Kpiloom
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

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