So here's an excellent example of my usual morning routine with Quickbooks.
At the end of each day I log into QBO and run update to pull all of the transactions into it from Paypal (my other accounts don't update automatically any longer thanks to Open Banking not being supported / implemented).
This morning I logged into Paypal and went through my daily ritual of creating and printing out a report for the previous days transactions. I then went through and put the Paypal fee transactions into a spreadsheet ready to import them into Quickbooks. If everything works properly (which is rare these days) the Paypal balance matches exactly the one for the Paypal account in Quickbooks.
This morning there was a discrepancy equal to the value of one of my payments.
So the next step is to go through the Paypal report line by line that I downloaded and printed out to compare the payments from customers until I find the missing one. This is tedious and takes time.
In todays case I had two transactions from the same person but only ONE of those transactions is registered in Quickbooks but because you don't show the Paypal ID number anywhere I have no way of knowing which it is.
As a result I then had to create an entry in my spreadsheet for this missing payment so that I can import it into Quickbooks.
What appears to be happening is that Quickbooks reads the transactions from Paypal and see a duplicate customer name and disregards one payment. That would suggest that it's using a non-unique value (the customer name) as the criteria to determine if a transaction has been imported. What it SHOULD do is look at the Paypal transaction ID which IS unique. This is a fundamental and schoolboy programming error !
