Webclass 100: If you don't do this before your data analytics project, you risk getting it all wrong!

Q1. What are four possible reasons for the general ledger data that you extracted not matching the trial balance?

1/ Journal entries were removed from the file that you received; 2/ The date field that was used to filter the data was not the posting date but the input date or the document date; 3/ A filter was applied on a business area, posting key, the wrong company code, etc. 4/ The data was accidentally truncated because it was exported to Excel (which is limited to around 1M lines, because of a special character or one of the files not being transferred via FPT)

Correct Incorrect Correct answer

1/ The data was extracted without using a SAP extractor tool; 2/ The data was filtered on the posting date rather than the document date; 3/ The data contains the periods 13 to 16; 4/ The IT department forgot to filter on the business area

Correct Incorrect Correct answer

Q2. If you are using a SAP extractor, then the data extracted can never be incomplete?

False: the data can still be incomplete if one of the files is not copied over to the data analytics server or if there are special characters in the data that prevent data import, for the rest of the file

Correct Incorrect Correct answer

True: using a data extractor provides 100% confidence that the data obtained from SAP will be complete and accurate

Correct Incorrect Correct answer

Q3. If you are using a SAP extractor, then the data extracted can never be incomplete?

False: the data can still be incomplete if one of the files is not copied over to the data analytics server or if there are special characters in the data that prevent data import, for the rest of the file

Correct Incorrect Correct answer

True: using a data extractor provides 100% confidence that the data obtained from SAP will be complete and accurate

Correct Incorrect Correct answer

Q4. Is the auditor more objective if they obtain the data directly from the system or if they obtain the data from the business?

From the system

Correct Incorrect Correct answer

From the business

Correct Incorrect Correct answer

Q5. When doing data reconciliations we will analyze the balances per account on the balance sheet.

False: data reconciliation is about checking that the transactional data obtained is complete and accurate and is done before going on to balance sheet analysis or other types of analysis

Correct Incorrect Correct answer

True: when doing data reconciliation we will calculate the opening and closing balance per general ledger account

Correct Incorrect Correct answer

Q6. When doing a reconciliation between the general ledger and the trial balance, we should look at the total debit and credit or we should look at the net

Net

Correct Incorrect Correct answer

Total debit and credit

Correct Incorrect Correct answer

Q7. When doing a reconciliation between the general ledger and the trial balance, we should include the periods 13 to 16

Yes

Correct Incorrect Correct answer

No

Correct Incorrect Correct answer

Q8. Which table in SAP will help us to know the calendar date of the beginning of the fiscal period?

T009B

Correct Incorrect Correct answer

T001

Correct Incorrect Correct answer

Q9. Is there a possibility within SAP that the BSAK/BSIK lines can be different to the K lines in the BSEG table?

No, because the BSEG table is like a view of the BSAK/BSIK table and other tables

Correct Incorrect Correct answer

Yes, due to an update following closing

Correct Incorrect Correct answer

Q10. How might process mining help you during the reconciliation process?

You can check whether or not the operational data (purchase orders and sales orders, etc) is of the same order of magnitude as the financial data

Correct Incorrect Correct answer

You can check whether or not the financial data matches the balance sheet and P&L

Correct Incorrect Correct answer

Webclass 100: If you don't do this before your data analytics project, you risk getting it all wrong!

Webclass 100: If you don’t do this before your data analytics project, you risk getting it all wrong!

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