Xargaar Tools
Xargaar ToolsTurn an eBay Transaction report into a monthly summary and a payout check.
Tested only on made-up files, never on a real eBay export. Column names come from eBay's help page for the Transaction report, and the report's columns can be customized, so the tool stops with a message if a needed one is missing. Fees and deductions are worked out as Net amount minus Gross transaction amount. It does not check your eBay account or your bank. Compare the totals with your eBay reports before you rely on them.
Set these to match your files before you drop them. Nothing is guessed. Limits: 20 files, 40 MB each, 200 MB in total, 60,000 rows per file and 300,000 in total.
What it does
Each month gets money in, money out, fees and deductions (Net amount minus Gross transaction amount) and the net movement.
Rows are grouped by Payout ID and their Net amount added up. Type what your bank received and see the difference.
eBay's Type names are shown exactly as written. We do not guess what they mean.
Questions
Which report do I use?
In Seller Hub, open Payments, Reports and the Transaction report, pick a date range and download the CSV (eBay's help: ebay.co.uk/help/selling/fees-credits-invoices/reconciling-ebay-sales-transactions). The tool needs the columns Transaction creation date, Type, Gross transaction amount and Net amount. Payout ID and Payout date are used for the payout table when they are in the file. Payout status is used to leave rows that are still processing or on hold out of that table. Add them in Customise column settings if they are missing.
Why are there settings?
eBay lets you change the report's columns, and number and date styles depend on your account. You tell the tool the currency, the number and date format, how empty amounts are shown, and how many lines come before the header, so nothing is guessed. Files with an Exchange rate other than 1 are stopped, because amounts could be in two currencies.
Does it prove my payout is right?
No. It adds up the rows that carry a Payout ID and shows the difference from the amount you type. Which rows eBay counts into a payout is not checked, so a difference is a reason to look at the rows, not a verdict.
Is the journal entry accounting advice?
No. It is a starting point built from the month's totals and the accounts you type. Your accountant decides how eBay items are booked. The tool makes no tax or accounting claims.
Is anything uploaded?
No. The files are read on your device.