How to Use Reports

The Reports page gives you access to over 40 financial reports across every module in your client's books. You can run standard reports, build your own custom reports, and assemble multi-section management report packs for client deliverables.

This guide walks through every section of the page, step by step, in the order you see on screen.

---

Getting Here

1. Open the main sidebar and select a Bookkeeping Client.
2. In the client sidebar, click Reports (under the Operations section).

The page opens to the reports dashboard with a search bar, three tabs, and a list of report groups you can expand and collapse.

---

The Page at a Glance

Page Title and Search

At the top of the page you see the heading Reports. Below it is a search bar labelled Find report by name. Type any part of a report name here and the list below filters instantly to show only matching reports.

The Three Tabs

Below the search bar, three tabs let you switch between different ways of working with reports:

---

Standard Reports

The Standard reports tab is where you find all the built-in financial reports. Reports are grouped into expandable sections by category.

Expanding and Collapsing Sections

Each section has a title bar with a chevron icon on the left. Click the title bar to expand or collapse the section. All sections start expanded when you first open the page.

If a section is locked because your plan does not include the required module, you see a lock icon and an Upgrade Plan badge on the right side of the section header. Reports inside a locked section show a lock icon and an Upgrade badge.

Favorites

When you click the star icon next to a report name, the report is added to your Favorites section at the very top of the page. The star fills green when a report is favorited. Click the star again to remove it from favorites.

The Favorites section only appears when you have at least one favorited report. It works like the other collapsible sections — click the header to show or hide your favorite reports.

Reports that are locked by feature entitlement do not appear in Favorites, even if you previously starred them.

All Report Groups

Below Favorites, the following report groups are available. Each group contains one or more reports you can run.

Business overview

Core financial statements for the business:

Who owes you

Accounts receivable reports (requires the Accounts Receivable module):

What you owe

Accounts payable reports (requires the Accounts Payable module):

Sales tax

Tax reports for GST/HST filing:

For my accountant

Reports commonly needed for year-end and review engagements:

Time

Time tracking reports (requires the Time Tracking module):

Class & Location

Reports segmented by tracking class or location (requires the Classes & Locations module):

Expense Claims

Expense reimbursement reports (requires the Expense Claims module):

Payroll

Payroll reports (requires the Payroll module). These reports open in the Payroll module's dedicated reporting area:

Six additional advanced payroll reports are also available under this section: Employee Payment History, Source Deductions Report, Labour Cost Analysis, Accrual Balance Report, Payroll Variance Report, and Payroll Period Summary, plus Time Sheet Summary.

Inventory

Inventory reports (requires the Inventory module):

Fixed Assets

Fixed asset reports (requires the Fixed Assets module):

Revenue Recognition

Revenue recognition reports (requires the Revenue Recognition module):

Cheque Register

Cheque register report (requires the Cheque Issuance module):

Opening a Report

To open a report, click the report name (shown in blue). The report opens on its own page with filters, export options, and the report data.

Report Actions Menu

Hover over a report row to reveal a three-dot menu on the right side. Click the menu to see available actions:

• View — Opens the report on its own dedicated page.

Locked Reports and Upgrade Badges

Some reports require a specific module that may not be included in your current plan. These reports show:

• A lock icon instead of a star.
• An amber Upgrade badge next to the report name.
• The report name is greyed out and not clickable.

Clicking a locked report opens a notification telling you which module is required and suggests upgrading your plan.

---

Inside a Report Page

When you open a report (for example, Trial Balance), you land on a dedicated page. While each report is unique, most follow a common layout.

Report Header

At the top, the report name appears as a large heading, with a short description underneath explaining what the report shows.

Date Filters

Every report page includes a date filter card. You choose the date or date range for the report:

• As of Date (for point-in-time reports like Balance Sheet and Trial Balance) — the report shows balances up to and including this date.
• Start Date / End Date (for period reports like Profit & Loss) — the report covers transactions within this range.

Some reports let you toggle an optional Start Date to compare two periods or restrict the data window. Click Load Report to apply your date selections and refresh the data.

Export Options

Below the date filters, an export card gives you three buttons:

Each button shows a loading state (e.g., "Generating...") while the file is being prepared.

Report Data

The main body of the page displays the report data. Depending on the report type, you may see:

• Tables — Account balances, transaction lists, aging summaries, and other tabular data. Columns vary by report. Numeric columns are right-aligned. Negative amounts appear in red.
• Summary indicators — For the Trial Balance, a coloured status card shows whether the books are in balance (green checkmark) or out of balance (red alert with the difference amount).
• Grouped sections — The Trial Balance groups accounts by type (Assets, Liabilities, Equity, Revenue, Expenses, Cost of Goods Sold) with subtotals for each group and a grand total.

---

Custom Reports

The Custom reports tab lets you build reports that go beyond the standard options. You pick the data source, choose which columns to show, apply filters, add sorting, and see a live preview as you build.

Custom Reports List

At the top, a counter shows how many custom reports you have used out of your plan limit (e.g., "3 of 10 custom reports used"). If you have unlimited custom reports, it shows "Unlimited custom reports."

Below the counter is a New custom report button. Click it to start building a new report.

If you have existing custom reports, they appear as cards in a grid. Each card shows:

Creating or Editing a Custom Report

Clicking New custom report or the Edit button on an existing report opens a builder panel that slides in from the right. The builder is organized into tabs:

Data & Columns tab

• Data source — Select the dataset your report is built on (e.g., Transactions, Journal Entries, Accounts).
• Columns — Check or uncheck columns to include or hide them. Drag columns to reorder. You can rename any column by clicking its label.

Filters tab

Add conditions to narrow down the data. Each filter has:

