Introduction

An online store can look busy and profitable while its finances quietly fall apart. Orders arrive from your website and marketplaces, gateways hold funds for days, and couriers remit cash on delivery in batches. Refunds, fees and tax deductions then change what finally reaches your bank. Without a well-kept ledger, none of this can be matched to reality, and the rules on sales tax registration in Pakistan make careless records riskier every year.

This guide comes from the Institute of Corporate and Taxation (ICT), where we teach practical accounting, taxation and compliance. It explains e-commerce ledger management from first principles: what to record, how to reconcile payouts, how to treat refunds, inventory and tax, and when to automate. It is written for store owners, bookkeepers, accountants and students, and it also draws on ICT’s own guidance on AI for bookkeeping.

By the end you will know how to build a clean chart of accounts and follow an order from click to bank deposit. You will also know how to close the month with confidence and what the FBR’s e-commerce rules mean for your records. If you want structured, hands-on training, our accounting and taxation courses cover these skills in depth.
Quick Answer: What Is E-Commerce Ledger Management?

E-commerce ledger management is the process of recording every online sale, fee, refund, tax and inventory movement in a structured general ledger, then reconciling it to payment-gateway payouts and bank statements. Done monthly, it gives an online store accurate profit figures, a clean audit trail and tax-ready records.

Key points

• Sales are not the same as bank deposits, because fees, refunds, reserves and timing differences sit in between.
• Use clearing accounts for each gateway, marketplace and courier so every payout can be matched to the orders behind it.
• Record gross sales, fees and refunds separately instead of posting only the net deposit.
• Reconcile at least monthly, and more often for high-volume stores, before filing returns.
• In Pakistan, keep records that can be matched with withholding statements generated under the FBR’s e-commerce regime.

What Is E-Commerce Ledger Management?

In short: it is the discipline of keeping a complete, organised and reconciled financial record of an online business. The record covers its sales channels, payment processors, couriers, suppliers, inventory and taxes. Sales tracking alone does not do this, and neither does a spreadsheet of orders. A true ledger turns operational data into accounting entries that produce financial statements.

Think of it as a pipeline. Your store platform (Shopify, WooCommerce or a marketplace) generates orders. Your payment gateway or courier collects the money, and your bank receives a net amount. The ledger connects all three and explains every rupee, dollar or pound along the way. ICT’s guide to business tax in Pakistan shows why that explanation matters at filing time.

What is the difference between bookkeeping and accounting?

Bookkeeping is the day-to-day recording and categorising of transactions. Accounting interprets those records, prepares financial statements, handles tax and advises on decisions. In e-commerce, a bookkeeper might post settlement data and reconcile payouts. An accountant reviews the ledger, decides on revenue and inventory treatment and prepares returns. Many small stores need both functions, even if one person performs them. You can see how the two roles differ in our article on becoming a tax accountant.

What is the difference between a journal, a general ledger and a subledger?

A journal records transactions in date order. A general ledger groups the same entries by account, so you can see everything that happened to “Sales” or “Inventory” in one place. A subledger holds detail for a specific area, such as accounts receivable, accounts payable or inventory, and its total feeds a control account in the general ledger. The trial balance lists every ledger balance, and total debits must equal total credits.

Why Does Ledger Management Matter for Online Stores?

In short: it matters because online revenue, cash and profit are three different numbers, and only a ledger shows how they connect. A store can report strong sales while cash is trapped in gateway reserves, unsettled courier remittances or unsold stock. It can also be losing money once fees, refunds, advertising and shipping are counted.

There are five practical reasons to take it seriously:

• Accurate profit. Contribution margin by product or channel is impossible without clean cost data, as explained in our guide to common tax mistakes by Pakistani businesses.
• Cash control. Knowing what is owed by gateways, couriers and marketplaces prevents surprise shortfalls.
• Tax compliance. Sales tax, income tax and withholding deductions all rely on correct records.
• Audit trail. Every figure can be traced back to a source document, which matters if you receive an FBR notice.
• Funding and growth. Banks, investors and acquirers expect reliable financial statements.

Who Needs an E-Commerce Ledger, and Who Should Maintain It?

