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.

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
- Open Purchases and click Reconcile.
- Pick the bill dates, up to 92 days. The last full month is filled in for you.
- 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.
- 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.