Dropshipping finance tracker: track Shopify, Amazon and ecommerce profit

Why dropshippers choose SheetLink

Most dropshippers track sales in Shopify or Amazon but lose sight of the money once it hits the bank. SheetLink connects the dots:

• Sync platform payouts when you choose: Shopify, Amazon and eBay deposits land in your sheet when you press Sync now
• Track supplier costs (COGS): payments to AliExpress, Alibaba, CJ Dropshipping
• Monitor ad spend: Facebook Ads, Google Ads and TikTok Ads charges
• Calculate real profit: revenue minus COGS, fees, ads, shipping and refunds
• Handle refunds and chargebacks: track returns to see your true net revenue
• Tax-ready records: organized for Schedule C

Why manual sync works for dropshippers

SheetLink only syncs when you press Sync now. Unlike tools that pull from your bank in the background, it gives you complete control over when your financial data reaches your spreadsheet. That’s a privacy feature, not a limitation.

How to set up your dropshipping finance tracker

Get your ecommerce finances organized in under 10 minutes:

Track revenue from multiple sales channels

SheetLink syncs the payouts from every platform that pays into your connected accounts, so you see your total revenue:

Ecommerce platforms

Payment processors

Add a Platform column to tag each payout. See which channel has the best margins and focus your marketing there.

Calculate true COGS (cost of goods sold)

COGS is one of the biggest expenses for dropshippers. Here’s how to track it accurately:

With your tags in column AI, the amount column (M) does the rest. Supplier payments are money out, so they’re positive; payouts are money in, so they’re negative and need their sign flipped:

=SUMIF(Transactions!AI:AI, "COGS", Transactions!M:M) / -SUMIF(Transactions!AI:AI, "Revenue", Transactions!M:M)

Track all dropshipping expenses

SheetLink syncs every business expense from your connected accounts, so nothing falls through the cracks:

Platform fees

Shopify subscription ($29-299/month), Shopify transaction fees (2% if you don’t use Shopify Payments), Amazon referral fees (8-15%), payment processing fees from Stripe and PayPal (Stripe’s standard card rate is 2.9% + $0.30), eBay fees. Fees a platform takes out of your payout (Amazon’s referral fees, PayPal and Stripe processing fees) arrive as a smaller deposit, not as charges of their own.

Advertising spend

Facebook Ads, Instagram Ads, Google Ads, TikTok Ads, Pinterest Ads, influencer payments. Track your ad spend to calculate ROAS (return on ad spend): Revenue ÷ Ad spend. Aim for 3:1 or better.

Software and tools

Spocket and CJ Dropshipping fees, email marketing (Klaviyo, Mailchimp), inventory management, product research tools (Jungle Scout, Helium 10), design tools (Canva Pro).

Refunds and chargebacks

Customer refunds (which reduce revenue), chargeback fees ($15-25 per chargeback), and return shipping if you cover it. A high refund rate kills profit: aim for under 2%.

Other expenses

Business bank account fees, an accountant or bookkeeper, LLC registration, business insurance, product photography, a virtual assistant.

Calculate dropshipping profit margins

Knowing your true profit is essential for scaling your store. Here’s an example:

Example: Shopify dropshipping store (monthly)

Build formulas to calculate this from your synced transactions, and track the month-over-month changes.

Monitor key dropshipping metrics

Use your SheetLink data to calculate the critical ecommerce KPIs:

• Gross profit margin: (Revenue - COGS) ÷ Revenue × 100. Aim for 60-80%.
• Net profit margin: Net profit ÷ Revenue × 100. Aim for 20-30%.
• ROAS (return on ad spend): Revenue ÷ Ad spend. Aim for 3:1 at least.
• Average order value (AOV): Total revenue ÷ Number of orders.
• Customer acquisition cost (CAC): Total ad spend ÷ New customers.
• Refund rate: Refund amount ÷ Total revenue × 100. Keep it under 2-3%.

Handle refunds and chargebacks

Refunds and chargebacks are a fact of ecommerce. Here’s how to track them:

Track refunds

A refund you send a customer is money leaving your account, so it comes through as a positive amount (Plaid’s sign: money out is positive). Tag refunds separately to calculate your refund rate. A high refund rate points to product quality problems or misleading product descriptions.

Monitor chargebacks

Chargebacks are deducted from your payouts, plus a fee ($15-25). A high chargeback rate can get your Shopify or Amazon account suspended, so keep it under 1%. Common causes: long shipping times, items not as described.

Calculate net revenue

Net revenue = Gross revenue - Refunds - Chargebacks. Use net revenue, not gross, for every profit calculation.

Sales tax for dropshippers

If you have sales tax nexus (physical presence or economic nexus in a state), you must collect and remit sales tax:

• Economic nexus: most states require collection once your sales into the state pass a threshold, commonly $100,000 a year (some also count transactions)
• Shopify collects for you: set up tax collection in Shopify for the states where you have nexus
• Separate tax from revenue: sales tax isn’t your income, it’s a liability you owe the states
• File and remit: most states require monthly or quarterly filing; TaxJar or Avalara help with multi-state compliance
• Track it in your sheet: add a column for sales tax collected vs. actual revenue

Tax preparation for a dropshipping business

Dropshippers file Schedule C (sole proprietors) or a corporate tax return. Your synced sheet organizes the data for tax season:

• Gross receipts: total sales revenue (before refunds and fees)
• Returns and allowances: total refunds issued
• COGS: the cost of inventory bought from suppliers
• Advertising: Facebook Ads, Google Ads, influencer payments
• Office expenses: software subscriptions, tools, email marketing
• Home office deduction: if you work from home, deduct a portion of rent and utilities
• Quarterly estimated taxes: pay 25-30% of net profit each quarter to avoid penalties

SheetLink vs. ecommerce accounting tools

Where SheetLink fits: it tracks your actual bank activity, not just Shopify or Amazon data. See when money hits your account and track ad spend and supplier payments in one view, free for one bank or $4.99 a month for Pro.

Two example sellers

Alex: Shopify print-on-demand store

Challenge: Alex’s Shopify dashboard showed $30k in revenue, but only $7.5k of it was profit. Alex couldn’t work out where the money went.

Solution: SheetLink synced the bank deposits and expenses. Alex found that 20% went to refunds, 10% to Printful COGS, 5% to fees and 40% to ads.

Result: Better product descriptions cut the refund rate from 20% to 5%, and net profit grew from $7.5k to $12k a month.

Rachel: multi-channel ecommerce seller

Challenge: Rachel sold on Shopify, Amazon and eBay but couldn’t see which channel was most profitable.

Solution: SheetLink syncs the payouts from every platform. Rachel tagged each deposit by platform and tracked COGS and ad spend per channel.

Result: Amazon had 15% margins against Shopify’s 30%. She shifted her focus to Shopify and grew her overall profit by 60%.

Questions