11 February 2021 11:17
Being doing this shit all morning but this one has got me to the point of screen punching, just got number blindness now.
Below are the figures for all outstanding invoices we have with a company, they have made a payment of £2961.13 but I just can’t get the right combination of invoices to match the payment.
Please feel free to embarrass me by doing it in 10 seconds.
Phone 'em up and ask 'em what invoices they think they’ve cleared?
11 February 2021 11:21
That’s not the point of the exercise.
Besides it’s taken a Letter Before Action to get to the payment stage so they are sulking.
Nightmare… Anyway, can’t help, I can only count to 3 and I need all my fingers and toes to do that…
Deposit the cheque, quick, and get it cleared, then worry about. When you have to chase them, get the money in your account, then get them to explain, what they think they have done.
Spent years doing this, for a company I worked for.
There can be no more than 6 invoices - the smallest 7 add up to more than they’ve paid. And there have to be at least 3, since the two largest aren’t enough.
11 February 2021 11:34
It’s already in via BACS just need to allocate it in QuickBooks.
Quick Excel fu says no possible combinations add up to the required amount.
I just took the oldest invoices, and credited the remainder to the next invoice.
11 February 2021 11:36
Thanks, I knew someone would have the skills!
11 February 2021 11:38
This! Excel Solver to the rescue. They just transferred what they fancied
11 February 2021 11:54
They have got plenty but just want to keep it all.
Or the standard inverse relationship between quantity of money and quality of accounting records is there once again.
11 February 2021 12:48
Did they add or subtract tax to it?
11 February 2021 13:42
The figures that I listed are inclusive of VAT, I have emailed them but don’t expect a rapid response.
11 February 2021 13:47
Tell them you couldn’t make head nor tail about the money they sent, so you bought some speakers with it
I’M A POUND OUT