Bank Statements
The Bank Statements module lets you upload client bank statements and match transactions to invoices for automated payment reconciliation.
Uploading a Statement
- Navigate to Bank Statements in the sidebar
- Click + Upload Statement
- Select:
- Entity — which client this statement belongs to
- Bank — bank name (FNB, Standard Bank, Absa, Nedbank, etc.)
- Account — account number
- Period — statement period
- Upload the file (CSV or OFX format)
- Atlas parses the transactions
Supported Formats
| Format | Banks |
|---|---|
| CSV | All major South African banks |
| OFX | Supported by most banking portals |
Auto-Matching
After upload, Atlas attempts to match statement lines to open invoices:
| Rule | How it matches |
|---|---|
| Amount | Statement amount matches invoice total |
| Reference | Invoice number found in statement description |
| Entity | Statement belongs to the entity that was invoiced |
| Date | Payment date is near or after the invoice date |
Match Confidence
| Level | Action |
|---|---|
| High | Auto-matched — review and confirm |
| Medium | Suggested match — verify manually |
| No match | Unmatched — manually assign or skip |
Reviewing Matches
- Open the uploaded statement
- Review each transaction:
- Matched — confirm with one click
- Wrong match — reassign to the correct invoice
- No match — mark as unrelated to any invoice
- 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