ACCT 2281: Accounting Software Systems 1 TRU Open Learning Final Project (25%) The information provided in this test allows you to set up all ledgers for an Ontario company named KILLARNEY specializes in sales of purebred and pedigreed Cats. In addition, they sell cages or cat houses, and high quality pet food. Some of the pet food is purchased from a supplier in the United States. The manager of the store provides some basic cat 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. Note: All dates are marked 20XX. Your Open Learning Faculty Member will give you the correct year to use for the Final Project. 1. Using Sage 50, create a new company file using the following information: Company Name: KILLARNEY (replace with your last name - see student signature file for instructions) Address: 460 Meow St. Fort Francis, Ontario, N9L 4B6 Phone: (519) 535-1918 Fax: (519) 535- 8819 Fiscal start: 04-01-20XX Earliest transaction date: 04-01-20XX Fiscal end: 06-30-20XX Email: k..y@shaw.ca Web site: www.KILLARNEY.ca Select: Create a new company Select: Let me build the list of accounts myself after the company is created Industry: Retail Select: I will update my tax information myself. Store company files in a new folder named KILLARNEY and use KILLARNEY as the file name. ACCT 2281: Accounting Software Systems 2 TRU Open Learning 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-20XX 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 Sales Order number 45 Next Receipts number 1522 Next Customer Deposits number 36 Next Purchase Order number 1001 Next Direct Deposit Stubs- Employee number 34 Allow printing in batches for all forms - Date Format MM-DD-YYYY; Use long date format on the screen and in reports Open a new Word document and name it, "ACCT 2281_FP_First Name Last Name - INI_XXXX.docx" (where INI = your initials and XXXX = the last 4 digits of your student number. Example: Joe Smith, Student Number T00253538, would name his file "Acct 2281_FP_Joe Smith-JS_3538.docx"). You will use this document to save your eight numbered screen prints. Please use this same format in naming the PDF reports (see page 18). Save screen prints of the Company: Information screen (1) and the Forms screen (2). 3. Create 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 ACCT 2281: Accounting Software Systems 3 TRU Open Learning KILLARNEY Chart of Accounts 1000 CURRENT ASSETS (H) 1050Test 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 Cats 1440 Cat Food 1460 Cat 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 EQUITY (H) 3560 H. Drew, Capital 3600 Net Income (X) 3690 TOTAL 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 Cat Food Used 5240 Rent 5260 Utilities 5280 Veterinary Consultation 5300 Wages 5310 EI Expense 5320 CPP Expense 5330 WSIB Expense 5400 Medical-MSP Expense 5420 Car Expenses 5490 TOTAL EXPENSES (T) Note: Check validity of accounts before proceeding ACCT 2281: Accounting Software Systems 4 TRU Open Learning 4. Add account balances from the following Trial Balance: KILLARNEY Post-Closing Trial Balance: April 1, 20XX 1080 Bank: CAD Chequing $23 289 1090 Bank: USD Chequing 860 (CAD) 845 USD 1100 Bank: Credit Card 2 200 1200 Accounts Receivable 2 000 1280 Food Supplies 1040 1300 Other Supplies 400 1420 Purebred Cats 5 200 1440 Cat Food 3 500 1460 Cat 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 H. Drew, Capital ______ 47 130 $53 089 $53 089 5. Add foreign currency. Allow transactions with United States suppliers in US dollars. Use account 5015 to track exchange rate differences. Enter 1.02 as the exchange rate for April 1, 20XX. Display the reminder if the rate is one day old. Save a screen print (3) of the foreign currency exchange rate screen. ACCT 2281: Accounting Software Systems 5 TRU Open Learning 6. Edit the Account Classes. Undeposited Cash & Cheques. Change the account class to Cash. CAD Chequing account. Change the account class to Bank. Enter XXXX501 as the next cheque number and 14 as next deposit No. USD Chequing account. Change the account class to Bank and enter 1023 as the next cheque number. Change the currency to USD and enter $845 as the USD balance. Bank: Credit Card. Change the account class to Bank. 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. Note: Change account #5060 class to Cost of Goods Sold Export a PDF of the Chart of Accounts. 7. Set up credit cards as follows: Cards Accepted: Credit Card Name: Shop Less Currency: CAD Linked Asset Account: 1100 Discount Fee: 3.5% Linked Expense Account: 5010 Cards Used: Credit Card Name: Shop Less Linked Payable Account: 2150 Linked Expense Account: 5010 Save a screen print (4) of the credit card setup screen for credit cards accepted. ACCT 2281: Accounting Software Systems 6 TRU Open Learning 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 Save a screen print (5) of the tax codes setup screen. 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 Fort Francis, Ontario, Canada - Linked Accounts Principal Bank Account for CAD 1080 Principal Bank Account for USD 1090 Options Aging periods: 30, 60 and 90 days Accounts Payable 2200 Freight Expense 5200 Early Payment Purchase Discount 5100 Prepayments and Prepaid Orders 1260 Receivable Settings: Address Fort Francis, 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 ACCT 2281: Accounting Software Systems 7 TRU Open Learning Employee & Payroll Settings: Names - Income & Deductions Income 1: Salary Income 2: Commission Income 3: No. Cats Income 4: Car Expense Delete other Income names Deduction 1: RRSP Delete other Deduction names Names - Additional Payroll Worker's Comp: WSIB User Defined Expense 2: 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 Regular and 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. Cats: (Type - Piece Rate; Unit of measure - Number) Calculate tax, EI, CPP and vacation Car Expense: (Type - Reimbursement) No taxes apply Deductions RRSP by amount after calculating tax , EI, CPP and vacation Taxes: EI factor is 1.4 WSIB rate is 2.54 (for existing and new employees) 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 ACCT 2281: Accounting Software Systems 8 TRU Open Learning 1, Salary, Commission and No. Cats Use 5420 for Car Expense - Deductions RSP 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 Expense -5400 Medical-MSP Inventory& Services Settings: - Options Inventory Costing Method: Average costing method 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 Save screen prints of the Linked screen for Payables (6), Receivables (7), and for the income screen for Payroll (8). ACCT 2281: Accounting Software Systems 9 TRU Open Learning 10. Create the following supplier accounts with historical information: Name (Contact), Address Phone/Fax Options, Tax, Account Feline Krumble Belinda Crunch) Tel: (617) 492-2826 Terms: 2/15, n/30 (after tax) 88 Gwen Cres., Ithica, New York, USA 14209 Fax: (617) 492- 6418 Tax Code: H Currency: USD Web site: www.krumble.com/cats Supplier Since 04/01/2019 Cathome PLACE (Al Meow) Tel: (519) 477-9017 Tax Code: H Tax ID: 533 766 457 RT0001 Fax:(519) 477-9977 E-mail: h..e@chp.com Supplier Since 03/01/02018 Pets Veterinarian Services (Mary Litter) Tel: (519) 625-1971 Terms: 2/5, n/15 (after tax) 33 Lab St., Fort Francis ON N9R 2V7 Tax Code: H Tax ID: 533 766 457 RT0001 Expense Account: E-mail: m..r@pvs.com 5280 Veterinary Consultation Supplier Since 02/04/2018 Historical Supplier Invoices and Payments Name Terms Date Invoice/Chq Amount Feline Krumble 2/15, n/30 after tax Mar 15/XX FK-402 $290 USD (300) CAD Cathome Place 1/10, n/30 (after tax) Mar 25/XX CP-6621 $5 500 Mar 28/XX Chq 488 -3 000 Mar 30/XX CP-6808 1 000 Balance owing $3 500 Grand Total $3 800 ACCT 2281: Accounting Software Systems 10 TRU Open Learning 11. Create 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 Nicole Scurry Tel: (519) 627-7612 55 Wiggy Tale., Fort Francis, ON N8P 7D3 E..e@scurry.com Customer Since 04/10/2018 Events Shows (Bob Thrush) Tel: (519) 925-1009 Preferred Price List Fax: (519) 925-1999 110 Wave St., Fort Francis, ON N9C 9A1 Customer Since 03/01/2018 Web site: www.eventsshows.com Historical Customer Invoices and Payments Name Terms Date Invoice/Chq Amount Nicole Scurry 2/10, n/30 Mar 28/XX 1104 $3 000 Mar 29/XX Chq 32 -1 000 Balance owing $2 000 12. Enter the following employee information: Use the linked payroll accounts. Personal Elaine Persian Bill Bengal Address 345 Rabbit Cres. 29 Circle Dr. Fort Francis, ON N8E 4C9 Fort Francis, ON N9F 2D4 (519) 459-2217 (519) 388-7218 SIN# 468 321 765 532 719 721 Birth Date Jan. 30, 1981 June 6, 1990 Date of Hire Jan. 1, 2011 April 1, 20XX Taxes Tax Table Ontario Ontario Federal Claim $14,308 $14,308 Provincial Claim $11,141 $11,141 Federal claim subject to indexing $14,308 $ 14,308 Provincial claim subject to indexing $11,141 $ 11,141 Deduct EI (Factor) Yes (1.4) Yes (1.4) ACCT 2281: Accounting Software Systems 11 TRU Open Learning Deduct CPP Yes Yes Historical Income Tax $1 819.36 Historical EI Premiums $253.19 Historical CPP Contributions $688.04 Income Benefits (medical-MSP plan) $12.50 $5.58 Historical benefits $83 Vacation Rate (0%) 4 weeks 6% retained Salary $2 350 bi-monthly (do not use) Historical salary $14 500 Regular Wage (do not use) $18/hr Regular Overtime wage (do not use) $27/hr Overtime Hours per period 80 (Salary hours) 35 (Regular hours) Commission 1% of all sales (do not use) Commission historical amount $460 No. Cats do not use $8 Car Expense historical amount $260 Pay Periods per Year 24 52 Deductions RSP deduction per pay $50 $20 Historical RRSP Contributions $350 WSIB and Other Expenses WSIB rate 2.54% 2.54% Medical-MSP per pay $12.50 $5.58 Historical Medical-MSP $83 Entitlements (entitlements are not cleared at year-end) Vacation 8%, 25 days maximum 0 Historical Vacation days 21 do not clear 0 Sick Leave 2.5%, 10 days max, clear 2.5%, 10 days max, clear Historical Sick Leave days 5 0 Direct Deposit No Yes Branch No. 59001 ACCT 2281: Accounting Software Systems 12 TRU Open Learning Institution No. 302 Account Number 100873 Percentage deposited to this account 100% T4 and RL-1 Reporting Historical EI Insurable Earnings $14 940 Historical Pensionable Earnings $15 021 13. Set up a payroll authority. Create a new supplier record for the Receiver General for Canada as the payroll authority for Income Tax, EI and CPP. Leave the remaining supplier record fields blank. Settings- Payroll: Remittance and suppliers - Receiver General for Canada Remitting frequency - Monthly End of remittance period - April 15, 20XX 14. Set up job categories. Create two job categories named Sales and Other. Persons in the Sales category are salespersons. Assign the employee Elaine Persian to the Sales category. Persons in the Other category are not salespersons. Assign the employee Bill Bengal to the Other category. Select Persian as the Salesperson for all sales. ACCT 2281: Accounting Software Systems 13 TRU Open Learning 15. Create 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. Siamese 101 Each 0 $1 000 ( $900) 5 $1 900 1420 40205060 Birman 102 Each 0 900 ( 800) 5 1 600 1420 40205060 Manx 103 Each 0 600 (500) 5 1 700 1420 40205060 Mature Cat Food 201 10kg 5 $45 ($40) 30 $ 630 1440 40205060 Kitten Food 202 5kg 10 20 (15) 100 770 1440 40205060 Regular Food 203 10kg 10 28 (25) 200 2 100 1440 40205060 Steel Wire Cage 301 Each 1 $260 ($220) 10 $1 050 1460 40205060 Wooden Cat House Kit 302 Each 1 560 (470) 10 2 550 1460 40205060 Services Reg (Pref) Linked Accounts Description No. Unit Price (Price) Tax Exempt Rev Expense Grooming - large cat 401 Each $90 ($80) HST No 4050 5070 Grooming - small cat 402 Each 50 (40) HST No 4050 5070 House Assembly 403 Each 90 (80) HST No 4050 5070 Shampooing 404 Each 24 (22) HST No 4050 5070 ACCT 2281: Accounting Software Systems 14 TRU Open Learning Note: Web Price is the same as regular price. 16. Create two divisions starting April 1, 20XX. 1. Sales 2. Service There are no balances forward. Select Status: Completed 17. Back up your data files. Finish entering the history. 18. Change the session date to April 8, 20XX. Add the shortcuts you need and then enter the following transactions: NOTE: Remember to add Elaine Persian as the salesperson for all sales. Edit prices as needed. Cheque Purchase Invoice #CH-04-26 Dated April 2, 20XX From Critter House Inc., $1 682 for monthly rent, including HST. Paid by cheque #XXXX501. 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, 20XX From Nicole Scurry, cheque #183 for $1 940 in full payment of invoice #1104, taking into account 2% sales discount of $60 for early payment. Discount is calculated on the original invoice amount. Purchase Invoice #FK-601 Dated April 4, 20XX From Feline Krumble 10 Mature Cat Food ($18 ea) $180.00 USD 20 Kitten Food (6.00 ea) 120.00 USD 50 Regular Food ($9.00 ea) 450.00 USD Freight Charge 90.00 USD HST Paid 109.20 USD Invoice Total $949.20 USD Terms: 2/15, net 30 The exchange rate is 1.025 (the exchange rate difference may not be allocated) Allocate 100% of the freight expense to the Sales Division. Ignore any messages that may appear. ACCT 2281: Accounting Software Systems 15 TRU Open Learning Purchase Order #1001 Dated April 4, 20XX Shipping Date April 11, 20XX From Cathome Place 4 Manx ($300 ea) $1 200 Freight Charge 200 HST Paid 182 Purchase Order Total $1 582 Terms: 1/10, net 30 Payment Cheque #XXXX502 Dated April 4, 20XX To Cathome Place, $3 500 in full payment of invoices #CP-6621 and # CP-6808 \. Payment Cheque #1023 Dated April 5, 20XX To Feline Krumble, $290 USD in full payment of invoice #FK-402. The exchange rate is 1.030. Paid from Bank: USD Chequing Account. Sales Quote #45 Dated April 6, 20XX Delivery Date April 15, 20XX To Events Shows (preparation for cat show) 10 Shampoos $22 each 10 Groomings - small cat 40 each HST Charged 13 % Terms: 2/10, net 30. Cash Sales Invoice #1121 Dated April 6, 20XX To Feline Kennel Service (Use Full Add for new Regular customer) 10 5kg bags Kitten Food $20 each 20 10kg bags Regular Food 28 each 5 10kg bags Mature Cat Food 45 each Sales Discount for regular volume purchase15% HST Charged 13 % Invoice total $946.09 paid by cheque #4222. Allocate 100% of sales to Sales Division and Employee Store as recurring weekly entry. ACCT 2281: Accounting Software Systems 16 TRU Open Learning Memo #1 Dated April 6, 20XX Events Shows 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, 20XX From Events Shows, cheque #288 for $600 as deposit #36 to accept sales order #45. Deposit Slip #14 Dated April 7, 20XX Deposit three cheques received in the past week. Total deposit is $3 467.17 ACCT 2281: Accounting Software Systems 17 TRU Open Learning KILLARNEY April 8, 20XX Invoice #1122 Bill To Customer Nicole Scurry Address 55 Sway Tail Fort Francis, Ontario N8P 7D3 Phone (519)762-2176 Division Sales Payment Terms 2/10 , net 30 Qty. Description Unit Price Line Total 2 Birman Cats $900 1,800.00 5 5kg bags Kitty Food 20 100.00 2 Wooden Cat House Kits 560 1,120.00 Subtotal 3,020.00 Sales Tax 392.60 Total 3,412.60 Thank you for your business ! KILLARNEY 460 Meow Street Fort Francis, Ontario N9L 4B6 ACCT 2281: Accounting Software Systems 18 TRU Open Learning Memo #2 Dated April 8, 20XX Pay hourly employee, Bill Bengal 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. Bengal should be paid for grooming 7 Cats (No. Cats piece rate pay). Allocate 80% of payroll expenses to Sales and 20% to Service. Hint: Net Pay amount should be $ 738.33. If you updated tax tables you need to enter tax amounts manually as follows: CPP $ 44.92 EI $ 14.00 Tax $ 68.75 Issue direct deposit slip #34. Ignore warnings. Export a PDF copy of the Trial Balance dated Apr 8, 20XX, hide accounts with zero balance (named Acct 2281_FP_Joe Smith--JS_3538 TB April 8 20XX). ACCT 2281: Accounting Software Systems 19 TRU Open Learning 19. Back up the data files. Change the session date to April 15, 20XX. Enter the following transactions: CATHOMEPLACE April 11, 20XX Invoice CP-7222 Bill To Customer KILLARNEY Address 440 Meow Street Fort Francis, Ontario N8T 7F3 Phone (519) 535-2918 Purchase Order # 1001 Payment Terms 1/10 , net 30 Qty. Description Unit Price Line Total 4 Manx Cats $300 $1,200 Freight Charge 200 Subtotal 1,400 HST Paid 182 Total $1 582 Thank you for your business Note: Allocate 100% of freight expense to Sales Division. ACCT 2281: Accounting Software Systems 20 TRU Open Learning Memo #3 Dated April 11, 20XX KILLARNEY will offer a package deal to the first five customers purchasing a Manx and Wooden Cat House Kit. They will also receive free assembly of the cat house, two coupons for free shampoos and 10 bags of regular cat food. The regular price of this $1 350 offer is over $1 500. To prepare for this special offer: (a) Create new Group accounts 1450 Promotions 4030 Revenue from Promotions (Allow division allocations) (b) Create new inventory item: 104 Promotional Spring Special Minimum level: 0 Regular and Preferred Selling Price: $1 200 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 Manx @ $ 340.00 each 5 Wooden Cat House Kits @ $255.00 each 10 10kg bags Regular Food @ $10.50 each Additional Costs $498 (labour for assembly and shampoos) Assembled Items 5 Promotional Spring Specials @ $3 578 total ($715.60 each) Cash Receipt #1524 Dated April 11, 20XX From Nicole Scurry, cheque #189 for $3,344.35 in payment of invoice #1122, taking into account 2% sales discount of $68.25 for early payment. Sales Invoice #1123 Dated April 12, 20XX To Events Shows (preparation for cat show), to fill Sales Order #45 10 Shampoos $22 each 10 Groomings - small cat 40 each HST Charged 13 % Terms: 2/10, net 30 Allocate 100 % of the revenue to the Service Division. Invoice total: $700.60 ACCT 2281: Accounting Software Systems 21 TRU Open Learning Cash Sales Invoice #1124 Dated April 13, 20XX Recall stored entry. To Feline Kennel Service 10 5kg bags Kitty Food $20 each 20 10kg bags Regular Food 28 each 5 10kg bags Mature Cat Food 45 each Sales Discount for regular volume purchase15% HST Charged 13 % Invoice total $946.09 paid by cheque #4355. Allocate 100 % of the sales to the Sales Division and Sales Employee. Credit Card Sales Invoice #1125 Dated April 15, 20XX To Mila Kitty (Use Full Add for new Regular customer, Terms: net 1, Tax Code: H) 2 Promotional Spring Specials $1 350 each (Including 4 coupons for 2 shampoos, 2 bags Regular cat food and cat house assembly) HST Charged 13 % Invoice total $3 051.00 paid by Shop Less. There is no discount on the promotional offer. Allocate 90% of revenue to Sales and 10% to Service. Memo #4 Dated April 15, 20XX Inventory stock of cat food required to feed cats for sale in store. Complete an inventory adjustment to decrease the inventory for the following items: 5 5kg bags Kitten Food 10 10kg bags Regular Food Use account 1280 Food Supplies instead of the default Adjustment Write-off account. Deposit Slip #15 Dated April 15, 20XX Deposit two cheques received in the past week. Total deposit $4 271.52 Memo #5 Dated April 15, 20XX Transfer $3 000 from Bank: Credit Card to Bank: CAD Chequing Account. Bank Credit Memo #AFCU-4433 Dated April 15, 20XX From Animal Friendly Credit Union, approval of $60, 000 bank loan at 6% interest per annum. Amount deposited to CAD Chequing bank account. ACCT 2281: Accounting Software Systems 22 TRU Open Learning Memo #6 Dated April 15, 20XX Prepare the Sales by Salespersons Detail Report, to check that all sales are included for Persian. Look up all sales invoices and adjust them to add Persian as the salesperson if necessary. Memo #7 Dated April 15, 20XX Pay hourly employee, Bill Bengal for 35 hours regular work. Recover $50 advance. Bengal took one day sick leave during the week. (Allow the net days accrued to be negative.) Bengal should be paid for grooming 4 Cats (No. Cats piece rate pay). Hint: Net Pay amount should be $ 526.47. If you updated tax tables you need to enter tax amounts manually as follows: CPP $ 32.71 EI $ 9.67 Tax $ 23.15 Issue deposit slip #35. Allocate 60% of payroll expenses to Sales and 40% to Service. Ignore warnings. Memo #8 Dated April 15, 20XX Pay salaried employee, Elaine Persian $2 350 her regular bi-monthly salary. Calculate and include sales commission for Persian. Persian took two days' vacation during the pay period. Hint: Net Pay amount should be $ 1,918.91. If you updated tax tables you need to enter tax amounts manually as follows: CPP $ 124.82 EI $ 38.30 Tax $ 291.90 Pay by Cheque # XXXX503. Allocate 60% of payroll expenses to Sales and 40% to Service. Ignore warning. Cheque Purchase Invoice #PVS-445 Dated April 15, 20XX From Pets Veterinary Services, $882, plus HST, for vaccination and health checkups for all new cats. Invoice total $996.66 paid by cheque #XXXX504. Includes early payment discount. Allocate 100% of expense to Sales. ACCT 2281: Accounting Software Systems 23 TRU Open Learning Memo #9 Dated April 15, 20XX Make payroll tax remittance to the Receiver General for the pay periods ending April 15, 20XX. Include remittance for income tax, EI and CPP. Issue cheque #XXXX505. 20. Bank reconciliation. Set up account 1080 for account reconciliation. Use the following linked accounts. Create 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: 5050 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 $1 000 500 Cathome Place Mar 28 Payment $3 000 (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 25 289.00 Mar. 25 Deposit 1 000.00 Mar. 30 Cheque 500 3 000.00 Apr. 1 Interest on account 22.00 Apr. 1 Service fee 15.00 Apr. 4 Cheque XXXX501 1 682.00 Apr. 4 Cheque XXXX502 3 500.00 Apr. 7 Deposit 14 3 467.17 Apr. 8 Payroll transfer Ref #34 738.33 Apr. 15 Deposit 15 4 271.52 Apr. 15 Funds transfer 3 000.00 Apr. 15 DD #35 526.47 Apr. 15 XXXX503 1 918.91 Apr. 15 XXXX504 976.73 Closing balance 24 692.25 ACCT 2281: Accounting Software Systems 24 TRU Open Learning 21. Export a PDF of the following ten reports: 1. Trial Balance at April 15, 20XX 2. Comparative Balance Sheet at April 15, 20XX. Amounts only. First period April 15, Second period April 1. Collapse Group Plant & Equipment to show group total only. 3. Income Statement from April 1, 20XX to April 15, 20XX 4. Customer Aged Detail Report April 15, 20XX including terms and foreign amounts 5. Supplier Aged Detail Report April 15, 20XX including terms and foreign amounts 6. Employee Summary 7. Division Income Detail from April 1, 20XX to April 15, 20XX 8. Sales by Salesperson Detail (group by customer) from April 1, 20XX to April 15, 20XX 9. Account Reconciliation Summary with Outstanding Transaction Detail, dated April 15 10. Inventory statistics detail, by asset, stocking units dated April 15. Sort by Item Number. Name the reports as follows: Acct 2281_FP_Joe Smith-JS_3538 Chart of Accounts Acct 2281_FP_Joe Smith--JS_3538 TB April 8 20XX Acct 2281_FP_Joe Smith-JS_3538 TB April 15 20XX Acct 2281_FP_Joe Smith -JS_3538 BS April 15 20XX Acct 2281_FP_Joe Smith -JS_3538 IS April 1 to April 15 20XX Acct 2281_FP_Joe Smith -JS_3538 Customer April 15 20XX Acct 2281_FP_Joe Smith-JS_3538 Supplier April 15 20XX Acct 2281_FP_Joe Smith-JS_3538 Employee Acct 2281_FP-Joe Smith -JS_3538 Division Income Acct 2281_FP_Joe Smith-JS_3538 Sales by Salesperson Acct 2281_FP_Joe Smith-JS_3538 Acc Rec April 15 20XX Acct 2281 Final Project Joe Smith-JS_3538 Inventory ACCT 2281: Accounting Software Systems 25 TRU Open Learning Note: You should already have a PDF of the following two reports: Chart of Accounts (step 6) Trial Balance at April 8, 20XX (, step 18) Required Submission Turn in the following thirteen files: One Word document with eight (8) screen prints. Twelve (12) PDF documentsone for each of the above reports.