Search Q&A
A macro for Excel accountants who receive payments without references
Hello, I have a client who always groups THREE payments and sends me ONE combined payment without any references on the bank statements, and they don't respect any daily or monthly sequence. These pseudo russians keep paying, but last year they forgot 17 payments that took me 4 working days to find for only 907 euros difference. I need a "macro" on EXCEL that will tell microsoft when using "control+F" to seek( X + Y + Z = AMOUNT ) i.e, the amount on the un-detailed bank statement. Are there any young computer boffins out there who can help an old pensioner ? . Serious answers please. RICHARD.
Keep it simple. You remittance advice should list:
- Their opening balance
- All the invoices you have issued
- All payments you have received
- Their current outstanding balance
They should, of course, make 1 payment per invoice, or at least include a reference for each invoice they have paid.
Otherwise, how the hell are you supposed to guess what they think they have paid and what they haven't?
.
You should simply treat each payment received as covering the oldest amount you are currently owed.
.
You could also ask them for a report detailing what they have paid to you - any decent accoutancy system will be able to provide this.
