Fill online: Journal entry testing working paper

Try the first few blanks free and watch the document fill in on the right. Pay, and the whole document opens here to finish and download in Word and PDF.

0 of 478 blanks filled

Leave a blank empty and it stays highlighted in your document, to fill by hand. Your answers are saved in this browser only.

Try the first 5 blanks free. After payment the whole document opens here: every blank, and clean Word and PDF downloads.

Your details

Name of the firm

Name of the company

Financial year

Working paper reference

First day of the financial year

Last day of the financial year

Date of extraction

Name of the preparer

Date prepared

Name of the reviewer

Date reviewed

WP ref of the fraud risk assessment

WP ref of the audit trail working paper

WP ref of the materiality working paper

Accounting software and version

Yes / No / Partly

How manual and system entries are distinguished

Describe the maker-checker and approval controls over journal entries and the result of any test of them

Number of users with posting rights

Date the books were closed

Report or tables extracted

Person who ran the extraction

Observed by the audit team / run by the audit team / received from the client

Yes / No (1)

Adjustments made outside the ledger and how they were tested

Tool used for the filters and location of the files

Person and designation, row 1

Chief financial officer: Date

Chief financial officer: Response

Chief financial officer: Follow-up and WP ref

Person and designation, row 2

Accounts manager responsible for the close: Date

Accounts manager responsible for the close: Response

Accounts manager responsible for the close: Follow-up and WP ref

Person and designation, row 3

Staff who post journal entries: Date

Staff who post journal entries: Response

Staff who post journal entries: Follow-up and WP ref

Person and designation, row 4

IT administrator: Date

IT administrator: Response

IT administrator: Follow-up and WP ref

Person and designation, row 5

Head of internal audit or chair of the audit: Date

Head of internal audit or chair of the audit: Response

Head of internal audit or chair of the audit: Follow-up and WP ref

Opening balance (Rs), row 1

Debits in the population (Rs), row 1

Credits in the population (Rs), row 1

Closing balance per trial balance (Rs), row 1

Opening balance (Rs), row 2

Debits in the population (Rs), row 2

Credits in the population (Rs), row 2

Closing balance per trial balance (Rs), row 2

Opening balance (Rs), row 3

Debits in the population (Rs), row 3

Credits in the population (Rs), row 3

Closing balance per trial balance (Rs), row 3

Opening balance (Rs), row 4

Debits in the population (Rs), row 4

Credits in the population (Rs), row 4

Closing balance per trial balance (Rs), row 4

Opening balance (Rs), row 5

Debits in the population (Rs), row 5

Credits in the population (Rs), row 5

Closing balance per trial balance (Rs), row 5

Opening balance (Rs), row 6

Debits in the population (Rs), row 6

Credits in the population (Rs), row 6

Closing balance per trial balance (Rs), row 6

Opening balance (Rs), row 7

Debits in the population (Rs), row 7

Credits in the population (Rs), row 7

Closing balance per trial balance (Rs), row 7

Opening balance (Rs), row 8

Debits in the population (Rs), row 8

Credits in the population (Rs), row 8

Closing balance per trial balance (Rs), row 8

Opening balance (Rs), row 9

Debits in the population (Rs), row 9

Credits in the population (Rs), row 9

Closing balance per trial balance (Rs), row 9

Opening balance (Rs), row 10

Debits in the population (Rs), row 10

Credits in the population (Rs), row 10

Closing balance per trial balance (Rs), row 10

Opening balance (Rs), row 11

Debits in the population (Rs), row 11

Credits in the population (Rs), row 11

Closing balance per trial balance (Rs), row 11

Opening balance (Rs), row 12

Debits in the population (Rs), row 12

Credits in the population (Rs), row 12

Closing balance per trial balance (Rs), row 12

Opening balance (Rs), row 13

Debits in the population (Rs), row 13

Credits in the population (Rs), row 13

Closing balance per trial balance (Rs), row 13

Opening balance (Rs), row 14

Debits in the population (Rs), row 14

Credits in the population (Rs), row 14

Closing balance per trial balance (Rs), row 14

Opening balance (Rs), row 15

Debits in the population (Rs), row 15

Credits in the population (Rs), row 15

Closing balance per trial balance (Rs), row 15

Opening balance (Rs), row 16

Debits in the population (Rs), row 16

Credits in the population (Rs), row 16

Closing balance per trial balance (Rs), row 16

