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 Journal, general journal, 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. For more information, 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.
  • Show more columns/actions – customize the page by showing additional data columns or actions via the Page tab.
  • Post Multiple Applications as one sum Entry - this setting on the Banking Import Setup page allows you to handle multiple applications for the same account as one summarized entry during payment reconciliations when posted. See Posting multiple applications as one sum entry.

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

The actions available on the Bank Acc. Reconciliation page

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

Import actions

ActionProcedure
To import a bank statementClick 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 proposalsClick Matching > Application Proposals. View or edit payment application proposals created by automatic matching.
To apply entriesClick Manual Application > Apply Entries. Apply payments to open entries or manually match bank statement lines with open ledger entries. Using Shift + F11 also opens the Apply Entries page.
To match lines manuallyClick Matching > Match Manually.
To remove a matchClick Matching > Remove Match.
To force remove matchClick Actions > Matching > Other > Force Remove Match. Convenient when the reconciliation line no longer exists and the ledger entry is stuck.
To view match detailsClick Matching > Match Details.
To add a search ruleClick Rules > Add Search Rule. Automatically adds a new rule based on the Description field and account information of the bank statement line.
To match automaticallyClick Home > Match Automatically. Search and match bank statement lines with open ledger entries based on rules.
To process pending direct debit returnsClick Home > Process Pending Direct Debit Returns.
To transfer difference to journalClick 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 ruleClick 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 handlingClick Manual Application > Set Manual Handling. Sets the reconciliation status to Manual on a bank account reconciliation line.
To remove manual handlingClick Manual Application > Remove Manual Handling. Sets the reconciliation status to Unsolved on a bank account reconciliation line.
To create a manual journal lineClick 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 detailsClick Related > Show Bank Transaction. View the data imported from the bank related to the reconciliation.

Rules management actions

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

Journal actions

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