Menu Reference · The menu bar

Reports menu

Every report on the Reports menu, submenu by submenu, with what it shows, the dates it asks for and where it is explained.

☰ Reports⌨ Alt+R
serobooks / reportsLive
Watch it in the appReports and drill-down The Report Centre, Profit & Loss with drill-down, the Balance Sheet and A/R Aging.

The Reports menu opens every report SeroBooks produces, laid out the way QuickBooks Desktop's Reports menu is: the Report Centre and your memorized, scheduled and commented reports at the top, then one submenu per report category, then the two one-transaction reports at the bottom. Every report on it is one SeroBooks produces; QuickBooks Desktop reports that SeroBooks does not produce are left off rather than shown as empty pages.

Opening the Reports menu

  • Click Reports on the menu bar, or rest the pointer on it.
  • Or press Alt+R.
  • Point at a submenu (for example Company & Financial) to open it, then click a report.

How a report opens from this menu

  • A report opens straight away in the same report viewer the Report Centre uses, with its dates, filters, drill-down, memorize, print and export. See Running a report.
  • It opens over the Home Page. When you press Esc or close it, you are back on the Home Page, not in the Report Centre.
  • The window is titled with the menu's name for the report, and the report's own heading uses the same QuickBooks names (Vendor, not Supplier). A few reports still carry a different heading in the viewer; the tables below say where.
  • Reports need permission for the Report Centre. If your role cannot open the Report Centre, the reports are left off the submenus; a submenu still appears when it holds a screen your role can open (for example Accountant & Taxes ▸ Trial Balance). If the report cannot be read, the viewer says This report is not available — the server may need updating, or your role cannot read it.
  • Entries in the tables below that say Opens the … screen (for example Trial Balance or Sales Reports) open that screen in its own window instead, with that screen's own permission.

The Dates or shortcut column says what the report asks for: From and to dates (a period), As of one date (balances on a day), or No dates (the position as it stands now). You can change the dates in the viewer.

The top of the menu

ItemWhat it doesRead more
Report CentreOpens the Report Centre: every report, by category, with a description of each.The Report Centre
Memorized ReportsOpens the list of reports you have memorized with their settings.Memorized Reports
Scheduled ReportsOpens the same list. A memorized report given a day to arrive on is a scheduled report; they are set and listed in the same place.Scheduled Reports
Commented ReportsOpens the Commented Reports page over the Home Page: reports you saved with comments.Comment on Report and Commented Reports
Company SnapshotOpens the Company Snapshot page over the Home Page. The same item is on the Company menu.Company Snapshot

A grey line follows these, then the report submenus.

Company & Financial

Profit and loss, income and expense, exchange gains and losses, balance sheet, cash flow and ratios. Grey lines separate the profit and loss reports; income and expense by customer and vendor; gains and losses; the balance sheet reports; the cash flow reports; and, under the grey Accounting screens heading, the three Accounting screens.

