Map one Etsy export type at a time; group amounts and fees, check record IDs and create charts.
Report type
Select the report type and map its columns before calculating. Remove summary rows and overlapping segments first. Amounts use account currency units, never micros. Choose a decimal mark; thousands separators and currency symbols are rejected.
Group by column
orders / items / payments / deposits amount / fees record_id currency
Result
Sums are exact; ratios are truncated to 6 decimal places. Zero denominators stay blank. Invalid rows and repeated selected keys are excluded and listed. Currencies remain separate; row counts are not order counts.
Only accepted records enter this summary. Review exclusions and the calculation rules below.