Skip to content

All projects

Seller Profit Tracker

A Google sheet for profit on each order, after fees, shipping and the cost of goods. It has a fee rule per channel and a monthly summary.

The problem

Marketplace revenue is not profit. The fee, the shipping and the refund were being subtracted by hand.

What I built

  • A fee rule for each channel.
  • Rows for refunds, restocks and cancellations.
  • More than one currency.
  • A monthly P&L, with a tax reserve.

Stack

Google SheetsApps Script

Images

The Seller Profit Tracker cover, with a sample dashboard.
The figures in the image are the sample in the file, not a real shop’s sales.