Opening balance (Rs), row 17

Debits in the population (Rs), row 17

Credits in the population (Rs), row 17

Closing balance per trial balance (Rs), row 17

Opening balance (Rs), row 18

Debits in the population (Rs), row 18

Credits in the population (Rs), row 18

Closing balance per trial balance (Rs), row 18

Threshold for investigating a difference (Rs): Difference (Rs)

All flagged entries / all flagged entries above Rs (amount) and a sample of the rest / a sample chosen as recorded in the Sampling working paper

Location of the books

C01: Entries flagged (count)

C01: Value flagged (Rs)

C01: Conclusion and WP ref

Start of working hours

End of working hours

C02: Entries flagged (count)

C02: Value flagged (Rs)

C02: Conclusion and WP ref

Designations treated as senior management

C03: Entries flagged (count)

C03: Value flagged (Rs)

C03: Conclusion and WP ref

Minimum postings for a regular user

C04: Entries flagged (count)

C04: Value flagged (Rs)

C04: Conclusion and WP ref

Round amount multiple in Rs

Minimum amount for the round amount test in Rs

C05: Entries flagged (count)

C05: Value flagged (Rs)

C05: Conclusion and WP ref

Percentage below the approval limit

C06: Entries flagged (count)

C06: Value flagged (Rs)

C06: Conclusion and WP ref

C07: Entries flagged (count)

C07: Value flagged (Rs)

C07: Conclusion and WP ref

Working days at the period end

C08: Entries flagged (count)

C08: Value flagged (Rs)

C08: Conclusion and WP ref

Minimum postings for a regular account

C09: Entries flagged (count)

C09: Value flagged (Rs)

C09: Conclusion and WP ref

Other combinations relevant to the client

C10: Entries flagged (count)

C10: Value flagged (Rs)

C10: Conclusion and WP ref

Minimum narration length in characters

C11: Entries flagged (count)

C11: Value flagged (Rs)

C11: Conclusion and WP ref

Number of days into the next year

C12: Entries flagged (count)

C12: Value flagged (Rs)

C12: Conclusion and WP ref

Days allowed between effective and posting dates

C13: Entries flagged (count)

C13: Value flagged (Rs)

C13: Conclusion and WP ref

C14: Entries flagged (count)

C14: Value flagged (Rs)

C14: Conclusion and WP ref

C15: Entries flagged (count)

C15: Value flagged (Rs)

C15: Conclusion and WP ref

C16: Entries flagged (count)

C16: Value flagged (Rs)

C16: Conclusion and WP ref

C17: Entries flagged (count)

C17: Value flagged (Rs)

C17: Conclusion and WP ref

C18: Entries flagged (count)

C18: Value flagged (Rs)

C18: Conclusion and WP ref

Engagement-specific criterion and parameter

C19: Entries flagged (count)

C19: Value flagged (Rs)

C19: Conclusion and WP ref

Unique entries flagged by one or more: Entries flagged (count)

Unique entries flagged by one or more: Value flagged (Rs)

Entries in the population, and total debits: Entries flagged (count)

Entry number, row 1

Criterion code, row 1

Effective date, row 1

Posted by, row 1

Amount (Rs), row 1

Accounts debited and credited, row 1

Supporting evidence examined, row 1

Authorised by, row 1

Business rationale, row 1

Yes / No (2)

Nature of exception and follow-up, row 1

Entry number, row 2

Criterion code, row 2

Effective date, row 2

Posted by, row 2

Amount (Rs), row 2

Accounts debited and credited, row 2

Supporting evidence examined, row 2

Authorised by, row 2

Business rationale, row 2

Yes / No (3)

Nature of exception and follow-up, row 2

Entry number, row 3

Criterion code, row 3

Effective date, row 3

Posted by, row 3

Amount (Rs), row 3

Accounts debited and credited, row 3

Supporting evidence examined, row 3

Authorised by, row 3

Business rationale, row 3

Yes / No (4)

Nature of exception and follow-up, row 3

Entry number, row 4

Criterion code, row 4

Effective date, row 4

Posted by, row 4

Amount (Rs), row 4

Accounts debited and credited, row 4

Supporting evidence examined, row 4

Authorised by, row 4

Business rationale, row 4

Yes / No (5)

Nature of exception and follow-up, row 4

Entry number, row 5

Criterion code, row 5

Effective date, row 5

Posted by, row 5

Amount (Rs), row 5

Accounts debited and credited, row 5

Supporting evidence examined, row 5

Authorised by, row 5

Business rationale, row 5

Yes / No (6)

Nature of exception and follow-up, row 5

Entry number, row 6

Criterion code, row 6

Effective date, row 6

Posted by, row 6

Amount (Rs), row 6

Accounts debited and credited, row 6

Supporting evidence examined, row 6

Authorised by, row 6

Business rationale, row 6

Yes / No (7)

Nature of exception and follow-up, row 6

Entry number, row 7

Criterion code, row 7

Effective date, row 7

Posted by, row 7

Amount (Rs), row 7

Accounts debited and credited, row 7

Supporting evidence examined, row 7

Authorised by, row 7

Business rationale, row 7

Yes / No (8)

Nature of exception and follow-up, row 7

Entry number, row 8

Criterion code, row 8

Effective date, row 8

Posted by, row 8

Amount (Rs), row 8

Accounts debited and credited, row 8

Supporting evidence examined, row 8

Authorised by, row 8

Business rationale, row 8

Yes / No (9)

Nature of exception and follow-up, row 8

Entry number, row 9

Criterion code, row 9

Effective date, row 9

Posted by, row 9

Amount (Rs), row 9

Accounts debited and credited, row 9

Supporting evidence examined, row 9

Authorised by, row 9

Business rationale, row 9

Yes / No (10)

Nature of exception and follow-up, row 9

Entry number, row 10

Criterion code, row 10

Effective date, row 10

Posted by, row 10

Amount (Rs), row 10

Accounts debited and credited, row 10

Supporting evidence examined, row 10

Authorised by, row 10

Business rationale, row 10

Yes / No (11)

Nature of exception and follow-up, row 10

Entry number, row 11

Criterion code, row 11

Effective date, row 11

Posted by, row 11

Amount (Rs), row 11

Accounts debited and credited, row 11

Supporting evidence examined, row 11

Authorised by, row 11

Business rationale, row 11

Yes / No (12)

Nature of exception and follow-up, row 11

Entry number, row 12

Criterion code, row 12

Effective date, row 12

Posted by, row 12

Amount (Rs), row 12

Accounts debited and credited, row 12

Supporting evidence examined, row 12

Authorised by, row 12

Business rationale, row 12

Yes / No (13)

Nature of exception and follow-up, row 12

Entry number, row 13

Criterion code, row 13

Effective date, row 13

Posted by, row 13

Amount (Rs), row 13

Accounts debited and credited, row 13

Supporting evidence examined, row 13

Authorised by, row 13

Business rationale, row 13

Yes / No (14)

Nature of exception and follow-up, row 13

Entry number, row 14

Criterion code, row 14

Effective date, row 14

Posted by, row 14

Amount (Rs), row 14

Accounts debited and credited, row 14

Supporting evidence examined, row 14

Authorised by, row 14

Business rationale, row 14

Yes / No (15)

Nature of exception and follow-up, row 14

Entry number, row 15

Criterion code, row 15

Effective date, row 15

Posted by, row 15

Amount (Rs), row 15

Accounts debited and credited, row 15

Supporting evidence examined, row 15

Authorised by, row 15

Business rationale, row 15

Yes / No (16)

Nature of exception and follow-up, row 15

Entry number, row 16

Criterion code, row 16

Effective date, row 16

Posted by, row 16

Amount (Rs), row 16

Accounts debited and credited, row 16

Supporting evidence examined, row 16

Authorised by, row 16

Business rationale, row 16

Yes / No (17)

Nature of exception and follow-up, row 16

Entry number, row 17

Criterion code, row 17

Effective date, row 17

Posted by, row 17

Amount (Rs), row 17

Accounts debited and credited, row 17

Supporting evidence examined, row 17

Authorised by, row 17

Business rationale, row 17

Yes / No (18)

Nature of exception and follow-up, row 17

Entry number, row 18

Criterion code, row 18

Effective date, row 18

Posted by, row 18

Amount (Rs), row 18

Accounts debited and credited, row 18

Supporting evidence examined, row 18

Authorised by, row 18

Business rationale, row 18

Yes / No (19)

Nature of exception and follow-up, row 18

Entry number, row 19

Criterion code, row 19

Effective date, row 19

Posted by, row 19

Amount (Rs), row 19

Accounts debited and credited, row 19

