Weekly eBay payouts and fees export to Google Sheets
Every Monday, automatically log last week's eBay payouts, sales, fees, and refunds into a Google Sheets tab so your accountant gets a clean reconciliation feed.
eBay
Google SheetsFinanceOperationsData SyncEvery 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.
Additional information
What does this prompt do?
- 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 do I need to use this?
- 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 can I 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.
Frequently asked questions
Does this change anything on my eBay account?
What ends up in each row?
How often does it run?
Will it create duplicate rows?
Does it work for sellers outside the US?
Related templates
Stop hand-copying eBay payouts into your books.
Give your accountant a clean weekly reconciliation feed that builds itself, every Monday.