Please generate the below information for checking
| Month | (A) GST Input Ledger Balance | (B) GST journal transfer to gst_Payable | (C) GST-03 Form 6b. | (D) GST Input ledger without BL : (A) - (B)BL | Diff between (D) - (B) | Diff between (B) - (C) | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Debit / Credit | Amount | Tax Code | Date | Jtxn | Amount | Total Amount | Amount | ||||
| TX | |||||||||||
| BL | |||||||||||
(A) to get the data, go to : Accounting > Journal and Ledger > GL Listing.
- Select the company, date range: choose for glcode : gst_Input, click Detail View
(B) get the journal from acc_Payble glcode, same step as (A)
Note: to check the BL tax code Input tax detail, can refer to Extended Module > Malaysia GST > Reports > Input Tax Invoice Report > refer to BL column
(C) to get the data, go to : Extended Module > Malaysia GST > GST Reports > GST-03 (GST Tax Return)
Please request the excel sheet template for the data comparison