What is your goal?
Goal: I want to automatically get the “You earned” amount (Net Income) from an Etsy order into my Google Sheets. In the Etsy Shop Manager “Earnings” tab, I can see the clear breakdown: Buyer Paid ($98.12), Tax ($9.12), Fees ($21.10), and the final “You earned” ($77.02).
The Problem: I am using the “Etsy - Watch Shop Receipts” module. This module provides fields like Grand Total, Total Tax Cost, and Total VAT Cost, but it does not provide a single field for “You earned” (Net Amount after all Etsy fees and internal taxes).
Data I have in the module:
Grand Total: Amount (e.g., 9812 / Divisor 100 = $98.12)
Total Tax Cost: Amount (e.g., 304 / Divisor 100 = $3.04)
Total VAT Cost: Amount
What I need to know:
Is there a hidden field or another module (like “Get a Shop Receipt”) that returns the actual “You earned” amount as shown in the Etsy dashboard?
If not, what is the exact mathematical formula to calculate it using the available fields to account for all Etsy transaction fees (6.5%), payment processing fees, and taxes collected by Etsy?
How should I handle cases where Etsy collects Sales Tax for US orders, which is included in the Grand Total but never reaches my balance?