Quick Answer: Setting up bookkeeping for a new online store requires separating your personal and business finances, choosing an accounting method, establishing a system to log inventory and sales channel data, and setting up clean record retention. The IRS explicitly states in Publication 583 that opening a separate business checking account is one of the first steps any new business should take. For founders forming a new entity, starting with a service like ZenBusiness simplifies the sequence by handling LLC formation, securing your EIN, and setting up business account prerequisites before you connect bookkeeping software or hire a service.

Why E-Commerce Bookkeeping Is Unique

Running an online store introduces bookkeeping complexities that general brick-and-mortar businesses rarely face. Instead of a single cash register, an e-commerce business processes payments through multiple sales channels and payment gateways such as Shopify, Amazon, Stripe, and PayPal.

When payment processors pay out funds to your bank account, they deposit a net amount that has already been reduced by processing fees, refunds, chargebacks, and shipping costs. If you simply record bank deposits as revenue, your gross receipts will be understated and your operational fees will be unrecorded. Accurate e-commerce bookkeeping requires capturing gross sales figures, itemizing fees, tracking sales tax collected across multiple states, and continually updating inventory levels.

Step 1: Form Your Entity and Separate Your Finances

Before connecting software or logging expenses, you must establish a clear boundary between personal and business finances. Mixing personal and business funds makes tax filing difficult and risks invalidating the liability protection offered by a limited liability company (LLC).

In Publication 583, "Starting a Business and Keeping Records," the Internal Revenue Service states that one of the first things a business owner should do is open a dedicated business checking account. The IRS notes that the business checkbook serves as the primary basic source of information for recording expenses.

To set up your financial foundation in the correct order:

  1. Form your business entity: Register your LLC or corporation with your state.
  2. Obtain a Federal Employer Identification Number (EIN): Secure an EIN from the IRS to use for banking and tax filings.
  3. Open a dedicated business checking account: Pass all business income and expenses exclusively through this account.
  4. Establish business credit or payment cards: Use dedicated business cards for store inventory and software subscriptions.

For new store owners, using a platform like ZenBusiness simplifies this initial sequence by managing entity formation, securing your EIN, and preparing you to establish dedicated business accounts. Once your business structure and accounts are in place, you can move directly to setting up your bookkeeping workflow.

Step 2: Choose Your Accounting Method (Cash vs. Accrual)

Small businesses must select an accounting method for tracking income and expenses. The two primary methods are cash basis and accrual basis.

Cash Basis Accounting

Under the cash method, you record revenue when money is received in your bank account and expenses when money actually leaves your account. Cash basis is simple to maintain, but it can distort financial reports for online stores because inventory purchases are paid upfront while sales occur over time.

Accrual Basis Accounting

Under the accrual method, you record revenue when a sale occurs (regardless of when the processor deposits the cash) and record expenses when they are incurred. Accrual accounting matches income directly with the Cost of Goods Sold (COGS) for that specific reporting period, giving you an accurate picture of your actual gross margin.

Most online sellers benefit from accrual accounting or a modified cash system because tracking physical inventory requires matching sales revenue directly against product costs.

Step 3: Establish an E-Commerce Bookkeeping System

Once your bank account is active, choose a software foundation or service to track transactions. E-commerce platforms generate hundreds or thousands of micro-transactions, so your system must automate data ingestion.

Key Tools and Services for Online Sellers

When evaluating software and services for your new online store, review these options listed alphabetically:

  • A2X: A dedicated e-commerce connector that fetches transaction data from sales platforms like Shopify, Amazon, and eBay, groups payout data into clean summaries, and posts them to your accounting software.
  • Bench: An online bookkeeping service that pairs your business with dedicated human bookkeepers who complete monthly financial statements for you.
  • Link My Books: An automated integration tool designed for Amazon, Shopify, eBay, and Etsy sellers that posts accurate payout summaries directly into accounting platforms.
  • QuickBooks Online: A widely used small business accounting software platform that offers robust inventory tracking, deep app integrations, and comprehensive reporting.
  • Wave: A financial software platform offering free core accounting and invoicing capabilities, with paid add-ons available for payment processing and payroll functions.
  • Xero: A cloud-based accounting platform featuring strong reconciliation workflows, unlimited user access on standard plans, and extensive third-party app connections.
  • ZenBusiness Money Pro: An add-on bookkeeping service offered by ZenBusiness for $30 per month. Designed for straightforward business management, it covers custom invoicing, revenue and expense tracking, and tax preparation tools alongside entity administration (check out ZenBusiness accounting).
  • Zoho Books: An accounting software platform within the Zoho ecosystem that provides end-to-end accounting features, inventory support, and automated payment workflows.

