Import your reseller tracker into Google Sheets
FatFat Studio · Updated 2 November 2026 · Reseller Tracker v0.2.2
Import the supplied Blank .xlsx file into a new Google Sheets spreadsheet on a computer. Start in a practice copy with fictional records, then import a fresh Blank file for your working inventory.
Before importing.
- Download and extract the complete ZIP from your chosen checkout platform. Keep the original files unchanged as a backup.
- Read README_EN.txt, Practical_Guide_EN.pdf and the additional import notes in the package.
- Use a computer, a browser and your own Google account. The .xlsx is an import file; opening it in Excel does not complete the Google Sheets setup.
Already have inventory in another spreadsheet?
These import steps open the supplied template as a new workbook; they do not migrate your existing inventory. There is no one-click transfer from another spreadsheet or the free SKU & storage map. Keep your original records unchanged. Practise with fictional items first, and enter working data only in the designated input areas. Do not paste an entire old sheet over the tracker’s formulas.
Moving from the free SKU & Storage Map
You can reuse three fields from the free worksheet. Move them into the matching input columns in a practice copy of Reseller Tracker v0.2.2 first. This is a manual transfer, not an automatic import of stock or sales history.
| Free Storage Map | Paid Inventory tab | Check before moving |
|---|---|---|
| A · SKU | A · SKU | Keep the same unique text identifier, including any leading zeros. Exclude the supplied SAMPLE rows. |
| B · Item description | B · Item | Confirm the description identifies the physical item you own. |
| C · Recorded location | G · Location | Check where the item is now. The destination is column G, not column C. |
| D–G · Location check, Next action, Last checked, Notes | No direct transfer | Keep these in the original map as your location-check history. Last checked is not a purchase or first-listed date. |
- Reconcile the items first. Start with located, unsold items you own. Resolve missing items, sold stock and pending returns before treating them as available inventory. Keep the original map unchanged.
- Practise with three fictional items. Follow the new-workbook steps below. Use separate test SKUs and keep this practice copy out of your working records.
- Move one column at a time as values. Enter SKU, description and confirmed location in the three named input columns. Do not paste the free worksheet’s entire A–G range into Inventory A–G: the columns have different meanings.
- Add the required cost records. The free map does not hold purchase date, purchase cost or preparation cost. Obtain those from your own records. Use 0 only for a cost you know did not apply; do not invent dates or costs to clear an error.
- Check before moving more. Confirm each item’s Input status is OK, its location is correct and its Stock state matches the stock you physically hold. Follow one practice item through the sale, refund and saleable-return sequence. Start a fresh working copy only after the practice checks pass.
In the paid Inventory tab, H–O and U–AB contain calculated fields. Preserve them. The free map does not supply sales or refund history; copying its rows does not create Events records or reconstruct past results.
Create a new spreadsheet.
- In Google Sheets, choose File → Import → Upload → Browse and select the supplied Blank workbook.
- Choose Create new spreadsheet, then Import data → Open now. Do not replace an existing spreadsheet or sheet containing your records.
- Rename this copy Practice. Keep the fictional Example workbook separate as a learning reference.
- Follow the package's first-run checks for spreadsheet time zone, currency and dates. Repeat them for every new imported file.
Menu labels can vary with your Google interface language. Follow the equivalent import action and verify that you are creating a new spreadsheet.
Use three fictional records to check your setup.
Enter three distinct sample items in the designated input areas. Use unique SKUs, a consistent currency and unambiguous dates. Compare the displayed information with the supplied Example and the written guide.
- Identity: each event belongs to the intended SKU, without duplicates.
- Dates: purchase, sale and first-listing dates are interpreted as expected. A value that looks like a date may still be text.
- Amounts: known zero costs use 0; unknown costs must be resolved rather than assumed to be zero.
- Results: follow the supplied sale example from inputs through item status and summary totals. Preserve formula areas.
Then practise the refund and saleable-return sequence. Once the practice checks are understood, import Blank again as a fresh working spreadsheet. Keep fictional records out of your real inventory file.
Check these details before entering a full inventory
| Detail | Try in your practice copy | Check before continuing |
|---|---|---|
| Item identity | Use a text SKU such as RT-0007. | Use the identical value for its events. Watch for extra spaces and a different item's SKU. |
| Dates | Choose a date with the date picker where available. | Confirm the displayed day and month. An entry such as 3/4 can be read differently across locales. |
| Costs | Enter 0 for a preparation cost you know did not apply. | Look up an unknown cost before treating the result as complete. Do not use 0 as a placeholder for missing information. |
| Currency | Choose the currency you will use for this workbook. | Keep all amounts in that currency. Changing a currency label does not convert existing values. |
If your old SKUs are numbers with leading zeros, compare them with the original file before entering related events. Preserve the same identity in the item row and event records. Work in the designated input cells and follow the package instructions for cell formats.
Once these checks pass, follow one fictional item through a sale and the refund and return sequence. Check the item status and summary results together before starting your working copy.
Try one new item from purchase to sale
Use a fresh, empty Practice import of Blank for this fictional USD example. You own one new boxed desk lamp and sell it in a one-item order. Keep this exercise separate from existing stock and from the supplied Example file.
Set up this practice copy first. In Settings B25 choose Fits this template, and choose USD in both B4 and B5. Review the spreadsheet locale and time zone as described above. In this practice copy only, set Overview S2 to 28 October 2026 so the report includes the dates below. A fresh real-stock Blank should retain its TODAY() formula.
| Step | Example details | Check |
|---|---|---|
| Record the item | SKU NL-0101; purchased 1 October 2026; cost $14; preparation $2; location A1. | Use its own Inventory row and the same text SKU in the sale. |
| Record the sale | 3 October 2026; item price $32; buyer shipping $0; actual fees $2; postage $3; packing $0. | Enter every required value, including the known zero packing cost. Open the exact fields below. |
| Review the result | $32 + $0 − $14 − $2 − $2 − $3 − $0 = $11 contribution. | The lamp is out of stock. Stock cost is $0; net receipts are $32; contribution is $11 for this practice report. |
Enter the exact cells and values
These row 7 instructions assume an empty Practice copy. Do not overwrite existing records. Enter amounts as numbers without currency symbols. Choose the source and location values shown below from their dropdowns.
Inventory · A7:G7
| Cell and field | Practice value |
|---|---|
| A7 · SKU | NL-0101 |
| B7 · Item | New boxed desk lamp |
| C7 · Source | Other |
| D7 · Purchase date | 1 October 2026; select a real date, not text |
| E7 · Purchase cost | 14.00 |
| F7 · Prep cost | 2.00 |
| G7 · Location | A1 |
Events · A7:N7
| Cell and field | Practice value |
|---|---|
| A7 · Sequence | 1; type a fixed number |
| B7 · Date | 3 October 2026; select a real date, not text |
| C7 · SKU | NL-0101 |
| D7 · Channel | Other |
| E7 · Order reference | NL-ORDER-1 |
| F7 · Sale price | 32.00 |
| G7 · Buyer shipping | 0.00 |
| H7 · Actual fees | 2.00 |
| I7 · Postage | 3.00 |
| J7 · Packing | 0.00 |
| K7 · Adjustment type | SALE |
| L7 · Buyer refund | 0.00 |
| M7 · Fee / postage credits | 0.00 |
| N7 · Notes / return reason | Fictional setup check |
Keep Inventory H–O and U–AB, and Events O–AB, unchanged. They contain calculated fields. Leave the other optional Inventory inputs blank for this first-sale exercise.
Check before continuing. Inventory I7 and Events Q7 should both show OK, and Rows needing correction should be 0. If Events Q7 asks you to confirm H7:J7, check all three actual-cost cells. For this fictional sale, J7 must contain 0; a blank means the packing cost is still unconfirmed.
The $11 is contribution before overhead, owner labour and income tax. Use the free single-sale calculator to check the arithmetic. A known zero is valid; an unknown real cost still needs checking. Twenty lamps under one shared SKU would need quantity-based stock tracking, which this workbook does not provide. Read the refund and saleable-return guide for a separate explanation of that workflow.
If a total or date looks wrong.
If a sale looks too small, check whether you copied a net payout into the sale field and then deducted fees again. Use the original order amounts and actual costs. The sale amount versus net payout example shows the difference using one fictional item.
- Check the guide's required fields and the entry format first.
- Confirm the SKU, event type, sequence, order reference and dates belong together.
- Check that Overview S2 includes the event date. Annual totals follow its calendar year. Keep earlier sale records for a refund or return in a new year.
- Compare an unchanged Example with your practice copy. Avoid adding columns or overwriting formulas to force a result.
- If you still need help, contact [email protected] with your order reference, the step attempted and fictional or redacted screenshots.
You do not need to send a Google password, payment details or real customer records. Do not buy the product again to solve an access issue. Product support terms are on the product page.
Manual records in desktop Google Sheets. No marketplace sync, automatic delisting, automatic currency conversion, tax filing or bank reconciliation. Desktop Excel and a complete mobile workflow are not supported or verified.
Preview the workbook before buying
For owned stock, manual entry, one item per SKU and order, in desktop Google Sheets. Includes space for 300 cumulative item records and 1,000 events. One currency per workbook.
Preview the tracker — US$15 once →Applicable taxes and total shown at checkout. Check the product page for the download, support, license and practical limits.