Skip to main content

Bank Statements

The Bank Statements module lets you upload client bank statements and match transactions to invoices for automated payment reconciliation.

Uploading a Statement

  1. Navigate to Bank Statements in the sidebar
  2. Click + Upload Statement
  3. Select:
    • Entity — which client this statement belongs to
    • Bank — bank name (FNB, Standard Bank, Absa, Nedbank, etc.)
    • Account — account number
    • Period — statement period
  4. Upload the file (CSV or OFX format)
  5. Atlas parses the transactions

Supported Formats

FormatBanks
CSVAll major South African banks
OFXSupported by most banking portals

Auto-Matching

After upload, Atlas attempts to match statement lines to open invoices:

RuleHow it matches
AmountStatement amount matches invoice total
ReferenceInvoice number found in statement description
EntityStatement belongs to the entity that was invoiced
DatePayment date is near or after the invoice date

Match Confidence

LevelAction
HighAuto-matched — review and confirm
MediumSuggested match — verify manually
No matchUnmatched — manually assign or skip

Reviewing Matches

  1. Open the uploaded statement
  2. Review each transaction:
    • Matched — confirm with one click
    • Wrong match — reassign to the correct invoice
    • No match — mark as unrelated to any invoice
  3. Confirmed matches auto-record payments against the invoices

Statement History

View previously uploaded statements:

  • Filter by entity, bank, or period
  • See reconciliation status (fully matched, partially matched, unprocessed)
  • Re-process statements if needed

Integration with Time & Billing

Matched payments automatically:

  • Record the payment against the invoice
  • Update the invoice status (Paid / Partially Paid)
  • Reflect in WIP Analytics