Finding the Leak in the Books
Gross revenue is a vanity number. Real profit is gross minus fees, minus shipping, minus label corrections, minus cost of goods, and it was the label corrections that were quietly eating me alive.
The trap in the shipping specifics
Here's the trap. When you enter a UPC or run a search, eBay helpfully populates the shipping specifics, package dimensions and weight. I trusted those. They were wrong. The moment a package hits USPS, UPS, or FedEx, the carrier measures and weighs it for real, and if your numbers were off, they adjust it and eBay bills you the difference after the fact. I was paying anywhere from $2 to sometimes $10 or $15 more per shipment than I thought, and it wasn't showing up cleanly in the eBay app when I glanced at my numbers. (I'll spare you the conspiracy theory about whether chronic underweighting earns you demerits with the carriers; I have no proof, just a hunch and a lighter wallet.)
Building my own books
So I built my own books. A small SQLite database syncs my orders and every financial transaction from eBay's APIs, nightly, and produces a per-item profit-and-loss: what each item actually netted, and my true ROI on every sourcing decision. When I first loaded real numbers in, the picture wasn't the one eBay had been showing me. What I thought was 10 to 15% profit was, on plenty of items, negative. That's e-commerce, you win by killing overhead you didn't even know you had.
Why build it instead of buying it
eBay offers some of this, but basic and shaped the way eBay wants. Third-party apps offer more, if you'll hand them access to your data, pay monthly, and accept the view of your business they think is best for you. But double-entry bookkeeping has been around since Roman times, and the tools to do it yourself have existed since the Apple II. With API access I can pull my own data and slice it the way I work. Every item I buy is a small bet, and now I get to see exactly how each bet turned out. That feedback loop is the single most valuable thing I've built.