E-commerce Accounting Best Practices for Indian Shopify Sellers

Running a successful Shopify store requires more than great products and marketing. Proper accounting practices ensure compliance, provide business insights, and prevent costly mistakes. This guide covers best practices specifically for Indian e-commerce businesses.

Setting Up Your Chart of Accounts

Essential Ledger Groups

Create these primary groups in Tally:

Revenue Groups:

Sales Accounts
├── Online Sales - Shopify
├── Marketplace Sales (if applicable)
├── Shipping Revenue
└── Other Income

Expense Groups:

Direct Expenses
├── Cost of Goods Sold
├── Packaging Materials
├── Shipping Charges
└── Payment Gateway Fees

Indirect Expenses
├── Marketing & Advertising
├── Platform Fees (Shopify subscription)
├── Software Subscriptions
└── Returns & Refunds

Asset Groups:

Current Assets
├── Bank Accounts
├── Payment Gateway Receivables
├── Inventory
└── GST Input Credit

Fixed Assets
├── Computers & Equipment
├── Office Furniture
└── Vehicles (if applicable)

Liability Groups:

Current Liabilities
├── GST Output Payable
├── TDS Payable
├── Creditors for Goods
└── Pending Refunds

Duties & Taxes
├── CGST Output
├── SGST Output
├── IGST Output
└── Cess (if applicable)

Naming Conventions

Use consistent naming for easy searching and reporting:

GST Handling Best Practices

Multi-Rate Product Handling

If you sell products at different GST rates:

Option 1: Separate Sales Ledgers

Sales - 5% GST
Sales - 12% GST
Sales - 18% GST
Sales - 28% GST

Option 2: Stock Item Based

Stock Items → GST Details → Rate
(Automatically picks correct rate)

Recommendation: Use stock items with GST configured. This ensures accuracy even with thousands of SKUs.

Place of Supply Rules

For e-commerce, place of supply determines CGST/SGST vs IGST:

Important: Always capture complete customer addresses including state.

Input Tax Credit Documentation

Maintain proper records for ITC claims:

1. Purchase invoices: Scanned copies with GSTIN
2. Credit notes: From returns to suppliers
3. Service invoices: Shipping, marketing, software
4. Import documents: If sourcing internationally

E-invoicing Compliance

If turnover exceeds Rs. 5 crore:

1. Generate IRN for B2B invoices
2. Update invoices within 24 hours
3. Maintain QR codes on invoices
4. Cancel within 24 hours if needed

Payment Reconciliation

Understanding Shopify Payouts

Shopify payouts include:

• Order amounts
• Minus: Payment processing fees
• Minus: Refunds
• Minus: Chargebacks
• Plus: Adjustments

Daily reconciliation formula:

Expected Payout = Orders - Fees - Refunds ± Adjustments

Recording Payment Gateway Fees

Don't net off fees. Record them separately:

Entry for Payout:

Bank A/c                    Dr.    9,700
Payment Gateway Charges     Dr.      300
  To Sales (or Receivables)    Cr. 10,000

This gives you accurate:

• Total sales figures
• Payment processing costs
• Actual cash received

Multi-Gateway Reconciliation

If using multiple payment methods:

Maintain separate receivable ledgers for each.

Inventory Management

Stock Valuation Methods

Handling Returns

Create a returns workflow:

Return Received:

Stock Item (Returned Goods)    Dr.
  To Sales Returns                 Cr.
  To Customer Account              Dr. (if refund pending)

If Resaleable:

Stock Item (Regular)           Dr.
  To Stock Item (Returned)         Cr.

If Damaged:

Damaged Goods Expense         Dr.
  To Stock Item (Returned)         Cr.

Dead Stock Identification

Quarterly, review:

• Items not sold in 90 days
• Items with high return rates
• Slow-moving inventory

Create provisions for obsolete stock if significant.

Cash Flow Management

Daily Cash Position

Track daily:

Opening Balance
+ Expected Collections (Orders - Returns)
- Scheduled Payments (Suppliers, Ads)
- Fixed Costs (EMIs, Subscriptions)
= Expected Closing Balance

Working Capital Cycle

Understand your cycle:

Inventory Days + Receivable Days - Payable Days = Cash Cycle

For e-commerce:

• Inventory Days: 30-60 (depends on model)
• Receivable Days: 2-7 (payment gateway hold)
• Payable Days: 15-45 (supplier terms)

Typical e-commerce cash cycle: 15-30 days

Seasonal Planning

Plan for:

• Diwali/Festive season (October-November)
• End of season sales
• New collection launches

Build inventory reserves 60-90 days before peak.

Financial Reports to Review

Daily

• Orders vs Synced vouchers count
• Payment gateway balance
• Return requests

Weekly

• Sales by product category
• Marketing spend vs revenue
• Outstanding receivables

Monthly

• Profit & Loss statement
• Balance Sheet
• GST reconciliation
• Bank reconciliation

Quarterly

• Product-wise profitability
• Customer acquisition cost
• Inventory turnover
• Tax planning review

Automation Best Practices

What to Automate

Integration Points

Shopify → Tally (Orders, Returns)
Bank → Tally (Statements)
Tally → GST Portal (Returns)
Tally → Reports (Dashboard)

Automation ROI

For 500 orders/month:

• Manual: ~50 hours/month
• Automated: ~5 hours/month
• Savings: 45 hours = Rs. 9,000-15,000

Common Mistakes to Avoid

1. Mixing Personal and Business

Always maintain:

• Separate bank accounts
• Clear documentation for drawings
• Proper capital account entries

2. Ignoring Small Expenses

Track even Rs. 100 expenses:

• Packaging materials
• Small tools
• Courier charges

3. Late GST Filing

Set reminders:

• GSTR-1: Due 11th
• GSTR-3B: Due 20th
• Annual: December 31

4. Not Reconciling Regularly

Monthly reconcile:

• Bank statements
• Payment gateway payouts
• GST credit ledger
• Inventory counts

5. Poor Documentation

Keep for 6 years:

• All invoices (issued and received)
• Bank statements
• GST returns
• Contracts and agreements

Getting Started

For New Businesses

1. Set up chart of accounts (Day 1)
2. Configure GST properly (Day 1)
3. Automate order sync (Week 1)
4. Establish reconciliation routine (Week 2)
5. Create reporting schedule (Week 3)

For Existing Businesses

1. Audit current setup (Week 1)
2. Clean up historical data (Week 2)
3. Implement automation (Week 3)
4. Train team (Week 4)
5. Monitor and adjust (Ongoing)

Conclusion

Proper accounting practices aren't just about compliance - they provide insights that drive better business decisions. For Indian e-commerce businesses, this means:

• Accurate GST handling
• Proper payment reconciliation
• Clear inventory management
• Regular financial review
• Strategic automation

Start with the basics, automate repetitive tasks, and build robust reporting. Your future self (and your accountant) will thank you.

Ready to automate your order accounting?

Start Your Free Trial - Sync Shopify orders to Tally automatically