• A column to filter on.
• An operator (equals, contains, greater than, less than, between, etc.).
• A value to match.

You can group filters with AND/OR logic. Click Add filter to add a new condition, and click the X to remove one.

Sort tab

Choose which column to sort by and whether the order is ascending or descending. You can add multiple sort levels.

Pivot tab

Transform your report into a pivot table by choosing:

• Row field — The column that defines each row.
• Column field — The column whose values become separate columns.
• Value field — The numbers to display (sum, count, average, etc.).

Computed Columns tab

Create new columns from formulas using existing columns. For example, calculate a margin percentage from revenue and cost columns.

Conditional Formatting tab

Apply rules to highlight cells based on their values. For example, colour negative amounts red or highlight values above a threshold.

Parameters tab

Define prompts that appear when the report is run. For example, a "Department" parameter lets the person running the report choose which department to filter by.

Subtotals & Comparison tab

• Subtotals — Add subtotal rows grouped by a column (e.g., subtotal by account type).
• Comparison — Add a prior-period column to compare current results against a previous month, quarter, or year.

Schedules tab

Set the report to run automatically on a schedule (daily, weekly, monthly, quarterly). You can configure who receives the report by email.

Snapshots tab

Save the current report output as a snapshot. Snapshots freeze the data at a point in time so you can refer back to it later, even after the underlying data changes.

Live Preview

As you make changes in any tab, a preview of the first 10 rows updates automatically below the builder. The preview refreshes after you stop typing. If the query has an error, an error message appears instead.

At the bottom of the builder:

• Save — Saves the report definition.
• Cancel — Discards changes and closes the builder.

Viewing a Custom Report

Clicking View on a custom report card navigates to a full-page view. From there you can:

• See the report with all rows (not just the preview).
• Export to PDF — Download a formatted PDF.
• Export to Excel — Download an Excel file.
• Apply parameter prompts if the report has any.

Duplicating a Custom Report

Click the copy icon on a report card to create an exact copy. The duplicate appears in the list with the same name. You can then edit it without affecting the original.

Deleting a Custom Report

Click the trash icon on a report card. A confirmation dialog opens showing the report name. Click Delete to permanently remove it, or Cancel to keep it.

Limit Reached

If you have used all your custom report slots, the New custom report button is disabled and an amber banner appears: "You've reached your saved-report limit. Delete one or upgrade your plan to add more."

---

Management Reports

The Management reports tab lets you build branded report packs. A pack is a collection of sections — cover pages, tables of contents, narrative commentary, custom reports, and standard reports — assembled in order and exported as a single PDF or Excel file.

Management Packs List

At the top, a short description explains the feature. To the right is a New pack button.

Existing packs appear as cards in a grid. Each card shows:

Creating or Editing a Management Pack

Clicking New pack or the Edit button on an existing pack opens an editor panel that slides in from the right.

Pack Settings

• Pack name — Give the pack a descriptive name.
• Visibility — Choose Private (only you) or Shared with firm (visible to everyone in your firm).
• Description — Optional text explaining the purpose of the pack.

Sections

Below the settings, the Sections area shows the list of sections in order. Each section can be one of six types:

Each section row shows:

• Drag handle on the left (for visual reference in the editor).
• Type selector dropdown.
• Title field (except for page breaks).
• Up arrow and Down arrow buttons to reorder sections.
• X button to remove the section.

For narrative sections, a text area appears below where you can write your commentary. For custom report sections, a dropdown lets you pick which of your custom reports to include.

Click Add section at the top of the sections list to add a new section at the bottom.

Saving

At the bottom of the editor, click Save to save the pack. The panel closes and the pack list refreshes. Click Cancel to discard changes.

Exporting a Management Pack

On any pack card, click:

• PDF to download the entire pack as a single PDF file.
• Excel to download the entire pack as an Excel file.

Duplicating and Deleting

• Click the copy icon to duplicate a pack. The copy appears with the same name.
• Click the trash icon to delete a pack. Confirm the deletion in the dialog. This action is permanent.

---

Searching for Reports

The search bar at the top of the Standard reports tab filters in real time as you type. It matches against report names only. When a search term is active:

• Only sections that contain matching reports are shown.
• Within each section, only matching reports are displayed.
• The Favorites section is hidden while searching.

Clear the search field to return to the full list.

---

Frequently Asked Questions

Can I run a report for a date range that crosses fiscal years?

Yes. The date filters on each report page let you choose any start and end date. The report will include all transactions within that range.

What happens if I close a report page without downloading?

Nothing is saved automatically. When you return, you need to set the date filters and load the report again.

Can I share a custom report with my team?

Yes. When building or editing a custom report, set its visibility to Shared with firm. Everyone in your firm who has access to the client can see and run the report.

How do I know if a report requires a module I do not have?

Locked reports show a lock icon and an Upgrade badge. The entire group section also shows an Upgrade Plan badge in its header. Clicking a locked report tells you which module is needed.

Can I schedule a report to run automatically?

Yes. When building a custom report, use the Schedules tab in the builder to set up automatic runs on a daily, weekly, monthly, or quarterly schedule. You can add email recipients who will receive the report each time it runs.

What is the difference between a custom report and a management pack?

A custom report is a single report built from one data source with your choice of columns, filters, and formatting. A management pack is a collection of multiple sections — cover page, narrative, several custom reports, and standard reports — combined into one deliverable document.

Can I export a management pack to both PDF and Excel?

Yes. Each pack card has separate PDF and Excel download buttons. The Excel export includes each section as a separate sheet.

Why are some payroll reports not listed under the Payroll section?

All payroll reports are listed under the Payroll section. They navigate to the Payroll module's dedicated reporting area. If you do not see them, the Payroll module may not be included in your plan.