Final Project 2 Computerized Accounting with Sage 50 Level 2 SI2O Copyright 2022 Project Code: SI1O v7-0 Project 2 Released: July 2012 Revised: January 20, 2022 Computerized Accounting with Simply Level 2 (SI2O) Final Project 2 no. 1 Computerized Accounting with Sage 50 Level 2 The Dog House INTRODUCTION This project will test your understanding of the Sage 50 Accounting application and your ability to apply the features of this application. You will be using many of the skills that you have acquired throughout the course to set up the accounts for a small business and record typical transactions. OBJECTIVES The objectives of this project are to: Set up the General, Payable, Receivable, Payroll, and Inventory ledgers for a small company Record transactions Print reports TIME REQUIRED You will require 10 hours to complete this project. MATERIALS REQUIRED To complete project, you will require: Windows 10 Sage 50 Accounting 2021 MARKING The project will be marked out of 100. Individual marks for requirements are shown below. Marks will be deducted if you ask anyone for help. The instructor will only answer questions regarding the meaning and interpretation of a step. You may refer to your textbook. If the project is not completed within the given time frame, 2 marks per additional hour will be deducted. For each typographical error, a further 0.5 mark deduction will be made. Journal Entries 60 marks Balance Sheet 20 marks Income Statement 10 marks Employee Summary Report 5 marks Inventory Summary Report 5 marks Computerized Accounting with Simply Level 2 (SI2O) Final Project 2 no. 2 PROJECT SPECIFICATIONS The information provided in this test allows you to set up all ledgers for an Ontario company named THE DOG HOUSE. The Dog House specializes in sales of large purebred and pedigreed dogs. In addition, they sell cages or dog houses, and high quality dog food. Some of the dog food is purchased from a supplier in the United States. The manager of the store provides some basic dog grooming services while the assistant works mostly in store sales and caring for the animals that are for sale. Two divisionssales and servicesare set up to allocate expenses and revenues. All ledgers are used. 1. Using Sage 50 Accounting, make a new company file using the following information: Company Name: The Dog House - (Your Name) NOTE: Be sure to include your name as part of the company name so the reports you print and hand in to your instructor will be properly identified. Address: 460 Barque St. London, Ontario, N9L 4B6 Phone: Fiscal start: (519) 523-8191 04-01-2024 Fax: (519) 525-8819 Earliest transaction date: 04-01-2024 Fiscal end: 06-30-2024 Select: made a new company Select: Let me build the list of accounts myself after the company is made Industry: Retail Select: I will update my tax information myself. Store company files in a new folder named DOGHOUSE and use DOGHOUSE as the file name. 2. Change the default settings if necessary to include the following: User Preferences - Options Use Accounting Terms Automatically save changes to suppliers, customers & other records Show list buttons - View Turn off Checklists and Daily Business Manager at startup and after changing session date Show Change Session Date at startup - Transaction Turn on Confirmation Message Box Company Settings: - Information Business No: 388 123 909 - System Do not allow transactions dated before 04-01-2024 Do not allow transactions in future - Backup Backup frequency: Weekly; turn off automatic backups - Features All features used - Forms Next Sales Invoice number 1121 Next Sales Quote number 45 Next Receipts number 1522 Next Customer Deposits number 36 Next Purchase Order number 1001 Next Direct Deposit Stubs- Employee number 34 Computerized Accounting with Simply Level 2 (SI2O) Final Project 2 no. 3 Verify sequence number for all forms Allow printing in batches for all forms Date Format MM-DD-YYYY; Use long date format on the screen and in reports 3. made

