Log Etsy Fees and Deposits to Google Sheets

4 min setup

No coding required

Runs automatically

An Etsy order total isn't what lands in your bank: listing fees, transaction fees, processing fees and ad spend come out first. This workflow runs every month, pulls the entries from your Etsy payment account ledger, and writes each one to a Google Sheet with its date, type, amount and running balance, so your bookkeeping sheet shows real profit next to sales.

Use this template → Related article

Run on the first day of each month

Etsy lists last month's ledger entries

Go through the entries one at a time

Google Sheets logs each fee, sale and deposit

How it works

4 steps to see every Etsy fee and deposit in your bookkeeping sheet

App connector: Schedule • Time to complete: 1 minute

Run monthly, on the 1st, covering the previous calendar month.

App connector: Etsy • Time to complete: 1 minute

Fetch the shop's payment account ledger entries created between the first and last day of the previous month, paging until every entry is returned.

App connector: Loop • Time to complete: 1 minute

Go through each ledger entry.

App connector: Google Sheets • Time to complete: 1 minute

Add a row with the entry date, entry type or description, amount, currency, running balance and the related receipt or reference ID when there is one.

Trusted by 1,000+ merchants

Ready to see every Etsy fee and deposit in your bookkeeping sheet

Get setup in 4 minutes.

Use this template →

FAQs

Is this the same as Etsy's monthly statement?

It reads the same payment account activity, but row by row in your own sheet, so you can total fees by type, match deposits to your bank and keep years of history in one place.

Can I combine this with my Etsy sales spreadsheet?

Yes. Keep ledger entries on their own tab next to the order log, then use a SUMIF on each month to put sales, fees and net payout side by side.

Does this replace an accountant or accounting software?

No. It gives you a clean, complete record of Etsy activity to hand to your accountant or import into your accounting tool.

Personalize this template

Customize this workflow even further:

Run weekly instead

Change the schedule to weekly and the date range to the past 7 days if you reconcile deposits more often.

Email a monthly fee total

Add a Sum step over the fee entries and an Email step that sends the month's total fees to you or your bookkeeper.

"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."

PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

Rothy's

see every Etsy fee and deposit in your bookkeeping sheet

4 min setup • Fully supported if you need help