{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Journals"],"not_rendered":{"charts":0,"images":55,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Journals","index":0,"n_rows":130,"n_cols":9,"rows_kept":130,"cut":false,"hidden":false,"merged":[[0,1,0,6],[7,2,7,11],[11,2,11,11],[34,3,34,11],[35,3,35,11],[9,2,10,12],[13,2,14,12],[23,2,24,12],[26,2,26,11],[32,3,32,11],[2,1,2,12],[22,2,22,11],[4,2,4,11],[8,2,8,11],[12,2,12,11],[16,2,16,11],[37,2,37,11],[47,2,47,11],[51,2,51,11],[69,5,69,12],[93,2,93,11],[86,2,87,12],[61,2,61,11],[65,2,65,11],[73,2,73,11],[71,5,71,12],[116,2,116,11],[120,2,120,11],[57,2,57,11],[82,2,82,11],[85,2,85,11],[89,2,89,11],[94,2,95,12],[117,2,118,12],[30,2,30,11],[31,3,31,11],[127,2,127,4],[124,2,125,12],[33,3,33,11],[62,2,63,12],[48,2,49,12],[38,2,39,12],[79,2,80,12],[41,2,41,11],[36,3,36,4],[123,2,123,11],[97,2,97,11],[103,2,103,11],[107,2,107,11],[111,2,111,11]]}
[null,"Understanding your journals system"]
[]
[null,"The questions below are designed for your auditor to get a better understanding of your system over journals which will assist in the risk identification process and ensure that the procedures performed are relevant to your organisation"]
[]
[null,1,"Do you use automatically reversing journal entries?"]
[null,null,null,"Yes"]
[null,null,null,"No"]
[]
[null,null,"If yes, is any manual intervention required to reverse the journal or is it entirely automatic?  "]
[]
[]
[]
[null,null,"If no, how does the client ensure that the journals requiring reversal have been reversed?  "]
[]
[]
[]
[null,2,"Is it possible to match the journal with the reversing journal?"]
[null,null,null,"System identified which shows which journals are reversals, but not the original journal it reversed"]
[null,null,null,"System identifies which journals are reversals and which journals they are reversing"]
[null,null,null,"Client can run a report which excludes the original journal and the reversal"]
[null,null,null,"No"]
[null,null,null,"Other"]
[null,null,"Explain how we could match the original journal with the reversing journal"]
[]
[]
[]
[null,4,"Is there independent approval of manual journals?"]
[null,null,null,"Yes"]
[null,null,null,"No"]
[]
[null,6,"What is involved in the nature, timing and extent of approval of journals?"]
[null,null,null,"Agree to supporting documentation"]
[null,null,null,"Ensure the journal balances"]
[null,null,null,"Discussion with the preparer to understand the purpose of the journal"]
[null,null,null,"Ensuring the account codes are correct"]
[null,null,null,"Ensuring the journal is correct, for example DR and CR the right way round etc"]
[null,null,null,"Other"]
[null,null,"If other, document"]
[]
[]
[]
[null,7,"How is independent review evidenced?"]
[null,null,null,"Review is not evidenced"]
[null,null,null,"System control - preparer and reviewer must sign-off in the FMIS, cannot post without independent review"]
[null,null,null,"Logged in the FMIS, but system allows a journal to be posted without an independent review"]
[null,null,null,"Preparer and reviewer manually sign a hard-copy of the documentation"]
[null,null,null,"Other"]
[null,null,"If other, please explain"]
[]
[]
[]
[null,8,"When are journal entries typically posted? Would it be unusual for journals to be processed at night? During the weekend?"]
[null,null,null,"Standard working hours only"]
[null,null,null,"Regularly work extra hours - evenings only"]
[null,null,null,"Regularly work extra hours - weekends only"]
[null,null,null,"Regularly work extra hours - evenings and weekends"]
[]
[null,9,"Are there any super-users who can post journals?"]
[null,null,null,"Yes - Super users can prepare and post their own journals"]
[null,null,null,"Yes - Super users can only post or prepare their own journals, not both"]
[null,null,null,"No"]
[null,null,"Describe who the supervisors are and what they are expected to do"]
[]
[]
[]
[null,10,"Is there any oversight of the journal entry-posting process by members of management, internal auditors, or others, including post-entry review, other than those who originally approved the journal? If so what is the nature, timing, and extent of review required? What documentation is expected?"]
[null,null,null,"Internal audit undertake reviews of journals "]
[null,null,null,"Management review actuals against budget on a monthly basis, which may identify unusual activity"]
[null,null,null,"Management perform random review of some journals each month"]
[null,null,null,"Other, explain"]
[]
[null,null,null,"No"]
[]
[null,11,"When entering a journal, how are the general ledger accounts for the debits and credits selected? Is this a manual process? Or is the selection limited by the system based on the type of journal?"]
[null,null,null,"Manually selected, no system checks"]
[null,null,null,"GL codes available are limited by the type of journal"]
[null,null,null,"Only certain users can post to certain accounts"]
[null,null,null,"Other"]
[null,null,"Describe"]
[]
[]
[]
[null,12,"Can journal entries be populated by uploading a file, such as an excel or csv file? "]
[null,null,null,"Yes"]
[null,null,null,"No"]
[null,null,"If yes, what controls are there over this process?"]
[]
[]
[]
[null,13,"How are journals numbered (or otherwise identified)? Are numbers assigned manually or are they system generated? Is the numbering sequential? Are there different numbering schemes different types of journals? "]
[null,null,null,"Manually selected, no system allocated numbers"]
[null,null,null,"Sequentially numbered by the system, all transactions the same"]
[null,null,null,"Sequentially numbered by the system, different numbering system for each type of transaction"]
[null,null,"If each type of journal has a specific numbering system, describe how this works.  "]
[]
[]
[]
[null,14,"Can journal entries be deleted? If so, can a deleted/parked journal still be viewed in the system for reference purposes?"]
[null,null,null,"Yes - Only before a journal has been posted"]
[null,null,null,"Yes - Before or after it has been posted"]
[null,null,null,"No - Can't be viewed after it has been deleted"]
[null,null,null,"No - Journals cannot be deleted"]
[]
[null,15,"If journals can be deleted before posting or after, can the journal number still be viewed in the system for reference purposes?"]
[null,null,null,"Yes"]
[null,null,null,"No"]
[]
[null,16,"What happens to the journal number for a deleted journal?"]
[null,null,null,"Journal number is re-used"]
[null,null,null,"Journal number is held and not re-used"]
[]
[null,17,"How do you ensure that all journals have been entered and posted at month/year-end?  "]
[null,null,null,"Rely on staff knowing what is required"]
[null,null,null,"Checklist of standard journals required in month-end / year-end instructions"]
[null,null,null,"Report is run at month-end / year-end to identify any journals prepared and not posted"]
[null,null,null,"Other"]
[null,null,"If other, please describe"]
[]
[]
[]
[null,18,"Are you or others involved in the financial reporting process aware of any inappropriate or unusual activity relating to the processing of journals and other adjustments?"]
[null,null,null,"Yes"]
[null,null,null,"No"]
[null,null,"If yes, describe:"]
[]
[]
[]
[null,null,"Completed by:",null,null,null,null,null,"Checked by:"]
[]
[null,null,"Date:",null,null,null,null,null,"Date:"]