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:

Type	Convention	Example
Customers	[Name] - [City]	Rahul Kumar - Mumbai
Suppliers	[Name] - [Product]	ABC Traders - Electronics
Bank	[Bank] - [Type]	HDFC - Current
Sales	Sales - [Category]	Sales - Apparel

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:

Seller Location	Buyer Location	Tax Type
Maharashtra	Maharashtra	CGST + SGST
Maharashtra	Karnataka	IGST
Maharashtra	Unknown	IGST (safer default)

Important: Always capture complete customer addresses including state.

Input Tax Credit Documentation

Maintain proper records for ITC claims:

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

E-invoicing Compliance

If turnover exceeds Rs. 5 crore:

Generate IRN for B2B invoices
Update invoices within 24 hours
Maintain QR codes on invoices
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:

Gateway	Ledger	Settlement Cycle
Shopify Payments	Shopify Receivables	2-3 days
Razorpay	Razorpay Receivables	T+2
PayU	PayU Receivables	T+2
COD Partners	COD Receivables	Weekly

Maintain separate receivable ledgers for each.

Inventory Management

Stock Valuation Methods

Method	When to Use	Tally Config
FIFO	Most e-commerce	Default, recommended
Weighted Average	Frequent price changes	Configure in company
Specific Identification	Luxury/unique items	Track by serial

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

Process	Manual Time	Automation Tool
Order to voucher	3-5 min/order	Shopify Tally Sync
Bank reconciliation	2-3 hours/month	Bank statement import
GST filing prep	4-6 hours/month	Tally export
Financial reports	2-3 hours/month	Scheduled reports

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

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

For Existing Businesses

Audit current setup (Week 1)
Clean up historical data (Week 2)
Implement automation (Week 3)
Train team (Week 4)
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