Viewing the Client Account Statement Report
Report Overview
The Client Account Statement report is a detailed accounting report that displays all journal entries linked to client accounts over a specified time period. It shows the opening balance before the period, debit and credit movements for each entry, and the closing balance for each client. This report is used to review account activity with accounting precision, verify entry balances, and track the full account statement for each customer, including invoices, returns, payments, and adjustments.
Steps to View the Report
- Click on the Reports menu.
- Click on Client Reports.
- From the page, select Client’s Statement.
- You can apply a number of filters before viewing the report:
- Date Range: Select the time period for which you want to view account activity.
- Last Week: The past seven days.
- Last Month: The past thirty days.
- Month to Date: From the beginning of the current month to today.
- Last Year: The past twelve months.
- Year to Date: From the beginning of the current year to today.
- Custom: Click the field and manually select a start and end date.
- Account: Select a specific customer account to display its statement only; you can search by name or code. If no account is selected, the system displays the report for the default account, which is the main customer account.
- Added By: Filter entries by the user who created them. If not selected, the system displays entries from all users.
- Journals Branch: Select a specific branch to display only the journal entries associated with it. If not selected, the system displays entries for the default branch.
- Display All Accounts: Control the scope of accounts displayed.
- Show accounts with transactions in the selected period: Displays only active accounts during the period.
- Show all accounts: Displays all customer accounts regardless of transaction activity.
- Show accounts with transactions: Displays accounts that have any prior accounting activity.
- Hide Staff Column: Enable this option to hide the employee column from the report table.
- Date Range: Select the time period for which you want to view account activity.
- Once filters are adjusted, click Show Report to refresh the results, or click Reset to return to the default settings.
- You can toggle between Summary view to show totals per account only, or Details view to show each entry individually within the customer account.
- ou can print the report using Print, or export it via Export Options to:
- CSV
- Excel
- PDF — with the ability to adjust page orientation and font size from the adjacent settings icon.
Report Columns
The table displays journal entries grouped under each customer. At the start of each customer group, an Opening Balance row appears showing the accumulated balance before the selected period begins, followed by the entry details. The columns are arranged as follows:
- Number: The sequential number of the entry within the customer group.
- Journal ID: The journal entry number in the system, with a direct link to view its details.
- Transaction ID: The internal number associated with the transfer or entry.
- Date: The date the journal entry was recorded.
- Staff: The code and name of the employee linked to the entry. This column can be hidden using the Hide Staff Column filter option.
- Description: The journal entry description, with a direct link to the associated document such as an invoice, return, or payment.
- Debit: The debit side value of the entry in the selected currency.
- Credit: The credit side value of the entry in the selected currency.
- Debit Balance: The accumulated debit balance up to the date of this entry.
- Credit Balance: The accumulated credit balance up to the date of this entry.
At the end of each client group, a Total row appears summarizing the total debit and credit activity and the closing balance for the period. At the bottom of the table, an Overall Total row aggregates data from all customer accounts across the entire period.