2. Edit Excel File

To make sure everything goes smoothly, it’s important that your QuickBooks file is fully compatible with LHDN’s e-invoicing requirements.

LHDN asks for 55 specific fields in each e-invoice. But here’s the good news: QuickBooks already covers most of them by default! You’ll just need to make a few small tweaks to get everything in line.

Step 1: Open your Excel file. We will only focus on the sheet named Sheet1

Step 2: Delete the first and last rows - because they have empty information in the columns

Step 3: Scroll all the way to the right and add these new columns

Column Name	What To Put	LHDN’s Reference
e-Invoice Type	Refer to LHDN’s reference Example: 1	https://sdk.myinvois.hasil.gov.my/codes/e-invoice-types/
Classification	Refer to LHDN’s reference Example: 22	https://sdk.myinvois.hasil.gov.my/codes/classification-codes/
Tax Type	Refer to LHDN’s reference Example: 6	https://sdk.myinvois.hasil.gov.my/codes/tax-types/
Tax Rate	The percentage % of `Sales Tax Code` column in the file
Details of Tax Exemption	Leave it blank if tax type is not 'E'
Amount Exempted from Tax	Leave it blank if tax type is not 'E'
Malaysia Standard Industrial Classification (MSIC) Codes	Refer to LHDN’s reference Example: 1111	https://sdk.myinvois.hasil.gov.my/codes/msic-codes/
Subtotal	Same value as `Net Amount` column in the file
Total Excluding Tax (line item)	Same value as `Net Amount` column in the file
Total Excluding Tax (invoice level)	Same value as `Net Amount` column in the file
Total Tax Amount	Same value as `Sales Tax Amount` column in the file
Total Including Tax	Same value as `Gross Amount` column in the file
Total Payable Amount	Same value as `Gross Amount` column in the file

Step 4: Save your file as csv format as per LHDN’s requirement

Next process ⬇️

You’re ready to upload on your JomeInvoice portal!

3. Upload E-Invoice