Question
HELP PLEASE 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
HELP PLEASE
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 | ELEVEN COLUMN JOURNAL | |||||||||||||||
DEBIT | CREDIT | |||||||||||||||||||
| Aug. 1 | Central Lumber | P1 | DATE | ACCOUNT TITLE | DOC. NO. | POST REF. | GENERAL | ACCOUNTS RECEIVABLE | SALES | SALES TAX PAYABLE | ACCOUNTS PAYABLE | PURCHASES | CASH | |||||||
| Aug. 6 | Kingstone Construction | S10 | DEBIT | CREDIT | DEBIT | CREDIT | CREDIT | CREDIT | DEBIT | CREDIT | DEBIT | DEBIT | CREDIT | |||||||
| Aug. 13 | Supplies - Store | M18 | $ 495.00 | Aug. 1 | Central Lumber | P1 | $ 4,350.00 | $ 4,350.00 | ||||||||||||
| Commercial Tool Warehouse | Aug. 6 | Kingstone Construction | S10 | $ 3,000.00 | $ 2,800.00 | $ 200.00 | ||||||||||||||
| Aug. 23 | Interior Plumbing Parts | C35 | Aug. 13 | Supplies - Store | M18 | $ 495.00 | ||||||||||||||
| Aug. 23 | Internet Expense | C36 | $ 200.00 | Commercial Tool Warehouse | $ 495.00 | |||||||||||||||
| Aug. 24 | Supplies - Office | C37 | $ 20.00 | Aug. 23 | Interior Plumbing Parts | C35 | $ 2,000.00 | $ 2,000.00 | ||||||||||||
| Supplies - Store | $ 35.00 | Aug. 23 | Internet Expense | C36 | $ 200.00 | $ 200.00 | ||||||||||||||
| Postage Expense | $ 12.00 | Aug. 24 | Supplies - Office | C37 | $ 20.00 | $ 130.00 | ||||||||||||||
| Miscellaneous Expense | $ 63.00 | Supplies - Store | $ 35.00 | |||||||||||||||||
| Purchases | $ 1,000.00 | Postage Expense | $ 12.00 | |||||||||||||||||
| Aug. 24 | Central School District | S11 | Miscellaneous Expense | $ 63.00 | ||||||||||||||||
| Aug. 31 | Totals | $ 825.00 | $ 1,000.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
Mastering Accounting Skills
Authors: Margaret Nicholson
3rd Edition
1403992703, 978-1403992703
