Does this change anything on my eBay account?

No. It only reads your payout and transaction history. It never edits listings, orders, prices, or money.

What ends up in each row?

Each row holds one record with its date, type (payout, sale, fee, or refund), order or payout reference, gross amount, fees, net amount, and currency.

How often does it run?

By default every Monday at 7am, covering the previous week. You can change it to run daily, monthly, or on any schedule you prefer.

Will it create duplicate rows?

Each run adds the records for its date range, so keep the schedule and the date range aligned (one week per weekly run) to avoid overlapping entries.

Does it work for sellers outside the US?

It is designed for US-based sellers. EU and UK sellers can use it too, but eBay requires an extra security verification to access financial data in those regions.

eBay to Google Sheets Bookkeeping Export (Runs Weekly)

Every Monday at 7:00am, on a weekly cron schedule, export the prior week's eBay finances into my Google Sheets bookkeeping tab. This is a deterministic bookkeeping export: one row per record, a fixed field mapping, and no summarization or interpretation, so my accountant always has a clean weekly reconciliation feed.

First, compute the date range for the prior week (the previous Monday through Sunday, ending just before this run). Use that same date range for every eBay call below.

Call eBay Get Payouts (Finances API) for payouts that settled within that date range. Treat each payout as one record.

Call eBay Get Transactions (Finances API) for the underlying activity in the same date range: the individual sales, fees, and refunds. Treat each transaction as one record.

For every payout and every transaction, write one row to the Google Sheets bookkeeping tab using Google Sheets Append Values. Each row must contain, in a fixed column order: the date (the payout settlement date for payouts, the transaction date for transactions), the record type (for example payout, sale, fee, or refund), the order or payout reference, the gross amount, the fees, the net amount, and the currency. Append the payout rows and the transaction rows so the tab grows by exactly one row per record. Do not merge, net, or summarize records, and do not interpret the data.

Frame this for a US-marketplace seller: target the US marketplace (EBAY_US) on the eBay calls. Note that the eBay Finances API is hosted on apiz.ebay.com, and that due to EU and UK payments regulations an additional Digital Signature security verification is required for all Finances API methods made on behalf of EU or UK sellers. If this seller operates in the EU or UK, that verification must be configured for the Get Payouts and Get Transactions calls to succeed.

What it does

Runs automatically every Monday morning and pulls in last week's eBay money movements.
Logs each payout that settled during the week alongside the individual sales, fees, and refunds behind it.
Writes one row per record to your Google Sheets bookkeeping tab with the date, type, order reference, gross amount, fees, net amount, and currency.
Gives your accountant a consistent, ready-to-reconcile feed with no manual copying or interpretation.

What you’ll need

An eBay seller account with payouts enabled
A Google account with a Google Sheets spreadsheet for bookkeeping
A dedicated tab (with column headers) where the weekly rows should be added
This is set up for US-based eBay sellers; sellers in the EU or UK may need an extra eBay security verification to access financial data

How to customize it

Change the day and time it runs, for example the first business day of each month instead of every Monday.
Point it at a different spreadsheet or tab, or reorder the columns to match your accountant's template.
Adjust the date range it covers, for example switching from last week to last month.

Use cases

Data Sync

Weekly eBay payouts and fees export to Google Sheets

Integrations

Type

Categories

What it does

What you’ll need

How to customize it

Use cases

FAQs

Related prompts