Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Task 1 You have been provided with an Excel File which contains the General Journal and Ledger Accounts. The necessary accounts as well as

image text in transcribedimage text in transcribed

Task 1 You have been provided with an Excel File which contains the General Journal and Ledger Accounts. The necessary accounts as well as blank accounts to be used if needed have been included. You will need to complete this task by entering the relevant information into the excel spreadsheet provided. To set up Steven's new system, enter the information below from the chart of accounts and schedules as an Opening Entry into the General Journal and post the relevant information to the General Ledger Accounts provided in the excel file. 1-1110 Bank S. Parks Electrical Chart of Accounts as at 1 July 2022 4,920.00 1-1160 1-1200 Petty Cash 450.00 Accounts Receivable Control 14,355.00 1-1201 Allowance for Bad and Doubtful Debts 287.00 1-1320 Inventory on Hand 12,408.00 1-1325 Stationery on Hand 130.00 1-1410 Prepaid Expenses 2,690.00 1-1420 Repairs Revenue not yet Received 96.00 1-2110 Premises 360,000.00 1-2120 Accumulated Depreciation - Premises 73,500.00 1-2210 Vehicle 37,000.00 1-2220 Acc. Depreciation -Vehicle 14,957.00 1-2310 Electrical Equipment 11,400.00 1-2320 Accumulated Depreciation - Electrical Equip 460.00 2-1200 Accounts Payable Control 8.349.00 2-1300 Sundry Creditor - Delta Machinery 1,386.00 2-1410 Accrued Advertising Expense 511.00 2-1420 Telephone Expense Payable 850.00 2-1211 GST Balance 2,950.00 2-2100 3-1000 ABC Bank Mortgage Loan (7-year) Capital Steven Parks 50,000.00 290,199.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental Accounting Principles

Authors: John Wild, Ken Shaw, Barbara Chiappetta

22nd edition

9781259566905, 978-0-07-76328, 77862279, 1259566900, 0-07-763289-3, 978-0077862275

More Books

Students also viewed these Accounting questions

Question

.000 Flight Att. .40 .24 .39 .13

Answered: 1 week ago