Banking & reconciliation

The Banking area of SolaCount holds your bank and cash accounts. You import bank statements there, set up rules that suggest how bank lines are categorized, and reconcile each bank account against your books. Every bank or cash account is linked to a ledger account in your chart of accounts, so the balances you see always come from posted journal entries.

Where to find it

The Banking section of the sidebar contains:

The reconciliation reports are under Reports → Banking.

Bank accounts

The list

Bank Accounts ("Manage cash & bank ledgers") shows four summary tiles: Bank Accounts, Active, Needs Reconciliation (with the number overdue) and Net Balance. The Net Balance tile is headed with your base currency (for example AED) and reads "Ledger balance in base currency": it adds the ledger balances of the accounts, which all share the base-currency unit, and does not mix in statement balances that may be in a foreign currency.

Each row has these actions: View bank, Reconcile, Edit and Import statement. At the top you can search ("Name / bank / number / IBAN"), filter by status, export with Excel, open Bank Ledgers, or click Add Bank Account.

Only postable ledger accounts of subtype Bank are bank accounts. Cash boxes are managed under Cash accounts and are excluded from the bank screens and bank reports, so a cash ledger never inflates a bank balance.

Add a bank account

1. Click Add Bank Account. The form is titled New Bank Account.
2. Fill in the Bank Account Information card:

3. Click Create. You see "Bank account created."

When you save, SolaCount creates a new Asset → Bank ledger account under your bank parent account and links it to the bank account. No opening balance is posted. To bring in a starting balance, use opening balances or a journal.

To change details, click Edit and then Save ("Bank account updated."). The React screens have no delete button. A bank account that has payments cannot be deleted ("Cannot delete: this bank account is referenced by payments."). Mark it inactive instead.

Bank account detail

View bank opens the account. You see Back, Cheque Books and Edit, the account details, and a Reconciliation History table (Period, Status, Statement balance, Reconciled at). If there are none yet it says "No reconciliations yet."

The Reconciliation sidebar shows Last reconciled (or "Not yet"), Next start, Cadence, and a New Reconciliation button. That button reopens your latest draft if one exists, or starts a new one. To see the account's transactions, use Open ledger on the list.

Cash accounts

Banking → Cash accounts manages cash on hand.

1. Click New cash account.
2. Enter the Cash account name and choose a Currency from your organization's currencies. A currency that is not enabled shows "This currency is not enabled for this organization." with a Currency settings link. Description (optional) is optional.
3. Choose the ledger:
   • Create a linked ledger automatically (default) creates a new Asset → Cash ledger.
   • Use an existing cash ledger lets you pick an active, postable cash ledger that is not linked yet, from the Ledger list.
4. Click Save. It is disabled until the required fields are filled. You see "Cash account saved."

The form notes that "Creating a cash account does not post a balance. Use Opening balances when needed."

The detail page shows the Posted balance (one line per currency, never added together), Currency, Ledger and Status. It also has a Posted transactions table with Date, Reference, Description, Money in, Money out and Currency, 20 rows per page.

Rules:

• After money has moved, the currency is locked: "Currency cannot change after financial activity."
• Delete cash account ("Delete this unused cash record? Its ledger will be retained.") works only when there is no activity. Otherwise you see "This cash account has financial activity and cannot be deleted." The ledger is always kept.
• The linked ledger cannot be swapped: "The linked ledger cannot be replaced."
• If your organization requires approval for bank accounts or new ledgers, saving shows "Submitted for approval. The cash account and ledger will be saved together after all required approvals."

Import a bank statement

Banking → Import Statements (Bank Statement Imports) has a Start New Import card (CSV, OFX, QFX) and a Recent Imports list. You can also click Import statement on a bank account row. The wizard has four steps: Upload → Map & Validate → Review → Done.

Step 1: Upload

1. Choose the Bank account. Only active bank accounts linked to a postable Bank ledger are offered; cash ledgers are not statement accounts. Opening the wizard or a reconciliation from the app's card links always loads the full page, so its scripts and file picker work.
2. Drop the file in Statement File or click Browse Files. Supported formats are CSV, TXT, OFX and QFX, up to 10 MB. OFX and QFX files are read directly. Other files are read as delimited text.
3. Check the Parsing Options:

4. Click Upload & Continue.

Step 2: Map & Validate

Match your file's columns to SolaCount fields. A mapping is suggested automatically.

• Required Fields are Transaction Date, plus one of these depending on the amount type: Amount Column; Direction Column (Credit/Debit); or Debit Column and Credit Column.
• Optional Fields are Description, Reference, Payee, Running Balance, Posted Date and Check Number.
• Direction words are recognised. Credit words: credit, cr, deposit, in, received, +, c. Debit words: debit, dr, withdrawal, out, payment, fee, -, d.

Click Apply Mapping.

Step 3: Review

Parsed Preview shows up to 50 rows and counts Valid, Errors, Duplicates and Warnings, together with Inflow, Outflow, Net and Period.

• Rows that look like an earlier import (same date, amount, description and balance) are flagged "Duplicate transaction" and are not imported.
• If more than 10% of rows have errors, the import is blocked unless you tick Import valid rows only if errors exist.
• Click Commit Import and confirm in the Import bank transactions dialog. Use Back to change the mapping, or Cancel Import to abandon the import.

Step 4: Done

You see Import Successful with Start Reconciliation and View All Imports.

Committing saves the lines as unmatched statement lines and runs your bank rules to suggest accounts. No journal entries are posted. The import detail page shows totals for lines, matched, unmatched, ignored and errors, and lists every line.

Import problems

• Uploading the same file again to the same bank account is refused. The wizard shows the server's explanation: that the file was already imported, and which import it was. To re-import, cancel or delete the earlier import first.
• Only draft, cancelled or failed imports can be deleted. A committed (posted) import cannot be deleted.
• If an action's outcome is not confirmed (a server error, a network drop, or more than 45 seconds), the wizard does not retry. A Status not confirmed dialog asks you to Check current status before submitting again. Open Recent Imports to see whether the import went through.

Permissions: View bank statement imports to see imports, and the upload permission to run the wizard, including committing.

Bank rules

Bank rules recognise recurring statement lines, such as DEWA bills or bank charges, and suggest or post the offset account. Rules need the Bank Auto-Rules feature, which is available on the Professional plan and above.

Create a rule

Go to Banking → Bank Rules ("Transaction auto-categorisation rules") and click New Rule. Fill in:

Click Create Rule ("Bank rule created."). To change a rule, open it and click Update Rule.

How rules work

• Only active rules are checked, in priority order. The first rule that matches wins. All the conditions you filled in must match.
• At import, the matching rule's offset account is stored as a suggestion on the line.
• In the reconciliation workspace, a matching rule raises the suggestion's score ("Rule confidence boost (+15)").
• During Auto-match All, a rule with Apply Automatically on posts an adjusting entry for the line's full amount. With Auto Adjust + Match it also matches the line. Rules without an offset account are skipped.
• Changes to rules are recorded in the financial audit log.

Users without Manage bank rules see a read-only list with no New Rule button. The React screen has no delete button.

Reconcile a bank account

Reconciliation confirms that your books agree with the bank statement for a period. Matching is free of journal entries. The only entries the process can post are adjusting entries for differences such as bank fees.

1. Start a reconciliation

Click Reconcile on the bank account row, or New Reconciliation on the account. The start page has three parts:

• Statement context shows the Last reconciled end date, the Suggested start date and Gap mode.
• Statement window has Use imported statement (optional), which fills in the dates from an import, and the Statement start date and Statement end date.
• Statement balance has Statement ending balance (required, prefilled from the import's running balance where available). "The difference must be zero before completion."

Click Start reconciliation. Possible messages:

• "Statement date range cannot exceed 366 days."
• "Statement dates cannot be in the future."
• "Statement window overlaps an existing {status} reconciliation (…)."
• "Reconciliation gaps are disabled. Statement start date must be {date}."
• "No accounting periods cover the selected statement range. Create/open periods first."
• "Selected statement range is inside a locked fiscal year."

If you start the same account and dates again, the existing draft is resumed ("Existing draft reconciliation resumed.") and the new ending balance replaces the old one. No second draft is created.

2. The reconciliation workspace

The header has the Statement Start Date, Statement End Date and Statement ending balance fields, with Update Statement. The summary shows:

• The left panel, Bank Statement Lines, has filters, a description search, and Top Suggestions with a score and an Apply button for each. Line actions are Unmatch, Ignore and Unignore.
• The right panel, Book Transactions, shows your posted ledger lines. You can search memo, reference and number, set Min amount / Max amount, and tick Un-reconciled only.
• The bottom bar shows Bank Amount, Selected Book Total, Diff (Bank - Book) and Running Selection Total, with the Match Selected button.

Keyboard shortcuts: Enter matches, A opens the adjustment window, and ↑ / ↓ move between bank lines.

3. Match lines

• Auto-match All (Safe Exact) matches every line whose best suggestion scores 70 or more and agrees to within one minor unit (AED 0.01). Then it shows "Auto-match completed. Review the matched and unmatched lines."
• To match manually, select a bank line, tick one or more book lines, and click Match Selected. One bank line can match several book lines. You can also apply part of a book line to each of several bank lines. Many bank lines to one book line directly is not available.
• Only exact matches are allowed: "Only fully balanced matches are allowed. Any non-zero diff is blocked until adjustment resolves it." If the amounts differ you see "Diff is X. Create adjustment or fix applied amounts first."
• Undo Last Match reverses your most recent match. Unmatch releases a single line.
• Ignore lines that do not belong in the books, for example a duplicate on the bank's side. A matched line must be unmatched before it can be ignored.

4. Create an adjusting entry

For a bank fee, interest or FX difference that is not yet in your books, select the bank line and press A (or use the adjustment action). The Create Adjusting Entry window opens.

1. Choose the type: Bank Fee / Expense, Interest / Income, FX Difference or Other.
2. Check the Adjustment amount and Adjustment memo.
3. Pick the Offset Account. A sensible default is suggested. It cannot be the same bank account.
4. Click Create Entry.

The entry is posted on the bank line's date (source BANK_RECON), so that date must be in an open period.

5. Finalize, lock and reopen

• Finalize asks "Finalize this reconciliation?" The server refuses it while the difference is not zero, unmatched bank lines remain, a match is uneven, or no ending balance has been entered.
• Lock asks "Lock this reconciliation?" Only reconciled reconciliations can be locked.
• Reopen returns the reconciliation to Draft. You must give a reason of at least 10 characters for the audit record. Reopening is blocked if a later reconciliation is locked. The original start date is kept.
• Finalize, lock, reopen and adjusting entries can require approval if your organization has set up approvals.

Error dialogs. When the server refuses an action in the workspace for a business reason (for example finalizing with a non-zero difference, an uneven match, or a locked period), the workspace shows that reason in an error dialog, for example "Cannot reconcile: difference of …". The generic "Action could not be completed – The request could not be completed. Check your connection and review the page." appears only for connection or server errors, expired sessions (sign in again) and permission failures. As with imports, an unconfirmed action is never repeated automatically. Use Check current status.

The Finalize, Lock and Reopen buttons in the page header and the workspace itself respond to each other, so the buttons work from any part of the page without reloading it.

Journal entries that are matched in a reconciliation cannot be unposted. Unmatch them first.

Worked example (AED)

Al Noor Trading LLC reconciles Emirates NBD – Current for September 2026. The previous reconciliation ended at AED 48,250.00, and the statement ending balance is AED 61,175.00.

1. Auto-match All matches 23 of 25 lines.
2. A customer receipt of AED 12,000.00 is matched by hand to its payment.
3. The last line is a bank charge of AED −75.00 (VAT on the charge is left out to keep the example simple). You create an adjusting entry of type Bank Fee / Expense, with the offset account Bank Charges:

4. The Difference shows 0.00. Click Finalize, then Lock.

Reports

Under Reports → Banking (permission View reports). All bank reports have PDF and Excel exports.

• Bank Summary lists each bank account with its debits, credits and balance at the end of the period, in base currency, and ends with a Total Balance row. Parent and child bank accounts roll up: when a bank record sits under another, each underlying ledger account is counted once, so the total on screen, in the PDF and in the Excel file is the same figure and agrees with the ledger.
• Bank Detail lists every posted transaction of one bank account. Foreign-currency lines keep their own exchange rate, so an account that is in USD shows the base-currency value each line was booked at (a line whose base amount is legitimately zero is not replaced by its foreign amount).
• Reconciliation Status ("Bank reconciliation runs and their completion state") has the tiles Reconciliations, Reconciled, In Progress and Discrepancies. It filters by date range (default: the last 6 months), bank and status.
• Reconciliation Discrepancies ("Bank reconciliations that ended with a non-zero difference") has the tiles Discrepancies, Total Difference, Maximum Difference and Unmatched.

The two reconciliation reports are translated into every supported language: title, subtitle, tile names, the status filter (Draft, In Progress, Reconciled, Locked, Reopened), the status column, and the month names in dates. The PDF uses the same wording as the screen.

Cash accounts have their own Cash Summary and Cash Detail reports; bank reports no longer include cash ledgers.

Second example: a dollar account on the list and in Bank Summary

Al Noor Trading LLC (base currency AED) has two bank accounts on 12 October 2026: Emirates NBD - Current (AED) with a ledger balance of AED 61,175.00, and Mashreq - USD (currency USD) holding USD 5,000.00 booked at 1 USD = AED 3.6725.

The Net Balance tile shows AED 79,537.50 with the caption "Ledger balance in base currency". Bank Summary for the same date lists the same two ledger balances and ends with Total Balance 79,537.50, in the screen, the PDF and the Excel file. The bank's statement for the USD account is in USD, so you enter its USD ending balance when you reconcile it; that figure is never added to the AED total. A USD supplier payment of USD 1,000.00 at 3.6700 moves the bank ledger by AED 3,670.00 and the USD quantity by 1,000.00; the exchange difference against the bill is posted on separate lines, not on the bank line (see Multi-currency).

Permissions and plan

Plan features: Bank Accounts, Import Bank Statements, Bank Reconciliation and Bank Auto-Rules (Professional). Imports, rules and reconciliation also require bank reconciliation to be enabled for your organization.

Tips

• Import the statement first, then click Start Reconciliation on the Done page. The dates and ending balance are filled in for you.
• Choose Windows-1256 encoding for CSV files from UAE banks that contain Arabic descriptions.
• Moving money between your own accounts is a Transfer payment. See Payments.

Related

• Payments · Cheques
• Chart of accounts · Journals
• Fiscal years & lock dates
• Reports