Workflow

Calculate True Profit Per Order with Fetch & Accounting

Understanding your true profit per order is critical for scaling a profitable eBay dropshipping business. Simply subtracting your AliExpress purchase price from your eBay sale price is insufficient. You need to account for all variables: eBay fees, PayPal/payment processing fees, shipping costs, and critically, refunds. Fetch Order Tracking provides the granular data necessary to automate this calculation when integrated with your accounting software.

The Problem with Basic Profit Calculation

Most dropshippers start with a simple calculation:

• eBay Sale Price - AliExpress Purchase Price = Gross Profit

This method ignores significant deductions that erode your margins. Without a robust system, you're making decisions based on incomplete data, which can lead to mispricing, stocking unprofitable items, or failing to identify problematic suppliers.

Data Points for True Profit Calculation

To calculate true profit per order, you need the following data points for each order:

1. eBay Sale Price: The final price the customer paid on eBay.
2. eBay Shipping Charged: Any shipping fee the customer paid on eBay.
3. AliExpress Purchase Price: The actual cost you paid for the item on AliExpress.
4. AliExpress Shipping Cost: The actual shipping cost you paid on AliExpress.
5. eBay Final Value Fees: The percentage-based fee eBay charges on the total sale amount (item + shipping).
6. Payment Processing Fees: PayPal fees, eBay Managed Payments fees, or other payment processor fees.
7. Refund Amount (if any): The amount refunded to the customer. This is where Fetch becomes invaluable.
8. Refund-Related Fees: Any fees retained by eBay/payment processors during a refund.

Integrating Fetch for Refund Data

Fetch's primary value in this context is its automated tracking of refund status and amounts. Your accounting software can pull the gmt_refund and refund_amount fields directly from Fetch's API or your Google Sheet. This allows for real-time adjustments to profit calculations.

Workflow for Accounting Integration

1. Initial Order Sync: When an order is placed on eBay and fulfilled on AliExpress, log the following into your accounting software:
   • eBay Order ID
   • eBay Sale Price
   • eBay Shipping Charged
   • AliExpress Order ID
   • AliExpress Purchase Price
   • AliExpress Shipping Cost
   • Estimated eBay Final Value Fees (can be calculated based on current rates)
   • Estimated Payment Processing Fees (can be calculated)
   • Initial Gross Profit (Sale Price + eBay Shipping - Purchase Price - AliExpress Shipping - Estimated Fees)
2. Fetch Data Sync: Regularly (e.g., daily or weekly), pull data from Fetch for all active orders. Focus on orders where order_status or logistics_status might indicate an issue, or specifically where gmt_refund is populated.
3. Refund Adjustment: If Fetch reports a refund (gmt_refund is not null and refund_amount > 0):
   • Locate the corresponding order in your accounting software.
   • Subtract the refund_amount from the initial Gross Profit.
   • Adjust for any retained fees or refunded fees from eBay/payment processors. For example, eBay typically refunds a portion of the Final Value Fee if a full refund is issued.
4. Final Profit Calculation: Once the order reaches a terminal status (e.g., FINISH, BUYER_ACCEPT_GOODS, or a fully resolved refund case), the profit calculation in your accounting software should be final.

Neglecting refund data in your profit calculations is like trying to drive with a blindfold on. Fetch provides the visibility needed to understand your actual bottom line on every single order, not just the successful ones.

Example Scenario

Let's consider an order:

• eBay Sale Price: $25.00
• eBay Shipping Charged: $5.00
• AliExpress Purchase Price: $10.00
• AliExpress Shipping Cost: $2.00
• eBay Final Value Fee (13% of $30.00): $3.90
• Payment Processing Fee (3% of $30.00): $0.90

Without Refund:

True Profit = ($25.00 + $5.00) - ($10.00 + $2.00 + $3.90 + $0.90) = $30.00 - $16.80 = $13.20

With Partial Refund (AliExpress reports gmt_refund and refund_amount = $5.00):

Assume eBay partially refunds $0.65 of the FVF for a $5.00 item refund.

Adjusted True Profit = $13.20 - $5.00 (refund) + $0.65 (refunded FVF) = $8.85

With Full Refund (AliExpress reports gmt_refund and refund_amount = $10.00):

Assume eBay fully refunds FVF on item portion, and payment processor refunds fees on item portion. This gets complex, but Fetch simplifies the initial refund amount.

Adjusted True Profit (simplified) = $13.20 - $10.00 (refund) + $1.30 (refunded FVF) + $0.30 (refunded PP fee) = $4.80

The complexity of refund-related fee adjustments underscores the need for automated integration. Fetch provides the core refund trigger and amount, which your accounting system can then use to apply your specific fee refund rules.

Benefits of Accurate Profit Tracking

• Better Product Sourcing: Identify truly profitable niches and products, not just those with high perceived margins.
• Optimized Pricing: Set competitive prices that cover all costs and ensure your desired profit margin.
• Supplier Performance: Pinpoint suppliers with high refund rates, impacting your bottom line.
• Cash Flow Management: Understand your real cash position, factoring in money tied up in returns or lost to refunds.
• Tax Preparation: Have clean, auditable financial records for tax season.
• Strategic Growth: Make data-driven decisions on where to invest more resources.

Integrating Fetch Order Tracking with your accounting solution isn't just about tracking refunds; it's about building a robust financial backbone for your dropshipping business. By automating the capture of critical refund data, you move beyond guesswork to a precise understanding of your profitability.

To learn more about how Fetch can streamline your dropshipping operations, visit our homepage.

---