Banking

The Banking area manages bank accounts, transactions, imports, categorization, and reconciliation.

Where to find it: Sidebar > Banking

9.1 Bank Accounts

Go to Banking > Bank Accounts to manage bank and cash accounts.

When creating a bank account, provide:

• Name
• Account Type
• GL Account
• Currency
• Opening Balance
• Opening Balance Date
• Optional bank reference fields

Each bank account is single-currency. If it is a foreign-currency account, Accounting preserves that source currency while translating reporting and ledger impact into GHS base amounts.

9.2 Bank Transactions

Go to Banking > Transactions to view and manage bank transactions.

Manual transaction entry supports:

• Deposit
• Withdrawal
• Transfer
• Fee
• Interest
• Adjustment
• Optional Tags for lightweight classification

Reconciled transactions cannot be edited or deleted.

9.3 Importing Transactions (CSV)

To import statement data:

1. Open Banking > Transactions
2. Click Import
3. Select the bank account
4. Choose a bank template if available
5. Upload the CSV
6. Review the preview
7. Map columns if needed
8. Process the import
9. Review the import batch
10. Commit valid rows

The import screen also provides sample and template downloads to help match the expected statement structure.

During review you can use:

• AI Cleanup for malformed rows
• New / Match / Review suggestions for likely duplicate detection during staging
• Valid / Invalid / Ignored row states before commit
• Row batch actions
• Update Tags for selected staged rows when Tags is enabled
• Commit once the import is ready

9.4 Categorizing Transactions

You can categorize one transaction at a time or use Bulk Categorize to assign a GL account to many rows. Category assignment typically maps a bank transaction to a revenue, expense, asset, or liability account.

9.5 AI Categorization

The transactions page also includes AI Categorize. This is separate from import-time AI Cleanup: cleanup repairs staged import rows before commit, while AI Categorize suggests GL categories for existing bank transactions. Suggestions are reviewed before being applied.

9.6 Bank Reconciliation

To start a reconciliation:

1. Go to Banking > Reconciliation
2. Click New Reconciliation
3. Select the bank account
4. Enter the statement date and ending balance
5. Mark matching transactions as cleared
6. Complete when the difference is zero, or acknowledge a permitted variance with a justification

If a reconciliation is already in progress for a bank account, SikaBooks reopens that in-progress session instead of starting a second overlapping reconciliation for the same account.

9.7 Reconciliation Review and Approval

Depending on the configured reconciliation mode:

• Basic — No second-person review
• Dual Control — Separate review/approval step
• Full SOD — Stronger separation of duties

Completed reconciliations can then be reviewed, approved, locked, unlocked, or reopened according to permissions and policy.

The review flow also enforces separation of duties: the reviewer cannot be the same person who completed the reconciliation, and the approver cannot be the completer or reviewer.

9.8 Reconciliation Reports

Reconciliations provide:

• Statement download
• Detailed report
• Status report
• Aging report
• History report

These reports are available as dedicated reconciliation reporting pages in addition to the per-reconciliation statement and report downloads.