Customer (AR) Bad Debt Recovered

Menu Path: Extended Modules > Malaysia GST > AR Bad Debt Recovered

Should the customer pay up after Bad Debt Relief is claimed, the business is obligated to report the collection as Bad Debt Recovered, which will increase Output Tax for the month.

Guide

  1. Control Panel > System Admin > EMP Configurations > Tax > Purchase (Input Tax) : assign a GL Code as Default GL Code for AR Bad Debt Recovered (Refer to GST Setup User Guide (2015-04-01) 3.3: Purchase (Input Tax))

2. Date (as of) : Select the 2015 November filling cycle and click "Generate Report", system will list out the 2015 April documents, which meet the following 2 criteria:

    • already claimed and filed AR Bad Debt Relief in October / previous Filing Cycle
    • payment/settlement/knock-off made after AR Bad Debt Relief claimed

3. Select the Invoice for reporting Bad Debt Recovered, then click "Report Bad Debt Recovered"

Detail explanation on the listing above 

Column NameDescription
Document
Invoices that had outstanding amount 6 months after being issued, already claimed AR Bad Debt Relief and filed,
payment received after Relief claimed
Customer NameName of the customer
Total Amount (Without GST)
Invoice total amount, before tax
Total GST Amount
Tax amount for the Invoice
Current Outstanding Amount (Without GST)
Invoice current outstanding amount, before tax
Bad Debt Relief Declared (Without GST)
Bad Debt Relief Credit Memo total amount, before tax
Bad Debt Relief Declared GST Amount
Tax amount for the Bad Debt Relief Credit Memo
Previous Bad Debt Recovered
Tax amount for previously reported Bad Debt Recovered Credit Memo
Current Bad Debt Recovered (Without GST)Current payment received, before tax
Current Bad Debt Recovered GST Amount
Tax amount for the current payment received

Note : an Invoice can be partially settled, thus, the Tax Amount claimable will always be calculated based on the outstanding amount, instead of the Total Invoice Amount

4. Once user click "Report Bad Debt Recovered", a Credit Memo will automatically be created to record the recovery (system will prevent if there are teo / more user click to create the same CM at the same time).

The Credit Memo will be as below, whereby badDebtRecoveredAR is the "Default GL Code for AR Bad Debt Recovered" that you have setup in EMP Configuration. The CM date is filing cycle end date.

 

5. Please proceed with the Output Tax Filling Step (Output Tax Filing)

 

6. The CM recorded in Output Tax Invoice Report, tax code: AJS (Output Tax Invoice Report)

 

7. GST-03 Report, on 5b Total Output Tax (Inclusive of Bad Debt Recovered & other Adjustments) and 18 Bad Debt Recovered


NOTES:

  • Regardless of filing status, system allow reversal of the Bad Debt Recovery CM
  • The document is available to declare again (AR Bad Debt Recovery Function should check for CM status when checking if bad debt recovery is already done)
  • Warning message 'This credit memo is already filed' will show if the CM already filed
  • If AR Bad Debt Recovery CM is NOT reversed → user may do the normal filling process
  • If AR Bad Debt Recovery CM is reversed but original entry was previously filed → user need to file reverse entry only

Plug in:

  • Job Main Class : taskscheduler.baddebt.ar_baddebt_recovered.src.ARbadDebtRecovered
  • Job Parameters :-
    • Name : TO Value : valid email
    • Name: company_code Value : company name
    • Name: filling_cycle_name-Value: 
    • Name: filing_cycle_date_start Value : 2016-03-01
  • the plug-in will email a list of ALL CM created and instruct to file them
  • cannot run the plug-in without entering a valid email parameter


Enhancement: Kendo UI Report Format

  • The image above shows the new enhancement made on the format.
  • This format needs to be enabled at the Control Panel > System Admin > EMP Configurations > System
  • The feature allows the report to be generated in the Kendo UI Format, that is available under the Customer (AR) Bad Debt Recovered function, on EMP


  • The image above shows the report result that was generated in a Kendo UI Format



Related Wiki Pages:




Private & Confidential