Workflow

Reconcile eBay GBP Payouts with AliExpress USD Costs

One of the most common reconciliation challenges for dropshippers involves currency mismatches. You sell on eBay UK, receiving payouts in GBP, but source from AliExpress in USD. Simply comparing the GBP payout to the USD cost for a single order doesn't give you an accurate profit picture due to exchange rate fluctuations, eBay fees, PayPal fees (if applicable), and potential refunds.

This process requires a structured approach to ensure every transaction is accounted for and your true profit margin is visible, especially when dealing with high volumes.

Tracking Order-Level Currency Conversions

For each order, you need to record both the eBay sale price in GBP and the AliExpress purchase price in USD. The critical step is converting one of these to the other currency at the time of the transaction.

1. Record eBay Sale Details (GBP)

• Sale Price: The final amount the buyer paid, including shipping.
• eBay Fees: Insertion fees, final value fees, promoted listing fees. These are usually deducted from your payout.
• PayPal Fees: If you use PayPal, record their transaction fees.
• Net Payout (GBP): Sale Price - eBay Fees - PayPal Fees. This is the amount you actually receive or is available for payout.

2. Record AliExpress Purchase Details (USD)

• Product Cost: The price of the item on AliExpress.
• Shipping Cost: Any shipping fees paid to AliExpress.
• Total AliExpress Cost (USD): Product Cost + Shipping Cost.

3. Determine Exchange Rates

This is where precision matters. You need to use the exchange rate that was applied to *your specific transaction*:

• For eBay Payout Conversion: If eBay or your payment processor (e.g., PayPal) converts the GBP to USD for you, use their exact conversion rate. If you withdraw GBP to a GBP bank account and then manually convert to USD, use the rate from your bank/exchange service.
• For AliExpress Purchase Conversion: If you pay AliExpress in USD directly from a USD account, no conversion is needed on the payment side. If you pay in GBP, your bank or payment processor will apply an exchange rate to convert your GBP to USD. Record this specific rate.

Always use the actual exchange rate applied to your specific funds, not a generic mid-market rate. This accounts for bank spreads and ensures accurate cost basis.

Calculating Profit per Order

To calculate profit, you need to bring both sides into a single currency. We recommend converting the AliExpress USD cost into GBP using the exchange rate at the time of purchase. This allows you to compare directly against your Net Payout (GBP).

1. AliExpress Cost in GBP: Total AliExpress Cost (USD) × (GBP/USD Exchange Rate at time of AliExpress purchase).
2. Gross Profit (GBP): Net Payout (GBP) - AliExpress Cost in GBP.

Handling Refunds and Disputes

Refunds complicate reconciliation significantly, as they often involve multiple currencies and different timing. Fetch Order Tracking specifically helps here by surfacing refund data:

eBay Refunds (GBP)

• Full Refund: If a buyer receives a full refund, your original eBay payout is reversed, and you may lose some or all of the eBay/PayPal fees. Record the exact amount refunded in GBP.
• Partial Refund: Record the specific partial amount refunded in GBP.
• Impact on Profit: Subtract the refund amount from the Gross Profit for that order.

AliExpress Refunds (USD)

Fetch Order Tracking will show you gmt_refund, order_status, logistics_status, and end_reason for AliExpress orders. This allows you to track specific refund scenarios like BUYER_ACCEPT_GOODS (buyer received goods, but still got a refund for quality issues) or FINISH (refund completed).

• Tracking Refunds: Monitor the gmt_refund field. When an AliExpress refund is processed, you'll receive funds back in USD.
• Converting AliExpress Refunds: Convert the refunded USD amount to GBP using the exchange rate at the time the refund was received.
• Adjusting Profit: Add this converted GBP refund amount back to your Gross Profit for that order.

Example Scenario: Defective Item

1. eBay sale: £20.00 (Net Payout £18.50 after fees).
2. AliExpress purchase: $10.00 (at 1.25 USD/GBP, cost is £8.00).
3. Initial Gross Profit: £18.50 - £8.00 = £10.50.
4. Buyer reports defect. You issue eBay partial refund of £5.00.
5. You open dispute on AliExpress. Supplier refunds $3.00 (at 1.28 USD/GBP, refund is £2.34).
6. Adjusted Gross Profit: £10.50 - £5.00 (eBay refund) + £2.34 (AliExpress refund) = £7.84.

Automating with Fetch Order Tracking and Google Sheets

Manually tracking these details for hundreds or thousands of orders is unsustainable. Fetch Order Tracking automatically pulls critical data into Google Sheets, making reconciliation far more manageable:

1. eBay Data: You'll have the net payout amount in GBP, along with fees.
2. AliExpress Data: You'll get the original purchase price in USD. Crucially, Fetch also provides gmt_create for the order and gmt_refund for any refunds.
3. Currency Exchange Integration: In your Google Sheet, you can use functions like GOOGLEFINANCE or integrate with a dedicated exchange rate API (e.g., Fixer.io, Open Exchange Rates) to pull historical exchange rates based on the gmt_create or gmt_refund timestamps.
4. Refund Detection: Fetch's refund detection simplifies identifying which AliExpress orders have been refunded, allowing you to accurately adjust your costs and profits.

By bringing all this data into a single sheet, you can create calculated columns for:

• AliExpress_Cost_GBP (AliExpress_Cost_USD / Exchange_Rate_at_Purchase)
• AliExpress_Refund_GBP (AliExpress_Refund_USD / Exchange_Rate_at_Refund)
• Net_Profit_GBP (eBay_Net_Payout_GBP - AliExpress_Cost_GBP + AliExpress_Refund_GBP - eBay_Refund_GBP)

This robust system allows you to accurately assess profitability despite currency differences and the complexities of refunds. Understanding your actual profit per order is fundamental to scaling your dropshipping operation sustainably.

For more details on automating your tracking and reconciliation, visit Fetch Order Tracking.

---