Growing a Shopify store is exciting right up until you realize your books have not kept pace. Revenue is coming in across channels, refunds are going out, transaction fees are stacking up, and orders ship daily, yet your accounting still feels like guesswork.
If your profit and loss statement does not match what actually hits your bank account, you are far from alone. Most Shopify sellers either handle the finances themselves or lean on a general accountant who does not fully grasp how ecommerce money moves.
Shopify accounting is not the same as traditional small-business accounting. Your revenue gets split across payment gateways, trimmed by processing fees, and delayed by payout schedules before a single dollar reaches your bank. Refunds, chargebacks, shipping costs, and sales tax pile on layers of complexity that standard bookkeeping was never built to handle. Accurate accounting means understanding those layers and building a system that tracks each one.
This guide covers the numbers you need to track, how to choose the right accounting method, handling inventory and cost of goods sold, sales tax basics, software that works for Shopify, and how to build a monthly review process. Whether you are doing six figures or pushing toward eight, these fundamentals keep your finances clean and your decisions grounded in real data.
If clean books feel like a second job you did not sign up for, that is exactly the work we take on. Our Shopify and ecommerce bookkeeping service reconciles every gateway and payout so your numbers are always ready to act on.
What Shopify Numbers Actually Need To Track
Your Shopify dashboard shows plenty of data, but not all of it belongs in your books. The numbers that matter most are the ones that affect profitability, cash flow, and tax reporting. Getting clear on the difference between revenue, fees, refunds, and actual cash received is the first step toward accurate accounting.
Sales, Refunds, And Shipping Are Not The Same As Cash
When a customer places an order, Shopify records gross revenue. That figure includes the product price, any shipping charged to the customer, and sales tax collected. Gross revenue is not your income, and each of those components is treated differently in your books.
Sales revenue is the amount charged for products before deductions. Shipping fees collected from customers are usually recorded as a separate revenue line or offset against your actual shipping costs. Refunds reduce gross revenue, but the timing matters. Record a sale in January and issue a refund in February, and your January numbers look inflated unless you account for the return properly.
Recording all three as a single lump sum is a common mistake that hides your true revenue and distorts your margins. Break these line items apart from the start, and your financial statements will tell a far more honest story.
Shopify Payments, PayPal, Stripe, And Other Payment Gateways
Most Shopify stores accept payments through more than one gateway. You might run Shopify Payments as your primary processor, with PayPal and Stripe handling the rest. Each gateway collects money from customers, deducts its own processing fees, and deposits the remainder into your bank on its own schedule. That creates a reconciliation challenge.
Your Shopify sales report might show $10,000 in orders for the week, but the deposits hitting your bank will not match that number. The gap comes from processing fees, pending transactions, refunds processed within the payout period, and timing differences between when a sale happens and when the money arrives.
Track each payment gateway separately. You need to know exactly how much revenue flowed through each one, how much was deducted in fees, and how much was actually deposited.
Transaction Fees, Payouts, And Reconciling Payouts
Transaction fees are the cost of accepting payments. Shopify Payments charges a percentage plus a flat fee per transaction, and PayPal and Stripe have their own rate structures. These fees add up quickly, and if you do not track them, your profit calculations will be off.
Payout reconciliation means matching what each processor deposited against what your Shopify reports say you earned. Start by pulling your Shopify payouts report, which shows exactly what was included in each deposit: gross sales minus refunds, fees, and chargebacks. Then compare that payout to the actual deposit on your bank statement. If the numbers match, you are good. If they do not, look for pending transactions, held reserves, or refunds that crossed payout periods.
Do this weekly or biweekly. Wait too long and discrepancies become hard to trace. A steady payout reconciliation habit is the backbone of trustworthy Shopify bookkeeping.
Choosing Your Accounting Method And Financial Setup
How you record income and expenses shapes everything from your tax return to your cash flow visibility. Picking the right method and building a clean structure early saves you from painful corrections later.
Cash Accounting Vs Accrual Accounting
Cash accounting records income when money hits your bank and expenses when money leaves it. It is simple and matches how you naturally think about money.
Accrual accounting records income when it is earned, meaning when the order ships or is fulfilled, and expenses when they are incurred, regardless of when cash moves. This method gives a more accurate picture of profitability, especially if you carry inventory or deal with supplier payment terms.
If your store generates under a certain revenue threshold, you may be eligible to use cash accounting. Once you grow past that threshold, or if you carry significant inventory, accrual accounting becomes either required or simply far more practical. Talk to your accountant about which method fits your situation and what would trigger a switch. Cash accounting is easier but can hide timing issues, while accrual is more accurate for ecommerce but asks for more disciplined bookkeeping. Pick one and stay consistent.
Chart Of Accounts For E-Commerce Operations
Your chart of accounts is the list of categories where every transaction gets sorted. Think of it as the filing system for your money. A generic small-business chart of accounts does not serve a Shopify store well, because it ignores the revenue and expense categories ecommerce creates.
At a minimum, your chart of accounts should include separate categories for gross product revenue, shipping income, refunds and returns, cost of goods sold, shipping expenses paid to carriers, transaction and processing fees by gateway, advertising and marketing spend, software and subscription costs, and sales tax collected as a liability rather than revenue.
Set this up correctly from the start and your financial reports will actually tell you something. You will see exactly where your money comes from and where it goes, instead of staring at a single “Sales” line and a single “Expenses” line that reveal almost nothing.
Bank Reconciliation And Expense Tracking Basics
Bank reconciliation means comparing the transactions in your accounting software against your bank statement to confirm they match. For Shopify sellers, that also means reconciling payment gateway deposits, not just bank activity. Every deposit from Shopify Payments, PayPal, or Stripe should tie back to specific orders, and every withdrawal, fee, or charge should be categorized correctly. If you find transactions in your bank that are not in your books, or entries in your books that never appear in the bank, something is wrong and needs to be investigated.
Expense tracking is just as important. Every business purchase, from inventory and shipping supplies to ad spend and software, needs to be recorded and categorized. Use a dedicated business bank account and credit card so personal and business spending never mix. That one habit removes a major headache at tax time and keeps your cash flow tracking reliable.
Inventory, COGS, And Profit Visibility
Knowing your true profit takes more than subtracting expenses from revenue. If you sell physical products, inventory and cost of goods sold are the two biggest factors that decide whether your store is actually making money.
Inventory Tracking Vs Inventory Management
These two terms sound alike but do different jobs. Inventory tracking is knowing how many units of each product you have on hand, and Shopify updates those counts as orders are placed and fulfilled. Inventory management goes deeper. It covers the cost of each unit, items in transit, shrinkage or damaged goods, and how inventory value appears on your balance sheet. Shopify’s built-in tools handle basic tracking, but they do not give you the cost-layer detail you need for accurate financial statements.
If you buy the same product at different costs over time, you need to choose an inventory valuation method. The three most common are FIFO (first in, first out), LIFO (last in, first out), and weighted average cost. FIFO is the most widely used for ecommerce and generally matches how physical inventory moves. Whichever method you pick, the IRS typically expects you to stick with it unless you get approval to change.
Cost Of Goods Sold And Gross Profit
Cost of goods sold (COGS) is the direct cost of the products you sold during a period. It includes what you paid for the product itself, inbound freight, customs duties if you import, and any direct costs of getting that product ready to sell.
Gross profit is revenue minus COGS. That number tells you whether your pricing and sourcing are working before you account for operating expenses like advertising, software, or payroll. For example, sell a product for $50 with COGS of $18 (product cost plus shipping to your warehouse), and your gross profit per unit is $32, a 64 percent gross margin. Layer on ad spend, transaction fees, and overhead, and your net margin lands much lower. Without gross profit first, you cannot evaluate any of those other costs meaningfully.
Shopify’s built-in reports do not calculate COGS for you. You need to input cost data manually, use a dedicated app, or handle it through your accounting software. Skip this step and your profit and loss statement is missing its most important expense line.
Why Timing Errors Distort The Profit And Loss Statement
One of the most common problems with Shopify profit and loss statements is timing mismatch, which happens when revenue and the matching COGS land in different periods. Buy $5,000 in inventory in March but sell it in April and May, and recording that $5,000 as a March expense makes March look unprofitable and April look artificially strong. Under proper accrual accounting, that $5,000 stays on your balance sheet as inventory until the products sell, at which point the cost moves to COGS.
Many sellers get tripped up here, recording inventory purchases as expenses when paid rather than when sold. The result is reports that swing wildly month to month and do not reflect real performance. Accurate tracking means matching revenue with the cost of producing that revenue in the same period. If your reports do not do this, you are making growth decisions on distorted data.
Sales Tax, Nexus, And Marketplace Complexity
Sales tax is one of the most misunderstood parts of Shopify accounting. You are responsible for collecting and remitting sales tax in states where you have an obligation, and the rules vary by state. Get it wrong and you risk penalties, interest, and back-tax assessments.
Sales Tax Nexus And Marketplace Facilitator Rules
Nexus is the legal connection between your business and a state that triggers a sales tax obligation, and it comes in two forms. Physical nexus exists when you have a physical presence in a state, such as an office, warehouse, or employees. Economic nexus is triggered when your sales into a state exceed a threshold that state sets, usually based on revenue, transaction count, or both.
After the 2018 Supreme Court decision in South Dakota v. Wayfair, most states adopted economic nexus rules. The thresholds vary, with some states set at $100,000 in sales and others at 200 transactions. These numbers can change, so monitor your sales volume by state regularly. If you sell on Amazon, Walmart, or other marketplaces alongside Shopify, marketplace facilitator laws add another layer. In most states the marketplace itself is responsible for collecting and remitting sales tax on orders placed through its platform, while the sales you make through your own Shopify store remain your responsibility. Track which channel each transaction came through and apply the correct treatment.
Multi-state sales tax is one of the fastest ways for a growing store to fall out of compliance without noticing. Our ecommerce sales tax services keep your nexus tracked and your filings on schedule so you can focus on selling.
Sales Tax Automation And Tax Reports
Manually calculating and filing sales tax across multiple states is not practical for a growing store. Sales tax automation connects to your Shopify store, calculates the correct rate for each order based on the buyer’s location, and generates reports you can file from. Shopify has a built-in tax engine that handles basic rate calculation, but it does not file returns for you. Dedicated tools go further, tracking your nexus status across states, applying product-specific rules, and preparing state-by-state filing reports.
Your Shopify tax reports show how much tax was collected by state and jurisdiction. Pull these monthly, not just at filing time. Reviewing them regularly helps you catch errors early, such as orders where tax was not collected in a state where it should have been.
What To Review With Accountants Before Filing
Before filing sales tax returns or your annual income tax return, review a few items with your accountant. First, confirm which states you currently have nexus in and whether any new states crossed the threshold since your last review. Second, verify that the sales tax you collected matches what your automation tool and Shopify reports show, since discrepancies can come from manual orders, refunds, or configuration errors. Third, make sure your income tax return reflects the correct accounting method and that COGS, inventory, and revenue are all recorded in the right periods.
A specialist ecommerce accountant flags these issues proactively. A general accountant may not even know to look for them.
Software Options And Integration Tradeoffs
Choosing accounting software for your Shopify store is a foundational decision. The right tool depends on your sales volume, number of channels, inventory complexity, and whether you keep the books yourself or work with an accountant.
Matching Accounting Software To Your Sales Volume
At the entry level, a lightweight cloud accounting platform covers invoicing, expense tracking, and bank reconciliation, and works for very small stores with simple needs. As you add volume, you will want a mainstream cloud ledger with stronger reporting, multi-currency handling, and a wide range of integrations, which is the setup most ecommerce accountants are comfortable working in. That familiarity matters, because it makes collaboration with your accountant far easier.
At the top end, enterprise platforms are built for complex, multi-channel operations with warehouse logistics, and typically suit sellers well into seven or eight figures. They offer deep inventory management and advanced reporting, but they are significantly more expensive and complex to implement. The point is to match the tool to your stage rather than overbuying early or outgrowing a basic tool too fast.
If you would rather not evaluate platforms at all, our team selects, sets up, and runs the right accounting stack for your store as part of our bookkeeping service, so you get clean books without becoming a software expert.
Shopify Integration, Shopify Connector, And Data Sync Limits
No accounting software pulls data from Shopify perfectly out of the box. Most rely on a connector or integration app to sync orders, refunds, fees, and payouts into your accounting platform, and the quality of that sync varies. Some connectors import each individual order as a separate transaction, while others summarize daily or per payout. The right approach depends on your volume and how granular you need the data to be. Individual order sync gives the most detail but can overwhelm your accounting file if you process thousands of orders a month, while summary-level sync is cleaner but harder to trace to specific transactions.
Watch for common sync limits: refunds not matched to original orders, transaction fees lumped together instead of broken out by gateway, shipping income not separated from product revenue, and sales tax collected being treated as revenue instead of a liability. Before you commit to a connector, test it with real data and verify that the numbers in your accounting software match your Shopify reports.
Free Plan, Free Trial, And Free Accounting Software Considerations
Several platforms offer a free plan or trial that looks tempting when you are starting out. Free tools work fine when you are processing a handful of orders a week and your needs are simple. The limits show up as you grow, usually as caps on users, integrations, or transactions, and missing features like inventory tracking or multi-currency support.
The cost of a proper accounting platform, usually around $25 to $75 per month, is small next to the cost of inaccurate books, missed deductions, or audit exposure from sloppy records. Invest in the right tool early and build a financial foundation that scales with you.
Building A Monthly Review Process That Supports Growth
Good Shopify accounting is about using your financial data to make better decisions. A monthly review turns your books from a compliance chore into a growth tool.
Custom Reports, Data Export, And Financial Forecasting
Your standard profit and loss statement and balance sheet are starting points. Custom reports reveal the insights that drive action. Build reports that show gross margin by product or category, customer acquisition cost by channel, and monthly trends in refunds and returns. Most accounting platforms let you save report templates, so you review the same metrics every month without rebuilding from scratch. Exporting to a spreadsheet gives you room to combine Shopify data with ad spend, fulfillment costs, and other metrics your accounting software may not track natively.
Forecasting becomes possible once you have several months of clean data. You can project revenue, estimate cash needs for inventory purchases, and plan for seasonal swings, which is where ecommerce CFO and financial advisory support turns your numbers into a real growth plan. If you sell in a seasonal niche, forecasting helps you avoid over-ordering before a slow stretch or under-ordering before a peak.
Receipt Scanning, Automate Bookkeeping, And Workflow Cleanup
Small inefficiencies compound over time. Receipt scanning apps that attach digital copies to transactions save hours and protect you during an audit, and most accounting platforms offer built-in capture through their mobile apps. Look for repetitive, rule-based tasks to automate, such as bank feed rules that categorize recurring expenses, automated invoices for wholesale orders, and scheduled report generation. Every manual step you remove reduces the chance of error and frees time for higher-value work.
Workflow cleanup means reviewing your processes quarterly and asking which transactions consistently need manual correction and which categories always get miscoded. Fix the root cause rather than correcting the same mistake every month.
How A Shopify Accountant Can Improve Decision-Making
A general accountant can file your taxes and keep your books compliant. A Shopify accountant who specializes in ecommerce does much more. They understand how Shopify payouts work, how to reconcile multiple gateways, how to account for inventory and COGS properly, and how to manage multi-state sales tax. The real value of a specialist is actionable insight.
Which products are actually profitable after all costs? Where are you losing margin? Should you put more into a specific channel? Are you carrying too much inventory for your sales velocity? Clean reports built on accurate bookkeeping give your accountant the data to answer these questions. Without clean data, even the best accountant is guessing. With it, your monthly review becomes a strategic planning session.
That is the level our specialists work at with growing sellers every day. If you want your numbers turned into decisions rather than a source of stress, book a free consultation with an ecommerce accounting specialist and see what clean books can do for your store.
Frequently Asked Questions
What is the best way to track sales, fees, refunds, and taxes from an online store in one system?
Use a cloud-based accounting platform connected to your Shopify store through a reliable integration app. Make sure the connector separates gross sales, refunds, shipping income, transaction fees, and sales tax into distinct line items so your reports stay accurate.
Which apps can automatically sync orders, payouts, and expenses to bookkeeping software?
Several connector apps bridge Shopify and your accounting platform, syncing at either the individual order level or the payout summary level. Evaluate each on how it handles refunds, fees, and multi-gateway transactions before committing, and always verify synced data against Shopify’s native reports.
How do I reconcile platform payouts with bank deposits and payment processor statements?
Pull the payouts report from each gateway, including Shopify Payments, PayPal, and Stripe, and compare the net payout against the matching bank deposit. Each payout should equal gross sales minus refunds, processing fees, and chargebacks for that period. Do this weekly or biweekly to catch discrepancies while they are still easy to trace.
What are the steps to set up a chart of accounts for an ecommerce business selling online?
Create separate revenue accounts for product sales, shipping income, and refunds. Add expense categories for COGS, shipping costs, transaction fees by gateway, advertising, software subscriptions, and sales tax payable as a liability. Customize from there based on your business model, and review the structure with your accountant before entering transactions.
How can I handle sales tax reporting and filing when selling in multiple regions?
Use a sales tax automation tool that connects to your Shopify store and tracks nexus thresholds by state. It should calculate correct rates at checkout, generate state-by-state filing reports, and alert you when you cross economic nexus thresholds in new states. Review these reports monthly and file on each state’s required schedule.
What training or certification options are available to learn ecommerce bookkeeping workflows?
Look for courses that address Shopify payout reconciliation, COGS accounting for physical products, and multi-state sales tax compliance, since those are the areas general bookkeeping training tends to skip. Working directly with a specialist ecommerce accountant gives you practical, business-specific guidance rather than generic theory.