Enter or review these records before relying on the summary.
Suggested for your taskFor people following several online purchases
Shopping, Deliveries & Returns Workbook
From the order to the money actually returned.
Connect purchases to partial deliveries, return records and actual refund transactions. Review what arrived, what still needs returning and what you really spent.
Excel 2021, Excel 2024 or Microsoft 365 with XMATCH; native compatibility not verified. Spreadsheet software is separate.
- Format
- Excel · .xlsx
- Inside
- 10 worksheets
- Included
- Clean file + example + guide
$6.90USD · one-time priceVAT included where applicable. Other applicable taxes are shown at checkout.Explore the sheets Follow the real example
Check the capacity and fitWho it is for, supplied record limits and software requirements
The everyday problem
From the order to the money actually returned.
Connect purchases to partial deliveries, return records and actual refund transactions. Review what arrived, what still needs returning and what you really spent.
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 summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
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 10 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the complete setup guideThe complete product. Your starting choices do not change its contents or price.
Your choices help you understand the complete product. They do not alter its contents or price.
Both XLSX files, all 10 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
Record the purchase. 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 summary.
- Start: Enter or review these records before relying on the summary.
- Settings: Enter or review these records before relying on the summary.
- Merchants: Enter or review these records before relying on the summary.
- Orders: Enter or review these records before relying on the summary.
- Order Lines: Enter or review these records before relying on the summary.
- Deliveries: Enter or review these records before relying on the summary.
- Returns: Enter or review these records before relying on the summary.
- Refunds: Enter or review these records before relying on the summary.
- Order Review: Enter or review these records before relying on the summary.
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. shopping-returns-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. shopping-returns-clean.xlsx
Follow the complete first taskUse the included guide and a disposable example copy.
Your first useful session / Start with the example
Record the purchase
Follow this one complete task before entering your own records. Keep the blank original and save a working copy.
Record the purchase
Add the merchant, one order and its item lines. Enter the actual line discount and order postage separately.
Inspect OrdersFollow partial deliveries
Link each receipt of goods to its Line ID. Returns keeps quantity, requested money and actual sending date separate.
Inspect DeliveriesReconcile actual refunds
Link received refund transactions to the Return ID. Order Review shows what was ordered, refunded and actually retained.
Inspect Refunds
EVERY WORKSHEET / ACTUAL EXAMPLE FILE
See what you enter.
Understand what updates.
Inspect all 10 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 results and source warnings.
- You enter
- Review linked input records
- Calculated or supplied reference
- Labelled results and source warnings
Actual example worksheet · Preview range A1:D40. Image only; entries are made in your downloaded workbook.
Start
Start: First useful task.
- You enter
- Read the route through the file
- Calculated or supplied reference
- First useful task
Actual example worksheet · Preview range A1:D27. Image only; entries are made in your downloaded workbook.
Settings
Settings: Chosen settings.
- You enter
- Review date, period and chosen assumptions
- Calculated or supplied reference
- Chosen settings
Actual example worksheet · Preview range A1:D14. Image only; entries are made in your downloaded workbook.
Merchants
Merchants: 100 supplied input rows.
- You enter
- Record ID, Merchant, Policy / contact reference
- Calculated or supplied reference
- Input check
Actual example worksheet · Preview range A1:J14. Image only; entries are made in your downloaded workbook.
Orders
Orders: 200 supplied input rows.
- You enter
- Record ID, Merchant ID, Placed on, Order postage, Merchant order reference, State
- Calculated or supplied reference
- Gross purchase, Actual refunded, Net purchase
Actual example worksheet · Preview range A1:M14. Image only; entries are made in your downloaded workbook.
Order Lines
Order Lines: 1000 supplied input rows.
- You enter
- Record ID, Order ID, Item, Ordered quantity, Unit price, Line discount, Confirmed return by
- Calculated or supplied reference
- Line net, Received quantity, Sent back quantity, Still to receive, Return deadline state
Actual example worksheet · Preview range A1:F14. Image only; entries are made in your downloaded workbook.
Deliveries
Deliveries: 600 supplied input rows.
- You enter
- Record ID, Line ID, Received on, Quantity received, Reference / short note
- Calculated or supplied reference
- Input check
Actual example worksheet · Preview range A1:K14. Image only; entries are made in your downloaded workbook.
Returns
Returns: 400 supplied input rows.
- You enter
- Record ID, Line ID, Opened on, Quantity requested, Refund requested, State, Sent on, Reference / short note
- Calculated or supplied reference
- Actual refunded, Requested still unpaid
Actual example worksheet · Preview range A1:H14. Image only; entries are made in your downloaded workbook.
Refunds
Refunds: 400 supplied input rows.
- You enter
- Record ID, Return ID, Received on, Actual refund, Transaction reference
- Calculated or supplied reference
- Order ID, Refund amount
Actual example worksheet · Preview range A1:F19. Image only; entries are made in your downloaded workbook.
Order Review
Order Review: Calculated review of linked records.
- You enter
- Review linked input records
- Calculated or supplied reference
- Calculated review of linked records
Follow the supplied fictional exampleRead the inputs and the result together
From the supplied fictional example
The supplied fictional example
Two baskets at $25 plus $4 postage create a $54 order. An actual $12 refund leaves $42 net. A requested refund without received money leaves $54.
- Items
- 2 × USD 25
- Postage
- USD 4
- Refund received
- USD 12
- Gross order
- USD 54
- Actual refund
- USD 12
- Net purchase
- USD 42
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
Items 2 × USD 25
Postage USD 4
Refund received USD 12
Two baskets at $25 plus $4 postage create a $54 order. An actual $12 refund leaves $42 net. A requested refund without received money leaves $54.
- Gross order
- USD 54
- Actual refund
- USD 12
- Net purchase
- USD 42
This is an explanation of the downloadable workbook, not an online editor. Its complete clean and worked files are included. Save a working copy. Manual entry, with 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
Record the purchase
You enterAdd the merchant, one order and its item lines. Enter the actual line discount and order postage separately.
CalculatedThe linked records and input checks use the same stable IDs and your chosen dates.
Your next stepReview the labelled results and correct source warnings before acting.
- 02
Follow partial deliveries
You enterLink each receipt of goods to its Line ID. Returns keeps quantity, requested money and actual sending date separate.
CalculatedThe linked records and input checks use the same stable IDs and your chosen dates.
Your next stepReview the labelled results and correct source warnings before acting.
- 03
Reconcile actual refunds
You enterLink received refund transactions to the Return ID. Order Review shows what was ordered, refunded and actually retained.
CalculatedThe linked records and input checks use the same stable IDs and your chosen dates.
Your next stepReview the labelled results and correct source warnings before acting.
10 sheets. Inspect each one.Inputs, outputs and when to use every worksheet
StartOpen sheet details
Editable inputs
- Read the route through the file
Calculated or reference
- First useful task
Enter or review these records before relying on the summary.
Inspect the actual Start sheetSettingsOpen sheet details
Editable inputs
- Review date, period and chosen assumptions
Calculated or reference
- Chosen settings
Enter or review these records before relying on the summary.
Inspect the actual Settings sheetMerchantsOpen sheet details
Editable inputs
- Record ID, Merchant, Policy / contact reference
Calculated or reference
- Input check
Enter or review these records before relying on the summary.
Inspect the actual Merchants sheetOrdersOpen sheet details
Editable inputs
- Record ID, Merchant ID, Placed on, Order postage, Merchant order reference, State
Calculated or reference
- Gross purchase, Actual refunded, Net purchase
Enter or review these records before relying on the summary.
Inspect the actual Orders sheetOrder LinesOpen sheet details
Editable inputs
- Record ID, Order ID, Item, Ordered quantity, Unit price, Line discount, Confirmed return by
Calculated or reference
- Line net, Received quantity, Sent back quantity, Still to receive, Return deadline state
Enter or review these records before relying on the summary.
Inspect the actual Order Lines sheetDeliveriesOpen sheet details
Editable inputs
- Record ID, Line ID, Received on, Quantity received, Reference / short note
Calculated or reference
- Input check
Enter or review these records before relying on the summary.
Inspect the actual Deliveries sheetReturnsOpen sheet details
Editable inputs
- Record ID, Line ID, Opened on, Quantity requested, Refund requested, State, Sent on, Reference / short note
Calculated or reference
- Actual refunded, Requested still unpaid
Enter or review these records before relying on the summary.
Inspect the actual Returns sheetRefundsOpen sheet details
Editable inputs
- Record ID, Return ID, Received on, Actual refund, Transaction reference
Calculated or reference
- Order ID, Refund amount
Enter or review these records before relying on the summary.
Inspect the actual Refunds sheetOrder ReviewOpen sheet details
Editable inputs
- Review linked input records
Calculated or reference
- Calculated review of linked records
Enter or review these records before relying on the summary.
Inspect the actual Order Review sheetDashboardOpen sheet details
Editable inputs
- Review linked input records
Calculated or reference
- Labelled results and source warnings
Enter or review these records before relying on the summary.
Inspect the actual Dashboard sheetFiles, capacities and practical limitsRead these before choosing your working copy
The download
Files with a purpose.
START_HERE.pdf
One guide: first session, file index, practical limits, recovery and license.
shopping-returns-clean.xlsx
Empty workbook. Save As a working copy before entering your records.
shopping-returns-example.xlsx
The same workbook with fictional records and checked results.
English instructions, sheet names and field labels.
Before you choose
Fit and practical limits.
- For people following several online purchases
Understand the boundaries.
- Save a working copy. Manual entry, with no automatic sync or external connections.
- Supplied tables have fixed capacities. Extend formulas, tables and validation together before using extra rows.
- Use one currency. Blank means unknown; enter 0 when the amount is known to be zero.
- Resolve the highlighted input rows before relying on the summary.
- Uses exact-mode XMATCH. Requires Excel 2021, Excel 2024 or Microsoft 365; older Excel editions are not supported. Native Excel, Google Sheets and Numbers have not been verified.
- Return dates and eligibility are entered from the merchant policy. This workbook does not decide consumer rights.
- Requested refunds do not reduce actual spending. Record a refund only when the money has arrived.
- Keep historical unit prices, line discounts and order postage. One line can have several partial deliveries and returns.
- Cancelled is for an unsent request with no actual refund. Keep the record; its quantity and requested money leave the active totals. One bank transaction links to one return record; combined transaction allocation across different returns is not supplied. Order cancellation covers the whole order; partial item cancellation is outside this edition. Closed without sending records a merchant-confirmed resolution without inventing a physical handover.
Excel 2021, Excel 2024 or Microsoft 365 with XMATCH; native compatibility not verified. Local digital-engine tests are separate from native application verification.
Shopping, Deliveries & Returns 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.
$6.90USD · One-time purchaseVAT included where applicable. Other applicable taxes are shown at checkout.
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.
Must I connect an account?
No. The files use your manual records and have no external account connection.
Can I add unlimited records?
No. Supplied capacities are listed. Extend all affected formulas, tables and validations together before using extra rows.
Why does a result ask me to review inputs?
Correct the Input check at its source. Keep a backup before changing stable IDs, dates or assumptions; do not replace the formula with a typed result.