please use Excel to build a table for this

1 Chapter 5 - Case Study Assignment #3 - KBC Decorating Co 2 3 Name: Student # : 4 5 11 12 13 Trial Balance 14 15 16 17 18 19 20 21 22 23 24 25 Bank Furniture & Equipment Vehicles Tools & Equipment HST Payable HST-ITC Capital, Henri Martin Capital, Wes Corbett Sales Paint & Supplies Sales Wallpaper Purchases Paint & Supplies Purchases Wallpaper Freight In Advertising Expense Delivery Expense Office Supplies Expense Rent Expense Telephone Expense Totals 26 27 28 29 30 31 32 33 $ $ 34 35 36 37 38 CASE STUDY: KBC DECORATING CO. JANUARY TRANSACTIONS CONTINUED These transactions occurred during the second half of January. Continue the General Journal where you left off in the previous chapter. Be sure to account for HST as indicated. 20 Jan. 16 Bought advertising space in the local community newspaper, $125 plus 13% HST. Issued Cheque #7. 16 Paid shipping costs on the merchandise bought on the 5th, $85 plus HST. Issued Cheque #8. 17 Paid transportation cost for new paint mixer and colour dispenser bought on the 9th and delivered from Toronto. Issued Cheque #9 for $84.75 (includes $9.75 HST). 20 Cash sales: paint and supplies, $2,500; wallpaper, $2,000; plus HST. 21 Paid delivery costs for paint and supplies delivered to our cus- tomer, $60 plus HST. Cheque #10. 26 Bought paint and supplies, $8,500 plus HST. Cheque #11. 26 Paid the shipping on paint and supplies bought today, $45 plus HST. Cheque #12. 30 Cash sales: paint and supplies, $3,000; wallpaper, $1,000; plus HST. 1 Chapter 5 - Case Study Assignment #3 - KBC Decorating Co 2 3 Name: Student # : 4 5 11 12 13 Trial Balance 14 15 16 17 18 19 20 21 22 23 24 25 Bank Furniture & Equipment Vehicles Tools & Equipment HST Payable HST-ITC Capital, Henri Martin Capital, Wes Corbett Sales Paint & Supplies Sales Wallpaper Purchases Paint & Supplies Purchases Wallpaper Freight In Advertising Expense Delivery Expense Office Supplies Expense Rent Expense Telephone Expense Totals 26 27 28 29 30 31 32 33 $ $ 34 35 36 37 38 CASE STUDY: KBC DECORATING CO. JANUARY TRANSACTIONS CONTINUED These transactions occurred during the second half of January. Continue the General Journal where you left off in the previous chapter. Be sure to account for HST as indicated. 20 Jan. 16 Bought advertising space in the local community newspaper, $125 plus 13% HST. Issued Cheque #7. 16 Paid shipping costs on the merchandise bought on the 5th, $85 plus HST. Issued Cheque #8. 17 Paid transportation cost for new paint mixer and colour dispenser bought on the 9th and delivered from Toronto. Issued Cheque #9 for $84.75 (includes $9.75 HST). 20 Cash sales: paint and supplies, $2,500; wallpaper, $2,000; plus HST. 21 Paid delivery costs for paint and supplies delivered to our cus- tomer, $60 plus HST. Cheque #10. 26 Bought paint and supplies, $8,500 plus HST. Cheque #11. 26 Paid the shipping on paint and supplies bought today, $45 plus HST. Cheque #12. 30 Cash sales: paint and supplies, $3,000; wallpaper, $1,000; plus HST