Corporate Treasury, Multi-Bank Vaults, Statement Reconciliation, Inter-Account Transfers & Banking Studio
Master multi-bank liquidity management in Keystone X: configure cheque accounts, call accounts, credit cards, and petty cash floats; understand Book Balance vs. Available Working Capital (Overdraft Buffers); execute double-entry Inter-Account Transfers without distorting revenue or expenses; reconcile physical bank statements; generate official Bank Confirmation Letters; and customize your Banking Governance Studio.
1. Plain-English Treasury 101: Book Balance, Available Funds & Contra Transfers
Every cent that enters or leaves your business flows through a **Bank Account Vault** (whether that is an FNB/Standard Bank/Nedbank/ABSA Current Account, an Interest-Bearing Call Account, a Corporate Credit Card, or a physical Petty Cash Tin in the office safe). To keep your balance sheet and tax returns 100% accurate, Keystone X enforces three foundational treasury principles:
1. Book Balance vs. Statement Balance
Your Book Balance is the real-time balance calculated by Keystone X from your Opening Balance plus all recorded Customer Receipts and Transfers In, minus all Supplier/Expense Payments and Transfers Out.
Your Statement Balance is the balance printed on your official bank statement on a given date. Comparing the two in the Statement Reconciliation tab immediately highlights unallocated bank charges, debit orders, or uncleared EFTs.
2. Available Working Capital
Cash flow management requires knowing not just what cash is sitting in the account, but how much total liquidity you can deploy before hitting a credit wall:
You can also set a Minimum Liquidity Alert Floor on each account so Keystone X raises a yellow Low Buffer warning before you dip into overdraft.
3. Why Inter-Account Transfers Are NOT Income or Expenses
When you sweep R 50,000 from your Main Cheque Account into your 32-Day Savings Account (or withdraw R 2,000 to top up Petty Cash), your company is not richer or poorer—you simply moved money from your left pocket to your right pocket.
Never record an inter-bank sweep as an Invoice Receipt or Operating Expense! Doing so artificially inflates your Revenue, Expenses, and SARS VAT201 figures. Always use the Inter-Account Transfer engine (`TRF-XXXX`), which credits the Source Bank GL (`1000`) and debits the Destination Bank GL (`1010`) with zero P&L or VAT distortion.
2. Command Center Header & 4 Executive Liquidity KPI Cards
Navigate to Accounting & Banking → Bank Accounts (`BankAccount/index`) to open the Bank Accounts & Liquidity Command Center.
📸 SCREENSHOT PLACEHOLDER: bank-accounts-command-center-list.png
- Log in as an Administrator and navigate to
BankAccount/index?view_mode=list. - Ensure at least 2–3 bank vaults exist (e.g., Main Business Cheque Account, Money Market Call Account, Petty Cash Float).
- Capture the full screen showing the top header pills, the 4 Liquidity KPI cards, the 4-Mode View Switcher bar, and the Portfolio Ledger table.
Top-Right Action Pills & Subscription Capacity Badge
| Badge / Action Button | Permission / Route | Exact System Behavior |
|---|---|---|
| Vault Capacity: X / Y | Licensing Tier Check | Displays how many bank accounts are currently provisioned against your subscription tier allowance (e.g., 3 / Unlimited). |
| Inter-Account Transfer | add_banking → Modal #recordTransferModal |
Opens the instant contra-transfer modal to move funds between two active bank vaults with automatic reference numbering (`TRF-XXXX`). |
| Reconcile Statement | edit_banking → Modal #reconcileStatementModal |
Opens the Statement Reconciliation sign-off modal to compare a vault's live Book Balance against your physical bank statement closing balance. |
| Customize | manage_settings → BankAccount/settings |
Opens the 4-Tab Banking Governance Studio (General Rules, Account Types, SA Bank Directory, and Vault Lifecycle Stages). |
| Add Bank Account | add_banking → BankAccount/add |
Opens the corporate bank vault onboarding form to configure a new cheque, savings, credit card, merchant gateway, or petty cash account. |
The 4 Executive Treasury Liquidity KPI Cards
| KPI Card | Headline Metric Formula | Sub-Metrics & Alert Indicators |
|---|---|---|
| 1. Total Book Liquidity | Sum of live current_balance across all active vaults |
Displays count of Active Accounts vs. Total Accounts. Turns red if aggregate liquidity is negative. |
| 2. Available Working Capital | Total Book Balance + Total Approved Overdraft Limits |
Shows combined Overdraft Lines (`R X`) and either a green Healthy Buffers badge or a yellow X Low Alert badge if any vault is below its `min_balance_alert` floor. |
| 3. 30-Day Cash Velocity | 30-Day Inflows − 30-Day Outflows |
Shows rolling 30-day gross inflows (green down-left arrow) vs. gross outflows (red up-right arrow) across all accounts. |
| 4. Statement Recon & POP | 100% Aligned or X Variance |
Shows the total Rand variance (`Var: R X.XX`) between book and last reconciled statement balances, plus a direct link to the POP Verification Queue (`X POP Pending`). |
3. The 4-Mode Treasury Workspace (List, Visual Vaults, Reconciliation & Transfers)
Directly below the KPI strip is the **4-Mode View Switcher** paired with a real-time filter bar (`Search bank, account, code...`, `All Account Types`, and `All Statuses`).
Displays a high-density tabular register of every bank vault with 8 columns:
- Vault Code & Account Name: Monospace vault code (`BNK-0001`), clickable Account Name,
DEFAULT EFTstar badge (if set as the primary invoice remittance account), and GL Control Code badge (`GL 1000`). - Institution & Branch: Bank Name (e.g., First National Bank (FNB)) and Universal Branch Code (`250655`).
- Account Number & Type: Account number (automatically masked as
••••••4821if Mask Account Numbers is enabled in Customize settings) and Account Type badge. - Book Balance: Live calculated cashbook balance in bold green (positive) or red (negative/overdrawn), plus a
Low Bufferwarning if below the minimum liquidity alert floor. - Overdraft & Available: Approved overdraft facility and total Available Working Capital.
- 30d Flow (In / Out): 30-day receipts vs. disbursements for that specific vault.
- Recon Status: Last statement reconciliation date and status (`Reconciled`, `Variance: R X`, or `Never Reconciled`).
- Actions Dropdown: Open Vault Cockpit (`BankAccount/view/{id}`), Open Double-Entry Cashbook (`Cashbook/index?bank_account_id={id}`), Set as Primary Default EFT (`BankAccount/setDefault/{id}`), Download Bank Confirmation Letter PDF (`BankAccount/pdf/{id}`), and Edit Vault (`BankAccount/edit/{id}`).
Renders each bank account as a color-coded executive bank card (using the custom hex `card_color` configured for each institution) displaying the chip icon, masked/full account number, branch code, SWIFT/BIC, live Book Balance, Available Funds progress bar, and 1-click quick actions.
Displays an audit-ready reconciliation matrix comparing every vault's Live ERP Book Balance against its Last Reconciled Statement Balance and Last Reconciled Date, highlighting exact Rand variances and offering a 1-click Reconcile Now button that pre-fills the Statement Reconciliation modal for that specific vault.
Displays the chronological audit log of all inter-vault contra transfers (`TRF-XXXX`), showing Transfer Date, Reference Number, Source Vault (Credited `-`), Destination Vault (Debited `+`), Transfer Method (`EFT / Online Banking`, `Cash Deposit / Withdrawal`, `Internal Sweep`), Notes, Recorded By User, and Amount.
📸 SCREENSHOT PLACEHOLDER: bank-accounts-visual-vault-cards.png
- Click the Visual Bank Vault pill (`BankAccount/index?view_mode=cards`).
- Capture the grid of color-coded corporate bank cards showing live book balances, overdraft buffers, and quick action buttons.
4. Adding & Editing a Bank Account Vault (`BankAccount/add` & `edit/{id}`)
Clicking + Add Bank Account opens the bank vault configuration studio. If you select a South African bank from the preset dropdown, Keystone X automatically populates the bank's Universal Branch Code, SWIFT/BIC code, and signature brand color!
| Field Label & Input Name | Required? | Purpose & Accounting Impact |
|---|---|---|
Vault Code (account_code) |
Auto / Editable | Unique internal identifier (auto-generated as BNK-0001, BNK-0002, etc., using your customizable prefix). |
Internal Vault Name (account_name) |
Required | Friendly display name across dropdowns and reports (e.g., FNB Main Operating Cheque, Investec Corporate Call, Office Petty Cash Float). |
Banking Institution (bank_name) |
Required | Name of the commercial bank (e.g., First National Bank (FNB), Standard Bank, ABSA, Nedbank, Capitec Business, Investec, or Internal Cash Safe). |
Account Type (account_type) |
Preset | Classification from the Banking Studio (e.g., Current / Cheque Account, Savings / Call Account, Corporate Credit Card, Petty Cash Float, Merchant Clearing Gateway, Foreign Currency (CFC)). |
Account Holder Name (account_holder) |
Optional | Registered legal entity name printed on Tax Invoice remittance footers and Bank Confirmation Letters. |
Account Number (account_number) |
Required | The bank account number printed on customer invoices (for EFT accounts) or internal identifier (e.g., CASH-SAFE-01 for Petty Cash). |
Branch Code (branch_code) |
Optional | 6-digit universal branch code (e.g., 250655 for FNB, 051001 for Standard Bank, 632005 for ABSA, 198765 for Nedbank, 450105 for Capitec, 580105 for Investec). |
SWIFT / BIC & IBAN (swift_code, iban, routing_number) |
Optional | International wire routing details for cross-border customers paying in USD, EUR, GBP, or ZAR via SWIFT. |
Currency & GL Control Code (currency, gl_account_code) |
Defaults to ZAR / 1000 |
Links this bank vault to its specific Double-Entry Chart of Accounts ledger code (e.g., 1000 Main Bank, 1010 Savings Call Account, 1020 Petty Cash). |
Opening Balance (opening_balance) |
Defaults to 0.00 |
The starting cash balance in the account when you first transition onto Keystone X. All subsequent inflows and outflows build upon this base. |
Approved Overdraft Limit (overdraft_limit) |
Defaults to 0.00 |
Credit line granted by the bank. Added to your Book Balance when calculating Available Working Capital. |
Minimum Balance Alert Floor (min_balance_alert) |
Defaults to 0.00 |
Triggers a visual Low Buffer warning badge whenever the vault's Book Balance drops below this threshold. |
Interest Rate (% p.a.) & Card Color (interest_rate_pa, card_color) |
Optional | Records the annual credit/overdraft interest rate and sets the visual hex color of the bank card in Mode 2. |
Relationship Manager & Contact Details (relationship_manager, bank_phone, bank_email) |
Optional | Stores your dedicated private/business banker's name, telephone, and email inside the Vault Cockpit for urgent forex or facility queries. |
Payment Instructions (payment_instructions) |
Optional | Custom remittance instructions printed on documents (e.g., "Please use your Invoice Number as EFT Beneficiary Reference and email POP to accounts@company.co.za"). |
Transaction Governance Switches (allow_invoicing, allow_expenses, is_default, is_active) |
Checkboxes |
|
5. The 360° Bank Vault Cockpit & Official Bank Confirmation Letter PDF (`BankAccount/view/{id}`)
Clicking any bank account name opens its dedicated **360° Bank Vault Cockpit** (`BankAccount/view/{id}`).
- 6-Month Cash Inflow vs. Outflow Telemetry Chart: Visualizes monthly money-in (`Payments Received` + `Transfers In`) against money-out (`Expenses Paid` + `Transfers Out`) for that specific vault.
- Unified Chronological Cashbook Stream: Combines Customer Invoice Receipts, Operating Expense Payouts, Inbound Contra Transfers, and Outbound Contra Transfers into a single filterable ledger (`?tx_type=all|inflow|outflow|transfer` and date range filters).
- 1-Click Official Bank Confirmation Letter PDF (`BankAccount/pdf/{id}`): Generates a formal, stamped corporate **Bank Account Confirmation Letter PDF** on your company letterhead showing your Company Registration Number, VAT Number, Bank Name, Account Holder, Account Number, Universal Branch Code, Account Type, and SWIFT code. Whenever a corporate client or government tender requires proof of banking details before loading you as a beneficiary, click **Bank Confirmation PDF** to download and email it immediately!
📸 SCREENSHOT PLACEHOLDER: bank-vault-360-cockpit-and-pdf.png
- Navigate to
BankAccount/view/1(your primary operating cheque account). - Capture the 360° Vault Cockpit showing the visual bank card, the 6-month Cashflow Telemetry chart, the unified transaction stream, and the top-right Bank Confirmation PDF button.
6. Recording a Bank Statement Reconciliation (`BankAccount/recordReconciliation`)
At the end of every week or month, download your official PDF/CSV bank statement from your online banking portal and click **Reconcile Statement** (`#reconcileStatementModal`).
- Select Bank Account Vault: Choose the account you are reconciling. Keystone X automatically displays its current Live ERP Book Balance.
- Statement Date (`reconciled_date`): Select the closing date shown on your bank statement.
- Statement Closing Balance (`statement_balance`): Enter the exact closing balance printed on your physical bank statement.
- Variance Calculation & Auto-Status:
- If $|\text{Book Balance} - \text{Statement Balance}| < \text{R } 0.01$, Keystone X marks the vault as Reconciled (100% Aligned) and records your user ID and timestamp in the audit log.
- If there is a difference (for example, unrecorded monthly bank charges of R 185.00), Keystone X logs the exact Rand variance (`Variance Detected`) so you can either import the missing lines via **CSV Bank Import** (Article #24) or post an Expense / Journal adjustment until the variance reaches `R 0.00`.
7. Recording an Inter-Account Contra Transfer (`recordTransfer` & `InternalTransfer/*`)
You can record an inter-bank transfer either from the **Inter-Account Transfer** modal inside `BankAccount/index` (`BankAccount/recordTransfer`) or via the dedicated **Internal Transfers** page (`InternalTransfer/index` → `InternalTransfer/add`).
| Field | Description & Validation Rules |
|---|---|
| From Account (Source Vault) | The bank or petty cash account money is leaving (Credited `-`). Cannot be the same as the Destination Vault. |
| To Account (Destination Vault) | The bank, savings, or petty cash account receiving the funds (Debited `+`). |
| Transfer Amount | Must be strictly greater than `0.00`. |
| Transfer Date & Method | Date of transfer and clearing channel (`EFT / Online Banking`, `Internal Bank Sweep`, `ATM Cash Withdrawal to Petty Cash`, `Cash Banking Deposit`). |
| Reference Number | Auto-generated using your configured prefix (e.g., `TRF-20261016-841`) or custom bank reference. |
8. Banking Governance Studio (`BankAccount/settings` — 4 Tabs)
Administrators with `manage_settings` permission can click **Customize** (`BankAccount/settings`) to configure four governance tabs:
Tab 1: General Treasury & Remittance (`?tab=general`)
- Vault Code Prefix & Next Sequence (`bank_code_prefix`, `bank_next_number`): Default `BNK-` and next auto-increment counter.
- Transfer Reference Prefix (`bank_transfer_prefix`): Default `TRF-`.
- Default Currency & GL Account (`bank_default_currency`, `bank_default_gl_code`): Default `ZAR` and GL `1000`.
- Security & PDF Controls: Toggle Mask Account Numbers in List Views (`••••1234`), Require Beneficiary Reference on Receipts, Show SWIFT/IBAN on Export Invoices, Auto-Print Default Bank Details on Quotes & Invoices, and customize the global Remittance Footer Note.
Tabs 2, 3 & 4: Account Types, SA Banks & Vault Stages
- Tab 2 — Account Types (`?tab=types`): Add, edit, color-code, or reorder vault classifications (Cheque, Call Account, Credit Card, Petty Cash, Merchant Gateway, CFC).
- Tab 3 — Banking Institutions (`?tab=institutions`): Pre-loaded South African bank directory (FNB `250655`, Standard Bank `051001`, ABSA `632005`, Nedbank `198765`, Capitec `450105`, Investec `580105`, TymeBank `678910`, Discovery Bank `679000`) with SWIFT codes and brand colors.
- Tab 4 — Vault Lifecycle Stages (`?tab=stages`): Customize operational statuses (`Active / Operating`, `Savings / Call Reserve`, `Under Reconciliation Review`, `Frozen / Compliance Hold`, `Closed / Archived`).