In short: every business that sells online needs one, whether it is a home-based Instagram seller or a multi-channel brand. The complexity differs, but the principle is the same.

You need a ledger if you are any of these:

• A Shopify, WooCommerce or custom-website store owner.
• A marketplace seller on Amazon, Daraz or similar platforms.
• A dropshipper or print-on-demand seller with supplier invoices to match.
• A D2C brand with inventory, warehouses and couriers.
• An exporter or import-export business selling through online channels.

The owner can maintain the ledger in the early days, using accounting software and a consistent routine. As order volume, channels or inventory grow, a trained bookkeeper or accountant becomes worth the cost. Many Pakistani sellers in Islamabad, Rawalpindi, Lahore, Karachi, Faisalabad, Multan, Peshawar and Sialkot now outsource bookkeeping while keeping control through monthly review. If you are building a career around this work, ICT’s Odoo for Business course is one way to learn the workflows.

Learn More

What Should an E-Commerce Ledger Include?

In short: it should include a chart of accounts that reflects how an online store really earns and spends money. That means separate accounts for each sales channel, each payment processor, each type of fee, inventory, tax and refunds.

Ledger accounts fall into five types: assets, liabilities, equity, revenue and expenses. Assets and expenses increase with debits. Liabilities, equity and revenue increase with credits. Our Xero accounting guide shows how these types appear inside cloud software.

What does a sample e-commerce chart of accounts look like?

The structure below is a practical starting point, not a legal template. Adapt it to your business and your accountant’s advice.

Why do clearing accounts matter?

A clearing account is a temporary holding account for money that has been earned but not yet received. When a customer pays, the sale is posted against the gateway clearing account. When the payout lands, the bank is debited and the clearing account is cleared. If the clearing balance does not return to roughly zero after reconciliation, something is missing, such as a fee, a refund or a timing difference. ICT’s guidance on tax software that professionals use explains why this discipline carries over to every tool.

How Does an Online Order Flow Through the Ledger?

In short: an order moves through the stages of order, payment, fulfilment, settlement and bank deposit. Each stage creates entries. The worked example below is illustrative only and uses round numbers, not real statistics.

Assume a customer pays Rs 5,000 for a product that cost you Rs 2,000. The gateway charges a Rs 150 fee. Sales tax is left out for simplicity, and the tax treatment is covered later.

After these four entries, the gateway clearing account is zero. Revenue is Rs 5,000, expenses are Rs 150 plus Rs 2,000 of cost, and the bank holds Rs 4,850. Recording only the Rs 4,850 deposit would understate both sales and fees, and your margin analysis would be wrong.

How does cash on delivery change the flow?

Cash on delivery (COD) adds a courier between your store and your bank. Assume a Rs 4,000 order is delivered and the courier later remits it, deducting a Rs 250 charge.

Returned-to-origin parcels reverse the sale and, when goods return to stock, restore inventory. Where tax is also withheld at source, post it to its own account, as explained in the withholding section below.

How to Set Up an E-Commerce Ledger Step by Step

In short: set the foundations once and the monthly work becomes routine. The sequence below suits most small and mid-sized stores, and ICT’s QuickBooks course guide shows how the same steps look in popular software.

1. Choose your accounting software and base currency. QuickBooks Online, Xero, Zoho Books, FreshBooks, Wave, Sage and NetSuite are common options. Choose based on your country, inventory needs and integrations.
2. Build your chart of accounts. Start from the structure above and add channel-specific accounts.
3. Create a clearing account for every payment source. That means each gateway, marketplace, courier and wallet, kept separate from the bank account.
4. Connect bank feeds and sales channels. Automated bank feeds reduce typing errors, but they never replace review.
5. Set the accounting method and inventory method. Decide on cash or accrual and FIFO or weighted average, with your accountant’s agreement.
6. Define tax accounts and codes. Keep sales tax, withholding tax and input tax separate.
7. Document your posting rules. Write down how sales, fees, refunds, chargebacks and COD are recorded, so any bookkeeper can follow them.
8. Set a reconciliation calendar. Reconcile weekly or monthly, depending on volume.
9. Store source documents. Keep payout reports, invoices and courier statements in an organised folder, as the record-keeping rules expect.
10. Review monthly reports. Check profit and loss, balance sheet, cash flow and aged balances every month.

