I can’t make the total account balance in the Trial Balance Worksheet. I don’t know where I did wrong. Please help!! Thanks.

I can’t make the total account balance in the Trial Balance Worksheet. I don’t know where I did wrong. Please help!! Thanks.

Attachment 1

Attachment 2

ATTACHMENT PREVIEW

Download attachment

Unlock Solution Unlocking…

Show entire document

ATTACHMENT PREVIEW

Download attachment

qattachments_bad1147041923a3b87c344320c1550d8cde96ea2.xls
Name: _________________________________
Date: ____________
Sullivan Realty
Excel Accounting Project
This project to be done soley by the student submitting it.
This is not a ‘group’ project.
19-Jul
Assignment
Reports Due in this stacking order:
Due Date: Points
Score
File Name per instructions (Lname Finitial Sullivan.xls)
2
Printing and formatting ‘presentation’ and stacking order of your submission.
6
Journalize and post ‘External Transactions’
for June
20
Use posting references (JE1, JE2, .
.) in JE Explanation.
GL posted properly
Preparation of Trial Balance – Worksheet
Worksheet:
Trial Bal = 45000
19-Jul
20
Enter Adjusting entries and finish worksheet
Worksheet: Adjusted Trial Bal = 45425
20
Journalizeand post June Adjusting Entries
Ref:
06AJE – 1… etc
18
Heading in Journal:
‘Adjusting Entries’
2
Complete Financial Statements
Income Statement
Net Income = 11,543
16
Statement of Owner’s Equity
16
Balance Sheet
16
Journalize and post June Closing Entries.
Ref:
06CLE – 1 , 2, 3, 4
18
Heading in Journal:
‘Closing Entries’
2
All postings in GL reconcile JE’s & Worksheet
June General Ledger
20
Prepare the Post Closing Trial Balance
Post Closing Trial Balance ($33,193)
14
GL account balances reconcile to Financials & WS & Post Close Trial Balance
10
Final submission: Closed thru PCTB
July 23rd
Total Points for
Submission:
>>>
200
Note:
An error in a journal entry can cause errors in multiple reports.
Correct amounts in Financials and Trial Balances that don’t reconcile to GL accounts indicate cheating: – 5 pts each
You are required to show an accounting of all balances in Financials.
(Update 7/6/13)
Enter your name in the field below and submit this file in Canvas.

Unlock Solution Unlocking…

qattachments_bad1147041923a3b87c344320c1550d8cde96ea2.xls
Get updated instructions.
. $ convention and print versus email per school

Show entire document

Leave a Comment