Ecommerce Bookkeeping Essentials

Bookkeeping systematically records financial transactions maintaining accurate records for reporting, tax compliance, and business management. Double-entry accounting ensures books balance while categorization enables meaningful analysis. Understanding bookkeeping fundamentals or working with professional bookkeepers ensures financial accuracy supporting confident decision-making.

Bookkeeping Fundamentals

Double-Entry Accounting

Every transaction affects at least two accounts with equal debits and credits. Debits increase assets and expenses while decreasing liabilities, equity, and revenue. Credits opposite effect. Accounting equation (Assets = Liabilities + Equity) always balances. Double-entry system catches errors through imbalanced entries. Provides complete financial picture showing both sides of transactions. Foundation of modern accounting dating back centuries.

Accrual Basis

Records revenue when earned and expenses when incurred regardless of cash movement. Matches revenue with associated costs. Provides accurate profitability picture. Required for businesses with inventory or significant receivables/payables. Accounts receivable for sales not yet collected. Accounts payable for expenses not yet paid. Deferred revenue for prepaid orders. Accurate accrual accounting requires tracking timing differences between economic activity and cash flow.

Daily Bookkeeping Tasks

Recording Sales

Daily sales recorded from ecommerce platform, marketplace, or point-of-sale system. Integration between platforms and accounting software automates imports. Revenue recognized gross of fees with platform commissions as expense. Returns and refunds recorded as allowances reducing revenue. Gift card sales create liability. Redemptions reduce liability and create revenue. Shipping charges collected treated as revenue or offset to shipping expense. Accurate sales recording essential for revenue recognition and tax compliance.

Recording Expenses

Document every business expense with receipt or invoice. Categorize expenses using chart of accounts. Date, amount, vendor, and category required. Personal expenses mixed with business expenses require separation. Credit card statements reconciled ensuring all business charges recorded. Bank account fees, wire transfer costs, and interest charges recorded. Recurring expenses set up as memorized transactions. Timely expense recording prevents year-end scrambles reconstructing forgotten purchases.

Inventory Tracking

Record inventory purchases increasing inventory asset and accounts payable. Inventory becomes cost of goods sold when products sell. Perpetual inventory systems update balances real-time with each purchase and sale. Periodic inventory counts verify balances matching physical stock to books. Discrepancies from shrinkage, damage, or errors adjusted. Accurate inventory critical for gross profit calculation and tax compliance. Write-downs for obsolete inventory reduce inventory value and create expense.

Weekly and Monthly Tasks

Bank Reconciliation

Monthly bank statement reconciled to accounting records. Compare statement transactions to recorded transactions. Outstanding checks issued but not cashed yet. Deposits in transit recorded but not shown on statement. Bank fees and interest recorded if not already entered. Reconciliation identifies errors, missing transactions, or fraud. Unreconciled differences investigated until resolved. Clean reconciliation ensures accurate cash balances. Most accounting software matches transactions automatically requiring review and approval.

Credit Card Reconciliation

Match credit card statements to recorded expenses. Business cards simpler as all charges business-related. Personal cards with business expenses require identifying business transactions. Receipt matching verifies expense categories and amounts. Payments to credit cards recorded reducing liability. Interest charges recorded as expense. Accurate reconciliation prevents duplicate expense recording or missed transactions. Regular reconciliation easier than annual catchup.

Accounts Receivable

B2B businesses invoicing customers track receivables. Issue invoices when sales occur. Record payments reducing receivable balances. Aging reports identify overdue invoices. Follow-up procedures for collections. Write-offs for uncollectible accounts after reasonable collection efforts. Most B2C ecommerce collects payment at purchase eliminating receivables. Marketplace businesses track platform receivables as platforms hold funds before disbursement. Reconciling marketplace payouts to sales ensures completeness.

Accounts Payable

Vendor invoices entered as payables when received. Bill due dates tracked avoiding late fees. Payments made before due dates taking early payment discounts when offered. Payment records reduce payable balances. Vendor statements reconciled to payable balances identifying discrepancies. Credit memos from returns or allowances reduce amounts owed. Accurate payables ensure all obligations paid timely maintaining vendor relationships and credit terms.

Chart of Accounts Organization

Revenue Accounts

