Match bank imports to invoices
Description
Cause
Resolution

Use Match, Create, or Transfer to process bank feed transactions and imported statement lines.

1. Match

  1. Select Match to match the imported transaction to one or more invoices.
  2. Review invoices, payments, receipts, and credit notes.
  3. Select a column header to sort by
    Date
    Number
    Contact
    Type
    Reference
    Due Date
    Amount
    Outstanding


  4. Use the search field to find a matching transaction.
  5. Select the checkbox beside each transaction you want to match.
  6. Confirm that Left to match equals 0.
  7. Select Make adjustment to record fees or differences, if required.
  8. Select Match.
 Matched transaction results
  • Sage Accounting clears matched unpaid invoices in banking activity
  • Paid invoices deleted from the bank feed don’t show as cleared in banking activity

Create a payment on account from the bank feed when no invoice, payment, or receipt exists.

  1. Select New Transaction.
  2. Select Payment on Account.
  3. Select Add.

Match the payment on account to the invoice later.

2. Create

Use Create to record a payment or receipt before you allocate it to an invoice.

  1. In For, select the customer or vendor.
  2. In What, select Payment on Account or Other Payment.
  3. Select Tax Rate, if applicable.
  4. Select Create.
Use this option when:
  • The amount paid or received doesn’t match the invoice
  • The invoice still needs allocation to a credit note

Allocate the payment on account after Sage Accounting records it in the customer or supplier account.

3. Transfer

Use Transfer to record a bank transfer between accounts.

NOTE:

Don’t record cash deposits with Transfer. Discard the transaction, then record it manually from the cash account.

 

Correct an Other Payment or Other Receipt
  1. Delete the incorrect Other Payment or Other Receipt from banking activity.
  2. Record the description, amount, and date before you delete it.
  3. Create the correct Expense Payment or Customer Receipt from Banking.
  4. Allocate the new payment or receipt to the invoice.

Transactions created from Banking or from an invoice don’t show as cleared in banking activity.

Steps to duplicate
Related Solutions