E-Commerce Expense Tracking & Burn Rate

Expense tracking in MerchantFlow is the process of recording, categorizing, and analyzing all business costs beyond product COGS and ad spend, giving Shopify and WooCommerce merchants a complete view of profitability. Track operational costs, capital investments, recurring subscriptions, and attribute expenses to specific channels or projects to calculate true ROI.

What Are Business Expenses in E-Commerce?

Business expenses are the costs of running your e-commerce operation beyond product costs:

• Software subscriptions (Shopify, email marketing, analytics tools)
• Marketing spend (ads, influencers, content creation)
• Office and supplies
• Equipment purchases
• Website development
• Professional services (accounting, legal)
• Shipping and fulfillment costs
• Team salaries and contractors

Why Track Expenses?

• Complete profit picture - Revenue minus all costs = true profit
• Burn rate analysis - How fast you are spending cash
• Budget management - Stay within spending limits
• Tax preparation - Organized records for deductions
• Attribution - Which expenses drive revenue

How to Access Expense Tracking

Navigate to Dashboard > P&L and expand the Expenses section.

Expense Dashboard shows:

• Total expenses by category
• Operating expenses (OPEX)
• Capital expenses (CAPEX)
• Recurring vs. one-time costs
• Expense trends over time
• Burn rate calculation
• Expense attribution to projects/channels

[Screenshot: Expense tracking dashboard]

What Is OPEX vs CAPEX?

Operating Expenses (OPEX)

Operating expenses are the day-to-day costs of running your business:

Marketing & Advertising:

• Google Ads (auto-synced if connected)
• Meta Ads (auto-synced if connected)
• Influencer partnerships
• Content creation
• Email marketing tools
• SEO services

Software & Subscriptions:

• Shopify/WooCommerce subscription
• Email marketing (Klaviyo, Mailchimp)
• Analytics tools
• Customer service platforms
• Accounting software
• Project management tools

Operations:

• Office rent
• Utilities
• Shipping materials
• Fulfillment fees
• Payment processing fees
• Bank fees

People:

• Salaries
• Contractor fees
• Freelancer payments
• Employee benefits (if applicable)

Professional Services:

• Accounting and bookkeeping
• Legal fees
• Consulting

[Screenshot: OPEX categories]

Capital Expenses (CAPEX)

Capital expenses are long-term investments that provide value over time:

Equipment:

• Computers and hardware
• Photography equipment
• Warehouse equipment
• Office furniture

Development:

• Website redesign
• Custom app development
• Brand identity development
• Major platform migrations

Infrastructure:

• Warehouse lease deposit
• Major software licenses (multi-year)
• Domain purchases

Marketing Assets:

• Professional product photography
• Video production
• Trademark registration

Key difference from OPEX:

• OPEX: Ongoing, recurring, immediate benefit
• CAPEX: One-time, long-term, lasting value

[Screenshot: CAPEX categories]

How to Add Expenses in MerchantFlow

Method 1: Manual Entry (Single Expense)

For individual expense records:

1. Go to Dashboard > P&L > Expenses
2. Click "Add Expense" button
3. Fill in expense details:
   • Amount - Cost in your currency
   • Date - When expense occurred
   • Category - Type of expense (see categories below)
   • Description - Brief note (e.g., "January Shopify subscription")
   • Type - OPEX or CAPEX
   • Recurring - Is this a recurring expense? (Yes/No)
   • Project - Optional: Attribute to project
   • Channel - Optional: Attribute to marketing channel
4. Click "Save"

[Screenshot: Add expense form]

Method 2: Recurring Expenses

For monthly subscriptions or regular costs:

1. Add expense as described above
2. Toggle "Recurring" to ON
3. Set recurrence:
   • Frequency - Monthly, Quarterly, Annual
   • Start date - When it began
   • End date - Optional (leave blank for ongoing)
4. Save

Effect: MerchantFlow automatically records this expense each period. You do not need to manually enter it every month.

