| Author |
Message |
Mike Scholl
Guest
|
 Posted:
Tue Oct 18, 2005 11:44 am Post subject:
Finding cheque used to pay supplier bill |
|
|
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?
Mike
|
|
| Back to top |
|
 |
Golden California Girls
Guest
|
| Posted:
Tue Oct 18, 2005 4:02 pm Post subject:
Re: Finding cheque used to pay supplier bill |
|
|
Mike Scholl wrote:
| Quote: | I have been filing all my invoices by cheque number.
|
Sounds like a good reason for a visit.
| Quote: | 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.
|
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.
| Quote: |
Does anyone know if I can modify, say the Supplier Quickreport so as to
group related bills and payments?
Mike
|
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? |
|
| Back to top |
|
|
Mike Scholl
Guest
|
| Posted:
Tue Oct 18, 2005 4:26 pm Post subject:
Re: Finding cheque used to pay supplier bill |
|
|
| Quote: | 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.
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
|
|
| Back to top |
|
|
Mike Scholl
Guest
|
| Posted:
Tue Oct 18, 2005 7:52 pm Post subject:
Re: Finding cheque used to pay supplier bill |
|
|
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 |
|
| Back to top |
|
|
Leo Navoichick
Guest
|
| Posted:
Tue Oct 18, 2005 11:53 pm Post subject:
Re: Finding cheque used to pay supplier bill |
|
|
"Mike Scholl" <MikeScholl@btinternet.com> wrote in message
news:dj2n7p$h8t$1@nwrdmz02.dmz.ncs.ea.ibs-infra.bt.com...
| Quote: | 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?
|
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.
--
Leo |
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in