Bookkeeping for high-volume sneaker resellers: a practical setup

A spreadsheet is fine for a few pairs a month. At volume it breaks for four reasons. Cost basis gets entered inconsistently. Payouts are recorded at the sticker price, not the net. Sales across five marketplaces never quite reconcile. The VAT column holds whatever you remembered to type. By the time you notice, the data is months deep and wrong.

The spreadsheet is a second, manual copy of data that already exists in your business. Every manual copy goes out of sync. This setup removes the copy.

The numbers a bookkeeper needs already exist when each event happens. Record them then, so you don't rebuild them later.

• Cost basis is set at intake, per unit, when you add stock to Inventory.
• Net payout is known at sale, pulled from the sale itself rather than the ask.
• VAT treatment is fixed per business profile and controller, so it's consistent across every document.
• Delivery proof is downloaded with the shipment, attached to the order.

With each number recorded at its moment, you no longer have to dig through old records every month to reconcile.

Reseller bookkeeping has two sources of truth, and a single spreadsheet column blurs them. The Sales tab keeps them apart on purpose. Account Sales are pulled live from your connected platforms. Click Load Sales and the tool gathers transactions across every linked account, each with its payout. Inventory Sales are the items from your own stock marked Sold. They carry the extra per-unit data your Inventory tab holds, like cost basis.

You need the two side by side to reconcile. Account Sales tell you what the platforms say you sold and will pay. Inventory Sales tie those sales back to specific units you owned and what they cost you. The gap between "a platform paid me X" and "that unit cost me Y" is your actual margin. You only see it cleanly when the two views are linked, not merged into one row you maintain by hand.

Match a platform payout (Account Sales) to the unit it sold (Inventory Sales) and you get the true margin per sale: payout minus cost basis, after fees and VAT. Do that every time and "how much did I make this month" becomes a number you can stand behind, not an estimate.

Three small fields matter here. A billed flag tracks whether a unit's invoice has been generated, so no sale goes un-invoiced. Carrier assignment ties each sale to its shipment. Proof of delivery can be pulled in bulk and kept with the sale it backs. Each field is recorded at the right moment, so there's no end-of-period scramble.

Everything then feeds the same analytics. Paid/pending, cost, payout and VAT are captured per sale. So the Dashboard and Analytics can show real revenue versus pending value, profit forecasts and grouped SKU performance, and you don't keep a parallel spreadsheet. Your books come from the same records you sell from, so there's no second system to keep in sync.

Reseller bookkeeping depends on knowing, at any moment, what sold, what's been paid and what's still outstanding. Sales and payout tracking pulls Account Sales live from your platforms and Inventory Sales from your own stock into one tab. There you mark each payout paid or pending.

Most spreadsheets lose the difference between paid and pending. You need it for cash flow and to know which payouts to chase.

Paid versus pending decides your cash flow. In the Sales tab you mark each payout paid or pending payment. At any moment you know what has landed and what's still in transit or being processed. That tells you your real available cash, so you don't have to guess.

The paid/pending split also feeds the later steps. Invoices generate from paid sales, and analytics can separate booked revenue from pending value. Record the status when it changes and you won't need to rebuild your books each month.

Good bookkeeping uses documents that already exist. Invoices generate from sale data and carry the right VAT mode per profile. Proof of delivery is pulled with each shipment. So your paper trail builds up as you sell, and there's no separate end-of-month scramble.

With the invoice generator and the documentation suite, your bookkeeping documents are a by-product of selling, not a second job.

Day to day, you want to glance at numbers, not assemble them. The Dashboard gives a real-time snapshot in two halves. Sales Overview shows Total Sales, Revenue Generated, Pending Value and Net Income for your selected timeframe. Inventory Insights shows Inventory Value (the market value of current stock) and Forecasted Profit (projected against current best market prices). Your stock is grouped by SKU, so you can see which lines carry the most upside.

Two details let you use it as a check. Colour-coded trend indicators next to Inventory Value and Forecasted Profit show the change since the last refresh. Missing-price counters (Errors, Loaded, Remaining) tell you when a number rests on incomplete data, and a one-click scrape fills the gaps. A SKU group showing Error simply lacks price data. The next update or a quick Comparator look-up usually resolves it. On the Dashboard you can spot a bookkeeping problem while it still takes a minute to fix.

Year-end shows whether a bookkeeping setup works. Done by hand, you reconstruct cost bases, chase which payouts landed and rebuild invoices you never made. With everything captured at the source, year-end is mostly export and review. The work already happened, in small pieces, as you sold.

Each earlier step feeds this one. Cost basis was set at intake. Payout and its paid/pending status were captured at sale. VAT mode was fixed per profile. Invoices and proof of delivery built up as by-products. The Dashboard caught anomalies monthly. By December there's no backlog to recreate, only a clean trail to hand over. Analytics exports to CSV and invoices already sit in LexOffice, SevDesk, Fakturownia or Infakt, so your accountant works from live records.

The last piece is a regular look at the totals. Analytics shows revenue, pending value, market value, profit forecasts and grouped sales behaviour from one dashboard. It has CSV export for when your accountant wants the raw data.

Used as a monthly check, it catches three things that slip. A payout is marked pending but has landed. A SKU group is selling below cost. Pending value is growing fast because confirmations are lagging. You notice the problem while it's still small.

Bookkeeping at volume doesn't mean more admin. Capture each number once, at the moment it's true, and never copy it by hand again.

RestocksAIO operating principle

For the tax side of this, pair the setup with the VAT guide and the invoicing guide in this cluster.