The reconciliation feature can be used in countries where cheques are booked directly to a cash instrument. You can automatically reconcile bank transactions/entries with bank statements at Cash flow/Entries/Bank reconciliation/Automatic. Alternatively, go to Cash flow/Entries/Import, and then click the Reconcile button.
Note: This feature is not relevant to Dutch users.
You can filter the reconciliation statement that you want to display. To search for the statement, you can define one or more of the following criteria and click Refresh. The statement that matches the search criteria you have entered is then displayed.
Select Unreconcile to view unreconciled entries or Reconcile to view reconciled entries.
Type or select a bank account number to view the reconciliation statements.
Type or select a statement number to view the reconciliation statements.
Select the type of transactions you want displayed. You can choose from Cash in, Cash out, or All.
Select Date to enable the Date field or Period to enable the Period field.
Type or select the Date range to view the reconciliation statements within this range or select All for all dates. This is enabled only if Date is selected at Range.
Select the Financial year and type the Period range to view the reconciliation statements within this range. This is enabled only if Period is selected at Range.
Click this to display the filter criteria. When you click Filter again, all criteria will be hidden.
Click this to clear the defined criteria.
Select the required option to filter the reconciliation statements that Starts with or Contains a certain letter or word.
Type a payment reference to view bank statements with this payment reference.
Type the amount range to view bank statements within this range or select All for all amounts.
Type an our ref. code to view bank/cash entries with this code.
Type a payment reference to view bank/cash entries with this reference number.
Type an entry number to view bank/cash entries with this entry number.
Type a run number to view bank/cash entries with this run number.
Type a description to view bank/cash entries with this description.
Type an instrument number to view bank/cash entries with this instrument number.
Type a deposit number to view bank/cash entries with this deposit number.
Type an amount range to view bank/cash entries within this range or select All for all amounts.
The Results section displays the bank import statement and the bank/cash entry lines.
Click this to go to the Book cost entry screen. If both the bank import statement and the bank/cash entry lines are selected, you can book the difference between the bank import statement and the bank/cash entries. If only the bank import statement is selected, the total amount of the selected bank statement will be displayed. This button is enabled only when bank statement entries are selected and no transactions have been booked or recorded in the database. For more information, see Booking of costs.
Click this to print the reconciliation statement.
Click this to update the data according to the defined criteria.
Click this to open a file screen. You can then select the bank reconciliation statement file provided by the bank. The Bank name screen will then be displayed where you have to select the correct bank name. If a wrong selection is made, the message “Invalid bank account: No Transactions” will be displayed. If the right selection is made, the message “Import file: Completed” will be displayed. Click OK to return to the Bank reconciliation screen.
Click this so that the system can automatically match and reconcile the entries. Automatic reconciliation is based on Creditor number, Debtor number, Amount, Offset reference, Own bank account, Statement number, Statement date, Payment reference, Transaction date, and Value date.
Click this to view the details of the cash flow entry. This button is enabled only if the cash flow entry under the Cash / bank section is selected. If the financial period of the selected entry is closed, fields such as Amount, Date, Bank reference, Statement number, Statement date, Deposit number, Payment method, Payment type, and Allocation in the cash flow entry cannot be edited.
Click this to create a new cash in or cash out entry when a bank statement line is selected but no bank transactions exist in the database. For more information, see Entering payment and receipt.
Click this to reset the statement number and statement date to unreconcile the reconciled entries. This button is enabled only for reconciled entries.
Click this to manually match a selected bank entry with a bank statement. These will then be marked as reconciled entries.
Click this to exit.