Finding cheque used to pay supplier bill

Sounds like a good reason for a visit.

There is something you can use. Run to your office supply store and get a sorting device. Take that pile of invoices (bills) and sort them by name of vendor using the device.

Allan, isn't it so much fun to see someone crash and burn when just a few hours of time with a professional could have prevented it?

sorting device. Take that pile of invoices (bills) and sort them by name of vendor using the device.

It is possible that I would have a little less work to do if I had filed my invoices by supplier. But I'm not sure about that. My Income tax detail report often has several lines in exactly the same order as my cheque numbers, whereas each line would be in a different section of a supplier file.

However it must surely be possible to ask QB the question. Have I paid this bill and if so when did I pay it, what cheque number and has the cheque been cleared. Unless I am missing something QB is only able to say "it's paid - search through your cheques to find which cheque" What I have done, as a workaround, is to export the Suppliers detail into Excel and then add a column for the cheque number. Then I just put in the cheque numbers used to pay all the invoices and used a sumif function to check that the totals agreed to the cheques.

QB's database clearly has a field which links cheques and supplier invoices, so it ought to be possible to put it on a report.

Mike

Not sure if this is what you are after, but try going to the bill in question. In the top of the bill window there is a button called history. Click that and it should bring up the relevant info you are after.

Thanks Leo, it's a solution even if not a perfect one. You also solved another problem for me - how to see what credits were applied to a bill when it was paid. The history button shows that too.

This is possibly not one of QB's strong areas.

Mike