A one-day gap between the two sides of a bank-to-PayPal transfer is almost always just timing, not an error in either feed. Your bank typically posts the outgoing transfer on the day you sent it, while PayPal's feed posts its side once the funds are actually received and available, which is often the next business day. QuickBooks Online's automatic matching expects both sides to land on the same date (or very close to it), so a routine one-day lag is enough to keep it from suggesting a match on its own.Here's how to match the two sides manually:Go to All apps, then Accounting, then Chart of accounts.Select View register next to the PayPal or checking account holding the transaction you want to adjust.Find the transaction, then select Edit.Change the date to match the other side of the transfer, then select Save and close.Go to Bank transactions, select the For review tab, find the downloaded transaction, then select Match.If you've confirmed the bank feed date itself is wrong rather than just delayed, exclude the downloaded transaction instead of editing your own entry: check the box next to it in the For review tab, then select Exclude. Use the transfer you already created in your books when you reconcile.If matching still doesn't work after adjusting the date, a few other things commonly block it:The transaction is older than 180 days.The dollar amount in QuickBooks doesn't exactly match what cleared the bank.The transaction type doesn't line up, such as QuickBooks expecting a check where the bank shows a card swipe or ACH debit.The transaction was recorded to a different bank account than the one it's showing up in.The downloaded transaction actually represents two or more separate entries in QuickBooks bundled into one deposit or payment.When a payment involves more than two legs, such as funds moving through a temporary PayPal balance before reaching a vendor, with each leg landing on its own account and its own date, matching gets harder, since QuickBooks' automatic and manual matching are both built around two-sided transfers rather than multi-step chains. In that situation, editing one date to align two of the three legs won't necessarily produce a match for the remaining leg, because the search is still comparing amount and date against a single counterpart, not a chain of three. Try Find Match on the outstanding leg with a wider date window than usual, and confirm the amount matches exactly, including any fees PayPal may have subtracted before passing funds along.For the full matching workflow and a complete list of reasons a match might not appear: Categorize and match online bank transactions in QuickBooks Online. For excluding a transaction instead of editing your own entry: Exclude a bank transaction you downloaded into QuickBooks Online.

Solved

Why is a PayPal transfer showing different dates on each side of the bank feed, and how do I match it when QuickBooks Online won't find it automatically?

Forum|Forum|6 years ago
June 2, 2020
7 replies
42 views

No text available

QuickBooks Online

Best answer by katelynner

A one-day gap between the two sides of a bank-to-PayPal transfer is almost always just timing, not an error in either feed. Your bank typically posts the outgoing transfer on the day you sent it, while PayPal's feed posts its side once the funds are actually received and available, which is often the next business day. QuickBooks Online's automatic matching expects both sides to land on the same date (or very close to it), so a routine one-day lag is enough to keep it from suggesting a match on its own.

Here's how to match the two sides manually:

Go to All apps, then Accounting, then Chart of accounts.
Select View register next to the PayPal or checking account holding the transaction you want to adjust.
Find the transaction, then select Edit.
Change the date to match the other side of the transfer, then select Save and close.
Go to Bank transactions, select the For review tab, find the downloaded transaction, then select Match.

If you've confirmed the bank feed date itself is wrong rather than just delayed, exclude the downloaded transaction instead of editing your own entry: check the box next to it in the For review tab, then select Exclude. Use the transfer you already created in your books when you reconcile.

If matching still doesn't work after adjusting the date, a few other things commonly block it:

The transaction is older than 180 days.
The dollar amount in QuickBooks doesn't exactly match what cleared the bank.
The transaction type doesn't line up, such as QuickBooks expecting a check where the bank shows a card swipe or ACH debit.
The transaction was recorded to a different bank account than the one it's showing up in.
The downloaded transaction actually represents two or more separate entries in QuickBooks bundled into one deposit or payment.

When a payment involves more than two legs, such as funds moving through a temporary PayPal balance before reaching a vendor, with each leg landing on its own account and its own date, matching gets harder, since QuickBooks' automatic and manual matching are both built around two-sided transfers rather than multi-step chains. In that situation, editing one date to align two of the three legs won't necessarily produce a match for the remaining leg, because the search is still comparing amount and date against a single counterpart, not a chain of three. Try Find Match on the outstanding leg with a wider date window than usual, and confirm the amount matches exactly, including any fees PayPal may have subtracted before passing funds along.

For the full matching workflow and a complete list of reasons a match might not appear: Categorize and match online bank transactions in QuickBooks Online. For excluding a transaction instead of editing your own entry: Exclude a bank transaction you downloaded into QuickBooks Online.

R

RaymondJayO

QuickBooks Team

I'll share with you the two ways to resolve your banking concern, @skgsc.

QuickBooks Online (QBO) depends on the financial data shared by your bank. With this, I'd first suggest contacting their support team. They can help you confirm why the bank feed dates are one day apart from the transfer you've made to PayPal from checking account.

If you've verified that the bank feed dates are correct, let's manually change the date for the transfer. This way, you'll be able to match your downloaded bank transaction to the entry you've created in QBO. I'll guide you how.

Go to Accounting from the left menu.
Select the PayPal or checking account.
Click View Register from the Action column.
Locate the transaction.
Choose Edit.
Manually change the Date. Use the bank feed date.
Hit Save and close.

The screenshot below shows you the last two steps.

