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
Action | Procedure |
---|---|
To import a bank statement | Select 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
Action | Procedure |
---|---|
To view application proposals | Select Matching > Application Proposals. View or edit payment application proposals created by automatic matching. |
To apply entries | Select Manual Application > Apply Entries. Apply payments to open entries or manually match bank statement lines with open ledger entries. |
To match lines manually | Select Matching > Match Manually. |
To remove a match | Select Matching > Remove Match. |
To view match details | Select Matching > Match Details. |
To add a search rule | Select Rules > Add Search Rule. Automatically adds a new rule based on the Description field and account information of the bank statement line. |
To match automatically | Select Home > Match Automatically. Search and match bank statement lines with open ledger entries based on rules. |
To process pending direct debit returns | Select Home > Process Pending Direct Debit Returns. |
To transfer difference to journal | Select 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 rule | Select Manual Application > Create Journal Line from Search Rule. Create a journal line based on the search rule matched to this line. |
Manual handling actions
Action | Procedure |
---|---|
To set manual handling | Select Manual Application > Set Manual Handling. Sets the reconciliation status to Manual on a bank account reconciliation line. |
To remove manual handling | Select Manual Application > Remove Manual Handling. Sets the reconciliation status to Unsolved on a bank account reconciliation line. |
To create a manual journal line | Select 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
Action | Procedure |
---|---|
To show bank transaction details | Select Related > Show Bank Transaction. View the data imported from the bank related to the reconciliation. |
Rules management actions
Action | Procedure |
---|---|
To apply a split rule | Select Rules > Apply Split Rule. Apply a split rule to the reconciliation line, dividing it into multiple lines. |
To manage search rules | Select Rules > All Search Rules/Customer Search Rules/Vendor Search Rules/Employee Search Rules/G/L Account Search Rules. |
To manage related party rules | Select Rules > Related Party Rules. View or edit rules for identifying accounts based on bank account information. |
To manage payment reference rules | Select Rules > Payment Reference Rules. View or edit rules for matching entries by payment reference. |
To manage direct debit return rules | Select Rules > Direct Debit Return Rules. View or edit rules for handling direct debit returns. |
Journal actions
Action | Procedure |
---|---|
To view the cash receipt journal | Select Journals > Cash Receipt Journal. View or edit the cash receipt journal lines created by reconciliation. |
To view the general journal | Select Journals > General Journal. View or edit the general journal lines created by reconciliation. |
To view the payment journal | Select Journals > Payment Journal. View or edit the payment journal lines created by reconciliation. |
To post all journal lines | Select Journals > Post All Journal Lines. Post all journal lines created by the reconciliation. |