Step 4: Map Out Sales Channels and Tax Requirements

Selling online means managing tax obligations across various jurisdictions. Setting up sales tax mapping from day one prevents costly audit surprises later.

Tracking Gross vs. Net Sales

Never rely solely on bank deposits to calculate revenue. Ensure your setup captures:

  • Gross Sales: The total total product price charged to customers.
  • Discounts and Refunds: Price adjustments and returned merchandise costs.
  • Merchant Fees: Transaction processing costs deducted by Stripe, PayPal, or marketplace operators.
  • Shipping Income and Expenses: Postage charged to customers versus actual fulfillment costs.

Managing Sales Tax Obligations

In the United States, economic nexus laws mean that reaching specific sales thresholds in a state obligates you to collect and remit sales tax in that state. Your e-commerce platform must be configured to calculate and collect the appropriate tax rate based on the buyer's shipping destination.

Keep in mind that sales tax collected is not revenue. It is a liability owed to state governments. Your bookkeeping software should hold sales tax receipts in a dedicated liability account until you remit the funds to the appropriate state agency.

State tax agencies impose strict recordkeeping requirements. For example, the California Department of Tax and Fee Administration (CDTFA) states in Publication 116 that business owners must retain sales and use tax records for at least 4 years, and longer if the business is under audit.

Step 5: Implement Record Retention Rules

The IRS and federal agencies require small business owners to preserve underlying financial documentation to substantiate tax returns and payroll filings.

The IRS notes in Publication 583 that supporting documents include:

  • Gross Receipts: Cash register tapes, bank deposit slips, receipt books, invoices, and credit card charge slips.
  • Purchases and Inventory: Canceled checks, cash register tape receipts, credit card sales slips, and invoices.
  • Expenses: Canceled checks, cash register tapes, account statements, credit card sales slips, and invoices.
  • Assets: Purchase and sales invoices, real estate closing statements, and canceled checks.

Official Record Retention Schedules

To ensure compliance with federal and state regulations, align your record storage policies with these official agency rules:

  • General Tax Records (3 Years): The IRS guidance "How Long Should I Keep Records?" specifies that small businesses must keep general tax and financial records for at least 3 years from the date the return was filed.
  • Employment Tax Records (At Least 4 Years): The IRS requires keeping all records related to employment taxes for at least 4 years after the tax becomes due or is paid, whichever is later.
  • Unreported Income (6 Years): If a business omits income that is greater than 25% of the gross income shown on the return, the IRS extends the assessment period to 6 years.
  • Worthless Securities and Bad Debts (7 Years): The IRS sets a 7-year retention rule for records supporting claims for losses from worthless securities or bad debt deductions.
  • Unfiled or Fraudulent Returns (Indefinite): The IRS requires keeping records indefinitely if a business does not file a tax return, or if a fraudulent return is filed.
  • FLSA Payroll Records (At Least 3 Years): The U.S. Department of Labor (DOL) Fact Sheet #21 states that employers subject to the Fair Labor Standards Act must preserve payroll records, collective bargaining agreements, and sales/purchase records for at least 3 years.
  • FLSA Supporting Documentation (2 Years): The DOL requires employers to retain basic supporting wage and time documentation, such as time cards, work schedules, and wage rate tables, for at least 2 years.
  • State Sales Tax Records (At Least 4 Years): State rules vary; for example, CDTFA Publication 116 mandates maintaining all books and records for at least 4 years for California sales tax reporting.

Step 6: Establish a Monthly Bookkeeping Routine

Clean bookkeeping relies on consistent routines. Schedule time every month to perform these core tasks:

  1. Reconcile Bank Accounts: Compare bank and credit card statements against your accounting records to identify missing entries or double charges.
  2. Reconcile Sales Channel Payouts: Match clearing account deposits against sales summaries generated by tools like A2X or Link My Books.
  3. Update Inventory Levels: Calculate Cost of Goods Sold (COGS) based on units sold, adjusting inventory assets accordingly.
  4. Review Financial Statements: Check your Profit and Loss Statement (P&L) and Balance Sheet to monitor gross profit margins, operating overhead, and sales tax liabilities.

Starting your bookkeeping workflow with clean entity separation, automated channel syncing, and compliant document retention protects your online store and gives you clear insights into profitability as your business grows.

Sources