Account Statement
Lists every debit and credit posted to one account, or to all accounts of one type, over a period. Use it to see what is behind a balance, or to check a bank account line by line.
Quick look
- Go to Reports › Business Reports and click the Account Statement card. It opens on your Bank Account.
- Pick another Account Name, or an Account Type.
- Pick a Time Period.
- Click Run Report.
Done. You see each entry on the account with its debit, credit and, for a bank account, the running balance.
Full guide
What it shows, and when to use it
One row for each document that moved the account, with the debit and credit it posted. You can also reach it by clicking an amount on the Balance Sheet or Profit & Loss. It is the closest thing to a ledger view in Bizconnekt.
Filters and date range
Click the filter button beside Run Report to show or hide the filters.
Fields in this section
| Field | Required | What to enter |
|---|---|---|
| Reports | No | Switch to another Business report. |
| Account Type | No | One type from your chart of accounts, such as Bank. Leave it on All Account Types for every type. |
| Account Name | No | Search and pick one account. A parent account includes the accounts under it. If you pick both a type and an account, only the accounts that match both are shown. |
| Time Period | No | Today, This week, This Month, This Quarter, This Year, Yesterday, Previous Week, Previous Month, Previous Quarter, Previous Year or Custom (pick the first and last day). |
If you pick no Time Period, the statement starts at the first day of your previous financial year and runs to today, so the tag above the table shows two years. Tags show the period and the account or type you chose.
Columns
Fields in this section
| Column | What it shows |
|---|---|
| Transaction Date | The date of the document. |
| Transaction Type | The kind of document, such as an invoice, bill, payment or journal. |
| Particulars | The party or reference on the entry. |
| Reference | The document number. |
| Debit | What the document debited to the account. |
| Credit | What the document credited to the account. |
| Balance | The running balance after the row, with Dr or Cr. Shown for bank accounts only. |
When one document touches the account on both sides, the two are netted into one row. Under the table you see Total Debit and Total Credit for the whole period, not only the page you are on. For a bank account the line also shows Opening Balance (everything before the period) and Closing Balance, with Dr or Cr.
Sorting, columns and pages
Click Transaction Date to sort. It is the only sortable column, and the newest entries come first until you change it. The sort runs on the whole statement, not just the page. Balances are worked out oldest to newest, then the order is flipped if you chose newest first. Use the column chooser in the table header to hide, show or reorder columns; the choice is remembered. The pager at the bottom has Go to page and Items per page.
Drill-down and export
Rows do not open the document, and there is no Excel, PDF, print or email on this report.
Who can see it
Open the report with View on Business Reports. Without it the report list shows a No Access page. Business Reports has only View and Add/Edit, and a report changes no record, so Add/Edit makes no difference here.
On mobile
In the mobile app open Reports, choose Business Reports, then Account Statement. It has Account Type (All Types), Account Name and Time Period. The Time Period list is This Financial Year (the default when the screen opens), Today, Yesterday, This Week, This Month, This Quarter, This Year, Previous Week, Previous Month, Previous Quarter, Previous Year and Custom, which has start and end dates. It opens on the Bank Account. A Reset to defaults button puts the filters back. Rows are oldest first, 25 to a page, with the columns Date, Type, Entity, Reference, Debit, Credit and Balance and a Totals row. Cards above show Opening Balance, Total Debit, Total Credit and Closing Balance. There is no file download. Same on iPhone and Android, except that the date picker is inline on iPhone and a pop-up on Android.
The Android app is on Google Play. The iPhone app is coming soon to the App Store.
Problems and fixes
I do not see a Balance column
The running balance is shown for bank accounts only. Choose Account Type Bank, or a bank account in Account Name.
An entry I expect is missing
Check the Time Period, and that the account is the one the document posted to. A document whose date moved out of the period, or that was voided, is not listed.
The statement starts a year earlier than I expected
With no Time Period it starts at the beginning of the previous financial year. Pick This Year to see the current year only.
The report page says No Access
Your role does not have View on Business Reports. Ask an administrator to turn it on.