Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
June 4, 2020
Question

report of payments made against specific bills

  • June 4, 2020
  • 1 reply
  • 1 view

We receive three bills from our insurance carrier for three policies.  We enter at beginning of year and pay down the balance monthly,  applying payments against all of the policies each month.  Sometimes additional bills are sent during the year so this bill may be added into the payment.   Since the payee receives only one check I cannot do a vendor report to show how much of each check was applied to a given bill.  What I would like is a report that says  (on each date a check was created)  Bill 1 $x,  Bill 2 $y,  Bill 3 z$ etc.   Or a report that says  Bill 1.    Paid  $x on date 1,  $y on date 2.   In other words,  a detailed breakdown of how a given bill was paid off.  Can't seen to find such a report that shows payments against bills.  (I can look at check stubs but this shows me the expense account credited.

 

1 reply

JessT
Moderator
June 5, 2020

Hi there, misokol.

 

Currently, the only way to know how much payments were applied to the bills is to open the check transactions or to see the stubs.

 

In this case, I would recommend running a quick report for the vendor. You can do that by right-clicking the vendor's name and choosing QuickReport. This will show you their list of transactions, which you can export to Excel. Then, you can filter the bills add more columns, where you enter the payment details against them. That can be our workaround a the moment.

 

Let me know if you have additional questions about this.