업데이트됨 2026년 11월 11일 오후 10:35 GMT+8
결과물 파일
October records organized for review
Platform example using 50 synthetic input rows in USD. No real customer transactions are included.
Summary
| Measure | Result |
|---|---|
| Original rows | 50 |
| Unique transactions retained | 48 |
| Duplicate export rows excluded | 2 |
| Client income after client refund | USD 4,250.00 |
| Classified expenses before supplier refunds | USD 642.20 |
| Supplier refunds | USD 39.70 |
| Net classified expenses | USD 602.50 |
| Unclassified outflow included in totals | USD 17.50 |
| Net expenses including unclassified outflow | USD 620.00 |
| Net cash movement | USD 3,630.00 |
Income is cash received minus a USD 50.00 client refund. Expenses are recorded outflows minus supplier refunds; they include the unresolved purchase below. These are cash-record totals, not a claim about taxable profit.
Category totals
| Category | Signed cash movement in USD |
|---|---|
| Client income | 4,250.00 |
| Software | -86.00 |
| Supplies | -112.50 |
| Travel | -42.00 |
| Workspace | -210.00 |
| Marketing | -128.00 |
| Fees | -24.00 |
| Pending review | -17.50 |
Workspace is the largest classified expense category at USD 210.00, followed by Marketing at USD 128.00 and Supplies at USD 112.50. These amounts describe this synthetic month only.
What changed
Dates use YYYY-MM-DD. Category spelling and whitespace are normalized using the agreed merchant mapping. Missing categories with known merchants are filled from that same mapping. Client refunds reduce income and supplier refunds offset the corresponding expense category.
ROW-049 repeats the transaction in ROW-008; ROW-050 repeats ROW-014. Their transaction IDs and all substantive input fields match, so only the repeated export rows are excluded. Separate purchases with matching amounts remain in the cleaned ledger.
The raw export sums to USD 3,591.50. Removing the two repeated outflows of USD 12.00 and USD 26.50 raises the reconciled movement by USD 38.50 to USD 3,630.00. Each source row is accounted for in the cleaned file or the duplicate log.
One question for the publisher
What was ROW-048, CARD PURCHASE 7Q, for USD 17.50? It is retained as Pending review and is already included in expenses. Reclassifying it will move category totals without changing total cash movement.
Files
- Original input - Cleaned records - Category summary - Row-level changes and exceptions - Reference controls
Keep the original export. For the next month, reuse the merchant mapping only after confirming that the new records use the same identifiers, date formats, currency and sign convention.