Net revenue
$0.00
Revenue reports from order and refund exports
Load your order and refund CSV files. LedgerLens totals them to the cent, lets you slice any period by month, customer, product or order size, and lists each row it left out so you can fix it on the spot.
Loading the sample store.
No files loaded yet.
LedgerLens tells orders from refunds by the header row.
You can also drop both files anywhere on the page.
Orders need order_id, order_date, currency, amount, status. Customer and items are optional, and they unlock the customer and product views. Only paid orders count as revenue.
Refunds need refund_id, order_id, refund_date, currency, amount. Reason is optional. If there were no refunds, load a file with just the header row.
Dates use YYYY-MM-DD, amounts are plain numbers such as 62.95, and the currency is USD. Each file can be up to 5 MB and 100,000 rows.
Sample files: orders.csv and refunds.csv
Loading the sample files.
Pick an orders file and a refunds file above, then choose Build report. Nothing is uploaded anywhere.
These figures are out of date. The source files changed after this report was built.
$0.00
$0.00
$0.00
0
$0.00
Orders count in the month they were placed, refunds in the month they were paid out.
Hover or tap a month for its figures. With the keyboard, focus the chart and use the arrow keys.
| Status | File | Line | ID | What happened | Fix |
|---|
Line numbers match the line in your CSV file, counting the header as line 1. Fixes change the copy in this browser only, until you download the corrected file.
Every row counted in the period. The JSON export includes all of them.
Exports use the last report you built. Build it again after changing a file.