Custom Financial Reporter
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 Intuit's Intuit Statement Writer (ISW) introduced with QuickBooks 2009 but it cost less, doesn't require the latest version of Excel and it works with Pro, Premier and Enterprise whereas ISW only works with the Accountants Editions. It's also similar to Intuit's Financial Statement Designer (FSD) which was used for QuickBooks 2008 and prior. The FSD was free with the Accountants Edition of QuickBooks but FSD can't create budget comparison reports but this Custom Financial Reporter can.
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.
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 - 2010 or the Microsoft Access 2000 Runtime engine which can be downloaded from the "How to Buy" page at no cost.
3. Microsoft Excel 2000 - 2010
4. Windows XP, 2000, Vista, Win 7.
If you have any questions or comments about this program, contact us at email@example.com
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.)
How to Buy Help
Copyright 2002-2013 , by Karl Irvin