Kuidas kasutada auditi tõendusmaterjali haldurit
Uuendatud 12. oktoobril 2026, lugemisaeg 6 minutit
Samm-sammult
Alates DocMasteri avamisest kuni kliendi failide hilisema leidmiseni. Piltidel on näidisandmed ja kõik ettevõtete nimed on välja mõeldud.
Avage DocMaster Excelis
Excelis vahekaardil Avaleht (Home) klõpsake Open DocMaster. Auditi tõendusmaterjali haldur avaneb paremal külgribana.
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 |
Lohistage kliendi failid sisse
Valige failid sellisena, nagu need kliendilt tulid, ja lohistage need külgribale. Eelnevalt ei ole vaja midagi ümber nimetada ega sorteerida.
DocMaster võtab vastu PDF-, PNG-, JPG- ja JPEG-failid, Wordi failid (DOC ja DOCX), eDoc ja ASiC-E failid ning ZIP-arhiivid. Ühe üleslaadimisega kuni 100 faili või 100 MB. Seejärel vajutage 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 |
Valige projekt, iga dokument leitakse üles
Töötlemine algab kohe. Selle ajal valige projekt, kuhu see partii kuulub.
DocMaster loeb iga faili ja leiab selle seest iga dokumendi. 20 arvega PDF-ist saab 20 arvet. 5 arvega ZIP-ist saab 5 arvet ning ka ZIP-i sees olev ZIP avatakse. Skanne ja fotosid loetakse samamoodi.
| 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 |
Sorteeritud gruppidesse
Dokumendid ilmuvad külgribale, sorteerituna gruppidesse Invoices, Contracts, Delivery documents ja Other documents. Avage grupp, et näha selle sisu, ja sulgege see, et loend jääks lühike. Otsing kitsendab loendit nime järgi.
| 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 |
Sobitage pearaamatuga
Lülitage sisse Match mode ja märkige dokumendid linnukesega. Valige oma tabelis pearaamatu kanded koos päisereaga, seejärel vajutage Match & insert. Iga arve jõuab oma pearaamatu kandele.
Veerg Difference on valem, pearaamatu summa miinus arve summa, nii et iga arvu saab jälgida. Veerg Description võtab kokku, milleks iga dokument on. Kui Two tables on sees, on seotud lepingud ja saatedokumendid paremal samal real. Kõik, mida ei sobitatud, jääb külgribale jaotisse 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 |
Vaadake tõendusmaterjali
Klõpsake mis tahes real View document ja dokument avaneb külgribal numbrite kõrval.
Telefoniga tehtud foto kortsus arvest või viltu skannitud lehekülg avaneb samamoodi nagu puhas PDF. Ülevaataja kontrollib allikat Excelist lahkumata.
| 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 |
Mis tahes dokumendiliik, näiteks lepingud
Auditi tõendusmaterjali haldur töötleb kõiki dokumendiliike, nii et samad sammud sobivad lepingute, saatelehtede või pangakirjade jaoks.
Märkige grupp, siin kõik lepingud, valige lahter ja vajutage Insert. Iga leping saab oma rea, kus on selle osapool, periood ja lühikirjeldus.
| 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.
Kogu meeskond näeb tõendusmaterjali
Iga View document link tabelis avab oma dokumendi külgribal. Lingid töötavad kõigile teie büroos, kes faili avavad, nii et vanemaudiitor ja ülevaataja näevad sama tõendusmaterjali nagu testi teinud inimene.
| 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 |
Leidke see uuesti vahekaardilt Projects
Iga üleslaadimine läheb teie valitud projekti. Avage vahekaart Projects, avage projekt ja seal on kõik selle partiid ja dokumendid, rühmitatud samamoodi.
| 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 |
Käsitsi ja DocMasteriga
Võtame pearaamatu valimist 20 ostuarvet, mille taga on mõned lepingud ja saatelehed.
| Käsitsi | DocMasteriga | |
|---|---|---|
| Aeg 30 dokumendiga detailitesti jaoks | Umbes tund | Umbes 2 minutit |
| Trükkimine | Iga väli käsitsi | Puudub |
| Üks PDF 20 arvega | Jagamine ja lugemine käsitsi | 20 dokumenti leitud |
| Allika kontrollimine | PDF-i otsimine kaustast | Üks klõps realt |
Mis jääb audiitorile
DocMaster korraldab tõendusmaterjali ja näitab, kus on vaja ülevaatust. Auditi järeldus jääb audiitorile.
DocMaster teeb
- Loeb ja eraldab dokumendi andmed
- Sobitab dokumendid pearaamatu kannetega
- Seob arved saatelehtede, CMR-ide ja lepingutega
- Loetleb kõik dokumendid, mida ta ei sisestanud
- Hoiab iga allika ühe klõpsu kaugusel
Audiitor teeb
- Valib valimi
- Hindab, kas tõendusmaterjalist piisab
- Selgitab erandid kliendiga
- Kirjutab järelduse
- Annab allkirja