E-commerce
October 31, 2026
Are you wondering how to acquire the basics of accounting for your online store?
Key takeaway: understanding the concepts of assets, liabilities, revenue, and expenses allows you to manage your cash flow and avoid unpleasant surprises.
In practice, e‑commerce involves rapid flows (sales, refunds, card fees) that require rigorous tracking from day one.
So, how do you master the basics of accounting for your e‑commerce? Here is the program:
What are the key steps to create a chart of accounts tailored to a Shopify store?
How to correctly record sales, refunds, and credit card fees?
What role does double‑entry bookkeeping play and how to apply it to each transaction?
How to choose and leverage an accounting software without becoming dependent on it?
How does Qstomy simplify the daily financial management of your e‑commerce?
Let's go.
By applying these best practices, you will gain peace of mind, reduce the risk of tax audits, and be able to reinvest more quickly into your site's growth.
In practice, setting up accounting tracking from the launch avoids costly adjustments and gives you strategic visibility into your store's profitability.
Summary
What are the key steps to create a chart of accounts tailored to a Shopify store?
The first step is to choose the legal structure of your activity (sole proprietorship, SARL, SAS, etc.) as it determines accounting obligations. Next, list the accounts you need: sales, shipping fees, commissions, advertising expenses, inventory, fixed assets, etc. This structure, called a 'chart of accounts', serves as the skeleton for all your entries. You can draw inspiration from the model proposed by How to handle customer inquiries about web offers not available in-store to anticipate the specific needs of your store. Once the plan is established, enter it into your software and keep it handy for every entry. Do not forget to periodically review your chart of accounts to adjust it for new products, changes in tax legislation, and evolutions in your business model, which ensures long‑term consistency.
Additionally, ensure you update your procedures every quarter to stay aligned with the latest accounting best practices.

Convert over 2,000 customers on average per month with Qstomy.
The world’s 1st Shopify AI dedicated to customer conversion



