Kpiloom

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

KPIs in every gST & Tax dashboard

KPIWhat it tells youFormula
Taxable salesSales on which GST or sales tax applies.SUM of taxable invoice value
Output taxTax collected on your sales.SUM of (Taxable value × Rate)
Input tax creditTax paid on purchases that you can claim back.SUM of eligible tax on purchase invoices
Net tax payableTax left to pay after input credit.Output tax − Input tax credit
Invoices issuedTax invoices raised in the period.COUNT of invoices
B2B shareShare of sales made to registered businesses.B2B taxable value ÷ Total taxable value
Returns filed on timeShare of returns filed by the due date.Returns on time ÷ Returns due
Mismatched invoicesPurchase invoices that do not match the supplier's filing.COUNT of invoices not matched in reconciliation