ItemWhat it showsDates or shortcutRead more
Profit & Loss StandardIncome less expenses for the period.From and to datesProfit & Loss Standard
Profit & Loss DetailEvery posting behind each income and expense account.From and to datesProfit & Loss Detail
Profit & Loss YTD ComparisonThe period beside the year so far.From and to datesProfit & Loss YTD Comparison
Profit & Loss Prev Year ComparisonThis period against the same period last year, with change.From and to datesProfit & Loss Prev Year Comparison
Profit & Loss by MonthOne column per month across the period.From and to datesProfit & Loss by Month
Profit & Loss by JobIncome and expense in a column per job.From and to datesProfit & Loss by Job
Profit & Loss by ClassIncome and expense in a column per class.From and to datesProfit & Loss by Class
Profit & Loss UnclassifiedIncome and expense posted with no class.From and to datesProfit & Loss Unclassified
Profit & Loss by LocationOne column per store or warehouse.From and to datesProfit & Loss by Location
Profit & Loss — % of IncomeEvery line as a share of sales.From and to datesProfit & Loss — % of Income
Income by Customer SummaryWhat each customer was worth this period.From and to datesIncome by Customer Summary
Income by Customer DetailEvery document behind each customer.From and to datesIncome by Customer Detail
Expenses by Vendor SummaryWhat was spent with each supplier.From and to datesExpenses by Vendor Summary
Expenses by Vendor DetailEvery bill and expense behind each supplier.From and to datesExpenses by Vendor Detail
Income & Expense GraphIncome, expense and net income month by month, drawn.From and to datesIncome & Expense Graph
Realized Gains & LossesExchange gains and losses on foreign documents settled in the period.From and to datesRealized Gains & Losses
Unrealized Gains & LossesOpen foreign invoices and bills marked to the rate on the date.As of one dateUnrealized Gains & Losses
Balance Sheet StandardWhat the business owns and owes on a given day.As of one dateBalance Sheet Standard
Balance Sheet DetailEvery posting behind each balance sheet account.As of one dateBalance Sheet Detail
Balance Sheet SummaryRolled up to account type.As of one dateBalance Sheet Summary
Balance Sheet Prev Year ComparisonToday against the same day last year.As of one dateBalance Sheet Prev Year Comparison
Balance Sheet by MonthMonth-end balances side by side.From and to datesBalance Sheet by Month
Balance Sheet by ClassEvery balance sheet account in a column per class.As of one dateBalance Sheet by Class
Net Worth GraphAssets, liabilities and net worth at each month end, drawn. A month opens the Balance Sheet as of its end.From and to datesNet Worth Graph
Statement of Cash FlowsOperating, investing and financing movement (indirect method).From and to datesStatement of Cash Flows
Statement of Cash Flows Prev Year ComparisonThe statement of cash flows beside the same period last year.From and to datesStatement of Cash Flows Prev Year Comparison
Cash Flow ForecastWeek by week: cash on hand, what is due in and out, and the projected balance.From and to dates, reaching into the futureCash Flow Forecast
Funds Flow StatementSources and applications of funds, and the change in working capital between two balance sheets.From and to datesFunds Flow Statement
Ratio AnalysisLiquidity, leverage, profitability and efficiency ratios, each with how it was worked out.From and to datesRatio Analysis
ACCOUNTING SCREENS (grey heading)The entries below it open the Accounting screens.
Profit & LossOpens the Accounting Profit & Loss screen: the same figures as a live workspace.Shortcut Ctrl+Shift+EProfit & Loss
Balance SheetOpens the Accounting Balance Sheet screen.—Balance Sheet
Cash FlowOpens the Accounting Statement of Cash Flows screen.—Statement of Cash Flows

Sales Tax

ItemWhat it showsDates or shortcutRead more
Tax Agency Report (GST/HST Return)Lines 101, 103, 105, 106, 108 and 109 — the return, filled in. The report's heading reads GST/HST Return.From and to datesTax Agency Report (GST/HST Return)
Tax Agency Detail ReportEvery document behind each line of the return. The report's heading reads GST/HST Return Detail.From and to datesTax Agency Detail Report
PST / QST ReturnThe provincial companion to the GST/HST return.From and to datesPST / QST Return
Unassigned Sales Tax Amounts Detail ReportSales carrying no tax code. Check these before filing. The report's heading reads Unassigned Sales Tax Amounts.From and to datesUnassigned Sales Tax Amounts Detail Report
Sales Tax Exception ReportWhere the tax charged does not match the rate the code says. The report's heading reads Sales Tax Exception.From and to datesSales Tax Exception Report
Tax Collected by Province and Tax TypeGST, HST, PST, QST and RST, per province the sale was supplied to.From and to datesTax Collected by Province and Tax Type
Sales Tax SummaryOpens the Tax report screen.—The Sales, Purchases, Inventory, Damaged and Tax report screens
View Prior Sales Tax Returns…Opens the Manage Sales Tax centre, where filed returns are listed.—Manage Sales Tax, Reverse a filed return

Customers & Receivables

