Oleh BoikoOrder Profit Reconciler / Free example

A clear view of each order

What came in.
What it cost.
What is left.

Follow sales and supplier costs through a complete reconciliation. See the gaps before calling them profit.

Explore the result
01

Import prepared totals

One row for each sale.
One row for each supplier purchase.

02

Connect the costs

Link a purchase to a sale.
Split shared costs explicitly.

03

Review the result

Completed profit stays separate
from missing or unused costs.

The actual computed result

Four orders complete.
One still needs a cost.

Fictional data · USD
Snapshot as of 16 October 2026

Completed order profit

$173.00

4 complete · 1 needs review

Completed net proceeds
$378.00
Allocated purchase costs
$203.00
Other selling costs
$2.00
Proceeds waiting for a cost
$40.00
Purchase cost not allocated
$24.00

The $173 includes only completed orders. A missing purchase cost is shown as a dash, never as zero.

Each sale and its contribution profit
SaleNet proceedsPurchase costOther costsProfitStatus
S10012026-10-14110.0063.002.0045.00Complete
S10022026-10-1470.0080.000.00-10.00Complete
S10032026-10-1554.0030.000.0024.00Complete
S10042026-10-15144.0030.000.00114.00Complete
S10052026-10-1640.00—0.00—Needs reviewPurchase cost not linked

Trace one order

S1001, step by step.

Open row 2 in each input CSV. The link assigns the full cost of purchase P1001 to sale S1001.

110 − 63 − 2 = 45

Net proceeds − purchase cost − other costs = profit

Sale S1001$110.00

$120 items + $5 shipping − $15 fees

Purchase P1001$63.00

$55 items + $5 shipping + $3 included tax

Other selling costs$2.00

Recorded separately in the sales file

The purchase side

A shared cost stays accounted for.

P1003 is split $30 + $30.
P1004 still has no sale to belong to.

Supplier purchase cost allocation
PurchaseNet costLinked salesAllocatedStatus
P100163.00S100163.00Fully allocated
P100280.00S100280.00Fully allocated
P100360.00S1003 + S100460.00Fully allocated
P100424.00No sale linked0.00Unallocated
The two open items need review.

S1005 has $40 in proceeds but no purchase link. P1004 has $24 in unused purchase cost. The app keeps both visible. It does not guess that they belong together.

Inspect the sources

Open only what you need.

Compare the inputs with the finished result.
All files use fictional records.

Use your own prepared files

The offline reconciler.

Map columns, choose date and money formats, link purchases to sales and export the review. The application runs in your browser without uploading customer data.

View the full application

Check the fit first.

  • Prepared CSVs with totals for each complete sale and purchase.
  • Explicit purchase links and one currency per matched allocation.
  • No marketplace API connection or automatic matching.
  • Native transaction or line-item exports may need preparation. Renaming a heading alone may not be enough.
  • For eBay, use Order earnings, not Net order earnings, in earnings mode.

Contribution profit is before overheads and income tax. The as-of date labels the supplied snapshot. It does not filter input rows. Later refunds can change the result. No currency conversion.