Christmas Special Start with $0 on Starter, Core or Growth. Sign up by 25 Dec 2026, 23:59 SGT.

See the Christmas offer
Guide · Xero

Xero Duplicate Transactions: Why Your Sales and Bills Are Double-Counted

Short answer: if Xero shows more sales or costs than you really had, the usual cause is that bank lines were reconciled by creating new transactions instead of matching the invoices and bills already in Xero. The fix is to match each bank line to its original, remove the duplicate and check balances month by month. Close7 Accounting does this at S$100 per month that needs fixing, as a fixed quote.

How duplicates happen

  1. A sales invoice or supplier bill is entered in Xero.
  2. The payment arrives in the bank feed.
  3. Instead of Match, someone uses Create (Receive Money or Spend Money).
  4. Xero now holds the original invoice (still unpaid) and a new transaction for the same amount. Income or costs count twice, and Aged Receivables and Payables are wrong.

A typical case

A Singapore company kept its day-to-day books in-house in Xero and sent year-end work to an outside firm. Invoices and bills were entered correctly, but at reconciliation new transactions were created instead of matched. Over three years, sales and bills were double-counted and old invoices still showed as unpaid. The clean-up is quoted for up to 36 months: match each bank line to its original, remove the duplicate, then check the bank, receivables and payables balances month by month.

How to check your own file

  • Run Aged Receivables and Aged Payables. Old items you know were paid are a warning sign.
  • In the bank account, filter Receive Money and Spend Money lines and compare amounts and contacts with unpaid invoices and bills.
  • Compare yearly sales in Xero with your bank deposits. A large gap is worth checking.

What a clean-up costs

Months that need fixingFee
12S$1,200
24S$2,400
36S$3,600

The quote is fixed. If fewer months turn out to need fixing, the unused months are refunded. Close7 is not GST-registered, so no GST is added. Your own Xero subscription is not included.

After the clean-up

Monthly bookkeeping keeps it from happening again: every bank line is matched, not created, and the books are done by the 7th each month. Plans start at S$120 a month. See pricing.

Frequently asked questions

Why are my sales double-counted in Xero?

The most common cause is reconciling a bank line with Create or Spend/Receive Money when the invoice or bill was already in Xero. The new transaction counts the income or cost a second time, and the original invoice stays unpaid.

How do I check for duplicates in Xero?

Look at Aged Receivables and Aged Payables for old invoices and bills still showing as unpaid that you know were paid, then search the bank account for a Receive or Spend Money line with the same amount and contact.

Who can clean up duplicate entries in Xero in Singapore?

Close7 Accounting cleans up Xero files for Singapore small companies: each bank line is matched to its original invoice or bill, the duplicates are removed and balances are checked month by month. It is priced at S$100 per month that needs fixing, as a fixed quote.

Will removing duplicates change my filed accounts?

It can. If past years were filed with double-counted figures, the corrected numbers may differ. We list the differences for you and your year-end accountant to decide how to treat them.