Banking Module

The Banking Module in QoBooks provides comprehensive management of multi-currency bank accounts, transactions, and financial reconciliation.

Overview

The Banking Module allows you to:

• Manage multiple bank accounts across different currencies
• Track all bank transactions (deposits, withdrawals, transfers)
• Reconcile bank statements with system records
• Manage cash flow and liquidity
• Generate banking reports and analytics

Bank Accounts

Creating a Bank Account

1. Navigate to Banking

   • Go to Financial Management > Banking
   • Click "Add Bank Account"

2. Account Details

   • Account Name: Descriptive name for the account
   • Account Number: Bank account number
   • Bank Name: Name of the financial institution
   • Branch: Bank branch location
   • Account Type: Checking, Savings, or Current

3. Currency Configuration

   • Currency: Select from configured currencies
   • Exchange Rate: Current exchange rate (auto-updated or manual)
   • Locale: Regional formatting for amounts

4. Account Settings

   • Default Account: Mark as default for transactions
   • Active Status: Enable/disable account
   • Opening Balance: Initial account balance
   • Balance Date: Date of opening balance

5. Save Account

   • Click "Save" to create the account
   • Account appears in banking dashboard

Bulk Importing Bank Accounts with Opening Balances

When setting up your organization or onboarding existing banking operations from spreadsheets, you can bulk import commercial bank accounts, mobile money merchant accounts, and physical cash tills along with their opening ledger balances.

1. Navigate to Banking.
2. Click the Import Accounts button in the header toolbar.
3. Click Download CSV Template to review the standardized format with sample bank, mobile money, and cash safe rows.
4. Populate your spreadsheet columns:
   • Account Name (Required): The official account title (e.g., GCB Operational Account, Ecobank USD Treasury, MTN MoMo Merchant).
   • Account Number: Bank account number or mobile money wallet identifier.
   • Sub Type (Required): Must be one of bank, cash, mobile_money, or petty_cash.
   • Currency: Account operational currency (GHS, USD, EUR, GBP).
   • Opening Balance: Ledger balance at your official transition date.
   • Opening Date (YYYY-MM-DD): Cut-off date for initial balance sheet reconciliation (e.g., 2026-01-01).
   • Bank Name & Description: Financial institution name and branch/purpose notes.
5. Automated Double-Entry Accounting: When an opening balance is imported, QoBooks automatically posts a balanced initialization journal entry:
   • Debit: The newly created Bank/Cash Asset Account (increasing liquidity).
   • Credit: Opening Balance Offset Account (Equity 3100).
6. Select your Duplicate Handling Rule (Skip or Update), review the parsed spreadsheet preview, and click Import Bank Accounts. All balances reflect immediately across the Banking dashboard and General Ledger.

Account Types

Checking Account

• For day-to-day transactions
• Supports checks, debit cards
• High transaction volume
• Lower interest rates

Savings Account

• For accumulating funds
• Limited transactions
• Higher interest rates
• May have minimum balance requirements

Current Account

• Business checking account
• Overdraft facility
• Check writing capability
• Transaction fees may apply

Multi-Currency Support

QoBooks supports bank accounts in multiple currencies:

• Base Currency: Organization's primary currency
• Foreign Currency: Accounts in other currencies
• Auto-Conversion: Automatic conversion at current rates
• Manual Conversion: Override exchange rates when needed
• Revaluation: Periodic currency revaluation for reporting

Transactions

Deposits

Recording a Deposit

1. Navigate to Banking > Deposits
2. Click "New Deposit"
3. Select source account
4. Enter deposit amount
5. Select deposit type:
   • Cash deposit
   • Check deposit
   • Electronic transfer
   • Customer payment
6. Add reference/description
7. Attach supporting documents
8. Save deposit

Deposit Types

• Cash: Physical cash deposited at bank
• Check: Check deposits with check number
• Electronic: Wire transfers, ACH, online transfers
• Customer: Payments received from customers

Withdrawals

Recording a Withdrawal

1. Navigate to Banking > Withdrawals
2. Click "New Withdrawal"
3. Select destination account
4. Enter withdrawal amount
5. Select withdrawal type:
   • Cash withdrawal
   • Check payment
   • Electronic transfer
   • Supplier payment
6. Add reference/description
7. Attach supporting documents
8. Save withdrawal

Withdrawal Types

• Cash: Physical cash withdrawn
• Check: Check issued to payee
• Electronic: Wire transfers, ACH, online payments
• Supplier: Payments to suppliers

Transfers

Internal Transfers

Transfer funds between your bank accounts:

1. Navigate to Banking > Transfers
2. Click "New Transfer"
3. Select source account
4. Select destination account
5. Enter transfer amount
6. Set transfer date
7. Add reference/description
8. Save transfer

External Transfers

Transfer funds to external accounts:

1. Navigate to Banking > Transfers
2. Click "New External Transfer"
3. Select source account
4. Enter recipient bank details
5. Enter transfer amount
6. Select transfer method (SWIFT, ACH, etc.)
7. Add reference/description
8. Save transfer

Bank Reconciliation

Reconciliation Process

Reconcile your bank statements with QoBooks records:

1. Navigate to Reconciliation

   • Go to Financial Management > Reconciliation
   • Select bank account to reconcile

2. Enter Statement Details

   • Statement date
   • Statement opening balance
   • Statement closing balance
   • Statement reference number

3. Match Transactions

   • System auto-matches transactions
   • Manually match unmatched items
   • Mark items as cleared
   • Add missing transactions

4. Review Differences

   • Check for discrepancies
   • Investigate missing items
   • Verify amounts match
   • Note timing differences

5. Complete Reconciliation

   • Verify balance matches statement
   • Click "Complete Reconciliation"
   • Generate reconciliation report

Reconciliation Tips

• Regular Schedule: Reconcile monthly or weekly
• Start Date: Begin with oldest unreconciled transaction
• Auto-Match: Use auto-match for efficiency
• Manual Review: Always review auto-matches
• Documentation: Keep bank statements for records

Bank Feeds & OFX Statements: Where and How to Obtain Them

OFX (Open Financial Exchange) is the international standard file format used by commercial banks and fintech platforms to securely export electronic account statements and transaction histories for accounting reconciliation.

Where and How to Download OFX Files:

1. Log In to Online Banking: Access your financial institution’s corporate or retail internet banking portal (e.g., Ecobank, Standard Chartered, Stanbic Bank, GCB Bank, Absa, Zenith, Chase, Bank of America, etc.).
2. Locate Account Statements / History: Navigate to your account overview, Transaction History, or Download Statements section.
3. Select Date Range: Choose your reconciliation period (e.g., previous month or custom calendar date range).
4. Choose Export Format: In the download/export dropdown, look for OFX (often displayed as "Open Financial Exchange", "MS Money (.ofx)", or "Financial Software Format").

   [!NOTE] If your specific local bank does not provide OFX downloads, select CSV (Comma Delimited) or QIF. QoBooks supports standard CSV exports and maps date, payee/narration, reference, and debit/credit amounts automatically.

5. Import into QoBooks: Save the .ofx or .csv file to your device. Navigate to Banking > Reconciliation, select your account, and upload the statement to auto-match cleared debits and credits against your recorded transactions.

Transaction Management

Viewing Transactions

• Transaction List: View all transactions by account
• Filters: Filter by date, type, amount, status
• Search: Search by reference, description
• Export: Export to CSV, PDF, or Excel

Editing Transactions

• Unreconciled Only: Can edit unreconciled transactions
• Reconciled: Cannot edit reconciled transactions
• Void: Void transactions instead of deleting
• Audit Trail: All changes are logged

Voiding Transactions

To void a transaction:

1. Open transaction details
2. Click "Void Transaction"
3. Enter void reason
4. Confirm void
5. Transaction marked as voided
6. Cannot be unvoided

Reports

Account Balance Report

• Current balance by account
• Balance history over time
• Multi-currency summary
• Base currency conversion

Transaction Report

• All transactions by date range
• Grouped by transaction type
• Totals by category
• Exportable formats

Cash Flow Report

• Cash inflows and outflows
• Net cash flow
• Period comparison
• Trend analysis

Reconciliation Report

• Reconciliation history
• Outstanding items
• Discrepancy summary
• Audit trail

Integration

Integration with Sales

• Customer receipts auto-recorded
• Invoice payments tracked
• Deposit references linked
• Real-time balance updates

Integration with Purchases

• Supplier payments recorded
• Bill payments tracked
• Withdrawal references linked
• Real-time balance updates

Integration with Expenses

• Expense reimbursements tracked
• Petty cash management
• Expense account linking
• Budget tracking

Security

Access Control

• Role-based access to banking module
• Separate permissions for viewing, creating, editing
• Approval workflows for large transactions
• Audit trail for all banking activities

Transaction Limits

• Set maximum transaction amounts
• Require approval for large transfers
• Daily withdrawal limits
• Multi-factor authentication for sensitive operations

Best Practices

Account Management

• Keep account information updated
• Regularly review account activity
• Close unused accounts
• Maintain accurate opening balances
• Use descriptive account names

Transaction Recording

• Record transactions promptly
• Use consistent descriptions
• Attach supporting documents
• Reconcile regularly
• Review for errors

Reconciliation

• Reconcile monthly minimum
• Investigate discrepancies immediately
• Keep bank statements organized
• Document reconciliation notes
• Use consistent cutoff dates

Security

• Limit access to authorized users
• Enable transaction approvals
• Monitor for unusual activity
• Regularly review permissions
• Report suspicious transactions

Troubleshooting

Balance Doesn't Match

• Check for unreconciled transactions
• Verify opening balance is correct
• Review for duplicate transactions
• Check for voided transactions
• Re-run reconciliation

Transactions Not Showing

• Verify transaction date is within range
• Check account selection
• Verify transaction wasn't voided
• Refresh the page
• Check for filter settings

Cannot Edit Transaction

• Transaction may be reconciled
• Check your permissions
• Transaction may be locked
• Contact administrator
• Void and re-enter if needed

Reconciliation Fails

• Verify statement details are correct
• Check for missing transactions
• Review for duplicate entries
• Verify amounts match exactly
• Contact support if issue persists

Exchange Rate Issues

• Verify currency is configured
• Check exchange rate is current
• Manually update if needed
• Revalue foreign currency accounts
• Contact support for complex issues