Bookkeeping for high-volume sneaker resellers: a practical setup

A spreadsheet is fine for a few pairs a month. It breaks at volume for predictable reasons: cost basis gets entered inconsistently, payouts are recorded at the sticker rather than the net, sales across five marketplaces never quite reconcile, and the VAT column is whatever you remembered to type. By the time you notice, the data is months deep and wrong.

The root problem is that the spreadsheet is a second, manual copy of data that already exists in your operation. Every manual copy drifts. The practical setup eliminates the copy.

The numbers a bookkeeper needs already exist at the moment of each event — they just need to be captured then, not reconstructed 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.

Capture each at its moment and reconciliation stops being a monthly archaeology project.

Reseller bookkeeping has two sources of truth that a single spreadsheet column always blurs, and the Sales tab keeps them distinct 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, carrying the extra per-unit data your Inventory tab holds, like cost basis.

Keeping the two side by side is what makes reconciliation possible. Account Sales tell you what the platforms say you sold and will pay; Inventory Sales tie those 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 — and you can only see it cleanly when the two views are linked rather than mashed into one row you maintain by hand.

The reconciliation those two views enable is the heart of clean reseller books. Match a platform payout (Account Sales) to the unit it sold (Inventory Sales) and you get true per-sale margin: payout minus cost basis, after fees and VAT. Do that consistently and "how much did I actually make this month" stops being an estimate and becomes a number you can stand behind.

Small flags carry real weight here. A billed flag tracks whether a unit's invoice has been generated, so nothing slips un-invoiced; carrier assignment ties each sale to its shipment; and proof of delivery can be pulled in bulk and kept with the sale it backs. Each is a field captured at the right moment, which is what stops the end-of-period scramble before it starts.

Everything then feeds the same analytics. Because paid/pending, cost, payout and VAT are captured per sale, the Dashboard and Analytics can show real revenue versus pending value, profit forecasts and grouped SKU performance without you maintaining a parallel spreadsheet. The books aren't a second system you keep in sync with the operation — they are the operation, read from a different angle.

The backbone of reseller bookkeeping is 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, where you mark each payout paid or pending.

That distinction between paid and pending is the one most spreadsheets lose, and it's the one that matters for cash flow and for knowing which payouts to chase.

The single distinction most spreadsheets lose is paid versus pending, and it's the one that governs cash flow. In the Sales tab you mark each payout paid or pending payment, so at any moment you know what's actually landed versus what's still in transit or being processed. That's not pedantry — it's the difference between knowing your real available cash and guessing at it.

Tracked properly, the paid/pending split also feeds everything downstream: invoices generate from paid sales, and analytics can separate booked revenue from pending value. Capture the status at the moment it's true and the rest of your books stay honest without a monthly reconstruction.

Good bookkeeping leans on documents that already exist. Because invoices generate from sale data and carry the right VAT mode per profile, and proof of delivery is pulled with each shipment, your paper trail accumulates as you operate rather than as a separate end-of-month scramble.

The invoice generator and the documentation suite mean the bookkeeping artefacts are a by-product of selling, not a second job.

Day to day, you don't want to assemble numbers — you want to glance at 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), with your stock grouped by SKU so you can see which lines carry the most upside.

Two details make it trustworthy as a check rather than a vanity screen. Colour-coded trend indicators next to Inventory Value and Forecasted Profit show the change since the last refresh, and missing-price counters (Errors, Loaded, Remaining) tell you when a number rests on incomplete data — with a one-click scrape to fill the gaps. A SKU group showing Error simply lacks price data, usually resolved on the next update or by a quick Comparator look-up. The Dashboard is where a bookkeeping problem becomes visible while it's still small enough to fix in a minute.

The real test of a bookkeeping setup is what year-end feels like. Done the manual way, it's an archaeology dig: reconstructing cost bases, chasing which payouts actually landed, rebuilding invoices you never made. Done with everything captured at the source, it's mostly export and review — the work already happened, in small pieces, as you operated.

That's the cumulative payoff of the previous steps. 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 accumulated as by-products; and the Dashboard caught anomalies monthly. By December there's no backlog to recreate — there's 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. A calm year-end isn't a reward for a heroic December; it's the natural result of never letting the data drift in the first place.

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

Used as a monthly check, it catches the things that slip: a payout marked pending that's actually landed, a SKU group quietly selling below cost, a month where pending value is ballooning because confirmations are lagging. The dashboard is where you notice a bookkeeping problem while it's still small.

Bookkeeping at volume isn't about doing more admin. It's about capturing each number once, at the moment it's true, and never copying 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.