Questions
Practical answers to the bookkeeping, accounting, and financial questions that come up when running a business.
How do I do bookkeeping for my Amazon FBA business?
The key is understanding that Amazon deposits aren't your revenue. They're the net result after fees, refunds, and deductions. You need integration software to break down settlements properly and careful tracking of inventory costs.
Read answerWhat's the best way to track Amazon seller fees in QuickBooks?
The key is breaking apart Amazon's net deposits into gross sales and individual fee categories. You can do this manually using settlement reports or automate it with integration tools like A2X.
Read answerHow do I reconcile Amazon payouts with my bank account?
Amazon deposits a net payout that includes sales minus fees, refunds, and reserves. Use your Settlement Report from Seller Central to see what's inside each deposit and record the components separately in your books.
Read answerWhy don't my Amazon deposits match my sales reports?
Amazon deposits are net amounts after fees, refunds, advertising costs, and reserves are deducted. The number hitting your bank is what remains after Amazon takes its cut, not your gross sales.
Read answerHow do I calculate cost of goods sold for my e-commerce store?
Cost of goods sold equals beginning inventory plus purchases minus ending inventory. For e-commerce, include product costs and inbound freight in COGS, but keep platform fees and outbound shipping as operating expenses.
Read answerWhat accounting method should I use for my Shopify store?
Most small Shopify stores can legally use cash basis accounting, but accrual often makes more sense once you're carrying inventory. Cash is simpler for tax prep, but accrual shows actual profitability by matching product costs to the revenue they generate.
Read answerHow do I track inventory for my online store?
Connect your sales platforms to accounting software, track cost of goods sold accurately, and reconcile physical counts regularly. The challenge isn't the tracking itself but getting all systems to sync reliably.
Read answerDo I need a bookkeeper who specializes in e-commerce?
Yes, if your e-commerce business has any real volume. Sales tax nexus, multi-channel reconciliation, inventory costing, and platform-specific fees create accounting challenges that general bookkeepers often haven't encountered.
Read answerHow do I handle sales tax for my Amazon business?
Amazon collects and remits sales tax in all states through marketplace facilitator laws. But FBA sellers still need to track nexus, register in some states, and record sales tax correctly in their books.
Read answerWhat's the difference between cash and accrual accounting for online sellers?
Cash accounting records income when you receive payment. Accrual records it when the sale occurs. For online sellers with inventory and delayed marketplace payouts, the difference affects how you see profitability and when you pay taxes.
Read answerHow do I track Amazon FBA fees and refunds in my books?
Amazon deposits a single net amount that bundles sales, fees, refunds, and reimbursements together. You need to break this down using settlement reports or integration software to see what you're actually earning and spending.
Read answerWhy is my e-commerce profit and loss statement inaccurate?
E-commerce P&Ls are often wrong because of inventory costing problems, miscategorized marketplace fees, or timing issues with returns. The most common culprit is Cost of Goods Sold that doesn't reflect actual product costs including landed costs like shipping and duties.
Read answerHow do I account for Shopify payouts and transaction fees?
Record your gross sales as revenue and Shopify fees as a separate expense. Don't just book the net payout amount to income or you'll underreport revenue and miss tracking what you're actually paying in fees.
Read answerWhat reports do I need to download from Amazon Seller Central each month?
The Settlement Report and Date Range Transaction Report are essential. FBA sellers also need storage fee and inventory adjustment reports. These downloads let you reconcile deposits and track the fees Amazon takes.
Read answerHow do I handle multi-channel sales bookkeeping for Amazon and Shopify?
Track gross sales, fees, and refunds separately for each channel rather than recording net deposits as revenue. Integration tools like A2X pull settlement data from Amazon and Shopify to create accurate journal entries in your accounting software.
Read answerWhat's the best bookkeeping software for Amazon sellers?
QuickBooks Online or Xero both work for Amazon sellers. But the accounting software matters less than the integration tool that translates Amazon's complicated settlement reports into clean accounting entries.
Read answerHow do I track returns and chargebacks for my online store?
Record returns as revenue reductions and chargebacks as disputed transactions with their associated fees. Keep them in separate accounts so you can see patterns and understand your actual margins.
Read answerDo I need an accountant who understands e-commerce accounting?
Yes. E-commerce involves unique challenges like payment processor reconciliation, inventory costing, multi-channel tracking, and multi-state sales tax that general accountants often struggle with.
Read answerHow do I calculate my actual profit margin on Amazon?
To calculate true Amazon profit margin, subtract all costs from revenue including product cost, Amazon fees, advertising, storage, and returns. Most sellers underestimate costs and overestimate margins.
Read answerWhat's the best way to handle dropshipping bookkeeping?
Track cost of goods sold without holding inventory by matching each supplier payment to its corresponding sale. Automate platform fee tracking and sales imports to handle high transaction volume and maintain visibility into actual margins.
Read answerHow do I account for Amazon advertising costs in my books?
Record Amazon advertising costs as a marketing expense, separate from your cost of goods and Amazon seller fees. The tricky part is extracting clean data since Amazon deducts ad spend from your settlements before depositing to your bank.
Read answerWhy does my e-commerce business have cash flow problems when sales are good?
Strong sales don't equal strong cash flow. Inventory purchases, platform payment delays, and the cash demands of growth create a gap between revenue on paper and money in your account.
Read answerHow do I track inventory across multiple Amazon warehouses?
Amazon automatically distributes FBA inventory across fulfillment centers and tracks it for you. Your job is pulling the right reports and reconciling Amazon's data with your accounting records.
Read answerWhat is A2X and do I need it for my Amazon accounting?
A2X is software that automatically pulls Amazon settlement data into your accounting software, breaking out sales, fees, refunds, and FBA charges. You probably need it once you're doing consistent volume and want accurate financials.
Read answerHow do I prepare my Amazon seller books for tax season?
Start by reconciling your Amazon settlement reports to your bank deposits, then calculate your cost of goods sold using inventory records. Gather your 1099-K and make sure it matches your recorded revenue before handing everything to your accountant.
Read answerWhat bookkeeping mistakes do Amazon sellers make most often?
The biggest mistakes are recording Amazon's disbursement as total revenue, not tracking inventory costs properly, and ignoring the detailed fee breakdown. These errors make it impossible to understand your actual profit margins.
Read answerHow do I handle currency conversion for international e-commerce sales?
Most platforms convert foreign currency to USD before paying you, so your books stay in dollars. Track the conversion fees separately, reconcile payouts to your bank, and record revenue at the amount you actually received.
Read answerWhat should I look for when hiring a bookkeeper for my Shopify store?
Look for someone with specific e-commerce experience who understands how Shopify reports revenue, handles payment processor reconciliation, and knows multi-state sales tax rules. General small business bookkeeping skills aren't enough for the complexity of online selling.
Read answerHow do I track product costs and landed costs for e-commerce?
Track every cost required to get inventory to your warehouse, not just the supplier invoice. Calculate landed cost per unit by totaling freight, duties, broker fees, and insurance, then dividing by units received.
Read answerWhy is my COGS wrong on my e-commerce profit and loss?
COGS errors in e-commerce usually come from how inventory is tracked. If purchases go straight to COGS instead of through an inventory account, or if your ending inventory balance is wrong, your cost of goods sold won't match reality.
Read answerHow often should I reconcile my e-commerce accounts?
Weekly reconciliation works best for most e-commerce businesses. The transaction volume and complexity of multiple platforms, payment processors, and fee structures make monthly reconciliation too risky. Problems are much harder to track down weeks after they happen.
Read answerDo I need separate bookkeeping for each Amazon marketplace?
No, most Amazon sellers can run all marketplaces through one set of books. The key is structuring your accounting software to track each marketplace separately using classes or locations, so you can see profitability by region.
Read answerHow do I account for Amazon reimbursements and lost inventory claims?
Record lost inventory as an adjustment reducing your inventory value and cost of goods sold impact. When Amazon reimburses you, record it as other income or offset it against the inventory loss depending on your preferred method.
Read answerWhat financial reports should a DTC brand review monthly?
DTC brands need a P&L structured to show contribution margin, a cash flow report to track timing gaps between spending and collecting, and inventory reports that identify slow movers. Standard reports work, but the structure matters.
Read answerHow do I value inventory for my online retail business?
Most e-commerce businesses use FIFO (First In, First Out) to value inventory. This method assumes you sell your oldest inventory first, which typically matches how online retail works and simplifies compliance.
Read answerHow do I do bookkeeping for a retail store?
Retail bookkeeping centers on tracking sales from your point of sale system, managing inventory costs, reconciling cash, and handling sales tax. The key is connecting your daily sales activity to accurate cost of goods sold calculations.
Read answerWhat's the best inventory tracking method for my boutique?
A perpetual inventory system with FIFO valuation works best for most boutiques. This gives you real-time stock visibility while producing accurate cost of goods sold for your financial statements.
Read answerHow do I calculate inventory shrinkage for my retail business?
Inventory shrinkage is the difference between what your records show and what you physically count. Divide the difference by your book inventory value, then multiply by 100 to get your shrinkage percentage.
Read answerWhat accounting software works best for retail stores?
The best accounting software for retail depends on your inventory complexity and POS system. QuickBooks Online and Xero both work well for most retail stores, but the right choice depends on what integrations you need and how many products you carry.
Read answerHow do I track cost of goods sold for my gift shop?
Track every purchase at cost, organize products into meaningful categories, and perform regular inventory counts. Your COGS equals beginning inventory plus purchases minus ending inventory.
Read answerWhat's the retail inventory method and should I use it?
The retail inventory method estimates ending inventory using the ratio between cost and retail prices. It works for stores with consistent markups but has largely been replaced by modern POS systems that track inventory in real time.
Read answerHow do I account for markdowns and clearance sales?
Record revenue at the actual selling price, not the original price. Your cost of goods sold stays the same, which means your margin shrinks on marked-down items. Track markdowns separately to analyze which products and categories underperform.
Read answerHow do I reconcile my POS system with my accounting software?
Match your POS sales reports to payment processor deposits and accounting records. The numbers won't align exactly due to processing fees, tips, and timing differences, so you need to account for each discrepancy.
Read answerWhat bookkeeping records should a retail store keep?
Keep everything related to money coming in and going out. Sales reports, vendor invoices, inventory records, bank statements, payroll documents, and tax filings. The key is organizing them consistently and knowing how long each type needs to be retained.
Read answerHow do I handle consignment inventory in my books?
The key rule is that whoever owns the goods records them as inventory. If you're selling someone else's products on consignment, those items don't hit your inventory until they sell. If you're placing your goods with another retailer, they stay on your books until that retailer makes a sale.
Read answerWhat financial reports does a retail business need each month?
Retail businesses need a profit and loss statement, balance sheet, cash flow report, and inventory-specific reports like aging and turnover. These reports help you track margins, manage cash tied up in products, and make smarter buying decisions.
Read answerHow do I track cash register shortages in my accounting?
Create a cash over/short account and record the difference between your expected drawer total and actual count each day or shift. This gives you visibility into patterns and helps identify whether shortages are normal variance or a bigger problem.
Read answerWhat's the best way to manage accounts payable for retail vendors?
Centralize all invoices in one system, match them to receiving documents before approving, and schedule payments based on each vendor's terms. Weekly AP reviews prevent missed payments and help you take advantage of early payment discounts.
Read answerHow do I account for gift cards and store credit?
Gift cards and store credit are liabilities until redeemed, not revenue when sold. Record the sale as a liability, then recognize revenue when the customer uses the card or credit toward a purchase.
Read answerDo I need FIFO or LIFO for my retail inventory?
For most retail businesses, FIFO is the better choice. It matches how inventory actually moves through your store and keeps your balance sheet accurate. LIFO creates complexity that rarely benefits smaller retail operations.
Read answerHow do I calculate my retail store's gross profit margin?
Subtract your cost of goods sold from revenue, then divide by revenue. The formula is simple but getting COGS right for retail requires understanding what costs to include and tracking margin by category.
Read answerWhat bookkeeping mistakes do small retail stores make?
Small retail stores commonly fail to track inventory as an asset, mix personal and business transactions, and skip daily cash reconciliation. These mistakes make financial reports meaningless and create tax problems.
Read answerHow do I track sales by department or product category?
Set up classes or product categories in your accounting software and assign them consistently to every sale. This gives you profit and loss reports broken down by department so you can see what's actually making money.
Read answerShould my retail store use cash or accrual accounting?
Most small retail stores can use cash accounting for simplicity, but accrual gives you a clearer picture of profitability when you carry significant inventory. The right choice depends on your size, inventory levels, and growth plans.
Read answerHow do I prepare my retail store books for an audit?
Start with reconciled accounts, verified inventory records, and documentation for every transaction. Retail audits focus heavily on inventory valuation, cash handling, and sales tax compliance.
Read answerHow do I know when to hire a bookkeeper for my small business?
The signs are usually clear once you know what to look for. You're consistently behind on reconciliations, tax season feels like chaos, or your business has grown more complex than your DIY bookkeeping can handle.
Read answerWhat's the difference between a bookkeeper and an accountant?
Bookkeepers handle day-to-day financial record keeping while accountants analyze those records for taxes and strategic decisions. Most small businesses need both, working together at different frequencies.
Read answerHow much does bookkeeping cost for a small business?
Small business bookkeeping typically costs $200 to $600 monthly for basic services. The actual price depends on transaction volume, industry complexity, and whether you need just the basics or more comprehensive financial management.
Read answerWhat should I look for when hiring a bookkeeper?
Look for industry experience, proficiency with your accounting software, clear communication, and a well-defined scope of work. References from similar businesses help confirm they can handle your needs.
Read answerHow often should my books be updated?
Monthly is the minimum for most small businesses. Businesses with high transaction volume or cash-intensive operations benefit from weekly updates. The right frequency depends on how quickly you need financial information to make decisions.
Read answerWhy can't I figure out where my money is going?
The problem is usually looking at the wrong information. Bank statements show transactions but not patterns. Properly categorized books with monthly review show exactly where every dollar went.
Read answerHow do I separate business and personal expenses?
Open a dedicated business bank account and credit card, then use them exclusively for business transactions. Pay yourself through owner's draws or salary rather than paying personal bills directly from the business.
Read answer