Tax and GST

A tax payable tally that agrees with your cash

How to keep a running tally of tax collected, tax paid and tax due, and how to check it against what is actually sitting in your accounts.

Editorial illustration for A tax payable tally that agrees with your cash

Three numbers that explain everything

For a registered seller, a month produces three figures worth tracking. Tax collected from customers on sales. Tax paid to suppliers on purchases, to the extent it can be recovered. And the difference, which is roughly what falls due. The exact computation follows the rules of your registration, so take it as a bookkeeping outline, not a calculation to file with.

Keeping these three numbers visible all month avoids the shock of a large payable arriving at the deadline.

Building the tally

Open a simple table, one row per week.

WeekTax collectedTax on purchasesRunning payable
11,8006001,200
22,1009002,400
31,5004003,500
42,4001,1004,800

Each week, add the new amounts and carry the running figure forward. By week four, you know the payable is around 4,800 before anyone asks. The figures are illustrative, but the structure is real.

Where each number comes from

Tax collected comes from your sales invoices. If you record each sale with base and tax separated, the weekly sum is a filter, not a calculation. Tax on purchases comes from the bills you hold, restricted to those that support credit.

Do not take the tax figure from the bank. The bank sees totals, with tax baked in. Only the documents carry the split.

Checking the tally against cash

Here is the test that gives the tally its value. Open a dedicated account or pot and move the running payable into it each week. At the month’s end, the balance of the pot should equal the tally, to within small rounding.

If the pot holds less, either tax was collected but spent, or the tally is overstated. If it holds more, some purchases supporting credit were not counted. Either way, the difference is a prompt to look at the entries, not an alarm.

Common ways a tally drifts

  1. Sales recorded without tax separated, so the collected figure is understated.
  2. Credit notes not entered, so collected tax is overstated.
  3. Purchase bills counted that do not support credit.
  4. Advances received but not yet billed, a case that needs advice.
  5. Cash sales entered late, after the weekly figure was taken.

Each of these has a simple remedy: record sales with the split from day one, link credit notes to invoices, flag doubtful purchases, ask about advances and enter cash sales at the end of the day.

Reading the trend

Over several months, the tally gives a feel for your tax cycle. Months with large purchases may show lower payable. Months with strong sales show higher. Knowing the pattern lets you plan cash rather than discover it.

If payable regularly surprises you in the same direction, investigate the cause. A consistent understatement suggests a missing category of sale. A consistent overstatement suggests purchases you are not capturing.

What to do at the deadline

When the period closes, freeze a copy of the tally with the date. Compare it to the figures in your return preparation. Small differences should be explained in a note: rounding, a late bill, a correction. Large differences should be resolved before filing, not after.

Then pay the dues from the dedicated pot, record the payment with its reference, and reset the table for the next period. The satisfaction of paying a number that you saw coming is a quiet reward of keeping the tally.

A quick weekly view

Every Friday, glance at the tally and ask one question: does the pot hold at least the running payable? If yes, nothing more is needed. If no, move the shortfall across before the weekend. This single question, asked weekly, is the entire discipline in miniature.

For those who like numbers, keep a small chart of the payable at each week’s end. A rising line followed by a drop on payment day makes the cycle easy to see and explain to a partner or adviser.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports