Monthly Reconciliation Tool — Sales vs Received vs Return vs Due

Monthly Reconciliation — Sales / Received / Return / Due

Select month

Upload files (Sales / Payments / Returns / Due)

Sales CSV/XLSX

Payment CSV/XLSX

Return CSV/XLSX (Optional)

Due CSV/XLSX (monthly)

File header names accepted (case-insensitive): Sales: date, invoice, customer_code, customer_name, amount. Payments/Returns: date (optional), invoice (optional), customer_code (or customer_name), amount. Due: customer_code (or customer_name), amount, month (optional: YYYY-MM). If month missing, due amounts considered for selected month.

Summary for —

TOTAL SALES 销售额

0

SALES RETURN 退货额

0

DUE PAYMENT 未收款

0

RECEIVED AMOUNT 已收款

0

Customer-wise Aggregation

Shows customers with non-zero difference highlighted

Invoice-wise Details

Shows each sales invoice in selected month, matched payments (if invoice mapped) and difference

Notes & Assumptions

• Tool uses the selected month (YYYY-MM). Sales/Payments/Returns entries are included only if their date falls in that month.
• If Payments/Returns CSV include an invoice column, payments will be applied to that invoice for invoice-level matching. Otherwise payments are aggregated customer-wise only.
• Due CSV is considered monthly. If your Due CSV has a "month" column (YYYY-MM), it will use that; otherwise the amounts are treated as for the selected month.
• CSV parsing is tolerant but please ensure amounts are numeric (commas allowed as thousands separators).
• Returns file is optional - the app will work without it.
• Excel (.xlsx) files are now supported in addition to CSV.

Template CSVs — click to download sample templates to fill with your data:

Sales CSV template | Payments CSV template | Returns CSV template | Due CSV template