How to use Audit Evidence Manager
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.
Open DocMaster in Excel
On the Home tab in Excel, click Open DocMaster. Audit Evidence Manager opens as a pane on the right.
DocMaster
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ||||||||||||||
| 2 | Selected ledger entries | |||||||||||||
| 3 | ||||||||||||||
| 4 | Invoice Number | Seller | Total Exc Tax | |||||||||||
| 5 | OFF-005 | Kvarnelo Office Supplies Ltd | 4 485.00 | |||||||||||
| 6 | NB-011 | Kaltrevo Digital Services Ltd | 3 529.73 | |||||||||||
| 7 | INT-9044 | Murrelin Hardware Trading Ltd | 9 130.00 | |||||||||||
| 8 | FV-PL-006 | Plenvaro Solutions Sp. z o.o. | 4 700.00 | |||||||||||
| 9 | INV-7782 | Tavrino Process Systems Ltd | 6 000.00 | |||||||||||
| 10 | CON-4521 | Grenvaltis Construction Services | 19 500.00 | |||||||||||
| 11 | ||||||||||||||
| 12 | ||||||||||||||
| 13 | ||||||||||||||
| 14 | ||||||||||||||
| 15 | ||||||||||||||
| 16 | ||||||||||||||
| 17 | ||||||||||||||
| 18 | ||||||||||||||
| 19 | ||||||||||||||
| 20 | ||||||||||||||
| 21 | ||||||||||||||
| 22 | ||||||||||||||
| 23 | ||||||||||||||
| 24 |
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.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |||||||||
| 2 | Selected ledger entries | ||||||||
| 3 | |||||||||
| 4 | Invoice Number | Seller | Total Exc Tax | ||||||
| 5 | OFF-005 | Kvarnelo Office Supplies Ltd | 4 485.00 | ||||||
| 6 | NB-011 | Kaltrevo Digital Services Ltd | 3 529.73 | ||||||
| 7 | INT-9044 | Murrelin Hardware Trading Ltd | 9 130.00 | ||||||
| 8 | FV-PL-006 | Plenvaro Solutions Sp. z o.o. | 4 700.00 | ||||||
| 9 | INV-7782 | Tavrino Process Systems Ltd | 6 000.00 | ||||||
| 10 | CON-4521 | Grenvaltis Construction Services | 19 500.00 | ||||||
| 11 | |||||||||
| 12 | |||||||||
| 13 | |||||||||
| 14 | |||||||||
| 15 | |||||||||
| 16 | |||||||||
| 17 | |||||||||
| 18 | |||||||||
| 19 | |||||||||
| 20 | |||||||||
| 21 | |||||||||
| 22 | |||||||||
| 23 | |||||||||
| 24 |
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.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |||||||||
| 2 | Selected ledger entries | ||||||||
| 3 | |||||||||
| 4 | Invoice Number | Seller | Total Exc Tax | ||||||
| 5 | OFF-005 | Kvarnelo Office Supplies Ltd | 4 485.00 | ||||||
| 6 | NB-011 | Kaltrevo Digital Services Ltd | 3 529.73 | ||||||
| 7 | INT-9044 | Murrelin Hardware Trading Ltd | 9 130.00 | ||||||
| 8 | FV-PL-006 | Plenvaro Solutions Sp. z o.o. | 4 700.00 | ||||||
| 9 | INV-7782 | Tavrino Process Systems Ltd | 6 000.00 | ||||||
| 10 | CON-4521 | Grenvaltis Construction Services | 19 500.00 | ||||||
| 11 | |||||||||
| 12 | |||||||||
| 13 | |||||||||
| 14 | |||||||||
| 15 | |||||||||
| 16 | |||||||||
| 17 | |||||||||
| 18 | |||||||||
| 19 | |||||||||
| 20 | |||||||||
| 21 | |||||||||
| 22 | |||||||||
| 23 | |||||||||
| 24 |
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.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |||||||||
| 2 | Selected ledger entries | ||||||||
| 3 | |||||||||
| 4 | Invoice Number | Seller | Total Exc Tax | ||||||
| 5 | OFF-005 | Kvarnelo Office Supplies Ltd | 4 485.00 | ||||||
| 6 | NB-011 | Kaltrevo Digital Services Ltd | 3 529.73 | ||||||
| 7 | INT-9044 | Murrelin Hardware Trading Ltd | 9 130.00 | ||||||
| 8 | FV-PL-006 | Plenvaro Solutions Sp. z o.o. | 4 700.00 | ||||||
| 9 | INV-7782 | Tavrino Process Systems Ltd | 6 000.00 | ||||||
| 10 | CON-4521 | Grenvaltis Construction Services | 19 500.00 | ||||||
| 11 | |||||||||
| 12 | |||||||||
| 13 | |||||||||
| 14 | |||||||||
| 15 | |||||||||
| 16 | |||||||||
| 17 | |||||||||
| 18 | |||||||||
| 19 | |||||||||
| 20 | |||||||||
| 21 | |||||||||
| 22 | |||||||||
| 23 | |||||||||
| 24 |
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.
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ||||||||||||||
| 2 | Selected ledger entries | Per invoices | Related documents | |||||||||||
| 3 | ||||||||||||||
| 4 | Invoice Number | Seller | Total Exc Tax | Invoice Number | Total Exc Tax | Difference | Description | View | Document Type | Relation | Description | |||
| 5 | OFF-005 | Kvarnelo Office Supplies Ltd | 4 485.00 | OFF-005 | 4 484.50 | 0.50 | Office supplies, paper, stationery and desk accessories | View document | ||||||
| 6 | NB-011 | Kaltrevo Digital Services Ltd | 3 529.73 | NB-011 | 3 529.73 | - | Subscription to a document processing platform and support | View document | ||||||
| 7 | INT-9044 | Murrelin Hardware Trading Ltd | 9 130.00 | INT-9044 | 9 130.00 | - | Central processing units and international freight | View document | ||||||
| 8 | FV-PL-006 | Plenvaro Solutions Sp. z o.o. | 4 700.00 | FV-PL-006 | 4 700.00 | - | Document management system rollout and documentation | View document | ||||||
| 9 | INV-7782 | Tavrino Process Systems Ltd | 6 000.00 | INV-7782 | 6 000.00 | - | Accounts payable data processing and validation services | View document | Contract | Framework agreement setting the monthly fee billed on INV-7782 | Master services agreement for AP data processing | |||
| 10 | CON-4521 | Grenvaltis Construction Services | 19 500.00 | CON-4521 | 19 500.00 | - | Construction works, steel framework and site supervision | View document | Delivery | Delivery note for the steel works billed on CON-4521 | Steel framework delivered to site, 12 tonnes | |||
| 11 | ||||||||||||||
| 12 | ||||||||||||||
| 13 | ||||||||||||||
| 14 | ||||||||||||||
| 15 | ||||||||||||||
| 16 | ||||||||||||||
| 17 | ||||||||||||||
| 18 | ||||||||||||||
| 19 | ||||||||||||||
| 20 | ||||||||||||||
| 21 | ||||||||||||||
| 22 | ||||||||||||||
| 23 | ||||||||||||||
| 24 |
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.
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ||||||||||||||
| 2 | Selected ledger entries | Per invoices | Related documents | |||||||||||
| 3 | ||||||||||||||
| 4 | Invoice Number | Seller | Total Exc Tax | Invoice Number | Total Exc Tax | Difference | Description | View | Document Type | Relation | Description | |||
| 5 | OFF-005 | Kvarnelo Office Supplies Ltd | 4 485.00 | OFF-005 | 4 484.50 | 0.50 | Office supplies, paper, stationery and desk accessories | View document | ||||||
| 6 | NB-011 | Kaltrevo Digital Services Ltd | 3 529.73 | NB-011 | 3 529.73 | - | Subscription to a document processing platform and support | View document | ||||||
| 7 | INT-9044 | Murrelin Hardware Trading Ltd | 9 130.00 | INT-9044 | 9 130.00 | - | Central processing units and international freight | View document | ||||||
| 8 | FV-PL-006 | Plenvaro Solutions Sp. z o.o. | 4 700.00 | FV-PL-006 | 4 700.00 | - | Document management system rollout and documentation | View document | ||||||
| 9 | INV-7782 | Tavrino Process Systems Ltd | 6 000.00 | INV-7782 | 6 000.00 | - | Accounts payable data processing and validation services | View document | Contract | Framework agreement setting the monthly fee billed on INV-7782 | Master services agreement for AP data processing | |||
| 10 | CON-4521 | Grenvaltis Construction Services | 19 500.00 | CON-4521 | 19 500.00 | - | Construction works, steel framework and site supervision | View document | Delivery | Delivery note for the steel works billed on CON-4521 | Steel framework delivered to site, 12 tonnes | |||
| 11 | ||||||||||||||
| 12 | ||||||||||||||
| 13 | ||||||||||||||
| 14 | ||||||||||||||
| 15 | ||||||||||||||
| 16 | ||||||||||||||
| 17 | ||||||||||||||
| 18 | ||||||||||||||
| 19 | ||||||||||||||
| 20 | ||||||||||||||
| 21 | ||||||||||||||
| 22 | ||||||||||||||
| 23 | ||||||||||||||
| 24 |
Invoice
Date: 02.08.2024
Currency: EUR
Riga, LV-1004
Riga, LV-1050
| Description | Qty | Price | Amount |
|---|---|---|---|
| Central processing units XT-9000 | 20 | 420.00 | 8 400.00 |
| International freight | 1 | 730.00 | 730.00 |
Invoice
Date: 05.10.2024
Currency: EUR
Gdansk, 80-001
Riga, LV-1050
| Description | Qty | Price | Amount |
|---|---|---|---|
| Document management system rollout | 1 | 3 900.00 | 3 900.00 |
| Technical documentation | 1 | 800.00 | 800.00 |
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.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | ||||||||
| 2 | Document Type | Document Number | Primary Party | Period Start | Period End | Description | View | |
| 3 | Contract | MSA-2024 | Ruvelko Process Automation Ltd | 01.03.2025 | 28.02.2027 | Framework agreement for AP automation services, monthly fee | View document | |
| 4 | Contract | LS-118 | Tamverin Industrial Works Ltd | 01.01.2025 | 31.12.2025 | Lease of 1 200 m2 of warehouse space, monthly rent | View document | |
| 5 | Contract | SUP-07 | Kvarnelo Office Supplies Ltd | 15.02.2025 | 14.02.2026 | Supply of office materials at fixed prices | View document | |
| 6 | Contract | SLA-25-3 | Ovrelka Data Labs Ltd | 01.04.2025 | 31.03.2026 | Cloud hosting and data processing with service levels | View document | |
| 7 | Contract | CW-4521 | Grenvaltis Construction Services | 10.06.2024 | 30.11.2025 | Construction of the new warehouse at a fixed price | View document | |
| 8 | ||||||||
| 9 | ||||||||
| 10 | ||||||||
| 11 | ||||||||
| 12 | ||||||||
| 13 | ||||||||
| 14 | ||||||||
| 15 | ||||||||
| 16 | ||||||||
| 17 | ||||||||
| 18 | ||||||||
| 19 | ||||||||
| 20 | ||||||||
| 21 | ||||||||
| 22 | ||||||||
| 23 | ||||||||
| 24 |
This Master Services Agreement is made on 1 March 2025 between:
(1) Ruvelko Process Automation Ltd, the Supplier, and
(2) Klestrovik Group SIA, Riga, the Client.
The Supplier provides accounts payable automation and data validation services to the Client, as set out in Annex 1.
The Client pays a monthly fee of EUR 6 000 excl. VAT, invoiced at the start of each month.
From 1 March 2025 to 28 February 2027, renewed for one year unless ended with 3 months notice.
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.
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ||||||||||||||
| 2 | Selected ledger entries | Per invoices | Related documents | |||||||||||
| 3 | ||||||||||||||
| 4 | Invoice Number | Seller | Total Exc Tax | Invoice Number | Total Exc Tax | Difference | Description | View | Document Type | Relation | Description | |||
| 5 | OFF-005 | Kvarnelo Office Supplies Ltd | 4 485.00 | OFF-005 | 4 484.50 | 0.50 | Office supplies, paper, stationery and desk accessories | View document | ||||||
| 6 | NB-011 | Kaltrevo Digital Services Ltd | 3 529.73 | NB-011 | 3 529.73 | - | Subscription to a document processing platform and support | View document | ||||||
| 7 | INT-9044 | Murrelin Hardware Trading Ltd | 9 130.00 | INT-9044 | 9 130.00 | - | Central processing units and international freight | View document | ||||||
| 8 | FV-PL-006 | Plenvaro Solutions Sp. z o.o. | 4 700.00 | FV-PL-006 | 4 700.00 | - | Document management system rollout and documentation | View document | ||||||
| 9 | INV-7782 | Tavrino Process Systems Ltd | 6 000.00 | INV-7782 | 6 000.00 | - | Accounts payable data processing and validation services | View document | Contract | Framework agreement setting the monthly fee billed on INV-7782 | Master services agreement for AP data processing | |||
| 10 | CON-4521 | Grenvaltis Construction Services | 19 500.00 | CON-4521 | 19 500.00 | - | Construction works, steel framework and site supervision | View document | Delivery | Delivery note for the steel works billed on CON-4521 | Steel framework delivered to site, 12 tonnes | |||
| 11 | ||||||||||||||
| 12 | ||||||||||||||
| 13 | ||||||||||||||
| 14 | ||||||||||||||
| 15 | ||||||||||||||
| 16 | ||||||||||||||
| 17 | ||||||||||||||
| 18 | ||||||||||||||
| 19 | ||||||||||||||
| 20 | ||||||||||||||
| 21 | ||||||||||||||
| 22 | ||||||||||||||
| 23 | ||||||||||||||
| 24 |
Invoice
Date: 10.09.2024
Currency: EUR
VAT rate: 21%
14 Stationery Park
Riga, LV-1010
200 Sample Avenue
Riga, LV-1050
| Description | Qty | Unit price | Amount |
|---|---|---|---|
| A4 copy paper 80 gsm, box of 5 | 40 | 24.50 | 980.00 |
| Ballpoint pens, blue | 200 | 0.85 | 170.00 |
| Desk organisers | 60 | 12.40 | 744.00 |
| Archive boxes | 150 | 17.27 | 2 590.50 |
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.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |||||||||
| 2 | Selected ledger entries | ||||||||
| 3 | |||||||||
| 4 | Invoice Number | Seller | Total Exc Tax | ||||||
| 5 | OFF-005 | Kvarnelo Office Supplies Ltd | 4 485.00 | ||||||
| 6 | NB-011 | Kaltrevo Digital Services Ltd | 3 529.73 | ||||||
| 7 | INT-9044 | Murrelin Hardware Trading Ltd | 9 130.00 | ||||||
| 8 | FV-PL-006 | Plenvaro Solutions Sp. z o.o. | 4 700.00 | ||||||
| 9 | INV-7782 | Tavrino Process Systems Ltd | 6 000.00 | ||||||
| 10 | CON-4521 | Grenvaltis Construction Services | 19 500.00 | ||||||
| 11 | |||||||||
| 12 | |||||||||
| 13 | |||||||||
| 14 | |||||||||
| 15 | |||||||||
| 16 | |||||||||
| 17 | |||||||||
| 18 | |||||||||
| 19 | |||||||||
| 20 | |||||||||
| 21 | |||||||||
| 22 | |||||||||
| 23 | |||||||||
| 24 |
By hand and with DocMaster
Take 20 purchase invoices from a ledger sample, with a few contracts and delivery notes behind them.
| By hand | With DocMaster | |
|---|---|---|
| Time for 20 invoices | About an hour | About 2 minutes |
| Typing | Every field, by hand | None |
| One PDF with 20 invoices | Split and read by hand | 20 documents found |
| Checking the source | Find the PDF in a folder | One 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