ItemWhat it showsDates or shortcutRead more
A/R Aging SummaryWho owes what, and for how long.As of one dateA/R Aging Summary
A/R Aging DetailEvery open invoice with its terms and due date.As of one dateA/R Aging Detail
Customer Balance SummaryOne line per customer.As of one dateCustomer Balance Summary
Customer Balance DetailRunning balance, document by document.From and to datesCustomer Balance Detail
Open InvoicesEverything unpaid, oldest first.As of one dateOpen Invoices
Collections ReportOverdue only, with phone numbers. A call list.As of one dateCollections Report
Average Days to PayHow long each customer actually takes.From and to datesAverage Days to Pay
Invoices and Received PaymentsEach invoice with the payments set against it and what is still owed. The report's heading reads Invoices and Payments Received.From and to datesInvoices and Received Payments
Money to Collect by Due DateWhat customers owe, by when it is due: overdue, today, this week, this month, later.As of one dateMoney to Collect by Due Date
Transaction List by CustomerEverything that happened, grouped by customer.From and to datesTransaction List by Customer
Customer RankingBest, loyal, new, at risk and gone quiet — scored on recency, frequency and spend.From and to datesCustomer Ranking
Inactive CustomersCustomers who have not bought in 90 days — the ones worth a call.As of one dateInactive Customers

Sales

Grey lines divide the submenu into three groups: Daily Sales Summary to Estimates by Customer; Sales by Month to Sales Returns by Item; and the two sales screens.

ItemWhat it showsDates or shortcutRead more
Daily Sales SummaryThe daily takings, excluding tax. The report's heading reads Sales by Day.From and to datesDaily Sales Summary
Daily Sales DetailEvery item sold, day by day.From and to datesDaily Sales Detail
Sales by Customer SummaryRanked by what they bought.From and to datesSales by Customer Summary
Sales by Customer DetailEvery invoice, grouped by customer.From and to datesSales by Customer Detail
Sales by Item SummaryQuantity, revenue, cost and gross margin per item (item-wise profitability).From and to datesSales by Item Summary
Sales by Item DetailEvery line sold, grouped by item.From and to datesSales by Item Detail
Sales by Rep SummaryPer commission agent.From and to datesSales by Rep Summary
Sales by Rep DetailEvery invoice, grouped by rep.From and to datesSales by Rep Detail
Sales by Ship To AddressSales grouped by where they were shipped.From and to datesSales by Ship To Address
Sales GraphSales before tax by month, drawn.From and to datesSales Graph
Pending SalesInvoices marked pending: written, not yet posted.No dates: as it stands nowPending Sales
Open Sales Orders by CustomerPromised and not yet invoiced.No dates: as it stands nowOpen Sales Orders by Customer
Open Sales Orders by ItemWhat the open orders need, against stock on hand.No dates: as it stands nowOpen Sales Orders by Item
Estimates by CustomerEvery quotation raised in the period. The report's heading reads Quotations by Customer.From and to datesEstimates by Customer
Sales by MonthInvoices, units and sales month by month.From and to datesSales by Month
Sales by Ship To ProvinceWhere each sale was supplied — the same rule the tax used. The report's heading reads Sales by Province / State.From and to datesSales by Ship To Province
Sales by Category SummaryRevenue, cost and margin per product category.From and to datesSales by Category Summary
Sales by LocationPer store or warehouse.From and to datesSales by Location
Gross Profit by InvoiceWhat each invoice actually earned after the cost of the goods (bill-wise profitability).From and to datesGross Profit by Invoice
Discounts GivenEvery discounted invoice, line and bill discounts apart.From and to datesDiscounts Given
Sales Returns by CustomerCredit notes issued, per customer.From and to datesSales Returns by Customer
Sales Returns by ItemWhat came back, and the return rate per item.From and to datesSales Returns by Item
Sales ReportsOpens the Sales report screen.—Report screens
Consolidated DayOpens the Consolidated Day screen, for businesses whose locations keep different clocks.—Consolidated Day

Jobs, Time & Mileage

ItemWhat it showsDates or shortcutRead more
Job Profitability SummaryWhat each job cost, what it earned, and the difference.From and to datesJob Profitability Summary
Job Profitability DetailA job's costs and revenue, account by account.From and to datesJob Profitability Detail
Job Estimates vs. Actuals SummaryEach job's budget and estimates against what actually happened.From and to datesJob Estimates vs. Actuals Summary
Unbilled Costs by JobTime and costs recorded for a customer and not yet invoiced.As of one dateUnbilled Costs by Job
Time by Job SummaryHours worked on each job, by person, billed and unbilled.From and to datesTime by Job Summary
Time by NameHours each person worked, by job.From and to datesTime by Name
Mileage by Vehicle SummaryDistance driven in each vehicle, and its mileage expense at the rate in effect.From and to datesMileage by Vehicle Summary
Mileage by Vehicle DetailEvery trip, under its vehicle.From and to datesMileage by Vehicle Detail
Mileage by Job SummaryBillable distance for each customer or job, and what it bills.From and to datesMileage by Job Summary
Mileage by Job DetailEvery billable trip, under its customer or job.From and to datesMileage by Job Detail

