Gross, Fee and Net columns in a PayPal activity CSV
A PayPal activity download can carry three money columns on each row: Gross, Fee and Net. Accounting imports usually want one amount, and sometimes the fee apart. Choose the file below: the page works in your browser, writes gross, fee and net into fixed columns, shows the first 20 cleaned rows and lists every line it left out, with the reason. This is an independent tool, not affiliated with or endorsed by PayPal.
Clean your CSV export
The cleaner detects the delimiter (comma, semicolon or tab), looks for a header row with a date column and an amount column, and writes eight fixed columns, comma-delimited: date, description, amount, currency, fee, net, reference and source. It recognises common header names in English, Spanish, German and French, such as Date, Fecha, Buchungstag, Amount, Importe, Betrag and Montant.
Your file is read in your browser and is never uploaded, stored or logged. It is held in the memory of this tab only, and closing or reloading the page discards it. Operator: Augeo. See the privacy notice.
Exports do not share one layout, and this page makes no promise about yours: the free preview shows what it does to your file.
The cleaning logic is checked by an automated test script that runs the engine file of this site over six synthetic sample files and a set of checks of the parsing rules; it ran in a sandbox before this site was published and finished with no failed check. The script does not open this page in a browser, does not test the licence key step, and nothing was tested against a real export from any provider. Use the free preview to check your own file.
Report
Warnings
Lines not parsed
Lines dropped
Preview of the cleaned rows
| line | date | description | amount | currency | fee | net | reference | source |
|---|
Download the full cleaned file
- Price: 6 USD, paid once on Gumroad. No subscription. You receive a licence key.
- What the key unlocks: the download of every cleaned row of the file you chose, as one CSV named after your file with -cleaned.csv at the end, instead of the first 20 rows on screen. The report and the way files are read stay the same.
- The key is for one buyer. Runs are not counted and no number of runs is promised. The key is kept in the memory of this page only, so you enter it again after closing or reloading the page.
- Refunds are requested through your Gumroad receipt and follow Gumroad's refund policy.
- Try the free preview first. If the preview cannot read your file, the full download cannot either.
Get a licence key on Gumroad for 6 USD
How the Gross, Fee and Net columns are read
- The columns are found by name. The cleaner applies this mapping when the header row has a Date column, a Gross column and at least one of Net and Transaction ID. Names are compared without regard to capitals or punctuation, and in English only.
- Gross becomes the amount column, with the sign it has in the file.
- Fee becomes the fee column, with the sign it has in the file. A fee written as
-1.16stays-1.16; the cleaner does not flip it. - An empty Fee cell becomes 0.00 when the file has a Fee column. When the file has no Fee column, the fee column of the output is left empty.
- Net is copied when the Net cell holds a number. When the Net cell is empty, or the file has no Net column, net is written as amount plus fee, added as exact decimals. With no fee either, net equals the amount.
- Gross plus fee is not compared with Net. When the Net cell holds a number, that number is written as it is, even if it differs from gross plus fee. Check that yourself on the rows that matter to you.
- The three columns share one number format. Thousands separators are removed, so
1,250.00becomes1250.00, and the decimal separator is taken from the values of all three columns together. - A row with an unusable figure is left out and listed. An empty Gross cell gives the reason
amount is empty. A Gross, Fee or Net cell holding text such asN/Agivesamount is not a number,fee is not a numberornet is not a number, with the text found. The row appears under "Lines not parsed" with its line number. - The other columns: Transaction ID becomes the reference, Currency the currency, and Name and Type are joined into the description. Amounts are never converted between currencies; when the file holds more than one, a warning says so.
The report's "Column mapping" line states which column of your file was used for the fee and for the net, or that net is amount plus fee when the file has no Net column. Its "Input layout" line states which mapping was applied to the file.
PayPal lets you choose which fields to download, so exports differ. A download without a Gross column, or with header names in another language, is not read with this mapping.
The output is always the same eight columns (date, description, amount, currency, fee, net, reference and source), comma-delimited. Columns of the download that are not among them, such as a balance or a time, are not carried over.
In a spreadsheet instead: keep the Gross, Fee and Net columns, fill empty Fee cells with 0, and add a column with Gross plus Fee minus Net to see the rows where the three do not agree.
Notices
- Privacy: files are read in your browser and never uploaded, stored or logged. Operator: Augeo.
- Independent tool, not affiliated with or endorsed by Etsy, PayPal, QuickBooks or any bank.
- Check the output before you use it. This is not accounting, tax or financial advice.
- Price of the full download: 6 USD one-time. The key is for one buyer. Refunds are requested through the Gumroad receipt.
- Only upload data you have the right to process. Choosing a file here does not send it anywhere, but you remain responsible for the data in it.
Other pages
- Clean a PayPal activity CSV
- Clean an Etsy sold orders CSV
- Clean an Etsy monthly statement CSV
- Convert decimal commas to decimal points in a CSV
- Fix DD/MM and MM/DD dates in a CSV
- Convert a tab-delimited file to a comma CSV
- Remove total and footer lines from a bank CSV
- Line breaks inside quoted fields of a CSV
- Remove duplicate rows from a CSV export
- Negative amounts in parentheses in a CSV
- Merge debit and credit columns into one amount
- Any other CSV export of transactions