Examples:

• Shopify subscription: $79/month, recurring monthly
• Annual software license: $1,200/year, recurring annually
• Quarterly accounting fees: $500/quarter, recurring quarterly

[Screenshot: Recurring expense setup]

Method 3: Auto-Synced Advertising

Google Ads and Meta Ads sync automatically:

• Connect Google Ads or Meta Ads integration
• Ad spend imports automatically during syncs
• Appears in Expenses under "Advertising"
• Already attributed to campaigns/channels

Manual override:

If automatic sync is not working:

1. Add expense manually
2. Category: "Advertising"
3. Add campaign name in description
4. Attribute to channel

Connect integrations

Method 4: Bulk Import

For importing many expenses at once:

1. Go to Dashboard > P&L > Expenses
2. Click "Import Expenses" button
3. Download CSV template
4. Fill in:
   • Date
   • Amount
   • Category
   • Description
   • Type (OPEX/CAPEX)
5. Upload completed CSV
6. Review and confirm

Use cases:

• Importing historical expenses from accounting software
• Uploading monthly credit card statements
• Bulk entry of contractor payments

[Screenshot: CSV upload interface]

Expense Categories

Pre-defined Categories

Marketing & Advertising:

• Paid search (Google Ads)
• Social media ads (Meta, TikTok)
• Influencer marketing
• Content marketing
• Email marketing
• SEO services

Technology:

• Software subscriptions
• Hosting and domains
• Development costs
• Analytics tools
• Customer service platforms

Operations:

• Fulfillment and shipping
• Payment processing
• Inventory management
• Returns processing

Overhead:

• Office rent
• Utilities
• Insurance
• Bank fees
• Accounting

People:

• Salaries
• Contractors
• Training
• Recruiting

How to Create Custom Categories

1. Go to Settings > Expense Categories
2. Click "Add Category"
3. Name category (e.g., "Trade Shows")
4. Choose parent (OPEX or CAPEX)
5. Save

Use custom categories for business-specific costs:

• Trade show expenses
• Product sampling
• Wholesale showroom costs
• Specific software not in standard list

What Is Expense Attribution?

Expense attribution links expenses to specific projects or marketing channels so you can calculate true ROI.

Example:

You spend $5,000 on Facebook Ads for a product launch campaign. With attribution:

• Expense: $5,000 attributed to "Q1 Product Launch"
• Revenue: Track revenue from that campaign
• ROI: Calculate profit from campaign

Learn more about Attribution

How to Attribute Expenses to Projects

Projects are initiatives or campaigns:

• Product launches
• Seasonal campaigns
• Market expansion
• Website redesigns

How to attribute:

1. When adding expense, select Project dropdown
2. Choose existing project or create new
3. Save expense

View project profitability:

1. Go to Dashboard > Attribution > Projects
2. See revenue and expenses by project
3. Calculate project ROI

How to Attribute Expenses to Channels

Channels are marketing sources:

• Google Search
• Facebook/Instagram
• Email marketing
• Organic social
• Influencer partnerships

How to attribute:

1. When adding expense, select Channel dropdown
2. Choose channel
3. Save

View channel profitability:

1. Go to Dashboard > Attribution > Channels
2. See revenue and expenses by channel
3. Calculate channel ROAS

[Screenshot: Expense attribution fields]

How to View Expense Reports

Expenses Overview

Dashboard > P&L > Expenses shows:

• Total expenses this period
• OPEX vs. CAPEX breakdown
• Top expense categories
• Trend chart (spending over time)
• Comparison to previous period

[Screenshot: Expenses overview]

Expense by Category

View spending breakdown:

1. Click "By Category" tab
2. See pie chart and table
3. Identify top spending categories
4. Filter by date range

Actions:

• Export to CSV
• Drill down into category
• See individual expense records

[Screenshot: Category breakdown]

Recurring Expenses

View all subscriptions and recurring costs:

