Question 1

Which file do I get from the tax portal?

Accepted Answer

On the e-invoice portal, search your purchase or sales invoices for the period and choose "Export Excel". Upload that file as is — title rows at the top are fine.

Question 2

My columns have different names. Will it still work?

Accepted Answer

Yes. The tool guesses the columns from their names, and you can pick the right column for each field if a guess is wrong.

Question 3

My records have no invoice number (each row is a line item). What do I do?

Accepted Answer

Choose "Date + buyer tax code" instead of "Invoice number". Amounts are added up per buyer per day on both sides and compared, with no invoice number needed. Note: if an invoice is dated differently between the two files (e.g. issued late at night but recorded the next day), that amount may show up as a mismatch even though it is really the same buyer.

Question 4

Matching by "Date + buyer tax code" reports a lot of differences — do I have to check every one by hand?

Accepted Answer

No. Rows labelled "Possibly just a date difference" have already been checked: that buyer's total for the period is equal on both sides, only the recorded date differs between the tax portal and your records — not a real error. You only need to check the rows without that label.

Question 5

My records cover several months but the tax file has only one. Is that OK?

Accepted Answer

Yes. With an invoice date column, only invoices from the months on the tax list are compared and the other months in your records are left out. You can also pick the months yourself under "Period".

Question 6

One invoice is split over several lines in my file. Is that OK?

Accepted Answer

Yes. Lines with the same invoice number, symbol and seller tax code are added up before comparing.

Question 7

Why do some amounts count as matching when they differ slightly?

Accepted Answer

Small rounding differences are allowed. Set "Allowed difference" to 0 to require exact amounts.

Question 8

Can I reconcile sales invoices too?

Accepted Answer

Yes. On sales invoices the seller tax code is your own, so set that column to "Not used" and match by symbol and invoice number.

Invoice Reconciliation

How to reconcile invoices

Frequently asked questions

More Accounting tools