Import finance data

Bring external records — a delivery-platform statement (e.g. Foodpanda) or your own Excel/CSV — into the ledger in one pass, following the Upload file → Map columns → Preview → Done steps. This is an optional path: the system normally estimates fees from your settings and never needs statement reconciliation, so you only import when you want to be exact to the cent.

Upload file

1. In the Upload an Excel (.xlsx) or CSV file card, choose your file (the first row must be column headers).
2. Click Upload to parse it.

For a multi-sheet file, only the first sheet with data is read (e.g. Attachment 1 of a Foodpanda statement). Dates in YYYY-MM-DD, YYYY/M/D, or Excel date format are supported.

Map columns

Tell the system what each column means; the First 10 rows preview below updates as you go.

1. Pick the Date column.
2. Pick the Data type: Revenue, Expense, or Revenue + expense (platform orders / statements).
3. Map the amount column(s):
   • Revenue / Expense → pick the Amount column.
   • Revenue + expense → pick the Revenue amount column, then either the Fee column (platform deduction) or the Payout amount column (expense = revenue − payout).
4. Revenue and Revenue+expense also need a Source and Payment method; if the source is Platform-collected, the payment method is locked and left blank.
5. (Optional) Map the Order ID column, Description column, and Category column.
6. Click Generate preview.

For revenue / revenue+expense imports, pick a Payment method first, otherwise the Fee is counted as 0 (unless the source is platform-collected). Without an Order ID column there is no automatic de-duplication — avoid re-uploading the same file.

Preview and confirm

1. Check the summary stats (revenue/expense counts, totals, Estimated fee, Error rows) and the per-row list below.
2. For revenue imports you can change the rate and Rounding under Adjust fee (live); the amounts below recompute automatically.
3. When it looks right, click Import N rows; once Import complete appears, click View ledger to reconcile.

Error rows are skipped automatically and don't affect the rest; duplicate order IDs are skipped too (the done screen shows "Skipped N entries"). If you see an amber notice such as "this row may already be recorded via POS" or "fee exceeds revenue, clamped to net 0", verify whether a manual adjustment is needed.

Import history and revert

The Import history at the bottom of the page lists every batch. Click Revert to delete the whole batch (including rows you edited afterwards); it is recoverable from the audit log.

Revert deletes ledger entries — Manager permission required. Imports avoid already-closed periods: a batch with any row in a month-closed month is blocked (reopen that month first); importing into a day-closed date — Manager permission required.