I'm a small business owner and do my own books. Every month I reconcile my QBO against my bank and paypal statements, and rarely have problems. But the July statement for Paypal has me befuddled. So far Paypal tech support is zero help so I'm hoping someone here can help me brainstorm an out of the box solution.

Okay, starting with June, that balanced and reconciled perfectly. The July statement has a beginning balance of 184.44 and an ending balance of 130.73. I put these into my QBO reconciliation for Paypal which I have set up like a bank account in QBO. Went through the statement checking off every transaction in QBO. I've done this at least 4 times start to finish and had someone else do the same and we are 100% sure we're not missing any transactions. But when they're all checked off, QBO still shows a discrepancy of 39.60.

After re-trying all those times to try to figure out where I missed or duplicated a transaction and not finding anything, I decided to hit my manual calculator against the statement, added up all the payments received (deposits into paypal) and got a total of 1331.42. The statement shows that all of the payments received total up to 1361.31. Which of course isn't a 39.60 discrepancy, but it still indicates something wonky with their math. Their total withdrawals/debits is correct and matches what QBO gives me. So it's just something weird going on with the income transactions.

Since Paypal isn't helping, I thought i'd maybe force a reconciliation somehow, but all the ways I can think to do that will still cause problems and future reconciliation failures. Yes, the beginning and ending balances in QBO match the Paypal statement, despite the fact that QBO says there's a discrepancy.

Ideas, please?

Edited to add: I see I need to add more details, sorry about that. I do not use any transaction import/exports, but do manual data entry of every transaction on a weekly basis. I've double and quadruple checked all of these: beginning balance, ending balance, transaction dates, transactions that match the discrepancy before or after the date range.

I really don't understand how the beginning and ending balances can match the statement but there is still a discrepancy. If I make a fake transaction to clear the discrepancy, then the ending balance will not match. It's completely mystifying.