Guide

How to use Audit Evidence Manager

Audit Evidence Manager takes the client’s files as they came and puts the evidence next to your ledger entries in Excel. This guide shows every step, with a picture of each.
D
DocMaster Team
Updated 12 October 2026, 6 min read

Step by step

From opening DocMaster to finding a client’s files again later. The pictures use sample data, and every company name in them is made up.

Step 1

Open DocMaster in Excel

On the Home tab in Excel, click Open DocMaster. Audit Evidence Manager opens as a pane on the right.

Figure 1. On the Home tab, click Open DocMaster. Audit Evidence Manager opens as a pane inside Excel, ready for the files.
Step 2

Drag in the client's files

Select the files as they came from the client and drag them into the pane. No renaming or sorting first.

DocMaster takes PDF, PNG, JPG and JPEG, Word files (DOC and DOCX), eDoc and ASiC-E, and ZIP archives. Up to 100 files or 100 MB in one upload. Then press Process.

Figure 2. Select the client files as they came, drag them in and press Process.
Step 3

Pick the project, every document is found

Processing starts at once. While it runs, pick the project this batch belongs to.

DocMaster reads every file and finds each document inside it. A PDF with 20 invoices in it becomes 20 invoices. A ZIP with 5 invoices becomes 5, and a ZIP inside a ZIP is opened too. Scans and photos are read the same way.

Figure 3. Processing starts. Pick the project, then the documents appear as they are read, sorted into groups. One PDF with 20 invoices gives 20 invoices, and ZIP files are opened, a ZIP inside a ZIP too.
Step 4

Sorted into groups

The documents appear in the pane, sorted into Invoices, Contracts, Delivery documents and Other documents. Open a group to see what is inside, close it to keep the list short. Search narrows the list by name.

Figure 4. The documents are sorted into Invoices, Contracts, Delivery documents and Other documents. Each group opens and closes.
Step 5

Match to the ledger

Turn on Match mode and tick the documents. Select the ledger entries in your sheet, header row included, then press Match & insert. Each invoice lands on its own ledger line.

The Difference column is a formula, ledger amount minus invoice amount, so every figure can be traced. The Description column sums up what each document is for. With Two tables on, the related contracts and delivery documents sit to the right, on the same line. Anything not matched stays in the pane under Not inserted.

Figure 5. Turn on Match mode, select the documents and the ledger with its header row, then press Match & insert. Each invoice lands on its ledger line. The Difference column is a formula, ledger amount minus invoice amount. Description sums up each document, and related documents sit to the right.
Step 6

View the evidence

Click View document on any row and the document opens in the pane, next to the numbers.

A phone photo of a creased invoice or a page scanned at a tilt opens the same way as a clean PDF. The reviewer checks the source without leaving Excel.

Figure 6. Click View document on any row and the evidence opens in the pane, next to the numbers. Phone photos and tilted scans open just like clean PDFs.
Step 7

Any document type, for example contracts

Audit Evidence Manager handles every document type, so the same steps work for contracts, delivery notes or bank letters.

Tick a group, here all the contracts, select a cell and press Insert. Each contract gets its own row with its party, its period and a short description.

Figure 7. Audit Evidence Manager is not only for invoices. Tick any group, here all the contracts, and insert them. Each contract lands on its own row with its party, period and a description.
Step 8

The whole team sees the evidence

Every View document link in the sheet opens its document in the pane. The links work for everyone at your firm who opens the file, so the senior and the reviewer see the same evidence as the person who ran the test.

Figure 8. The View links work for everyone at your firm. A teammate opens the same workbook, clicks View document and sees the same evidence.
Step 9

Find it again in Projects

Each upload goes to the project you pick. Open the Projects tab, open a project, and all its batches and documents are there, grouped the same way.

Figure 9. Each upload goes to the project you pick. Open the Projects tab, open a project, and all its batches and documents are there.

By hand and with DocMaster

Take 20 purchase invoices from a ledger sample, with a few contracts and delivery notes behind them.

By handWith DocMaster
Time for 20 invoicesAbout an hourAbout 2 minutes
TypingEvery field, by handNone
One PDF with 20 invoicesSplit and read by hand20 documents found
Checking the sourceFind the PDF in a folderOne click from the row

What stays with the auditor

DocMaster organises the evidence and shows where review is needed. The audit conclusion stays with the auditor.

DocMaster does

  • Reads and extracts the document data
  • Matches documents to ledger lines
  • Links invoices to delivery notes, CMRs and contracts
  • Lists every document it did not insert
  • Keeps every source one click away

The auditor does

  • Picks the sample
  • Judges whether the evidence is enough
  • Follows up exceptions with the client
  • Writes the conclusion
  • Signs off
Try it on your own sample.
Free two-week trial. We set it up and train your team.
Scroll to Top