Process incoming bank transactions
Use the Incoming Bank Transactions page to process transactions imported from a bank feed or bank statement. This page opens automatically after you:
or
About transactions
Each transaction shows the date, amount and transaction details and is either a payment in or out of the account. You decide how to process it using the Match, Create, and Transfer buttons in the middle of the transaction. You can also split and delete transactions.
Using a bank feed is not mandatory, and you can still enter transactions manually using the Create, and New options from Banking
Note:
You won't be able to match multi-currency transactions that come in from a bank feed. You'll need to manually create them.
You can also select Create bank rule on any transaction to automatically create them based on predefined criteria on your next batch of incoming transactions.
Find out more about bank rules
We look for outstanding invoices during the download (or import) process and suggest any invoices that may match an payment. We show these with a Match button on the right.
For example, if a payment for £110.00 comes in from your bank, it may match an outstanding sales invoice for £110.00. If it's correct, select Match to apply the payment to the invoice. If it's incorrect, select Edit to fix it.
If a match isn't found but you think there is one, select Match to see a list of all outstanding invoices. You may need to do this if you receive a payment that covers more than one invoice. Select the invoice (or invoices) to match.
1. Select Match to show a list of your outstanding invoices.
|
|
2. Select the relevant invoices.
|
|
3. Edit as needed. Confirm the totals match and then select Match.
|
|
If no outstanding invoices were found but you think there is one, select Search to find it.
Partial payments, overpayments, bank fees, and refunds
There may be special payment situations to consider when matching transactions to outstanding invoices. For:
-
Partial payments. Enter the amount of the incoming transaction in the Amount field and then select Match. The payment will be applied as long as you've entered the total payment amount.
-
Overpayments. If a customer has overpaid you or you have overpaid a supplier, partially pay the invoice and then enter the remainder as a payment on account.
|
1. Enter the amount of the partial payment in the Amount field.
|
|
|
|
2. Select New Transaction and then Add.
|
|
|
|
3. Select Payment on Account andthen Add. Select Match.
|
|
|
Note: The net status A bank transaction's net status determines its display in your feed. If a transaction, for example an outgoing payment, is the result of a payment for one invoice and a credit for another, then this will not show up in the list as a credit. If the rolled-up bank transaction is of this type, you should record a separate transaction for each element, and then discard the rolled up transaction to have each element show up on its own.
You cannot create a new refund from a bank feed.
If your refund is being used to pay a credit note, then match it to the credit note that it's paying.
For refunds that are not matched to credit notes, discard the transaction from your bank feed, then manually create the refund.
Enter money out as a cash refund
Enter money in as a cash refund
Payment on account
Money out or Money In
Use this to record money in or money out that is not being used to pay an invoice. Just
-
Select the relevant category from the What drop down list
-
Select Create.
Split transactions.
Use this when single payment needs to be split over several categories or has different VAT rates. You might have a single expense payment that covers petrol and office sundries for example.
If you use transaction analysis types, you can also select different categories for department, cost centre, and project. Select Split
to expand the transaction and then create a new line for each nominal account or VAT rate and amount. Make sure all of the lines add up and then select Create.
Use this when transferring money between bank accounts. This creates a transaction in both bank accounts. If both bank accounts use bank feeds, you'll need to discard or match the imported transaction from the other bank account.
- Select Transfer.
- Choose the bank account to Transfer to or Transfer from.
- Select Transfer.
If you have transactions you don't want, you can delete them. You may need to do this if you have bank transfers or transactions you've already imported or reconciled.
Select the transaction (or transactions) you want to delete and then select Delete.
Fix problems with your incoming transactions
Tip:
If you have missing transactions, keep in mind that most banks only send transactions once a day. So, there may be times when you see a transaction in your online banking service that isn't on the Incoming Bank Transactions page.
If you're still missing transactions or have duplicates, use the troubleshooting guide to fix the problem. The guide will help you identify your connection type and provide potential solutions. If a solution isn't available, you will be able to send a request for help directly from the guide.
Resolve issues with a bank feed