General Ledger Reports

Ayiza provides several reports to help you monitor your financial position, prepare for period-end closing, and meet compliance requirements.

G/L Account Balances

The G/L Account Balances report shows the balance of individual general ledger accounts over time.

What it shows

For each account and period, you can see:

• Opening balance at the start of the period
• Total debits and total credits posted during the period
• Closing balance at the end of the period

Balances are shown in the company code currency by default. You can also view them in the group currency or functional currency if these are configured for your company code.

How to use it

1. Navigate to General Ledger > G/L Account Balances.
2. Select the company code and financial year.
3. Optionally filter by a specific G/L account or range of accounts.
4. The report displays one row per account per period, with columns for debits, credits, and balance.

You can drill down from a balance figure to see the individual accounting document lines that make up that balance.

Common uses

• Check the current balance of a specific expense or revenue account.
• Verify that a particular journal entry was posted correctly by viewing the period it affected.
• Compare balances across periods to spot trends or anomalies.

Trial Balance

The Trial Balance shows the total debits and credits for every G/L account in a company code, verifying that your books are in balance.

What it shows

For each G/L account:

Column	Description
Account number	The G/L account number.
Account name	The description of the account.
Opening balance	The balance carried forward from the previous period or year.
Period debits	Total debit postings in the selected period.
Period credits	Total credit postings in the selected period.
Cumulative debits	Year-to-date debit total.
Cumulative credits	Year-to-date credit total.
Closing balance	The resulting balance at the end of the selected period.

The trial balance can display amounts in three currencies:

• Company code currency — your local reporting currency.
• Functional currency — an additional reporting currency, if configured.
• Group currency — the corporate group reporting currency, if configured.

How to use it

1. Navigate to General Ledger > Trial Balance.
2. Select the company code, financial year, and period (or period range).
3. The report lists all accounts that have activity or a balance in the selected timeframe.

The grand totals at the bottom should show equal debits and credits, confirming that your books are balanced.

Common uses

• Month-end review to confirm all postings are complete and balanced.
• Quick overview of every account's balance in one place.
• Starting point for preparing financial statements.

Financial Statement

The Financial Statement report generates a formatted Profit and Loss (income statement) or Balance Sheet based on your financial statement hierarchy.

What it shows

Rather than listing every G/L account individually, the financial statement groups accounts into meaningful sections — Assets, Liabilities, Equity, Revenue, Expenses — based on the hierarchy you have defined. Each section shows subtotals, and you can drill down from any subtotal to see the underlying G/L account balances.

How to use it

1. Navigate to General Ledger > Financial Statement.
2. Select the company code, financial year, and period.
3. Select the financial statement hierarchy to use (see Financial Statement Structure to learn how to set one up).
4. The report renders the hierarchy with calculated subtotals at each level.

Click on any node or subtotal to expand it and see the individual accounts and their balances.

Common uses

• Generate a Balance Sheet or P&L for board reporting or management review.
• Drill down from a high-level subtotal (e.g. "Operating Expenses") to the individual accounts.
• Compare financial statements across periods or years.

tipp

The structure of your financial statement is fully customisable. You control which accounts appear under which headings by editing the hierarchy. See Financial Statement Structure for details.

Control Account Balances by Business Partner

The Control Account Balances by Business Partner report shows the breakdown of your Accounts Payable (AP) and Accounts Receivable (AR) control accounts by individual business partner.

What it shows

For each business partner (customer or supplier) that has postings to a control account:

• Business partner number and name
• Total debits and total credits
• Outstanding balance

This is essentially a subledger view — it shows you how much each customer owes you (AR) or how much you owe each supplier (AP).

How to use it

1. Navigate to General Ledger > Control Account Balances by Business Partner.
2. Select the company code and financial year.
3. Optionally filter by business partner or by control account type (AR or AP).
4. The report lists each business partner with their balance details.

Common uses

• Review outstanding customer receivables.
• Check the total amount owed to a specific supplier.
• Reconcile the AP or AR control account balance to the sum of individual partner balances.

Tax Register Lines

The Tax Register Lines report shows all tax-relevant line items from your accounting documents, giving you a detailed view of VAT and other indirect tax entries.

What it shows

For each tax-relevant accounting document line:

Column	Description
Document number	The accounting document that contains this line.
Posting date	When the entry was posted.
Tax reporting date	The date used for tax reporting (may differ from the posting date).
G/L account	The account posted to.
Tax code	The VAT or indirect tax code applied.
Tax rate	The tax percentage.
Net amount	The amount before tax.
Tax amount	The calculated tax.
Gross amount	The total including tax.

How to use it

1. Navigate to General Ledger > Tax Register Lines.
2. Select the company code and the period or date range.
3. Optionally filter by tax code to focus on specific tax types (e.g. standard rate, reduced rate, zero rate).

Common uses

• Prepare data for your VAT return by reviewing all input and output tax entries for a period.
• Verify that tax codes have been applied correctly across all postings.
• Investigate discrepancies between your VAT return figures and your general ledger.
• Export the data for review by your accountant or tax advisor.

info

The Tax Register Lines report draws from the same accounting document line items that feed the UK Tax Compliance module. If you use Ayiza for MTD VAT filing, the figures should agree.