 |
|
|
 |
New Member
|
|
Oct 29, 2008, 01:47 AM
|
|
About balance sheet and ledger accounts
I have attached the file,
Please look at it and see if anyone can solve it
Please, I need help as soon as possible.
Thank you for your time.
My email:
[email protected]
|
|
 |
New Member
|
|
Feb 3, 2011, 05:05 PM
|
|
I sent you an email. The exercise looks simple, but requires you to enter Sept 1 balances and account numbers for the Balance sheet. The rest is making journal entries good luck rob
|
|
 |
Ultra Member
|
|
Feb 3, 2011, 05:45 PM
|
|
Step A: You need to post the accounts name, number, date, amount in rows 11 through 19 in rows141 through 274.
Step B: You need to journalize the transactions in rows 22 through 32 in rows 78 through 117.
Step C: You need to post the entries from row 78 through 117 in rows 141 through 274. Then you need to get the account balance for each account.
Step D: You need to post the account name and balance from Step C into rows 58 through 72. Then you need to sum the columns E58 to E72 in E73 and columns F58 to F72 in F73. Your amounts for E72 should equal F72.
Step E: You need to do the adjusting entries from rows 35 to 38 and post them in rows 119 to 133. Then you need to post these entries into rows 141 to 274 and get account balances for each account.
Step F: You need to post the account balances from rows 141 to 274 in rows and columns G58 to H72. Then you neeed to sum G58 to G72 in G73 and sum H58 to H72 in H73. These amounts should be equal.
Step G(1): You need to post your Income Statement Accounts (Revenues and Expenses) from G58 to H72 in rows 282 to 788. Next you need to calculate Net Income in G290.
Step G(2): You need to post your beginning retained earnings balance from row 141 to 274 to E297. Then post your net income from Step G(1) to E298, then add these two amounts to get ending revenue in E299.
Step G(3): You need to post your balance sheet accounts from G58 to H72 and E299. Next you need to sum your accounts. Your Total Assets should equal your Total Liabilities plus Stockholders Equity.
|
|
Question Tools |
Search this Question |
|
|
Add your answer here.
Check out some similar questions!
Ledger, trial balance, balance sheet
[ 5 Answers ]
hello, I have problem with my assignment. Can anyone help me with one question?
I have to prepare journals, ledger, trial balance, profit and loss and balance sheet.
Jan 6
Bought spare parts on credit 27000
cash sale 62500
Jan 7
charged Moji for repairs 5000
sold spare parts to Koba on...
Income and Balance Sheet Accounts
[ 1 Answers ]
Hi ~ I was wondering if you could help me put the right accounts into the right statements. These are the accounts I have:
Accounts Payable
Accounts Receivable
Cash
Fees Earned
Insurance Expense
Land
Miscellaneous Expense
Prepaid Insurance
If T-Accounts Balance does this mean balance sheet & P&L work correctly?
[ 1 Answers ]
Hi,
Just wondering been having some problems with my Balance Sheet balancing, I was wondering if the Trial Balance balances, does that mean that the balance sheet will balance? (given that I do everything correctly? )
Also just a quick question while I'm asking, regarding depreciation in...
Allowance for Doubtful Accounts and a Balance Sheet
[ 4 Answers ]
I have the following question and I can not seem to find an example and would just like some help.
On December 31, of the current year, a campanies unadjusted trial balance reveled the following: Accounts Receivable $185,600; Sales Revenue $1,280,000; (75% were on credit), Allowance for Doubtful...
View more questions
Search
|