Part $2$: General Ledger Analytics

In this part of your assignment, you will examine the Data Analytics General Ledger Excel file. Please complete the following tasks using the Excel file:

Q$1.$ Analyze unusual journal entries based on the time of day.

a$.$

Using the data provided in the Excel file, identify any entries made after $9$ p$.$m$.$ and before $6$ a$.$m$.$

in $2022.$

b$.$ Are there any entries you want to discuss with management? If so$,$ what questions do you have?

Are there any additional audit procedures you think need to be performed?

Q$2.$ Evaluate unusual journal entries based upon the date transactions were entered into the general ledger. Alpine Cupcakes' official holidays are July $4$th$,$ New Year's Day, and Christmas Day. On those days, the business office is closed. The Alpine Storefront is open every day, so those entries will appear on weekends and holidays. The business office is open Monday through Friday, closed on Saturday and

Sunday.

a$.$ Using the data provided in the Excel file, identify any unusual journal entries made on holidays in

$2022.$ Recall that the Storefront is open on holidays.

b$.$

Using the data provided in the Excel file, identify any unusual entries made on weekends in $2022.$

Recall the Storefront is open on weekends, so you are looking for business office entries made on

c$.$ Are there any entries you want to discuss with management? If so$,$ what questions do you have?

Are there any additional audit procedures you think need to be performed?

Q$3.$ Analyze unusual journal entries in $2022$ that are made by unauthorized persons. List the exceptions in order of journal entry number $($smallest to largest$).$ Also, indicate who should have made the entry for each exception you find. You can use the Chart of Accounts to see who is authorized to make the entries in each account.

Q$4.$ Using the data provided in the Excel file, identify any unusual journal entries made in $2022$ that were above the authorization limit$.$ List your entries in order of journal entry number $($smallest to largest$).$

You can use the details provided in the Excel file to determine authorization limits by employee.

Q$5.$ Using the data provided in the Excel file, identify any journal entries made in $2022$ that were made just below the threshold limits $($$$0\mathrm{.}01-$$$200$ below limits provided$).$ Put your entries in order of journal entry number $($smallest to largest$).$ You can use the details provided in the Excel file to determine authorization limits by employee.

Q$6.$ Using the data provided in the Excel file, identify the top $15$ highest dollar journal entries made during

$2022.$ List the journal entries by journal entry number $($smallest to largest$).$ Provide a description of the purpose of the high$-$dollar transactions.

Q$7.$ Using the data provided in the Excel file, identify any duplicate journal entries $($they have the same dollar amount and account numbers$)$ greater than $$4,000$ made during $2022.$ Provide a description of the high dollar amount transactions. Put your entries in order of journal entry number $($smallest to largest$).$

Q$8.$ Round amounts.

a$.$

Using the data provided in the Excel file, identify any journal entries that are in even amounts made during $2022.$ For this exercise, even amounts are defined as anything in the $100\text{'}$s$.$ You only need to analyze the cash, accounts receivable and accounts payable accounts. Enter the entire journal entry in two categories $1)$ monthly round amounts $--$ only need to enter first month $2)$ all other round amounts. Enter in order of journal entry number $($smallest to largest$).$

b$.$

Note any entries you believe need further investigation; explain why you believe further investigation is warranted.

$09.$ Compare a select number of accounts in $2022$ to the same accounts in $2021.$ The accounts to analyze are provided in the Excel file.

a$.$ Using the data provided in the Excel file, compare selected accounts between the two years.

Analyze the change in the dollar amount and number of transactions for the accounts. Create a visualization $($chart$,$ graph or table$)$ to display your results.

What might you conclude from analyzing these accounts about Alpine Cupcakes' business?