- VAT % variances – All transactions with VAT – by VAT category – with columns for totals of gross, base and VAT and calculated percentage – to highlight variances to % stored in master data or selected %
- VAT registration numbers validation – use standard format and display all customers/vendors where registration number is not ‘compatible’ to SARS format
Recalculation of VAT – using each VAT cat % – and highlighting all VAT variance amounts - VAT on Imports – all transactions sorted by General ledger code(s) for imports – and then by VAT category – with columns for totals of base and VAT – to highlight VAT values and percentages
- VAT Registration numbers – customers/vendors where VAT was applied and have no VAT Registration number on master record and/or where no VAT was applied and there is a VAT Registration numbers on master record
- Duplicated Document numbers – vendors by document for the same date and values – overstated VAT
- Customer inconsistencies – where customer has both vatable and non vatable transactions
- Vendor inconsistencies – where vendor has both vatable and non vatable transactions
- Posting vs. document or system capture date – highlight all Input transactions where both dates are the same – might be transports from other ERP systems – highlighting period mismatches
- Currency vs. Country codes – customers/vendors codes – compare and highlight inconsistencies – and VAT or no VAT Registration numbers
- Month-end checklists – highlight any steps not completed by users
- Manual entries – report of all manuals captured – by output or input – by period(s)
- Customers/vendors and General ledger with no master data details – highlight imports not done regularly or new accounts
- Customers/ vendors and General ledger with master data fields missing details – highlight imports not done regularly or new accounts – or manual info not captured
- Output and Input cat codes listing – with all info – highlighting missing codes – where description is unallocated
- General ledger accounts– all transactions sorted by General ledger code – and then by VAT category – with columns for totals of base and VAT – to highlight General ledger codes used for both Output and/or Input- and if VAT for all / some transactions only
- VAT category codes– all transactions sorted by VAT category code – with columns for master data information (VAT201 code & default rate % and exclude Indicator) and totals of base and VAT – to highlight where VAT was used correctly according to master data rules – and if VAT for all / some transactions only.
- Zero rated transactions– all zero rated transactions sorted by VAT category code – with columns for master data information (VAT201 code & default rate % and exclude Indicator) and totals of base and VAT – and highlight where VAT was charged incorrectly according to master data rules
- Non-claimable transactions– all non-claimable transactions sorted by VAT category code – with columns for master data information (VAT201 code & default rate % and exclude Indicator) and totals of base and VAT – and highlight where VAT was charged incorrectly according to master data rules
- Exempt transactions– all exempt transactions sorted by VAT category code – with columns for master data information (VAT201 code & default rate % and exclude Indicator) and totals of base and VAT – and highlight where VAT was charged incorrectly according to master data rules
- Bad debts– all bad debt transactions sorted by General ledger code – with columns for totals of base and VAT – and highlight where VAT was not charged
- Foreign purchases– imports and exports – by country or currency – with columns for totals of base and VAT – and highlight where VAT was charged incorrectly
- Apportionment– recovery analysis – If an expense can be directly attributed to an income
- Discount allowed– all transactions sorted by General ledger code for discount allowed – and then by VAT category – with columns for totals of base and VAT – and highlight where VAT was charged and where no VAT was charged
- High value VAT Transactions– by customer/vendor – with complete documents – selected by monetary value
- High value credit VAT Transactions– by customer/vendor – with complete documents – selected by monetary value
- Gross value check– by Transactions – where base and VAT do not add up to gross amounts
- Comparison of VAT201s per period(s)– highlighting current to previous periods – percentages and values – with comments
- PLUS: Completeness test– all trans sorted by VAT General ledger codes – posted to VAT Accounts with no VAT
- Single company or multiple companies – Select range of Companies
- Output transactions only – might default to correct option depending on report chosen
- Input transactions only – might default to correct option depending on report chosen
- From and to period – YYYYYpp (for period(s) and historical)
- From and to customer/vendor
- From and to General ledger Code
- Key search analysis – need to determine special options per report
- By document type