All Collections
Reporting and Accounting
Exporting PayPal Transactions Data
Exporting PayPal Transactions Data

Find everything you need to know about how to access your PayPal transaction export for bookkeeping

Lucia Bayon avatar
Written by Lucia Bayon
Updated over a week ago

If you are using PayPal as a payment method you might need to access your data related to all transactions including payments and refunds for bookkeeping purposes.

Unlike how it works with Stripe, for PayPal your transaction data is only available directly from your PayPal account.

This guide helps you with the process of exporting the data from your PayPal account and matching your PayPal transactions to bookingkit Orders.

Exporting Your PayPal Transactions

When an order is created in bookingkit and paid via PayPal by a customer, PayPal stores all the payment details from bookingkit including the corresponding Order Code. This allow each transaction in PayPal to be linked to an order in bookingkit.

To access the data of your PayPal transactions follow these instructions:

  1. Login to your PayPal account.

  2. Go to Reports.

  3. Click on Activity download.

  4. Select the transaction type, date range, and file format. We recommend you select CSV.

  5. Click on Create Report.

  6. When the report is ready, click on Download.

For more details about the exports available from PayPal, please check their help material.

Matching Transaction IDs with Order Codes

The file exported from PayPal shows all of the transactions within the selected date range and their full details, including the Transaction IDs from PayPal and Order Codes from bookingkit.

The Order Code from bookingkit appears in the "Note" and "Invoice Number" fields of your CSV file.

Important: The Order Code from bookingkit will only appear in the PayPal export for transactions that took place after the 1st of March 2023.

Working with DATEV

In case you use DATEV to manage your accounting and have the PayPal integration activated you will find the Order Codes related to each transaction in DATEV.

To set up PayPal in DATEV, please follow these instructions from their help center.

After the setup of PayPal, the Order Code from bookingkit will appear in the "Belegfeld" field in your "Belege buchen" report.

Important: The Order Code from bookingkit will only appear in DATEV for transactions that took place after the 2nd of March 2023.

Did this answer your question?