Explore the Course

How Do You Reconcile Payouts, Marketplaces and Cash on Delivery?

In short: reconcile each payout against the transactions it contains, not against your sales total. A payout is a net settlement, and it can include several days of sales, minus fees, refunds, disputes and adjustments. Reconciliation is easier once you accept that sales and deposits measure different things, which our article on digital invoicing and compliance also highlights.

How do you reconcile Shopify payouts?

Shopify lets eligible merchants export transactions from the payouts page. The route is Settings, Payments, View payouts, View transactions, Export, and you then choose a date range and CSV type. In January 2026 Shopify added a bank reference to payout exports and a payout ID to order transaction exports, so it is easier to see which bank deposit matches which transactions, as described in Shopify’s changelog. Payment methods outside Shopify Payments, such as PayPal or other gateways, pay out under their own rules and need their own reconciliation. Shopify Payments is also not offered in every country, so check Shopify’s supported-country list before relying on it. If you use Shopify, ICT’s Master Sales Tax course helps connect reconciliation to tax reporting.

How do you reconcile Amazon settlements?

Download the settlement report for the period that matches your bank deposit from Seller Central. Then separate gross sales, referral and fulfilment fees, storage fees, refunds, reimbursements and adjustments. Post each type to its own account and clear the Amazon clearing account against the deposit. Settlement cycles rarely match calendar months, so a cycle that straddles two months needs a cut-off entry. Our guide to AI accounting software compares tools that can automate this split.

How do you reconcile Stripe, PayPal and Payoneer?

Stripe states that every movement of funds creates a balance transaction, and its payout reconciliation report matches bank payouts to the batches of payments they settle. Its payout reconciliation documentation explains the reports in detail. For PayPal and Payoneer, record the gross receipt, the fee and any currency conversion separately, and recognise exchange differences in a foreign-exchange gain or loss account. For sellers working with US or UK clients, ICT’s course on UK taxation explains the compliance side of cross-border income.

How do you reconcile cash on delivery and courier remittances in Pakistan?

COD reconciliation is where many Pakistani stores lose money. Match each courier remittance statement to delivered orders, and record courier fees, failed deliveries and returns. Track unremitted balances as a receivable, and chase anything outstanding beyond the courier’s agreed settlement period. Compare delivery data from the courier with your store’s order data every week. Our guide on responding to withholding statements is useful here.

How should you handle timing differences, reserves and holds?

Timing differences are normal. Orders captured on the last day of the month may be paid out in the next. Gateways can also hold a reserve against refund or dispute risk. Record the withheld amount as a receivable from the gateway, not as a loss, and release it when the funds arrive. Keep a short “unreconciled items” list each month, and clear it before closing the period, as explained in ICT’s guide to the Pakistan tax calendar.

Which Accounting Method Is Best for an Online Store: Cash or Accrual?

In short: accrual accounting usually gives a truer picture of an online store, because it matches revenue and costs to the period in which they occur. Cash accounting records transactions only when money moves, which is simpler but can distort profit when payouts, COD and inventory purchases are delayed. Your entity type and your tax adviser’s guidance decide what is permitted, and ICT’s corporate tax guide explains the corporate context.

Incorporated businesses usually follow accrual-based frameworks such as IFRS. IFRS 15 is the IASB’s revenue standard. It sets out a five-step model for recognising revenue and has applied to annual periods beginning on or after 1 January 2018. In the US, the equivalent is Topic 606, issued by the FASB. The steps are to identify the contract, identify the performance obligations, set the price, allocate it, and recognise revenue when or as each obligation is met.

When is e-commerce revenue actually earned?

For most physical goods, revenue is recognised when control passes to the customer, usually on delivery. Pre-orders, subscriptions and gift cards are different, because you have received money but not yet delivered. Treat those amounts as liabilities until delivery or redemption. A COD sale is recognised at delivery, not at order. ICT’s guide to the Pakistan tax system shows how timing choices feed into tax reporting.

