Workpaper project, could someone explain it. My professor wasn't helpful explaining.

Start with the Lead Sheet I recommend that you do this on Excel 1. Format it using the Balance Sheet and Income Statement 2. A will be the Balance Sheet 3. A1 will be the Income Statement & any other accounts. Next set-up Sub-Lead sheets 4. B will be cash: within the B family will be all the cash workpapers. Example B1, B2 Et All the B workpapers flow back to B which will eventually flow back to A and l. 5. Accounts Receivables C 6. Note Receivable D 7. Revenue R 8. Expenses X For this assignment we will concentrate mostly on the Cash B workpapers. Each workpaper should contain the following: Center Top Company Name Workpaper Name Year End Date Top Right Corner Workpaper number Ex. B Your Initials Date you started workpaper 9. Prepare Bank reconciliations for Checking & Payroll. 10. Select items to test: use Random Table. 11. Prepare Adjusting Entries Register Checking 15,220.00 11,000.00 2 4 123.00 85,116.00 26,953.00 35,110.00 160.00 1,952.00 4,568.00 4,472.00 98,989.00 40,302.00 48.00 11 13 14 87.00 324,100.00 Note: underlined items are open Random Table Checking Account Payroll Account Sample size 3 1 19 14 600 82 16 17 23 1 Sample size 18 2 39 7 28 38 5 47 37 44 11 30 N 17 13 55 3 Register Payroll Register Payroll 1p 2 p 3P 4p 5 p 6 p 7p 8 p 9 p 10 p 11 p 1,250.00 1,685.00 25,441.00 2,534.00 525.00 4,410.00 1,252.00 2,500.00 5,544.00 8,952.00 1,258.00 5,487.00 9,635.00 8,569.00 2,356.00 6,523.00 85.00 1,258.00 12 p 13 p 14 p 15 p 16 p 17 p 18 p 19 p 8,569.00 42 p 2,356.00 43 p 6,523.00 44 p 747.00 45 p 1,258.00 46 p 9,356.00 47 p 7,487.00 48 p 1,287.00 49 p 7,854.00 50 p 65.00 51 p 4,787.00 52 p 26,200.00 53 p 47,300.00 54 p 51,200.00 55 p 56,530.00 56 p 37,220.00 57 p 4,410.00 58 p 1,252.00 59 p 2,500.00 60p 5,544.00 61 p 8,952.00 62 p 1,258.00 63 p 5,487.00 64 p 9,635.00 65 p 8,569.00 66 p 2,356.00 67 p 6,523.00 68 p 47.00 69 p 1,258.00 70 p 9,356.00 71 p 7,487.00 72 p 1,287.00 73 p 7,854.00 74 p 365.00 75 p 9,356.00 20 p 7,487.00 1,287.00 21 p 22 p 23 p 24 p 25 p 26 p 27 p 28 p 29 p 30 p 7,854.00 365.00 4,787.00 5,544.00 8,952.00 1,258.00 5,487.00 9,635.00 8,569.00 2,356.00 6,523.00 99.00 1,258.00 31 p 32 p 33 p 34 p 68 p 27 p 28 p 29 p 30 p 31 p 32 p 33 p 34 p 35 p 36 p 37 p 38 p 39 p 40 p 1,258.00 5,487.00 9,635.00 8,569.00 2,356.00 6,523.00 99.00 1,258.00 9,356.00 7,487.00 1,287.00 6,523.00 47.00 1,258.00 9,356.00 7,487.00 1,287.00 7,854.00 365.00 4,787.00 5,544.00 8,952.00 1,258.00 5,487.00 9,635.00 5,487.00 9,635.00 69 p 70 p 71 p 72 p 73 p 74 p 75 p 76 p 77 p 78 p 79 p 80 p 81 p 82 p 83 p 7,854.00 2,675.00 4,787.00 2,809.00 41 p 610,000.00 206,336.00 403,664.00 Register Petty Savings Money MKT 50.00 55,000.00 250,000.00 12.00 25.00 62.00 44.00 125.00 318.00 55,000.00 250,000.00 Start with the Lead Sheet I recommend that you do this on Excel 1. Format it using the Balance Sheet and Income Statement 2. A will be the Balance Sheet 3. A1 will be the Income Statement & any other accounts. Next set-up Sub-Lead sheets 4. B will be cash: within the B family will be all the cash workpapers. Example B1, B2 Et All the B workpapers flow back to B which will eventually flow back to A and l. 5. Accounts Receivables C 6. Note Receivable D 7. Revenue R 8. Expenses X For this assignment we will concentrate mostly on the Cash B workpapers. Each workpaper should contain the following: Center Top Company Name Workpaper Name Year End Date Top Right Corner Workpaper number Ex. B Your Initials Date you started workpaper 9. Prepare Bank reconciliations for Checking & Payroll. 10. Select items to test: use Random Table. 11. Prepare Adjusting Entries Register Checking 15,220.00 11,000.00 2 4 123.00 85,116.00 26,953.00 35,110.00 160.00 1,952.00 4,568.00 4,472.00 98,989.00 40,302.00 48.00 11 13 14 87.00 324,100.00 Note: underlined items are open Random Table Checking Account Payroll Account Sample size 3 1 19 14 600 82 16 17 23 1 Sample size 18 2 39 7 28 38 5 47 37 44 11 30 N 17 13 55 3 Register Payroll Register Payroll 1p 2 p 3P 4p 5 p 6 p 7p 8 p 9 p 10 p 11 p 1,250.00 1,685.00 25,441.00 2,534.00 525.00 4,410.00 1,252.00 2,500.00 5,544.00 8,952.00 1,258.00 5,487.00 9,635.00 8,569.00 2,356.00 6,523.00 85.00 1,258.00 12 p 13 p 14 p 15 p 16 p 17 p 18 p 19 p 8,569.00 42 p 2,356.00 43 p 6,523.00 44 p 747.00 45 p 1,258.00 46 p 9,356.00 47 p 7,487.00 48 p 1,287.00 49 p 7,854.00 50 p 65.00 51 p 4,787.00 52 p 26,200.00 53 p 47,300.00 54 p 51,200.00 55 p 56,530.00 56 p 37,220.00 57 p 4,410.00 58 p 1,252.00 59 p 2,500.00 60p 5,544.00 61 p 8,952.00 62 p 1,258.00 63 p 5,487.00 64 p 9,635.00 65 p 8,569.00 66 p 2,356.00 67 p 6,523.00 68 p 47.00 69 p 1,258.00 70 p 9,356.00 71 p 7,487.00 72 p 1,287.00 73 p 7,854.00 74 p 365.00 75 p 9,356.00 20 p 7,487.00 1,287.00 21 p 22 p 23 p 24 p 25 p 26 p 27 p 28 p 29 p 30 p 7,854.00 365.00 4,787.00 5,544.00 8,952.00 1,258.00 5,487.00 9,635.00 8,569.00 2,356.00 6,523.00 99.00 1,258.00 31 p 32 p 33 p 34 p 68 p 27 p 28 p 29 p 30 p 31 p 32 p 33 p 34 p 35 p 36 p 37 p 38 p 39 p 40 p 1,258.00 5,487.00 9,635.00 8,569.00 2,356.00 6,523.00 99.00 1,258.00 9,356.00 7,487.00 1,287.00 6,523.00 47.00 1,258.00 9,356.00 7,487.00 1,287.00 7,854.00 365.00 4,787.00 5,544.00 8,952.00 1,258.00 5,487.00 9,635.00 5,487.00 9,635.00 69 p 70 p 71 p 72 p 73 p 74 p 75 p 76 p 77 p 78 p 79 p 80 p 81 p 82 p 83 p 7,854.00 2,675.00 4,787.00 2,809.00 41 p 610,000.00 206,336.00 403,664.00 Register Petty Savings Money MKT 50.00 55,000.00 250,000.00 12.00 25.00 62.00 44.00 125.00 318.00 55,000.00 250,000.00