Create EPIC pivot tables from Quickbooks Data

[@joelnelson1682]

Fantastic Hannah! Thank you for the date tip! I learned a ton from this one!

[@ClaraCFO]

Yay! It took me a while to realize that tidbit about the date, so I am happy it helped you too!

[@jgtv6269]

Love this series thank u for your time!! Much appreciated, hoping to learn more accounting related tasks.

[@ClaraCFO]

Great! Thanks for watching! We've got a lot more videos on accounting coming your way!

[@cheufdphil2487]

Thank you for your work! Your tutorial nicely complements my accounting undergraduate program! :)

[@ClaraCFO]

Great to hear!

[@user-mq6xn4sh2j]

Thank you for this Clara

[@jorgefraga5045]

Fantastic !.... Excel tricks ..... like I would like a video on Macros.

[@gellerpricebookvideos4159]

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]

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!

[@joeklemke3227]

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]

Awesome! I like mm/dd/yy format in general, but that's great to know for the future!

[@dirtydan6098]

Dang, rip. I was hoping to create a pivot table of the whole general ledger. Then you deleted the account name

[@AgustinDelfin-fb5fs]

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]

@@AgustinDelfin-fb5fs I have not :(