Journal Entry Backup Checklist
Journal Entry Backup
Checklist
The documentation needed to provide Journal
approvers and auditors with the complete
details needed to support the journal,
ensuring its reasonableness and accuracy.
2
W
h
a
t
i
s
J
o
u
r
n
a
l
E
n
t
r
y
B
a
c
k
u
p
?
C
h
e
c
k
l
i
s
t
1.
Show all calculations
2.
Provide reference & backup to show the source of dollar
amounts
3.
Include a journal entry summary tab in complex
spreadsheets
4.
Redact/remove and/or do not submit confidential
information
5.
Include relevant email trails showing approvals
6.
Only include relevant portion of supporting documents
3
S
h
o
w
A
l
l
C
a
l
c
u
l
a
t
i
o
n
s
•
When a journal entry amount is based on a calculation, the
calculation must be substantiated with all data points
•
The preferred backup is an Excel sheet
•
Always include all detailed information
•
A PDF or Word document showing only partial information or lacking
relevant calculations is not sufficient
4
S
h
o
w
A
l
l
C
a
l
c
u
l
a
t
i
o
n
s
E
x
a
m
p
l
e
:
T
h
e
a
t
t
a
c
h
e
d
E
x
c
e
l
f
i
l
e
i
n
c
l
u
d
e
s
r
e
l
e
v
a
n
t
c
a
l
c
u
l
a
t
i
o
n
s
5
P
r
o
v
i
d
e
r
e
f
e
r
e
n
c
e
&
b
a
c
k
u
p
t
o
s
h
o
w
t
h
e
s
o
u
r
c
e
o
f
d
o
l
l
a
r
a
m
o
u
n
t
s
•
Provide documentation showing the original amounts used in all
calculations (include report screenshots)
•
Remember to highlight and/or circle the relevant transaction(s) and
please reference page number(s) where these can be found
•
Revenue/Expenses are not recognized until they are recorded in the
General Ledger. When transferring expenses, GL references are the
only valid backup
•
Example: specific EXPJ-##########, SINJ-##########, etc.,
or a printout of the FIN RPT - Financial Rollup Report, or bank
statements showing transaction
6
P
r
o
v
i
d
e
r
e
f
e
r
e
n
c
e
a
n
d
b
a
c
k
u
p
t
o
s
h
o
w
t
h
e
s
o
u
r
c
e
o
f
d
o
l
l
a
r
a
m
o
u
n
t
s
E
x
a
m
p
l
e
:
J
o
u
r
n
a
l
S
e
q
u
e
n
c
e
N
u
m
b
e
r
i
n
f
o
r
m
a
t
i
o
n
i
s
h
i
g
h
l
i
g
h
t
e
d
7
I
n
c
l
u
d
e
s
u
m
m
a
r
y
s
h
e
e
t
f
o
r
c
o
m
p
l
e
x
s
p
r
e
a
d
s
h
e
e
t
s
1.
If the calculations in an Excel spreadsheet involve multiple tabs or
are complex, add a Summary Sheet tab that cell-references other
sheets and summarizes the values of the Journal Entry
2.
Include annotations that explain what is being referenced and how it
is relevant to the journal
3.
Remember that all calculation details must be included and a
summary alone is not adequate
8
I
n
c
l
u
d
e
a
j
o
u
r
n
a
l
e
n
t
r
y
s
u
m
m
a
r
y
t
a
b
i
n
c
o
m
p
l
e
x
s
p
r
e
a
d
s
h
e
e
t
s
E
x
a
m
p
l
e
:
S
u
m
m
a
r
y
S
h
e
e
t
i
s
t
h
e
t
a
b
t
h
a
t
t
i
e
s
t
h
e
d
e
t
a
i
l
s
h
e
e
t
s
t
o
t
h
e
j
o
u
r
n
a
l
e
n
t
r
y
d
o
l
l
a
r
v
a
l
u
e
s
9
1.
Summary Sheet and cell-references
2.
Annotation
3.
Detailed calculation sheets
R
e
d
a
c
t
/
r
e
m
o
v
e
a
n
d
/
o
r
d
o
n
o
t
s
u
b
m
i
t
c
o
n
f
i
d
e
n
t
i
a
l
i
n
f
o
r
m
a
t
i
o
n
•
Personal or confidential information cannot be included
•
Redact confidential information including but not limited to:
•
Investment account and bank account transit numbers
•
Credit card numbers
•
Employee names
•
Birthdays
•
Addresses
•
Payroll reports
•
S
tudent names and other student information, marks, etc.
•
Other confidential information
10
10
C
o
n
t
.
-
R
e
d
a
c
t
/
r
e
m
o
v
e
a
n
d
/
o
r
d
o
n
o
t
s
u
b
m
i
t
c
o
n
f
i
d
e
n
t
i
a
l
i
n
f
o
r
m
a
t
i
o
n
•
Confidential information backup can be retained by the originating
department and made available to Finance and auditors upon request
•
To ensure compliance see Policy IT01 and the Algonquin College
Privacy Statement:
https://www.algonquincollege.com/policies/files/2021/01/IT01.pdf
https://www.algonquincollege.com/policies/privacy/
NOTE: Confidential information backup files must be retained by the
originating department for current year+7 years
11
11
I
n
c
l
u
d
e
r
e
l
e
v
a
n
t
e
m
a
i
l
t
r
a
i
l
s
s
h
o
w
i
n
g
a
p
p
r
o
v
a
l
s
•
Where relevant to the journal entry, ensure all prior approvals are in
place and included in the journal entry backup. E.g., email showing
approval
•
The “Forward” response should be used by the approving manager
for email backups so the files that have been reviewed are included in
the approval email
Do not submit a “Reply” response because the reviewed and
approved files will not be included and therefore the approval cannot
be assumed to be for the dollar amounts in the journal entry
12
12
I
n
c
l
u
d
e
r
e
l
e
v
a
n
t
e
m
a
i
l
t
r
a
i
l
s
s
h
o
w
i
n
g
a
p
p
r
o
v
a
l
s
E
x
a
m
p
l
e
:
A
t
t
a
c
h
“
f
o
r
w
a
r
d
e
d
”
e
m
a
i
l
a
p
p
r
o
v
a
l
.
T
h
i
s
i
s
a
n
u
p
l
o
a
d
o
f
t
h
e
O
u
t
l
o
o
k
e
m
a
i
l
a
W
o
r
k
d
a
y
J
o
u
r
n
a
l
a
t
t
a
c
h
m
e
n
t
.
D
o
u
s
e
p
r
i
n
t
e
d
o
r
c
o
p
i
e
d
t
e
x
t
f
r
o
m
a
n
e
m
a
i
l
.
13
13
Workday
Outlook
O
n
l
y
i
n
c
l
u
d
e
r
e
l
e
v
a
n
t
p
o
r
t
i
o
n
o
f
s
u
p
p
o
r
t
i
n
g
d
o
c
u
m
e
n
t
s
•
When a journal entry relies on information from a large data file (such
as a contract or multi-page report), include a screenshot of the
journal-relevant backup rather than the large data file
•
Ensure backup documents are legible (not blurry, readable font size,
etc.)
•
Large data file must be made available to Finance and auditors upon
request, for up to current year+7 years.
•
Where a report of financial data is the subledger data, the complete
file is needed
•
Example: if only the budget is relevant to the Journal, only
include screenshots of the budget pages, labeling the excerpt
to reference the large data file.
•
14
14
O
n
l
y
i
n
c
l
u
d
e
r
e
l
e
v
a
n
t
p
o
r
t
i
o
n
o
f
s
u
p
p
o
r
t
i
n
g
d
o
c
u
m
e
n
t
s
E
x
a
m
p
l
e
:
I
n
c
l
u
d
e
a
s
c
r
e
e
n
s
h
o
t
o
f
t
h
e
i
n
f
o
r
m
a
t
i
o
n
r
e
l
a
t
e
d
t
o
t
h
e
j
o
u
r
n
a
l
,
n
o
t
t
h
e
f
u
l
l
d
o
c
u
m
e
n
t
15
15
Questions?
FinServices@algonquincollege.com
A checklist outlining the documentation and steps needed to provide approvers and auditors with complete details for ensuring the reasonableness and accuracy of journal entries.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Journal Entry Backup Checklist
What is Journal Entry Backup? The documentation needed to provide Journal approvers and auditors with the complete details needed to ensuring its reasonableness and accuracy. support the journal, 2
Checklist 1. Show all calculations 2. Provide reference & backup to show the source of dollar amounts 3. Include a journal entry summary tab in complex spreadsheets 4. Redact/remove and/or do not submit confidential information 5. Include relevant email trails showing approvals 6. Only include relevant portion of supporting documents 3
Show All Calculations When a journal entry amount is based on a calculation, the calculation must be substantiated with all data points The preferred backup is an Excel sheet Always include all detailed information A PDF or Word document showing only partial information or lacking relevant calculations is not sufficient 4
Show All Calculations Example: The attached Excel file includes relevant calculations 5
Provide reference & backup to show the source of dollar amounts Provide documentation showing the original amounts used in all calculations (include report screenshots) Remember to highlight and/or circle the relevant transaction(s) and please reference page number(s) where these can be found Revenue/Expenses are not recognized until they are recorded in the General Ledger. When transferring expenses, GL references are the only valid backup Example: specific EXPJ-##########, SINJ-##########, etc., or a printout of the FIN RPT - Financial Rollup Report, or bank statements showing transaction 6
Provide reference and backup to show the source of dollar amounts Example: Journal Sequence Number information is highlighted 7
Include summary sheet for complex spreadsheets 1. If the calculations in an Excel spreadsheet involve multiple tabs or are complex, add a Summary Sheet tab that cell-references other sheets and summarizes the values of the Journal Entry 2. Include annotations that explain what is being referenced and how it is relevant to the journal 3. Remember that all calculation details must be included and a summary alone is not adequate 8
Include a journal entry summary tab in complex spreadsheets Example: Summary Sheet is the tab that ties the detail sheets to the journal entry dollar values 1 3 1 2 1. Summary Sheet and cell-references 2. Annotation 3. Detailed calculation sheets 9
Redact/remove and/or do not submit confidential information Personal or confidential information cannot be included Redact confidential information including but not limited to: Investment account and bank account transit numbers Credit card numbers Employee names Birthdays Addresses Payroll reports Student names and other student information, marks, etc. Other confidential information 10
Cont. - Redact/remove and/or do not submit confidential information Confidential information backup can be retained by the originating department and made available to Finance and auditors upon request To ensure compliance see Policy IT01 and the Algonquin College Privacy Statement: https://www.algonquincollege.com/policies/files/2021/01/IT01.pdf https://www.algonquincollege.com/policies/privacy/ NOTE: Confidential information backup files must be retained by the originating department for current year+7 years 11
Include relevant email trails showing approvals Where relevant to the journal entry, ensure all prior approvals are in place and included in the journal entry backup. E.g., email showing approval The Forward response should be used by the approving manager for email backups so the files that have been reviewed are included in the approval email Do not submit a Reply response because the reviewed and approved files will not be included and therefore the approval cannot be assumed to be for the dollar amounts in the journal entry 12
Include relevant email trails showing approvals Example: Attach forwarded email approval. This is an upload of the Outlook email a Workday Journal attachment. Do use printed or copied text from an email. Outlook Workday 13
Only include relevant portion of supporting documents When a journal entry relies on information from a large data file (such as a contract or multi-page report), include a screenshot of the journal-relevant backup rather than the large data file Ensure backup documents are legible (not blurry, readable font size, etc.) Large data file must be made available to Finance and auditors upon request, for up to current year+7 years. Where a report of financial data is the subledger data, the complete file is needed Example: if only the budget is relevant to the Journal, only include screenshots of the budget pages, labeling the excerpt to reference the large data file. 14
Only include relevant portion of supporting documents Example: Include a screenshot of the information related to the journal, not the full document 15
Questions? FinServices@algonquincollege.com
