Webclass 45: Quick win: Bank Statement review – the first place to look according to CFO of major French Group

Q1. Where did the CFO of a French supermarket say was the first place to look to find fraud? (single choice)

'In the bank statements

Correct Incorrect Correct answer

In the general ledger

Correct Incorrect Correct answer

Q2. What example did we give as to a potential fraud scenario? (single choice)

A user updates the data directly in the treasury system and then enters manual journal entries to adjust the balance and total movements to the general ledger account that relates to the house bank

Correct Incorrect Correct answer

A user updates the payment data in the SAP system before this information is sent through the treasury system to pay the suppliers

Correct Incorrect Correct answer

Q3. What controls might we seek to strengthen if we see that there are employees that have access to the payment order file in the Windows folder? (single choice)

Windows access and folder security

Correct Incorrect Correct answer

Badge access logs

Correct Incorrect Correct answer

Q4. Why might we want to compare the PDF bank statements to the SAP general ledger data? (single choice)

To see if there are payment lines in the bank statements that do not exist in the general ledger, or to see if there are payment lines in the bank statements that are different in value, than those in the general ledger, or to see if there are values in the bank statements and in the general ledger, but that the accounting scheme is not as expected (ie an adjustment to hide the difference following an illigitimate payment)

Correct Incorrect Correct answer

To see the value of payments over time

Correct Incorrect Correct answer

Q5. Why might we want to automate the import of data from PDF bank statements? (single choice)

Because maybe we have a lot of PDF bank statements, and automating the task could make the process quicker – also we might want to repeat the exercise in following years, or for entities having similar bank statement format

Correct Incorrect Correct answer

Because automating PDF bank statement import will enable us to more easily take a sample from the table that is generated.

Correct Incorrect Correct answer

Q6. What other tools, other than ACL, could we use to automate the import and conversion into table format of unstructured data such as bank statements? (single choice)

Python

Correct Incorrect Correct answer

SQL

Correct Incorrect Correct answer

Q7. Do we have to be a programmer to be able to automate the import of a PDF bank statement? (single choice)

No, we can use the ACL user interface and copy-paste from the log to automate the import. However, if the PDF bank statement is not very harmonized then we might use a bit of ACL programming knowledge to optimize the import process.

Correct Incorrect Correct answer

Yes, to automate the import of PDFs into ACL, only someone who has advanced ACL programming skills can do it

Correct Incorrect Correct answer

Q8. Why might we want to visualize the imported bank statements and their comparison to SAP? (single choice)

Visualization helps us to immediately see the % value of issues so that as an auditor, we know if we need to spend any time on this topic. Furthermore, with visualization, we can then easily see trends in the differences: for example if there are documents that have very different values, if there are differences occurring for one particular bank account, if there are differences occuring at the same period of the year

Correct Incorrect Correct answer

The visualization's main purpose is to help us to see the detailed records concerning the differences

Correct Incorrect Correct answer

Q9. How does the scatter chart help us to identify issues? (single choice)

Each dot on the scatter chart represents one combination of bank account + date, the value on the Y axis shows the value for the dot in the SAP system and the value on the X axis shows the value from the PDF statement. Any dot that is on the Y axis (with zero on the x) would be for account+date found in SAP and not PDF. Any found on X (with zero on the Y) would be for account + date found in PDF not SAP. Any dots that are found below the diagonal would be for the value on the PDF (the actual bank value) that was higher than the value that was posted in the accounts

Correct Incorrect Correct answer

The scatter chart helps us to see the average value of bank-out transactions

Correct Incorrect Correct answer

Q10. Why might we also consult the dashboard about strange journal entries for bank adjustments? (single choice)

Because the fraudster, who manages to take money out of the bank, will not want the difference between the bank statement and the general ledger to be detected during the month-end bank reconciliation. Therefore, they would enter bank adjustments or a journal entry that credits bank and debits an account that is not closely monitored (such as a generic cost account that is not attached to a cost center or a suspense account, for which the items posted are not individually cleared)

Correct Incorrect Correct answer

Because the fraudster will need to enter a manual journal entry in order to cause the bank to emit the unauthorized funds.

Correct Incorrect Correct answer

WC045 – Quick win: bank statement review – the first place to look according to CFO of major French group

Quizzes

Participants 13

Webclass 45: Quick win: Bank Statement review – the first place to look according to CFO of major French Group

admin June 9, 2026

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question