Your Cart
Loading

Reseller Stock & Profit Tracker | English XLSX Workbook

On Sale
$9.99
$9.99
Added to cart

Stop guessing what an item really earned after fees and shipping.


Reseller Stock & Profit Tracker keeps your one-off inventory and completed sales in one manual workbook. See how much stock cost is still tied up, which items have been held longest and what each completed sale earned after its recorded direct costs.


What you can track

• One physical item per SKU, with category, supplier, acquisition date, cost, preparation costs and notes.

• Gross receipts, platform/payment fees, outbound shipping and other selling costs.

• Net receipts, net item profit, item margin and days to sale.

• Current in-stock count and cost, four stock-age buckets and an adjustable age alert.

• A rolling 12-month completed-sales summary, plus all-record headline totals.

• Full-return history and later resale using the documented workflow.

• Common input warnings, including duplicate SKUs, unknown sale SKUs, duplicate completed sales, bad dates and invalid amounts.


Your download includes

1) Blank XLSX with 500 unique-item Stock rows and 1,000 Sales/history rows.

2) Fictional worked-example XLSX, including loss, full-return and resale cases.

3) Five-page PDF quick start and field guide.

4) Blank printable stock-count PDF.

5) Fixed example-dashboard PDF.

6) A plain-text readme.


The workbook also generates a 25-item physical count page from valid in-stock records. Change the page number to print the next set.


Read before buying

This is for manually tracking one-off items, not quantity-based inventory. It uses one currency per file, with money entered to at most two decimal places. It has no marketplace imports or automatic synchronization.


Net item profit subtracts recorded acquisition, preparation and direct selling costs. It is not business-wide net profit and does not include tax/VAT, overheads, financing, owner pay or omitted expenses. It is not a bank reconciliation or locked accounting ledger. Changing sale states or item costs can change older monthly figures.


The full-return workflow excludes the original sale and carries any nonrecoverable costs into that item's preparation-cost basis. Partial refunds/returns, chargebacks and detailed refund-settlement accounting are not supported. Do not use it as a substitute for formal accounts or professional advice.


Dashboard totals do not change when you filter an input table. Stay within the prepared row limits. The files are digital downloads; no physical item is included. All preview transactions are fictional.


Software

XLSX with standard spreadsheet formulas, no macros and no external workbook links. Recalculation and PDF output tested in LibreOffice 7.3. Microsoft Excel and Google Sheets were not directly tested. Desktop spreadsheet software is needed; this is not a mobile app. Compare any imported copy against the supplied example before relying on it.


Worksheet protection has no password and reduces accidental formula edits. Filters are available; whole-table sorting requires unprotecting the sheet. Keep a backup before advanced edits.

You will get a ZIP (302KB) file