Once you have either imported a bank statement by uploading a csv file or by using the Bank Feeds and you are on the Bank Reconciliation screen, for unrecorded bank transaction such as bank fees, charges or interests, you can manually post the equivalent cash book transactions using the Create Transactions button.
You can also use the same button to post a cash book transaction for the difference between selected bank statement and cash book transactions.
Access the Create Transactions button
Click Financials the click Bank Reconciliation.
Type in or select the bank account you wish to work with from the Bank Account.
Note: You must know the first few characters of the nominal code or name as this search is what we refer to as a "Begins With" search.
You can also select the Show More option which gives you a larger list of records and more advanced filtering.
To open the filters, hover over the label of the columns until you see 3 small horizontal lines, then click on the 3 small horizontal lines to open the Filtering popup where you can select the relevant filtering option you want to work with.
Click on Confirm Selection.
The Bank Reconciliation screen refreshes and displays all transactions and statements that are relevant for the selected account.
Click on the Unmatched tab to gain access to the Create Transactions button which is at the bottom of the screen.
Once you are on the Unmatched tab, you can use the Create Transactions button in one of the following ways:
Create different type transactions using the Create Transactions button
Select the checkbox in front of the bank statement you wish to work with.
Click on the Create Transactions button and select the relevant transaction type from the list.
Note: The Date, Value and Reference fields are prepopulated for you on the cash book transactions and you just have to specify the supplier, customer or nominal code needed.
You can also allocate any customer and or supplier transactions created by using the Allocate Transaction Now options on the Save Options screen.
Once you have saved the transaction, you are redirected to the Cash Allocation screen where your previously posted transaction will be selected for you ready to be processed.
After you have processed your allocations, you will be returned to the Bank Reconciliation screen to continue the reconciliation process of the cash book account and statement you were working on.
Click the Bank Reconciliation button on the top of the screen to match your newly created transaction with the bank statement.
Create a transaction for the difference between bank statement and cash book transactions
You can use this option when the amount on the bank statement doesn't fully match the transactions in the cash book and you wish to post the missing amount without having to calculate it manually.
Select the checkbox in front of the bank statement or transactions you wish to work with.
Then select the checkbox in front of the cash book transaction or transactions you wish to work with.
Click on the Create Transactions button and select the relevant transaction type from the list.
The difference is only calculated when you have selected at least one bank statement transaction, at least one cash book transaction and the difference between them is at least 0.01.
If you have only selected bank statement transactions, the cash book transactions are created based on the individual bank statement amounts as described in the section above.
Click the Bank Reconciliation button on the top of the screen to match your newly created transaction with the bank statement and cash book transactions.
The Bank Reconciliation option is available throughout the full bank reconciliation process and you can click it on demand. All matches are displayed for you under the Matched tab where you can review, accept and reconcile or reject them.