Automating an Excel-Based Financial Statement

by David Ringstrom,CPA
QuickBooks allows you a fair amount of control over financial statements – just about any user can easily customize the built-in reports. Users of Enterprise Solutions and Accountant versions can go farther and use the Financial Statement Designer to integrate QuickBooks and Excel. Yet, sometimes neither of these options is sufficient, so users dump data over to Excel to start building their own reports. This, in turn, often results in repetitive efforts and data integrity issues. As soon as you add or change a single transaction in QuickBooks, your Excel-based financial statement is out of date. However, there’s a way to have your cake and eat it too. In this article, I’ll demonstrate how to build a three-sheet Excel workbook from which you’ll be able to easily view and update a profit and loss report for any month of the year.
Continue reading on
About the author:

David H. Ringstrom, CPA, heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at or follow him on Twitter. David speaks at conferences about Microsoft Excel and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link.