need general journal + subsidiary accounts on excel
Credit Additional formation Account Cashion ou Cash on Hand Debit 15.37054 3.700.00 en les 9.00 2.000.00 200000 Land ng Acom 00.00 An Der Away STARS ST At 3000 D OM OS TH 000 You neticed tempor nec.com is pret Saw w War Mallow me they were Red Deer Transactions General Journal Post Apply 12 vi Speche Record December Transactions in General Journal 12/16/42 Paid A. Phillips (paid by check) (Hint: Salaries Payable) 12/18/Y2 Paid electric bill paid by check) 12/1842 Paid Dividends of S2000 (paid by check) 12/19/2 Paid XYZ, Inc. (paid by check) 12/20/Y2 Purchased office supplies for $400 (paid by check) 12/22/Y2 Received phone bill for $275 from AT&T (didn't pay it) 12/24/42 Weekly cash sales included: 1001(17@$125), 1002 (7@5190), 1003 (6@$250), 1004 (@$500) Sales tax of 9.12% is added to all sales Cash deposited into checking count on transaction dute. Watson Sales uses a perpetual inventory system. 12/24/42 The following sale was made an account to A. McMullen: 1001(@5125), 1004 (@5500) Sales tax of 9.125% is added to all sales. Watson Sales uses a perpetual inventory system Shipping cost of $16 was paid by Watson's for this order 12/28/Y2 Paid 53000 for another 3 months of insurance (puld by check) 12/28/42 Received inventory item 1005 (32 units @ $250 plus shipping of $24) from MNO, Inc. on count Watson Sales unes a perpetual inventory system. (Hint: Shipping is part of the cost of inventory This is important now and later for COGS:) 12/28/Y2 Received $1000 from C McKnight: deposited. 12/30/22 Weekly Sales included: 1001 (16@$125), 1002 (1025190), 1003 (25250), 1004 (3@5500), 1005 (1@5620) Sales tax of 9,125% is added to all sales. Cash deposited into checking account on traction date, Watson Sales as a perpetual inventory system. 12/30/Y2 The following sales were made on account To K. Oxner 100235190) To Young1005 (15620) Shipping cost of 528 was paid by Watson for those two orders but not charged to customers Sales tax of 9.125% is added to all sales Watson Sales es perpetual inventory system. 12/31/42 Paid all Sales tax due (puld by check) Post from Journal to T-accounts As you post a transaction record a check maticorn X in the post reference column of the journal For cach entry in the general ledger (1-4ccounts), include a date Keep the General ledger and Subsidiaries where appropriate com a different tah in the Gl. Excel file Prepare Trial Balanss Remember, you don't have to list accounts with a zero balance When your trial balance is in balance, highlight your account balunces in YELLOW. Check Figures Thai Belane Dehits 5575 1776 Cath on Depost=518.839 55 Sales Revenue 5300,290.00 Cost of Goods Sold S120,156.30 Credit Additional formation Account Cashion ou Cash on Hand Debit 15.37054 3.700.00 en les 9.00 2.000.00 200000 Land ng Acom 00.00 An Der Away STARS ST At 3000 D OM OS TH 000 You neticed tempor nec.com is pret Saw w War Mallow me they were Red Deer Transactions General Journal Post Apply 12 vi Speche Record December Transactions in General Journal 12/16/42 Paid A. Phillips (paid by check) (Hint: Salaries Payable) 12/18/Y2 Paid electric bill paid by check) 12/1842 Paid Dividends of S2000 (paid by check) 12/19/2 Paid XYZ, Inc. (paid by check) 12/20/Y2 Purchased office supplies for $400 (paid by check) 12/22/Y2 Received phone bill for $275 from AT&T (didn't pay it) 12/24/42 Weekly cash sales included: 1001(17@$125), 1002 (7@5190), 1003 (6@$250), 1004 (@$500) Sales tax of 9.12% is added to all sales Cash deposited into checking count on transaction dute. Watson Sales uses a perpetual inventory system. 12/24/42 The following sale was made an account to A. McMullen: 1001(@5125), 1004 (@5500) Sales tax of 9.125% is added to all sales. Watson Sales uses a perpetual inventory system Shipping cost of $16 was paid by Watson's for this order 12/28/Y2 Paid 53000 for another 3 months of insurance (puld by check) 12/28/42 Received inventory item 1005 (32 units @ $250 plus shipping of $24) from MNO, Inc. on count Watson Sales unes a perpetual inventory system. (Hint: Shipping is part of the cost of inventory This is important now and later for COGS:) 12/28/Y2 Received $1000 from C McKnight: deposited. 12/30/22 Weekly Sales included: 1001 (16@$125), 1002 (1025190), 1003 (25250), 1004 (3@5500), 1005 (1@5620) Sales tax of 9,125% is added to all sales. Cash deposited into checking account on traction date, Watson Sales as a perpetual inventory system. 12/30/Y2 The following sales were made on account To K. Oxner 100235190) To Young1005 (15620) Shipping cost of 528 was paid by Watson for those two orders but not charged to customers Sales tax of 9.125% is added to all sales Watson Sales es perpetual inventory system. 12/31/42 Paid all Sales tax due (puld by check) Post from Journal to T-accounts As you post a transaction record a check maticorn X in the post reference column of the journal For cach entry in the general ledger (1-4ccounts), include a date Keep the General ledger and Subsidiaries where appropriate com a different tah in the Gl. Excel file Prepare Trial Balanss Remember, you don't have to list accounts with a zero balance When your trial balance is in balance, highlight your account balunces in YELLOW. Check Figures Thai Belane Dehits 5575 1776 Cath on Depost=518.839 55 Sales Revenue 5300,290.00 Cost of Goods Sold S120,156.30