LedgerLens

Files stay in your browser

Revenue reports from order and refund exports

Revenue you can trace back to the row.

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.

Your files

No files loaded yet.

You can also drop both files anywhere on the page.

Which columns do I need?

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.

Loading sample

Loading the sample files.

Load both files to build a report.

Pick an orders file and a refunds file above, then choose Build report. Nothing is uploaded anywhere.

Fix this row

Keyboard shortcuts

They work anywhere except while you type in a field.

1 2 3
Report, Exceptions, Rows
M Q C P O
Group by month, quarter, customer, product or order size
[ ]
Move the period back or forward by its own length
A
Whole range
R
Switch between bars and running total
/
Search the open tab
Ctrl Z
Undo a view change or a fix
Ctrl Shift Z
Redo
V
Open saved views
L
Copy a link to this view
E
Download this view as CSV
In the chart
Arrow keys move between months. Shift with an arrow widens the period. Drag across the bars to pick a period.