How to keep a sourcing and inventory ledger for reselling
Write each item down when you buy it, list it, and close it out when it sells. Margrow keeps that ledger on your iPhone, one item at a time, so you always know what you paid, what is still on hand, and what you made.
What each line of the ledger keeps
| When | What is kept |
| You buy it | Name, photo, date bought, source, cost, expected price, lowest price, category |
| You list it | Marketplace, list price and expected shipping, for as many marketplaces as you list on |
| It sells | Sale price, date sold, fees, shipping label cost, other costs, order number, profit |
| It leaves otherwise | Returned to the source, or written off (including lost), with the date |
Steps in Margrow
- On the Inventory tab, tap + at the bottom right and choose Add one item. Enter the Name, Photo, Bought on date, Source, Cost and Expected price, then tap Save. If you bought several items together, choose Add a bundle.
- When you list an item, open Set List Price on the item to check the price for each marketplace, and record the listing with List at this price.
- When it sells, open Mark as Sold and tap Record sale. With many orders, use Import CSV on the Sales tab to record them from your marketplace’s order file.
- Filter the inventory list by Status and set Sort by to Days in stock to see the items that have been with you longest first.
- At the end of the year, open Tax summary on the Books tab to see Beginning inventory, Purchases, Ending inventory and Cost of goods sold.
Heading out to source? Tap Start a trip on the Sourcing tab and set a Budget. This trip then shows the items you added and how much you spent.
View Margrow on the App Store
Questions
- How do I split the cost of a bundle?
- In Add a bundle, enter the Total paid and the items, then choose Split cost: By expected price, Evenly or Manually. Splitting by expected price puts more of the cost on items you expect to sell for more.
- How do I find items that are not selling?
- Set Sort by to Days in stock in the inventory list. Items older than Flag items after (days) in Settings are marked, and with Reprice reminders on you get a notification on your iPhone.
- Does it give me numbers for my taxes?
- The Tax summary on the Books tab shows, per year, cost of goods sold from beginning inventory, purchases and ending inventory, along with expenses and mileage. The figures are a bookkeeping guide, not tax advice.
- Which order files can I import?
- An eBay Transaction report and an Etsy Sold Orders file are matched automatically. For other CSV files, you choose which column holds each value.
- How do I move my ledger to a new iPhone?
- In Settings, open Export & Backup and use Export backup to save the whole ledger as one file, then open it in Margrow on the new iPhone.
Another way to use it
How to calculate resale profit after fees and shipping