Can someone please help me clear up duplicate and misapplied bill payment matches in the bank register? The "duplicates" are tied to bill amts.

Hi Mark,

I'm here to ensure the bill payments match the correct bills.

Since the payments are tied to the incorrect bills, we'll have to exclude and delete all the matched bills, and then delete the duplicates first. From there, we can match the bills manually. You can follow the steps below.

Before deleting the transactions, you may refer to your bank statement to ensure they are valid duplicates.

Here's how to exclude and delete the transactions:

1. From the Banking tab, select Banking.
2. Select the tile of the bank account in question.
3. Go to the Categorized tab.
4. Select the transactions.
5. Click Undo. ( The transactions will move to the For review tab)
6. On the For review tab, tick the duplicate transactions.
7. Select Exclude.
8. Go to the Excluded section, then select the same transactions.
9. Click Delete.

Then, you can follow the steps laid out below to match the entries manually:

1. On the Banking page, go to the For review tab.
2. Click the transaction.
3. Click the Find match button, and then select its corresponding transaction.
4. Select Save.

I've also added this article as your guide in making sure your accounts match your bank and credit card statements: Reconcile an account in QuickBooks Online.

I'm always around if you have other concerns in managing your bank transactions.

How can I adjust the bill payment amounts to match the payments recorded on the bank account?  Situation #1)  The total of three bills equals $22,265.37.  The total of the one payment is $22,175.37.  What do I do to adjust for the $90 difference (shortage) in payment?  Situation 2 & 3) The total of two bills equals $11,264.21.  The person making the payment from the bank repeated the $15,902.69 amount from another set of bills.  This resulted in a $4,638.48 overpayment.  The next bill was for $12,832.25 and only $8,243.77 was paid (shortage) because of the previous $4,638.48 overpayment.  Can I make some sort of entry to reconcile the bill payments with the actual amount paid at these two different dates?  Where does this entry need to be made, so that the bill payment matches the amount paid?

Let's ensure that bill payments are accurately documented within QuickBooks Online (QBO), Mark.

Within QBO, you have the option to input the complete bill amount and enter bill payments for both transactions. Moreover, if you prefer not to settle the $90 discrepancy, you can address it through a journal entry.

When offsetting accounts payable or vendor balances, the "Credit" account type is often expense or liability. It's essential to consult an accountant for further guidance and to choose the correct account.

Here's how:

1. Go to the +New button.
2. Under Other, select Journal Entry.
   
3. Enter the Journal date.
4. On the first line, select the expense or liability account affected by the bill from the drop-down arrow in the Account column.
5. Put the amount in the Credits column.
6. Key in the reason for this journal entry in the Description field
7. In the second line, select Accounts Payable (A/P) from the Accounts drop-down arrow. The amount should be automatically entered in the Debit column.
8. Choose your vendor from the Name drop-down arrow.
9. Hit Save and close.
   

You can check this article for more information: Resolve accounts receivable or accounts payable balances on a cash basis balance sheet in QuickBooks....

Let me know if there's anything you want to ask about matching bill payments in QuickBooks. I'm always around to help. Take care!