ANTE User Manual

Bank Reconciliation

Bank Reconciliation checks a bank account's ledger against its bank statement for one month. You choose the account and the month, attach the statement, and ANTE matches every statement line to a ledger entry. You review the matches, deal with what is left over, and finish with a reconciliation report. The ledger side is read straight from your live books, so you never upload a journal export for this screen.

Where to Find It

  1. Click Treasury in the sidebar
  2. Open Accounting, then Financial Statements, and select Bank Reconciliation

A progress bar at the top shows the five stages: Set up, Statement, Processing, Review and Report. Once you have moved past a stage you can click it to go back, except Set up, because starting again would create a second reconciliation.

Setting Up a Reconciliation

The first stage is Set up reconciliation. Pick what you are reconciling against, then the month.

Reconcile against*toggle
Bank account uses a Treasury fund account's cash ledger. GL account uses the posted journal entries of a cash or bank account from your Chart of Accounts, which is handy when the bank has no fund account set up.
Bank account*select
Shown when you reconcile against a bank account. The list is your fund accounts.
GL cash/bank account*select
Shown when you reconcile against a GL account. Only active accounts in the Bank / Cash category are offered.
Month*select
The month to reconcile. The ledger side covers the first to the last day of the month.
Year*number
Defaults to the current year.
Name (optional)text
A label for the session. If you leave it blank, ANTE names it after the account and the date range.

Click Start reconciliation. If the account is missing, ANTE asks you to select a bank account or GL account first.

Attaching the Bank Statement

  1. Click Select statement file(s). The File Drive opens in a picker titled Select bank statement.
  2. Choose one or more statement files for the period. Files you attached are listed under the button.
  3. Click Run reconciliation. It stays disabled until at least one file is attached.
Tip

Upload the statement to the File Drive first if it is not there yet. Back returns to the set-up stage.

Processing

ANTE reads the statement and matches it automatically. A checklist under Pipeline Steps shows the progress: Parse Files, Analyze Documents, AI Categorization, Normalize Data, Pre-process Entries, Algorithmic Matching, AI Matching Remaining, AI Analysis & Auto-Confirm and Calculate Statistics. When it finishes the screen moves to Review by itself.

Reviewing Matches

The top of the Review stage has four summary cards: Auto-Matched, Needs Review, Confirmed and Unmatched Entries. Below them, tabs let you work through the results.

All Matchestab
Every pairing of a bank line with a ledger entry.
Auto-Matchedtab
Pairs ANTE was confident enough to accept on its own.
Needs Reviewtab
Suggested pairs that wait for your decision.
Confirmed / Rejectedtab
Pairs you have already decided on.
Bank Entries / GL Entriestab
All statement lines, and all ledger entries for the month.
Bank w/o GL / GL w/o Banktab
Statement lines with no ledger entry, and ledger entries that never appeared on the statement. These feed the reconciling items in the report.

Click a row to open its details. A match shows how well the amount, date, reference, description and category agree, next to the bank line and the ledger entry. Click Confirm Match to accept it, or Reject and give a reason to throw it out. Click Continue to Report at the bottom when you are done.

The Reconciliation Report

The last stage lays the reconciliation out as a statement with two sides. The Bank side starts from the statement ending balance and adds deposits in transit, then outstanding checks and outstanding transfers, to reach the adjusted bank balance. The Book side (GL) starts from the GL cash balance and adjusts for bank credits not in the GL, bank charges not in the GL and unrecorded debits, to reach the adjusted book balance. The Variance at the bottom is the difference between the two. It should be zero when everything is explained.

Download Report produces an Excel file with seven sheets: Reconciliation Summary, Bank + GL Tags, GL + Bank Tags, Unmatched Bank, Unmatched GL, AI Analysis and Adjusting JEs. Back to Review returns to the matches, and Finalize Reconciliation closes the session. Once finalized the button reads Session Completed.

Tip

Anything the bank has that your books do not, such as bank charges, still has to be recorded in the ledger. Post those as journal entries so the next month starts clean.

Coming Back to a Session

A saved session opens directly at the Review stage, so you can pick up where you left off without running the matching again.

How It Connects

Set up first

  • Fund Account — the bank account you reconcile against, when you choose Bank account.
  • Chart of Accounts — supplies the Bank / Cash GL accounts you can reconcile against.

Gets its data from

  • File Drive — where the bank statement files are stored before you attach them.
  • Journal Entries — the posted entries for the month form the book side being matched.
  • Fund Account — cash movements recorded on a fund account appear on its ledger.

Feeds into