SuperReports

MORE THAN STANDARD REPORTS

Six Super Summary templates.

Choose these directly in the Report box. Each adds a review layout built from QuickBooks' report results, with the report controls it supports.

TEMPLATE 01

Split: P&L/BS

Review profit and financial position together. Put the P&L and Balance Sheet in either order, or pair either report with a Drilldown pane that fills as you click amounts. Resize the panes and export them separately.

View report screenshot ↗Watch the narrated workflow ↓

TEMPLATE 02

P&L Cash vs. Accrual

See both accounting bases and their difference in one report. Choose Cash/Accrual/Diff, Accrual/Cash/Diff, a signed cash-to-accrual bridge, or Debit/Credit adjustments. Trace a supported difference to the transactions behind it.

View report screenshot ↗Watch the narrated workflow ↓

TEMPLATE 03

Balance Sheet Cash vs. Accrual

Compare cash and accrual balances as of the same date, with the same four comparison layouts. Supported difference drills explain the change by account, including specialized receivable and payable routes.

View report screenshot ↗

WATCH THE WORKFLOW · 31 seconds

Open full-size video ↗Read transcript

TEMPLATE 04

Split: P&L/BS Cash vs. Accrual

Keep both cash-versus-accrual reports side by side. Review income and balance differences together, reverse their order, or use a Drilldown pane for the supporting detail.

View report screenshot ↗

WATCH THE WORKFLOW · 32 seconds

Open full-size video ↗Read transcript

TEMPLATE 05

Trial Balance Cash vs. Accrual

Compare both bases across the Trial Balance. In addition to the four comparison layouts, choose Cash/Adjustment/Accrual (Dr/Cr): six columns for a complete conversion worksheet, or three signed net columns with Single Column Debit-Credit. Supported adjustment drills check the supporting total.

View report screenshot ↗

WATCH THE WORKFLOW · 35 seconds

Open full-size video ↗Read transcript

TEMPLATE 06

Trial Balance Period Difference

Show Starting, Period and Ending balances for a bounded date range on cash or accrual basis. Period is Ending minus Starting. View six Debit/Credit columns or three signed net columns, then drill into a supported Period amount to trace the movement.

View report screenshot ↗

WATCH THE WORKFLOW · 34 seconds

Open full-size video ↗Read transcript

THE COMPLETE REPORT MENU

93 report choices. One workspace.

87 QuickBooks report choices plus the six Super Summary templates above. Expand a category to see every report. Availability depends on your company's QuickBooks plan and enabled features; filters, columns, comparisons and review tools vary by report.

Payroll and reconciliation reports are not part of this menu. Saved Views preserve your setup in this browser for the current company.

• Find a report fast: Type a few letters in the Report box to open any of 93 report choices (87 QuickBooks reports plus six Super Summary templates). These include Profit and Loss, Balance Sheet, Statement of Cash Flows, Trial Balance and Adjusted Trial Balance, plus aging, budget, sales, expense, 1099, inventory and project reports, the General Ledger and other detail reports, transaction lists and lists.

• Tune aging buckets: On A/R and A/P Aging, choose report-date or current aging, 1–365 days per period, and 2–12 periods. Compare supported aging periods in the same workspace.

• Review budgets and project progress: Select a company budget for Budget Overview or Budget vs. Actuals. Estimates & Progress Invoicing by Project brings together original estimated income, accepted change orders, estimated income, total invoiced, progress percentage and total paid, with links to estimates. Income by Customer can include lines with no customer.

• Pick and step through periods: Choose a date range from QuickBooks' own presets, fiscal-year ones included, or set custom dates. Click « or », or press Ctrl/Cmd + ← / →, to move to the previous or next month, quarter or year, or to a custom range of the same length. The report re-runs right away.

• Spread it out: Split the P&L, the Balance Sheet and other summaries into columns by days, weeks, months, quarters or years. You can also split them by class, location, Customer:Project, vendor, employee or product/service, and the P&L by tag group too.

• Compare periods: Add the previous year, the previous period, year-to-date or a custom period, up to three at once, each with its own $ change and % change. This also works on the Trial Balance, A/R and A/P aging, customer and vendor balances, and budget reports.

• Filter the report itself: Filter the P&L, the Balance Sheet and other summaries by the fields each one supports, such as customer, vendor, product/service, class, location, employee, account or account type. Transaction Detail by Account, the General Ledger, P&L Detail and Balance Sheet Detail offer QuickBooks' full list of filter fields: up to 5 filters, each with up to 5 conditions joined by "and" or "or".

