Is there a formula that exists...
 

I work in accounts recievables. Some of the checks that I recieve are
$200,000.00, with hundereds of invoices referenced. People never pay
invoices in line or by date, which make it very time consuming to post cash.

I was wondering if you can take a persons account with all the open
invoices which could total $446,98.00, and take there check which totals
$298,987.89 run a formauls which would find all the invoices that would total
that particular amount? Say if I had $298,897.89, i type that in my formula
and excel would give me all the invoces that would add to that total? I hope
this makes sense? Is there any why of doing this? It would save me a lot of
time and I would greatly appreciate it. Thank you for your time.

Isaac

Is there a formula that exists...
 

Could you post an example of how it would look on a sheet, or how the
data is separated, and we can go from there?

Is there a formula that exists...
 

Your chances of finding the invoices which total the exact amount of the
check are very slim.

If people don't tell you what invoices they are paying, why not just
allocate the payment to the oldest invoices on file?

Regards,
Fred.

"Isaac" wrote in message
...
I work in accounts recievables. Some of the checks that I recieve are
$200,000.00, with hundereds of invoices referenced. People never pay
invoices in line or by date, which make it very time consuming to post
cash.

I was wondering if you can take a persons account with all the open
invoices which could total $446,98.00, and take there check which totals
$298,987.89 run a formauls which would find all the invoices that would
total
that particular amount? Say if I had $298,897.89, i type that in my
formula
and excel would give me all the invoces that would add to that total? I
hope
this makes sense? Is there any why of doing this? It would save me a lot
of
time and I would greatly appreciate it. Thank you for your time.

Isaac

Is there a formula that exists...
 

It's a little too complex for a formula approach, see this link

http://www.mrexcel.com/pc09.shtml

"Fred Smith" wrote:

Your chances of finding the invoices which total the exact amount of the
check are very slim.

If people don't tell you what invoices they are paying, why not just
allocate the payment to the oldest invoices on file?

Regards,
Fred.

"Isaac" wrote in message
...
I work in accounts recievables. Some of the checks that I recieve are
$200,000.00, with hundereds of invoices referenced. People never pay
invoices in line or by date, which make it very time consuming to post
cash.

I was wondering if you can take a persons account with all the open
invoices which could total $446,98.00, and take there check which totals
$298,987.89 run a formauls which would find all the invoices that would
total
that particular amount? Say if I had $298,897.89, i type that in my
formula
and excel would give me all the invoces that would add to that total? I
hope
this makes sense? Is there any why of doing this? It would save me a lot
of
time and I would greatly appreciate it. Thank you for your time.

Isaac