Google Sheets 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 Google Sheets version.
Choose your industry
Retail GST & Tax DashboardGoogle Sheets · $29E-commerce GST & Tax DashboardGoogle Sheets · $29SaaS GST & Tax DashboardGoogle Sheets · $29Restaurant GST & Tax DashboardGoogle Sheets · $29Café & Bakery GST & Tax DashboardGoogle Sheets · $29Hotel GST & Tax DashboardGoogle Sheets · $29Real Estate GST & Tax DashboardGoogle Sheets · $29Construction GST & Tax DashboardGoogle Sheets · $29Manufacturing GST & Tax DashboardGoogle Sheets · $29Logistics GST & Tax DashboardGoogle Sheets · $29Clinic GST & Tax DashboardGoogle Sheets · $29Hospital GST & Tax DashboardGoogle Sheets · $29Dental Practice GST & Tax DashboardGoogle Sheets · $29Pharmacy GST & Tax DashboardGoogle Sheets · $29Gym & Fitness GST & Tax DashboardGoogle Sheets · $29Salon & Spa GST & Tax DashboardGoogle Sheets · $29Coaching Institute GST & Tax DashboardGoogle Sheets · $29School GST & Tax DashboardGoogle Sheets · $29University GST & Tax DashboardGoogle Sheets · $29Marketing Agency GST & Tax DashboardGoogle Sheets · $29Consulting GST & Tax DashboardGoogle Sheets · $29Law Firm GST & Tax DashboardGoogle Sheets · $29Accounting Firm GST & Tax DashboardGoogle Sheets · $29Insurance GST & Tax DashboardGoogle Sheets · $29Banking GST & Tax DashboardGoogle Sheets · $29Fintech GST & Tax DashboardGoogle Sheets · $29Automotive GST & Tax DashboardGoogle Sheets · $29Car Dealership GST & Tax DashboardGoogle Sheets · $29Agriculture GST & Tax DashboardGoogle Sheets · $29Food Processing GST & Tax DashboardGoogle Sheets · $29FMCG Distribution GST & Tax DashboardGoogle Sheets · $29Wholesale GST & Tax DashboardGoogle Sheets · $29Kirana Store GST & Tax DashboardGoogle Sheets · $29Fashion & Apparel GST & Tax DashboardGoogle Sheets · $29Jewellery GST & Tax DashboardGoogle Sheets · $29Electronics Store GST & Tax DashboardGoogle Sheets · $29Furniture GST & Tax DashboardGoogle Sheets · $29Pharma GST & Tax DashboardGoogle Sheets · $29Telecom GST & Tax DashboardGoogle Sheets · $29Solar & Energy GST & Tax DashboardGoogle Sheets · $29Non-profit GST & Tax DashboardGoogle Sheets · $29Events GST & Tax DashboardGoogle Sheets · $29Travel Agency GST & Tax DashboardGoogle Sheets · $29Media & Publishing GST & Tax DashboardGoogle Sheets · $29Gaming GST & Tax DashboardGoogle Sheets · $29Creator Business GST & Tax DashboardGoogle Sheets · $29Freelancer GST & Tax DashboardGoogle Sheets · $29Startup GST & Tax DashboardGoogle Sheets · $29IT Services GST & Tax DashboardGoogle Sheets · $29Security Services GST & Tax DashboardGoogle Sheets · $29Cleaning Services GST & Tax DashboardGoogle Sheets · $29Printing & Packaging GST & Tax DashboardGoogle Sheets · $29Pet Care GST & Tax DashboardGoogle Sheets · $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 |