CAUTION: Read Appendix B for specific instructions recurg luwese templates. 1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (") will appear to the right of an incorrect answer. 2. A formula begins with an equals sign ) and can consist of any of the following elements: Operators such as + (for addition), - (for subtraction). * (for multiplication), and/ (for division). Cell references, including cell addresses such as B52, as well as named cells and ranges Values and text Worksheet functions (such as SUM) 14 3. You can enter a formula into a cell manually (typing it in) or by pointing to the cells. 15 To enter a formula manually, follow these steps: 16 Move the cell pointer to the cell that you want to hold the formula 17 Type an equals sign (=) to signal the fact that the cell contains a formula. 18 Type the formula, then press Enter. 19 20 4. Rounding These templates have been formatted to round numbers to either the nearest whole number or the nearest cent. For example, 21 1765 x 15=26.475. The template will display and hold 26.48, not 26.475. There is no need to use Excel's founding function 23 5 Remember to save your work When saving your workbook, Excel overwrites the previous copy of your file. You can save your work at any time 24 You can save the file to the current name, or you may want to keep multiple versions of your work by saving each successive version under a differes 25 To save to the current name, you can select File, Save from the menu bar or click on the disk icon in the standard toolbar 26 It is recommended that you save the file to a new name that identifies the file as yours, such as Chapter_7_long_version_Your Name xlsx 27 To save under a different name, follow these steps: 28 Select Save As to display the Save As Type deop-box, chose Excel Workbook ("xlsx) 29 Select the folder wuch to store the workbook 30 Enter the new filename is the file name box 31 Click Save Excel Instructions loma General Ledger Payroll Register Employees' Earnings Records Type here to search Of S Payroll Project Excel Template - 2018 (1) - Excel Draw Formulas Data View Home Insert Page Layout Review Help Arial 10 AAE - Cut Copy ~ Format Painter Clipboard 5 12 Wrap Text Merge & Center BI U Font Alignment A B LE JOURNAL Page 42 DATE DESCRIPTION POST. REF DEBIT CREDIT 20 Oct. 527 2,307.69 4,651.08 3,600.00 5,219.60 23 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable - OASDI FICA Taxes Payable-HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payablo Group Insurance Premiums Collected Union Dues Payable Payroll Cash 20.1 20.2 24 25 25.1 26 27 28 12 978.26 228.80 1,148.00 484.42 11.07 615.43 181.20 16.00 12.115.19 23 Payroll Taxes FICATs Payable - OASDI FICA Tax Payablo - HI 1.386 96 56 20.1 20.2 978. 26 228.79 Total debts and credits (calculated automatically) 124,528 47 124,528.47 Your debits and credits should be equal after each journal ontry is complete Cumulative Journal Checkpoint Through Month Ending October 31, 20 December 31, 20- 398 124528 AT Tovember 30, 20 January 31, 20- 401 berstructions Journal General Ledger Payroll Register Type here to search Employees Earnings Records AutoSave OHH Home Insert Draw File Page Layout Formulas Data He Review View & fcut Arial 10 AA === Ove Wrap Tex Merge & Copy Format Painter Paste BIUR A Clipboard Font Alignment C164 co E F JOURNAL Page 4 DATE DESCRIPTION POSTI REF DEBIT CREDIT 20- Oct 2.307.69 4,651.08 3,600.00 ,219.60 23 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Group Insurance Premiums Collected Union Dues Payable Payroll Cash 51 52 53 545 20.11 202 24 25 25.1 26 27 28 12 978.26 228.80 1,148.00 484.42 11.07 615.43 181 20 16.00 12,115.19 23 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - H 56 20.1 1.396 961 20.2 978.26 228.79 394 Total debits and credits (calculated automatically) 124,528.47 124,528.47 Your debits and credits should be equal after each journal entry is complete Cumulative Journal Checkpoint Through Month Ending 397 58.544 96 October 31, 20- December 31, 20- 398 124 528.47 November 30, 20 - January 31, 20- 399 395 396 400 401 Anal Excel Instructions Journal General Ledger Payroll Register Employees' Earnings R Type here to search Payroll Project Excel Template - 2018 (1) - Excel Draw AutoSave On File Home Insert 9 X aut Page Layout Formulas Data Review Help View 10 AA Arial BIB = E 2 Wrap Text Merge & Center w 3 Copy A Format Painter Clipboard Alignment C164 C JOURNAL Page 43 DESCRIPTION DEBIT CREDIT DATE 20 Nov 77 6 Payroll Carsh Cash 12 11.893.42 11.893.42 51 52 2,307.69 4,605,85 3.600 00 4.908 00 53 6 Administrative Salarios Office Salaries Sales Salaries Plant Wages FICA Taxes Payable - OASDI FICA Taxes Payable-HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Union Dues Payable Payroll Cash 20.1 202 24 25 25 1 955,53 223.49 1,238.00 473 16 1082 601.12 16.00 11.893.42 28 396 Total debits and credits (calculated automatically) 124,528 47 124 528 47 Your debts and credits should be equal for cach journal entry is complete Cumulative Journal Checkpoint Through Month Ending 397 58.54496 October 31, 20 December 31, 20- 6 124 598 47 November 30, 20 January 31, 20 Excel instructions Journal General Ledger Payroll Register Employees Earnings Records Type here to search 8 Payroll Project Excel Template 2018 (1) - Excel Search Draw Page Layout Formulas Data Review View Help Arial - 10 AA = 33 2 Wrap Text BTU - B A EEE 3Merge & Center w $ AutoSave O B File Home Insert A Xat Copy Format Painter Clipboard 5 C164 . X 4 102 103 % Number Alignment f E F L . Page 44 JOURNAL DESCRIPTION DEBIT CREDIT 107 106) Nov 52207932 201 202 13 Otce Salaries FICA Taxes Payable - OASDI FICA Taxes Payable-HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Group Insurance Premium Collected Payrol Cash 24 25 128.92 30.15 331.00 83 84 1.46 81.10 14 40 1.428 45 25.1 12 13 Payroll Taxes 56 FICATES Payable - OASDI 20.1 128.92 FICA Tours Payable-HI 20.2 30.15 121 16 FICA Taxes Payabe-OASDI 201 3.873.17 Totaldobits and credits (calculated automatically 124,528.47 124,528 47 3815 Your debts and credits should be equal after each journal entry is complete Cumulative Journal Checkpoint Through Month Ending 397 58.64496 October 31, 20 December 31, 20 340 124 523 47 November 30, 20 January 31, 20- 001 the instructions Journal General Ledger Payroll Register Employees Earnings Records Type here to search DOLI Search AutoSave R S Payroll Project Excel Template 2018 (1) Excel Page Layout Formulas Data Review View Help File Home Insert Draw 8 Xan P -In Copy Tomat Painter 10 A AA = E E 2Wrap Text Merge & Center BTU $ % Alignment C164 - X fo DE 26 27 Employees CIT Payable Group Insurance Premiums Collected Union Dues Payable SIMPLE Contributions Payable Payrol Cash FILM 543 02 166.80 16.00 1.850 00 216 00 29 129 JOURNAL Page 45 DESCRIPTION DEBIT CREDIT 1.113.15 20 Payroll Taxes FICA Taxos Payable - OASDI FICA Taxes Payable-HI SUTA Tasos Payable - Employer 201 202 383 17 201 87 Total debits and credits (calculated automatically 124,528.47 124,528 47 Your debts and credits should be equal for each journal entry is complete Cumulative Journal Checkpoint Through Month Ending 391 58.644 October 31, 20- December 31, 20- 12450841 November 30, 20- January 31, 20- cel instructions Journal General Ledger Payroll Register Employees Earnings Records Type here to search O e DO AutoSave E Search File Home Insert A Xcut Ih Copy - Format Painter Draw Arial BIU Payroll Project Excel Temp2010 U Page Layout Formulas Data Review - 10 AA ===> BB A View Help Wrap Tent Merge & Center $ % 58- Insert De Conditional Formatas Cell Formatting Table Styles Styles Number A BCDEFGHIJKLMNOPQRST U V W X Y ZM ABAC PAYROLL REGISTER GLO-BRITE PAINT COMPANY Time Record Regular Earnings Overtime Earnings Vantar Status NO WH Alow Rate Per Total F IT 86.00 59 ON J 60 RV 61 Hyan, N Rate Per S M T W T F S S M T W T F S Hrs Hour Amount Hrs Hour Amount Earnings 8 8 8 8 8 8 8 8 8 8 80 2,307 69 2,307 69 6 8 8 8 8 8B88B78 1.170.00 1.17000 M4BBBBBBB 888 00 18.00 1,440.00 1.440.00 S2BBB 8 8 8 8 8 8 8 80 205000 2,050.00 S1 8B 884 88 8 8 4 72 14.00 1,000.00 1.008.00 QASDI 143 00 72 541 89 28 127 10 62.501 HI 33.46 16.97 20.88 29.731 14.621 9800 29.00 249.00 97.00 6 30 13.922 0823 18 20109182800427 20 For Period Ending November 20 20 TOTALS Payday, December TO A 11 erguson 72 ford, c. a Mano 14 Wood General de Payroll Register Employees Earnings Records e type here to search CAUTION: Read Appendix B for specific instructions recurg luwese templates. 1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (") will appear to the right of an incorrect answer. 2. A formula begins with an equals sign ) and can consist of any of the following elements: Operators such as + (for addition), - (for subtraction). * (for multiplication), and/ (for division). Cell references, including cell addresses such as B52, as well as named cells and ranges Values and text Worksheet functions (such as SUM) 14 3. You can enter a formula into a cell manually (typing it in) or by pointing to the cells. 15 To enter a formula manually, follow these steps: 16 Move the cell pointer to the cell that you want to hold the formula 17 Type an equals sign (=) to signal the fact that the cell contains a formula. 18 Type the formula, then press Enter. 19 20 4. Rounding These templates have been formatted to round numbers to either the nearest whole number or the nearest cent. For example, 21 1765 x 15=26.475. The template will display and hold 26.48, not 26.475. There is no need to use Excel's founding function 23 5 Remember to save your work When saving your workbook, Excel overwrites the previous copy of your file. You can save your work at any time 24 You can save the file to the current name, or you may want to keep multiple versions of your work by saving each successive version under a differes 25 To save to the current name, you can select File, Save from the menu bar or click on the disk icon in the standard toolbar 26 It is recommended that you save the file to a new name that identifies the file as yours, such as Chapter_7_long_version_Your Name xlsx 27 To save under a different name, follow these steps: 28 Select Save As to display the Save As Type deop-box, chose Excel Workbook ("xlsx) 29 Select the folder wuch to store the workbook 30 Enter the new filename is the file name box 31 Click Save Excel Instructions loma General Ledger Payroll Register Employees' Earnings Records Type here to search Of S Payroll Project Excel Template - 2018 (1) - Excel Draw Formulas Data View Home Insert Page Layout Review Help Arial 10 AAE - Cut Copy ~ Format Painter Clipboard 5 12 Wrap Text Merge & Center BI U Font Alignment A B LE JOURNAL Page 42 DATE DESCRIPTION POST. REF DEBIT CREDIT 20 Oct. 527 2,307.69 4,651.08 3,600.00 5,219.60 23 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable - OASDI FICA Taxes Payable-HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payablo Group Insurance Premiums Collected Union Dues Payable Payroll Cash 20.1 20.2 24 25 25.1 26 27 28 12 978.26 228.80 1,148.00 484.42 11.07 615.43 181.20 16.00 12.115.19 23 Payroll Taxes FICATs Payable - OASDI FICA Tax Payablo - HI 1.386 96 56 20.1 20.2 978. 26 228.79 Total debts and credits (calculated automatically) 124,528 47 124,528.47 Your debits and credits should be equal after each journal ontry is complete Cumulative Journal Checkpoint Through Month Ending October 31, 20 December 31, 20- 398 124528 AT Tovember 30, 20 January 31, 20- 401 berstructions Journal General Ledger Payroll Register Type here to search Employees Earnings Records AutoSave OHH Home Insert Draw File Page Layout Formulas Data He Review View & fcut Arial 10 AA === Ove Wrap Tex Merge & Copy Format Painter Paste BIUR A Clipboard Font Alignment C164 co E F JOURNAL Page 4 DATE DESCRIPTION POSTI REF DEBIT CREDIT 20- Oct 2.307.69 4,651.08 3,600.00 ,219.60 23 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Group Insurance Premiums Collected Union Dues Payable Payroll Cash 51 52 53 545 20.11 202 24 25 25.1 26 27 28 12 978.26 228.80 1,148.00 484.42 11.07 615.43 181 20 16.00 12,115.19 23 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - H 56 20.1 1.396 961 20.2 978.26 228.79 394 Total debits and credits (calculated automatically) 124,528.47 124,528.47 Your debits and credits should be equal after each journal entry is complete Cumulative Journal Checkpoint Through Month Ending 397 58.544 96 October 31, 20- December 31, 20- 398 124 528.47 November 30, 20 - January 31, 20- 399 395 396 400 401 Anal Excel Instructions Journal General Ledger Payroll Register Employees' Earnings R Type here to search Payroll Project Excel Template - 2018 (1) - Excel Draw AutoSave On File Home Insert 9 X aut Page Layout Formulas Data Review Help View 10 AA Arial BIB = E 2 Wrap Text Merge & Center w 3 Copy A Format Painter Clipboard Alignment C164 C JOURNAL Page 43 DESCRIPTION DEBIT CREDIT DATE 20 Nov 77 6 Payroll Carsh Cash 12 11.893.42 11.893.42 51 52 2,307.69 4,605,85 3.600 00 4.908 00 53 6 Administrative Salarios Office Salaries Sales Salaries Plant Wages FICA Taxes Payable - OASDI FICA Taxes Payable-HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Union Dues Payable Payroll Cash 20.1 202 24 25 25 1 955,53 223.49 1,238.00 473 16 1082 601.12 16.00 11.893.42 28 396 Total debits and credits (calculated automatically) 124,528 47 124 528 47 Your debts and credits should be equal for cach journal entry is complete Cumulative Journal Checkpoint Through Month Ending 397 58.54496 October 31, 20 December 31, 20- 6 124 598 47 November 30, 20 January 31, 20 Excel instructions Journal General Ledger Payroll Register Employees Earnings Records Type here to search 8 Payroll Project Excel Template 2018 (1) - Excel Search Draw Page Layout Formulas Data Review View Help Arial - 10 AA = 33 2 Wrap Text BTU - B A EEE 3Merge & Center w $ AutoSave O B File Home Insert A Xat Copy Format Painter Clipboard 5 C164 . X 4 102 103 % Number Alignment f E F L . Page 44 JOURNAL DESCRIPTION DEBIT CREDIT 107 106) Nov 52207932 201 202 13 Otce Salaries FICA Taxes Payable - OASDI FICA Taxes Payable-HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Group Insurance Premium Collected Payrol Cash 24 25 128.92 30.15 331.00 83 84 1.46 81.10 14 40 1.428 45 25.1 12 13 Payroll Taxes 56 FICATES Payable - OASDI 20.1 128.92 FICA Tours Payable-HI 20.2 30.15 121 16 FICA Taxes Payabe-OASDI 201 3.873.17 Totaldobits and credits (calculated automatically 124,528.47 124,528 47 3815 Your debts and credits should be equal after each journal entry is complete Cumulative Journal Checkpoint Through Month Ending 397 58.64496 October 31, 20 December 31, 20 340 124 523 47 November 30, 20 January 31, 20- 001 the instructions Journal General Ledger Payroll Register Employees Earnings Records Type here to search DOLI Search AutoSave R S Payroll Project Excel Template 2018 (1) Excel Page Layout Formulas Data Review View Help File Home Insert Draw 8 Xan P -In Copy Tomat Painter 10 A AA = E E 2Wrap Text Merge & Center BTU $ % Alignment C164 - X fo DE 26 27 Employees CIT Payable Group Insurance Premiums Collected Union Dues Payable SIMPLE Contributions Payable Payrol Cash FILM 543 02 166.80 16.00 1.850 00 216 00 29 129 JOURNAL Page 45 DESCRIPTION DEBIT CREDIT 1.113.15 20 Payroll Taxes FICA Taxos Payable - OASDI FICA Taxes Payable-HI SUTA Tasos Payable - Employer 201 202 383 17 201 87 Total debits and credits (calculated automatically 124,528.47 124,528 47 Your debts and credits should be equal for each journal entry is complete Cumulative Journal Checkpoint Through Month Ending 391 58.644 October 31, 20- December 31, 20- 12450841 November 30, 20- January 31, 20- cel instructions Journal General Ledger Payroll Register Employees Earnings Records Type here to search O e DO AutoSave E Search File Home Insert A Xcut Ih Copy - Format Painter Draw Arial BIU Payroll Project Excel Temp2010 U Page Layout Formulas Data Review - 10 AA ===> BB A View Help Wrap Tent Merge & Center $ % 58- Insert De Conditional Formatas Cell Formatting Table Styles Styles Number A BCDEFGHIJKLMNOPQRST U V W X Y ZM ABAC PAYROLL REGISTER GLO-BRITE PAINT COMPANY Time Record Regular Earnings Overtime Earnings Vantar Status NO WH Alow Rate Per Total F IT 86.00 59 ON J 60 RV 61 Hyan, N Rate Per S M T W T F S S M T W T F S Hrs Hour Amount Hrs Hour Amount Earnings 8 8 8 8 8 8 8 8 8 8 80 2,307 69 2,307 69 6 8 8 8 8 8B88B78 1.170.00 1.17000 M4BBBBBBB 888 00 18.00 1,440.00 1.440.00 S2BBB 8 8 8 8 8 8 8 80 205000 2,050.00 S1 8B 884 88 8 8 4 72 14.00 1,000.00 1.008.00 QASDI 143 00 72 541 89 28 127 10 62.501 HI 33.46 16.97 20.88 29.731 14.621 9800 29.00 249.00 97.00 6 30 13.922 0823 18 20109182800427 20 For Period Ending November 20 20 TOTALS Payday, December TO A 11 erguson 72 ford, c. a Mano 14 Wood General de Payroll Register Employees Earnings Records e type here to search