90.2K

Verified Solution

Link Copied!

Open subsidiary ledger accounts and post amounts from the journal for Southside Building Supply. Start Microsoft Excel, and open the BUS113_10_05.xlsx file from C:\ACTT1\Data\Unit_10. Click the File tab, and click Save As. Save the file to C:\ACTT1\Student\Unit_10. Navigate to the Accounts Payable Ledger spreadsheet tab. Open an accounts payable ledger account for the following vendors: Central Lumber, 220 Commercial Tool Warehouse, 230 Record a balance on the following account: Interior Plumbing Parts -- $2,320 on August 21. Navigate to the Accounts Receivable Ledger spreadsheet tab. Open an accounts receivable ledger account for the following customer: Kingstone Construction, 160 Record a balance on the following account: Central School District -- $5,500 on August 23. Post the amounts from entries in the Accounts Receivable and Accounts Payable special amount columns in the journal to the appropriate subsidiary ledgers. Navigate to the Schedule of Accounts Payable tab. Prepare a schedule of accounts payable using the balances from the accounts payable ledger. Navigate to the Schedule of Accounts Receivable tab. Prepare a schedule of accounts receivable using the balances from the accounts receivable ledger. Save and close the spreadsheet. Submit your file to your instructor for grading.

ELEVEN COLUMN JOURNAL DATE ACCOUNT TITLE DOC. NO. POST REF. GENERAL ACCOUNTS RECEIVABLE SALES SALES TAX PAYABLE ACCOUNTS PAYABLE PURCHASES CASH DEBIT CREDIT DEBIT CREDIT CREDIT CREDIT DEBIT CREDIT DEBIT DEBIT CREDIT Aug. 1 Central Lumber P1 $ 4,350.00 $ 4,350.00 Aug. 6 Kingstone Construction S10 $ 3,000.00 $ 2,800.00 $ 200.00 Aug. 13 Supplies - Store M18 $ 495.00 Commercial Tool Warehouse $ 495.00 Aug. 23 Interior Plumbing Parts C35 $ 2,000.00 $ 2,000.00 Aug. 23 Internet Expense C36 $ 200.00 $ 200.00 Aug. 24 Supplies - Office C37 $ 20.00 $ 130.00 Supplies - Store $ 35.00 Postage Expense $ 12.00 Miscellaneous Expense $ 63.00 Purchases $ 1,000.00 Aug. 24 Central School District S11 $ 831.60 $ 770.00 $ 61.60 Aug. 31 Totals $ 825.00 $ 1,000.00 $ 3,831.60 $ - $ 3,570.00 $ 261.60 $ 2,000.00 $ 4,845.00 $ 4,350.00 $ - $ 2,330.00

Answer & Explanation Solved by verified expert

See Answer