Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

Panel

Output Tax has to be reported either upon Invoice or Collection, whichever comes first.

Thus, a business will need to report and pay the Output Tax once an Invoice is issued, regardless if the customer has paid.

However, if the customer does not pay up within 6 months, the business can declare that particular Invoice as Bad Debt and claim Bad Debt Relief, which will increase Input Tax for the month, and subsequently offset the Output Tax that the business will need to pay to the Royal Custom.


 Guide

  1. Control Panel > System Admin > EMP Configurations > Tax > Purchase (Input Tax) : assign a GL Code as Default GL Code for AR Bad Debt Relief (Refer to GST Setup User Guide (2015-04-01) 3.3: Purchase (Input Tax))
  2. Date (as of) : Select the 2015 October filling cycle, system will list out the 2015 April outstanding documents. Select the Invoice for claim Bad Debt Relief, than click "Claim Relief"

Detail explanation on the listing above 

TableDescription
Document
Invoices that have outstanding amount 6 months after being issued
Amount Before Tax
Invoice total amount before tax
Total GST Amount
Tax amount for the Invoice
Outstanding Amount Before Tax
Invoice current outstanding amount before tax
Bad Debt Relief Claimable
Tax amount for the outstanding amount

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


Refer example below on the Tax Amount claimable calculation

INV1275 : Total Amount = RM1,990, Outstanding Amount = RM500

ItemAmt bf TaxTax RateTax AmtAmt After TaxWeight (Item amt After tax / Total amt of taxO/S Amt (weight * Ttl O/S Amt)Bad Debt Relief Claimable (O/S Amt / (100 + Tax Rate) * Tax RateO/S bf Tax
Item ARM1,0006%RM 60RM 1,0601,060 / 1,990 = 0.53266RM 266.33RM 15.08RM251.25
Item BRM 5006%RM 30RM 530530 / 1,990 = 0.26633RM 133.165RM 7.54RM125.63
Item CRM 4000%RM 0RM 400400 / 1,990 = 0.20101RM 100.505RM 0RM100.50
TotalRM1,900 
RM 90RM 1,990 
RM 500RM 22.62RM477.38


3. Once you user click "Claim Relief", a Credit Memo will automatically be created to record the relief . (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 badDebtAR is the "Default GL Code for AR Bad Debt Relief" that you have setup in EMP Configuration. The CM date is filing cycle end date. 

Image Modified

 

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

5. The CM recorded in Input Tax Invoice Report, tax code: AJP (Input Tax Invoice Report)AJP 

Image Modified

6. GST-03 Report, on 6b Total Input Tax (Inclusive of Bad Debt Relief & other Adjustments) and 17 Bad Debt Relief

Image Modified


Malaysia Royal Custom DG's Decisions

http://gst.customs.gov.my/en/rg/SiteAssets/Keputusan%20KP/DG/DGD%201%202014/ITEM%203.pdf

Image ModifiedImage Modified

...


NOTES:

Panel

Kendo UI Report Format

...

panel

  • 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 Relief function, on EMP


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

...