Once done, let's go to the For Review tab. Then, locate the transaction and click Match. For the detailed instructions, check out this article: Categorizing And Matching Bank Transactions.

However, if you've verified that the bank feed dates are incorrect, I'd suggest excluding them. They won't be added to your register to avoid any duplicate entries in QBO. Just use the transfer you've created when reconciling your account. Here's how:

Go back to the For Review tab.
Check the box next to the downloaded transaction.
Click the Batch actions drop-down.
Choose Exclude Selected.

For more information, go through this article: Exclude Expenses From Downloaded Bank Transactions.

Once done, I recommend reconciling your PayPal and checking account monthly. It helps you detect any differences early to ensure the accounts in QBO match your bank statements.

You can always visit this website: Reconcile Workflow. This is a resource hub about starting, fixing any differences, and completing the reconciliation process. Just click the links beside QuickBooks Online.

I'll be right here to help if you have other concerns. Enjoy the rest of your day, @skgsc.

T

TMTLLC

This solution is not working for me.
Overview - When I pay someone using Paypal, from my bank, the chronological steps (as reflected by statement downloads) are as follows:

Paypal transfers the money into the PP Bank account (temp funds)
Paypal Pays the vendor

-Next day-

Checking account transfers money to PP Bank account

In my case, I have a PPBank "Spent" on 7/14/2022, BBBank Transfer from Checking 7/14/2022, and Checking account transfer to 7/15/2022.

I attempted to accept the PPBank transfer from for the 14th, then go into the chart of accounts, to the register, and change the date to the 15th to match the checking account. Even after I do, QBO can't find a match for the uncategorized Checking account Transfer of the same amount, even when I narrow the search to three days before and after the transfer.

Adrian_A

Level 8

Hi TMTLLC,

Let's isolate and fix why the transactions won't match.

There are possible reasons why our system is unable to recognize the match in QuickBooks. These are due to the following:

The transaction is older than 180 days.
The dollar amount in QuickBooks is different than what cleared the bank.
The transaction type is different in QuickBooks than at the bank. QuickBooks wants to match a check with a check and an expense with an ACH or debit/credit card swipe.
The transaction was recorded in a different bank account.
The transaction from the bank is a payment/ deposit of two or more open transactions in QuickBooks.

If everything is correct, let's match the transactions on an incognito window. There are times that an issue like this occurs when QuickBooks encounters unexpected browser-related crashes. Here is a list of keyboard shortcuts to open one:

For Google Chrome: Ctrl + Shift + N
For Mozilla Firefox: Ctrl + Shift + P
For Microsoft Edge: Ctrl + Shift + P
For Safari: ⌘+ Shift + N

If you can match them, you can go back to a regular browser and clear its cache. Piled browser history can be the reason for some issues on the page. You may also switch to a different browser like Google Chrome, Mozilla Firefox, Safari, or Microsoft Edge.

Afterward, you can reconcile the transactions to ensure they match your bank statements.

I want to ensure that you're able to continue working on your QuickBooks. That said, let me know how these steps work on your end. I'll be around to help you.

katelynner

Answer

Community Manager

A one-day gap between the two sides of a bank-to-PayPal transfer is almost always just timing, not an error in either feed. Your bank typically posts the outgoing transfer on the day you sent it, while PayPal's feed posts its side once the funds are actually received and available, which is often the next business day. QuickBooks Online's automatic matching expects both sides to land on the same date (or very close to it), so a routine one-day lag is enough to keep it from suggesting a match on its own.

Here's how to match the two sides manually:

Go to All apps, then Accounting, then Chart of accounts.
Select View register next to the PayPal or checking account holding the transaction you want to adjust.
Find the transaction, then select Edit.
Change the date to match the other side of the transfer, then select Save and close.
Go to Bank transactions, select the For review tab, find the downloaded transaction, then select Match.

If you've confirmed the bank feed date itself is wrong rather than just delayed, exclude the downloaded transaction instead of editing your own entry: check the box next to it in the For review tab, then select Exclude. Use the transfer you already created in your books when you reconcile.

If matching still doesn't work after adjusting the date, a few other things commonly block it:

The transaction is older than 180 days.
The dollar amount in QuickBooks doesn't exactly match what cleared the bank.
The transaction type doesn't line up, such as QuickBooks expecting a check where the bank shows a card swipe or ACH debit.
The transaction was recorded to a different bank account than the one it's showing up in.
The downloaded transaction actually represents two or more separate entries in QuickBooks bundled into one deposit or payment.

When a payment involves more than two legs, such as funds moving through a temporary PayPal balance before reaching a vendor, with each leg landing on its own account and its own date, matching gets harder, since QuickBooks' automatic and manual matching are both built around two-sided transfers rather than multi-step chains. In that situation, editing one date to align two of the three legs won't necessarily produce a match for the remaining leg, because the search is still comparing amount and date against a single counterpart, not a chain of three. Try Find Match on the outstanding leg with a wider date window than usual, and confirm the amount matches exactly, including any fees PayPal may have subtracted before passing funds along.

For the full matching workflow and a complete list of reasons a match might not appear: Categorize and match online bank transactions in QuickBooks Online. For excluding a transaction instead of editing your own entry: Exclude a bank transaction you downloaded into QuickBooks Online.

Sign up

Login with SSO

Let's get you signed in

Login with SSO