Skip to main content
K
kogexx
February 15, 2024
Question

How does QB define the Description and Payee (should of course be Payer) columns in the Paypal downlaod?

  • February 15, 2024
  • 1 reply
  • 0 views
Description is the Payer name in the Paypal data set.  Payee appears sometimes to be the Customer Name in the QB data set that QB can match to, but sometimes it is just random and sometimes it is blank when the Customer name is actually identical with the Payer.  Also, I assume that the QB Category column will have usable data in it if our Product names match the Paypal Item name?  Thanks.

1 reply

JoesemM
JoesemM
February 15, 2024

I'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.

K
kogexxAuthor
February 19, 2024

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.

JenoP
JenoP
February 19, 2024

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:

 

  • Matched Item Name: Maps PayPal purchase to existing matched QBO product/service
  • Unmatched Item Name: Categorizes to default "PayPal Sales" item, while updating line description with PayPal's reported item name

 

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.

Terms & ConditionsAccessibility statement