accounts to match the following Chart of Account: 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 Edit the current earnings account THE DOG HOUSE: Chart of Accounts 1000 CURRENT ASSETS (H) 1050 Test Balance 1060 Undeposited Cash & Cheques 1080 Bank: CAD Chequing 1090 Bank: USD Chequing 1100 Bank: Credit Card 1200 Accounts Receivable 1240 Advances Receivable 1260 Purchase Prepayments 1280 Food Supplies 1300 Other Supplies 1390 TOTAL CURRENT ASSETS (T) 1400 INVENTORY (H) 1420 Purebred Dogs 1440 Dog Food 1460 Dog Houses 1490 TOTAL INVENTORY (T) 1500 PLANT & EQUIPMENT (H) 1550 Computer/Cash Register 1580 Store Fixtures and Cages 1590 TOTAL PLANT & EQUIPMENT (T) 2000 CURRENT LIABILITIES (H) 2100 Bank Loan 2150 Credit Card Payable 2200 Accounts Payable 2250 Prepaid Sales and Deposits 2300 Vacation Payable 2310 EI Payable (A) 2320 CPP Payable (A) 2330 Income Tax Payable (A) 2340 Receiver General Payable (S) 2400 RRSP Payable 2420 Medical-MSP Payable 2460 WSIB Payable 2650 HST Charged on Sales (A) 2670 HST Paid on Purchases (A) 2750 HST Owing (Refund) (S) 2900 TOTAL CURRENT LIABILITIES (T) 3000 OWNER'S EQUITY (H) 3560 A. Katz, Capital 3600 Net Income (X) 3690 TOTAL OWNER'S EQUITY (T) 4000 REVENUE (H) 4020 Revenue from Sales 4050 Revenue from Services 4100 Sales Discounts 4200 Freight Revenue 4390 TOTAL REVENUE (T) 5000 EXPENSES (H) 5010 Bank & Credit Card Fees 5015 Exchange Rate Differences 5020 Cleaning and Maintenance 5030 Adjustment Write-Off 5040 Item Assembly Costs 5060 Cost of Goods Sold 5070 Cost of Services 5100 Purchase Discounts 5200 Freight Expense 5220 Dog Food Used 5240 Rent 5260 Utilities 5280 Veterinary Consultation 5300 Wages 5310 EI Expense 5320 CPP Expense 5330 WCB Expense 5400 Medical-MSP Expense 5420 Car Expenses 5490 TOTAL EXPENSES (T) Computerized Accounting with Simply Level 2 (SI2O) Final Project 2 no. 4 Print the Chart of Accounts for reference. 4. Add account balances from the following Trial Balance: THE DOG HOUSE Post-Closing Trial Balance: April 1, 2024 1080 Bank: CAD Chequing $24 289 1090 Bank: USD Chequing 860 (CAD) 1100 Bank: Credit Card 2 200 1200 Accounts Receivable 1 500 1280 Food Supplies 540 1300 Other Supplies 400 1420 Purebred Dogs 5 200 1440 Dog Food 3 500 1460 Dog Houses 3,600 1550 Computer/Cash Register 6 500 1580 Store Fixtures and Cages 4 500 2150 Credit Card Payable $ 1 200 2200 Accounts Payable 3 800 2310 EI Payable 81 2320 CPP Payable 217 2330 Income Tax Payable 661 3560 A. Katz, Capital 47 130 $53 089 $53 089 Print the Trial Balance for referen ce. 5. Add foreign currency. Allow transactions with United States suppliers in US dollars. Use account 5015 to track exchange rate differences. Enter 1.20 as the exchange rate for April 1, 2024. Display the reminder if the rate is one day old. 6. Edit the Account Classes. Undeposited Cash & Cheques. Change the account class to Cash. CAD Chequing account. Change the account class to Bank. Enter 501 as the next cheque number and 14 as next deposit slip number. USD Chequing account. Change the account class to Bank and enter 1023 as the next cheque number. Change the currency to USD and enter $715 as the USD balance. Bank: Credit Card. Change the account class to Credit Card Receivable. Accounts Receivable. Change the account class to Accounts Receivable Inventory Accounts: Change the account class to Inventory Credit Card Payable. Change the account class to Credit Card Payable. Accounts Payable. Change the account class to Accounts Payable Expense accounts: Change the account class to Expense for all Expense Group accounts. 7. Set up credit cards as follows: Cards Accepted: Credit Card Name: SpendMore Currency: CAD Computerized Accounting with Simply Level 2 (SI2O) Final Project 2 Page 5 Linked Asset Account: 1100 Discount Fee: 3.5% Linked Expense Account: 5010 Cards Used: Credit Card Name: SpendMore Linked Payable Account: 2150 Linked Expense Account: 5010 8. Enter Sales Taxes and Tax Codes Tax - HST: Not Exempt, Not Taxable, Use 2670 to track tax paid on purchases Use 2650 to track taxes charged on sales, Report on taxes Code - H: Tax HST, Taxable, Rate 13%, Not included, Refundable Code - HI: Tax HST, Taxable, Rate 13%, Included, Refundable 9. Enter the ledger settings. Leave unused linked accounts blank. Allow account classes to change. General: Linked Accounts Retained Earnings 3560 Net Income 3600 Payables Settings: Address London, Ontario, Canada - Linked Accounts Principal Bank Account for CAD 1080 Principal Bank Account for USD 1090 Accounts Payable 2200 Freight Expense 5200 Early Payment Purchase Discount 5100 Prepayments and Prepaid Orders 1260 Receivable Settings: Address London, Ontario, Canada - Options Aging periods: 10, 30 and 45 days No interest charges on overdue accounts Include invoices paid in last 31 days Default tax code for new customers is H - Discount Payment terms: 2% after tax discount in 10 days; net 30 days Line discounts are not used - Comments On Sales Invoices: Thank you. - Linked Accounts Principal Bank Account for CAD 1060 Principal Bank Account for USD 1090 Accounts Receivable 1200 Default Revenue Leave blank Freight Revenue 4200 Early Payment Sales Discount 4100 Deposits and Prepaid Orders 2250 Employee & Payroll Settings: Names - Income & Deductions Income 1: Salary Income 2: Commission Income 3: No. Dogs Income 4: Car Expense Delete other Income names Deduction 1: RRSP Delete other Deduction names using Incomes set up tool Names - Additional Payroll Worker's Comp: WSIB Computerized Accounting with Simply Level 2 (SI2O) Final Project 2 Page 6 User Defined Expense 1: Medical-MSP (this is an employee benefit) Delete other User-Defined Expense names Entitlement 1: Vacation Entitlement 2: Sick Leave Delete other Entitlement names Incomes Overtime 1: (Type - Hourly rate) Calculate tax, EI, Insurable Hours, CPP and vacation Salary: (Type - Income) Calculate tax, EI, Insurable Hours and CPP Commission: Type - Income Calculate tax, EI and CPP No. Dogs: (Type - Piece Rate; Unit of measure - Number) Calculate tax, EI, CPP and vacation Car Expense: (Type - Reimbursement) No taxes apply Deductions RRSP by amount before calculating tax Taxes: EI factor is 1.4 WSIB rate is 1.55 Entitlements Vacation: Track - 8%; Maximum - 25 days; Do not clear at Year-end Sick Leave: Track - 2.5%; Maximum - 10 days; Clear at Year-end Linked Accounts - Incomes Bank 1080 Vacation Owed 2300 Advances & Loans 1240 Use 5300 for Vacation Earned, Regular, Overtime 1, Salary, Commission and No. Dogs Use 5420 for Car Expense - Deductions RRSP 2400 - Taxes: EI (Payable) 2310 CPP (Payable) 2320 Tax (Payable) 2330 WSIB (Payable) 2460 EI (Expense) 5310 CPP (Expense) 5320 WSIB (Expense) 5330 - User-defined Expenses: Payable- 2420 Medical-MSP Inventory Settings: Expense -5400 Medical-MSP - Options Sort by description Profit evaluation by markup Do not allow inventory to drop below zero. - Linked Accounts Item Assembly Costs 5040 Adjustment Write-off 5030 Division Settings: Allocate payroll transactions by percentage Warn if allocation is not complete Allow access to Allocate field using Tab key Computerized Accounting with Simply Level 2 (SI2O) Final Project 2 Page 7 10. made the following supplier accounts with historical information: Name (Contact), Address Phone/Fax Options, Tax, Account Kanine Kibble (Chewzon Bone) Tel: (716) 492-6282 Terms: 2/15, n/30 (after tax) 88 Benjie Cres, Buffalo, New York, USA 14209 Fax: (716) 492-8164 Tax Code: H Currency: USD Web site: www.chow.com/dogs Supplier Since 04/01/2016 Kennelworth Pound (Leo Wolfe) Tel: (519) 774-7109 Terms: 1/10, n/30 (after tax) 440 Rover Circle, St. Mary, Ontario N8T 7F3 Fax: (250) 774-7799 Tax Code: H Tax ID: 672 213 992 E-mail: w..e@dogscape.com Supplier Since 03/01/2015 Pooch Veterinarian Services (Warren Fox) Tel: (519) 526-7191 Terms: 2/5, n/15 (after tax) 33 Lassie Lane, Viscount, ON N9R 2V7 Tax Code: H Tax ID: 887 210 092 Expense Account: E-mail: w..x@poochvs.com 5280 Veterinary Consultation Historical Supplier Invoices and Payments Supplier Since 02/04/2015 Name Terms Date Invoice/Chq Amount Kanine Kibble 2/15, n/30 after tax Mar 15/24 KK-402 $242 USD (300 CAD) Kennelworth Pound 1/10, n/30 (after tax) Mar 25/24 KP-6621 $5 500 Mar 27/24 Chq 488 -3 000 Mar 30/24 KP-6808 1 000 Balance owing $3 500 Grand Total $3 800 (CAD) 11. made the following customer accounts and add the historical information: The credit limit for all customers is $5 000.The terms for all customers are 2/10, n/30 after tax. The tax code for all customers is H. If information is not provided, leave fields blank. Name (Contact), Address Phone/Fax Nikki Chow Tel: (519) 762-6712 55 Wagstail Blvd, London, ON N8P 7D3 E-mail: n..i@dogscape.com Customer Since 04/10/2016 Show Off Dogs (Rex Rabbit) Tel: (519) 592-9001 Preferred Price List Fax: (519) 592-9991 110 Terrier St, Windsor, ON N9C 9A1 Web site: www.showdogs.com Customer Since 03/01/2015 Historical Customer Invoices and Payments Name Terms Date Invoice/Chq Amount Nikki Chow 2/10, n/30 Mar 28/24 1104 $2 500 Mar 28/24 Chq 32 -1 000 Balance owing $1 500 Computerized Accounting with Simply Level 2 (SI2O) Final Project 2 Page 8 12. Enter the following employee information: Use the linked payroll accounts. Personal Kitty Feline Bobbi Bowser Address 345 Benjie Cres 29 Hounds Dr London, ON N8E 4C9 London, ON N9F 2D4 (519) 459-7122 (519) 388-8127 SIN# 468 321 765 532 719 721 Birth Date Jan. 30, 1974 June 6, 1989 Date of Hire Taxes Jan. 1, 2008 April 1, 2024 Tax Table Ontario Ontario Federal Claim (& subject to indexing) $11,635 $11,635 Provincial Claim (& subject to indexing) $10,171 $10,171 Federal claim subject to indexing Provincial claim subject to indexing Deduct EI (Factor) $ 8,400 $ 4,900 Yes (1.4) $ 3,800 $ 7,500 Yes (1.4) Deduct CPP Yes Yes Historical Income Tax $1 981.36 Historical EI Contributions $241.18 Historical CPP Contributions Income $651.04 Benefits (medical-MSP plan) $13.50 $6.58 Historical benefits $81 Vacation 4 weeks (0%) 6%, retained Salary $2 250 bi-monthly (do not use) Historical salary $13 500 Regular Wage (do not use) $16/hr Regular Overtime wage (do not use) $24/hr Overtime Hours per period 80 (Salary hours) 35 (Regular hours) Commission 1% of all sales (do not use) Commission historical amount $440 No. Dogs (do not use) $5 per dog Car Expense historical amount $240 (do not use) Pay Periods per Year Deductions 24 52 RRSP deduction per pay $50 $20 Historical RRSP Contributions WSIB and Other Expenses $300 WSIB rate 1.55% 1.55% Medical-MSP per pay $13.50 $6.58 Historical Medical-MSP $81 Entitlements (entitlements are not cleared at year-end) Vacation 8%, 25 days maximum 0 Historical Vacation days 20 do not clear 0 Sick Leave 2.5%, 10 days max, clear 2.5%, 10 days max, clear Historical Sick Leave days 4 0 Computerized Accounting with Simply Level 2 (SI2O) Final Project 2 Page 9 Direct Deposit Yes Yes Branch No. 44588 59001 Institution No. 204 302 Account Number 610092 100873 Percentage deposited to this account 100% 100% T4 and RL-1 Reporting Historical EI Insurable Earnings $13 940 Historical Pensionable Earnings $14 021 13. Set up a payroll authority. made a new supplier record for the Receiver General as the payroll authority for Income Tax, EI and CPP. Leave the remaining supplier record fields blank. Settings- Payroll: Remittance and suppliers - Receiver General of Canada Remitting frequency - Monthly End of remittance period - April 15, 2024 14. Set up job categories. made two job categories named Sales and Other. Persons in the Sales category are salespersons. Assign the employee Kitty Feline to the Sales category. Persons in the Other category are not salespersons. Assign the employee Bobbi Bowser to the Other category. Select Feline as the Salesperson for all sales. 15. Made the following inventory accounts: Allow account classes to change. There is no year-to-date information (No Statistics). Foreign prices (in USD) are not required. Variance accounts will not be required. Leave the variance account field blank. Taxes: HST is charged on inventory and service items. Inventory Items Reg (Pref) Opening Linked Accounts Description No. Unit Min Price (Price) Qty Value Asset Rev C.O.G.S. Great Dane 101 Each 0 $1 650 ($1 500) 4 $1 900 1420 4020 5060 Saint Bernard 102 Each 0 1 450 (1 300) 4 1 600 1420 4020 5060 Samoyed 103 Each 0 1 250 (1 100) 4 1 700 1420 4020 5060 Holistic Mature Dog Chow 201 10kg 5 $45 ($40) 30 $ 630 1440 4020 5060 Holistic Puppy Chow 202 5kg 10 20 (15) 100 770 1440 4020 5060 Holistic Regular Chow 203 10kg 10 28 (25) 200 2 100 1440 4020 5060 Steel Wire Cage 301 Each 1 $250 ($210) 10 $1 050 1460 4020 5060 Wooden Dog House Kit 302 Each 1 550 (470) 10 2 550 1460 4020 5060 Services Reg (Pref) Linked Accounts Description No. Unit Price (Price) Tax Exempt Rev Expense Clipping - large dog 401 Each $100 ($90) HST No 4050 5070 Clipping - small dog 402 Each 50 (45) HST No 4050 5070 House Assembly 403 Each 100 (90) HST No 4050 5070 Shampooing 404 Each 25 (22) HST No 4050 5070 Note: Web Price is the same as regular price. Computerized Accounting with Simply Level 2 (SI2O) Final Project 2 Page 10 16. Made two divisions starting April 1, 2024. 1. Sales 2. Service There are no balances forward. Select Status: Completed Setup: Warn if allocation is not complete. 17. Back up your work files. Continue with the original working copy, DOGHOUSE.SAI. Finish entering the history. 18. Change the session date to April 8, 2024. Add the shortcuts you need and then enter the following transactions: NOTE: Remember to add Kitty Feline as the salesperson for all sales. Edit prices as needed. Cheque Purchase Invoice #FW-04-18 Dated April 2, 2024 From Four Walls Inc., $1 582 for monthly rent, HST included. Paid by cheque #501. Allocate 70% of rent expense to Sales Division and 30% to Service. Store as monthly recurring entry. Use Quick Add for the new supplier. Cash Receipt #1522 Dated April 4, 2024 From Nikki Chow, cheque #183 for $1 450 in full payment of invoice #1104, taking into account 2% sales discount of $50 for early payment. Purchase Invoice #KK-601 Dated April 4, 2024 From Kanine Kibble 10 Holistic Mature Dog Chow ($20 ea) $200.00 USD 20 Holistic Puppy Chow ($7.50 ea) 150.00 USD 50 Holistic Regular Chow ($10 ea) 500.00 USD Freight Charge 30.00 USD HST Paid 114.40 USD Invoice Total $994.40 USD Terms: 2/15, net 30 The exchange rate is 1.205 (the exchange rate difference may not be allocated) Allocate 100% of the freight expense to the Sales Division. Purchase Order #1001 Shipping Date April 11, 2018 From Kennelworth Pound Dated April 4, 2024 4 Samoyed ($450 ea) $1 800 Freight Charge 100 HST Paid 247 Purchase Order Total $2 147 Terms: 1/10, net 30 Payment Cheque #502 Dated April 4, 2024 To Kennelworth Pound, $3 435 in full payment of invoices #KP-6621 and KP-6808, taking into account 1% purchase discount of $65 for early payment. Payment Cheque #1023 Dated April 5, 2024 To Kanine Kibble, $250 USD in full payment of invoice #KK-402. The exchange rate is 1.230. Paid from Bank: USD Chequing Account. Computerized Accounting with Simply Level 2 (SI2O) Final Project 2 Page 11 Sales Quote #45 Dated April 6, 2024 Delivery Date April 15, 2024 To Show Off Dogs (preparation for dog show) 10 Shampoos $22 each 10 Clippings - large dog 90 each HST Charged 13 % Terms: 2/10, net 30. Cash Sales Invoice #1121 Dated April 6, 2024 To Doggie Day Care (Use Quick Add for new Regular customer) 10 5kg bags Holistic Puppy Chow $20 each 20 10kg bags Holistic Regular Chow 28 each 5 10kg bags Holistic Mature Dog Chow 45 each Sales Discount for regular volume purchase 15 % HST Charged 13 % Invoice total $946.09 paid by cheque #4222. Allocate 100% of sales to Sales Division. Store as recurring weekly entry. Memo #1 Dated April 6, 2024 Show Off Dogs has accepted the sales quote and is placing an order. Convert Sales Quote #45 to Sales Order #45 using the same shipping date. Cash Receipt #1523 Dated April 7, 2024 From Show Off Dogs, cheque #288 for $500 as deposit #36 to accept sales order #45. Deposit Slip #14 Dated April 7, 2024 Deposit three cheques received in the past week. Total deposit is $2 896.09. Sales Invoice #1122 Dated April 8, 2024 To Nikki Chow 2 Saint Bernards $1 450 each 5 5kg bags Holistic Puppy Chow 20 each 2 Wooden Dog House Kits 550 each HST Charged 13 % Terms: 2/10, net 30. Allocate 100% of sales to Sales Division. Invoice total: $4,633.00 Memo #2 Dated April 8, 2024 Pay hourly employee, Bobbi Bowser for 35 hours regular work. Include $200 advance which will be repaid at the rate of $50 over each of the next four pay periods. Bowser should be paid for grooming 6 dogs (No. Dogs piece rate pay). Allocate 80% of payroll expenses to Sales and 20% to Service. Issue direct deposit slip #34. Hint: Use Payroll Run & ignore warnings. 19. Back up the data files. Continue with the file DOGHOUSE.SAI. Change the session date to April 15, 2024. Enter the following transactions: Computerized Accounting with Simply Level 2 (SI2O) Final Project 2 Page 12 Purchase Invoice #KP-7222 To fill Purchase Order #1001 From Kennelworth Pound Dated April 11, 2024 4 Samoyed ($450 ea) $1 800 Freight Charge 100 HST Paid 247 Invoice Total $2 147 Terms: 1/10, net 30 Allocate 100% of freight expense to Sales Division. Memo #3 Dated April 11, 2024 The Dog House will offer a package deal to the first five customers purchasing a Samoyed and Wooden Dog House Kit. They will also receive free assembly of the dog house, two coupons for free shampoos and a supply of dog food. The regular price of this $1 600 offer is over $1 950. To prepare for this special offer: (a) Made new Group accounts 1450 Promotions 4030 Revenue from Promotions (Allow division allocations) (b) Made new inventory item: 104 Promotional Spring Special Minimum level: 0 Regular and Preferred Selling Price: $1 600 CAD each Asset: 1450 Revenue: 4030 C.O.G.S.: 5060 Taxes: not exempt for HST (c) Enter the inventory item assembly as follows: Assembly Components 5 Samoyed @ $ 437.50 each 5 Wooden Dog House Kits @ $255.00 each 10 10kg bags Holistic Regular Chow @ $10.45 each Additional Costs $500 (labour for assembly and shampoos) Assembled Items 5 Promotional Spring Specials @ $4 067.00 total ($813.40 each) Cash Receipt #1524 Dated April 11, 2024 From Nikki Chow, cheque #189 for $4 540.34 in payment of invoice #1122, taking into account 2% sales discount of $92.66 for early payment. Sales Invoice #1123 Dated April 12, 2024 To Show Off Dogs (preparation for dog show), to fill Sales Order #45 10 Shampoos $22 each 10 Clippings - large dog 90 each HST Charged 13 % Terms: 2/10, net 30 Allocate 100 % of the revenue to the Service Division. Invoice total: $1265.60 Computerized Accounting with Simply Level 2 (SI2O) Final Project 2 Page 13 Cash Sales Invoice #1124 Dated April 13, 2024 Recall stored entry. To Doggie Day Care 10 5kg bags Holistic Puppy Chow $20 each 20 10kg bags Holistic Regular Chow 28 each 5 10kg bags Holistic Mature Dog Chow 45 each Sales Discount for regular volume purchase 15 % HST Charged Invoice total $946.09 paid by cheque #4355. Allocate 100 % of the revenue to the Sales Division. 13 % Credit Card Sales Invoice #1125 Dated April 15, 2024 To Collee Schnauzer (Use Full Add for new Regular customer, Terms: net 1, Tax Code: H) 2 Promotional Spring Specials $1 600 each (Including 4 coupons for shampoo and free dog house assembly) HST Charged 13 % Invoice total $3 616 paid by SpendMore. There is no discount on the promotional offer. Allocate 90% of revenue to Sales and 10% to Service. Memo #4 Dated April 15, 2024 Inventory stock of dog food required to feed dogs for sale in store. Complete an inventory adjustment to decrease the inventory for the following items: 5 5kg bags Holistic Puppy Chow 10 10kg bags Holistic Regular Chow Use account 1280 Food Supplies instead of the default Adjustment Write-off account. Deposit Slip #15 Dated April 15, 2024 Deposit two cheques received in the past week. Total deposit $5 486.43 Memo #5 Dated April 15, 2024 Transfer $5 000 from Bank: Credit Card to Bank: CAD Chequing Account. Bank Credit Memo #PLCU-4433 Dated April 15, 2024 From Pet Lovers Credit Union, approval of $5 000 bank loan at 6% interest per annum. Amount deposited to CAD Chequing bank account. Memo #6 Dated April 15, 2024 Prepare the Sales by Salespersons Detail Report, to check that all sales are included for Feline. Look up all sales invoices and adjust them to add Feline as the salesperson if necessary. Memo #7 Dated April 15, 2024 Pay hourly employee, Bobbi Bowser for 35 hours regular work. Recover $50 advance. Bowser took one day sick leave during the week. (Allow the net days accrued to be negative.) Bowser should be paid for grooming 5 dogs (No. Dogs piece rate pay). Issue deposit slip #35. Allocate 60% of payroll expenses to Sales and 40% to Service. Ignore warnings. Computerized Accounting with Simply Level 2 (SI2O) Final Project 2 Page 14 Memo #8 Dated April 15, 2024 Pay salaried employee, Kitty Feline $2 250 her regular bi-monthly salary. Calculate and include sales commission for Feline. Feline took two days vacation during the pay period. Issue deposit slip #36. Allocate 60% of payroll expenses to Sales and 40% to Service. Cheque Purchase Invoice #PVS-445 Dated April 15, 2024 From Pooch Veterinary Services, $600, plus $78 HST, for vaccination and health checkups for all new dogs. Invoice total $678 paid by cheque #503. Allocate 100% of expense to Sales. Memo #9 Dated April 15, 2024 Make payroll tax remittance to the Receiver General for the pay periods ending April 15, 2024. Include remittance for income tax, EI and CPP. Issue cheque #504. 20. Bank reconciliation. Set up account 1080 for account reconciliation. Use the following linked accounts. Made new accounts if necessary. Income: Interest 4280 Revenue from Interest Expense1: Bank Charges 5010 Bank & Credit Card Fees Expense2: NSF fee 5010 Bank & Credit Card Fees Adjustment: 5005 Reconciliation Adjustments Reconcile the account using April 1 as statement start date and April 15 as the statement end date and the reconciliation date. There are two outstanding prior transactions Source Description Date Amount 13 Deposit slip Mar 25 Deposit $4 600 500 Kennelworth Pound Mar 30 Payment $2 700 (Hint: after adding the first outstanding transaction, click Insert Outstanding again to access a new transaction line.) Use the following bank statement details to complete the reconciliation. withdrawals deposits balance Mar. 15 Balance forward 22 389.00 Mar. 25 Deposit 4 600.00 Mar. 30 Cheque 500 2 700.00 Apr. 1 Interest on account 22.00 Apr. 1 Service fee 15.00 Apr. 4 Cheque 501 1 582.00 Apr. 4 Cheque 502 3 435.00 Apr. 8 Deposit 14 2 896.09 Apr. 8 Payroll transfer Ref #34 631.93 Apr. 15 Deposit 15 5 486.43 Apr. 15 Credit memo 5 000.00 Apr. 15 Transfer from 02333-88899 5 000.00 Apr. 15 Payroll transfer Ref #35 432.94 Apr. 15 Payroll transfer Ref #36 1825.42 Apr. 15 Closing Balance 34 727.23 Computerized Accounting with Simply Level 2 (SI2O) Final Project 2 Page 15 21. Made the following reports, open them in Excel, save them in your Doghouse folder, and upload them to LMS to your instructor only: Note: Make sure your name appears as part of the company name at the top of each report. 1. Journal Entries for all journals from April 1 to April 15, 2024 - Show division allocations, foreign currency amounts, corrections and additional information. 2. Balance Sheet at April 15, 2024 3. Income Statement from April 1 to April 15, 2024 4. Employee Summary 5. Inventory Summary