• 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