NPM Calculator

Load your masterfile first, then upload the latest detail file to update the preview. Quantity is now always based on the last uploaded detail file, grouped by order, and written as the summed quantity for each matching order.

Smart merge • Clean preview • Faster review

1) Load Masterfile

Start with your base file. This becomes the main table used for preview and export.

Output columns: Date, Site Order ID, Quantity, Unit Sales Price, Total Tax Price, Total Shipping Paid, Total Amount Paid, Sales Order Total, Total Supplier Cost, SS Shipping Price, Merchant / List Fee, Total Cost, Net profit, NPM.
No masterfile loaded yet.

2) Upload Latest Detail File

The latest detail file controls the merge. Quantity is always recalculated from that file and summed per order.

Fixed rules:
• Date = Order Date
• Quantity = Qty / Quantity from the latest uploaded detail file, summed by order
• Unit Sales Price = Unit Price
• Total Shipping Paid = Total Shipping Price
• Total Amount Paid = Amount Paid only
• Total Supplier Cost = Amount only (sum by order)
• SS Shipping Price = Rate
• Existing masterfile values are preserved except Quantity, which always refreshes from the latest detail file
Load the masterfile first.

3) Preview

Review the merged output before downloading.

No data loaded
Formula logic: Sales Order Total = Total Amount Paid - Total Tax Price - Total Shipping Paid. If Total Amount Paid is blank and Sales Order Total has a value, Total Amount Paid will copy Sales Order Total. Merchant / List Fee = Sales Order Total × 0.13. Total Cost = Total Supplier Cost + SS Shipping Price + Merchant / List Fee. Net profit = Sales Order Total - Total Cost. NPM = Net profit / Sales Order Total.