BadCop › Integrations › PayPal
Automatic, escalating invoice reminders for PayPal
PayPal exports invoices from the Invoicing page and transactions from Activity > Statements. Payment matching works best on the transactions CSV.
1. Export your invoices
In PayPal, find the invoice list or the invoice report and export it as CSV (menu names move between versions; look for Export or Download). You need, at minimum, the invoice number, the customer name and email, the amount, and the issue date. Include the due date and status if the export offers them.
2. Map the columns
| BadCop column | From the PayPal export |
|---|---|
invoice_id | Invoice number / ID |
client_name | Customer / Client name |
client_email | Customer email (add a column if the export lacks it) |
amount | Total or Amount due, excluding any fees |
issued_date | Invoice date, as YYYY-MM-DD |
due_date | Due date, or leave blank to use your net terms |
status | open for unpaid / sent / overdue, paid for paid, void for cancelled |
Rename the headers in a spreadsheet and save as invoices.csv. BadCop validates every row and tells you the line number of anything it cannot read.
3. Run the ladder
badcop init
# replace invoices.csv with your export, edit badcop.toml
badcop run --dry-run --verbose # read every email first
badcop run # schedule this daily4. Close invoices when the money lands
Export payments or bank transactions (from PayPal or from your bank) and run badcop match payments.csv --apply. Amounts are matched to open invoices; the matched ones are marked paid and their reminders stop. Ambiguous lines are listed for you.
PayPal is a trademark of its owner. BadCop is an independent open-source project and is not affiliated with it.