Business Software Excel Templates Accounting, Retail & POS HR Management Customer Relations Management Marketing & Sales School Projects Data & Statistics Financial Plans & Projections Education Quick Office Tools PHP SCRIPTS How to Get Our Resources Blog

VAT and Company Income Tax Excel Template [Finance Act 2020 Updated]

2,920 130

2,500 | shub

Category: Accounting, Business Utitilties, Excel Templates


Value Added Tax (VAT) is a type of tax charged on Sales or Revenue made by an organization. It is indirect taxation mechanism adopted by the government to generate revenue via sales made by businesses.

Value Added Tax (VAT) or Sales Tax is currently 7.5% in Nigeria and the government expects businesses eligible to pay VAT to remit 7.5% of sales made from the 21st of every month. VAT is it is commonly called is mostly paid to the Federal Inland Revenue Service (FIRS) by corporate bodies montly

This Excel Template will save you the stress of calculating montly VAT remittances and Annual Corporate Income Tax (CIT). The VAT excel template captures Daily sales, Tracks expenditures and computes accurate amounts to be remitted monthly to the Federal Inland Revenue Service or any other tax body in Nigeria.

Small and emerging businesses will find this utility template useful for easy Value Added Tax (VAT) and Company Income Tax (CIT) computation.

The template will save you great cost, money and time as all features are programmed to be responsive to your feedback.


  1. Easy and User friendly interface.
  2. Current Tax rates and methodology in accordance to the FIRS Finance Act 2020 as amended.
  3. Monthly VAT Calculator. Annual CIT Computation.
  4. Easy Expense and Cost of Sales Tracking.
  5. Manual on How to Use Template.
  6. Input Model for Easy Customization.

MS Excel Template

MS Excel Template

Widget is loading comments...