Scenario:

On a monthly basis prior to closing the books, the Accounting Manager performs a flux analysis on the balance sheet and profit & loss statement (P&L).  For any variance greater than $2.5k AND 10% from prior month the Accounting Manager analyzes to ensure the change is appropriate.  In addition for accounts that do not change, the Accounting Manager is assessing if no change is appropriate.

Company Specifics:

In December 2020, the Company began offering overtime pay at twice their regular hourly rate to referral employees to clear out backlogs.

Documents provided:

November 2011 flux analysis snip - no flux comments provided purposely (yellow tab)

Trial balance of some accounts for the month ending 12/31/20

Formatting Notes:

Dates are in mm-yyyy format in this workbook

Deliverables:

Create flux comments, applying the thresholds utilized by the Accounting Manager, for December 2020

Account	10-2020	11-2020	PM vs CM $	PM vs CM %	Flux Analysis	PM Avg	Variance this month from avg	% Variance from Avg
5010 · Salaries - Referral	840,747.24	828,076.73	(12,670.51)	-2%		728,650.02	99,426.71	14%
5015 · Payroll Taxes - Referral	67,796.11	67,758.37	(37.74)	0%		62,443.86	5,314.51	9%

Account	Month Ending December 31, 2020
5010 · Salaries - Referral	1,038,759.42
5015 · Payroll Taxes - Referral	94,679.11