How should I prepare a rolling turnover record for a VAT registration decision?

Why a financial-year total is not enough

Your accounting year might end in February while the strongest sales period runs from July to June. Looking only at the financial-year total can hide what happened across two accounting years. A rolling record moves with time so that the registration review is not tied to an arbitrary year-end report.

SARS’s registration guidance uses consecutive 12 month periods for the relevant taxable-supplies tests and also addresses future supplies under written contractual obligations. Maintain both views. Past sales and future commitments should not be blended into a single unexplained total.

A monthly schedule is a useful management tool, but the underlying transactions and relevant dates still matter. If the business is approaching a threshold or signs a substantial contract, review the position promptly. Do not assume that waiting for the next month-end spreadsheet run is always an adequate response.

Define which business and records the schedule covers

Put the legal entity’s name and registration details at the top of the working record. State the reporting period, the source system and who prepared it. If the founder has more than one business, do not combine their bank receipts simply because one bookkeeper handles them all.

Check whether several trading names belong to the same legal person or whether apparently related activities are carried on by different entities. Resolve that question before doing the arithmetic. If the structure itself needs specialist review, show the uncertainty in the working paper rather than quietly choosing a convenient treatment.

Keep the original export from the accounting system. Make classifications and corrections in a separate reviewed working version so that a later reviewer can understand how the final number was produced. Record the reason for material adjustments, with a link or reference to the supporting transaction.

Classify supplies before adding amounts

Taxable supplies include standard-rated and zero-rated supplies. Exempt supplies are a different category. SARS’s guidance on VAT and other tax products explains this distinction, and the RAV01 guide separates standard-rated and zero-rated amounts in the registration information.

Do not classify an amount solely from a short bank description. Check what was supplied, to whom, by which entity and on what terms. A deposit from a customer needs to be understood in the context of the transaction; a deposit from the owner may instead represent funding.

Flag unusual items, mixed activities and disputed classifications for review. Selling an asset or receiving a refund may require a different analysis from an ordinary customer sale. The objective is a supportable taxable-supplies schedule, not an inflated or reduced total chosen to obtain a preferred registration outcome.

Use columns that make the record reviewable

These are suggested working-paper fields, not an official SARS form. Use a format your team can maintain accurately. Protect formula cells and retain a dated reviewed version when the schedule supports an application or a decision to monitor further.

A fictional rolling calculation

The following numbers are invented solely to illustrate a rolling calculation. They are not Vatco results, a forecast or a complete determination of VAT liability.

The arithmetic is R2,200,000 less R180,000 plus R330,000. Under the general R2.3 million threshold in current SARS guidance, this result needs immediate attention. The threshold change notice dates the new compulsory figure from 1 April 2026. A real review must still establish the correct transactions, dates and applicable rules.

Reconcile the total without treating bank receipts as sales

Compare the schedule with the sales ledger and the financial records. Then explain the difference between those sales and cash received. Unpaid invoices, customer advances, credit notes and timing differences can make the bank movement differ from the sales record without either number being fabricated.

A useful reconciliation starts from an identified report, lists each adjustment and arrives at the figure used for the registration review. Avoid a balancing number called “other” with no supporting explanation. If a duplicate invoice was removed, retain its reference and the reason.

The SARS registration supporting-document guidance includes financial information and trading evidence. Prepare the schedule so that a reviewer can follow it back to those records. The application should not rely on a spreadsheet total that nobody can reconstruct from the underlying business activity.

Keep future contractual commitments alongside the history

Maintain a separate list of signed commitments that may affect registration. Record the parties, value, expected supply period and relevant conditions. A sales pipeline is useful commercially, but it should not be presented as a binding obligation if the customer has not committed.

If a contract changes, update the schedule and keep the earlier version. Ask how the new facts affect the registration review. Do not simply move future amounts into the historical sales column to make the spreadsheet appear to meet a test.

For businesses with limited sales history, the voluntary VAT registration guide discusses evidence for different routes. Some details on official guidance require case-specific confirmation. Use the underlying regulation, current notice and actual contract rather than inventing a universal monthly shortcut.

Check these spreadsheet errors before relying on the result

Check that the rolling formula includes exactly the intended period. A copied formula can accidentally include thirteen months, omit the newest month or keep an old fixed range while fresh transactions are added below it. Compare the first and last transaction dates with the period shown in the heading.

Look for duplicate imports. If a bank feed and an invoice export were combined, the same customer transaction might appear twice. A credit note also needs a traceable treatment; removing the invoice and subtracting the credit note again can understate the record.

Keep foreign-currency source amounts and the basis of any conversion visible. Do not replace the original figure with a rounded rand amount that cannot be reproduced. Likewise, do not hide unresolved classifications inside a formula. Put them in a separate review column and record who decided the treatment.

Have someone review the schedule from the source documents, not just inspect whether the final number looks plausible. A correct addition of incorrectly selected transactions remains an unreliable basis for a registration decision.

Turn the record into a documented next action

1. Confirm the entity, classification and period covered.
2. Check the formulas and reconcile material differences.
3. Review the current rule and any relevant effective date.
4. Consider signed future commitments and special circumstances separately.
5. Record the conclusion, unanswered questions and next review trigger.

If registration appears compulsory, address the application and liability-date questions promptly. If the business is below the general threshold, consider whether voluntary registration is eligible and sensible rather than treating it as automatic. If the records are incomplete, state what must be obtained before the decision can be finalised.

Vatco’s VAT registration support can use the schedule as part of the evidence review. Monthly bookkeeping support can help keep the underlying records consistent. Keep the schedule alive after the first review so a change in trading is noticed in time.