Vendors & Payables

ItemWhat it showsDates or shortcutRead more
A/P Aging SummaryWhat is owed, and for how long.As of one dateA/P Aging Summary
A/P Aging DetailEvery unpaid bill with its due date.As of one dateA/P Aging Detail
Vendor Balance SummaryOne line per supplier.As of one dateVendor Balance Summary
Vendor Balance DetailRunning balance, document by document.From and to datesVendor Balance Detail
Unpaid Bills DetailGrouped by supplier, oldest first.As of one dateUnpaid Bills Detail
Bills and Applied PaymentsEach bill with the payments and credits applied to it.From and to datesBills and Applied Payments
Bills to Pay by Due DateWhat you owe suppliers, by when it is due: overdue, today, this week, this month, later.As of one dateBills to Pay by Due Date
Transaction List by VendorEverything that happened, grouped by supplier.From and to datesTransaction List by Vendor
Sales Tax LiabilityTotal, non-taxable and taxable sales and tax collected, by tax.From and to datesSales Tax Liability

Purchases

Grey lines separate the purchase and open purchase order reports; the purchase analysis reports (from Purchases by Month); and the Purchase Reports screen.

ItemWhat it showsDates or shortcutRead more
Purchases by Vendor SummaryWhat was bought from each supplier.From and to datesPurchases by Vendor Summary
Purchases by Vendor DetailEvery bill and return, under its supplier.From and to datesPurchases by Vendor Detail
Purchases by Item SummaryWhat was bought, and at what cost.From and to datesPurchases by Item Summary
Purchases by Item DetailEvery line bought, under its item.From and to datesPurchases by Item Detail
Open Purchase OrdersOrdered and not yet received, with what is late.No dates: as it stands nowOpen Purchase Orders
Open Purchase Orders DetailEach open purchase order with the lines still to come.No dates: as it stands nowOpen Purchase Orders Detail
Open Purchase Orders by JobOpen purchase orders grouped by the job they are for.No dates: as it stands nowOpen Purchase Orders by Job
Open Purchase Orders by ItemWhat is on order, per item, beside what is on the shelf.No dates: as it stands nowOpen Purchase Orders by Item
Purchases by MonthBuying month by month.From and to datesPurchases by Month
Purchases by Vendor by MonthOne column per month, per supplier.From and to datesPurchases by Vendor by Month
Goods Received DetailEvery receipt, in the order it arrived.From and to datesGoods Received Detail
Purchase Returns by VendorGoods sent back — debit notes.From and to datesPurchase Returns by Vendor
Purchase Price by VendorThe same item from different suppliers — who is cheaper.From and to datesPurchase Price by Vendor
Purchase Cost ChangesItems that got dearer or cheaper to buy, and what it cost you.From and to datesPurchase Cost Changes
Purchase ReportsOpens the Purchases report screen.—Report screens

Inventory

Grey lines separate the valuation and stock status reports; the stock movement reports (from Stock by Location); and the inventory screens.

ItemWhat it showsDates or shortcutRead more
Inventory Valuation SummaryOn hand, at cost and at retail, per item.No dates: as it stands nowInventory Valuation Summary
Inventory Valuation DetailWhat came in and what went out, per item.From and to datesInventory Valuation Detail
Inventory Stock Status by ItemOn hand against reorder point, with shortfall. The report's heading reads Stock Status by Item.No dates: as it stands nowInventory Stock Status by Item
Inventory Stock Status by VendorItems by the vendor they were last bought from: on hand, reorder point, on order.No dates: as it stands nowInventory Stock Status by Vendor
Physical Inventory WorksheetA count sheet to print, with a blank column.No dates: as it stands nowPhysical Inventory Worksheet
Pending BuildsBuilds saved but not yet finished.No dates: as it stands nowPending Builds
Stock by LocationWhere the stock physically is.No dates: as it stands nowStock by Location
Stock Movement SummaryOpening, in, out and closing per item — the stock reconciliation.From and to datesStock Movement Summary
Stock Adjustment DetailEverything written off or corrected, and why.From and to datesStock Adjustment Detail
Slow-moving StockNothing sold in the period. Money sitting on a shelf.From and to datesSlow-moving Stock
Inventory AgingHow long stock has been sitting, by age bracket.No dates: as it stands nowInventory Aging
Negative StockItems the system thinks there are fewer than none of.No dates: as it stands nowNegative Stock
Inventory ReportsOpens the Inventory report screen.—Report screens
Damaged GoodsOpens the Damaged report screen.—Report screens
Serial Number LookupOpens Serial Number Lookup: find a serial number and see where it came from and went.—Serial Number Lookup
Lot ExpirationOpens the lot and expiry screen.—Lot numbers and expiry

Employees & Payroll

ItemWhat it showsDates or shortcutRead more
Payroll Summary by EmployeeThe same pays rolled up per person. What a T4 is reconciled to.From and to datesPayroll Summary by Employee
Payroll RegisterEvery pay line in the period — gross, each deduction, net and employer cost.From and to datesPayroll Register
Payroll Remittance HistoryWhat was owed to the authority period by period, what was paid, and what is overdue.From and to datesPayroll Remittance History
Payroll Item ListEvery payroll item: statutory, additions and deductions.No dates: as it stands nowPayroll Item List

Banking

The banking reports, the reconciliation history, and (after a grey line) the three registers. The registers are the lists of cheques, deposits and card charges written so far; Banking ▸ Write Cheques, Enter Credit Card Charges and Make Deposits open the forms themselves (see Banking menu).

ItemWhat it showsDates or shortcutRead more
Deposit DetailEvery payment received, by day.From and to datesDeposit Detail
Cheque DetailEvery cheque written or received.From and to datesCheque Detail
Missing ChequesGaps in the numbers of the cheques you wrote. The report's heading reads Missing Cheque.From and to datesMissing Cheques
Reconciliation SummaryEvery bank and card reconciliation, with its difference.No dates: as it stands nowReconciliation Summary
Previous ReconciliationAsks which account first (see below), then lists that account's reconciliations. Opens over the Home Page.—Previous Reconciliation
Reconciliation DiscrepancyAsks which account first (see below), then opens what has changed since that account's last reconciliation. Opens over the Home Page.—Reconciliation Discrepancy
Cheque RegisterOpens the Cheque register screen: every cheque written, newest first, with the button that opens a blank cheque. A row opens its cheque to change it.Shortcut Ctrl+WCheque, Deposit and Credit Card registers
Deposit RegisterOpens the Deposit register screen: every deposit made.—Cheque, Deposit and Credit Card registers
Credit Card Charges RegisterOpens the Credit Card Charges register screen: every credit card charge and credit, newest first, with the button that opens a blank charge.—Cheque, Deposit and Credit Card registers

Previous Reconciliation and Reconciliation Discrepancy: choosing the account

Both items ask which account before anything else, as QuickBooks Desktop does:

  1. The page opens over the Home Page and lists your bank and credit card accounts under Specify the account. Each shows whether it is a bank or credit card account, its masked number and when it was last reconciled.
  2. Click the account.
  3. Previous Reconciliation then lists every reconciliation of that account: Statement date, Account, Statement balance, Cleared balance and Status (signed off or undone), with Report to open the reconciliation report and Undo to take a reconciliation back. Undo asks for a reason, which stays on the record, and needs the permission to undo a reconciliation. Back closes the page.
  4. Reconciliation Discrepancy goes straight to the discrepancy report for the account's last reconciliation: what has changed since it was signed off. If the account has never been reconciled, SeroBooks says …has not been reconciled yet, so nothing can have changed since.

If no bank or credit card accounts are set up, the page says so.

Accountant & Taxes