How Do You Account for Inventory and Cost of Goods Sold?

In short: inventory is an asset until the item is sold, and then its cost moves to cost of goods sold (COGS). The basic formula is opening inventory, plus purchases and landed costs, minus closing inventory.

Landed cost includes the purchase price plus inbound freight, import duties and other costs needed to bring goods to a saleable condition. Understanding it is essential for importers, and ICT’s customs clearance guide explains the duty side.

Which inventory valuation method should you use?

Under IAS 2, FIFO (first in, first out) and weighted average cost are acceptable, but LIFO is not. FIFO assumes the oldest stock sells first. Weighted average spreads cost across all units. Use whichever suits your product and apply it consistently. Inventory software such as Odoo handles these methods automatically, as ICT’s Odoo accounting guide explains.

What is the difference between perpetual and periodic inventory systems?

A perpetual system updates inventory and COGS with every sale, which suits online stores. A periodic system calculates COGS only after a stock count. Most e-commerce platforms support perpetual tracking, but you should still do regular counts to find shrinkage, damage and errors. Post write-offs and adjustments to a separate account so losses stay visible. The Master Import and Export course covers the cost and compliance side of imported stock.

How Do You Record Refunds, Chargebacks, Discounts, Gift Cards and Shipping?

In short: record each one in its own account, so you can see its true cost. Netting them against sales hides problems such as high return rates or costly shipping promises. ICT’s guide to tax credits versus tax deductions helps with the tax side of these costs.

How are refunds recorded in a ledger?

Debit “Sales returns and allowances” and credit the gateway clearing account (or bank). If the goods return to stock, debit inventory and credit COGS at cost. For a Rs 1,000 refund of an item that cost Rs 400 and went back into stock:

Whether the processor returns its fee on a refund depends on its terms, so check each processor’s rules and record any non-refunded fee.

How are chargebacks recorded?

A chargeback is a forced reversal initiated by the customer’s bank. Record the reversed sale, any chargeback fee and any inventory loss. If you win the dispute, reverse the entries. A recurring spike is a risk signal, so track chargeback losses in a dedicated account. Our guide to tax audits in Pakistan shows why unexplained adjustments draw attention.

How are discounts, coupons and gift cards recorded?

Record discounts as a deduction from sales, not as a marketing expense, unless your accounting policy says otherwise. Sold gift cards are liabilities, not revenue, until redeemed. Store credit is treated the same way. Loyalty points may also create a liability, and your accountant should assess the treatment under the applicable reporting framework. ICT’s article on sales tax training for accountants explains why correct invoice values matter.

How should you account for shipping income and shipping costs?

Shipping charged to customers is revenue (or a recovery, depending on policy), while the courier cost is an expense or part of COGS. Keep them in separate accounts, because “free shipping” is a cost you absorb and should see clearly. Use the same treatment for every order so your margin analysis stays reliable, and see the ICT blog on import and export tax rules for cross-border shipments.

How Do Sales Tax, VAT and Withholding Tax Affect an E-Commerce Ledger?

In short: tax changes your ledger in two ways. You collect or owe tax on sales, and third parties such as couriers, payment intermediaries or marketplaces may deduct tax before paying you. Both need dedicated accounts. This section is for general understanding and is not tax advice. Rates, thresholds and the final or adjustable character of deductions can change, so it deliberately quotes no rates. Always confirm the current position with the FBR or a qualified adviser. ICT’s Advanced Taxation and Litigation course goes deeper on these topics.

What is Pakistan’s e-commerce tax regime?

The FBR’s Sales Tax Circular 02 of 2025-26 explains that the Finance Act 2025 introduced a definition of “e-commerce” to bring digitally ordered taxable goods into the sales tax net. It also treats banks, financial institutions and payment gateways that move funds between parties as payment intermediaries responsible for collecting and paying tax on such goods. You can read the official FBR circular for the exact wording.

