Transfer problem

Hello @themadstans,

Check the transaction in the Bank feed & PayPal feed.
Somehow you categorize the PayPal statement line of this transfer.
Undo that & match that with the Bank statement line.

For further assistance, check my bio. I am a professional bookkeeper.

Thanks.

Why would you exclude a transaction? Yiu need to show the movement of funds from current bank account to PayPal surely?

Let me share more information on why we need to exclude a transaction, @SRK2024.

When you transfer a payment from PayPal to the bank, the transactions will appear in both accounts since both PayPal and the bank are connected to QuickBooks Online. However, since the transfer is downloaded from the bank, they can't be matched to each other.

As a workaround, if you don't want to exclude the transaction and record the movement of funds. We can categorize the PayPal transaction as an expense, and the transaction in the bank can be categorized as a transfer to PayPal.

Follow these steps:

1. Go to the Bank Transactions.
2. Find and click the transaction.
3. Select Record as transfer.
4. Provide the necessary information.
5. Hit Add.

Moreover, I'm sharing this article to help you reconcile your transactions: Reconcile an account in QuickBooks Online.

Let me know if you still have questions about your bank transactions. Have a great day, and take care always.

I'm curious why these transactions can't be matched.

For example, I have two bank accounts at the same bank.  Both accounts have the transactions imported.  The transactions shows on both registers as we would expect.  I understand the match helps you find existing transactions that have been entered in Quickbooks like invoices, sales receipts, etc.

Couldn't the database query it uses in the background for matches be changed to include other database tables like the transactions of another account?  It's already querying multiple tables (or whatever your equivalent in the database is) so just add another table.  I understand that could open up a potentially huge query, so you could create a quick option set in the overall settings to identify what other accounts you want it to search in for matches.

This is really annoying and unnecessary hiccup, especially considering the recommended solutions aren't common sense for the average user.  I'd bet QB Accountants spend tons of time and adjusting this.  I know I just did on my books because my staff didn't know and they basically double entered every transaction.

Thank you for your feedback about QuickBooks Online (QBO), @PearCityMedia. Allow me to share some information about your transactions.

Transactions from Bank A cannot directly match with bank B because they are recorded oppositely (outgoing vs. incoming). However, if those transactions are from third-party payment processors associated with a bank, the feature to match the received payment from PayPal to the Bank is currently unavailable at this time.

Also, when you transfer your transaction from Bank A to Bank B, and both banks are connected to QBO, you can categorize your Bank A transactions by choosing Transfer and selecting Bank B as the destination account.

Afterward, those transactions were downloaded from Bank B. You can exclude them to avoid duplication.

For future reference, read through this article: Reconcile an account in QuickBooks Online. This helps you balance your books in QBO to make sure they match with your actual bank and credit card statements.

Please don't hesitate to post any follow-up questions or new inquiries about your transactions in QBO. The entire QuickBooks Team is here to help and ensure a smooth online banking experience in the program.

Again - that work around completely misses the point of accounting software and also misses the actual problem going on.

Right now, as I'm working on it, sometimes it pairs the transactions automatically, sometimes you can hit match and go find it.  In neither of these situations do the transactions need to be excluded. So, it absolutely can be matched; however, the system is just not consistent in its ability to handle that type of transaction.  How am I supposed to develop a system and/or train staff if the software doesn't handle it the same way each time?

Obviously, the best case scenario is not to have to exclude any transactions from an imported transaction feed.  This is an issue around how the query hits the database to find matches and absolutely should be fixed.

Attached is a screenshot showing the system handling identical transactions differently.  That's the unacceptable part, especially when you click on match it can be found.

In this attached screen shot, you can see that it did find a transfer in the match function.  Again, its the inconsistency in its ability to find things that is the problem.

Please explain why this happens and what will be done to prevent it other than a blanket, manual work around.

We can only imagine the amount of time and effort you've invested in resolving this issue, and we want you to know that this isn't the kind of experience we want you to have, PearlCityMedia.

We appreciate you for providing us with a screenshot to isolate the issue better. QuickBooks Online (QBO) automatically identifies transfers between two of your connected bank accounts (including credit card accounts) to look for matches in transfer amounts and dates. To learn more about matching downloaded bank entries, you can check out this article: Match online bank transactions in QuickBooks Online.

Since there's inconsistency in finding matches in transfer transactions, we recommend reaching out to our Customer Care Support Team. They'll look into your account in a safe environment and find the root cause of this issue. Here's how:

1. From the Search tab, click Contact Us.
2. Enter your question and hit Continue.
3. Choose a way to connect with us either Have us call you or Chat with us.

Moreover, refer to this article to help you reconcile your transactions to match your bank and credit card statements: Reconcile an account in QuickBooks Online.

If you have any further questions about matching bank transactions or any Bank feed concerns, add them to the thread. We'll be here to help. Take care always.