Processing GST Across Multiple Amounts at Once
How it works
The standard GST calculation is straightforward — multiply by 1.1 to add GST, or divide by 11 to extract the GST component from a GST-inclusive price. But when you're working with dozens or hundreds of figures at once, doing it one at a time is impractical. The Bulk GST Calculator lets you paste an entire column of numbers and get the ex-GST, GST, and inc-GST breakdown for every row instantly.
This is particularly useful at BAS time, when bookkeepers need to verify GST across batches of transactions, or when businesses are re-pricing inventory and need to calculate the GST-inclusive price for every product in a catalogue. The calculator handles common number formats automatically — dollar signs, commas, spaces, and trailing zeros are all stripped before calculation.
All calculations follow the standard ATO formula. To add GST, each amount is multiplied by 0.1 to get the GST component, then added to the original amount for the inclusive price. To remove GST, each amount is divided by 11 to extract the GST, with the remainder being the ex-GST price. Rounding follows the ATO's standard rule: round to the nearest cent (0.5 cents round up).
When to use this calculator
- You're a bookkeeper or accountant processing a batch of transactions and need GST breakdowns for all of them at once
- You're updating a product catalogue or price list and need to calculate GST-inclusive prices for every item
- You're reconciling bank statements against invoices and need to quickly extract the GST from a list of payments
- You need to prepare a spreadsheet for your BAS with correct GST columns and want to verify the figures
- You're comparing supplier quotes that mix ex-GST and inc-GST pricing and need everything in the same format
Key concepts
- Adding GST (ex-GST → inc-GST)
- When your amounts are before GST, the calculator multiplies each by 1.1 to get the inclusive price. The GST component is 10% of the original amount. Example: $450 ex-GST → $45 GST → $495 inc-GST.
- Removing GST (inc-GST → ex-GST)
- When your amounts already include GST, the calculator divides each by 11 to find the GST, then subtracts it. The formula is: GST = amount ÷ 11, ex-GST = amount − GST. Example: $495 inc-GST → $45 GST → $450 ex-GST.
- ATO rounding
- The ATO requires GST to be rounded to the nearest cent. When the third decimal is exactly 5, round up. For example, $45.455 rounds to $45.46. This matches standard Australian rounding conventions and what accounting software produces.
- CSV export
- The results can be exported as a CSV file, which opens directly in Excel, Google Sheets, or any accounting software that accepts CSV imports. Each row contains the original amount, ex-GST amount, GST component, and inc-GST total — ready for pasting into your BAS working papers or general ledger.
Worked example — Extracting GST from a list of supplier payments
James runs a construction company and needs to extract the GST from this month's supplier payments for his BAS. All amounts include GST.
Input amounts (inc-GST):
$2,310.00, $847.00, $15,400.00, $363.00, $5,027.00
| Supplier payment (inc-GST) | Ex-GST | GST component |
|---|---|---|
| $2,310.00 | $2,100.00 | $210.00 |
| $847.00 | $770.00 | $77.00 |
| $15,400.00 | $14,000.00 | $1,400.00 |
| $363.00 | $330.00 | $33.00 |
| $5,027.00 | $4,570.00 | $457.00 |
| Totals | $21,770.00 | $2,177.00 |
James can claim $2,177.00 in input tax credits at label 1B on his BAS for these purchases (assuming all are for taxable business purposes and he has valid tax invoices). He exports the table as CSV and pastes it into his BAS working spreadsheet.