Power BI version coming soon. We are testing every Power BI file before we sell it. The Excel and Google Sheets versions of each dashboard are ready to download now.
Power BI 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 Power BI version.
Choose your industry
Retail GST & Tax DashboardPower BI · $49E-commerce GST & Tax DashboardPower BI · $49SaaS GST & Tax DashboardPower BI · $49Restaurant GST & Tax DashboardPower BI · $49Café & Bakery GST & Tax DashboardPower BI · $49Hotel GST & Tax DashboardPower BI · $49Real Estate GST & Tax DashboardPower BI · $49Construction GST & Tax DashboardPower BI · $49Manufacturing GST & Tax DashboardPower BI · $49Logistics GST & Tax DashboardPower BI · $49Clinic GST & Tax DashboardPower BI · $49Hospital GST & Tax DashboardPower BI · $49Dental Practice GST & Tax DashboardPower BI · $49Pharmacy GST & Tax DashboardPower BI · $49Gym & Fitness GST & Tax DashboardPower BI · $49Salon & Spa GST & Tax DashboardPower BI · $49Coaching Institute GST & Tax DashboardPower BI · $49School GST & Tax DashboardPower BI · $49University GST & Tax DashboardPower BI · $49Marketing Agency GST & Tax DashboardPower BI · $49Consulting GST & Tax DashboardPower BI · $49Law Firm GST & Tax DashboardPower BI · $49Accounting Firm GST & Tax DashboardPower BI · $49Insurance GST & Tax DashboardPower BI · $49Banking GST & Tax DashboardPower BI · $49Fintech GST & Tax DashboardPower BI · $49Automotive GST & Tax DashboardPower BI · $49Car Dealership GST & Tax DashboardPower BI · $49Agriculture GST & Tax DashboardPower BI · $49Food Processing GST & Tax DashboardPower BI · $49FMCG Distribution GST & Tax DashboardPower BI · $49Wholesale GST & Tax DashboardPower BI · $49Kirana Store GST & Tax DashboardPower BI · $49Fashion & Apparel GST & Tax DashboardPower BI · $49Jewellery GST & Tax DashboardPower BI · $49Electronics Store GST & Tax DashboardPower BI · $49Furniture GST & Tax DashboardPower BI · $49Pharma GST & Tax DashboardPower BI · $49Telecom GST & Tax DashboardPower BI · $49Solar & Energy GST & Tax DashboardPower BI · $49Non-profit GST & Tax DashboardPower BI · $49Events GST & Tax DashboardPower BI · $49Travel Agency GST & Tax DashboardPower BI · $49Media & Publishing GST & Tax DashboardPower BI · $49Gaming GST & Tax DashboardPower BI · $49Creator Business GST & Tax DashboardPower BI · $49Freelancer GST & Tax DashboardPower BI · $49Startup GST & Tax DashboardPower BI · $49IT Services GST & Tax DashboardPower BI · $49Security Services GST & Tax DashboardPower BI · $49Cleaning Services GST & Tax DashboardPower BI · $49Printing & Packaging GST & Tax DashboardPower BI · $49Pet Care GST & Tax DashboardPower BI · $49
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 |