The reports your bookkeeper exports each month, how to set them up in QuickBooks, and what each dashboard uses.
| # | Report | Setting | Used by |
|---|---|---|---|
| 1 | Profit and Loss | Display columns by Months, full period | Almost every dashboard |
| 2 | Balance Sheet | Display columns by Months, ending on the last day of the period | Almost every dashboard |
| 3 | Statement of Cash Flows | Same period, by Months if QuickBooks offers it | Cash Flow & Receivables, Cash Reconciliation, Lender Snapshot |
| 4 | A/R Aging Summary | As of the last day of the period | Cash Flow & Receivables, Cash Reconciliation |
| 5 | A/P Aging Summary | As of the last day of the period | Cash Flow & Receivables, Cash Reconciliation |
| 6 | Expenses by Vendor Summary | Same period, Total column | Cost Center, Tax Preparation Readiness |
| 7 | Profit and Loss by Class (and/or by Location) | Same period, one total per class | Cost Center |
| 8 | Sales by Customer Summary | Same period, Total column | Revenue Analysis |
| 9 | Budget (optional) | Budgets vs. Actuals export, or two columns: Account, Budget | Budget vs Actual |
| Dashboard | Needs | Optional |
|---|---|---|
| Business (CFO) | ||
| CFO Financial Performance Report | Profit & Loss, Balance Sheet (total or by Months) | Cash Flow, client profile |
| Monthly Trend & Forecast | Profit & Loss by Months | Balance Sheet by Months (for the cash charts) |
| Capital & Investment Readiness | Profit & Loss, Balance Sheet | Monthly versions add the worst-stretch chart |
| Break-even & Pricing | Profit & Loss | By Months adds the month-by-month check |
| Cash Flow & Receivables | Statement of Cash Flows | P&L, Balance Sheet, A/R Aging, A/P Aging |
| Budget vs Actual | Profit & Loss | Budget file |
| Lender Snapshot | Profit & Loss, Balance Sheet | Statement of Cash Flows |
| 13-Week Cash Forecast | Profit & Loss, Balance Sheet | Monthly versions add seasonality |
| KPI Scorecard | Profit & Loss | Balance Sheet; monthly versions add trends |
| Tax Planning | Profit & Loss | Balance Sheet |
| Wealth & Planning | ||
| Goals & Risk Profile, Retirement, Allocation, Estate | No QuickBooks files. The client types in their own figures | Client profile |
| Net Worth, Owner Total Picture, Business Exit, Insurance Review | No QuickBooks files needed | Profit & Loss (fills in owner pay and business value) |
| CPA & Compliance | ||
| P&L Variance Review | Profit & Loss by Months | None |
| Revenue Analysis | Profit & Loss (by Months is best) | Sales by Customer Summary |
| Cost Center | P&L by Class or Location, or Expenses by Vendor Summary | The other one |
| Cash & Working Capital Reconciliation | Statement of Cash Flows and Balance Sheet | P&L, A/R Aging, A/P Aging |
| Monthly Close & Books Quality | Profit & Loss by Months and Balance Sheet by Months | None yet |
| Tax Preparation Readiness | Profit & Loss | Balance Sheet, Expenses by Vendor Summary |
| Income & Payroll Tax Calendar | Profit & Loss | Balance Sheet |
| What you see | What to do |
|---|---|
| It says only 1 column was found | The report was exported with "Total only". Export it again with Display columns by: Months. |
| A file was skipped | The page picks out the files it needs and lists the rest. If a needed file was skipped, check the report name at the top of the file. |
| "Files appear to come from different companies" | One file belongs to another client. Check the company name at the top of each file, or press Clear loaded files and start again. |
| "Does not match the business on your profile" | You may have picked another client’s folder. Confirm the business name on your profile. |
| A dashboard asks for files again | Files stay loaded while you stay in the same browser tab. Closing the tab, signing out, or pressing Clear loaded files removes them. They are never uploaded anywhere. |
| Excel did not load | Export the report as CSV instead. |