1. Click "Recurring" tab
2. See list of active recurring expenses
3. See total monthly recurring costs
4. Identify opportunities to reduce subscriptions

Monthly Recurring Expense Calculation:

Total Monthly Recurring Expenses = Sum of all monthly recurring costs

Why this matters: Recurring costs compound. Cutting a $50/month subscription saves $600/year.

[Screenshot: Recurring expenses list]

Expense Timeline

Visual timeline of spending:

1. Click "Timeline" tab
2. View expense events on calendar
3. See spending patterns
4. Identify seasonal trends

Use cases:

• Plan budget for busy seasons
• Identify unusual spending spikes
• Compare year-over-year spending

What Is Burn Rate and How Is It Calculated?

Burn rate is how fast your e-commerce business spends cash reserves:

Monthly Burn Rate = Total Monthly Expenses - Total Monthly Revenue

Positive burn rate: Spending more than earning (burning cash) Negative burn rate: Earning more than spending (accumulating cash)

How to View Burn Rate

Dashboard > P&L > Burn Rate shows:

• Current monthly burn rate
• Runway (months until cash runs out)
• Burn rate trend
• Runway projection

Example:

• Cash balance: $50,000
• Monthly revenue: $20,000
• Monthly expenses: $25,000
• Burn rate: -$5,000/month
• Runway: 10 months

Action: Increase revenue or decrease expenses before runway ends.

[Screenshot: Burn rate dashboard]

How to Improve Burn Rate

Increasing Revenue:

• Launch new products
• Optimize pricing
• Improve conversion rates
• Expand to new markets

Decreasing Expenses:

• Audit subscriptions (cancel unused)
• Negotiate with vendors
• Optimize ad spend (focus on high ROAS)
• Reduce contractor costs
• Move to cheaper tools

Learn more about P&L optimization

How to Edit and Delete Expenses

Update Expense Details

1. Find expense in Expenses list
2. Click pencil icon to edit
3. Modify fields
4. Click "Save"

Can change:

• Amount
• Date
• Category
• Description
• Attribution (project/channel)

Delete Expenses

1. Find expense in list
2. Click trash icon
3. Confirm deletion

Warning: Deletion is permanent. Affects burn rate and attribution calculations.

Pause Recurring Expenses

To temporarily stop a recurring expense:

1. Edit recurring expense
2. Set "End date" to today
3. Save

To resume later:

1. Edit expense
2. Remove end date or set future end date
3. Save

How to Set Expense Alerts

Get notified when spending exceeds thresholds:

1. Go to Settings > Notifications
2. Enable "Expense Alerts"
3. Set thresholds:
   • Total monthly expenses exceed $X
   • Specific category exceeds $X
   • Burn rate exceeds $X/month
4. Choose notification method (email/dashboard)

Use cases:

• Alert when ad spend exceeds budget
• Notify when monthly expenses hit target
• Warning when burn rate becomes concerning

[Screenshot: Expense alert settings]

How to Export Expense Data

Export for Accounting

Prepare for tax filing or bookkeeping:

1. Navigate to Dashboard > P&L > Expenses
2. Set date range (e.g., full year)
3. Click "Export" button
4. Choose format:
   • CSV (for Excel)
   • PDF (for printing)
   • QuickBooks format (for import)
5. Download

Exported data includes:

• Date
• Amount
• Category
• Description
• Type (OPEX/CAPEX)
• Project/channel attribution

Export by Category

For specific expense analysis:

1. Filter to category (e.g., "Software")
2. Set date range
3. Click "Export"
4. Get detailed CSV of that category

Best Practices for Expense Tracking

1. Record Expenses Promptly

Do not wait until month-end:

• Add expenses when they occur
• Set up recurring expenses once
• Import monthly credit card statements

Why: Real-time data helps you make informed decisions now, not after the fact.

2. Use Consistent Categories

Standardize expense categorization:

• Always categorize Shopify under "Software"
• All ad spend under "Marketing & Advertising"
• Keep categories consistent month-to-month

Why: Enables accurate trend analysis and comparisons.

3. Add Detailed Descriptions

Be specific in descriptions:

• "January 2026 Shopify subscription" (good)
• "Facebook Ads - Holiday Campaign" (good)
• "Software" (too vague)
• "Ads" (too vague)

Why: Easier to review during tax prep or when analyzing specific campaigns.

4. Attribute Marketing Expenses

Always attribute marketing costs:

• Link ad spend to campaigns
• Connect contractor costs to projects
• Tie expenses to channels

Why: Calculate true ROI for marketing initiatives.

5. Review Recurring Expenses Quarterly

Audit subscriptions every 3 months:

• Which subscriptions are not used?
• Can you downgrade plans?
• Are there cheaper alternatives?

Tip: Regular audits help identify unused subscriptions and redundant costs.

6. Separate OPEX and CAPEX

Properly classify expenses:

• OPEX: Ongoing, recurring, operational
• CAPEX: One-time, long-term investments

Why: Different tax treatment. Important for accurate financial reporting.

7. Track Burn Rate Monthly

Monitor cash runway:

• Calculate burn rate each month
• Set alerts for concerning trends
• Plan adjustments before running out of cash

Why: Avoid running out of cash unexpectedly.

Troubleshooting Expense Tracking

Expense Not Showing in Reports

Check:

• Date range includes expense date
• Category filters not excluding expense
• Expense was saved (not just drafted)

Recurring Expense Not Auto-Creating

Verify:

• Recurring toggle is ON
• Start date is in the past
• End date has not passed (if set)
• Frequency is correct

Fix: Edit recurring expense, verify settings, save.

Ad Spend Not Syncing

If Google/Meta Ads not auto-importing:

1. Check integration is connected (Settings > Integrations)
2. Trigger manual sync (Dashboard > Sync)
3. Verify campaigns were active during period
4. Check date range

Ad spend troubleshooting

Burn Rate Seems Wrong

Verify:

• All expenses are recorded
• All revenue is synced
• Date range is correct (monthly)
• Not mixing time periods

Cannot Find Expense to Edit

Try:

• Search by description
• Filter by category
• Check different date range
• Look in archived expenses (if applicable)

Frequently Asked Questions

What is the difference between OPEX and CAPEX in e-commerce?

OPEX (operating expenses) are ongoing, recurring costs like software subscriptions, ad spend, and salaries. CAPEX (capital expenses) are one-time investments with lasting value like equipment purchases, website redesigns, and major software licenses. The distinction matters for tax treatment and financial reporting.

How does MerchantFlow automatically track ad spend?

When you connect your Google Ads or Meta Ads integrations, MerchantFlow automatically imports ad spend data during each sync. The spend appears under the "Advertising" expense category and is already attributed to campaigns and channels.

Can I import expenses from QuickBooks or other accounting software?

Yes. Use the bulk import feature under Dashboard > P&L > Expenses > Import Expenses. Download the CSV template, fill in your data, and upload. MerchantFlow accepts CSV files exported from most accounting platforms.

How often should I review recurring expenses?

Audit your recurring expenses quarterly. Use the "Recurring" tab to see all active subscriptions and their total monthly cost. Many businesses find unused or underutilized subscriptions that can be cancelled to reduce burn rate.

What is a healthy burn rate for an e-commerce store?

A healthy e-commerce business has a negative burn rate, meaning revenue exceeds expenses. If your burn rate is positive (spending more than earning), monitor your cash runway closely and take action to either increase revenue or reduce costs before reserves run out.

Related Topics

• P&L Overview - Complete financial tracking
• COGS Management - Product cost tracking
• Bank Balance - Cash position monitoring
• Attribution System - Project and channel tracking
• Expense FAQ - Common questions

Need help? Contact support at [email protected] or visit our Expense FAQ.

Last updated: March 14, 2026