Product sales primary revenue account. Multiple accounts segment revenue by product line, channel, or customer type. Shipping revenue separate if separately stated on invoices. Other revenue for affiliate income or advertising. Discounts and returns as contra-revenue accounts reducing gross sales. Detail enables analyzing revenue mix and profitability by segment. Standard financial reporting aggregates accounts into total revenue.

Asset Accounts

Cash accounts for each bank account, payment processor, and petty cash. Accounts receivable if invoicing customers. Inventory at cost. Prepaid expenses for advance payments like annual insurance or software. Fixed assets for equipment and furniture. Accumulated depreciation contra-account reducing fixed asset value. Other assets for deposits or long-term investments. Asset accounts appear on balance sheet showing resources owned.

Liability Accounts

Accounts payable for vendor invoices. Credit cards and lines of credit. Loans and notes payable. Accrued expenses for earned but unpaid wages or taxes. Deferred revenue for prepaid orders. Sales tax payable collected but not remitted. Payroll tax liabilities. Other current liabilities due within year and long-term liabilities beyond year. Liability accounts show obligations owed.

Equity Accounts

Owner’s equity or retained earnings for sole proprietors and partnerships. Common stock and additional paid-in capital for corporations. Distributions or dividends for ownership withdrawals. Current year net income rolls into retained earnings annually. Equity represents owner’s stake in business. Equity increases with profits and investments. Decreases with losses and distributions. Equity accounts complete accounting equation.

Expense Accounts

Cost of goods sold captures direct product costs. Operating expenses include marketing, payroll, rent, utilities, software, professional services, office supplies, insurance, and depreciation. Sub-accounts provide detail like separating Facebook ads from Google ads within marketing. Interest expense separate from operating expenses. Tax preparation fees and penalties separate for clarity. Organized expense accounts simplify reporting and analysis.

Financial Reports

Income Statement

Profit and loss statement showing revenue minus expenses equaling net income over period. Monthly, quarterly, and annual periods. Comparative statements show multiple periods side-by-side. Percentage of revenue analysis identifies expense ratios. Gross profit line shows revenue minus COGS. Operating profit shows gross profit minus operating expenses. Net profit includes interest and taxes. Income statement answers “were we profitable?”

Balance Sheet

Financial position at specific date. Assets listed first with current assets (converted to cash within year) including cash, receivables, and inventory then fixed assets. Liabilities next with current liabilities (due within year) then long-term debt. Equity including retained earnings and current period net income. Total assets equals total liabilities plus equity. Balance sheet answers “what do we own and owe?”

Cash Flow Statement

Three sections: operating activities, investing activities, and financing activities. Operating cash flow from business operations different from net income due to non-cash expenses like depreciation and timing differences. Investing cash flow from equipment purchases or sales. Financing cash flow from loans, equity investments, or distributions. Net cash flow change in cash balance. Cash flow statement answers “where did our cash come from and go?”

Working with Bookkeepers

When to Hire

Full-time bookkeeper justified for businesses with significant transaction volume, complex operations, or multiple entities. Typical cost $40,000-60,000 annually. Part-time bookkeeper or outsourced firm more economical for smaller businesses at $300-2,000 monthly depending on volume. Virtual bookkeepers handle tasks remotely accessing cloud accounting software. Founder-managed bookkeeping works initially but becomes unsustainable as business grows. Professional bookkeeping frees owner time for strategic activities while ensuring accuracy.

Bookkeeper Responsibilities

Daily transaction recording. Bank and credit card reconciliations. Accounts payable management. Payroll processing or coordination with payroll service. Sales tax compliance. Monthly financial statement preparation. Year-end preparation for accountant or tax preparer. Software maintenance and backups. Vendor communication. Bookkeepers handle routine transactions and reconciliations. Accountants or CFOs provide strategic analysis and advice. Clearly defined responsibilities prevent gaps or duplication.

Tax Preparation Support

Clean books throughout year simplify tax preparation. Organized records with properly categorized expenses. Receipt documentation substantiating deductions. Reconciled accounts confirming accuracy. Accountant or tax preparer reviews bookkeeper work making adjustments as needed. QuickBooks or other accounting software directly used by tax preparers. Year-end accruals for unpaid expenses. Depreciation schedules for fixed assets. Proactive bookkeeping throughout year far easier than year-end catchup compiling shoe boxes of receipts.