Supporting evidence examined, row 19

Authorised by, row 19

Business rationale, row 19

Yes / No (20)

Nature of exception and follow-up, row 19

Entry number, row 20

Criterion code, row 20

Effective date, row 20

Posted by, row 20

Amount (Rs), row 20

Accounts debited and credited, row 20

Supporting evidence examined, row 20

Authorised by, row 20

Business rationale, row 20

Yes / No (21)

Nature of exception and follow-up, row 20

Entry number, row 21

Criterion code, row 21

Effective date, row 21

Posted by, row 21

Amount (Rs), row 21

Accounts debited and credited, row 21

Supporting evidence examined, row 21

Authorised by, row 21

Business rationale, row 21

Yes / No (22)

Nature of exception and follow-up, row 21

Entry number, row 22

Criterion code, row 22

Effective date, row 22

Posted by, row 22

Amount (Rs), row 22

Accounts debited and credited, row 22

Supporting evidence examined, row 22

Authorised by, row 22

Business rationale, row 22

Yes / No (23)

Nature of exception and follow-up, row 22

Entry number, row 23

Criterion code, row 23

Effective date, row 23

Posted by, row 23

Amount (Rs), row 23

Accounts debited and credited, row 23

Supporting evidence examined, row 23

Authorised by, row 23

Business rationale, row 23

Yes / No (24)

Nature of exception and follow-up, row 23

Entry number, row 24

Criterion code, row 24

Effective date, row 24

Posted by, row 24

Amount (Rs), row 24

Accounts debited and credited, row 24

Supporting evidence examined, row 24

Authorised by, row 24

Business rationale, row 24

Yes / No (25)

Nature of exception and follow-up, row 24

Entry number, row 25

Criterion code, row 25

Effective date, row 25

Posted by, row 25

Amount (Rs), row 25

Accounts debited and credited, row 25

Supporting evidence examined, row 25

Authorised by, row 25

Business rationale, row 25

Yes / No (26)

Nature of exception and follow-up, row 25

Number of entries tested

Number of entries in the population

Number of exceptions

Obtained further evidence and corroborated the explanation / extended testing to all entries with the same characteristic / identified a misstatement of Rs (amount), carried to the summary of audit differences

Management / those charged with governance

Date of communication of the exceptions

Name of the engagement partner

Date of the partner's review

[Name of the firm] · Chartered Accountants

JOURNAL ENTRY TESTING WORKING PAPER

Client: [Name of the company] · Financial year: [Financial year] · WP ref: [Working paper reference]
Period covered: [First day of the financial year] to [Last day of the financial year], with post-closing entries to [Date of extraction]
Prepared by: [Name of the preparer] on [Date prepared] · Reviewed by: [Name of the reviewer] on [Date reviewed]

1. Objective and the requirements applied

Irrespective of the assessed risk of management override of controls, SA 240 paragraph 32(a) requires us to test the appropriateness of journal entries recorded in the general ledger and of other adjustments made in preparing the financial statements, and in doing so (i) to inquire of individuals involved in the financial reporting process about inappropriate or unusual activity in the processing of journal entries and other adjustments, (ii) to select journal entries and other adjustments made at the end of the reporting period, and (iii) to consider the need to test journal entries and other adjustments throughout the period. Paragraphs A41 to A44 explain that override is commonly effected through inappropriate or unauthorised entries, often at the period end or through adjustments that never pass through a formal journal, and direct the selection to the assessed fraud risks, the controls over journal entries, the nature of the evidence available, the characteristics of fraudulent entries (unrelated, unusual or seldom-used accounts; users who do not normally post; period-end or post-closing entries with little or no explanation; entries without account numbers; round or consistently ending amounts), complex accounts and entries outside the normal course of business.

SA 330 paragraph 20 requires us to agree or reconcile the financial statements with the underlying accounting records and to examine material journal entries and other adjustments made in preparing them. SA 500 paragraph 9 requires us to evaluate whether information produced by the entity is sufficiently reliable, including its completeness and accuracy: the population is therefore reconciled to the trial balance in section 4 before any filter is run.

The rest of this format (27 more paragraphs and tables) opens here after payment, to fill in the same way.

₹199 + GST, for the finished document, Word and PDF

The short sample is the opening of the document with your details, marked SAMPLE.

A drafted format for your use. It is not legal advice; for a complex matter, consult a professional. About this format