Reconcile supplier e-invoices with your bills

Audience: Owners and accountants Time: 2 minutes

Your suppliers file e-invoices to your TIN, and envoice copies them into Purchases. Reconcile puts them next to the bills you recorded in your own books, so you can see which bills have a valid e-invoice and which do not.

Reconcile with the four groups, a sandbox demo with example data

1. Get your bill list

Export your supplier bills (purchase invoices) for the period from your accounting system as CSV or Excel. The file needs these columns, with any header names:

Column Example
Supplier TIN C10000000010
Supplier name Demo Office Mart
Supplier's invoice number (the number on their bill, not your own reference) INV-20261006-D60
Bill date 06/10/2026
Total including tax 2,737.54

If your file has no TIN column, envoice matches by supplier name instead. Dates are read day first, so 03/04/2026 is 3 April. Title rows at the top and a totals row at the bottom are fine.

If your shop is connected to Zoho Books, you can skip the file and click Pull from Zoho Books. envoice reads the bills dated in your period and each vendor's TIN. Draft and void bills are left out.

2. Run the check

  1. Open Purchases and click Reconcile.
  2. Pick the bill dates, up to 92 days. The last full month is filled in for you.
  3. Choose your file. envoice picks the columns from the header row; change any that look wrong. The sample shows the first rows as envoice reads them.
  4. Click Reconcile.

If a row cannot be read, envoice lists every row and field to fix. Fix them in the file and upload it again.

3. Read the result

Every bill and every e-invoice lands in one group:

Group Meaning What to do
Matched Same supplier, same invoice, same day, amount within 5 sen Nothing
Differs Same invoice, but the amount or the date is different Check with the supplier. If their e-invoice is wrong, ask them to cancel it and file again
No e-Invoice A bill in your books with no valid e-invoice from LHDN Ask the supplier to file one. If the supplier is exempt or abroad, you may need to issue a self-billed e-invoice
Not in your books An e-invoice from LHDN with no bill in your books Record the bill. If it is not yours, open it and click Reject within 72 hours of validation

envoice treats invoice numbers the same when only case, spaces, punctuation or leading zeros differ, so inv/00123 matches INV-123. When the numbers differ completely, it matches on the same supplier, the same amount and a date within 3 days, and says so on the row.

A bill whose e-invoice was cancelled or rejected shows under No e-Invoice, because the supplier owes you a new one. Self-billed e-invoices are left out, because there you are the seller.

The result follows Purchases: when you refresh Purchases or reject a document, Reconcile updates without a new upload.

4. Export or start again

  • Export CSV or Export Excel downloads the group and search you are looking at.
  • New check runs another period or file. It replaces the last one.
  • Clear deletes the bill list now. envoice keeps it for 30 days otherwise.