Home   Overview   Screenshots  How to Buy   Help Page   Testimonials   Videos


Custom Financial Reporter

Overview

Introduction:

With the Custom Financial Reporter, you can quickly and easily produce presentation quality financial statements. The Reporter allows you to use Excel to create customized financial statement formats and then to merge QuickBooks data into those formats. The same financial statement formats (in an Excel workbook) can be used from month to month and for all of your clients or you can have different financial statement format workbooks for different clients.

We provide an Excel workbook with set of financial statement formats that you can modify or copy or you can create your own format workbooks. Other than the columns of data that are available, you have total control over the design of the financial statement formats. You can have as many heading and data rows as you need and you can use any of Excels fonts, type styles, number format, colors etc. 

The Reporter exports multiple trial balances from QuickBooks and puts the data into any Excel workbook that you choose. The only requirement is that the workbook has a worksheet named "Trial Balance" and a worksheet named "Variables" which the Reporter changes each time you export data from QuickBooks.. The other sheets in the workbook will contain your financial statement formats and you can have as many financial statement format sheets as you need to meet your reporting requirements. The provided workbook includes sheets on which we have designed formats  for Assets, Liabilities, Profit and Loss, Cash Flow, Cover Sheet and Accountants Report . This workbook can be copied or modified to meet your needs and includes the ability to print all financial statement pages with a single button click.

This program is similar to the QuickBooks Statement Writer (QSW)  but it works with Excel 2000 through 2013. It also works with Pro, Premier and Enterprise whereas QSW only works with the Accountants Editions. 

The data in the Trial Balance sheet is linked or mapped to the financial format sheets using the Excel SUMIF function which matches user definable "Row Names" in the financial statement format sheets with same name in the Trial Balance sheet. Data in the Trial Balance sheet automatically flows to your financial statement format sheets based on matching row names. To create a link between a financial statement format sheet and the Trial Balance sheet, you give a row in a financial statement sheet a "Row Name" and then in the Trial Balance sheet you assign the same "Row Name" to all accounts to be accumulated on that row. 

The Reporter saves the row names you have assigned to accounts and the next time you export data from a company, those previously assigned row names are automatically included on your Trial Balance sheet. There is also a report that shows new accounts which have not been assigned to a row name.

The Reporter exports multiple period Trial Balances and budget data from QuickBooks and places the data in columns in the Trial Balance sheet. You only need to enter one date and the Reporter exports sufficient data to produce the following statements.

Balance Sheets: Current year, prior year, last preceding year-end and prior month.

Profit and Loss: Current month (or quarter) this year and prior year and budget current and year to date.

Cash Flow: Current month (or quarter) and year to date this year. Year to date prior year. 

Budget: Current Month and Year to Date versus actuals. Due to a limit in Intuits Software Development Kit, budgets by class can't be exported. Budgets can be included only if they are set up without a class or if you enter the budget data in the Excel workbook (a once a year task) and link it to the actual data. 

Annual Budget: To export the annual budget, the computer system date must be set to a date in the next year before starting QuickBooks. Otherwise QuickBooks will only export the budget up to the computer system date and the annual budget column will be zero.

Cover Sheet with company name and reporting period.

Accountants report with company name and reporting period.

System Requirements:

1. Pro or higher versions of QuickBooks 2003 and later or Enterprise Solutions 3 and later.  (See the "How to Buy" page for more information.)

2. Microsoft Access 2000 - 2013 or the free Microsoft Access Runtime engine which can be downloaded from the "How to Buy" page.  

3. Microsoft Excel 2000 - 2013

4. Windows XP, 2000, Vista, Win 7, Win 8.

Contact:

If you have any questions or comments about this program, contact us at karl@q2q.us

Trademarks:

QuickBooks is a registered trademark and service mark of of Intuit, Inc. in the United States and other countries. The Custom Financial Reporter is designed for use with the Pro and higher versions of QuickBooks 2003 an later or Enterprise Solutions 3 and later. (See the "How to Buy" page for more information.)