Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI'll share insights about the download transactions from PayPal to QuickBooks, @kogexx.
When you download your bank transactions to QuickBooks, it depends on the information provided by your financial institution. After that, ensure that the data is in the correct format, and you can upload CSVs with either the following 3-column or 4-column format. These are the only columns that QuickBooks can handle, and they must be in this order.
Also, QuickBooks automatically downloads the latest transactions and suggests categories/payees for these transactions based on how you categorized similar transactions. The more data you've downloaded, the better it gets at defining the categories and payees.
I've also added these great resources you can use how to check the format of the CSV file and fix common errors:
Additionally, I've got you this helpful article for the steps that'll help review your transactions after uploading them: Categorize and match online bank transactions in QuickBooks Online.
I'm always here to help if you have any other concerns with downloaded transactions or questions with QuickBooks. Just tag my name in the comment section and I'll get back to you as soon as I can.
Thanks, this is a description of the banking download procedure but does not reflect the Paypal download, which attempts to download sales information. My questions are not answered.
Thanks for the additional details, kogexx. Allow me to provide detailed information to answer your questions about how the system categorizes PayPal transactions.
The way the system assigns categories is dependent on the level of detail provided by the integration itself. It utilizes the information passed from PayPal to determine appropriate categories.
In situations where a customer name is blank, QBO defaults to assigning the payee as either "PayPal Customer" or "PayPal Sales Item." This allows for consistent categorization even when customer specifics are lacking from the original payment facilitated via PayPal. Please note that the system specifically pulls up data from the Customer field, and not from the Description section.
For products or services, QBO will match the item name to an existing product/service set up within your account. If a name match is found, the PayPal transaction will automatically map to the matched item in QuickBooks.
However, if no product or service name is the same, the line item will be categorized under a default item called "PayPal Sales." In these non-matched cases, the item name provided by PayPal will also be added to the line description for reference.
In summary:
Let me share these articles for more details and guidance when downloading transactions from PayPal:
Don't hesitate to reply to us again if you still have additional questions on this matter, kogexx. Our goal is to make sure all your questions are fully addressed, so please reach back out if there is anything else needed on this topic.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here