According to Dawn’s report on the registration procedures, e-commerce sellers must register for income tax, and online marketplaces and couriers may not serve unregistered sellers. Amendments to sections 14(1A) and 14(1B) of the Sales Tax Act also require e-commerce vendors, including non-residents selling through online marketplaces, to register under the sales tax framework. The practical steps for registering are covered in ICT’s guide to business NTN registration.

How should withheld tax appear in your books?

Since July 2025, the withholding regime has covered domestic e-commerce transactions, including cash-on-delivery and digitally paid orders, with couriers acting as withholding agents who file statements through IRIS. The same Customs Today report notes that sellers are advised to reconcile those statements against their own sales records to avoid later discrepancies.

In practice, post the gross sale to revenue and the tax withheld to a separate receivable or tax account. Whether the deduction is adjustable or final depends on your category, and the FBR circular treats it as a final discharge for certain categories, such as cottage industry. Your tax adviser decides the exact treatment. Our overview of withholding tax explains the mechanics.

What about VAT, GST and US sales tax for international sellers?

Sellers who reach customers abroad face other regimes. UK sellers deal with VAT, which ICT explains in its UK VAT guide. UAE-based activity falls under UAE VAT registration rules, and Canadian sales involve GST/HST. In the US, sales tax rules vary by state, and marketplace facilitator laws often shift collection to the platform. Tools such as TaxJar and Avalara automate calculation, but the ledger still needs correct tax accounts. Pakistani freelancers selling to the US can start with the US LLC tax filing guide.

How long must you keep your records?

Under section 174 of the Income Tax Ordinance, 2001, taxpayers generally keep records for six years after the end of the relevant tax year, but the proviso requires records to be maintained while proceedings are pending. The FBR’s summary of Supreme Court decisions confirms this position. Companies must also keep proper books of account under the Companies Act, 2017, and ICT’s guide to SECP annual return filing shows how records support corporate filings.

Which Financial Reports Should an Online Store Maintain?

In short: maintain a profit and loss statement, a balance sheet, a cash flow statement, a trial balance, aged receivables and payables, an inventory valuation report and a tax reconciliation. Together they show profitability, financial position and cash movement. Our guide to Advanced Excel skills helps you build custom reports.

How do online stores calculate net profit?

Start with net sales (gross sales less returns and discounts), subtract COGS to get gross profit, then subtract operating expenses. The example below is illustrative only.

Which KPIs should you track from the ledger?

• Gross margin: gross profit divided by net sales.
• Contribution margin per order: order revenue less product cost, fees, shipping and advertising for that order. If an order brings Rs 5,000, costs Rs 2,750 in product, Rs 100 in fees, Rs 300 in shipping and Rs 600 in advertising, its contribution is Rs 1,250, or 25%. These figures are illustrative.
• Average order value (AOV), customer acquisition cost (CAC) and return on ad spend (ROAS): these connect ledger data to marketing decisions.
• Inventory turnover: COGS divided by average inventory.

ICT’s Certified Data Analyst course is relevant if you want to turn these numbers into dashboards.

How Can You Automate E-Commerce Bookkeeping Safely?

In short: automation works best when your chart of accounts and posting rules are already clear. Connect your store, gateways and marketplaces to accounting software, and let rules handle repetitive entries, while a human reviews the exceptions. ICT’s review of the best AI tools for accountants covers current options.

Which tools can sync e-commerce data to your ledger?

Shopify and WooCommerce can connect to QuickBooks Online, Xero or Zoho Books through integrations. Marketplace-focused tools such as A2X and Link My Books summarise Amazon settlements into clean entries, and ERP platforms like Odoo and NetSuite handle larger operations. Automate repetitive entries and bank rules, but keep reconciliation and exception review as manual checkpoints. ICT’s Certified AI Automation Agents Specialist course explores workflow automation.

How do you choose accounting software for an online store?

Check these points before you commit:

• Does it connect to your store platform and gateways?
• Does it handle multi-currency and multi-channel reporting?
• Can it track inventory and landed costs?
• Does it support the tax rules in your country?
• Can your accountant access it?
• Does it keep an audit trail?

The comparison in ICT’s Xero accounting guide shows the questions to ask. For hands-on practice, the UK Accountant Course with Xero training covers bank feeds, automated rules, bank reconciliation and inventory management.

