Why Income Tracking Matters
Income tracking is the foundation of understanding your business performance. By systematically recording all revenue sources—from sales to returns and refunds—you gain visibility into which products, platforms, and customers are driving revenue. Combined with expense tracking, income data enables accurate profitability analysis, tax compliance, and informed business decisions. Without proper income tracking, you're flying blind on your business health.
Types of Income to Track
| Income Type | Description | Impact | Example |
|---|---|---|---|
| Product Sales | Revenue from product sales | Core revenue stream | $5,000 Amazon sales |
| Platform Fees Reimbursed | Advertising allowances, promotions reimbursed | Secondary revenue | $200 Amazon advertising grant |
| Refunds & Returns | Negative revenue (deduct from sales) | Reduces net sales | -$300 product returns |
| Shipping Reimbursements | Customer pays for shipping | Revenue offset | $50 shipping collected |
| Miscellaneous Income | Gifts, resales, other revenue | Minor revenue sources | $100 wholesale deals |
What's Included in Our Income Tracker
- Daily Sales Entry: Log each transaction with date, platform, product, and amount
- Multi-Platform Support: Separate columns/sheets for Amazon, Shopify, Etsy, eBay, Walmart
- Return & Refund Tracking: Deduct returns and refunds from gross sales
- Net Revenue Calculation: Automatic calculation of net sales after returns
- Platform Fee Visibility: Shows fees deducted by each platform
- Payment Method Tracking: Bank deposits, credit card, PayPal, etc.
- Payout Reconciliation: Links income to actual bank deposits
- Monthly Summaries: Automatic totals by month and platform
- Comparison Analysis: Compare revenue trends month-to-month and platform-to-platform
- Tax Category Codes: Mark income as taxable or exempt
How to Use the Income Tracker
Step 1: Set Up Platforms
Create tabs/sections for each sales platform (Amazon FBA, Amazon FBM, Shopify, Etsy, eBay, Walmart, etc.). Each platform has different fee structures and payout schedules.
Step 2: Daily Entry Habit
Enter sales daily: date, customer/order ID, product name/SKU, gross sale price, fees deducted, net amount received. This real-time tracking is more accurate than month-end reconciliation.
Step 3: Track Returns & Refunds
Record all returns, refunds, and chargebacks immediately. Mark as negative revenue to adjust gross sales to net sales. This is critical for accurate profitability.
Step 4: Reconcile to Deposits
Weekly or bi-weekly, match income tracker totals to actual bank deposits. Investigate any discrepancies before they grow. This catches problems early.
Step 5: Analyze Revenue Trends
At month-end, compare total revenue to previous months. Identify best-selling products and platforms. Use insights to optimize inventory and marketing.
Step 6: Calculate Profitability
Combine income data with expense data (from your expense tracker) to calculate profit: Revenue − COGS − Operating Expenses = Net Profit.
Income Tracking Best Practices
- Track by Platform: Separate tracking for each sales channel to understand which is most profitable
- Account for All Fees: Record platform fees, payment processor fees, and other deductions
- Update Immediately: Enter sales same day to avoid backlogs and memory gaps
- Verify Accuracy: Reconcile tracker to platform dashboards and bank statements weekly
- Monitor Trends: Track month-to-month changes to spot seasonal patterns or declining sales
- Document Returns: Reason for returns (damaged, defective, customer request) helps improve quality
- Compare Platforms: After-fee revenue per platform shows which channels are most efficient
Income vs. Profitability
Income is not profit. A critical mistake many sellers make is confusing revenue (total sales) with profit (revenue minus all expenses). Two sellers can have the same revenue but very different profitability:
Revenue − COGS − Operating Expenses = Net Profit
Not: Revenue = Success
Example: Seller A has $100,000 revenue with 40% COGS ($40,000) and 30% operating expenses ($30,000) = $30,000 profit (30% margin). Seller B has $100,000 revenue with 50% COGS ($50,000) and 25% operating expenses ($25,000) = $25,000 profit (25% margin). Same revenue, different profitability. Income tracking enables this analysis.
Multi-Platform Income Breakdown
- Amazon FBA: Track gross sales, FBA fees, referral fees, and net payment
- Amazon FBM: Lower fees than FBA, but you handle fulfillment
- Shopify: Your responsibility to fulfill, but lower platform fees (2.9% + $0.30)
- Etsy: Fixed shop fee ($0.20/listing) plus transaction fees (6.5%)
- eBay: Insertion fees, final value fees (12.9%), plus payment processing
- Walmart: Commission-based (6%), similar to Amazon but different fee structure
Download Our Free Income Tracker
Choose your preferred format to start tracking income accurately and systematically:
- Daily Sales Tracker (Excel): Day-by-day income entry with automatic summaries
- Monthly Income Summary (Excel): Consolidate sales into monthly revenue reports
- Multi-Platform Income Tracker (Excel): Separate sheets for each sales channel
- Income Tracker with Reconciliation (Excel): Links income to bank deposits
- Income Tracker (Google Sheets): Cloud-based with team sharing and real-time updates