Bank Reconciliation Transaction Types

All of the instructions below stem from the Bank Reconciliation Tool. Choose the relevant transaction, click on the Actions button and then follow the steps below according to the transaction type.

1. Payments against Purchase Order / Purchase Invoice

For these transactions, a Payment Entry first needs to be created against the relevant Purchase Invoice. Then, at the bank reconciliation tool, select 'Match Against Voucher' and 'Payment Entry' under Filters and choose the relevant Payment Entry. See below:

*If electronic invoice was received, remember to attach it to the Purchase Invoice or Journal Entry on ERPNext.

2. Receipts against Sales Invoice

Once a payment is received, first create a payment entry against the Sales Invoice. Then, at the Bank Reconciliation Tool, select 'Match Against Voucher' and 'Payment Entry' under Filters. Select the relevant Payment Entry and click on Submit. See below and example here.

3. Donations

Select 'Create Voucher' and 'Journal Entry' as the voucher type.

Journal Entry Type is Bank Entry and Account is Donations.

Ensure that dates and amounts are correct, see below:

4. Ad-hoc bank transactions

Select 'Create Voucher' and 'Journal Entry' as the voucher type.

Journal Entry Type is Bank Entry, please choose Account according to the type of expense.

Ensure that dates and amounts are correct, see below:

Examples: fuel purchases and maintenance expenses.

*If the supplier is a regular supplier and you would like to keep track of transactions with said supplier, please select 'Supplier' in the Party Type field and select the applicable supplier. Create a new supplier record if they do not exist on the system yet.

**If the invoice also includes VAT:

Click on the 'Edit in Full Page' button:

In the Accounting Entries table, click on Add Row and add the amount applicable for VAT:

Ensure that dates are correct and references are specified, then submit.