How to reconcile a bank transaction that is both income and expenditure
If a bank transaction includes both income and expenditure (other than bank fees) for the total amount, you won't be able to reconcile it as one transaction.
Examples include:
- if you have rent income from and agency and a supplier refund from the same agency
- if you have net event income which actually represents gross income less money costs of the event
Top Tip: If you have a payroll payment that was made incorrectly, see this help guide article.
To reconcile the income and expenditure separately, you will first need to split it into two transactions which you can reconcile separately as income and expenditure.
Important: if your income transaction includes bank or processor fees, these can be reconciled using the Mixed Income functionality, and you do not need to follow the steps below.
These are the steps you should follow to split a bank transaction:
1. Click edit on the bank statement transaction
Within the View Statement screen, click the 'pencil' button to the right of the bank statement transaction (£1020.00)
2. Split the transaction into two:
- Paid Out Transaction for the expenditure amount (£1030)
- Paid In Transaction for the income amount (£10.00)
Reconcile Transactions
a. Reconcile the paid-out transaction as expenditure e.g. invoice payment, supplier refund
b. Reconcile the paid-in transaction as income e.g. other income, donation
To better understand the Bank Reconciliation module, please view the module overview video here.