A downloadable Excel template for reconciling your sales ledger, EFRIS invoices and monthly VAT return — with built-in sanity checks.
This workbook ships with four tabs: sales ledger import, EFRIS envelope import, reconciliation worksheet, and the VAT-return reveal.
The sanity checks on the reconciliation worksheet are: total ledger sales = total EFRIS supply = Box 1 of the VAT return.
Any mismatch is a reconciliation break. The workbook flags each break with a traffic-light.
More for Finance teams.
Rates per supplier type, exemption handling, the common audit pitfalls, and a checklist for defending your return under URA review.
Read guideEighteen checkpoints — payroll run, PAYE compute, NSSF, Local Service Tax, journal, review, submit — in the right order.
Read guideFrom URA EFRIS enrolment to inbound envelope review to monthly reconciliation — the complete field guide.
Read guideWe publish new guides monthly. Tell us what topic you want to see.
