How to process bank transactions from Bank Feeds or imported statements
Description

Use the Incoming Bank Transactions page to process transactions from bank feeds or bank statements.

Sage Accounting notifies you when transactions are ready. Select the linked transaction count on the bank tile to open Incoming Bank Transactions.

Cause
Resolution

How this works

Each transaction displays the date, amount, and reference. Payments leaving the account appear in red.

Choose how to process each transaction using Match, Create, or Transfer. Create bank rules to automate the processing of common transactions based on predefined criteria.

Read about bank rules in the article How to create and apply bank rules.

Match to existing transactions or pay invoices

Use Match to apply transactions to existing entries or invoices.

Match existing transactions

Confirm the bank transaction matches the transaction. This could be for a recorded transaction or an imported bank transfer.

  1. Select Match on the transaction.
  2. Review payments, receipts, and outstanding invoices.
  3. Use Search to filter results.
  4. Select matching transactions.
  5. When Left to match equals zero, select Match.

Pay outstanding invoices

Create a new customer receipt or supplier payment and use it to pay an outstanding invoice.

If we find any outstanding invoices that match the payment, we show these with a Match button on the right. We use the reference and amount to suggest these matches.

If we don't find a matching invoice, or you want to pay a different one:

  1. Select Match on the transaction.
  2. Review suggested invoices.
  3. Use Search to select different invoices, if required.
  4. When Left to match equals zero, select Match.

Overpayments

If you have leftover money after selecting invoices to pay, save it as a payment on account for future invoice allocation.

  1. Select New Transaction.
  2. Select Payment on Account.
  3. Enter the details and select Add.
  4. When Left to match equals zero, select Match.

Partial payments

  1. Enter the partial amount in the Payment field.
  2. When Left to match equals zero, select Match.

Add bank fees and interest

  1. Select Make Adjustment.
  2. Enter the charge details.
  3. Select Add.
  4. When Left to match equals zero, select Match.

Match refunds to credit notes

  1. Record the credit note before matching.
  2. Money In matches purchase credit notes.
  3. Money Out matches sales credit notes.

Create new transactions

Payment on account

Create payments or receipts without an invoice. The payment remains outstanding until allocation.

Payments on account can match invoices and bills from the Manage Allocations page.

  1. Select Create.
  2. Choose a contact in For.
  3. Select Payment on Account in What.
  4. Select Create.

Money Out

Use this option for expenses or bill payments.

  1. Select Create.
  2. Select a supplier in Who, if required.
  3. Select the correct category in What.
  4. Select Create.

Money In

Use this option for non‑invoice income, such as cash register receipts or grants. For money used to pay sales invoices, select Match to pay an existing invoice. To create the receipt, select the correct category.

  1. Select Create.
  2. Select a customer in Who, if required.
  3. Select the correct category in What.
  4. Select Create.

Refund a sale

Use this for cash refunds not linked to invoices or credit notes. This could be for money paid out from cash register receipts or money refunded to someone who isn’t a regular customer.
  1. Select Create.
  2. Select Create a refund.
  3. Select the customer in Who, if required.
  4. Select the category in What.
  5. Select Create.

To undo this action, select Revert back to sale.

Refund a purchase

Record refunds from suppliers or general purchases.

  1. Select Create.
  2. Select Create a refund.
  3. Select a supplier in Who, if required.
  4. Select the category in What.
  5. Verify the tax amount, if applicable.
  6. Select Create.

To undo this action, select Revert back to purchase.

Split transactions across categories

Split a single payment or receipt across multiple categories.

  1. Select Split.
  2. Add a line for each category.
  3. Confirm the totals match.
  4. Select Create.

Transfer between bank accounts

Use this option when moving funds between bank accounts.

  1. Select Transfer.
  2. Choose the account to Transfer to or Transfer from.
  3. Select Transfer.

Delete transactions

Remove unwanted transactions directly from the list.

  1. Select the transaction or transactions.
  2. Select Delete.

Fix problems with your incoming transactions

Missing transactions

Bank feeds update on varying schedules. The Incoming Transactions page displays the last update time at the top.

If the feed is current, check for a reauthorization request. Banks require reauthorization every 90 days.

Select Enter Credentials to re-authorize the bank feed.

Duplicate transactions

Bank errors or feed issues can cause duplicate transactions. Delete duplicates based on when you notice them:

Imported Discard from bank feed.
Created in Accounting Delete from bank account (Activity tab)
Before reconciliation Delete transactions
After reconciliation Delete from bank activity

 

Sage Accounting updates the next reconciliation starting balance automatically.

Read more about How to delete bank transactions.

What's next?

Create transactions with bank rules

Bank reconciliation

Steps to duplicate
Related Solutions