Reconciling E-Invoices Using the Web Report
This guide explains how to use the Web Report to reconcile E-Invoices by comparing daily sales amounts against total payable amounts after redemptions, ensuring accurate submission to IRBM (LHDN).
Understanding of Total Payable Amount
The Total Payable Amount submitted to LHDN represents the final invoice value after deducting loyalty points and vouchers.
Calculation Logic:
Total Payable Amount = Sales Amount − Redemption Amount (Point Value, Voucher Amount)
Sales Amount = Gross amount of goods/services before deductions
Point Value = Any client points redeemed in the transaction
Voucher Amount = Any voucher or discount coupon used during payment
Only the Total Payable Amount (after deductions) is submitted to LHDN as the final value in the E-Invoice Document.
Steps for reconciliation using Web Reports
Step 1: Verify Daily Sales Report
- Access the Daily Sales Report on Web Report.
- Select the relevant date and outlet.
- Query the report to retrieve the Total Sales Amount from the report.
Step 2: Verify E-Invoice Report
- Access the E-Invoice Report on Web Report.
- Add/drag the following columns:
- Total Redemption Amount
- Total Payable Amount
- Total Payable Amount (ex. Redemption)
- Select the relevant date and outlet.
- Query the report to retrieve the Total Payable Amount (ex. Redemption).
Step 3: Compare Grand Totals
- Compare the Total Payable Amount ex. Redemption with Total Sales Amount.
- Total Sales Amount (from Daily Sales Report)
- Total Payable Amount (ex. Redemption) (from E-Invoice Report)
- If both amounts aligned, which means that the reconciliation is tally and correct.
Sample & Explanation
1. Sale with Redemption (Voucher)
Daily Sales Report
E-Invoice Report
Comparison Result 1:
(Daily Sales Report) Sales Amount matches with (E-Invoice Report) Total Payable Amount ex. Redemption (before redemption deductions).
Explanation 1:
Total Sales Amount = RM12.70
Redemption Amount = RM10.00
Final Total Payable Amount = RM12.70 – RM10.00 = RM2.70
In this case, only RM2.70 will be submitted to IRBM (LHDN) as the final value in the e-Invoice.
2. Multiple sales with Redemption (Point / Voucher)
Daily Sales Report
E-Invoice Report
Comparison Result 2:
(Daily Sales Report)Sales Amount matches with (E-Invoice Report)Total Payable Amount ex. Redemption (before redemption deductions).
Explanation 2:
Total Sales Amount = RM260.75
Redemption Amount = RM115.00
Final Total Payable Amount = RM260.75 – RM115.00 = RM145.75
In this case, only RM145.75 will be submitted to IRBM (LHDN) as the final value in the e-Invoice.
Related Articles
How to Resolve Invalid E-Invoices in E-Invoicing Dashboard
E-Invoices are validated directly by the LHDN Malaysia server. When a submission is marked as invalid, the server will return an error message (also known as the “Invalid Reason”). Taxpayers are expected to review this message and take corrective ...Enable E-Invoicing via Xilnex Portal
Xilnex Portal is the central platform where all configurations and settings for your system can be managed. Designed for flexibility and ease of use, the portal allows you to set up, monitor, and maintain various aspects of your business operations ...Xilnex E-Invoicing Document Split
Type Descriptions Product Xilnex E-Invoicing New Features E-Invoice Document Splitting Document Splitting Function Type Toggle Configuration E-Invoice Settings Required DB Upgrade No Release Date 13 August 2025 Background When a generated payload ...Enable E-Receipt Portal (Buyer's Portal)
Overview The E-Receipt Portal is a service featured by Xilnex. It allows buyers to submit their purchase details themselves through a public portal, so sellers do not have to collect information during a transaction checkout. Collecting buyer ...How to Stop Xilnex E-Invoicing
Scenarios Requiring Xilnex E-Invoicing Deactivation Deactivate Xilnex E-Invoicing when a business falls below mandatory thresholds or ceases operations, ensuring compliance with IRBM guidelines while avoiding unnecessary module activity. This ...
Recent Articles
How to Stop Xilnex E-Invoicing
Scenarios Requiring Xilnex E-Invoicing Deactivation Deactivate Xilnex E-Invoicing when a business falls below mandatory thresholds or ceases operations, ensuring compliance with IRBM guidelines while avoiding unnecessary module activity. This ...Xilnex E-Invoicing Document Split
Type Descriptions Product Xilnex E-Invoicing New Features E-Invoice Document Splitting Document Splitting Function Type Toggle Configuration E-Invoice Settings Required DB Upgrade No Release Date 13 August 2025 Background When a generated payload ...Connecting KDS 2.0 to POS
Xilnex ClassicPOS Important Notice: As of now, in order to use KDS2.0, Classic POS version must be at least version 2.16 July 2025 and above. 1. In System Configuration > select Device Configuration > under This Machine > look for Kitchen Display ...Congiure a Client KDS - Connect to a Host KDS
KDS Client A KDS Client Device in Xilnex KDS 2.0 is a display screen (such as a tablet, monitor, or smart TV) located at a specific kitchen station (e.g., Grill, Bar, or Cold Station). Its primary function is to receive and display orders sent from ...Configure A Host KDS Device
A Host KDS in Xilnex KDS 2.0 is the designated central hub device responsible for synchronizing and managing the entire kitchen network. It acts as the primary authority, ensuring that all orders from the POS system are correctly distributed to ...
Popular Articles
Basic - How to create a voucher-coupon
Voucher and coupon definition Voucher can be generated in bulk and can be used once Coupon can only be created one at a time (reusable code) and can be use multiple times Pre-voucher / coupon setup There are 2 things need to be prepared before we can ...Basic - How to change custom cost to another branch that don’t have custom cost
Change custom cost to another branch that don’t have custom cost 1. Get the item list from the location with custom cost (Item Code, Name, Custom Cost) 2. Make sure the Show Location Price are selected 3. Export the item list in Excel 4. The file ...Intermediate - How to Bill & Post to Sales from Transfer Note
1.0 Purpose A bill is required from transfer note when an inventory transfer involves financial transactions, cost allocation, or compliance with tax and accounting regulations. It is used when stock is moved between outlets that operate as separate ...Basic - How to enable E-Receipt Portal and QR Code Setup on Printing format in Xilnex
Enable E-Receipt Portal Enable the E-receipt functionality Once Enabled, you will be getting the E-Receipt portal link Continue under Theme & Styling, enabled for the E-Invoice (LHDN) You can customize the look and feel of the E-Receipt portal ...Importing Usernames in Xilnex Portal
What is User Import? User Import allows you to add, update, or manage multiple users in bulk rather than handling them one by one. This feature is especially useful for onboarding new employees, migrating data, or making large-scale updates to user ...