Add a bank transaction and match it to existing journal transaction

ChristineD65 · ‎December 30, 2020

My client uses a third party program for payroll (gusto). There are two payouts for the same amount on the same payday. The transactions for the payees are in QBO and correct, but there is only one transaction in the bank feed to match to them. I think one was not included, as it appears to be a duplicate. (I have verified that BOTH are in the bank account, just not included in the bank feed on QBO)
How do I add another transaction to the bank feed in a way that will allow me to match it to the payroll entries?
I've tried adding it in the register, but then cannot match that entry to anything.
Picture attached showing the single transaction in the bank feed, and the two entries to match the transactions to.

SarahannC · ‎December 31, 2020

Hello there, ChristineD65.

When QuickBooks downloads bank data, it tries to find a match with any QuickBooks transactions already entered. If you agree with the match information shown in the row, click the Match button. This will match with the existing QuickBooks transaction.

You can manually upload the bank transactions using the CSV file to include the transactions that are not included in your bank feed yet. First, download transactions from your bank by logging in to your bank's website. Then, follow the given instructions on how to download transactions and save the file on your desktop or anywhere you can easily find it. Once done, upload them to your book by following these steps:

Sign to your QBO account and select Transactions on the left panel.
Click Link account drop-down arrow.
Select Upload from file. Then, click the file you've saved on your computer.

You can use these articles as additional reference in fixing bank upload errors, categorizing transactions after imported them, and the reconciliation workflow in QBO:

Let me know if you have follow-up questions. I'll be right here to continue to help you. Take care and stay safe always.

View solution in original post

AileneA · ‎December 30, 2020

I'm here to ensure that you'll be able to match your transactions in QuickBooks Online, ChristineD65.

We can perform some troubleshooting steps to see if this is a browser-related issue. Let's start by accessing your account in a private/incognito window. This will help me verify if this is a browser issue. Also, there are times that the browser stores frequently-accessed data, thus causing some errors or unusual behavior.

Let's try logging in to your QuickBooks Online account using a private or a different browser. Here's how:

Google Chrome: press Ctrl + Shift + N
Mozilla Firefox: press Ctrl + Shift + P
Safari: press Command + Shift + N
Microsoft Edge: press Ctrl + Shift + P

Once logged in, and able to match the transactions. You need to clear the cache of the regular browser you're using. You can also do this task on other supported, up-to-date browsers. Clearing the cache will refresh the system, and you'll be able to work with clean trash.

Additionally, you can visit the link below on how to categorize and match transaction for future reference:

Categorize and match online bank transactions in QuickBooks Online.

You can get back to me anytime you have additional questions in QuickBooks by posting your response below. I'll do whatever it takes to ensure your concerns are addressed. Enjoy the rest of your day.

ChristineD65 · ‎December 31, 2020

Thank you for the reply, but no. I can match transactions without an issue. The problem I am having is that the transaction did not, and will not, download. So, there is nothing to match. I need to create the bank feed transaction so that there is something TO match.

SarahannC · ‎December 31, 2020

Hello there, ChristineD65.

When QuickBooks downloads bank data, it tries to find a match with any QuickBooks transactions already entered. If you agree with the match information shown in the row, click the Match button. This will match with the existing QuickBooks transaction.

You can manually upload the bank transactions using the CSV file to include the transactions that are not included in your bank feed yet. First, download transactions from your bank by logging in to your bank's website. Then, follow the given instructions on how to download transactions and save the file on your desktop or anywhere you can easily find it. Once done, upload them to your book by following these steps:

Sign to your QBO account and select Transactions on the left panel.
Click Link account drop-down arrow.
Select Upload from file. Then, click the file you've saved on your computer.

You can use these articles as additional reference in fixing bank upload errors, categorizing transactions after imported them, and the reconciliation workflow in QBO:

Let me know if you have follow-up questions. I'll be right here to continue to help you. Take care and stay safe always.

Topics

Training

Community

Resources

Add a bank transaction and match it to existing journal transaction