Question

Matching transactions from 6+ months ago

Forum|Forum|2 years ago
March 19, 2024
11 replies
149 views

I have two separate bank accounts in my client's QB - PayPal and a normal banking account. The bank account funds the PayPal account via bank transfers and PayPal uses those funds to pay contractors. My question is how do I match 6+ month-old transfers from the bank account to the PayPal account? I was told by the QB support team that anything over 6 months old would not match due to the age of the transaction. If I go into each account and select "transfer" to record the transaction in each bank account, I will see a double entry on my balance sheet thus throwing it off drastically.   Instead of recording double entries and then going back into the balance sheet to correct the error (zeroing out or voiding), is there a better way to go about this and essentially not have to do double the work?

Thanks in advance!

QuickBooks Online

JaeAnnC

Level 6

Welcome to the QuickBooks Community, @Bdonahue. Let me assist you in matching or excluding your bank transaction in QuickBooks Online (QBO) to avoid recording duplicate entries.

If QBO is unable to find a matching transaction from existing records, you can select the Find other matches option to view the list of other possible matches. Here's how:

Go to Transactions and select Bank Transactions.
Click the blue tile of the bank account, then go to the For Review tab.
Select the transaction to expand the view. Then, click the Match radio button to show the list of possible matches.
Set the date range. Select the checkbox of the transaction.
Click Match.

If it's not showing, you can exclude the transaction so it won't show as a duplicate in your books.

Moreover, we recommend reconciling your accounts monthly to ensure your bank transactions match those on your bank statements.

Feel free to reach out to us whenever you have further questions about matching bank transactions. We're always here to assist. Stay safe, and have a great day ahead.

B

BdonahueAuthor

Thank you for the reply!

Is there any way to bypass this 6-month rule? I'm still having this issue even on some transactions that are not 6 months old. Additionally, when I search for potential matches the system will bring up "potential" matches that are almost a year old and nowhere near the same dollar amount.

It just doesn't make sense as to why QB wouldn't allow for matches to be over 6 months old yet they will attempt to match transactions that are even older and have no correlation whatsoever.

Thanks!

A

AdonL

QuickBooks Team

Thanks for getting back on the thread, Bdonahue.Allow me to provide additional insights about matching transactions in QuickBooks Online.

If you have manually entered transfers in QBO, be sure to match them with your downloaded transactions. Categorizing them as transfers can lead to duplicates.

Furthermore, QBO does not enforce a 6-month rule for categorizing transactions. You can choose the date range within the system when searching for a match. If the transaction is not visible, you can exclude it to prevent a duplicate in your records.

We also suggest that you reconcile your accounts on a monthly basis to verify that your bank transactions align with those on your bank statements.

Finally, I'm adding these articles as guides if you encounter reconciliation issues in QBO:

Please let me know if you have further questions about managing your bank transactions. I'm always here to help. Have a great day ahead.

J

JoeAmmo

New Member

I have a similar issue of not being able to match a transaction that is over 6 months old. For Example, I have a check that just cleared the bank after a year. The check is unmatched and unreconciled, the check number, amount and date are all correct. The transaction will not match even when selecting the “find more matches” button and changing the date filter to the appropriate dates. I dont understand why, even after changing the date filter the check no longer shows as availible for a match or any older checks dont show. Is there a work around for my issue?

EduardA

QuickBooks Team

Clicking Match may only find suggested matches. However, clearing the date filter on the Find other matches page should allow you to find the appropriate match as long as the transaction date matches and the amount of the downloaded transaction is slightly greater than or equal to the amount of the recorded transaction.

Additionally, ensure that both transactions (the downloaded one and the one you recorded) appear in the same account for successful matching.

If you have any further concerns, feel free to leave a comment.

Sign up

Login with SSO

Let's get you signed in

Login with SSO