Create EPIC pivot tables from Quickbooks Data

  Рет қаралды 13,466

Clara CFO Group

Clara CFO Group

Күн бұрын

It's great to have your bookkeeping done every month, but what does your data tell you? Having reliable financial data is step 1, but understanding and analyzing data is step 2 if you want results from your accounting information! Pivot tables in Excel are one of the best ways to analyze your financial data to help you make practical decisions on a daily basis.
Take any table of data and turn it into USEFUL insights for EPIC results in your business. Yes Epic...are we being dramatic? No! Because we LOVE pivot tables! When you understand your data, you can make better decisions and meaningful take action that creates immediate financial results!
Need to get QBO set up for your business? Save money & grab a 12 month discount here: claracfo.com/QBO
Find more resources for your small business HERE: learn.claracfo.com/
--------------------------------------------------------------------------------------------------------------------------------------------
💲 Need an accounting system? We use Quickbooks Online with clients and recommend it as the best accounting system for small businesses. Sign up to get a discounted subscription for 12 months! claracfo.com/QBO
🙋‍♀‍Got Employees? Need a payroll company that knows what small businesses need? We recommend Gusto as the best small business payroll provider. Sign up for $100 gift card after you run your first payroll: claracfo.com/gusto
💸Pay vendors any way they want and get paid faster! Accept credit cards without paying merchant fees! Melio is a fantastic payments solution for every small business! claracfo.com/melio
(As an affiliate or referral partner for these companies, I may earn rewards from qualifying purchases)
Hannah Smolinski is a #CPA and the Founder of Clara CFO Group. Find out more about Clara CFO Group at claracfo.com/
Disclaimer: This video is intended for educational purposes and
should not be taken as legal or tax advice. You should consult with your financial professionals about your unique financial situation before acting on anything discussed in these videos. Clara CFO Group, LLC is providing educational content to help small business owners become more aware of certain issues and topics, but we cannot give blanket advice to a broad audience.

Пікірлер: 15
@joelnelson1682
@joelnelson1682 2 жыл бұрын
Fantastic Hannah! Thank you for the date tip! I learned a ton from this one!
@ClaraCFO
@ClaraCFO 2 жыл бұрын
Yay! It took me a while to realize that tidbit about the date, so I am happy it helped you too!
@user-mq6xn4sh2j
@user-mq6xn4sh2j 6 ай бұрын
Thank you for this Clara
@cheufdphil2487
@cheufdphil2487 Жыл бұрын
Thank you for your work! Your tutorial nicely complements my accounting undergraduate program! :)
@ClaraCFO
@ClaraCFO Жыл бұрын
Great to hear!
@jgtv6269
@jgtv6269 2 жыл бұрын
Love this series thank u for your time!! Much appreciated, hoping to learn more accounting related tasks.
@ClaraCFO
@ClaraCFO 2 жыл бұрын
Great! Thanks for watching! We've got a lot more videos on accounting coming your way!
@jorgefraga5045
@jorgefraga5045 Жыл бұрын
Fantastic !.... Excel tricks ..... like I would like a video on Macros.
@joeklemke3227
@joeklemke3227 2 жыл бұрын
Thanks for this. One note regarding dates: I think if you change QB to use the international, sortable date standard yyyy-MM-dd, then you won't have to monkey with it in Excel. The reason this is a standard is that if you use yyyy-MM-dd in folder names, filenames, spreadsheet data, etc then dates always sort correctly.
@ClaraCFO
@ClaraCFO 2 жыл бұрын
Awesome! I like mm/dd/yy format in general, but that's great to know for the future!
@gellerpricebookvideos4159
@gellerpricebookvideos4159 2 жыл бұрын
Thanks for this, i think you are an EXCELLENT teacher and trainer. I will try this from my QB desktop One question on excel. I have officer 365, when I double click or right click on an excel file in windows explorer, Excel opens but the file itself does not. i get a blank worksheet. i can drag the file to the blank sheet and it opens , but no other way. used to open at a click last year. Thanks ! David
@ClaraCFO
@ClaraCFO 2 жыл бұрын
Thanks! I'm glad this was helpful for you. Usually this happens to me before I click "enable edit" which shows up at the top of the page. See if that works!
@dirtydan6098
@dirtydan6098 Жыл бұрын
Dang, rip. I was hoping to create a pivot table of the whole general ledger. Then you deleted the account name
@AgustinDelfin-fb5fs
@AgustinDelfin-fb5fs 8 ай бұрын
Have you find a way to do that? I have been looking a way to obtain the data in a way that a pivot table can be created with accounts and sub accounts
@dirtydan6098
@dirtydan6098 8 ай бұрын
@@AgustinDelfin-fb5fs I have not :(
How to use Bank Rules in QBO | Reduce bookkeeping hours {Free Checklist}
19:36
What reports are most important? CFO shows top QBO reports
17:07
Clara CFO Group
Рет қаралды 9 М.
Inside Out Babies (Inside Out Animation)
00:21
FASH
Рет қаралды 22 МЛН
Пранк пошел не по плану…🥲
00:59
Саша Квашеная
Рет қаралды 6 МЛН
小宇宙竟然尿裤子!#小丑#家庭#搞笑
00:26
家庭搞笑日记
Рет қаралды 9 МЛН
Slow motion boy #shorts by Tsuriki Show
00:14
Tsuriki Show
Рет қаралды 9 МЛН
12 Pro PivotTable Formatting Tricks = No more UGLY PivotTables!
12:12
MyOnlineTrainingHub
Рет қаралды 330 М.
Answers to your Quickbooks questions with Hector Garcia CPA
59:46
Clara CFO Group
Рет қаралды 10 М.
Advanced Excel - Creating Pivot Tables in Excel
13:11
Technology for Teachers and Students
Рет қаралды 2,4 МЛН
How to avoid duplicate transactions in Quickbooks Online (QBO)
19:44
Clara CFO Group
Рет қаралды 47 М.
PivotTable Tricks That Will Change the Way You Excel (Free File)
17:47
MyOnlineTrainingHub
Рет қаралды 120 М.
TAGS in QuickBooks Online - Complete Tutorial
23:06
Hector Garcia CPA
Рет қаралды 36 М.
Inside Out Babies (Inside Out Animation)
00:21
FASH
Рет қаралды 22 МЛН