Excel GST & Tax Dashboard Templates
A gST & Tax dashboard tracks taxable sales, output tax, input credit and filing status so returns are never a last-minute rush. Pick your industry below to see a live preview of the Excel version.
Choose your industry
Retail GST & Tax DashboardExcel · $29E-commerce GST & Tax DashboardExcel · $29SaaS GST & Tax DashboardExcel · $29Restaurant GST & Tax DashboardExcel · $29Café & Bakery GST & Tax DashboardExcel · $29Hotel GST & Tax DashboardExcel · $29Real Estate GST & Tax DashboardExcel · $29Construction GST & Tax DashboardExcel · $29Manufacturing GST & Tax DashboardExcel · $29Logistics GST & Tax DashboardExcel · $29Clinic GST & Tax DashboardExcel · $29Hospital GST & Tax DashboardExcel · $29Dental Practice GST & Tax DashboardExcel · $29Pharmacy GST & Tax DashboardExcel · $29Gym & Fitness GST & Tax DashboardExcel · $29Salon & Spa GST & Tax DashboardExcel · $29Coaching Institute GST & Tax DashboardExcel · $29School GST & Tax DashboardExcel · $29University GST & Tax DashboardExcel · $29Marketing Agency GST & Tax DashboardExcel · $29Consulting GST & Tax DashboardExcel · $29Law Firm GST & Tax DashboardExcel · $29Accounting Firm GST & Tax DashboardExcel · $29Insurance GST & Tax DashboardExcel · $29Banking GST & Tax DashboardExcel · $29Fintech GST & Tax DashboardExcel · $29Automotive GST & Tax DashboardExcel · $29Car Dealership GST & Tax DashboardExcel · $29Agriculture GST & Tax DashboardExcel · $29Food Processing GST & Tax DashboardExcel · $29FMCG Distribution GST & Tax DashboardExcel · $29Wholesale GST & Tax DashboardExcel · $29Kirana Store GST & Tax DashboardExcel · $29Fashion & Apparel GST & Tax DashboardExcel · $29Jewellery GST & Tax DashboardExcel · $29Electronics Store GST & Tax DashboardExcel · $29Furniture GST & Tax DashboardExcel · $29Pharma GST & Tax DashboardExcel · $29Telecom GST & Tax DashboardExcel · $29Solar & Energy GST & Tax DashboardExcel · $29Non-profit GST & Tax DashboardExcel · $29Events GST & Tax DashboardExcel · $29Travel Agency GST & Tax DashboardExcel · $29Media & Publishing GST & Tax DashboardExcel · $29Gaming GST & Tax DashboardExcel · $29Creator Business GST & Tax DashboardExcel · $29Freelancer GST & Tax DashboardExcel · $29Startup GST & Tax DashboardExcel · $29IT Services GST & Tax DashboardExcel · $29Security Services GST & Tax DashboardExcel · $29Cleaning Services GST & Tax DashboardExcel · $29Printing & Packaging GST & Tax DashboardExcel · $29Pet Care GST & Tax DashboardExcel · $29
KPIs in every gST & Tax dashboard
| KPI | What it tells you | Formula |
|---|---|---|
| Taxable sales | Sales on which GST or sales tax applies. | SUM of taxable invoice value |
| Output tax | Tax collected on your sales. | SUM of (Taxable value × Rate) |
| Input tax credit | Tax paid on purchases that you can claim back. | SUM of eligible tax on purchase invoices |
| Net tax payable | Tax left to pay after input credit. | Output tax − Input tax credit |
| Invoices issued | Tax invoices raised in the period. | COUNT of invoices |
| B2B share | Share of sales made to registered businesses. | B2B taxable value ÷ Total taxable value |
| Returns filed on time | Share of returns filed by the due date. | Returns on time ÷ Returns due |
| Mismatched invoices | Purchase invoices that do not match the supplier's filing. | COUNT of invoices not matched in reconciliation |