Aantar Books
Banking reports
Money in and money out by payment method, payments received day by day, cheques written and received, gaps in the cheques you wrote, and every bank and card reconciliation.
Where: Reports ▸ Banking · Reports ▸ Report Centre ▸ Banking
The Banking reports follow the money itself: every payment received and made, by method and by day, every cheque, and every reconciliation. Use them to match what reached the bank against what was recorded, to find a cheque that is missing from the sequence, and to review past reconciliations.
Where to find them
- Reports ▸ Banking lists Deposit Detail, Cheque Detail, Missing Cheques and Reconciliation Summary, then the reconciliation screens (Previous Reconciliation, Reconciliation Discrepancy) and the three registers (Cheque Register, Deposit Register, Credit Card Charges Register). Reports ▸ Banking also lists Daily Takings by Payment Method and Day-End Summary (Z report). Those screens are described at the end of this article.
- Reports ▸ Report Centre, category Banking, has the same reports, plus Payments by Method, which is not on the menu. The menu's Missing Cheques is Missing Cheque in the Report Centre.
What these reports count
- Payments, on the day they were made. A payment is counted on its own date, which is not always the date of the invoice or bill it pays.
- Refunds subtract. A refund given or received is taken off, not added.
- Applying a credit is not a payment. When a credit memo or vendor credit is set against an invoice or bill, no money moves, so it is left out of every banking report.
These reports cover the whole company: only Daily Takings by Payment Method follows the location picker at the top of the window. None of them has a customer or vendor filter; use the search box or Filter in the report toolbar instead. See Running a report.
Banking
Deposit Detail
What it answers: every payment received from customers in the period, day by day.
Date: a period.
Columns:
| Column | What it shows |
|---|---|
| Date | The date the payment was received. |
| Invoice | The invoice (or other document) it was paid against. |
| Customer | Who paid. Sales to no named customer show Walk-In Customer. |
| Method | How it was paid, for example Cash, Cheque, Card or Bank Transfer. |
| Reference | The payment reference or cheque number. |
| Amount | The amount. Refunds are negative. |
Rows: one section per day with a Total for the day, then a TOTAL row.
Drill down: double-click a payment to open the invoice it was made against.
When you open it from a Payments by Method line, it shows only that method, and its title names it (for example Deposit Detail — Cash). From a Paid Out line it lists payments made to vendors instead, under the title Payments Made, with Bill and Vendor columns.
Note: Deposit Detail lists each payment received, by the day it was received. To see the deposits you made with Make Deposits, use the Deposit Register (below).
Cheque Detail
What it answers: every payment made or received by cheque in the period.
Date: a period.
Columns:
| Column | What it shows |
|---|---|
| Date | The date of the payment. |
| Cheque no. | The cheque number; — when none was recorded. |
| Name | The customer or vendor. |
| Document | The invoice, bill or expense it was paid against. |
| Bank account | The bank account recorded on the payment. |
| Amount | Cheques you wrote are negative; cheques you received are positive. |
Rows: one per cheque payment, by date, then a TOTAL row.
Drill down: double-click a line to open the document.
Related: The Cheques list and the Cheque Register show the cheques written from your bank account.
Missing Cheques
Shown in the Report Centre as Missing Cheque.
What it answers: every cheque you wrote, in number order, with the gaps and the duplicates in the sequence highlighted.
Date: a period.
Columns: Cheque no., Date, Name and Amount.
Rows: every cheque you wrote in the period: bills paid by cheque, cheques from Write Cheques, expenses paid by cheque and refund cheques to customers. Cheques you received from customers are not included, because their numbers are the customers' own.
The cheques are grouped by the bank account they were drawn on, with a section for each account, so two chequebooks never show each other's numbers as missing. A cheque whose payment did not name an account is listed under Account not recorded. Within each account the cheques are in cheque-number order, and a highlighted line, shaded amber, appears wherever something is wrong with the sequence:
| Highlighted line | What it means |
|---|---|
*** Missing number here: 156 *** |
One number was skipped between the cheques above and below. |
*** Missing numbers here: 156 to 158 (3) *** |
A run of numbers was skipped, with how many. |
*** Duplicate cheque number 155 *** |
The same number was used on two cheques. Both are listed. |
Cheque numbers that are not numbers (with letters or symbols in them) cannot be put in sequence. They are listed at the end of their account, marked (not a number). Each account ends with a Cheques: N line and the total of its cheques.
A note says how many numbered cheques, gaps and duplicates were found.
Drill down: double-click a cheque line to open it.
Tip: A missing number is usually a spoiled cheque that was never recorded, or a cheque written by hand and not entered in Write Cheques.
Payments by Method
Report Centre only.
What it answers: how much came in and went out through each payment method: the cash-up.
Date: a period.
Columns:
| Column | What it shows |
|---|---|
| Method | Cash, Cheque, Card, Bank Transfer and every other method used. |
| Count | How many payments. |
| Surcharge | Surcharges collected with the payments. |
| Tips | Tips collected with the payments. |
| Amount | The total, with refunds subtracted. |
Surcharges and tips are shown on their own because they are collected with a payment but are not sales.
Rows: two sections: RECEIVED (payments from customers) and PAID OUT (payments to vendors and for expenses), each with a subtotal. The last row, NET MOVEMENT, is received less paid out.
Drill down: double-click a method to open the payments behind it: Deposit Detail for a received line, Payments Made for a paid-out line, in each case for that method only.
Tip: Compare the Cash line under RECEIVED with the cash you actually deposited, and the Card line with your card processor's settlement for the same days.
Daily Takings by Payment Method
What it answers: each day's money received from customers, split by payment method, for matching each day's bank deposits and card batches.
Date: a period. Filters: location.
Columns: Day, then one column per payment method used (the busiest method first), then Total.
Rows: one per day that had payments, then a TOTAL row.
Only payments on sales and credit memos count. Refunds and change given are subtracted.
Drill down: double-click a figure to open Deposit Detail for that day and that method; click the day to open Deposit Detail for the whole day.
Day-End Summary (Z report)
What it answers: how the day went at the counter: what was sold, how each sale was settled, and all the money that came in that day, by method. Use it to close the day, like a Z report.
Date: one day by default (any period can be chosen). In Aantar Books, Today's sales on the Home page shows the same figures, and its ◀ ▶ arrows and calendar move to an earlier day.
Columns: Day-end and Amount.
Rows: three sections.
- SALES: the invoices of the day with their count and the sales tax in them, less the credit notes, giving Net sales.
- HOW THE SALES WERE PAID: for the day's sales only, the amount settled by each payment method (named as the company named it, for example E-Transfer), then Credit notes applied and On account (left owing), giving Total of the sales. A sale paid partly by card and partly left owing appears on both lines.
- MONEY RECEIVED: every payment received that day, by method, giving Total received, split under it into for these sales, for earlier invoices, customer advances (no invoice yet) and refunds paid out. This section agrees with Daily Takings by Payment Method for the same day.
Drill down: double-click a line under MONEY RECEIVED to open Deposit Detail for that method and day.
Register Closing Summary
Not in Aantar Books. This is a Aantar POS report about point-of-sale cash register sessions, and the Aantar Books Report Centre does not list it. It is described here for companies that also use Aantar POS, where it is in the Aantar POS Report Centre under Banking.
What it answers: for each cash register session opened in the period, the cash that should have been in the drawer against the cash counted at close.
Date: a period (the day each session was opened). Filters: location.
This report lists sessions on a point-of-sale cash register. A company that does not open and close registers has none, and the report is empty.
Columns: Opened, Closed (or Still open), Staff, Location, Opening cash, Cash sales, Cash refunds, Expected cash (opening cash plus cash sales less cash refunds), Counted, Over / short, Card, Other and Total takings.
When any session closed over or short, a warning above the report says how many.
Reconciliation
Reconciliation Summary
What it answers: every bank and credit card reconciliation you have done, with any difference left over.
Date: none. It lists every reconciliation.
Columns:
| Column | What it shows |
|---|---|
| Account | The account's name is the heading of each section. |
| Statement Date | The statement's ending date. |
| Statement Balance | The ending balance you entered from the statement. |
| Cleared Balance | The balance of the transactions you marked cleared. |
| Difference | What was left unreconciled when you finished. |
| Cleared | How many transactions were cleared. |
| Reconciled By | The user who finished it. |
| Status | Completed, or Undone if it was later undone. |
Rows: one section per account, newest statement first.
To see a reconciliation's detail, or what has changed since, open Previous Reconciliation (below).
Related: Reconcile a bank or credit card account.
Other screens on this menu
Previous Reconciliation
Reports ▸ Banking ▸ Previous Reconciliation lists every past reconciliation, opens each one's report, and lets you undo a reconciliation. See Previous Reconciliation and undoing a reconciliation.
Reconciliation Discrepancy
Reports ▸ Banking ▸ Reconciliation Discrepancy opens the discrepancy report of your most recent reconciliation: what has changed among its cleared transactions since you finished it. That is the usual reason a new reconciliation does not start where the last one ended. See Reconciliation Discrepancy.
Cheque Register, Deposit Register and Credit Card Charges Register
Reports ▸ Banking ▸ Cheque Register, Deposit Register and Credit Card Charges Register list the cheques written, the deposits made and the credit card charges entered. See Cheque, Deposit and Credit Card registers.
Common problems
Deposit Detail does not match my bank statement. Deposit Detail lists each payment on the day it was received. Your bank shows each deposit, which may combine several payments made on different days. Compare against the Deposit Register, or group the payments with Make Deposits so each bank deposit is recorded as one amount.
A credit memo I applied does not show. Applying a credit moves no money, so no banking report lists it. It is on the invoice and on the customer's ledger.
Missing Cheques shows numbers as missing that I never had. Missing numbers are found between the cheques of one account. If the payments for two chequebooks did not name their bank account, they all fall under Account not recorded and show each other's numbers as missing. When you record a cheque, choose the bank account it is drawn on, so each chequebook gets its own section.
Payments by Method shows a method called Unspecified. A payment was recorded without a method. Click the line to list those payments, then open each one's document to check it.
Related articles
Related articles
Something unclear or out of date? Write to support@aantar.com and name this page.