BOB'S BACK HOES STUDENT EXERCISE Overview In this case-study, you, the student, will set up a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
BOB'S BACK HOES STUDENT EXERCISE Overview In this case-study, you, the student, will set up a new service company file using the Easy Step Interview found by clicking on Detailed Start after clicking to create a new company. As you navigate through the Easy Step Interview, you will decide the best answers to the interview based on the information presented here. You will also have the opportunity to practice setting up a Chart of Accounts, and completing Journal entries, sales, Bills, and Cheques. As an extended activity, you may be required to complete the Bank Reconciliation. Accounting Information Bob Brown has decided to start a business of his own, doing backhoe work for clients beginning January 1. He will run the business from his home at 123 Any Street, Chatham, Ontario N7M 1A1. He has obtained his Business Number and registered for Goods and Services tax. Tax rates are GST 5%, and HST 13% • Bob will use the calendar year as his fiscal year. • His first HST quarterly report period will end March 31. • Bob will only do business in Southwest Ontario. • This is a Service Based Business with no inventory. To assist with setting up the Chart of Accounts, choose 'General Service-Based Business' as the industry in the Easy Step Interview process. Set up a Service Item called Back Hoe Fees, Description Back Hoe Services, Default Tax will be HST Only. • Bob Expects to invoice some Customers and collect Payment later. • Bob will sometimes buy products and services on credit and pay his vendors later. • Attached is a Chart of Accounts Bob has been given to use with his business. QuickBooks 2019 - Assignment 2 Chart of Accounts: Туре Bank Description Chequing Account Account 10500 Chequing Account 11000 Prepaid Insurance Other current asset Prepaid Insurance Accounts Receivable Fixed Asset 12000 Accounts Receivable Accounts Receivable 13000 Home Office Equipment Home office Equipment Computer Equipment additions Computer Equipment Depreciation Fixed Asset Computer equipment additions Computer equipment Depreciation 13010 Fixed Asset 13020 Office Equipment Additions Office Equipment Depreciation Undeposited Funds 13510 Fixed Asset Office Equipment Additions Office Equipment Depreciation Undeposited funds 13520 Fixed Asset 14990 Other Current assets 15000 Equipment Fixed Asset Equipment 15010 Equipment additions Fixed Asset Equipment Additions Equipment depreciation Accounts Payable GST/HST Payable Opening Bal Equity Bob Brown Capital 15020 Fixed Asset Equipment Depreciation Accounts Payable 20000 Accounts Payable Other Current Liability HST Payable Equity Equity 25500 30000 Opening bal Equity Bob Brown capital 32000 30800 Bob Brown Withdrawals Equity Bob Brown Withdrawals 39000 Retained Earnings Equity Retained Earnings 40100 Back Hoe fees earned Income Fees 60400 Depreciation expense Expense Depreciation Expense 61000 Advertising Expense Expense Advertising Expense 62000 Back Hoe Equipment Rental Expense Back Hoe Equipment Rental 62500 Back Hoe Gas & Oil Expense Back Hoe Gas & Oil 63000 Bank fees Expense Bank fees 64000 Insurance Expense Insurance 64250 Liability Insurance Expense Liability Insurance 65000 Home Office Expense Office Supplies Utilities Expense Telephone Expense Expense Home Office Expense Office supplies 65250 Expense 65500 Expense Utilities Expense 65750 Expense Telephone Expense 66200 Professional fees Expense Professional fees 66500 Accounting Expense Expense Accounting Fees 67000 Repairs Repairs 68200 Taxes Expense Тахes 68300 Federal Expense Federal taxes 68400 Provincial Expense Provincial Transactions: On 3 January, Bob deposits $25,000 in a separate Bank Account for the Business at CIBC, downtown branch. (Create journal Entry # 1 to Debit Chequing Account and Credit B Brown, Capital) Bob has decided to lease the backhoe. The monthly payment of $2,000 (plus HST) is made on the 15th day of each month to Brian's Leasing. The Following Transactions took place in January: Date Transaction Source Purchased a computer by cheque from Impact Computers $4,600 Chq 1 (plus HST) Bob Contributed a ladder to the Business Valued at $400 Fair Market value 3 4 Journal Entry #2 Completed cash Job for Maple City construction, issued receipt for $2500 (plus HST). Receive Payment in full and deposited cash 101 in bank. Bob paid expenses for the business: Telephone $198.45 (plus HST $20.00) to Telus. Overwrite 6 Sales Receipt Chq 2 7 calculated HST Electricity $430 (plus HST) to Origin Power Chq 3 Advertising $2,000 (plus HST) to leader Papers Chq 4 Completed Job for JP Construction, 158 Keil Drive, Chatham, Ontario N7L1A1 (519) 555-1234. Invoiced $2000 (Plus HST), Terms Net 30. 8 Invoice 201 Completed cash job for Big Brothers Construction, issued receipt Sales receipt for 4,400.00 (plus HST). Received payment in full and deposited 11 102 cash in bank. Bob purchased office furniture on credit Inv B333 $700 (plus HST) Bill from Bizquip. Terms Net 30 Bob paid expenses for the business: Fuel $214(plus HST) to Echo 12 Chq 5 fuels Insurance $600 to CUG Insurance for 12 Months liability Insurance. Expense January Insurance and set up Prepaid Chq 6 Insurance for Balance. Bob drew $800 cash for his own use. Chq 7 15 Paid Brian's Leasing for the lease of the backhoe. Chq 8 Page 3 of 5 Problem Statement Step 1: You have been hired to set up a Service Company File for Bob and set up the chart of Accounts as provided by the Consulting Accountant. Step 2: You have been directed to complete the transactions for the first two weeks of January. Step 3: You receive the bank statement and process the Reconciliation. NOTE - Only complete the steps as assigned by your instructor. Required Items for Each Step Step 1 • Create the file Bob's Back Hoes – Your Name". This will help distinguish your report from the other students' assignments. • Add, Edit, Delete or Make Inactive Accounts to match the Chart of Accounts Step 2 • Process the transactions for January (including the initial capital contribution). • Print (or create a pdf) the following reports for the period January 1-16: • Chart of Accounts • Income Statement • Balance Sheet • Journals Step 3 • Complete Bank Reconciliation using the Bank Statement dated January 16 found on the next page • Print (or create a pdf) the following report for the Period January 1-16: • Bank Reconciliation Detailed Page 4 of 5 Bank Statement Using the bank statement below, prepare the bank reconciliation at January 16 CIBC Downtown Account Name Bob's Back Hoes Account No 333067 Statement for January 1-16 Date Debit Credit Balance January 2 Cash/Chqs 25,000.00 25,000.00 CR 0001 5,198.00 19,802.00 CR 6 Cash/Chqs 2,825.00 22,627.00 CR 8 0003 485.90 22,141.10 CR 11 Cash/Chqs 4,972.00 27,113.10 CR 0002 218.45 26,894.65 CR 0007 800.00 26,094.65 CR 13 Bank fee 20.00 26,074.65 CR 0006 600.00 25,474.6 CR Check figures: • Net Income: $3,987.55 • Book Value of Chequing Account after bank reconciliation: $20,712.83 BOB'S BACK HOES STUDENT EXERCISE Overview In this case-study, you, the student, will set up a new service company file using the Easy Step Interview found by clicking on Detailed Start after clicking to create a new company. As you navigate through the Easy Step Interview, you will decide the best answers to the interview based on the information presented here. You will also have the opportunity to practice setting up a Chart of Accounts, and completing Journal entries, sales, Bills, and Cheques. As an extended activity, you may be required to complete the Bank Reconciliation. Accounting Information Bob Brown has decided to start a business of his own, doing backhoe work for clients beginning January 1. He will run the business from his home at 123 Any Street, Chatham, Ontario N7M 1A1. He has obtained his Business Number and registered for Goods and Services tax. Tax rates are GST 5%, and HST 13% • Bob will use the calendar year as his fiscal year. • His first HST quarterly report period will end March 31. • Bob will only do business in Southwest Ontario. • This is a Service Based Business with no inventory. To assist with setting up the Chart of Accounts, choose 'General Service-Based Business' as the industry in the Easy Step Interview process. Set up a Service Item called Back Hoe Fees, Description Back Hoe Services, Default Tax will be HST Only. • Bob Expects to invoice some Customers and collect Payment later. • Bob will sometimes buy products and services on credit and pay his vendors later. • Attached is a Chart of Accounts Bob has been given to use with his business. QuickBooks 2019 - Assignment 2 Chart of Accounts: Туре Bank Description Chequing Account Account 10500 Chequing Account 11000 Prepaid Insurance Other current asset Prepaid Insurance Accounts Receivable Fixed Asset 12000 Accounts Receivable Accounts Receivable 13000 Home Office Equipment Home office Equipment Computer Equipment additions Computer Equipment Depreciation Fixed Asset Computer equipment additions Computer equipment Depreciation 13010 Fixed Asset 13020 Office Equipment Additions Office Equipment Depreciation Undeposited Funds 13510 Fixed Asset Office Equipment Additions Office Equipment Depreciation Undeposited funds 13520 Fixed Asset 14990 Other Current assets 15000 Equipment Fixed Asset Equipment 15010 Equipment additions Fixed Asset Equipment Additions Equipment depreciation Accounts Payable GST/HST Payable Opening Bal Equity Bob Brown Capital 15020 Fixed Asset Equipment Depreciation Accounts Payable 20000 Accounts Payable Other Current Liability HST Payable Equity Equity 25500 30000 Opening bal Equity Bob Brown capital 32000 30800 Bob Brown Withdrawals Equity Bob Brown Withdrawals 39000 Retained Earnings Equity Retained Earnings 40100 Back Hoe fees earned Income Fees 60400 Depreciation expense Expense Depreciation Expense 61000 Advertising Expense Expense Advertising Expense 62000 Back Hoe Equipment Rental Expense Back Hoe Equipment Rental 62500 Back Hoe Gas & Oil Expense Back Hoe Gas & Oil 63000 Bank fees Expense Bank fees 64000 Insurance Expense Insurance 64250 Liability Insurance Expense Liability Insurance 65000 Home Office Expense Office Supplies Utilities Expense Telephone Expense Expense Home Office Expense Office supplies 65250 Expense 65500 Expense Utilities Expense 65750 Expense Telephone Expense 66200 Professional fees Expense Professional fees 66500 Accounting Expense Expense Accounting Fees 67000 Repairs Repairs 68200 Taxes Expense Тахes 68300 Federal Expense Federal taxes 68400 Provincial Expense Provincial Transactions: On 3 January, Bob deposits $25,000 in a separate Bank Account for the Business at CIBC, downtown branch. (Create journal Entry # 1 to Debit Chequing Account and Credit B Brown, Capital) Bob has decided to lease the backhoe. The monthly payment of $2,000 (plus HST) is made on the 15th day of each month to Brian's Leasing. The Following Transactions took place in January: Date Transaction Source Purchased a computer by cheque from Impact Computers $4,600 Chq 1 (plus HST) Bob Contributed a ladder to the Business Valued at $400 Fair Market value 3 4 Journal Entry #2 Completed cash Job for Maple City construction, issued receipt for $2500 (plus HST). Receive Payment in full and deposited cash 101 in bank. Bob paid expenses for the business: Telephone $198.45 (plus HST $20.00) to Telus. Overwrite 6 Sales Receipt Chq 2 7 calculated HST Electricity $430 (plus HST) to Origin Power Chq 3 Advertising $2,000 (plus HST) to leader Papers Chq 4 Completed Job for JP Construction, 158 Keil Drive, Chatham, Ontario N7L1A1 (519) 555-1234. Invoiced $2000 (Plus HST), Terms Net 30. 8 Invoice 201 Completed cash job for Big Brothers Construction, issued receipt Sales receipt for 4,400.00 (plus HST). Received payment in full and deposited 11 102 cash in bank. Bob purchased office furniture on credit Inv B333 $700 (plus HST) Bill from Bizquip. Terms Net 30 Bob paid expenses for the business: Fuel $214(plus HST) to Echo 12 Chq 5 fuels Insurance $600 to CUG Insurance for 12 Months liability Insurance. Expense January Insurance and set up Prepaid Chq 6 Insurance for Balance. Bob drew $800 cash for his own use. Chq 7 15 Paid Brian's Leasing for the lease of the backhoe. Chq 8 Page 3 of 5 Problem Statement Step 1: You have been hired to set up a Service Company File for Bob and set up the chart of Accounts as provided by the Consulting Accountant. Step 2: You have been directed to complete the transactions for the first two weeks of January. Step 3: You receive the bank statement and process the Reconciliation. NOTE - Only complete the steps as assigned by your instructor. Required Items for Each Step Step 1 • Create the file Bob's Back Hoes – Your Name". This will help distinguish your report from the other students' assignments. • Add, Edit, Delete or Make Inactive Accounts to match the Chart of Accounts Step 2 • Process the transactions for January (including the initial capital contribution). • Print (or create a pdf) the following reports for the period January 1-16: • Chart of Accounts • Income Statement • Balance Sheet • Journals Step 3 • Complete Bank Reconciliation using the Bank Statement dated January 16 found on the next page • Print (or create a pdf) the following report for the Period January 1-16: • Bank Reconciliation Detailed Page 4 of 5 Bank Statement Using the bank statement below, prepare the bank reconciliation at January 16 CIBC Downtown Account Name Bob's Back Hoes Account No 333067 Statement for January 1-16 Date Debit Credit Balance January 2 Cash/Chqs 25,000.00 25,000.00 CR 0001 5,198.00 19,802.00 CR 6 Cash/Chqs 2,825.00 22,627.00 CR 8 0003 485.90 22,141.10 CR 11 Cash/Chqs 4,972.00 27,113.10 CR 0002 218.45 26,894.65 CR 0007 800.00 26,094.65 CR 13 Bank fee 20.00 26,074.65 CR 0006 600.00 25,474.6 CR Check figures: • Net Income: $3,987.55 • Book Value of Chequing Account after bank reconciliation: $20,712.83 BOB'S BACK HOES STUDENT EXERCISE Overview In this case-study, you, the student, will set up a new service company file using the Easy Step Interview found by clicking on Detailed Start after clicking to create a new company. As you navigate through the Easy Step Interview, you will decide the best answers to the interview based on the information presented here. You will also have the opportunity to practice setting up a Chart of Accounts, and completing Journal entries, sales, Bills, and Cheques. As an extended activity, you may be required to complete the Bank Reconciliation. Accounting Information Bob Brown has decided to start a business of his own, doing backhoe work for clients beginning January 1. He will run the business from his home at 123 Any Street, Chatham, Ontario N7M 1A1. He has obtained his Business Number and registered for Goods and Services tax. Tax rates are GST 5%, and HST 13% • Bob will use the calendar year as his fiscal year. • His first HST quarterly report period will end March 31. • Bob will only do business in Southwest Ontario. • This is a Service Based Business with no inventory. To assist with setting up the Chart of Accounts, choose 'General Service-Based Business' as the industry in the Easy Step Interview process. Set up a Service Item called Back Hoe Fees, Description Back Hoe Services, Default Tax will be HST Only. • Bob Expects to invoice some Customers and collect Payment later. • Bob will sometimes buy products and services on credit and pay his vendors later. • Attached is a Chart of Accounts Bob has been given to use with his business. QuickBooks 2019 - Assignment 2 Chart of Accounts: Туре Bank Description Chequing Account Account 10500 Chequing Account 11000 Prepaid Insurance Other current asset Prepaid Insurance Accounts Receivable Fixed Asset 12000 Accounts Receivable Accounts Receivable 13000 Home Office Equipment Home office Equipment Computer Equipment additions Computer Equipment Depreciation Fixed Asset Computer equipment additions Computer equipment Depreciation 13010 Fixed Asset 13020 Office Equipment Additions Office Equipment Depreciation Undeposited Funds 13510 Fixed Asset Office Equipment Additions Office Equipment Depreciation Undeposited funds 13520 Fixed Asset 14990 Other Current assets 15000 Equipment Fixed Asset Equipment 15010 Equipment additions Fixed Asset Equipment Additions Equipment depreciation Accounts Payable GST/HST Payable Opening Bal Equity Bob Brown Capital 15020 Fixed Asset Equipment Depreciation Accounts Payable 20000 Accounts Payable Other Current Liability HST Payable Equity Equity 25500 30000 Opening bal Equity Bob Brown capital 32000 30800 Bob Brown Withdrawals Equity Bob Brown Withdrawals 39000 Retained Earnings Equity Retained Earnings 40100 Back Hoe fees earned Income Fees 60400 Depreciation expense Expense Depreciation Expense 61000 Advertising Expense Expense Advertising Expense 62000 Back Hoe Equipment Rental Expense Back Hoe Equipment Rental 62500 Back Hoe Gas & Oil Expense Back Hoe Gas & Oil 63000 Bank fees Expense Bank fees 64000 Insurance Expense Insurance 64250 Liability Insurance Expense Liability Insurance 65000 Home Office Expense Office Supplies Utilities Expense Telephone Expense Expense Home Office Expense Office supplies 65250 Expense 65500 Expense Utilities Expense 65750 Expense Telephone Expense 66200 Professional fees Expense Professional fees 66500 Accounting Expense Expense Accounting Fees 67000 Repairs Repairs 68200 Taxes Expense Тахes 68300 Federal Expense Federal taxes 68400 Provincial Expense Provincial Transactions: On 3 January, Bob deposits $25,000 in a separate Bank Account for the Business at CIBC, downtown branch. (Create journal Entry # 1 to Debit Chequing Account and Credit B Brown, Capital) Bob has decided to lease the backhoe. The monthly payment of $2,000 (plus HST) is made on the 15th day of each month to Brian's Leasing. The Following Transactions took place in January: Date Transaction Source Purchased a computer by cheque from Impact Computers $4,600 Chq 1 (plus HST) Bob Contributed a ladder to the Business Valued at $400 Fair Market value 3 4 Journal Entry #2 Completed cash Job for Maple City construction, issued receipt for $2500 (plus HST). Receive Payment in full and deposited cash 101 in bank. Bob paid expenses for the business: Telephone $198.45 (plus HST $20.00) to Telus. Overwrite 6 Sales Receipt Chq 2 7 calculated HST Electricity $430 (plus HST) to Origin Power Chq 3 Advertising $2,000 (plus HST) to leader Papers Chq 4 Completed Job for JP Construction, 158 Keil Drive, Chatham, Ontario N7L1A1 (519) 555-1234. Invoiced $2000 (Plus HST), Terms Net 30. 8 Invoice 201 Completed cash job for Big Brothers Construction, issued receipt Sales receipt for 4,400.00 (plus HST). Received payment in full and deposited 11 102 cash in bank. Bob purchased office furniture on credit Inv B333 $700 (plus HST) Bill from Bizquip. Terms Net 30 Bob paid expenses for the business: Fuel $214(plus HST) to Echo 12 Chq 5 fuels Insurance $600 to CUG Insurance for 12 Months liability Insurance. Expense January Insurance and set up Prepaid Chq 6 Insurance for Balance. Bob drew $800 cash for his own use. Chq 7 15 Paid Brian's Leasing for the lease of the backhoe. Chq 8 Page 3 of 5 Problem Statement Step 1: You have been hired to set up a Service Company File for Bob and set up the chart of Accounts as provided by the Consulting Accountant. Step 2: You have been directed to complete the transactions for the first two weeks of January. Step 3: You receive the bank statement and process the Reconciliation. NOTE - Only complete the steps as assigned by your instructor. Required Items for Each Step Step 1 • Create the file Bob's Back Hoes – Your Name". This will help distinguish your report from the other students' assignments. • Add, Edit, Delete or Make Inactive Accounts to match the Chart of Accounts Step 2 • Process the transactions for January (including the initial capital contribution). • Print (or create a pdf) the following reports for the period January 1-16: • Chart of Accounts • Income Statement • Balance Sheet • Journals Step 3 • Complete Bank Reconciliation using the Bank Statement dated January 16 found on the next page • Print (or create a pdf) the following report for the Period January 1-16: • Bank Reconciliation Detailed Page 4 of 5 Bank Statement Using the bank statement below, prepare the bank reconciliation at January 16 CIBC Downtown Account Name Bob's Back Hoes Account No 333067 Statement for January 1-16 Date Debit Credit Balance January 2 Cash/Chqs 25,000.00 25,000.00 CR 0001 5,198.00 19,802.00 CR 6 Cash/Chqs 2,825.00 22,627.00 CR 8 0003 485.90 22,141.10 CR 11 Cash/Chqs 4,972.00 27,113.10 CR 0002 218.45 26,894.65 CR 0007 800.00 26,094.65 CR 13 Bank fee 20.00 26,074.65 CR 0006 600.00 25,474.6 CR Check figures: • Net Income: $3,987.55 • Book Value of Chequing Account after bank reconciliation: $20,712.83 BOB'S BACK HOES STUDENT EXERCISE Overview In this case-study, you, the student, will set up a new service company file using the Easy Step Interview found by clicking on Detailed Start after clicking to create a new company. As you navigate through the Easy Step Interview, you will decide the best answers to the interview based on the information presented here. You will also have the opportunity to practice setting up a Chart of Accounts, and completing Journal entries, sales, Bills, and Cheques. As an extended activity, you may be required to complete the Bank Reconciliation. Accounting Information Bob Brown has decided to start a business of his own, doing backhoe work for clients beginning January 1. He will run the business from his home at 123 Any Street, Chatham, Ontario N7M 1A1. He has obtained his Business Number and registered for Goods and Services tax. Tax rates are GST 5%, and HST 13% • Bob will use the calendar year as his fiscal year. • His first HST quarterly report period will end March 31. • Bob will only do business in Southwest Ontario. • This is a Service Based Business with no inventory. To assist with setting up the Chart of Accounts, choose 'General Service-Based Business' as the industry in the Easy Step Interview process. Set up a Service Item called Back Hoe Fees, Description Back Hoe Services, Default Tax will be HST Only. • Bob Expects to invoice some Customers and collect Payment later. • Bob will sometimes buy products and services on credit and pay his vendors later. • Attached is a Chart of Accounts Bob has been given to use with his business. QuickBooks 2019 - Assignment 2 Chart of Accounts: Туре Bank Description Chequing Account Account 10500 Chequing Account 11000 Prepaid Insurance Other current asset Prepaid Insurance Accounts Receivable Fixed Asset 12000 Accounts Receivable Accounts Receivable 13000 Home Office Equipment Home office Equipment Computer Equipment additions Computer Equipment Depreciation Fixed Asset Computer equipment additions Computer equipment Depreciation 13010 Fixed Asset 13020 Office Equipment Additions Office Equipment Depreciation Undeposited Funds 13510 Fixed Asset Office Equipment Additions Office Equipment Depreciation Undeposited funds 13520 Fixed Asset 14990 Other Current assets 15000 Equipment Fixed Asset Equipment 15010 Equipment additions Fixed Asset Equipment Additions Equipment depreciation Accounts Payable GST/HST Payable Opening Bal Equity Bob Brown Capital 15020 Fixed Asset Equipment Depreciation Accounts Payable 20000 Accounts Payable Other Current Liability HST Payable Equity Equity 25500 30000 Opening bal Equity Bob Brown capital 32000 30800 Bob Brown Withdrawals Equity Bob Brown Withdrawals 39000 Retained Earnings Equity Retained Earnings 40100 Back Hoe fees earned Income Fees 60400 Depreciation expense Expense Depreciation Expense 61000 Advertising Expense Expense Advertising Expense 62000 Back Hoe Equipment Rental Expense Back Hoe Equipment Rental 62500 Back Hoe Gas & Oil Expense Back Hoe Gas & Oil 63000 Bank fees Expense Bank fees 64000 Insurance Expense Insurance 64250 Liability Insurance Expense Liability Insurance 65000 Home Office Expense Office Supplies Utilities Expense Telephone Expense Expense Home Office Expense Office supplies 65250 Expense 65500 Expense Utilities Expense 65750 Expense Telephone Expense 66200 Professional fees Expense Professional fees 66500 Accounting Expense Expense Accounting Fees 67000 Repairs Repairs 68200 Taxes Expense Тахes 68300 Federal Expense Federal taxes 68400 Provincial Expense Provincial Transactions: On 3 January, Bob deposits $25,000 in a separate Bank Account for the Business at CIBC, downtown branch. (Create journal Entry # 1 to Debit Chequing Account and Credit B Brown, Capital) Bob has decided to lease the backhoe. The monthly payment of $2,000 (plus HST) is made on the 15th day of each month to Brian's Leasing. The Following Transactions took place in January: Date Transaction Source Purchased a computer by cheque from Impact Computers $4,600 Chq 1 (plus HST) Bob Contributed a ladder to the Business Valued at $400 Fair Market value 3 4 Journal Entry #2 Completed cash Job for Maple City construction, issued receipt for $2500 (plus HST). Receive Payment in full and deposited cash 101 in bank. Bob paid expenses for the business: Telephone $198.45 (plus HST $20.00) to Telus. Overwrite 6 Sales Receipt Chq 2 7 calculated HST Electricity $430 (plus HST) to Origin Power Chq 3 Advertising $2,000 (plus HST) to leader Papers Chq 4 Completed Job for JP Construction, 158 Keil Drive, Chatham, Ontario N7L1A1 (519) 555-1234. Invoiced $2000 (Plus HST), Terms Net 30. 8 Invoice 201 Completed cash job for Big Brothers Construction, issued receipt Sales receipt for 4,400.00 (plus HST). Received payment in full and deposited 11 102 cash in bank. Bob purchased office furniture on credit Inv B333 $700 (plus HST) Bill from Bizquip. Terms Net 30 Bob paid expenses for the business: Fuel $214(plus HST) to Echo 12 Chq 5 fuels Insurance $600 to CUG Insurance for 12 Months liability Insurance. Expense January Insurance and set up Prepaid Chq 6 Insurance for Balance. Bob drew $800 cash for his own use. Chq 7 15 Paid Brian's Leasing for the lease of the backhoe. Chq 8 Page 3 of 5 Problem Statement Step 1: You have been hired to set up a Service Company File for Bob and set up the chart of Accounts as provided by the Consulting Accountant. Step 2: You have been directed to complete the transactions for the first two weeks of January. Step 3: You receive the bank statement and process the Reconciliation. NOTE - Only complete the steps as assigned by your instructor. Required Items for Each Step Step 1 • Create the file Bob's Back Hoes – Your Name". This will help distinguish your report from the other students' assignments. • Add, Edit, Delete or Make Inactive Accounts to match the Chart of Accounts Step 2 • Process the transactions for January (including the initial capital contribution). • Print (or create a pdf) the following reports for the period January 1-16: • Chart of Accounts • Income Statement • Balance Sheet • Journals Step 3 • Complete Bank Reconciliation using the Bank Statement dated January 16 found on the next page • Print (or create a pdf) the following report for the Period January 1-16: • Bank Reconciliation Detailed Page 4 of 5 Bank Statement Using the bank statement below, prepare the bank reconciliation at January 16 CIBC Downtown Account Name Bob's Back Hoes Account No 333067 Statement for January 1-16 Date Debit Credit Balance January 2 Cash/Chqs 25,000.00 25,000.00 CR 0001 5,198.00 19,802.00 CR 6 Cash/Chqs 2,825.00 22,627.00 CR 8 0003 485.90 22,141.10 CR 11 Cash/Chqs 4,972.00 27,113.10 CR 0002 218.45 26,894.65 CR 0007 800.00 26,094.65 CR 13 Bank fee 20.00 26,074.65 CR 0006 600.00 25,474.6 CR Check figures: • Net Income: $3,987.55 • Book Value of Chequing Account after bank reconciliation: $20,712.83 BOB'S BACK HOES STUDENT EXERCISE Overview In this case-study, you, the student, will set up a new service company file using the Easy Step Interview found by clicking on Detailed Start after clicking to create a new company. As you navigate through the Easy Step Interview, you will decide the best answers to the interview based on the information presented here. You will also have the opportunity to practice setting up a Chart of Accounts, and completing Journal entries, sales, Bills, and Cheques. As an extended activity, you may be required to complete the Bank Reconciliation. Accounting Information Bob Brown has decided to start a business of his own, doing backhoe work for clients beginning January 1. He will run the business from his home at 123 Any Street, Chatham, Ontario N7M 1A1. He has obtained his Business Number and registered for Goods and Services tax. Tax rates are GST 5%, and HST 13% • Bob will use the calendar year as his fiscal year. • His first HST quarterly report period will end March 31. • Bob will only do business in Southwest Ontario. • This is a Service Based Business with no inventory. To assist with setting up the Chart of Accounts, choose 'General Service-Based Business' as the industry in the Easy Step Interview process. Set up a Service Item called Back Hoe Fees, Description Back Hoe Services, Default Tax will be HST Only. • Bob Expects to invoice some Customers and collect Payment later. • Bob will sometimes buy products and services on credit and pay his vendors later. • Attached is a Chart of Accounts Bob has been given to use with his business. QuickBooks 2019 - Assignment 2 Chart of Accounts: Туре Bank Description Chequing Account Account 10500 Chequing Account 11000 Prepaid Insurance Other current asset Prepaid Insurance Accounts Receivable Fixed Asset 12000 Accounts Receivable Accounts Receivable 13000 Home Office Equipment Home office Equipment Computer Equipment additions Computer Equipment Depreciation Fixed Asset Computer equipment additions Computer equipment Depreciation 13010 Fixed Asset 13020 Office Equipment Additions Office Equipment Depreciation Undeposited Funds 13510 Fixed Asset Office Equipment Additions Office Equipment Depreciation Undeposited funds 13520 Fixed Asset 14990 Other Current assets 15000 Equipment Fixed Asset Equipment 15010 Equipment additions Fixed Asset Equipment Additions Equipment depreciation Accounts Payable GST/HST Payable Opening Bal Equity Bob Brown Capital 15020 Fixed Asset Equipment Depreciation Accounts Payable 20000 Accounts Payable Other Current Liability HST Payable Equity Equity 25500 30000 Opening bal Equity Bob Brown capital 32000 30800 Bob Brown Withdrawals Equity Bob Brown Withdrawals 39000 Retained Earnings Equity Retained Earnings 40100 Back Hoe fees earned Income Fees 60400 Depreciation expense Expense Depreciation Expense 61000 Advertising Expense Expense Advertising Expense 62000 Back Hoe Equipment Rental Expense Back Hoe Equipment Rental 62500 Back Hoe Gas & Oil Expense Back Hoe Gas & Oil 63000 Bank fees Expense Bank fees 64000 Insurance Expense Insurance 64250 Liability Insurance Expense Liability Insurance 65000 Home Office Expense Office Supplies Utilities Expense Telephone Expense Expense Home Office Expense Office supplies 65250 Expense 65500 Expense Utilities Expense 65750 Expense Telephone Expense 66200 Professional fees Expense Professional fees 66500 Accounting Expense Expense Accounting Fees 67000 Repairs Repairs 68200 Taxes Expense Тахes 68300 Federal Expense Federal taxes 68400 Provincial Expense Provincial Transactions: On 3 January, Bob deposits $25,000 in a separate Bank Account for the Business at CIBC, downtown branch. (Create journal Entry # 1 to Debit Chequing Account and Credit B Brown, Capital) Bob has decided to lease the backhoe. The monthly payment of $2,000 (plus HST) is made on the 15th day of each month to Brian's Leasing. The Following Transactions took place in January: Date Transaction Source Purchased a computer by cheque from Impact Computers $4,600 Chq 1 (plus HST) Bob Contributed a ladder to the Business Valued at $400 Fair Market value 3 4 Journal Entry #2 Completed cash Job for Maple City construction, issued receipt for $2500 (plus HST). Receive Payment in full and deposited cash 101 in bank. Bob paid expenses for the business: Telephone $198.45 (plus HST $20.00) to Telus. Overwrite 6 Sales Receipt Chq 2 7 calculated HST Electricity $430 (plus HST) to Origin Power Chq 3 Advertising $2,000 (plus HST) to leader Papers Chq 4 Completed Job for JP Construction, 158 Keil Drive, Chatham, Ontario N7L1A1 (519) 555-1234. Invoiced $2000 (Plus HST), Terms Net 30. 8 Invoice 201 Completed cash job for Big Brothers Construction, issued receipt Sales receipt for 4,400.00 (plus HST). Received payment in full and deposited 11 102 cash in bank. Bob purchased office furniture on credit Inv B333 $700 (plus HST) Bill from Bizquip. Terms Net 30 Bob paid expenses for the business: Fuel $214(plus HST) to Echo 12 Chq 5 fuels Insurance $600 to CUG Insurance for 12 Months liability Insurance. Expense January Insurance and set up Prepaid Chq 6 Insurance for Balance. Bob drew $800 cash for his own use. Chq 7 15 Paid Brian's Leasing for the lease of the backhoe. Chq 8 Page 3 of 5 Problem Statement Step 1: You have been hired to set up a Service Company File for Bob and set up the chart of Accounts as provided by the Consulting Accountant. Step 2: You have been directed to complete the transactions for the first two weeks of January. Step 3: You receive the bank statement and process the Reconciliation. NOTE - Only complete the steps as assigned by your instructor. Required Items for Each Step Step 1 • Create the file Bob's Back Hoes – Your Name". This will help distinguish your report from the other students' assignments. • Add, Edit, Delete or Make Inactive Accounts to match the Chart of Accounts Step 2 • Process the transactions for January (including the initial capital contribution). • Print (or create a pdf) the following reports for the period January 1-16: • Chart of Accounts • Income Statement • Balance Sheet • Journals Step 3 • Complete Bank Reconciliation using the Bank Statement dated January 16 found on the next page • Print (or create a pdf) the following report for the Period January 1-16: • Bank Reconciliation Detailed Page 4 of 5 Bank Statement Using the bank statement below, prepare the bank reconciliation at January 16 CIBC Downtown Account Name Bob's Back Hoes Account No 333067 Statement for January 1-16 Date Debit Credit Balance January 2 Cash/Chqs 25,000.00 25,000.00 CR 0001 5,198.00 19,802.00 CR 6 Cash/Chqs 2,825.00 22,627.00 CR 8 0003 485.90 22,141.10 CR 11 Cash/Chqs 4,972.00 27,113.10 CR 0002 218.45 26,894.65 CR 0007 800.00 26,094.65 CR 13 Bank fee 20.00 26,074.65 CR 0006 600.00 25,474.6 CR Check figures: • Net Income: $3,987.55 • Book Value of Chequing Account after bank reconciliation: $20,712.83 BOB'S BACK HOES STUDENT EXERCISE Overview In this case-study, you, the student, will set up a new service company file using the Easy Step Interview found by clicking on Detailed Start after clicking to create a new company. As you navigate through the Easy Step Interview, you will decide the best answers to the interview based on the information presented here. You will also have the opportunity to practice setting up a Chart of Accounts, and completing Journal entries, sales, Bills, and Cheques. As an extended activity, you may be required to complete the Bank Reconciliation. Accounting Information Bob Brown has decided to start a business of his own, doing backhoe work for clients beginning January 1. He will run the business from his home at 123 Any Street, Chatham, Ontario N7M 1A1. He has obtained his Business Number and registered for Goods and Services tax. Tax rates are GST 5%, and HST 13% • Bob will use the calendar year as his fiscal year. • His first HST quarterly report period will end March 31. • Bob will only do business in Southwest Ontario. • This is a Service Based Business with no inventory. To assist with setting up the Chart of Accounts, choose 'General Service-Based Business' as the industry in the Easy Step Interview process. Set up a Service Item called Back Hoe Fees, Description Back Hoe Services, Default Tax will be HST Only. • Bob Expects to invoice some Customers and collect Payment later. • Bob will sometimes buy products and services on credit and pay his vendors later. • Attached is a Chart of Accounts Bob has been given to use with his business. QuickBooks 2019 - Assignment 2 Chart of Accounts: Туре Bank Description Chequing Account Account 10500 Chequing Account 11000 Prepaid Insurance Other current asset Prepaid Insurance Accounts Receivable Fixed Asset 12000 Accounts Receivable Accounts Receivable 13000 Home Office Equipment Home office Equipment Computer Equipment additions Computer Equipment Depreciation Fixed Asset Computer equipment additions Computer equipment Depreciation 13010 Fixed Asset 13020 Office Equipment Additions Office Equipment Depreciation Undeposited Funds 13510 Fixed Asset Office Equipment Additions Office Equipment Depreciation Undeposited funds 13520 Fixed Asset 14990 Other Current assets 15000 Equipment Fixed Asset Equipment 15010 Equipment additions Fixed Asset Equipment Additions Equipment depreciation Accounts Payable GST/HST Payable Opening Bal Equity Bob Brown Capital 15020 Fixed Asset Equipment Depreciation Accounts Payable 20000 Accounts Payable Other Current Liability HST Payable Equity Equity 25500 30000 Opening bal Equity Bob Brown capital 32000 30800 Bob Brown Withdrawals Equity Bob Brown Withdrawals 39000 Retained Earnings Equity Retained Earnings 40100 Back Hoe fees earned Income Fees 60400 Depreciation expense Expense Depreciation Expense 61000 Advertising Expense Expense Advertising Expense 62000 Back Hoe Equipment Rental Expense Back Hoe Equipment Rental 62500 Back Hoe Gas & Oil Expense Back Hoe Gas & Oil 63000 Bank fees Expense Bank fees 64000 Insurance Expense Insurance 64250 Liability Insurance Expense Liability Insurance 65000 Home Office Expense Office Supplies Utilities Expense Telephone Expense Expense Home Office Expense Office supplies 65250 Expense 65500 Expense Utilities Expense 65750 Expense Telephone Expense 66200 Professional fees Expense Professional fees 66500 Accounting Expense Expense Accounting Fees 67000 Repairs Repairs 68200 Taxes Expense Тахes 68300 Federal Expense Federal taxes 68400 Provincial Expense Provincial Transactions: On 3 January, Bob deposits $25,000 in a separate Bank Account for the Business at CIBC, downtown branch. (Create journal Entry # 1 to Debit Chequing Account and Credit B Brown, Capital) Bob has decided to lease the backhoe. The monthly payment of $2,000 (plus HST) is made on the 15th day of each month to Brian's Leasing. The Following Transactions took place in January: Date Transaction Source Purchased a computer by cheque from Impact Computers $4,600 Chq 1 (plus HST) Bob Contributed a ladder to the Business Valued at $400 Fair Market value 3 4 Journal Entry #2 Completed cash Job for Maple City construction, issued receipt for $2500 (plus HST). Receive Payment in full and deposited cash 101 in bank. Bob paid expenses for the business: Telephone $198.45 (plus HST $20.00) to Telus. Overwrite 6 Sales Receipt Chq 2 7 calculated HST Electricity $430 (plus HST) to Origin Power Chq 3 Advertising $2,000 (plus HST) to leader Papers Chq 4 Completed Job for JP Construction, 158 Keil Drive, Chatham, Ontario N7L1A1 (519) 555-1234. Invoiced $2000 (Plus HST), Terms Net 30. 8 Invoice 201 Completed cash job for Big Brothers Construction, issued receipt Sales receipt for 4,400.00 (plus HST). Received payment in full and deposited 11 102 cash in bank. Bob purchased office furniture on credit Inv B333 $700 (plus HST) Bill from Bizquip. Terms Net 30 Bob paid expenses for the business: Fuel $214(plus HST) to Echo 12 Chq 5 fuels Insurance $600 to CUG Insurance for 12 Months liability Insurance. Expense January Insurance and set up Prepaid Chq 6 Insurance for Balance. Bob drew $800 cash for his own use. Chq 7 15 Paid Brian's Leasing for the lease of the backhoe. Chq 8 Page 3 of 5 Problem Statement Step 1: You have been hired to set up a Service Company File for Bob and set up the chart of Accounts as provided by the Consulting Accountant. Step 2: You have been directed to complete the transactions for the first two weeks of January. Step 3: You receive the bank statement and process the Reconciliation. NOTE - Only complete the steps as assigned by your instructor. Required Items for Each Step Step 1 • Create the file Bob's Back Hoes – Your Name". This will help distinguish your report from the other students' assignments. • Add, Edit, Delete or Make Inactive Accounts to match the Chart of Accounts Step 2 • Process the transactions for January (including the initial capital contribution). • Print (or create a pdf) the following reports for the period January 1-16: • Chart of Accounts • Income Statement • Balance Sheet • Journals Step 3 • Complete Bank Reconciliation using the Bank Statement dated January 16 found on the next page • Print (or create a pdf) the following report for the Period January 1-16: • Bank Reconciliation Detailed Page 4 of 5 Bank Statement Using the bank statement below, prepare the bank reconciliation at January 16 CIBC Downtown Account Name Bob's Back Hoes Account No 333067 Statement for January 1-16 Date Debit Credit Balance January 2 Cash/Chqs 25,000.00 25,000.00 CR 0001 5,198.00 19,802.00 CR 6 Cash/Chqs 2,825.00 22,627.00 CR 8 0003 485.90 22,141.10 CR 11 Cash/Chqs 4,972.00 27,113.10 CR 0002 218.45 26,894.65 CR 0007 800.00 26,094.65 CR 13 Bank fee 20.00 26,074.65 CR 0006 600.00 25,474.6 CR Check figures: • Net Income: $3,987.55 • Book Value of Chequing Account after bank reconciliation: $20,712.83
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
You are helping a friend, Jonah, set up a new accounting system for a small start-up construction company. He specializes in custom, energy efficient homes that are built on a cost-plus basis....
-
Agnes is an elderly woman with osteoporosis. She recently sustained a severe bone fracture for no apparent reason (she did not fall or otherwise injure herself). The fracture was not treated for some...
-
A company wants to set up a new office in a country where the corporate tax rate is as follows: 15% of first $50,000 profits, 25% of next $25,000, 34% of next $25,000, and 39% of everything over...
-
A hospital radiology department has the following activities: Activity Number Activity Description 1 Repair X-ray equipment 2 Taking X-ray with X-ray...
-
Consider the reaction of methane, CH4, with oxygen, O2, discussed in Section 6.5. How would you set up the calculation if the problem had been to compute the heat if 10.0 g H2O were produced (instead...
-
A square loop of wire has a perimeter of \(4.00 \mathrm{~m}\) and is oriented such that two of its parallel sides form a \(25.0^{\circ}\) angle with the horizontal. A uniform horizontal magnetic...
-
In order to reduce material costs, a composite panel is to be made by placing fibers in the matrix material in an X-pattern of \(\pm \alpha\) as shown in Figure 6.46, instead of randomly distributing...
-
Son, Inc., and Clef, Inc., are both taxable domestic C corporations. Using the information in the exhibits, enter either the correct amount or holding period (in a number of months) for each item...
-
Find dx dt dx - dt at x= dy =-4 if y = x + 2 and = dt 1.
-
The Tamer Tire Company provided the following partial trial balance for the current year ended December 31. The company is subject to a 40% income tax rate. Required a. Prepare a single- step income...
-
Required: 1 What are the balances that will be impacted if the company decides to convert to IFRS? 2 What are the journal entries that the company would have to record to make the adjustment to...
-
Are there any groups of people in the United States that you think should be covered by federal laws as a protected group but are not currently covered? Why or why not?
-
The natural rate of unemployment Suppose that the markup of the prices of products over wage cost, \(z\), is \(10 \%\), and that the wage-setting equation is \[ W=P(1-2 m+z) \] where \(m\) is the...
-
It is the beginning of September and you have been offered the following deal to go heli-skiing. If you pick the first week in January and pay for your vacation now, you can get a week of heli-skiing...
-
Discuss the following statements. a. The Phillips curve implies that when an economy is operating below full capacity, a significant increase in aggregate demand is likely to cause a reduction in...
-
You own a wholesale plumbing supply store. The store currently generates revenues of $1 million per year. Next year, revenues will either decrease by 9.6% or increase by 4.8%, with equal probability,...
-
The beginning inventory of merchandise at Rhodes Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Date Transaction Number of Units Per Unit Total Apr. 3...
-
Dr. Chan obtained a $15,000 demand loan at prime plus 1.5% on September 13 from the Bank of Montreal to purchase a new dental X-ray machine. Fixed payments of $700 will be deducted from the dentists...
-
A group of businessmen formed a partnership to buy and race an Indianapolis-type racing car. They agreed to pay an individual $50,000 for the car and associated equipment. The payment was to be in a...
-
Find the best alternative using incremental IRR analysis. A B D Initial cost $2000 4000 5000 3000 Annual benefit 800 1300 500 400 Salvage value 1400 2000 1500 3000 Life, in years 6 4 MARR required 6%...
-
Ann deposits $100 at the end of each month into her bank savings account. The bank paid 6% nominal interest, compounded and paid quarterly. No interest was paid on money not in the account for the...
-
Let \(X_{1}, X_{2}, \ldots, X_{5}\) be 5 independent random variables. Find the moment generating function \[M_{\sum X_{i}}(t)=E\left(e^{t\left(X_{1}+X_{2}+\cdots+X_{5} ight)} ight)\] of the sum when...
-
Let \(X_{1}, X_{2}\), and \(X_{3}\) be independent normal variables with \[\begin{array}{lll}E\left(X_{1} ight)=5 & \text { and } & \sigma_{1}^{2}=9 \\E\left(X_{2} ight)=-2 & \text { and } &...
-
Refer to Exercise 6.36. (a) Show that \(2 X_{1}-X_{2}-4 X_{3}-12\) has a normal distribution. (b) Find the mean and variance of the random variable in part (a). Data From Exercise 6.36 6.36 Let X1,...
Study smarter with the SolutionInn App