Empowering 200+ e-commerce merchants
How to correctly record sales, refunds, and credit card fees?
Each sale generates two entries: a credit to the 'Sales' account and a debit to the 'Cash' or 'Online Payment' account. Card fees (e.g., 2.9% + €0.30) are recorded as a separate expense, allowing you to measure their impact on your margin. In case of a refund, reverse the initial entries: debit the Sales account and credit the Cash account, then add an expense line for the processing fee if it is not refunded. This method ensures clear visibility of monetary flows and simplifies monthly bank reconciliation. This visibility also helps you quickly identify discrepancies between recorded sales and bank deposits, facilitating the detection of potential fraud or processing errors.
Additionally, ensure you update your procedures every quarter to stay aligned with the latest accounting best practices.
What role does double‑entry bookkeeping play and how to apply it to each transaction?
The principle of double‑entry states that every transaction affects at least two accounts, one debited and the other credited, for the same amount. Thus, selling a product increases the 'Sales' account (credit) and decreases the 'Inventory' account (debit) if you manage stock. Similarly, paying a supplier invoice debits the 'Supplier Expenses' account and credits the 'Cash' account. By systematically applying this principle, you obtain a balanced account statement, essential for producing a reliable balance sheet and quickly detecting errors. By practicing double‑entry for every entry, you create a traceability that simplifies audits and provides a solid foundation for profitability analysis.
Additionally, ensure you update your procedures every quarter to stay aligned with the latest accounting best practices.
How to choose and leverage an accounting software without becoming dependent on it?
Solutions like QuickBooks, Xero, or the French version of Sage offer direct integrations with Shopify. Before committing, verify compatibility with your needs (local tax management, refund tracking, export of entries). The advantage of software is automating most repetitive tasks, but it remains crucial to understand the meaning of the entries you input. A good exercise is to prepare a small test spreadsheet to validate the process before migrating all your data. Thus, you remain in control of your information and avoid being a 'prisoner' of a platform. Additionally, prioritize solutions offering exports in standard formats (CSV, XBRL) to migrate your data without loss if your needs evolve.
Additionally, ensure you update your procedures every quarter to stay aligned with the latest accounting best practices.
How to establish monthly cash flow tracking to anticipate liquidity needs?
At the end of each month, create a cash flow statement that aggregates inflows (net sales, customer refunds) and outflows (supplier purchases, marketing fees, salaries, taxes). Compare the result with your actual bank balance to identify any discrepancies. A surplus allows you to plan investments (advertising, new products), while a deficit indicates a need for financing or expense adjustments. This regular tracking becomes a dashboard that alerts you to cash flow tensions before they become critical. Thanks to this dashboard, you can also project future flows based on your planned marketing campaigns, helping you plan medium-term financing needs.
Additionally, ensure you update your procedures every quarter to stay aligned with the latest accounting best practices.
What are the legal obligations for retaining accounting documents in France?
In France, merchants must retain their accounting documents (invoices, bank statements, journals) for ten years. This obligation also applies to electronic archives, provided they guarantee data integrity and readability. Remember to save supplier invoices in a timestamped PDF format and implement an automated backup routine. In the event of a tax audit, you can quickly provide supporting documents without facing penalties. Also, store digital proofs in the cloud with a versioning system to respond quickly to audit requests or unannounced inspections.
Additionally, ensure you update your procedures every quarter to stay aligned with the latest accounting best practices.
How to prepare the necessary documents for VAT declaration for an online store?
VAT is the most frequent charge for e‑merchants. Each month or quarter, gather sales invoices (with the applied rate) and purchase invoices (deductible VAT). The accounting software automatically generates the VAT declaration: you just need to verify the totals, correct any omissions, and transmit the file to the administration via the net‑entreprises portal. Good tracking avoids late fees and allows you to recover VAT on your business expenses. Consider automating the submission of the declaration file via administration APIs, which reduces the risk of manual entry errors.
Additionally, ensure you update your procedures every quarter to stay aligned with the latest accounting best practices.
Why and how to conduct periodic physical inventory?
Even if your store is digital, you must manage physical stock (products, raw materials). A periodic inventory (quarterly or annual) involves counting each item, comparing the result with the level recorded in your accounting plan, and then adjusting discrepancies (losses, theft, errors). This operation ensures that the 'stock' account reflects reality and allows for accurate recalculation of the cost of goods sold (COGS). A well-conducted inventory protects your margin and strengthens investor confidence. Plan this inventory during calm periods of activity to minimize disruptions and ensure that each discrepancy is recorded in the inventory journal to maintain a historical record.
Additionally, ensure you update your procedures every quarter to stay aligned with the latest accounting best practices.
How to analyze key financial indicators to drive profitability?
Key metrics to monitor include gross margin (sales, cost of goods), conversion rate, customer acquisition cost (CAC), and customer lifetime value (LTV). Using your accounting software, extract these ratios monthly and compare them to your targets. For instance, if your gross margin drops, review platform fees or excessive discounts. By cross-referencing accounting data with Digital marketing strategy: complete guide for online businesses, you will identify the most effective levers for improvement. By regularly tracking these metrics, you can adjust your acquisition strategies, optimize margins, and anticipate market trends before your competitors.
Additionally, ensure you update your procedures every quarter to stay aligned with the latest accounting best practices.
How to manage advertising and influencer expenses in accounting?
Advertising campaigns, influencer commissions, and partnerships generate various invoices (Google Ads, Facebook, TikTok). Classify each expense under a dedicated account (e.g., 'online advertising', 'influencer marketing') to analyze their impact on revenue. Also record refunds or advertising credits as expense adjustments. This granularity facilitates ROI calculation for each channel and helps you allocate your marketing budget more effectively. Additionally, track cost per acquisition (CPA) by channel to compare the real ROI of influencers versus traditional advertising.
Additionally, ensure you update your procedures every quarter to stay aligned with the latest accounting best practices.
How does Qstomy simplify accounting for your Shopify store?
Qstomy directly integrates sales data, card fees, and refunds from your Shopify dashboard into your financial dashboard. Thanks to automatic synchronization, every transaction is recorded in double-entry without manual data entry. Moreover, Qstomy offers cash flow reports, cash flow forecasts, and personalized alerts when a critical threshold is reached. With one click, you can export accounting journals compatible with QuickBooks or Sage, saving time and reducing error risks. Finally, Qstomy provides personalized alerts for cash flow threshold breaches or billing anomalies, enabling immediate intervention.
Additionally, ensure you update your procedures every quarter to stay aligned with the latest accounting best practices.
What checklist to follow before closing your first accounting period?
In short
Plan comptable : verify that all necessary accounts are created and correctly labeled.
Sales journal : every sale, refund, and card fee must be recorded.
Inventaire : conduct a physical stock audit and adjust discrepancies.
TVA : ensure all tax filings are up to date and refunds are accounted for.
Cash flow reports : compare the bank balance with accounting entries.
FAQ
Should I hire a certified accountant? Yes, especially to validate your balance sheets and optimize your tax strategy.
Which software to choose? Opt for a solution that integrates with Shopify and offers French-language support.
How to avoid double-entry errors? Use an automated validation process like the one offered by Qstomy.
To go further, consult What share of retail is conducted online? and Why use social media for e-commerce customer service?.
To go further: Why does an e-commerce business fail in the first 12 months? - Qstomy, E-commerce SEO strategy for category pages - Qstomy, AI Chatbot for web exclusives: explain availability, stock, and alternatives - Qstomy.
By strictly following this checklist, you minimize the risk of omissions and ensure your first accounting period closes smoothly, laying the foundation for sustainable financial management.
Additionally, ensure you update your procedures every quarter to stay aligned with the latest accounting best practices.

Enzo
October 31, 2026


