Your Perfect Assignment is Just a Click Away

We Write Custom Academic Papers

From as Little as $6

100% Original, Plagiarism Free, Customized to your instructions!

glass
pen
clip
papers
heaphones

Bethesda University of California Trial Balance Financial Statements & Closing Entries Report

Bethesda University of California Trial Balance Financial Statements & Closing Entries Report

Question Description

Nearly all the project is done, I need someone to look over it and find missing expensed that were left out. Some are in twice (rental expense and Repair expense and depreciation expense, water). And some accounts are missing.

The below has been done:

1. Create a General Ledger (T-accounts) in Excel from the General Journal you have been given. (Account numbers from the Chart of Accounts are in parentheses)

i. Show

1. Beginning Balance for permanent accounts

2. Total Debits

3. Total Credits

4. Account balance

ii. Consider using a pivot table to summarize accounts

2. Create an Adjusted Trial Balance. On the tab provided. Make sure our debits equal your credits

a. Moving your account balance from each account into the template provided.

b. Ensure your debits equal your credits

3. Create Financial Statements from your trial balance (Income Statement, Statement of Change in owner’s equity, Balance sheet)… on tab provided… A template for the financial statements is provided.

4. Create your closing entries (you can summarize all revenues, all expenses and dividends into 3 entries)

5. Create a post-closing trial balance on the tab provided