Merge Excel HPP
Merge transaction data and calculate HPP automatically from 2 Excel files based on Transaction Number.
Excel Format Guide
Make sure the Excel files you upload have the following column structure (the first row must contain column headers):
Excel 1: HPP Transaction Data
- Date
- Transaction No
- Type
- Debit (Positive HPP value)
- Credit (Negative HPP value)
Excel 2: Sales Data
- Date
- Transaction No
- Description (Item/Details)
- Harga Jual (Selling Price of Goods/Services)
Loading...
Processing Excel Files
Please wait a moment. We are reading, matching transactions, and calculating HPP automatically for you...
Excel Files Processed Successfully!
Your merged Excel file is ready. Click the button below to download the result.