This isn't the kind of experience we want you to have in updating your PayPal refund transactions in QuickBooks Online (QBO), @pturzo. That's why I'm here to guide you in manually uploading transactions using a CSV file.
There isn't an option to just type in the PayPal transactions so they can match the refund receipts you've already created in QBO. Let's get your CSV file formatted accordingly so you can upload it to the system.
Regardless if you're using either the 3-column or 4-column format, you'll have to make sure the information on the CSV file complies with the following requirements:
- 0's are not allowed anywhere in the file, e.g $0 should be left blank
- $ symbols are not allowed, e.g $234 should be 234
- Commas for thousands are not allowed, e.g 2,111 should be 2111
- Other special characters such as #, %, and & are not allowed.
- Correct any transactions with the amount showing in the description column
- Remove the word “amount" if it appears in the credit or debit column, i.e. credit amount, debit amount
- Correct and standardize the date format to a single format i.e. dd/mm/yyyy
- MAC users must save the file as a Windows CSV file
You can learn more about this by checking out this article: Import transactions using Excel CSV files.
After the file is formatted correctly, upload it to QBO.
Once uploaded, you'll have to review and match them to the existing entries in QuickBooks This way you can keep your financial data accurate. For the step-by-step guide, you can refer to this article: Categorize and match online bank transactions in QuickBooks Online. Then, reconcile your PayPal account to effectively monitor the growth of your business.
Let me know how it goes in the comments below. If you have other banking concerns and inquiries about managing PayPal transactions in QuickBooks, I'm just around to help. Take care always.
