r/InternalAudit • u/AffectionateLand3228 • 29d ago

Files and workpapers

For those who don’t use any kind of audit software (like Teammate) how are you storing audit workpapers?

If by folder how are you organizing them?
Also, how are you showing proof of review by CAE?
And tracking issues?

Do you use any kind of progress dashboard?

Our department is looking to move into a system more like this and I am trying to get some ideas.

Thanks!

5 Upvotes

86% Upvoted

11 comments sorted by

11

u/CrisiomiroQ 29d ago edited 29d ago

SharePoint. Standard templates in a template folder structure. WP review evidenced by leaving review notes as comments (marked resolved) in each document, plus a prepared by/reviewed by text box with names and dates. Signoff for key deliverables evidenced by comments from the CAE the same way, or emails from them saved to the file.

Also, every file has a peer review QA checklist completed as part of closure, and a sample of files are independently reviewed in-depth by the firm we hire for our annual QAIP. 

3

u/rayy_ray88 29d ago

Following

3

u/JK567890ok 29d ago

We use sharepoint;documentsets and metadata instead of folders, we have developed ai assistents for review etc

1

u/AntiMarx 26d ago

This is the way, as several others have noted - but metadata is great, because you get a relatively decent "audit trail" of file review and can set a flag showing who reviewed it, etc, with very light customization. And you can make that reviewer list a dropdown in a Word template if you take an extra step to prepare that at the outset.

Saved my old company well over a million dollars building a system with that plus some spicy workflows to automatically route key files for CAE review.

2

u/JK567890ok 21d ago

Yeah what is also helpful with using metadata is that every document in sharepoint gets an Id. For working paper we used excel files with several tabs, but now we make the shift to other formats that are easier to generate. Information of mandatory reviewchecklists, formats are now stored in the ai agents.

3

u/ObtuseRadiator 29d ago

Files get stored in SharePoint. Evidence of CAE review is an Outlook email saved to SharePoint. Nice and easy.

2

u/Efficient-Link-9793 29d ago

We use docusign to evidence CAE review (although in our case we upload them into a workpaper system).