Hi all,
I'm having a massive brain freeze at present and wondering if anyone could help as I'm sure there's an easy solution but for whatever reason I can't get my head around it.
As part of my job, I have to check and sign off client due diligence documents (ID, proof of address & proof of funds).
At present, I use a very simple Excel spreadsheet as a mental checklist which lists all the possible documents and what to check on these, eg: Passport, does the name match? Does the DOB match? Is it certified? And I have tick boxes next to these which changes a value to TRUE, and if in a section I have all TRUE boxes it turns green, very simple but useful as a mental checklist.
Once I've done this and I have a green box in each section for each client I sign it off and don't save the document as it's not needed, it's just used as a mental checklist as a one off.
However, I've now been asked to record this data, mostly so we know what the most common reasons are for not signing off, eg; documents not being certified. I don't want to keep creating sheets every time I do it and want it all on 1 sheet.
My mind has gone blank on how I can do this, even though it sounds really simple.
Can anyone help put me out of my misery.
Thanks in advance.
I'm having a massive brain freeze at present and wondering if anyone could help as I'm sure there's an easy solution but for whatever reason I can't get my head around it.
As part of my job, I have to check and sign off client due diligence documents (ID, proof of address & proof of funds).
At present, I use a very simple Excel spreadsheet as a mental checklist which lists all the possible documents and what to check on these, eg: Passport, does the name match? Does the DOB match? Is it certified? And I have tick boxes next to these which changes a value to TRUE, and if in a section I have all TRUE boxes it turns green, very simple but useful as a mental checklist.
Once I've done this and I have a green box in each section for each client I sign it off and don't save the document as it's not needed, it's just used as a mental checklist as a one off.
However, I've now been asked to record this data, mostly so we know what the most common reasons are for not signing off, eg; documents not being certified. I don't want to keep creating sheets every time I do it and want it all on 1 sheet.
My mind has gone blank on how I can do this, even though it sounds really simple.
Can anyone help put me out of my misery.
Thanks in advance.
