cancel
Showing results for 
Search instead for 
Did you mean: 
dkjones
Level 2

I paid 3 supplier invoices (same supplier) via ABA file. Bank feeds brought transactions individually. How do I match bank feeds to supplier payment. QB doesn't show bill

 
Solved
Best answer October 05, 2020

Best Answers
Catherine_B
QuickBooks Team

I paid 3 supplier invoices (same supplier) via ABA file. Bank feeds brought transactions individually. How do I match bank feeds to supplier payment. QB doesn't show bill

Hello there, dkjones.

 

You can exclude the bill payment downloaded from your bank feeds since we can't match them to paid bills in QuickBooks Online. This will avoid duplicates in your register.  After that, manually clear them manually created bill payment in QuickBooks. 

 

Let me show you how to exclude the bank downloaded transactions:

  1. Go to the Transactions or Banking menu and click Banking.
  2. Select the bank where the payments downloaded.
  3. Click the three bill payments and select the Exclude button.

You can follow these steps on how to manually clear a transaction.

 

  1. Go to the Gear icon and click Chart of Accounts.
  2. Look for the bank and click View register.
  3. Locate the bill payment and select it.
  4. Under the reconciliation status column indicated with a checkmark, repeatedly select the box until you see a cleared status ( C ).
  5. Click Save

Feel free to read this article for more details: Reconcile an account in QuickBooks Online.

 

The Community is always available 24/7. If there's anything you need help with, just leave a reply below. You take care and stay safe!

View solution in original post

3 Comments 3
BettyJaneB
QuickBooks Team

I paid 3 supplier invoices (same supplier) via ABA file. Bank feeds brought transactions individually. How do I match bank feeds to supplier payment. QB doesn't show bill

I appreciate your time visiting our forum for your supplier payment concern, @dkjones.

 

In QuickBooks Online, you can only match an entry if both transactions are found in the system. Since you mentioned that QuickBooks isn't displaying a bill, I recommend creating a bill. This way, you'll be able to match the supplier's payment to the bill.

 

Here's a link that contains a short clip that will give you details on how to generate a bill in QBO: How to create bills and expense reports in QuickBooks.

 

Once done, you can now start matching your bank transactions with the entries that you made.

 

To do that:

  1. Go to Banking on the left panel, then choose Banking.
  2. In the Banking page, go to the For Review tab.
  3. Select the transaction to expand the view. 
  4. Review the Records found. These transactions are ones you already entered in QuickBooks.
  5. Select the link next to each record to get more details.
  6. You can also check the Find other matches option to find the other possible match of the transaction.
  7. Review the Deposit to field on the forms. Your transaction in QuickBooks is already in the account listed.
  8. When you’re done, select Match.

To give you more insights about categorising and matching your transactions so you can have a smooth reconciliation, please see this link: Categorise and match online bank transactions in QuickBooks Online.

 

I'll be on a lookout for your reply as to how things go in your end. I'm here to assist you further if there's anything else that you need. Have a great weekend!

dkjones
Level 2

I paid 3 supplier invoices (same supplier) via ABA file. Bank feeds brought transactions individually. How do I match bank feeds to supplier payment. QB doesn't show bill

Betty, I have already created the bill in QB. I selected the bill for processing the ABA file. If I add the bills again I will be double claiming the GST and that is illegal.

 

I need to match the bank feed to the payment I created through generation of the ABA file. the problem is QB created one payment but the bank feed come through as 3 separate entries.

Catherine_B
QuickBooks Team

I paid 3 supplier invoices (same supplier) via ABA file. Bank feeds brought transactions individually. How do I match bank feeds to supplier payment. QB doesn't show bill

Hello there, dkjones.

 

You can exclude the bill payment downloaded from your bank feeds since we can't match them to paid bills in QuickBooks Online. This will avoid duplicates in your register.  After that, manually clear them manually created bill payment in QuickBooks. 

 

Let me show you how to exclude the bank downloaded transactions:

  1. Go to the Transactions or Banking menu and click Banking.
  2. Select the bank where the payments downloaded.
  3. Click the three bill payments and select the Exclude button.

You can follow these steps on how to manually clear a transaction.

 

  1. Go to the Gear icon and click Chart of Accounts.
  2. Look for the bank and click View register.
  3. Locate the bill payment and select it.
  4. Under the reconciliation status column indicated with a checkmark, repeatedly select the box until you see a cleared status ( C ).
  5. Click Save

Feel free to read this article for more details: Reconcile an account in QuickBooks Online.

 

The Community is always available 24/7. If there's anything you need help with, just leave a reply below. You take care and stay safe!

View solution in original post