Converting PayPal CSV

CSV files from PayPal should be mapped automatically by default. Please send the file you are trying to convert (you can leave the header and few lines from the file, the whole file is not required).

PayPal files usually have a net amount, gross and fee amounts, and when QIF and IIF formats support splits, QBO/QFX/OFX/MT940 files do not support splits. can create separate transactions for gross and fee amounts, which is what usually users are looking for.

If you have a manual mapping applied, select [auto]. You should see split1 (gross), split2 (fee) columns filled. For non-zero fees and output formats not supporting splits (OFX, QFX, QBO, MT940) the app will create a separate transaction on the QBO/OFX/QFX file, which you can assign to a separate expense account in Quickbooks/Xero/Quicken.

INTU.BID value for QBO files (PayPal bank is not listed)

Quickbooks imports QBO files into a PayPal account, but INTU.BID for PayPal is not listed. Use any other allowed INTU.BID value for the QBO file and import into a PayPal Account.

Paypal transactions can be imported:

  • in Quickbooks as a QBO file with INTU.BID value set for another bank label with splits transactions as separate transactions for each split

Import the QBO file into Quickbooks and select the existing PayPal account during import. Once the QBO file is imported, go to Bank Feeds Center and review transactions under the bank label bank chosen for INTU.BID value and add transactions to the PayPal account register.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us