Skip to main content
J
jacqueline-m-wal
September 10, 2024
Question

Bill and Payment Report

  • September 10, 2024
  • 1 reply
  • 0 views

I have a supplier and I have a large number of bills from this supplier each month.  Some of these bills are paid in full and some are partially paid over a number of instalments.  By practice, I make one payment a month.  When I make the payment, I identify the bills I want to pay and the amount I want to pay against each Bill - either to clear the bill or make a partial payment.

That's all fine and the payment transaction screen shows the total original amount of the bill and the amount that I am paying

My issue is the Bills and Payments report which shows the paid amount and underneath the bills that payment was applied to.   However, the amount shown for the bill is the original invoice amount, not the amount paid off the bill.  So for example I have a payment of 20,000 but the Bill amounts - which are showing the original Bill amount, not the amount applied - could total 150,000

Under any accounting basis, I would expect the Bill amounts shown to total to the Payment amount.

 

I want to use this report to reconcile with my supplier - but I can't get the information without manually going in and checking and writing down each payment and bill one by one

 

Support advice was to contact the feedback team and to date have been unable to provide a work around.  So I reaching out here to see if anyone could provide some help.   Or if this is posted in the wrong forum, could you suggest where best to post this to help me resolve this.   

Many thanks

1 reply

P
payment after leaving
September 10, 2024

Hi jacqueline-m-wal Thanks for reaching out to us here on the Community. When running the Bills and Applied Payments report the original amount of the bills will remain and the payments will be listed separately, as you've discovered. When creating the bills you could enter a bill reference number and then enter the bill reference number in the reference number field of the bill payment/s, this would then assist you in identifying on the report which payments relate to each bill. There is also the option of including the open balance column, which shows the remaining balance due against each bill.

We have submitted your feedback to our developers and hopefully in the future they maybe able to implement in the future a more robust supplier report function. We have also included a link that will enable you to leave direct feedback: https://intuit.me/3VYQIEt 

J
jacqueline-m-walAuthor
September 10, 2024

Hi John

Thanks for responding but it doesn't sort the issue - do you have a work around or any way other than actually opening the payment screen itself to see the amount that I have allocated to each bill?

Because I do use the reference of the bill, I know the bills that the payment is for - but I can't find any way to see how much has been allocated against each bill.  

Including the open balance column on the report isn't helpful, as there are a number of bills which will be paid over multiple instalments - so again I can't see how much was applied.

If you can suggest a work around, that would be great as I am trying to do a reconciliation with my supplier 

Terms & ConditionsAccessibility statement