Group report

Purpose

See one range of accounts, or one group (parent) account, month by month for this company.
Use it for general-ledger accounts, customers, or suppliers. Each month’s figure opens the ledger.
This report is one company. It does not merge several companies into one set of accounts.

You are in the company whose books you want.
For General Ledger, the chart of accounts exists. A group account is a parent that has sub-accounts.
For Sales Ledger, customers exist. For Purchase Ledger, suppliers exist.
The months you care about are inside a 12-month window.

Financial Report → Group Report.
Choose the ledger: General Ledger, Sales Ledger, or Purchase Ledger.
Choose how to pick accounts:
Leave Group Account unticked. Set From Account and To Account (customers or suppliers on the sales and purchase ledgers).
Tick Group Account and pick one parent Group Account. The report uses the accounts under that parent.
Set Start Date and End Date. The range must be within 12 months, and start must be on or before end.
Set Report Type:
Balance Report — balance at each month (brought forward plus movement).
Month To Date — movement inside each month.
Click Search (magnifying glass, or F9).
Read the grid. The first columns are Code and G/L Account, Customer, or Supplier. The remaining columns are months in the range (for example Jun 2026).
Click a monthly amount to open Ledger Report for that account and that month. A hint says: Please click on the monthly column to drill down.
Print PDF or Export To Excel.
Zero rows can be hidden. If a tick for zero balances is on the page, use it when you need accounts that did not move.

General Ledger — chart accounts in the range, or children of the group account. Typical job: expenses or sales by month.
Sales Ledger — customers. Typical job: who bought what across the months.
Purchase Ledger — suppliers. Typical job: who you paid or billed across the months.
From Account and To Account are both required when Group Account is unticked. With Group Account ticked, only the group account is required. The messages are Please select Account and Please select Group Account.

Date Range greater than 12 month. Shorten Start Date / End Date to 12 months or less, then Search.
Start Date is greater than End Date. Put start on or before end.
Please select Account / Please select Group Account. Fill from and to, or tick Group Account and pick the parent.
Clicking a row does not open the ledger. Click the month amount. The code and name columns do not drill.
You expected every company in the firm on one page. Run this report once in each company. Use Switch Company. Company management is a separate set of screens.

Ledger report — the month you clicked.
Profit and loss — a formatted statement, not a monthly grid.
Sales reports and Purchase reports — aging and statements when you need what is still unpaid, not monthly movement.
Department / project is a filter on the other financial reports. This grid’s columns are months, not projects.