Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PROJECT SPECIFICATIONS The information provided in this test allows you to set up the General, Payables and Receivables ledgers for an Ontario company named GEORGE'S

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
PROJECT SPECIFICATIONS The information provided in this test allows you to set up the General, Payables and Receivables ledgers for an Ontario company named GEORGE'S WELDING owned and run by Chris George, a master welder. He performs all kinds of welding jobs for individuals as well as companies. George has contracted youa to set up his company to use Sage 50 Accounting for general ledger, accounts receivable and accounts payable. DO EACH OF THE FOLLOWING TASKS IN ORDER 1. Using Sage 50 Accounting, create a new company file using the following information Company Name: NOTE: Be sure to include your name as part of the company name so the reports you print and hand in to George's Welding-(Your Name) your instructor will be properly identified. 33 Maple St. Windsor, Ontario N9S 4B6 Address: Phone: (519) 653-8383 07-01-2022 Fax: (519) 653-7700 Fiscal start Earliest transaction date:07-01-2022 Fiscal end: Select: Let me build the list of accounts myself after the company is created Industry: Store company files in a new folder named George and use George as the file name. Select: I will update my tax information myself 12-31-2022 Service Working from the Company module window, change default settings if necessary to include the following: 2. Use Accounting Terms Automatically save changes to Suppliers, Clients and Other Records Show list buttons Turn off Checklists and Daily Business Manager at startup and after changing session date Turn off Employee & Payroll, Inventory & Services, Project and Time & Billing Turn on Change Session Date at startup Turn on confirmation message Box User Preferences Options User Preferences View User Preferences Transaction Company Information Settings Company System Settings Business No: 342 121 190 Do not allow transactions dated before 07-01-2022 Do not allow transactions in future Backup frequency: Weekly; turn off automatic backups Company does not use quotes, orders, packing slips and project Company does business in French and English Next Client & Sales Invoice number: 121 Company Backup Settings Company Features Settings Company Forms Settings Next Receipts number: 297 Month, day, year. Use long date format on the screen and in reports Company Date Format Settings Computerized Accounting with Sage 50 Level 1 (S110) Final Project 1 Page 3 3. Create accounts to match the following Chart of Accounts. Edit the current earnings 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. GEORGE'S WELDING Chart of Accounts 1000 CURRENT ASSETS (H) 1050 Test Balance 1080 Bank: Chequing Account 1100 Bank: Credit Card 1200 Accounts Receivable 1290 Welding Supplies 1390 TOTAL CURRENT ASSETS (T) 5000 EXPENSES (H) 5020 Advertising 5030 Bank and Credit Card Fees 5040 Cleaning and Maintenance 5060 Hydro Expense 5220 Insurance Expense 5240 Interest Expense 5260 Telephone Expense 5270 Payroll Service Fees 5280 Welding Supplies Used 5590 TOTAL EXPENSES (T) 1400 CAPITAL ASSETS (H) 1420 Torches 1450 Computers 1480 Other Welding Equipment 1500 Vehicle 1550 Shop 1590 TOTAL CAPITAL ASSETS (T) 2000 CURRENT LIABILITIES (H) 2100 Bank Loan 2200 Accounts Payable 2250 Credit Card Payable 2650 HST Charged on Services (A) 2670 HST Paid on Purchases (A) 2750 HST Owing (Refund) (S) 2790 TOTAL CURRENT LIABILITIES (T) 2800 LONG TERM LIABILITIES (H) 2850 Mortgage Payable 2890 TOTAL LONG TERM LIABILITIES (T) 3000 OWNERS' EQUITY (H) 3560 Chris George, Capital 3600 Net Income (X) 3690 TOTAL OWNERS' EQUITY (T) 4000 REVENUE (H) 4020 Revenue from Services 4100 Sales Allowances 4200 Sales Discounts 4390 TOTAL REVENUE (T) Computerized Accounting with Sage 50 Level 1 (SI10) Final Project 1 Page 4 Back to l Add account balances from the following Trial Balance 4. GEORGE'S WELDING Post-Closing Trial Balance July 1, 2022 1080 Bank: Chequing Account 1100 Bank: Credit Card 1200 Accounts Receivable $12 150 200 5 000 1260 Welding Supplies 1420 Welding Torches 1450 Computer 1480 Other Welding Equipment 900 3 800 1 500 4 200 9 000 150 000 1500 Vehicle 1550 Shop 2100 Bank Loan $6 000 1 600 1 100 950 2200 Accounts Payable 2250 Credit Card Payable 2650 HST Charged on Services 2670 HST Paid on Purchases 2850 Mortgage Payable 3560 Chris George, Capital 750 99 000 78 850 $187 500 $187 500 Hint: Remember to use account 1050 Test Balance for out of balance amounts. ideman 5. Change Account Classes: Bank: Chequing Account: Change the account class to Bank and enter 201 as the next cheque number. Bank: Credit Card: Change the account class to Credit Card Receivable. Credit Card Payable: Change the account class to Credit Card Payable. Expense Group accounts: Change the account class to Expense. 6. Set up credit cards as follows: Credit Cards Accepted: Credit Card Name: Chargit Currency CAD Linked Asset Account 1100 Discount Fees: 3% Linked Expense Account: 5030 Credit Card name: Chargit Linked Payable Account: 2250 Linked Expense Account: 5030 Credit Cards Used: 7. Enter Sales Taxes and Tax Codes (do not enter accounts to track PST) Tax-HST: Not Exempt, Not Taxable, Use 2670 to track tax paid on expenses Use 2650 to track taxes charged on revenues, Report on taxes Tax HST, Taxable, Rate 13 % , Not included, Refundable Tax HST, Taxable, Rate 13 % , Included, Refundable Code - H: Code - HI: Computerized Accounting with Sage 50 Level 1 (SI10) Final Project 1 Page 5 Save saq Jouner H AM C Enter Ledger Settings: General (Accounts) - Linked Accounts Allow account classes to change. Badgeting should be turmed off Retained Eanings 3560 Current Eamings 3600 Windsor, Ontario, Canada Aging periods: 30, 60 and 90 days Calculate all discounts after tax for one time suppliers Principal Bank Account 1080 Accounts Payable 2200 Early Payment Purchase Discount and Freight Expense: leave blank Prepayments and Prepaid Orders 2200 Windsor, Ontario, Canada Aging periods: 5, 15 and 30 days No interest charges on overdue accounts Include invoices paid in last 30 days Use tax code H as default for new customers Terms: 2% discount in 5 days (after tax), net in 15 days Line discounts not used On sales invoices: "Where fire meets steel" Principal Bank Account 1080 Accounts Receivable 1200 Default Revenue 4020- Freight Revenue: leave blank Early Payment Sales Discount 4200 Deposits and Prepaid Orders 1200 Payables: Address -Options Sh - Linked Accounts Receivables: Address -Options Discounts -Comment Linked accounts 8. Create the following supplier accounts Add the historical information provided. Name (Contact), Address Phone/Fax Tel: (905) 310-5221 Terms. Tax, Account Terms: net 10 Tax Code: HI Expense Account 5260 Telephone Expense Bell Canada 339 Jupiter Ave, Toronto, ON R4S 6T3 Web: www.bell.ca Supplier since: 12/01/2005 Tel: (902) 821-8186 Terms: net 1 Tax Code: No tax (tax exempt-yes) Receiver General for Canada (Margot Taxit) Summerside Tax Centre, Summerside PE CIN 6L2 Web: www.cra-arc.ge.ca Supplier since: 12/01/2005 Tel: (226) 593-7191 Fax: (226) 593-1772 Terms: net 20 Tax Code: H Expense Account 5020 Advertising Welding Monthly (Leo Libra) 29 Taurus Lane, London, ON R4V 2V7 Tax ID: 493 421 289 E-mail: look.up@weld.com Supplier since: 06/12/2006 Terms: net 30 Tax Code: H Expense Account 1480 Other Welding Equipment Tel: (519) 592-6282 Fax: (519) 592-8164 Welds 'r Us (Vulcan Sidekick) 81 Aquarian Way, Chatham, On R3T 2C9 Tax ID: 563 327 766 E-mail: weldall@welds.com Supplier since: 01/15/2008 Computerized Accounting with Sage 50 Level 1 (S110) Final Project 1 Page 6 Minut Historical Supplier Inveices and Payments Name Bell Canada Terms net 10 Date Jun 28/22 Invoice/Chq BC-55112 Amount S 150 Welding Monthly net 20 Jun 21/22 WM-611 $450 Welds 'r Us. net 30 Jun 12/22 Jun 19/22 Jun 28/22 WU-4229 Chq 195 WU-SI10 Balance Owing S1 100 -500 400 $1 000 net 30 Grand Tetal $1 600 9. Create the following customer accounts with historical information. The credit limit for all customers is $5 000. The terms for all customers are 2/5, w15 The tax code for all customers is H. If information is not provided, leave fields blank. Name (Contact), Address Wacky Welding (Major Stickit) 45 Dunnit St., Wallaceburg, ON RIE 6T3 E-mail: the major@wacky.com Web site: www.wacky.com Customer since: 01/01/2006 Phone/Eax Tel: (519) 591-7722 Rexenue Acceant 4020 Revene for Services Fax: (519) 591-9112 Tel: (519) 592-0001 Fax: (519) 592-9991 4020 Revenue for Services Noya Welding (Para Noya) 110 Oxygen St., Windsor, ON NST 9A1 E-mail: paoya@interface.ca Customer since: 09/16/2008 Att 4020 Revenue for Services Tel: (519) 762-6712 Flamer's Steel (Clare Flame) 1OA Readers Den, Woodstock, ON N3H 7D3 Web site: www.flamers.com Customer since: 11/06/2007 Historical Supplier Invoices and Payments Amount $5 500 -500 $5 000 Inveice Chq 108 Date Jun 22/22 Jun 23/22 Balance owing (Grand Total) Terms 2/5, n/15 Name Wacky Welding Chq 212 Computerized Accounting with Sage 50 Level 1 (SI10) Final Project1 Page 7 Loce Shit Alt Memo #2 Dated July 8, 2022 Adjust Sales Invoice #122 to Flamer's Steel. Flamer's Steel will be using our services on a weekly basis so their rate will be reduced. The amount billed should be redaced to $400 plas $52 HST. Store the sales invoice as a weekly recurring transaction Memo #3 Chris's welding tank exploded when a customer accidentally dropped it. Write off the welding tool recorded in account # 1480 valued at $750. Create new Group expense account 5100 Damaged Tools Dated July 8, 2022 Bank Debit Memo #PB-77386 Dated July 8, 2022 From Payblo Bank, pre-authorized bi-weekly payrolll for employees. Wages and payroll expenses Payroll services fee HST paid on payroll services Total withdrawal Create new Group expense account 5265 Wage and Payroll Expenses Change the session date to July 15, 2022. Enter the following transactions: S6,000.00 80.00 10.40 $6,090.40 Emin a ANCOL Cash Receipt #298 From Noya Welding, cheque t 431 for $996.66 in payment of account, including 2% discount for prompt payment. Reference invoice #121 Dated July 9, 2022 Cheque Purchase Invoice #CP-2990 From Crystal Products, Inc. (use Quick Add for new supplier), $900 plus $117 HST for one welding tank to replace the destroyed tank. Invoice total $1 017 paid by choque 202. Dated July 10, 2022 Purchase Invoice #WU-5331 From Welds 'r Us, $600 plus $78 HST, for one are welding torch kit.. Invoice total $678. Terms net 30. Dated July 11, 2022 Dated July 11, 2022 Cash Receipt #299 From Wacky Welding, certified cheque #WW-44239 for $1 600 to replace NSF cheque. Reference invoice #108 and Bank Memo # PB-77225 Dated July 13, 2022 Sales Invoice #124 To Wacky Welding, $900 for steel welding and consultations, plus $117 HST. Invoice total $1 017. Change the customer's terms to net 15 for this invoice and in the customer ledger. Dated July 13, 2022 Sales Invoice #125 To Flamer's Steel, $400 plus $52 HST for 5 hours of arc welding. Invoice total $452. Terms 2/5, net 15. Recall stored entry. (Accept message) Dated July 13, 2022 Credit Card Sales Invoice #126 To One-time customers, 150.00 total 19.50 $169.50 150 minutes @ $1.00 each HST Charged Total amount paid by Chargit Computerized Accounting with Sage 50 Level 1 (SI10) Final Project 1 Page 9 Accuu Cash Sales Invoice # 127 Dated July 14, 2022 Sales Summary: To One-time walk-in clients, $380 for various types of welding jobs, plus $49.40 HST. Invoice total $429.40. Paid by Cash. Memo #5 Dated July 14, 2022 Welding supplies used in the past week amounted to $24. Adjust welding supplies account and charge to welding supplies used expense account. Recall stored entry Bank Memo # PB-82771 Dated July 15, 2022 From Paylo Bank, $1 500 for regular monthly mortgage payment. This amount includes interest of $1 200 and $300 in principal. 13. Print and assemble the following reports in the order indicated and hand in to your instruct tor: 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 July I to July 15, 2022 Show corrections. 2. Comparative Balance Sheet (with percent difference) at July 1, 2022 and July 15, 2022 3. Income Statement from July 1 to July 15, 2022 4. Supplier Aged Summary Report 5. Customer Aged Summary Report PROJECT SPECIFICATIONS The information provided in this test allows you to set up the General, Payables and Receivables ledgers for an Ontario company named GEORGE'S WELDING owned and run by Chris George, a master welder. He performs all kinds of welding jobs for individuals as well as companies. George has contracted youa to set up his company to use Sage 50 Accounting for general ledger, accounts receivable and accounts payable. DO EACH OF THE FOLLOWING TASKS IN ORDER 1. Using Sage 50 Accounting, create a new company file using the following information Company Name: NOTE: Be sure to include your name as part of the company name so the reports you print and hand in to George's Welding-(Your Name) your instructor will be properly identified. 33 Maple St. Windsor, Ontario N9S 4B6 Address: Phone: (519) 653-8383 07-01-2022 Fax: (519) 653-7700 Fiscal start Earliest transaction date:07-01-2022 Fiscal end: Select: Let me build the list of accounts myself after the company is created Industry: Store company files in a new folder named George and use George as the file name. Select: I will update my tax information myself 12-31-2022 Service Working from the Company module window, change default settings if necessary to include the following: 2. Use Accounting Terms Automatically save changes to Suppliers, Clients and Other Records Show list buttons Turn off Checklists and Daily Business Manager at startup and after changing session date Turn off Employee & Payroll, Inventory & Services, Project and Time & Billing Turn on Change Session Date at startup Turn on confirmation message Box User Preferences Options User Preferences View User Preferences Transaction Company Information Settings Company System Settings Business No: 342 121 190 Do not allow transactions dated before 07-01-2022 Do not allow transactions in future Backup frequency: Weekly; turn off automatic backups Company does not use quotes, orders, packing slips and project Company does business in French and English Next Client & Sales Invoice number: 121 Company Backup Settings Company Features Settings Company Forms Settings Next Receipts number: 297 Month, day, year. Use long date format on the screen and in reports Company Date Format Settings Computerized Accounting with Sage 50 Level 1 (S110) Final Project 1 Page 3 3. Create accounts to match the following Chart of Accounts. Edit the current earnings 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. GEORGE'S WELDING Chart of Accounts 1000 CURRENT ASSETS (H) 1050 Test Balance 1080 Bank: Chequing Account 1100 Bank: Credit Card 1200 Accounts Receivable 1290 Welding Supplies 1390 TOTAL CURRENT ASSETS (T) 5000 EXPENSES (H) 5020 Advertising 5030 Bank and Credit Card Fees 5040 Cleaning and Maintenance 5060 Hydro Expense 5220 Insurance Expense 5240 Interest Expense 5260 Telephone Expense 5270 Payroll Service Fees 5280 Welding Supplies Used 5590 TOTAL EXPENSES (T) 1400 CAPITAL ASSETS (H) 1420 Torches 1450 Computers 1480 Other Welding Equipment 1500 Vehicle 1550 Shop 1590 TOTAL CAPITAL ASSETS (T) 2000 CURRENT LIABILITIES (H) 2100 Bank Loan 2200 Accounts Payable 2250 Credit Card Payable 2650 HST Charged on Services (A) 2670 HST Paid on Purchases (A) 2750 HST Owing (Refund) (S) 2790 TOTAL CURRENT LIABILITIES (T) 2800 LONG TERM LIABILITIES (H) 2850 Mortgage Payable 2890 TOTAL LONG TERM LIABILITIES (T) 3000 OWNERS' EQUITY (H) 3560 Chris George, Capital 3600 Net Income (X) 3690 TOTAL OWNERS' EQUITY (T) 4000 REVENUE (H) 4020 Revenue from Services 4100 Sales Allowances 4200 Sales Discounts 4390 TOTAL REVENUE (T) Computerized Accounting with Sage 50 Level 1 (SI10) Final Project 1 Page 4 Back to l Add account balances from the following Trial Balance 4. GEORGE'S WELDING Post-Closing Trial Balance July 1, 2022 1080 Bank: Chequing Account 1100 Bank: Credit Card 1200 Accounts Receivable $12 150 200 5 000 1260 Welding Supplies 1420 Welding Torches 1450 Computer 1480 Other Welding Equipment 900 3 800 1 500 4 200 9 000 150 000 1500 Vehicle 1550 Shop 2100 Bank Loan $6 000 1 600 1 100 950 2200 Accounts Payable 2250 Credit Card Payable 2650 HST Charged on Services 2670 HST Paid on Purchases 2850 Mortgage Payable 3560 Chris George, Capital 750 99 000 78 850 $187 500 $187 500 Hint: Remember to use account 1050 Test Balance for out of balance amounts. ideman 5. Change Account Classes: Bank: Chequing Account: Change the account class to Bank and enter 201 as the next cheque number. Bank: Credit Card: Change the account class to Credit Card Receivable. Credit Card Payable: Change the account class to Credit Card Payable. Expense Group accounts: Change the account class to Expense. 6. Set up credit cards as follows: Credit Cards Accepted: Credit Card Name: Chargit Currency CAD Linked Asset Account 1100 Discount Fees: 3% Linked Expense Account: 5030 Credit Card name: Chargit Linked Payable Account: 2250 Linked Expense Account: 5030 Credit Cards Used: 7. Enter Sales Taxes and Tax Codes (do not enter accounts to track PST) Tax-HST: Not Exempt, Not Taxable, Use 2670 to track tax paid on expenses Use 2650 to track taxes charged on revenues, Report on taxes Tax HST, Taxable, Rate 13 % , Not included, Refundable Tax HST, Taxable, Rate 13 % , Included, Refundable Code - H: Code - HI: Computerized Accounting with Sage 50 Level 1 (SI10) Final Project 1 Page 5 Save saq Jouner H AM C Enter Ledger Settings: General (Accounts) - Linked Accounts Allow account classes to change. Badgeting should be turmed off Retained Eanings 3560 Current Eamings 3600 Windsor, Ontario, Canada Aging periods: 30, 60 and 90 days Calculate all discounts after tax for one time suppliers Principal Bank Account 1080 Accounts Payable 2200 Early Payment Purchase Discount and Freight Expense: leave blank Prepayments and Prepaid Orders 2200 Windsor, Ontario, Canada Aging periods: 5, 15 and 30 days No interest charges on overdue accounts Include invoices paid in last 30 days Use tax code H as default for new customers Terms: 2% discount in 5 days (after tax), net in 15 days Line discounts not used On sales invoices: "Where fire meets steel" Principal Bank Account 1080 Accounts Receivable 1200 Default Revenue 4020- Freight Revenue: leave blank Early Payment Sales Discount 4200 Deposits and Prepaid Orders 1200 Payables: Address -Options Sh - Linked Accounts Receivables: Address -Options Discounts -Comment Linked accounts 8. Create the following supplier accounts Add the historical information provided. Name (Contact), Address Phone/Fax Tel: (905) 310-5221 Terms. Tax, Account Terms: net 10 Tax Code: HI Expense Account 5260 Telephone Expense Bell Canada 339 Jupiter Ave, Toronto, ON R4S 6T3 Web: www.bell.ca Supplier since: 12/01/2005 Tel: (902) 821-8186 Terms: net 1 Tax Code: No tax (tax exempt-yes) Receiver General for Canada (Margot Taxit) Summerside Tax Centre, Summerside PE CIN 6L2 Web: www.cra-arc.ge.ca Supplier since: 12/01/2005 Tel: (226) 593-7191 Fax: (226) 593-1772 Terms: net 20 Tax Code: H Expense Account 5020 Advertising Welding Monthly (Leo Libra) 29 Taurus Lane, London, ON R4V 2V7 Tax ID: 493 421 289 E-mail: look.up@weld.com Supplier since: 06/12/2006 Terms: net 30 Tax Code: H Expense Account 1480 Other Welding Equipment Tel: (519) 592-6282 Fax: (519) 592-8164 Welds 'r Us (Vulcan Sidekick) 81 Aquarian Way, Chatham, On R3T 2C9 Tax ID: 563 327 766 E-mail: weldall@welds.com Supplier since: 01/15/2008 Computerized Accounting with Sage 50 Level 1 (S110) Final Project 1 Page 6 Minut Historical Supplier Inveices and Payments Name Bell Canada Terms net 10 Date Jun 28/22 Invoice/Chq BC-55112 Amount S 150 Welding Monthly net 20 Jun 21/22 WM-611 $450 Welds 'r Us. net 30 Jun 12/22 Jun 19/22 Jun 28/22 WU-4229 Chq 195 WU-SI10 Balance Owing S1 100 -500 400 $1 000 net 30 Grand Tetal $1 600 9. Create the following customer accounts with historical information. The credit limit for all customers is $5 000. The terms for all customers are 2/5, w15 The tax code for all customers is H. If information is not provided, leave fields blank. Name (Contact), Address Wacky Welding (Major Stickit) 45 Dunnit St., Wallaceburg, ON RIE 6T3 E-mail: the major@wacky.com Web site: www.wacky.com Customer since: 01/01/2006 Phone/Eax Tel: (519) 591-7722 Rexenue Acceant 4020 Revene for Services Fax: (519) 591-9112 Tel: (519) 592-0001 Fax: (519) 592-9991 4020 Revenue for Services Noya Welding (Para Noya) 110 Oxygen St., Windsor, ON NST 9A1 E-mail: paoya@interface.ca Customer since: 09/16/2008 Att 4020 Revenue for Services Tel: (519) 762-6712 Flamer's Steel (Clare Flame) 1OA Readers Den, Woodstock, ON N3H 7D3 Web site: www.flamers.com Customer since: 11/06/2007 Historical Supplier Invoices and Payments Amount $5 500 -500 $5 000 Inveice Chq 108 Date Jun 22/22 Jun 23/22 Balance owing (Grand Total) Terms 2/5, n/15 Name Wacky Welding Chq 212 Computerized Accounting with Sage 50 Level 1 (SI10) Final Project1 Page 7 Loce Shit Alt Memo #2 Dated July 8, 2022 Adjust Sales Invoice #122 to Flamer's Steel. Flamer's Steel will be using our services on a weekly basis so their rate will be reduced. The amount billed should be redaced to $400 plas $52 HST. Store the sales invoice as a weekly recurring transaction Memo #3 Chris's welding tank exploded when a customer accidentally dropped it. Write off the welding tool recorded in account # 1480 valued at $750. Create new Group expense account 5100 Damaged Tools Dated July 8, 2022 Bank Debit Memo #PB-77386 Dated July 8, 2022 From Payblo Bank, pre-authorized bi-weekly payrolll for employees. Wages and payroll expenses Payroll services fee HST paid on payroll services Total withdrawal Create new Group expense account 5265 Wage and Payroll Expenses Change the session date to July 15, 2022. Enter the following transactions: S6,000.00 80.00 10.40 $6,090.40 Emin a ANCOL Cash Receipt #298 From Noya Welding, cheque t 431 for $996.66 in payment of account, including 2% discount for prompt payment. Reference invoice #121 Dated July 9, 2022 Cheque Purchase Invoice #CP-2990 From Crystal Products, Inc. (use Quick Add for new supplier), $900 plus $117 HST for one welding tank to replace the destroyed tank. Invoice total $1 017 paid by choque 202. Dated July 10, 2022 Purchase Invoice #WU-5331 From Welds 'r Us, $600 plus $78 HST, for one are welding torch kit.. Invoice total $678. Terms net 30. Dated July 11, 2022 Dated July 11, 2022 Cash Receipt #299 From Wacky Welding, certified cheque #WW-44239 for $1 600 to replace NSF cheque. Reference invoice #108 and Bank Memo # PB-77225 Dated July 13, 2022 Sales Invoice #124 To Wacky Welding, $900 for steel welding and consultations, plus $117 HST. Invoice total $1 017. Change the customer's terms to net 15 for this invoice and in the customer ledger. Dated July 13, 2022 Sales Invoice #125 To Flamer's Steel, $400 plus $52 HST for 5 hours of arc welding. Invoice total $452. Terms 2/5, net 15. Recall stored entry. (Accept message) Dated July 13, 2022 Credit Card Sales Invoice #126 To One-time customers, 150.00 total 19.50 $169.50 150 minutes @ $1.00 each HST Charged Total amount paid by Chargit Computerized Accounting with Sage 50 Level 1 (SI10) Final Project 1 Page 9 Accuu Cash Sales Invoice # 127 Dated July 14, 2022 Sales Summary: To One-time walk-in clients, $380 for various types of welding jobs, plus $49.40 HST. Invoice total $429.40. Paid by Cash. Memo #5 Dated July 14, 2022 Welding supplies used in the past week amounted to $24. Adjust welding supplies account and charge to welding supplies used expense account. Recall stored entry Bank Memo # PB-82771 Dated July 15, 2022 From Paylo Bank, $1 500 for regular monthly mortgage payment. This amount includes interest of $1 200 and $300 in principal. 13. Print and assemble the following reports in the order indicated and hand in to your instruct tor: 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 July I to July 15, 2022 Show corrections. 2. Comparative Balance Sheet (with percent difference) at July 1, 2022 and July 15, 2022 3. Income Statement from July 1 to July 15, 2022 4. Supplier Aged Summary Report 5. Customer Aged Summary Report

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions