Introducing Bank Account Reconciliation

The Bank Account Reconciliation page helps you match bank statement transactions with ledger entries, including customer, vendor, employee, and bank account entries.

Unlike the Payment Reconciliation Journal, which reconciles entries directly in the journal, Bank Account Reconciliation transfers multiple entries into the Cash Receipt, General, or Payment journals for posting.

You can choose to work with either Bank Account Reconciliation or the Payment Reconciliation Journal depending on your reconciliation workflow needs.

Note

If you use Continia Finance's G/L Open Entries module, you can reconcile G/L open entries during import, either automatically or manually.

Continia Banking enhancements to Bank Account Reconciliation

Continia Banking extends the standard Bank Account Reconciliation page with the following advanced features:

  • Automatic matching – matches bank statement transactions with open ledger entries using configurable rules. See Introducing reconciliation with Continia Banking for more information about the matching procedure.
  • Import – import and match bank statement transactions manually or automatically.
  • Payment application proposals – a centralized Payment Application Review page where the system generates suggested matches between payments and ledger entries, with visual indicators for match criteria. You can review and apply these proposals, view full transaction details, and track reconciliation status. See Working with payment application proposals.
  • Error prevention – validation prevents duplicate applications and highlights already-applied entries.
  • Reconciliation line detail – provides a detailed view of transaction data, charges, matching status, and available actions. See Viewing and editing reconciliation line details.
  • Rules – includes search rules, split rules, payment reference rules and more to improve matching accuracy, automate reconciliation, and support advanced scenarios.
  • Journal integration – integration with Cash Receipt, General, and Payment journals. Journal lines created during reconciliation can be reviewed and posted directly.
  • Show more columns/actions – customize the page by showing additional data columns or actions via the Page tab.

When you configure a bank account in Bank Account Reconciliation using Continia Banking, these enhancements become available.

The actions available on the Bank Account Reconciliation page

The Bank Account Reconciliation page provides actions for importing, matching, posting, and reviewing transactions.

Import actions

ActionProcedure
To import a bank statementSelect Home > Import and Match Bank Statement/Import New Bank Statement/Import Existing Bank Statement. To see these actions, first select Page > Show More Actions.

Matching and application actions

ActionProcedure
To view application proposalsSelect Matching > Application Proposals. View or edit payment application proposals created by automatic matching.
To apply entriesSelect Manual Application > Apply Entries. Apply payments to open entries or manually match bank statement lines with open ledger entries.
To match lines manuallySelect Matching > Match Manually.
To remove a matchSelect Matching > Remove Match.
To view match detailsSelect Matching > Match Details.
To add a search ruleSelect Rules > Add Search Rule. Automatically adds a new rule based on the Description field and account information of the bank statement line.
To match automaticallySelect Home > Match Automatically. Search and match bank statement lines with open ledger entries based on rules.
To process pending direct debit returnsSelect Home > Process Pending Direct Debit Returns.
To transfer difference to journalSelect Manual Application > Transfer Difference to Journal. Transfers the amount difference from the bank account reconciliation line to a journal line.
To create a journal line from a search ruleSelect Manual Application > Create Journal Line from Search Rule. Create a journal line based on the search rule matched to this line.

Manual handling actions

ActionProcedure
To set manual handlingSelect Manual Application > Set Manual Handling. Sets the reconciliation status to Manual on a bank account reconciliation line.
To remove manual handlingSelect Manual Application > Remove Manual Handling. Sets the reconciliation status to Unsolved on a bank account reconciliation line.
To create a manual journal lineSelect Manual Application > Create Manual Journal Line. Transfers the amount from the bank account reconciliation line to a journal line for manual reconciliation.

Review and details actions

ActionProcedure
To show bank transaction detailsSelect Related > Show Bank Transaction. View the data imported from the bank related to the reconciliation.

Rules management actions

ActionProcedure
To apply a split ruleSelect Rules > Apply Split Rule. Apply a split rule to the reconciliation line, dividing it into multiple lines.
To manage search rulesSelect Rules > All Search Rules/Customer Search Rules/Vendor Search Rules/Employee Search Rules/G/L Account Search Rules.
To manage related party rulesSelect Rules > Related Party Rules. View or edit rules for identifying accounts based on bank account information.
To manage payment reference rulesSelect Rules > Payment Reference Rules. View or edit rules for matching entries by payment reference.
To manage direct debit return rulesSelect Rules > Direct Debit Return Rules. View or edit rules for handling direct debit returns.

Journal actions

ActionProcedure
To view the cash receipt journalSelect Journals > Cash Receipt Journal. View or edit the cash receipt journal lines created by reconciliation.
To view the general journalSelect Journals > General Journal. View or edit the general journal lines created by reconciliation.
To view the payment journalSelect Journals > Payment Journal. View or edit the payment journal lines created by reconciliation.
To post all journal linesSelect Journals > Post All Journal Lines. Post all journal lines created by the reconciliation.