Skip to content
PN Scripts

Business spreadsheets

Reseller Profit & Inventory Tracker (Excel / Google Sheets)

A spreadsheet for US resellers who buy by the lot: split a lot's cost across its items, set your own platform fees, see profit per item and per lot, and get the Schedule C cost of goods sold lines at year end. Excel, LibreOffice and Google Sheets.

  • Microsoft Excel (.xlsx)
  • LibreOffice Calc (.ods)
  • Google Sheets
  • PDF
  • Paid
  • External marketplace: Gumroad
Buy on Gumroad (opens in a new tab)

Sold on Gumroad. PN Scripts does not take payment for it here.

Business spreadsheets
The Dashboard sheet of the example workbook with sales, profit, net profit, items sold, stock at cost and tax set-aside, a sales and profit chart by month and results by platform

What it solves

The gap

Resellers buy in lots, sell item by item on several platforms with different fees, and at tax time still have to work out what the items they sold actually cost.

What it is

One workbook that splits each lot's cost across its items, applies your own fee profile for each platform and turns the item list into the Schedule C cost of goods sold lines.

How you use it

Download the ZIP from Gumroad, enter your settings and fees once, then add lots and items as you buy and sell.

Built for flippers who buy by the lot: cost allocation, editable fee profiles and a Schedule C Part III helper in a plain workbook without macros or a subscription.

Who it is for

Use it when

  • Thrift, estate sale, garage sale and storage unit flipping.
  • Selling on eBay, Poshmark, Mercari, Depop, Etsy, Facebook Marketplace, Whatnot or Vinted, or locally for cash.
  • Preparing cost of goods sold and expense figures for Schedule C (Form 1040).

Built for

  • Part-time and full-time resellers in the United States who file Schedule C.
  • Sellers who buy in lots and want profit per item and per lot without a subscription app.

What is inside

Lots and bundles

Enter a lot once with what you paid. Its cost is split across the items that carry its ID, equally or by expected price, and the Lots sheet shows items entered, expected sales, sold so far and profit so far, with a check column for a lot whose cost is not fully allocated.

Inventory and sales

One row per item from purchase to sale: platform, sale price, shipping charged, label, supplies and an optional exact fee. The workbook adds item cost, fees, profit, ROI, days to sell and age, and marks unsold items older than your limit in red.

Your fee profiles

No fee tables are built in, because fees change and depend on your account. You enter each platform's current percentage, fixed fee, fee on shipping and payment processing once; the example file uses illustrative numbers.

Schedule C helper

Part III cost of goods sold with beginning and ending inventory worked out from your item list and a check line, then gross income, expenses by line and net profit, plus a self-employment tax and set-aside estimate.

Dashboard

Sales, profit, net profit, items sold, stock at cost and a suggested tax set-aside, with sales and profit by month, results by platform and unsold stock by age.

Specs

Vendor
PN Scripts
Type
Template
Latest version
v1.0
Pricing
One-time purchase · USD 14.00 Price on Gumroad.
License
Commercial license
Deployment
Download (ZIP: .xlsx, .ods and PDF guide)
Maturity
v1.0, released 2026-10-06

Compatibility

Platform or runtime Supported versions Tested up to
Microsoft Excel 2019 or newer Not stated
LibreOffice Calc 7 or newer 24.2

Releases

  1. v1.0

Stack

  • Microsoft Excel (.xlsx)
  • LibreOffice Calc (.ods)
  • Google Sheets
  • PDF

Get the Reseller Profit & Inventory Tracker

Buy it on Gumroad: blank and example workbooks for Excel and LibreOffice, a PDF guide and Google Sheets instructions in one ZIP.

Buy on Gumroad (opens in a new tab)

Sold on Gumroad. PN Scripts does not take payment for it here.

Questions

Yes. Upload the .xlsx file to Google Drive, open it with Google Sheets and save it as a Google Sheets file; the instructions are in the ZIP. Google does not carry over the sheet protection.

Excel 2019, 2021, 2024 or Microsoft 365, LibreOffice, or Google Sheets. It does not work in Excel 2016 or older or in Apple Numbers. There are no macros.

The platform list is ready, but you enter your own current fees once, because fees change and depend on your account. The example file uses illustrative numbers.

Yes. Enter them with their purchase date and they count as beginning inventory. Older stock you do not list item by item can go in as one opening amount.

No, it is a tool. Line references follow Schedule C (Form 1040); check the current IRS instructions or ask a tax professional.

Use them for your own business and make as many copies as you need for yourself. Do not resell, share or publish the template.

The workbook is generated from code, and its tests recalculate the example workbook in LibreOffice and compare every result with an independent model. Created with AI assistance; every formula is checked by PN Scripts with automated recalculation tests.

On Gumroad, which takes the payment and delivers the download. PN Scripts does not take payment on this site.