• Group and total: Group Transaction Detail by Account, Transaction List by Date, Sales by Customer Detail and drill-downs two levels deep, for example by class and then by customer. Some reports can also be grouped by your transaction custom fields. You can add Average and Percentage rows under each group total.

• Drill into the numbers: Click an amount on a summary report to see the transactions behind it. The detail opens in place with a Back button, in a new tab, in a Drilldown pane beside the P&L or Balance Sheet, or on QuickBooks' own report page. You can change the drill-down's dates or basis, regroup it, and open a transaction from its line. P&L and Balance Sheet drill-downs also show Class, Location, Customer and Project columns.

• Work side by side: Show the Profit and Loss and Balance Sheet together in Split view, in either order. Or pair either one with a Drilldown pane that fills in as you click amounts.

• See Cash vs. Accrual: Run the P&L, Balance Sheet, Trial Balance or paired P&L/Balance Sheet on cash and accrual basis at once, with the difference. There are four layouts: Cash/Accrual, Accrual/Cash, Cash-to-Accrual, and Cash-to-Accrual as Debit and Credit. Click a cash or accrual amount to drill on that basis.

• Explain the difference: Click a supported Difference or adjustment amount on P&L, Balance Sheet or Trial Balance Cash vs. Accrual to see its supporting transactions. The drill groups contributions and shows whether they tie to the amount clicked; it identifies a gap when they do not. Routes vary by account type, including open-item explanations for receivables and payables.

• Build a cash-to-accrual worksheet: Trial Balance Cash vs. Accrual adds a fifth layout: Cash/Adjustment/Accrual, each with Debit and Credit columns. Turn on Single Column Debit-Credit to show each pair as one signed net column.

• Trace period movement: Trial Balance Period Difference lines up Starting, Period and Ending balances. Period is Ending minus Starting, with Debit/Credit pairs or three signed net columns. Click a supported Period amount to trace the movement to transactions and check the total.

• Pivot a Custom Summary: Choose rows by Customer:Project, vendor, employee, product/service, class, location, distribution account type or time period, then choose a different supported column dimension. Apply the supported report filters and cash or accrual basis. Available comparisons depend on the layout.

• Focus on changed accounts: Only Show Differences groups unchanged accounts into expandable rows while preserving their amounts and totals. Use it on cash-versus-accrual and period-difference reports.

• See account activity dates: Show Last Transaction Date on supported Balance Sheet and Trial Balance reports, beside the account name or in its own column. Its link opens the account register or QuickReport as appropriate.

• Check reconciliations: On the Balance Sheet and Trial Balance, show each reconciled account's last statement date after its name. The date is green when it reaches the report date and red when it is behind. You can also show how many of the account's transactions up to that date are still unreconciled, and click that count to open them in Super Register.

• Right-click for more: Right-click an account on the P&L, Balance Sheet or Trial Balance to open it in QuickBooks' register, Super Register, Reconcile, Reclassify or Bank Feed, where those apply. From the same menu you can see Account Info, summarize the account by name or transaction type, edit the account, or post a Quick Adjustment. Right-click any cell to copy it as shown, as a plain number or as a whole row. Right-click a transaction line to preview it.

• Highlight what matters: This works on Transaction Detail by Account, the General Ledger, P&L Detail, Balance Sheet Detail, and P&L and Balance Sheet drill-downs. Color whole lines that meet all your conditions (yellow by default). Color single cells that meet any one condition, such as "Amount is greater than 1,000", each condition in its own color.

• Explain the numbers: Turn on Comments and click an account or amount on the P&L, Balance Sheet, Trial Balance or Cash vs. Accrual reports to add a numbered footnote. You can reorder the footnotes or sort them in report order. You can also add a free-text note under any report.

• Save your setup: Save the report as a named Saved View: its dates, columns, comparisons, filters, settings, collapsed rows, column order, sort, highlights, notes and comments. Reopen it in one click, or bookmark the page link, which rebuilds the report.

• Export cleanly: Export to Excel, CSV, or Print or save as PDF. Excel files hold real numbers under a header with the company, title and period. They keep bold totals, your highlight colors and notes, and your comments as Excel cell notes. A Split view exports each pane to its own sheet, file or page.

