Question
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:ACTT1DataUnit_10. Click
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started