The Excel file includes two sheets: Summary (one row per invoice) and Line Items (one row per item).
Invoices
Grand Total
Collected
Outstanding
| Invoice No | Date | Customer | Subtotal | Discount | Shipping | Grand Total | Paid | Balance Due | Status |
|---|---|---|---|---|---|---|---|---|---|
| 1001kei-20260603-402dcf | 03 Jun 2026 | 1001Kei | MYR 2,230.50 | MYR 0.00 | MYR 0.00 | MYR 2,230.50 | MYR 2,230.50 | MYR 0.00 | Paid |
| dudeno-20260606-e03787 | 06 Jun 2026 | Dudeno | MYR 289.80 | MYR 0.00 | MYR 0.00 | MYR 289.80 | MYR 289.80 | MYR 0.00 | Paid |
| kaiteen-20260607-bc37e1 | 07 Jun 2026 | Kaiteen | MYR 38.00 | MYR 0.00 | MYR 0.00 | MYR 38.00 | MYR 38.00 | MYR 0.00 | Paid |
| hanako-20260607-c28a2a | 07 Jun 2026 | Hanako | MYR 38.00 | MYR 0.00 | MYR 0.00 | MYR 38.00 | MYR 38.00 | MYR 0.00 | Paid |
| ruffeyhana-20260608-d72b80 | 08 Jun 2026 | Ruffeyhana | MYR 112.00 | MYR 0.00 | MYR 0.00 | MYR 112.00 | MYR 112.00 | MYR 0.00 | Paid |
| yukilynn-20260611-8647ed | 11 Jun 2026 | yukilynn | MYR 358.50 | MYR 0.00 | MYR 0.00 | MYR 358.50 | MYR 358.50 | MYR 0.00 | Paid |
| keeko-20260617-b45f23 | 17 Jun 2026 | Keeko | MYR 585.00 | MYR 0.00 | MYR 0.00 | MYR 585.00 | MYR 0.00 | MYR 585.00 | Unpaid |
| kian-20260617-e09a1e | 17 Jun 2026 | Kian | MYR 575.00 | MYR 0.00 | MYR 0.00 | MYR 575.00 | MYR 0.00 | MYR 575.00 | Unpaid |
| yukinayee-20260617-c9396f | 17 Jun 2026 | Yukinayee | MYR 1,261.50 | MYR 0.00 | MYR 0.00 | MYR 1,261.50 | MYR 1,261.50 | MYR 0.00 | Paid |
| watermelonnn-20260617-327ac1 | 17 Jun 2026 | Watermelonnn | MYR 714.50 | MYR 0.00 | MYR 0.00 | MYR 714.50 | MYR 0.00 | MYR 714.50 | Unpaid |
| ryan-20260617-8677b9 | 17 Jun 2026 | Ryan | MYR 16.00 | MYR 0.00 | MYR 0.00 | MYR 16.00 | MYR 16.00 | MYR 0.00 | Paid |
| Totals | MYR 6,218.80 | MYR 4,344.30 | MYR 1,874.50 | ||||||