Back to Free Tools
Google Sheets
Cloud Spreadsheets AccountingDynamic GST formulas, sales registers, and automated GSTR-3B ledger exports
GST Spreadsheet Formula Library
Copy validated Google Sheets & Excel formulas tailored for Indian GST accounting
How to Use Sheets with GST Maker
Streamlined sales and purchase ledgers
-
1
Export CSV from GST Maker Download your monthly Invoices or Purchases ledger as CSV from GST Maker's Reports module.
-
2
Import into Google Sheets Open a new spreadsheet, click File → Import → Upload, and select your CSV file.
-
3
Apply Reconciling Formulas Use our pre-tested formulas to calculate net taxable values, CGST/SGST splits, and check matching with GSTR-2B.
-
4
Share with Your Chartered Accountant Share view or edit permissions with your CA for direct filing in the government GST portal.
Pro Tips for Spreadsheet Tax Accounting
Preventing rounding and reconciliation errors
-
Always Wrap Calculations in `=ROUND(..., 2)` Floating point math errors in spreadsheets cause 1-paisa mismatches. Always round line items to 2 decimal places.
-
Format GSTIN Column as Plain Text Delhi state codes starting with '07' or Bihar '10' can lose leading zeroes if formatted as numbers. Always format GSTIN columns as 'Plain text'.
-
Use Conditional Formatting for Duplicates Highlight duplicate invoice numbers using `=COUNTIF(A:A, A2)>1` to prevent double-counting revenue in GSTR-1.
-
Build Pivot Tables for GSTR-3B Table 3.1 Create a pivot table grouped by tax slab (5%, 12%, 18%, 28%) and supply type (Interstate vs Intrastate) to copy directly into GST returns.
Need a quick online reverse GST calculation?
Use our dedicated Reverse GST Calculator to extract base taxable values instantly.