• Fix as you review: Turn on Batch Edit on the General Ledger, Transaction Detail by Account, the Journal, P&L or Balance Sheet Detail, a sales or purchase detail report, or a drill-down. Tick the lines to change and edit them in the Transaction Browser's batch edit window. The report re-runs afterward to show the change.

• Make it read your way: On detail reports and lists, you can:

  • choose, drag and resize columns;
  • add more columns from QuickBooks' own column list on the main detail reports;
  • sort by any column or fit columns automatically.

  On reports that support them, hide account numbers or $0 lines, show every account, or turn on Debit/Credit, % of row, % of column or % of income. Use Filters to hide account types, single accounts or columns without re-running the report.

• Style it: Set the number of decimals, how negative numbers look (red included), divide by 1,000, show the currency symbol on totals, and show empty cells as a dash. Pick QuickBooks' report borders, row density and banded-row colors. Collapse or expand the report one level at a time, with an indicator showing which levels are open.

• Drill-downs that check themselves: A drill-down shows a check mark when its transactions add up to the amount you clicked. When they don't, it shows the gap and, where it can tell, the reason.
• Cash vs. Accrual explained: Both bases and the difference appear on one screen, with supported P&L, Balance Sheet and Trial Balance differences traced to their supporting transactions. In QuickBooks itself you would run the report twice and compare the two by hand.
• Worksheets without rebuilding them in Excel: Cash/Adjustment/Accrual and Starting/Period/Ending Trial Balance layouts make basis conversion and period movement visible together.
• Custom Summary is available now: Build a row-and-column summary in SuperReports; the separate SuperCustomReports tool is coming soon.
• More ways to compare: Compare up to three periods at once. This includes reports where QuickBooks can't compare periods itself, such as the Trial Balance, aging and budget reports; SuperReports runs each period and lines the results up.
• Keep your place: Split view and the Drilldown pane keep a report and its detail on one screen, and Back returns you to the report you came from.
• Review tools on the report: Reconciled dates, unreconciled counts, highlights, footnote comments and notes appear right on the report. Highlights, comments and notes carry over into Excel and print or PDF.
• Set it up once: Saved Views and bookmarkable links rebuild the whole layout. A view saved on a relative period like "Last month" opens on the new last month.

• Month-end close: Open Split: P&L/BS with reconciled dates and unreconciled counts turned on. Click a count to open those transactions in Super Register, then press » to move on to the next month.
• Cash-basis tax prep: Run P&L Cash vs. Accrual and click the Net Income difference. You get the transactions that explain it, such as invoices and bills not yet paid, grouped and totaled.
• Client review package: Compare to the previous year with $ and % change, and add footnote comments on the accounts that moved. Save it as a view and export it to Excel or PDF.
• Basis conversion workpaper: Open Trial Balance Cash vs. Accrual and choose Cash/Adjustment/Accrual (Dr/Cr). Review the adjustment columns, trace a supported adjustment and export the worksheet.
• Balance movement review: Open Trial Balance Period Difference for the month. Compare the starting and ending balances and click Period to investigate the change.
• Class or location analysis: Use Custom Summary with class rows and month columns, or customer rows and location columns, then save the setup as a view.
• Cleanup: Filter the General Ledger to one class and highlight lines over a set amount. Then use Batch Edit to fix the miscoded lines without leaving the report.

• SuperReports is part of SuperTools, which is in Beta.
• Saved Views and report notes are stored in this browser, separately for each company. Comments and highlights last until you refresh the page, unless you save them in a view.
• It works with other SuperTools. Batch Edit needs the Transaction Browser turned on, and unreconciled counts and "Open in Super Register" open Super Register.
• Limits:
  • Difference and Period drill routes depend on the account and amount clicked. The drill reports whether the supporting lines tie; a mismatch is shown rather than treated as a successful explanation.
  • Trial Balance Period Difference needs a bounded period with a start and end; All Dates and open-ended Since ranges cannot establish its starting balance.
  • Difference and Period drill results cannot be saved as Saved Views; open them in a new tab for a link, or save the parent report setup instead.
  • Report availability and data depend on the company's QuickBooks subscription and enabled features. Custom Summary column and comparison options vary with the selected row/column layout.
  • Cash vs. Accrual reports have no Compare to and no column breakdowns.
  • Quick Adjustment is built for companies that use US dollars and is not offered on Cash vs. Accrual.
  • Payroll and reconciliation reports are not included.

SuperTools sidebar → SuperReports

Install the SuperTools extension, then open the SuperTools S menu in QuickBooks Online, choose Home, and enable the tool there.