Xargaar ToolsTurn a PayPal activity download into a monthly summary and a journal.
Drop in your PayPal Activity Download CSV files. See each month and currency split into money in and money out with fees broken out, memo rows kept apart, and the Balance column checked row by row. The pack lets you give each Type an account and gets you a journal CSV per month. Nothing is uploaded.
Tested only on made-up files built from PayPal's documented column names, never on a real PayPal export. The Balance check only compares rows with each other in the same file. It does not check your PayPal account or your bank. Compare the totals with your PayPal statement 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 and currency gets money in, money out, fees (Net minus Gross) and the net movement. Rows whose Balance Impact is Memo are counted but left out of the totals.
PayPal's Type names are shown exactly as written. We do not guess what they mean. In the pack you give each Type an account yourself.
For each row with a Balance, we check it equals the previous balance plus Net, as PayPal documents. Breaks are shown and block the journal until you review them.
Pay once. Work through all your months.
- All months and currencies in your files instead of the first 3.
- A journal CSV per month that passes the checks, with an account for each Type that you choose, and a CSV of every Type.
- One folder that opens in your browser with no internet. Your PayPal data stays on your computer.
Questions
Which report do I use?
The Activity Download report in CSV format (PayPal documentation: docs.paypal.ai/growth/reports/fields-formats). The tool needs the columns Date, Type, Status, Currency, Gross, Fee, Net, Balance Impact and Balance. Balance Impact and Balance are required too, because memo rows and the balance check depend on them. A file without any of these is rejected with a message.
How are rows counted?
Rows with Balance Impact Credit or Debit are counted. Rows marked Memo are left out of the totals and shown as a count. Money in is a row with a Net of zero or more, money out is a negative Net. Fees are Net minus Gross, so the tool works whether PayPal writes the fee as a positive or negative number, as long as its size equals the gap between Gross and Net.
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 PayPal items are booked. The tool makes no tax or accounting claims.
Has it been tested on real PayPal files?
No. It was tested only on made-up files. The date format and number format are whatever your PayPal account uses, so you choose them. Nothing is guessed.
Is anything uploaded?
No. The files are read on your device.