Introduction:
With the Online 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 Online 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 click.
The data in the Trial Balance worksheet is linked or mapped to the financial format worksheets 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 from QuickBooks and places the data in columns in the Trial Balance sheet. It 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 period and year to date for this year and last year.
Cash Flow: Current month and year to date this year. Year to date prior year.
Cover Sheet with company name and reporting period.
Accountants report with company name and reporting period.
System Requirements:
1. QuickBooks Online.
2. Microsoft Access 2000-2013 (32 bit) or the free Microsoft Access Runtime engine which can be downloaded from the "How to Buy" page.
3. Windows 7, Windows 8.
4. Internet Connection.
5. Microsoft Excel 2000 to 2013.
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 Online Custom Financial Reporter is designed for use with only with QuickBooks Online.