Can AI keep your books?

AI can categorise transactions, flag anomalies and draft reports. It cannot take responsibility for them. Outputs need review by a qualified person, and sensitive financial data should be handled according to your privacy policy. ICT’s article on AI tax calculation and legal risk discusses why. Finance leaders who want to use AI more broadly can look at the AI-Driven CFO Masterclass.

Manual, Automated or Outsourced: Which Approach Suits Your Store?

In short: the right choice depends on order volume, number of channels, inventory complexity and your own time. There is no single best option, and many stores combine approaches. Our guide to remote accounting careers also shows how outsourced bookkeeping works in practice.

How much does e-commerce bookkeeping cost?

There is no reliable single price. Cost depends on order volume, number of channels and gateways, inventory complexity, tax filings required and the experience of the provider. Ask for a written scope that lists reconciliations, reports, tax support and response times, and compare it with your own time cost. ICT’s guide on starting a tax preparation business explains how professionals structure such services.

How do you choose an e-commerce accountant near you?

Look for experience with your platform and tax regime, a clear month-end process, and willingness to explain the numbers. Ask how they reconcile gateways, COD and marketplaces, and whether they can handle FBR correspondence. Whether you are in Islamabad, Lahore, Karachi or elsewhere, check qualifications and ask for sample reports. If you are an owner who wants to understand your accountant’s work, ICT’s Certified Business Advisor course is one learning route.

What Are the Most Common E-Commerce Accounting Mistakes?

In short: most mistakes come from treating deposits as revenue and skipping reconciliation. The list below reflects the issues covered in this guide, and ICT’s article on income tax return filing mistakes explains how some of them surface at filing time. Actually, the correct page for that topic in your list is income-tax-return-filing-pakistan-mistakes.

1. Posting net payouts as sales instead of recording gross sales, fees and refunds separately.
2. Mixing personal and business money.
3. Skipping clearing accounts, which leaves unmatched balances.
4. Ignoring COD remittance delays and returned parcels.
5. Not recording inventory at landed cost.
6. Forgetting gift card, pre-order and deposit liabilities.
7. Mixing sales tax and withholding tax with revenue and expenses.
8. Not reconciling with courier or marketplace withholding statements.
9. Missing chargebacks, reserves and non-refunded fees.
10. Closing the month without reviewing unreconciled items.

What Happens If the Ledger Is Not Maintained Properly?

In short: you lose control of profit and cash, and you may face compliance problems. Poor records make it hard to answer tax notices, support tax credits or explain differences between declared sales and bank activity. ICT’s overview of FBR notices explains the process.

Specific risks include:

• Overpaying or underpaying tax because sales and withholding are misrecorded.
• Failure to match your sales records to withholding statements, which can trigger queries.
• Lost input tax credits where documentation is missing.
• Poor cash decisions, such as buying stock with money still trapped in gateways.
• Difficulty raising finance, since lenders ask for reliable statements.

If you receive a notice, a structured reply backed by clean records is far easier. Our guide on replying to a Section 161 notice shows how professionals approach this.

What Is a Practical Month-End Close Checklist for Online Stores?

In short: a repeatable checklist keeps the ledger accurate. Update the ledger daily or weekly for high-volume stores, and always close monthly. This frequency is a good-practice recommendation, not a legal rule, and ICT’s guide to digital invoicing for FBR compliance shows why timely records help.

1. Import or sync all sales, refunds and fees for the month.
2. Reconcile every bank account and gateway clearing account.
3. Match COD and courier remittances and review delivered, returned and unremitted orders.
4. Reconcile marketplace settlements, including month-end cut-offs.
5. Review inventory counts, shrinkage and write-offs.
6. Post accruals, prepayments and depreciation.
7. Reconcile sales tax and withholding tax accounts to filings and statements.
8. Review the trial balance for unusual balances.
9. Produce the profit and loss statement, balance sheet and cash flow statement.
10. Archive source documents and lock the period.

What Are the Career Opportunities in E-Commerce Accounting?

