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 ...Enforcing Individual E-Invoice for Classification Code
Under LHDN E-Invoice requirements, certain activities and transactions must be issued as Individual E-Invoices for each transaction, where consolidated E-Invoice submission is not permitted. For these activities, taxpayers are required to obtain full ...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 ...
Recent Articles
Staff Meal Integration
Staff Meal Integration User Guideline Introduction Staff Meal Integration allows F&B POS to deduct staff meal credit / wallet balance directly from a third-party staff management system when staff purchase meals. This feature is currently supported ...Cancel Print of Full Tax Invoice
Overview In Classic POS, there is a feature called Print Full Tax Invoice, which allows users to generate a full tax invoice for a completed sale. The system must maintain an auditable log whenever a Full Tax Invoice is cancelled. This guideline ...Xilnex API Guide for 3rd party
1. Objective The objective of this API guide is to provide a clear reference for developers and integration partners on how to utilize the Xilnex APIs to establish communication with the Xilnex system. The guide outlines the available endpoints, ...Enabling On The Move 1.0 Access Permission (OTM1.0)
Overview This guide explains how to enable access for users who need to use On The Move 1.0 (OTM 1.0). For OTM 1.0, only one permission is required: Allow to access on the move If this permission is not enabled for the user's assigned user group, the ...Available Events: Xilnex Event Hub
Last Updated: 05 May 2026 Sales # Event Name 1 Create Sales 2 Confirm Sales 3 Confirm Sales v2 4 Complete Sales 5 Complete Sales v2 6 Cancel Sales 7 Update Sales 8 Cancel Sales Order 9 Confirm Sales Order 10 Complete Sales Order 11 Post Quotation 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 ...Understanding DuitNow QR Payment in ClassicPOS
Introduction This document introduces the DuitNow QR payment feature available in the Xilnex Retail POS, enabling merchants to accept payments conveniently through Malaysia's national QR payment standard. The integration of DuitNowQR simplifies the ...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 ...