Bad Debt VAT Not Reflecting Correctly on VAT201

Bad Debt VAT Not Reflecting Correctly on VAT201

(Screenshot 1)




Info
Question:

We want to write off the bad debt in IQ/ERP Go, but we are unable to record the VAT correctly on the VAT201 form for the bad debt.

When reviewing the journal, the Bad Debts and VAT Input – Trade entries are incorrect. (Please refer to Screenshot 1.)

Quote
The Debtors Control amount of R192,000 needs to be written off as bad debt.

Steps to resolve:

Navigate to Ledger --> Batch Journals. 

Credit the Debtors control account with the amount of R192,000.

The Bad Debts account to be debited with the amount for R192,000

Record the Bad Debts journal with the VAT Rate 4, this will allow the system to calculate VAT amount correctly. 

To proceed click on the Process button. 

As per screenshot 5: the Bad Debt account will preview correctly on the your VAT201 report. 

(Screenshot 1.)



Alert

Note:

Before proceeding, ensure that VAT Rate 4 exists and has been correctly configured as shown in the screenshot below under Utilities → Setup → Company Details → Tax Rates.

Also ensure that the Position on the VAT201 is set to Bad Debt; otherwise, it will not appear on the VAT201 form.


(Screenshot 2.)



(Screenshot 5.)


If we look at the accounting equation or T-Accounts:

Account
Debit 
Credit
Bad Debtors
166,956.22

VAT Input Trade 
25,043.48

Debtors Control 

192,000

    • Related Articles

    • VAT 404 - Guide for Vendors

      The VAT 404 is a basic guide where technical and legal terminology has been avoided wherever possible. Although fairly comprehensive, the guide does not deal with all the legal detail associated with VAT and is not intended for legal reference.

    • VAT Summary differs with General Ledger

      Reason for the Difference The VAT report is driven by tax transactions (VAT codes / tax events), while the General Ledger reflects posted accounting entries. These are not always identical in timing or structure. Troubleshooting Checklist 1. ⏱ Timing ...

    • Ledger | General Journals | Greater than ledger maximum date: 2026-02-28

      Issue: When attempting to post a General Journal, the system displays the following error message: “Greater than ledger maximum date: 2026-02-28” Cause: The transaction date you are trying to post falls outside the allowed posting range, as the ...

    • VAT 411 - Guide for Entertainment/Accommodation & Catering

      This guide is a general guide concerning the application of the Value-Added Tax (VAT) law regarding supplies of goods or services which fall into the category of “entertainment” and serves as a supplement to the VAT 404 – Guide for Vendors which ...

    • (South Africa 2025 | Proposed VAT increase reversed ) South Africa 2025 VAT Increase | Effective from 1st of May 2025

      (South Africa 2025 | Proposed VAT increase reversed) South Africa 2025 VAT Increase (1 May 2025) Product: IQ Retail (IQ POS, IQ Accounting, IQ Business & IQ Enterprise) Minimum required release: 2024.2.0.0 Clients on older versions are encouraged to ...