Skip to main content
M
MaryH-Online
June 24, 2024
Question

How do I resolve when a downloaded bank transaction includes an overpayment on a bill?

  • June 24, 2024
  • 1 reply
  • 0 views
Downloaded transaction is for an amt that is greater than the bill. For ex bill is $28, $30 is paid. I want the $2 to show as a credit on the account. When I click on add, I am told the payment does not match the bill, and it will either "correct" the payment to the bill or sometimes to the credit amt when I go to reconcile. I cannot figure out how to resolve this so I can add the actual transaction with the remaining credit left in the supplier acct to apply at a later date. If I try to correct the information when reconciling, the bank transaction will return to the bank transaction table for review. Since this is something that can happen frequently, I want to find a work around that does not just exclude the bank transaction on the download page. I have tried splitting the payment but having two separate A/P lines does not work. 
Thanks, Mary

1 reply

A
Alex M
June 24, 2024

Hi there MaryH-Online,

 

Thanks for reaching out about your supplier overpayment. QuickBooks Online is a great tool able to help you keep track of bills, payments and credits so you know the amount owed to your supplier I can provide some information about entering bill payments.

 

When creating a bill payment manually, you can add the total amount of the payment, and the amount not applied to the bill would remain on the account as a credit to be applied later. To do so, go to the Expenses tab, then Suppliers, click on the supplier in question, then find the bill in question to click on the option to Mark as paid. In the amount Box in the left of the screen, insert the total amount of the payment including the overpayment. Make sure the bill in question is selected in the outstanding transactions, and the amount you want to apply is entered in the Payment column of the row. Don't forget to enter the correct date, and Save. Once created, you can then go back to the Banking tab to match the bank transaction to this payment you've created.

 

if you have any other questions feel free to reach out here.

Terms & ConditionsAccessibility statement