Analytical Procedures to identify accounts that have large fluctuations that will require additional testing.
PLEASE PREPARE A MEMO WITH YOUR FINDINGS FROM THE EXCEL SPREAD SHEET
THE EXCEL WORK HAS BEEN DONE AS SEEN BELOW: PLEASE WRITE MEMO FOR FINDINGS
A B C D E F G H 1 j K L M N 1 Instructions 2 Analytical Procedures to identify accounts that have large fluctuations that will require additional testing. 3 Prepare an Excel Spreadsheet (using the template found on Blackboard) that shows: 4 5 1 The dollar difference between the 2019 and 2020 numbers. Highlight each amount that is material (exceeds $50,000, positive or negative). 6 7 8 2 The percentage difference between the 2019 and 2020 numbers (Difference/2018 number). Highlight each difference that is material (exceeds 10%, positive or negative). 9 10 11 3 Place an X in the "Both" column for accounts that meet both criteria. This identifies accounts will require additional testing. 12 13 STATEMENT OF ACTIVITIES YEARS ENDED DECEMBER 31, 2020 AND 2019 12/31/20 3,276,531 403,778 277,914 12/31/19 1,892,295 320,635 167,645 INCOME Legacy and Wills Grants Placement Donations Contributions Annual Appeal Capital Campaign Spay & Neuter Retail Store Donations Publication Donation Thank Yous Tributes and Memorials Unsolicited Donations Outreach Donations Memberships Clinic Reimbursements Investment Income Unrealized and Realized Gains on Sale Trust Income Special Events Retail Store Income 265,761 30,000 645,948 15,433 46,407 26,669 131,280 339,933 124,631 3,430 831,150 151,633 (283,199) (164,710) 1,066,131 209,387 405,086 739,319 503,726 14,000 39,852 20,772 146,932 270,859 154,303 7,095 556,645 178,331 335,972 349,160 1,221,278 215,557 TOTAL INCOME 7,398, 107 7,539,462 EXPENSES Accounting Advertising Animal Care Automobile Expenses Bank Service Charges Communications IT/Computer Expenses and Services Intependent Contractor and Professional Fees Depreciation Dues and Subscriptions Payroll Equipment Insurance Interest Expense Legal Services Office Supplies Rent Repairs and Maintenance Utilities Miscellaneous 12/31/20 15,500 64,415 1,330,312 23,019 59,037 0 183,278 2,686 530,322 0 3,837,247 59,333 60,439 171,993 3,011 212,052 7,594 577,668 235,730 7,645 12/31/19 15,700 70,884 1,236,906 20,620 48, 108 35,808 101,553 22,316 407,438 5,578 3,545,466 63,082 65,506 169,726 7,173 236,258 9,196 631,023 183,305 50,503 TOTAL EXPENSES 7,381,281 6,926,149 CHANGE IN NET ASSETS 16,826 613,313 STATEMENT OF ACTIVITIES YEARS ENDED DECEMBER 31, 2020 AND 2019 12/31/20 3,276,531 403,778 277,914 12/31/19 1,892.295 320.635 167,645 Percentage Difference 73% 26% 66% Both X X X X X INCOME Legacy and Wills Grants Placement Donations Contributions Annual Appeal Capital Campaign Spay & Neuter Retail Store Donations Publication Donation Thank Yous Tributes and Memorials Unsolicited Donations Outreach Donations Memberships Clinic Reimbursements Investment Income Unrealized and Realized Gains on Sale Trust Income Special Events Retail Store Income 265,761 30,000 645,948 15,433 46,407 26,669 131,280 339.933 124,631 3,430 831,150 151,633 (283,199) (164,710) 1,066,131 209,387 X Dollar Difference 1,384,236 83,143 110,269 0 (139,325) (709,319) 142,222 1,433 6,555 5,897 (15,652) 69,074 (29,672) (3,665) 274,505 (26,698) (619,171) (513,870) (155,147) (6,170) 405,086 739,319 503,726 14,000 39,852 20,772 146,932 270,859 154,303 7,095 556,645 178,331 335,972 349,160 1,221,278 215,557 -34% -96% 28% 10% 16% 28% -11% 26% -19% -52% 49% -15% -184% -147% -13% -3% X X X X TOTAL INCOME 7,398, 107 7,539,462 Both X X EXPENSES Accounting Advertising Animal Care Automobile Expenses Bank Service Charges Communications IT/Computer Expenses and Services Independent Contractor and Professional Fees Depreciation Dues and Subscriptions Payroll Equipment Insurance Interest Expense Legal Services Office Supplies Rent Repairs and Maintenance Utilities Miscellaneous 12/31/20 15,500 64,415 1,330,312 23,019 59,037 0 183,278 2,686 530,322 0 3,837,247 59,333 60,439 171,993 3,011 212,052 7,594 577,668 235,730 7,645 12/31/19 15,700 70,884 1,236,906 20,620 48, 108 35,808 101,553 22,316 407,438 5,578 3,545,466 63,082 65,506 169,726 7,173 236,258 9,196 631,023 183,305 50,503 Dollar Difference (200) (6,469) 93,406 2,399 10,929 (35,808) 81,725 (19,630) 122,884 (5,578) 291,781 (3,749) (5,067) 2,267 (4,162) (24,206) (1,602) (53,355) 52,425 (42,858) Percentage Difference -1% -9% 8% 12% 23% -100% 80% -88% 30% -100% 8% -6% -8% 1% -58% -10% -17% -8% 29% -85% X X TOTAL EXPENSES 7,381,281 6,926, 149 CHANGE IN NET ASSETS 16,826 613,313 A B C D E F G H 1 j K L M N 1 Instructions 2 Analytical Procedures to identify accounts that have large fluctuations that will require additional testing. 3 Prepare an Excel Spreadsheet (using the template found on Blackboard) that shows: 4 5 1 The dollar difference between the 2019 and 2020 numbers. Highlight each amount that is material (exceeds $50,000, positive or negative). 6 7 8 2 The percentage difference between the 2019 and 2020 numbers (Difference/2018 number). Highlight each difference that is material (exceeds 10%, positive or negative). 9 10 11 3 Place an X in the "Both" column for accounts that meet both criteria. This identifies accounts will require additional testing. 12 13 STATEMENT OF ACTIVITIES YEARS ENDED DECEMBER 31, 2020 AND 2019 12/31/20 3,276,531 403,778 277,914 12/31/19 1,892,295 320,635 167,645 INCOME Legacy and Wills Grants Placement Donations Contributions Annual Appeal Capital Campaign Spay & Neuter Retail Store Donations Publication Donation Thank Yous Tributes and Memorials Unsolicited Donations Outreach Donations Memberships Clinic Reimbursements Investment Income Unrealized and Realized Gains on Sale Trust Income Special Events Retail Store Income 265,761 30,000 645,948 15,433 46,407 26,669 131,280 339,933 124,631 3,430 831,150 151,633 (283,199) (164,710) 1,066,131 209,387 405,086 739,319 503,726 14,000 39,852 20,772 146,932 270,859 154,303 7,095 556,645 178,331 335,972 349,160 1,221,278 215,557 TOTAL INCOME 7,398, 107 7,539,462 EXPENSES Accounting Advertising Animal Care Automobile Expenses Bank Service Charges Communications IT/Computer Expenses and Services Intependent Contractor and Professional Fees Depreciation Dues and Subscriptions Payroll Equipment Insurance Interest Expense Legal Services Office Supplies Rent Repairs and Maintenance Utilities Miscellaneous 12/31/20 15,500 64,415 1,330,312 23,019 59,037 0 183,278 2,686 530,322 0 3,837,247 59,333 60,439 171,993 3,011 212,052 7,594 577,668 235,730 7,645 12/31/19 15,700 70,884 1,236,906 20,620 48, 108 35,808 101,553 22,316 407,438 5,578 3,545,466 63,082 65,506 169,726 7,173 236,258 9,196 631,023 183,305 50,503 TOTAL EXPENSES 7,381,281 6,926,149 CHANGE IN NET ASSETS 16,826 613,313 STATEMENT OF ACTIVITIES YEARS ENDED DECEMBER 31, 2020 AND 2019 12/31/20 3,276,531 403,778 277,914 12/31/19 1,892.295 320.635 167,645 Percentage Difference 73% 26% 66% Both X X X X X INCOME Legacy and Wills Grants Placement Donations Contributions Annual Appeal Capital Campaign Spay & Neuter Retail Store Donations Publication Donation Thank Yous Tributes and Memorials Unsolicited Donations Outreach Donations Memberships Clinic Reimbursements Investment Income Unrealized and Realized Gains on Sale Trust Income Special Events Retail Store Income 265,761 30,000 645,948 15,433 46,407 26,669 131,280 339.933 124,631 3,430 831,150 151,633 (283,199) (164,710) 1,066,131 209,387 X Dollar Difference 1,384,236 83,143 110,269 0 (139,325) (709,319) 142,222 1,433 6,555 5,897 (15,652) 69,074 (29,672) (3,665) 274,505 (26,698) (619,171) (513,870) (155,147) (6,170) 405,086 739,319 503,726 14,000 39,852 20,772 146,932 270,859 154,303 7,095 556,645 178,331 335,972 349,160 1,221,278 215,557 -34% -96% 28% 10% 16% 28% -11% 26% -19% -52% 49% -15% -184% -147% -13% -3% X X X X TOTAL INCOME 7,398, 107 7,539,462 Both X X EXPENSES Accounting Advertising Animal Care Automobile Expenses Bank Service Charges Communications IT/Computer Expenses and Services Independent Contractor and Professional Fees Depreciation Dues and Subscriptions Payroll Equipment Insurance Interest Expense Legal Services Office Supplies Rent Repairs and Maintenance Utilities Miscellaneous 12/31/20 15,500 64,415 1,330,312 23,019 59,037 0 183,278 2,686 530,322 0 3,837,247 59,333 60,439 171,993 3,011 212,052 7,594 577,668 235,730 7,645 12/31/19 15,700 70,884 1,236,906 20,620 48, 108 35,808 101,553 22,316 407,438 5,578 3,545,466 63,082 65,506 169,726 7,173 236,258 9,196 631,023 183,305 50,503 Dollar Difference (200) (6,469) 93,406 2,399 10,929 (35,808) 81,725 (19,630) 122,884 (5,578) 291,781 (3,749) (5,067) 2,267 (4,162) (24,206) (1,602) (53,355) 52,425 (42,858) Percentage Difference -1% -9% 8% 12% 23% -100% 80% -88% 30% -100% 8% -6% -8% 1% -58% -10% -17% -8% 29% -85% X X TOTAL EXPENSES 7,381,281 6,926, 149 CHANGE IN NET ASSETS 16,826 613,313
