I'd love to know what I don't know about Etsy charges
June 12, 2020 3:02 PM Subscribe
Help me understand my Etsy fees / payment discrepancies.
I'm sure I'm missing something simple here, but I can't for the life of me figure it out. I've opened a moderately successful Etsy shop recently. By my calculations I should have netted $7,966.39 but my deposits total $7444.35. I'm not sure what to look at to find the discrepancy.
For simplicity's sake: I opened my shop in 2020. Any reports I'm referencing here are being run for 2020 in its entirety. I'm generating all reports from my Etsy Shop Manager -> Settings -> Options -> Download Data tab.
I have not had any sales in the last week and the most recent payment has hit my bank account, so it's not a matter of outstanding payments. If I run Etsy Payments Deposits report I can reconcile to the penny the deposits they have made to what my bank has received. This amount is $7444.35.
I ran the Orders report (which generates EtsySoldOrders2020.csv) and got the following:
column Q, Order Value: $8295.00
column V, Shipping: $648.28
column X, Order Total: $9145.52
column Z, Card Processing: $328.61
Column AA, Order Net: $8614.67
If I run the Etsy Payments Sales report (which generates EtsyDirectCheckoutPayments2020.csv) and run some totals on the columns there I come up with the same $8614.67 in column J, Posted Net.
Now I know that Order Net or Posted Net is what in theory I got paid, but I also purchased my postage through Etsy, so I deduct the postage amount to get a new total of $7966.39.
As mentioned, deposits total $7444.35 so that's a difference of $522.04.
Am I misunderstanding something? I feel like I can't use these reports to get a clear accounting of my fees. What else am I missing? I know they charge me $0.20 per listing or whatever, but I've only had 269 sales so that only accounts for around $50, and I got the impression that if I listed one single item with a quantity of 100 then they'd only charge me $0.20 once for a single listing.
I'm sure I'm missing something simple here, but I can't for the life of me figure it out. I've opened a moderately successful Etsy shop recently. By my calculations I should have netted $7,966.39 but my deposits total $7444.35. I'm not sure what to look at to find the discrepancy.
For simplicity's sake: I opened my shop in 2020. Any reports I'm referencing here are being run for 2020 in its entirety. I'm generating all reports from my Etsy Shop Manager -> Settings -> Options -> Download Data tab.
I have not had any sales in the last week and the most recent payment has hit my bank account, so it's not a matter of outstanding payments. If I run Etsy Payments Deposits report I can reconcile to the penny the deposits they have made to what my bank has received. This amount is $7444.35.
I ran the Orders report (which generates EtsySoldOrders2020.csv) and got the following:
column Q, Order Value: $8295.00
column V, Shipping: $648.28
column X, Order Total: $9145.52
column Z, Card Processing: $328.61
Column AA, Order Net: $8614.67
If I run the Etsy Payments Sales report (which generates EtsyDirectCheckoutPayments2020.csv) and run some totals on the columns there I come up with the same $8614.67 in column J, Posted Net.
Now I know that Order Net or Posted Net is what in theory I got paid, but I also purchased my postage through Etsy, so I deduct the postage amount to get a new total of $7966.39.
As mentioned, deposits total $7444.35 so that's a difference of $522.04.
Am I misunderstanding something? I feel like I can't use these reports to get a clear accounting of my fees. What else am I missing? I know they charge me $0.20 per listing or whatever, but I've only had 269 sales so that only accounts for around $50, and I got the impression that if I listed one single item with a quantity of 100 then they'd only charge me $0.20 once for a single listing.
This thread is closed to new comments.
posted by belladonna at 5:34 PM on June 12, 2020