Date Format: Allow printing in batches for all forms 3. MM, DD, YYYY. Use long date format on screen and in reports Create accounts to match the following Chart of Accounts: Account types are shown in brackets beside the account. (A) = Subgroup (S) = Subgroup total (H) = Heading (T) = Total (X) = Current Earnings All other accounts (unmarked) are Group accounts. Allow division allocations for all revenue and expense accounts. 1000 CURRENT ASSETS (H) 1040 Test Balance 2650 HST Charged on Sales (A) 1060 Undeposited Cash and Cheques 2670 HST Paid on Purchases (A) 1080 Bank: CAD Chequing 2750 HST Owing (Refund) (S) 1090 Bank: USD Chequing 2800 TOTAL CURRENT LIABILITIES (T) 1 100 Bank: Credit Card -2810 LONG TERM LIABILITIES (H) 1200 Accounts Receivable 2850 Mortgage Payable 1240 Advances Receivable 2890 TOTAL LONG TERM LIABILITIES (T) 1260 Purchase Prepayments 1280 Sterilized Needles 3000 EQUITY (H) 1320 Other Supplies 3560 D. Zines, Capital 1390 TOTAL CURRENT ASSETS (T) 3600 Net Income (X) 3690 TOTAL EQUITY (T) 1400 INVENTORY (H) 1420 Tattoo Designs 4000 REVENUE (H) 1440 Ink 4020 Revenue from Sales 1490 TOTAL INVENTORY (T) 4060 Revenue from Design 4100 Sales Discounts 1600 PLANT & EQUIPMENT (H) 4390 TOTAL REVENUE (T) 1620 Computers and Video Monitors 1640 Sterilization Equipment 5000 EXPENSES (H) 1660 Tattoo Equipment 5010 Credit Card & Bank Fees 1680 Store Fixtures and Displays 5015 Exchange Rate Differences 1690 Store 5020 Store Maintenance 1695 TOTAL PLANT & EQUIPMENT (T) 5030 Adjustment Write-Off 2000 CURRENT LIABILITIES (H) 5060 Cost of Goods Sold 2100 Bank Loan 5070 Cost of Services 2150 Credit Card Payable 5100 Purchase Discounts 2200 Accounts Payable 5200 Freight Expense 2240 Prepaid Sales and Deposits 5220 Supplies Used 2300 Vacation Payable 5230 Interest Expense 23 10 EI Payable (A) 5260 Utilities 2320 CPP Payable (A) 5300 Wages 2330 Income Tax Payable (A) 5310 EI Expense 2340 Receiver General Payable (S) 5320 CPP Expense 2360 EHT Payable 5330 WSIB Expense 2380 Medical Payable 5360 EHT Expense 2390 Tuition Payable 5380 Medical Expense 2400 CSB Plan Payable 5400 Tuition Expense 2460 WSIB Payable 5490 TOTAL EXPENSES (T) Print the Chart of Accounts for reference.Hints: Use Payroll cheque run. Accept: Payroll Tables are out of date 19. Back up the data files. Continue with the file DERMAL.SAI. Change the session date to April 15, 2022. Enter the following transactions: Purchase Invoice #SD-986 Dated April 11, 2022 To fill Purchase Order #55 From Skin Decals, Inc. 20 Designs - Small ($13 ea) $260.00 10 Designs - Medium ($27 ea) 270.00 10 Designs - Large ($58 ea) 580.00 Courier Freight Charge 40.00 HST Paid 149.50 Invoice Total $1 299.50 Terms: 1/10, net 30 (new payment terms). Allocate 100% of freight expense to Sales Division. Memo #3 Dated April 11, 2022 Several boxes of supplies and inventory were damaged after a prolonged power failure. The following items were not usable and should be written off: Sterilized needles $120 Other supplies $80 Tattoo gun $250 30 tubes Ink - Permanent Colour accept cost price 20 tubes Ink - Temporary Colour accept cost price Allocate 100% of the cost of equipment and supplies to the Services division and 100% of the cost of damaged ink inventory to the Sales division. Create new General Ledger Group expense account 5210 Damaged Supplies and Equipment. (Hint: two journal entries are required.) Cash Receipt #358 Dated April 11, 2022 From Wanda Wonder, cheque #344 for $901.67 in payment of invoice #3110, taking into account 1% sales discount of $9.11 for early payment. Cash Receipt #359 Dated April 11, 2022 From Stan Stoner, cheque #2789 for $1 000 as deposit #107 in prepayment for tattoo work to be completed over several weeks. Sales Invoice #3112 Dated April 13, 2022 To Stan Stoner 4 Designs - Large $100 each 10 Ink - Permanent Outline 10 /tube 40 Ink - Permanent Colour 10 /tube 20 Tattoo application 80 /session HST Charged 13 % Terms: 1/15, net 30 Allocate 100% of sales to Sales Division and 100% of services to services Division. Accept message. Computerized Accounting with Sage 50 Level 2 (S120) Final Project 1 Page 13