Excel Integration with QuickBooks 2012


You may want to use Excel for your more heavy duty data analysis. In QuickBooks you can export your reports to Excel. In QuickBooks 2012, you can now update a saved Excel spreadsheet instead of exporting the reports each time you want to analyze data. QuickBooks is integrated into Excel to update your numbers and figures without removing your heading changes and formulas.

Within Excel, you can change the imported data to change fonts, add formulas, change titles, resize and insert columns, rows, and text.  


Gita Faust

About the Author

Gita Faust has over 30 years of accounting experience in the real estate and property management industry, Gita Faust is more than just a real estate investor; she is also popular for her work as an accountant, consultant, mentor, speaker, QuickBooks Top ProAdvisor, QuickBooks Solution Provider, member of Intuit’s Trainer/Writer Network, and, of course, author. Gita is well-known for her exemplary leadership and advisory skills. In fact, she even helped pioneer the adaptation of QuickBooks to suit the needs of professionals in real estate and property management. To share her knowledge she has written a series of courses titled Simplified Accounting Solution, which provides step-by-step guidance for those working with QuickBooks.

Leave A Comment

Leave a Reply

Your email address will not be published. Required fields are marked *