GST - Revenue Mismatch in Diagnostics
DESCRIPTION: The diagnostic tool GST & GL Revenue Mismatch is very useful in preparing the GST Form 5.
WHAT IS PURPOSE OF THIS DIAGNOSTIC?
It is meant to help users identify and correct errors that occurred during a transaction entry. Although the Revenue amount in Box 13 of the GST F5 should tie up with sum of Sales/Output Tax reported in Box 1, 2 and 3 - it need not be so.
Some example are:
- A Sales A/c (Revenue Item) did not have GST selected and caused Form 5 not to tally.
- GST applied on a non-revenue item like Discounts, Advance Revenue, Asset Disposal etc.
- Out-of-Scope transactions that are not captured in GST report but are recognized as Revenue items.
- Journals passed erroneously to the GST control account
It serves as support for “valid differences" between Box 4 and Box 13 in your GST Form 5
HOW TO USE THIS TOOL
To use this tool, generate the diagnostic period to coincide with the GST Form 5 periods you are preparing.
If you notice Box 4 (Total Supplies) and Box 13 (Total Revenue) do not tally, (as in above example graphic) it is clearly due to out-of-scope transactions which are not reported in Box 4. However, the difference may also be caused by other errors that must be corrected. Some examples of errors (non-exhaustive list) that need to be corrected are:
- Transactions where GST is applicable but the GST Box is not ticked. If this is the case, this transaction will be included in Box 13 but not in Box 4.
- An item in the Chart of Account like Fixed Asset Disposal A/c will not be flagged as Revenue item, but Standard Rate GST is charged. This cause Box 4 to have the tax amount, for this disposal is not shown in Box 13.
- User passing journal entries into the GL Revenue account but did not book in any corresponding GST entries.
Users are urged to perform regular maintenance to ascertain whether this difference is acceptable or not. Please check with your accounting professional as to what is acceptable.
ARE ALL RECORDS DISPLAYED IN DIAGNOSTIC CONSIDERED AS "ERRORS"?
No, not all items listed here are errors or need to be cleared. These will depend on the nature of the transaction (if in doubt please check with your auditor or accountant). Some examples of differences that may be considered as valid are:
- GST-applicable transactions which are not Revenue (i.e. sale of capital assets etc.)
- Rounding off differences which are immaterial in nature
- Deferred sales (or advance incomes) booked in wherein GST is charged (picked up in Box 4) but are liability items in balance sheet (non-Revenue).
- Audit adjusting entries passed directly to the General Ledger module which affected the Revenue account - but were not picked up in GST Box 4 report.
HOW TO SET A CHART OF ACCOUNT AS REVENUE ITEM?