Pay $30 for the camera. Cash falls by $30, while the same $30 becomes stock at cost. Nothing has sold yet.
Full-history contribution so far$0
−$30 cash + $30 stock at cost = $0 contribution
Step 1 of 4. Buy the camera. Full-history contribution so far $0.
Cash after purchases−$30
+
Stock still on hand, at cost$30
=
Realized contribution$0
Adjust this one fictional cost. The earlier loss stays in the full history.
Return postage in US dollars, between zero and twenty. The original teaching example uses six dollars.
Inspect the records behind the story
Fictional USD records. Changes at each event; totals shown through the selected stage.
Record
Cash change
Stock change at cost
Contribution change
R002 · Buy camera
−$30
+$30
$0
Through this stage
−$30
$30
$0
Source records: R002 camera, S002 first sale, RT001 return and S003 resale from the workbook's fictional worked example.
Interactive explanation of fictional records, not the workbook interface or a customer result. The $12 fee credit is an entered example, not an automatic marketplace policy. Contribution excludes overhead, labor, income tax and unentered costs.
Paid download is an XLSX workbook for desktop Google Sheets import; the web demonstration is not included. Manual entries, one physical item per SKU, no marketplace sync.
Four items, four sales and two refund records. These are the same teaching inputs included in the paid workbook. Read the arithmetic here or download the static CSV records without buying.
SKU R002 stays with the same camera. The first sale S002 receives $100. After $15 fees, $8 postage and $2 packaging, sale cash is $75.
Return RT001 pays a $100 refund and $6 return shipping, with $12 fees credited: a −$94 cash adjustment. Restocking restores the camera's $30 cost basis. First-sale contribution is −$19.
The later sale S003 receives $90. After $12 fees, $8 postage and $2 packaging, sale cash is $68. Subtracting its $30 basis gives $38 contribution. Across both sales: −$19 + $38 = $19.
An unsold item stays in stock.
The $10 book, R003, has no sale record and remains on hand. Its purchase reduces cash, while its $10 cost remains stock. It is not deducted from realized contribution as a sold item.
A partial refund does not restore stock.
The zero-cost mug, R004, leaves $15 sale cash. The buyer keeps it after a $5 partial refund, leaving $10 contribution and no restocked item.
Trace all four sales to the $59 contribution
USD. Return effects belong to their original Sale ID.
Sale / item
Sale cash
Return cash
Basis sold
Basis restored
Contribution
S001 · Jacket
$53
$0
$23
$0
$30
S002 · Camera first sale
$75
−$94
$30
$30
−$19
S003 · Camera resale
$68
$0
$30
$0
$38
S004 · Mug
$15
−$5
$0
$0
$10
Sale cash $211, less $99 return adjustments and $63 acquisition/preparation costs, leaves $49 cash. The $10 unsold book brings the reconciliation to $59 contribution.
Static reference records only. These CSVs have no formulas, validation, linked calculations or operational template. The paid workbook is a separate desktop Google Sheets import. Contribution excludes overhead, labor, income tax and unentered costs. All teaching figures are fictional.
WHAT IT HELPS YOU DO
Cash, stock and contribution are different.
In the fictional worked example, $49 cash after purchases plus $10 stock still on hand reconciles to $59 realized contribution. An unsold item remains stock at cost; its purchase is not also deducted from realized contribution.
Give each physical item a unique SKU and storage location.
Enter acquisition, prep, selling, shipping and return costs.
Handle a partial refund, or a full return followed by resale.
Separate cash after purchases, stock at cost and realized contribution.
Actual reseller workbook illustration of a return, restock and later resale with fictional records. Select to enlarge.
CHECK ONE SALE FIRST · FREE
What did the sale actually leave?
In the fictional camera resale, $90 receipts minus $30 acquisition, $12 actual fees, $8 shipping and $2 packaging leaves $38 contribution for that transaction. The free check lets you enter your own amounts, without a signup.
One completed sale without a refund or return. No platform-rate estimate. Contribution excludes unentered overhead, labor and income tax.
One sale is not the whole history
The same camera had an earlier refunded sale that contributed a $19 loss. The later resale contributes $38, leaving $19 across that item’s complete fictional history. The paid workbook keeps those linked records together.
Cash and unsold stock are different
Across the whole worked example, $49 cash after purchases plus $10 stock still on hand reconciles to $59 realized contribution. That is contribution after entered costs, not complete business net profit.
Use the free check for one transaction; preview the workbook when you need individual stock, sale and return records.
A ZIP containing the XLSX workbook, a three-page PDF Quick Start, START-HERE.txt and USAGE.txt. This is a file to import, not a shared template link. Digital download only; no physical item or custom setup.
Verified workflow
Unzip on desktop, upload to Google Drive, open in Google Sheets and save as Google Sheets. A Google account and internet are required. Other spreadsheet apps and mobile have not been verified. USD display; no currency conversion.
Product limits
One physical item per SKU and sale row; quantity lots and bundles are outside scope. One consolidated return per sale. Same-day restock/resale cycles are not supported. Contribution excludes overhead, labor, tax and unentered costs.
Use your own records. These tools do not guarantee sales or profit and are not complete bookkeeping or tax-filing systems.
READY TO USE YOUR OWN FIGURES?
Reseller Inventory, clearly laid out.
$19 USD · Check the current offer and download details in your chosen shop.
No. Each paid product is a ZIP with an XLSX workbook and two TXT guides. The bakery download also includes a PDF Quick Start. Download and unzip on desktop, upload the XLSX to Google Drive, open in Google Sheets and save as Google Sheets.
Do the spreadsheets connect to my marketplace or bank?
No. These are manual tools. You enter your own figures and actual costs. They do not connect to Etsy, a bank, a POS system or another marketplace.
Can I see an example first?
Yes. Every product page shows actual workbook previews with fictional teaching figures. Try the free single-sale reseller profit check, then compare it with the workbook’s linked stock, sales and returns workflow.
Is support included?
For a file or formula question, contact The Digital Ease Studio through your purchase. Include an anonymized example. Custom setup, integrations and ongoing data entry are outside these downloads.
A little help improving these tools?
Optional PostHog analytics measures visits, tool actions and shop clicks. Calculator entries stay in your browser. Privacy details