ItemWhat it showsDates or shortcutRead more
Trial BalanceOpens the Trial Balance screen: debits and credits, account by account.Shortcut Ctrl+Shift+TTrial Balance
Adjusted Trial BalanceBalances before and after the period's adjusting entries.From and to datesAdjusted Trial Balance
General LedgerOpens the General Ledger screen: every entry, account by account.Shortcut Ctrl+GGeneral Ledger
JournalOpens the Journal screen: every journal entry, with its lines.Shortcut Ctrl+Shift+GMake General Journal Entries
Transaction Detail by AccountPostings grouped under the account they hit.From and to datesTransaction Detail by Account
Transaction List by DateEvery document the business raised, in order.From and to datesTransaction List by Date
Audit TrailOpens the Audit Trail screen.—Audit Trail
Audit Trail ReportEvery transaction added, changed, voided or deleted in the period, who did it and from where. The report's heading reads Audit Trail.From and to datesAudit Trail Report
Closing Date Exception ReportTransactions dated on or before the closing date that were entered, changed or deleted after the closing date was set.No dates: as it stands nowClosing Date Exception Report
Voided/Deleted Transactions SummaryEvery transaction voided or deleted, when and by whom.From and to datesVoided/Deleted Transactions Summary
Voided/Deleted Transactions DetailEach voided or deleted transaction as it was and as it is now.From and to datesVoided/Deleted Transactions Detail
Possible DuplicatesSame customer or supplier, same amount, a few days apart.From and to datesPossible Duplicates
Invoice Number Gaps and RepeatsMissing invoice numbers, and numbers used twice.From and to datesInvoice Number Gaps and Repeats

Budgets & Forecasts

ItemWhat it showsDates or shortcutRead more
Budget OverviewThe profit and loss budget for the fiscal year, month by month.As of one dateBudget Overview
Budget vs. ActualWhat each income and expense account did against its budget.From and to datesBudget vs. Actual
Profit & Loss Budget PerformanceThis month and year to date against budget, beside the annual budget.As of one dateProfit & Loss Budget Performance
Budget vs. Actual by ClassEach class's own budget beside what was posted to it, fiscal year to date.As of one dateBudget vs. Actual by Class
Budget vs. Actual by JobEach job's own budget beside what was posted to it, fiscal year to date.As of one dateBudget vs. Actual by Job
Balance Sheet Budget OverviewBudgeted balance of each asset, liability and equity account at each month end.As of one dateBalance Sheet Budget Overview

List

ItemWhat it showsDates or shortcutRead more
Account ListingThe chart of accounts, with balances.No dates: as it stands nowAccount Listing
Item ListingEvery product with cost, price and stock.No dates: as it stands nowItem Listing
Item Price ListSelling prices, ready to hand out.No dates: as it stands nowItem Price List
Customer Contact ListNames, addresses, balances.No dates: as it stands nowCustomer Contact List
Customer Phone ListJust the numbers.No dates: as it stands nowCustomer Phone List
Vendor Contact ListNames, addresses, balances.No dates: as it stands nowVendor Contact List
Vendor Phone ListJust the numbers.No dates: as it stands nowVendor Phone List
Employee Contact ListStaff and their details.No dates: as it stands nowEmployee Contact List

Snapshots

ItemWhat it showsDates or shortcutRead more
Sales AnalyticsOpens the Sales Analytics snapshot.—Snapshots
Inventory HealthOpens the Inventory Health snapshot.—Snapshots
Cash FlowOpens the Cash Flow snapshot: the day-to-day cash view (not the accounting statement).—Snapshots

Transaction History…

Asks for a document first. A small Transaction History window opens with one box, Document number (invoice, bill, cheque…). Type the number as it is printed on the document and press Enter or OK (Cancel closes it). The Transaction History report then opens over the Home Page, titled with the number: the document and every payment, credit and return linked to it.

Read more: Transaction History and Transaction Journal

Transaction Journal…

Works the same way: type the document number, then the Transaction Journal report opens over the Home Page with the debits and credits the document and its payments posted.

Read more: Transaction History and Transaction Journal

Common problems

  • The reports are missing from the submenus; only a few screens show. Your role cannot open the Report Centre, which the reports on the submenus use for their permission.
  • A report opens with "This report is not available". Your role cannot read that report, or the report is newer than the server your company is on. Ask your administrator.
  • Esc takes me to the Home Page instead of the Report Centre. Reports opened from this menu open over the Home Page on purpose. Open the Report Centre first (Reports ▸ Report Centre) if you want to go back to it.
  • Transaction History finds nothing. Type the document number exactly as printed. To search by customer or vendor name, use Edit ▸ Transaction History… instead.
  • Previous Reconciliation opens on a list of accounts. That is the first step: choose the account.