Matching Payment Receipts in QBO

Emlyn · ‎September 24, 2021

When searching by date for a transaction to match a receipt by, in the date box I type the date and it says Invalid Date. Why is this? and It won't find the transaction I want to match it with.

RCV · ‎September 24, 2021

Let me help you with the missing bank transactions, Emlyn.

We'll have to get transactions from your bank or credit cards and manually import them into QuickBooks Online. This helps us download your bank transactions from April. Here's how:

Go to the Banking menu and select the Banking tab.
Tap the blue tile for the account you want to upload the transactions into.
Click the Link account dropdown and then Upload from file.
Hit Browse and then select the file you downloaded from your bank. Then Next.
In the QuickBooks account dropdown, choose the account you want to upload the transactions into. Then Next.
Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Next.
Select the transactions you would like to import. Then select Next.
Hi Yes.
When you're ready, press Let's go.

Then, follow the next steps in the Manually upload transactions into QuickBooks Online article. Once done, review and categorise all of your downloaded transactions. Go back to Reconcile page and enter the previous ending balance and date then the Start reconciling section. The transaction you recreated or added should show on this page for you to tick, and the difference should be 0. For the steps and details, see the Reconcile an account in QuickBooks Online article.

The program automatically generates a reconciliation report every time you finish reconciling. This helps you fix any discrepancies when you reconcile on the following month and when you meet with your accountant. You can check out also the Learn the reconcile workflow in QuickBooks article to guide you anytime you need help doing or fixing a reconciliation.

Feel free to visit our Banking page for more insights about managing your bank feeds and reconciling accounts.

You can always update us after performing the steps as I want to ensure this is resolved for you. Just leave a comment below and I'll get back to you. Take care always.

View solution in original post

Catherine_B · ‎September 24, 2021

I can help you match your sales transactions, Emlyn.

It can be you're unable to find a match due to the transaction is outside of the date range you are searching for or the sales receipt is over 90 days old. You can try opening the transaction you recorded in QuickBooks and check the date you created it. Then, you can go back to the Match transactions page if the transaction is now showing.

After verifying the dates and you still get the same error, we can check if the issue is caused by browser-related issues. First, let's try login and match the transactions using a private browser, here's how:

Google Chrome: Ctrl + Shift + N
Mozilla Firefox: Ctrl + Shift + P
Safari: Command + Option + P

If it works fine, I recommend clearing your regular browser's cache to start fresh. Cache files can cause unexpected behaviors on a program when they are piled up. However, if it's still not working, please switch to another browser.

You can also consider excluding the bank downloaded transaction if you're still unable to do so. Excluding the transaction in the for review section will not affect your figures within QuickBooks and this can also prevent duplicates in case you accidentally add it.

You'll want to check these articles where you can get more information about handling your payments in QuickBooks Online:

We are right here if you need help with QuickBooks. Take care!

Emlyn · ‎September 24, 2021

Ah, I think I may have caused the problem by not updating the bank feed after the 90 days and the connection I had would no longer update. I have created another bank feed connection. I have found that I now have some missing transactions from april that were already reconciled. I'm in a mess!

RCV · ‎September 24, 2021

Let me help you with the missing bank transactions, Emlyn.

We'll have to get transactions from your bank or credit cards and manually import them into QuickBooks Online. This helps us download your bank transactions from April. Here's how:

Go to the Banking menu and select the Banking tab.
Tap the blue tile for the account you want to upload the transactions into.
Click the Link account dropdown and then Upload from file.
Hit Browse and then select the file you downloaded from your bank. Then Next.
In the QuickBooks account dropdown, choose the account you want to upload the transactions into. Then Next.
Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Next.
Select the transactions you would like to import. Then select Next.
Hi Yes.
When you're ready, press Let's go.

Then, follow the next steps in the Manually upload transactions into QuickBooks Online article. Once done, review and categorise all of your downloaded transactions. Go back to Reconcile page and enter the previous ending balance and date then the Start reconciling section. The transaction you recreated or added should show on this page for you to tick, and the difference should be 0. For the steps and details, see the Reconcile an account in QuickBooks Online article.

The program automatically generates a reconciliation report every time you finish reconciling. This helps you fix any discrepancies when you reconcile on the following month and when you meet with your accountant. You can check out also the Learn the reconcile workflow in QuickBooks article to guide you anytime you need help doing or fixing a reconciliation.

Feel free to visit our Banking page for more insights about managing your bank feeds and reconciling accounts.

You can always update us after performing the steps as I want to ensure this is resolved for you. Just leave a comment below and I'll get back to you. Take care always.

Topics

Training

Community

Resources

Matching Payment Receipts in QBO