Enter or review these records before relying on the dashboard.
Suggested for your taskFor occasional sellers and small resellers of unique second-hand items
Second-Hand Sales Workbook
Know what a sale actually leaves after its costs.
Track unique objects, listings across channels, actual sales and partial refunds. Review contribution using the amounts you really paid, and see when other listings still need closing.
- Format
- Excel · .xlsx
- Inside
- 8 worksheets
- Included
- Clean file + example + guide
Check the capacity and fitWho it is for, supplied record limits and software requirements
The everyday problem
Know what a sale actually leaves after its costs.
Track unique objects, listings across channels, actual sales and partial refunds. Review contribution using the amounts you really paid, and see when other listings still need closing.
Optional guideNeed help getting started?Choose where to begin. All listed files are included.
Add the complete product to your cart whenever you’re ready. Use this guide only if you’d like help choosing what to open first; your choices do not change the product or its price.
Guide step 1 of 4
What would you like to do?
Pick a useful task, or build your own selection.
Which sheets would you explore first?
Choose your starting points. The workbook keeps all its connected sheets and formulas; this does not remove or rebuild worksheets.
Nothing selected yet.
Enter or review these records before relying on the dashboard.
Suggested for your taskEnter or review these records before relying on the dashboard.
Suggested for your taskEnter or review these records before relying on the dashboard.
Suggested for your taskEnter or review these records before relying on the dashboard.
Suggested for your taskEnter or review these records before relying on the dashboard.
Suggested for your taskEnter or review these records before relying on the dashboard.
Suggested for your taskEnter or review these records before relying on the dashboard.
Suggested for your taskWhich file would you open first?
Both files are included. Choose which one you would open first in a desktop spreadsheet application.
Your starting plan.
Your first file or method
Both XLSX files, all 8 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the complete setup guideYour choices help you understand the complete product. They do not alter its contents or price.
Both XLSX files, all 8 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the tasks, contents and file choices
Useful starting tasks
Start with one connected record.. Use the included START_HERE.pdf guide to follow one complete task in a disposable example copy.
Choose my own starting points. Explore the contents and select only the parts you would use first.
Contents to explore
- Dashboard: Enter or review these records before relying on the dashboard.
- Start: Enter or review these records before relying on the dashboard.
- Settings: Enter or review these records before relying on the dashboard.
- Items: Enter or review these records before relying on the dashboard.
- Listings: Enter or review these records before relying on the dashboard.
- Sales: Enter or review these records before relying on the dashboard.
- Returns: Enter or review these records before relying on the dashboard.
- Item review: Enter or review these records before relying on the dashboard.
Both files are included. Choose which one you would open first in a desktop spreadsheet application.
Explore the worked example: Fictional records show how the sheets work together. Save a disposable copy before trying a change. second-hand-sales-example.xlsx
Start my own working copy: Open the clean workbook after reading the guide. Keep the original and save a copy for your own records. second-hand-sales-clean.xlsx
Follow the complete first taskUse the included guide and a disposable example copy.
Your first useful session / Start with the example
Start with one connected record.
Follow this one complete task before entering your own records. Keep the blank original and save a working copy.
Give the object an ID
Enter one actual item and its acquisition cost in Items. Use that same ID in every channel listing.
Inspect ItemsRecord the completed sale
Enter actual gross payment, shipping collected, fees and shipping paid in Sales. Close other listings manually.
Inspect SalesFollow returns separately
Returns links to Sale ID. Record money refunded, fee credit and extra return postage separately from whether the object came back.
Inspect Returns
EVERY WORKSHEET / ACTUAL EXAMPLE FILE
See what you enter.
Understand what updates.
Inspect all 8 sheets. These are images of the delivered example, with fictional records. Open an image to read its full detail.
Actual example worksheet · Preview range A1:E29. Image only; entries are made in your downloaded workbook.
Dashboard
Dashboard: Labelled summary and input warning count.
- You enter
- Use the linked input sheets
- Calculated or supplied reference
- Labelled summary and input warning count
Actual example worksheet · Preview range A1:D40. Image only; entries are made in your downloaded workbook.
Start
Start: The route through the workbook.
- You enter
- Read the instructions
- Calculated or supplied reference
- The route through the workbook
Actual example worksheet · Preview range A1:D27. Image only; entries are made in your downloaded workbook.
Settings
Settings: Input validation.
- You enter
- Review date, reporting period and currency label
- Calculated or supplied reference
- Input validation
Actual example worksheet · Preview range A1:L14. Image only; entries are made in your downloaded workbook.
Items
Items: 300 supplied input rows.
- You enter
- Record ID, Description, Acquired on, Acquisition cost, Condition, Storage reference, State, Preparation hours
- Calculated or supplied reference
- Completed sales, Live listings, Listing state
Actual example worksheet · Preview range A1:I14. Image only; entries are made in your downloaded workbook.
Listings
Listings: 600 supplied input rows.
- You enter
- Record ID, Item ID, Channel, Listed on, Asking price, State, Reference / short note
- Calculated or supplied reference
- Live count
Actual example worksheet · Preview range A1:N14. Image only; entries are made in your downloaded workbook.
Sales
Sales: 300 supplied input rows.
- You enter
- Record ID, Item ID, Sold on, Item payment, Shipping collected, Fees paid, Shipping paid
- Calculated or supplied reference
- Acquisition cost, Refunds, Fee credits, Extra postage, Net contribution, Sale count
Actual example worksheet · Preview range A1:I14. Image only; entries are made in your downloaded workbook.
Returns
Returns: 300 supplied input rows.
- You enter
- Record ID, Sale ID, Refunded on, Refund paid, Fee credit, Extra postage, Object returned, Reference / short note
- Calculated or supplied reference
- Input check
Actual example worksheet · Preview range A1:F19. Image only; entries are made in your downloaded workbook.
Item review
Item review: Calculated review of the linked records.
- You enter
- Use the linked input sheets
- Calculated or supplied reference
- Calculated review of the linked records
Follow the supplied fictional exampleRead the inputs and the result together
From the supplied fictional example
The supplied fictional example
The fictional completed sale contributes USD 16 after acquisition, actual fees, postage and the recorded refund/credit. Another listing remains open, so the item asks you to close other listings. A refund does not automatically restock it.
- Review date
- 13 October 2026
- Reporting period
- 1–31 October 2026
- Actual sale contribution
- USD 16
- Unclosed cross-channel listing
- 1
FOLLOW THE ACTUAL EXAMPLE FILE
The supplied fictional example
Fictional records from the supplied example XLSX. Follow the same references through the sheets, then start your own clean copy.
The records behind the result
Review date 13 October 2026
Reporting period 1–31 October 2026
The fictional completed sale contributes USD 16 after acquisition, actual fees, postage and the recorded refund/credit. Another listing remains open, so the item asks you to close other listings. A refund does not automatically restock it.
- Actual sale contribution
- USD 16
- Unclosed cross-channel listing
- 1
This is an explanation of the downloadable workbook, not an online editor. Its complete clean and worked files are included. Save a working copy first. Manual entry; no automatic sync or external connections.
Inspect the actual worksheetsFrom setup to a regular review
How you use it.
Open the 3-step setup and review routineInputs, calculations and the decision each step supports
- 01
Give the object an ID
You enterEnter one actual item and its acquisition cost in Items. Use that same ID in every channel listing.
CalculatedLinked records and input checks use the same stable IDs; review the labelled calculated cells.
Your next stepKeep the source record and the review together.
- 02
Record the completed sale
You enterEnter actual gross payment, shipping collected, fees and shipping paid in Sales. Close other listings manually.
CalculatedLinked records and input checks use the same stable IDs; review the labelled calculated cells.
Your next stepKeep the source record and the review together.
- 03
Follow returns separately
You enterReturns links to Sale ID. Record money refunded, fee credit and extra return postage separately from whether the object came back.
CalculatedLinked records and input checks use the same stable IDs; review the labelled calculated cells.
Your next stepKeep the source record and the review together.
8 sheets. Inspect each one.Inputs, outputs and when to use every worksheet
StartOpen sheet details
Editable inputs
- Read the instructions
Calculated or reference
- The route through the workbook
Enter or review these records before relying on the dashboard.
Inspect the actual Start sheetSettingsOpen sheet details
Editable inputs
- Review date, reporting period and currency label
Calculated or reference
- Input validation
Enter or review these records before relying on the dashboard.
Inspect the actual Settings sheetItemsOpen sheet details
Editable inputs
- Record ID, Description, Acquired on, Acquisition cost, Condition, Storage reference, State, Preparation hours
Calculated or reference
- Completed sales, Live listings, Listing state
Enter or review these records before relying on the dashboard.
Inspect the actual Items sheetListingsOpen sheet details
Editable inputs
- Record ID, Item ID, Channel, Listed on, Asking price, State, Reference / short note
Calculated or reference
- Live count
Enter or review these records before relying on the dashboard.
Inspect the actual Listings sheetSalesOpen sheet details
Editable inputs
- Record ID, Item ID, Sold on, Item payment, Shipping collected, Fees paid, Shipping paid
Calculated or reference
- Acquisition cost, Refunds, Fee credits, Extra postage, Net contribution, Sale count
Enter or review these records before relying on the dashboard.
Inspect the actual Sales sheetReturnsOpen sheet details
Editable inputs
- Record ID, Sale ID, Refunded on, Refund paid, Fee credit, Extra postage, Object returned, Reference / short note
Calculated or reference
- Input check
Enter or review these records before relying on the dashboard.
Inspect the actual Returns sheetItem reviewOpen sheet details
Editable inputs
- Use the linked input sheets
Calculated or reference
- Calculated review of the linked records
Enter or review these records before relying on the dashboard.
Inspect the actual Item review sheetDashboardOpen sheet details
Editable inputs
- Use the linked input sheets
Calculated or reference
- Labelled summary and input warning count
Enter or review these records before relying on the dashboard.
Inspect the actual Dashboard sheetCompare with a manual starting pointWhat the connected workbook adds
| What is included | A standalone manual list | Second-Hand Sales Workbook 1.0 |
|---|---|---|
| Connected record IDs | References you carry and check manually | Linked input records with source checks |
| Repeat calculations | Calculated separately by hand | Formula-driven reviews using the workbook dates |
| A complete starting copy | Create and maintain your own structure | Clean XLSX, fictional example and one setup guide |
Files, capacities and practical limitsRead these before choosing your working copy
The download
Files with a purpose.
START_HERE.pdf
Your one guide: first session, file index, limits, recovery and license.
second-hand-sales/second-hand-sales-clean.xlsx
Empty workbook. Save As a working copy before entering your own records.
second-hand-sales/second-hand-sales-example.xlsx
The same workbook with fictional records and reviewed outputs.
English instructions, sheet names and field labels.
Before you choose
Fit and practical limits.
- For occasional sellers and small resellers of unique second-hand items
Understand the boundaries.
- Save a working copy first. Manual entry; no automatic sync or external connections.
- Fixed supplied capacities: extend formulas, tables and validations before adding more rows.
- Use one currency; currency labels do not convert money. No accounting or professional advice.
- Resolve input warnings before using summaries. Blank means unknown; enter 0 for a known zero.
- One unique object can have several listings but only one sale. Split lots before recording individual sales.
- Platform fees and actual postage are entered by you. No marketplace sync, tax return, live fee lookup or inventory valuation.
- A partial refund does not put an item back in stock; enter the physical return separately.
XLSX for a current Excel application. Digital engine tests are separate from native Excel, Google Sheets or Numbers verification.
Second-Hand Sales Workbook / Version 1.0
Your own working copy.
Clean workbook, separate example and one START_HERE.pdf guide covering setup, practical limits and the internal-use license.
Desktop spreadsheet software required; it is not included. Native Excel compatibility is still awaiting verification.
Private preview. Purchases are unavailable while the files and delivery are verified.
Questions about this workbook
The details that affect your choice.
Do I need to connect an account?
No. These are manual, downloadable workbooks with no external connections.
Can I add unlimited rows?
No. The supplied capacities are listed above. Extend every relevant formula, validation and review range before adding records beyond them.
What if the dashboard shows a warning?
Find and correct the Input check in the source table. Do not overwrite the result cell. Keep a backup before changing identifiers.