Abbpay

Reports

Updated 1 day ago 6 min read

Overview

The Reports section provides a comprehensive suite of financial reports to help you analyse your business performance. From profit and loss statements to accounts receivable aging, every report is filterable, exportable, and designed for actionable insights.

Accessing Reports

Navigate to Account > Reports from the left sidebar.

Available Reports

The Reports hub contains 11 report types, each accessible via tabs:

# Report Description
1 Transactions All financial transactions with filtering
2 Account Statement Revenue and payment records by account
3 Income Summary Income analysis by account and period
4 Expense Summary Expense and COGS analysis by period
5 Income vs Expense Profit analysis comparing income and expenses
6 Profit & Loss Comprehensive financial performance statement
7 Tax Summary VAT analysis with net liability
8 Cash Flow Cash flow statement (indirect method)
9 AR Aging Accounts Receivable aging by customer
10 AP Aging Accounts Payable aging by supplier
11 General Ledger Transaction detail with running balance

Transaction Report

Purpose

View all financial transactions with optional filtering.

Filters

Filter Description
Date Range Presets: Today, Last 7/30 Days, This/Last Month, Quarter, Year, Custom
Account Filter by specific bank account
Category Filter by income/expense category

Columns

  • Account, Category, Date, Amount

Export

  • Excel (.xlsx)
  • PDF

Account Statement

Purpose

Manage and analyse revenue and payment records by account.

Filters

Filter Description
Date Range 5-month default, expandable with presets
Account Bank account selector
Type Revenue or Payment

Data

  • Revenue accounts with totals
  • Payment accounts with totals
  • Filtered by date range

Export

  • Excel (.xlsx)
  • PDF

Income Summary

Purpose

GL-based income analysis by account, with period aggregation.

Filters

Filter Description
Date Range Full year default
Period Monthly, Quarterly, Half-Yearly, or Yearly

Visualisation

ApexCharts area chart showing income trends over the selected period.

Data

  • Income accounts grouped by period
  • Period totals and grand total

Export

  • PDF (landscape orientation)

Expense Summary

Purpose

GL-based expense analysis combining Expenses and Cost of Goods Sold accounts.

Filters

Filter Description
Date Range Customisable period
Period Monthly, Quarterly, Half-Yearly, or Yearly

Visualisation

ApexCharts area chart (red colour scheme) showing expense trends.

Export

  • PDF (landscape)

Income vs Expense

Purpose

Profit analysis comparing total income against total expenses.

Filters

Filter Description
Date Range Customisable period
Period Monthly, Quarterly, Half-Yearly, or Yearly

Key Calculations

Metric Description
Total Income Sum of all income accounts
Total Expenses Sum of expenses + COGS
Net Profit Income - Expenses
Profit Margin Net Profit / Income x 100

Visualisation

ApexCharts bar chart with 3 series:

  • Green - Income
  • Red - Expenses
  • Blue - Profit

Export

  • PDF (landscape)

Profit & Loss

Purpose

Comprehensive financial performance report showing income, expenses, and net profit/loss.

Filters

Filter Description
Date Range Full year default

Report Structure

Income Accounts
  ├── Parent Account → Sub-accounts → Subtotal
  └── Total Income

Expense Accounts
  ├── Parent Account → Sub-accounts → Subtotal
  └── Total Expenses

Cost of Goods Sold
  ├── Parent Account → Sub-accounts → Subtotal
  └── Total COGS

━━━━━━━━━━━━━━━━━━━━━
Net Profit/Loss = Total Income - Total Expenses - Total COGS

Columns

Column Description
Account Code Account identifier
Account Name Account description
Total Credit Credit balance
Total Debit Debit balance
Net Amount Credit - Debit

Only accounts with non-zero balances are displayed.

Export

  • PDF

Tax Summary

Purpose

VAT analysis showing output tax (sales), input tax (purchases), and net liability.

Filters

Filter Description
Date Range Customisable period

Data Structure

Metric Description
Output VAT (Sales) VAT collected on sales
Input VAT (Purchases) VAT paid on purchases
Net VAT Liability Output VAT - Input VAT
Monthly Breakdown Per-month VAT analysis

Visualisation

ApexCharts bar chart with 3 series:

  • Red - Output VAT
  • Green - Input VAT
  • Blue - Net VAT

Export

  • PDF (landscape)

Cash Flow

Purpose

Cash flow statement using the indirect method, derived from General Ledger data.

Filters

Filter Description
Date Range Full year default

Report Sections

Section Description
Operating Activities Cash from day-to-day business operations
Investing Activities Cash from buying/selling assets
Financing Activities Cash from loans, equity, dividends
Net Change Total change in cash position
Opening Cash Balance Cash at start of period
Closing Cash Balance Cash at end of period

Visualisation

ApexCharts bar chart (green for positive, red for negative cash flow).

Export

  • PDF

Accounts Receivable Aging

Purpose

Shows outstanding customer invoices grouped by age buckets.

Filters

Filter Description
As of Date Single date picker (aging calculated from this date)

Age Buckets

Bucket Colour Description
Current Green Not yet due
1-30 Days Yellow 1 to 30 days overdue
31-60 Days Orange 31 to 60 days overdue
61-90 Days Red 61 to 90 days overdue
90+ Days Dark Red More than 90 days overdue

Data

Table showing each customer with amounts in each aging bucket and total outstanding.

Visualisation

ApexCharts bar chart with 5 colour-coded categories.

Export

  • PDF (landscape)

Accounts Payable Aging

Purpose

Shows outstanding supplier bills/purchases grouped by age buckets.

Filters

Filter Description
As of Date Single date picker

Age Buckets

Same structure as AR Aging: Current, 1-30, 31-60, 61-90, 90+ days.

Visualisation

ApexCharts bar chart with same colour scheme.

Export

  • PDF (landscape)

General Ledger

Purpose

Detailed transaction listing for a specific account with running balance.

Filters

Filter Description
Account Select a Chart of Accounts entry (searchable, required)
Date Range Start and end dates

Data Display

Field Description
Opening Balance Balance at start of period
Date Transaction date
Reference Transaction reference
Description Transaction description
Debit Debit amount
Credit Credit amount
Running Balance Cumulative balance
Closing Balance Balance at end of period

Export

  • PDF (landscape)

Note: You must select an account before the report data is displayed.

Was this page helpful?
0 found it helpful, 0 did not