Map your CSV into the required columns
Preserve your original CSV. Select what each source column means, then save a new 13-column file for free.
Why you choose the mapping
Sales and cash received are different. Gross and net reports are different. Verify the meanings in your source report rather than guessing from platform column names. Inputs stay in your browser.
Required values: row income/cost, currency JPY/USD, basis gross/net, type sale/membership/referral/reading/other, costComplete true/false. Period YYYY-MM. Unmapped columns remain blank. Amounts are blank or nonnegative plain numbers, without formulas or thousands separators. No currency or meaning conversion.
Missing row, period, currency, type or basis columns? Explicitly choose a constant for this file and confirm it applies to every row. No values are inferred. Unspecified remains unknown; required meanings must be confirmed before a calculable CSV can be saved.
Save a new CSV without changing the original
For repeated multi-file aggregation
Mapping one file is free. For repeated multi-file aggregation, CSV Income Reconciliation Kit is from US$3. It requires Python 3.9+ on a computer and the exact prepared 13-column format. No platform connection, tax filing or combined-currency sum. Check the final checkout total.
See the batch kit and conditions