In short: as online selling grows, businesses need people who understand both accounting and platform data. Roles include e-commerce bookkeeper, marketplace accountant, reconciliation specialist, tax compliance officer and ERP functional consultant. Freelance and remote work is also possible, as ICT’s article on new digital compliance roles explains.

Useful skills include double-entry bookkeeping, reconciliation, sales tax knowledge, spreadsheet analysis and software such as QuickBooks, Xero, Zoho Books or Odoo. This guide does not quote salary figures, because we cannot verify a reliable current number. ICT’s Certified Tax Advisor course adds the tax depth that employers often look for.

Why Choose ICT for E-Commerce Accounting and Ledger Training in Pakistan

Learning ledger management works best when theory is tied to real workflows. ICT describes its approach on its About page as practical and career-focused, covering taxation, corporate affairs, finance and business. It lists campuses in Islamabad, Karachi and Lahore, and its mentors page introduces the people behind the programmes.

ICT’s accounting-related programmes already cover areas this guide discusses, such as bank reconciliation, inventory, sales tax and e-commerce sector rules. Students can also confirm a certificate through the certificate verification page. For more on how the institute positions itself, read why students choose ICT.

Frequently Asked Questions

What is an e-commerce ledger?
It is the set of accounts that records an online store’s sales, fees, refunds, inventory, tax and cash movements. It is the foundation for financial reporting.

What are the five types of ledger accounts?
Assets, liabilities, equity, revenue and expenses. Every transaction in an accounting system touches at least two of them.

How often should an e-commerce ledger be updated?
Daily or weekly for busy stores, and at least monthly for small ones. Regular updates also help you stay aligned with the tax calendar.

What is the difference between cash and accrual accounting?
Cash accounting records transactions when money moves, and accrual records them when they are earned or incurred. Most stores with inventory benefit from accrual, as explained in ICT’s corporate tax guide.

How do you record marketplace fees?
Post gross sales to revenue and commissions, referral fees and shipping charges to separate expense accounts. Never net them against sales, and see the Master Sales Tax course for tax treatment.

How are refunds recorded?
Debit sales returns and credit the gateway or bank, and restore inventory at cost if goods return to stock. ICT’s guide on sales tax invoicing explains why accurate adjustments matter.

How do you calculate COGS for an online store?
Add opening inventory and purchases (including landed costs), then subtract closing inventory. The import-export course covers landed costs for imported stock.

Is accounting software necessary for an online store?
It is not legally mandatory, but it becomes practically essential as orders and channels grow. Spreadsheets struggle with reconciliation and audit trails, as shown in ICT’s QuickBooks guide.

Can Shopify integrate with accounting software?
Yes. Shopify and similar platforms connect to tools such as QuickBooks Online and Xero through integrations. Learn the Xero side in the UK Accountant Course.

How do you reconcile Amazon settlements?
Download the settlement report for the period matching your bank deposit, split it into sales, fees, refunds and adjustments, and clear the Amazon clearing account. See ICT’s AI accounting software comparison for automation options.

How much does e-commerce bookkeeping cost?
It varies with order volume, channels, inventory and tax work, so ask for a written scope before comparing quotes. ICT’s business tax guide helps you list the work to be done.

Do online sellers in Pakistan need tax registration?
According to Dawn’s reporting on the FBR procedures, e-commerce sellers are required to register for income tax, and sales tax registration applies to e-commerce vendors under the amended provisions. Confirm your own position with the FBR or your adviser, using ICT’s NTN guide.

Conclusion

E-commerce ledger management is about making online money visible. When you record gross sales, fees, refunds, inventory and tax in the right accounts, and reconcile them every month, you see real profit, protect cash and have records ready for any query. In Pakistan, the FBR’s e-commerce regime means your books must also line up with withholding statements. Stores that build these habits early find growth, funding and compliance far easier, and the accounting automation tools available today can speed up the routine work once the foundations are sound.

If you want to build these skills properly, ICT’s Odoo for Business course teaches accounting, inventory and bank reconciliation in a business setting. Pair it with the Master Sales Tax course to cover the tax side. Talk to our team about the right programme for your goals.