Reconciling bank statement lines manually
With Continia Banking, when bank statements are imported, transactions are matched to customer, vendor and employee ledger entries, and the corresponding journal line is created. However, some transactions might be new and previously unknown, requiring the journal line to be created manually based on the transaction in the statement. For such transactions, journal lines are created solely from the statement data. In these cases, users can manually transfer a Bank Acc. Reconciliation Line to a journal, post the entry, and reconcile it automatically.
On the Banking Import Setup page, on the Bank Account Reconciliation FastTab, the Manual Handling section allows you to specify the actions to be taken when handling a line manually. The following fields are available:
- Show Dialog - a boolean setting that lets the user choose whether to display the manual reconciliation dialog during the import process. The default value is true.
- Default Journal Type - specifies the default journal type to use when creating a manual journal line. Options include Account Type, Cash Receipts, General, and Payments. The default value is General. If Account Type is selected, the template type is determined by the account type of the bank account statement line.
To manually transfer a line to a journal
If you have a bank statement line that needs to be transferred manually, you can select the account to post the journal line to, either on the Bank Acc. Reconciliation Line or in the journal after the line is created.
To manually transfer a line to a journal:
- On the Bank Acc. Reconciliation page, navigate to the bank statement line that you want to transfer and, on the action bar, select Manual Application > Set Manual Handling. This will change the Reconciliation Status to Manual (this can only be done for lines with status Unsolved)
- Mark the lines you want to transfer and on the action bar, select Manual Application > Create Manual Journal Line.
If you enabled the Show Dialog option on the Banking Import Setup page, the dialog will contain settings similar to those for handling amount differences:
- The amount field will automatically display the Statement Amount from the Bank Acc. Reconciliation Line.
- The Journal Template Type field will be prefilled with the default setting, but you can change it if needed.
- You will need to select the appropriate account in the Account Type and Account No. fields for the journal line.
- Ensure that the selected G/L Account allows direct posting.
- The Description field will be prefilled with the description from the Bank Acc. Reconciliation Line, which you can modify as necessary.
- Complete the process as needed.