I have been filing all my invoices by cheque number. I now need to prepare (for our friends at the Inland Revenue) a list of my administation costs (as reported using Income tax detail) together with copies of the supporting documents.
I have been unable to find a way of identifying the cheque used to pay a bill other than looking at the bill Payments (cheques ) for each supplier and searching for the relevant invoice.
Does anyone know if I can modify, say the Supplier Quickreport so as to group related bills and payments?
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.
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.
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here.
All logos and trade names are the property of their respective owners.