Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help to create accounts to match the following chart of accounts. b 3. Create accounts to match the following Chart of Account: Account
I need help to create accounts to match the following chart of accounts.
b
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 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) 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) 1400 INVENTORY (H) 1420 Purebred Dogs 1440 Dog Food 1460 Dog Houses 1490 TOTAL INVENTORY (T) 4000 REVENUE (H) 4020 Revenue from Sales 4050 Revenue from Services 4100 Sales Discounts 4200 Freight Revenue 4390 TOTAL REVENUE (T) 1500 PLANT & EQUIPMENT (11) 1550 Computer/Cash Register 1580 Store Fixtures and Cages 1590 TOTAL PLANT & FOUIPMENT (T) 5000 EXPENSES (H) 5010 Bank & Credit Card Fees 5015 Exchange Rate Differencer 5020 Cleaning and Maintenance Thumont Writer 7 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 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 Computerized Accounting with Simply Level 2 (CAB4) Final Project 2 Page 3 4. Add account balances from the following Trial Balance: THE DOG HOUSE Post-Closing Trial Balance: April 1, 2022 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 3800 2200 Accounts Payable 81 2310 EI Payable 217 2320 CPP Payable 661 2330 Income Tax Payable 47 130 3560 A. Katz, Capital $53 089 $53 089 Print the Trial Balance for reference. 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, 2022. 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. 01 ENG 3:57 PM 2021-06-20 34C 7. Cards Used Set up credit cards fonte Cards Acuerned Credit Card Name: Spend More Currency: CAD Linka Atist Account 1100 Discount Fot: 3.5% Linked Expense Account: 5010 Credit Card Name: Spend More Linked Payable Account: 2150 Linked Expense Account: 5010 Enter Sales Taxes and Tax Codes Tax-HST: Not Etempt. Not Tatable. Use 2670 to track taxpand on purchases Use 2650 to track taxes charged on sales, Report on taxes Code - H: Tax HST, Tatable, Rate 13%, Not included, Refundable Code -HI: Tax HST. Tatable, Rate 13%, Included, Refundable 8. 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 * ENG 34C O BI Names - Additional Payroll Incomes Deduction 1: RRSP Delete other Deduction names using Incomes set up tool Worker's Comp: WSIB 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 Overtime 1: (Type - Hourly rate) Calculate tax, EI, Insurable Hours, CPP and vacation sblary: (Type - Income) Calculate tax, EI, Insurable Hours and CPP Commission: Type Income Calculate tax, El and CPP No. Dogs: (Type - Piece Rate; Unit of measure - Number) Calculate tax, EI, CPP and vacation Car Expense: (Type - Reimbursement) No taxes apply RRSP by amount before calculating tax El factor is 1.4 WSIB rate is 3.54 Vacation: Track -8%; Maximum - 25 days: Do not clear at Year-end Sick Leave: Track - 2.5%; Maximum - 10 days; Clear at Year-end 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 RRSP 2400 Deductions Taxes: Entitlements Linked Accounts - Incomes Deductions a 17 ENG 3:59 PM 2021-06-28 34C OBE O III 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 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) 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) 1400 INVENTORY (H) 1420 Purebred Dogs 1440 Dog Food 1460 Dog Houses 1490 TOTAL INVENTORY (T) 4000 REVENUE (H) 4020 Revenue from Sales 4050 Revenue from Services 4100 Sales Discounts 4200 Freight Revenue 4390 TOTAL REVENUE (T) 1500 PLANT & EQUIPMENT (11) 1550 Computer/Cash Register 1580 Store Fixtures and Cages 1590 TOTAL PLANT & FOUIPMENT (T) 5000 EXPENSES (H) 5010 Bank & Credit Card Fees 5015 Exchange Rate Differencer 5020 Cleaning and Maintenance Thumont Writer 7 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 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 Computerized Accounting with Simply Level 2 (CAB4) Final Project 2 Page 3 4. Add account balances from the following Trial Balance: THE DOG HOUSE Post-Closing Trial Balance: April 1, 2022 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 3800 2200 Accounts Payable 81 2310 EI Payable 217 2320 CPP Payable 661 2330 Income Tax Payable 47 130 3560 A. Katz, Capital $53 089 $53 089 Print the Trial Balance for reference. 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, 2022. 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. 01 ENG 3:57 PM 2021-06-20 34C 7. Cards Used Set up credit cards fonte Cards Acuerned Credit Card Name: Spend More Currency: CAD Linka Atist Account 1100 Discount Fot: 3.5% Linked Expense Account: 5010 Credit Card Name: Spend More Linked Payable Account: 2150 Linked Expense Account: 5010 Enter Sales Taxes and Tax Codes Tax-HST: Not Etempt. Not Tatable. Use 2670 to track taxpand on purchases Use 2650 to track taxes charged on sales, Report on taxes Code - H: Tax HST, Tatable, Rate 13%, Not included, Refundable Code -HI: Tax HST. Tatable, Rate 13%, Included, Refundable 8. 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 * ENG 34C O BI Names - Additional Payroll Incomes Deduction 1: RRSP Delete other Deduction names using Incomes set up tool Worker's Comp: WSIB 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 Overtime 1: (Type - Hourly rate) Calculate tax, EI, Insurable Hours, CPP and vacation sblary: (Type - Income) Calculate tax, EI, Insurable Hours and CPP Commission: Type Income Calculate tax, El and CPP No. Dogs: (Type - Piece Rate; Unit of measure - Number) Calculate tax, EI, CPP and vacation Car Expense: (Type - Reimbursement) No taxes apply RRSP by amount before calculating tax El factor is 1.4 WSIB rate is 3.54 Vacation: Track -8%; Maximum - 25 days: Do not clear at Year-end Sick Leave: Track - 2.5%; Maximum - 10 days; Clear at Year-end 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 RRSP 2400 Deductions Taxes: Entitlements Linked Accounts - Incomes Deductions a 17 ENG 3:59 PM 2021-06-28 34C OBE OStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started