How to set up bookkeeping for an e-commerce startup before your first sale

An e-commerce startup preparing for its US launch has one narrow window to set up its books correctly: before the first transaction. Once Shopify starts processing orders and Stripe starts collecting payments, the volume of financial data grows fast. Setting up the accounting system after the fact means categorizing historical transactions manually and reconciling discrepancies that compound every week you wait.

This post covers what an e-commerce startup needs to have in place before launch: which systems to connect, how to handle inventory before a formal tracking system is in place, and what the sales tax question requires.

This scenario is drawn from real conversations with Pilot customers.

Which systems does an e-commerce startup need to connect to its accounting software?

The goal is to have every source of financial transactions flowing automatically into QuickBooks (or your accounting software of choice) before your first order ships. For a typical e-commerce startup, that means four categories of integration:

Banking: your business bank account or corporate card (Brex, for example) records every expense and payment. Connecting it directly eliminates manual transaction entry and gives your bookkeeper a complete record of cash flow.

Payments: Stripe processes customer payments and charges fees on each transaction. Those fees need to be recorded separately from gross revenue. A direct integration captures both, along with refunds and chargebacks, without requiring manual reconciliation.

E-commerce platform: Shopify records orders, returns, and sales by product. Connecting Shopify to your accounting system ensures that revenue is recorded when an order is placed or fulfilled, depending on your revenue recognition policy, rather than when Stripe deposits the net proceeds into your bank account. That timing difference matters under accrual accounting.

Payroll: if you have employees or contractors, Gusto or a similar payroll provider records wages, employer taxes, and benefits. Connecting it ensures that payroll expenses appear in your books automatically, in the right period.

Getting all four connected before launch means your books are populated with real data from day one. Getting one or more wrong means reconstructing that data later, which is time-consuming even for low transaction volumes.

How should a pre-revenue e-commerce startup track inventory?

Inventory accounting is one of the more complex areas of e-commerce bookkeeping, and it's one that many startups defer until it becomes a problem.

The core issue: under accrual accounting, inventory is an asset on your balance sheet until it's sold. When you sell a unit, its cost moves from inventory to cost of goods sold (COGS) on your income statement. That movement needs to be recorded correctly for your financial statements to reflect what the business owns and what it earned on each sale.

For a startup without a formal inventory management system, a spreadsheet is a reasonable interim tool, but only if it tracks the right things: units received, units sold, unit cost, and the resulting inventory balance. A spreadsheet that tracks units but not cost, or that doesn't reconcile to the QuickBooks inventory balance monthly, produces financial statements that misstate both assets and profitability.

The practical setup for a pre-revenue startup is: record inventory purchases as an asset when goods are received, update the spreadsheet with unit counts and costs, and reconcile to QuickBooks at month-end. As transaction volume grows, a dedicated inventory tool becomes necessary. But for an early-stage business with a small SKU count, a well-maintained spreadsheet, reviewed monthly by a bookkeeper, is defensible.

What doesn't work: treating inventory purchases as expenses when you pay for them (a cash-basis habit), or not tracking inventory at all until an auditor or investor asks for it.

What does an e-commerce startup need to know about sales tax?

Sales tax is the area of e-commerce accounting where the most founders get caught off guard.

Before 2018, a business only had to collect and remit sales tax in states where it had a physical presence. The Supreme Court's 2018 ruling in South Dakota v. Wayfair, Inc. changed that. States can now require out-of-state sellers to collect and remit sales tax based on economic nexus, meaning the volume of sales or transactions in a state, regardless of physical presence.

Every state sets its own economic nexus threshold. South Dakota's threshold, which the Supreme Court upheld, is $100,000 in annual sales or 200 transactions. Most other states have adopted similar thresholds, though the specifics vary. As an e-commerce company selling nationally, you may trigger nexus in multiple states before you reach meaningful revenue.

The obligations that follow nexus vary too. You need to register with the state's revenue authority, collect the correct sales tax rate (which varies by state and sometimes by county or city), file returns on the schedule the state requires, and remit what you've collected. Failing to do any of these creates a liability that grows with interest and penalties.

For a startup preparing to launch, the right step is not to wait until nexus is triggered. It is to understand which states your customers are likely to be in, confirm whether you've crossed any thresholds, and set up collection before you owe it rather than after.

How does this setup change once the business starts growing?

The integrations and processes that work for a pre-revenue startup with a small SKU count and limited transaction volume will need to evolve as the business scales. The chart of accounts that served a two-person team becomes insufficient for a business with multiple product lines, multiple sales channels, and employees in more than one state.

The advantage of starting with the right structure is that evolution is additive. You're not rebuilding; you're extending. Adding a new sales channel means adding a new integration, not reconstructing historical data. Adding employees in a new state means registering with that state's tax authority and updating payroll, not discovering a multi-year nexus exposure.

Pilot's bookkeeping service for e-commerce companies includes the integrations, the inventory handling, and the sales tax awareness that a growing e-commerce company needs as its transaction volume increases. The setup that works at pre-revenue can carry through to a business processing thousands of orders a month, with the same underlying structure.

KEY TAKEAWAY

An e-commerce startup has one clean opportunity to set up its books: before the first transaction. Connecting your bank, payment processor, e-commerce platform, and payroll before launch costs far less than reconstructing those records after the fact. And the sales tax question isn't one to defer. The threshold for obligation is lower than most founders expect.