60.1K

Verified Solution

Link Copied!

I need journal entries posted using the accounts posted from the excel file

INSTRUCTIONS Aggie Health & Fitness Center Practice Problem The "Accounting Cycle Projeet" is worth 50 points. The answers to this project 1. Download the transactions for the second month of business for Ag he answers to this project will be submitted on cCampus. Also, Aggie Health&Fitness Center. excel spreadsheet file and save to your own USB drive/disk/hard drive/etc. (Do not atempt to do any work in the Excel file until you have saved it to your o our work will be saved.) )Enter transactions for the second month of business as journal entries in the of the electronic spreadsheet. Use the format we use in class to write these journal debit line comes first, then drop down one line, indent, and record the second account title). 2. Post from the "General Journal" into the "General Ledaer" You must use the cell referencing feature of excel. Post the debit or credit in the appropriate account, and make a note in the "notes" column so that you will be able to track your entries when you make any changes. You must make notes in notes column! The spreadsheet will automatically compute a balance in the "Unadjusted cell. Do not enter any negative numbers. There are enough lines for all necessary entries, so if you run out of space, it means that you have not done it correctly. Start the entries on the top line of the account's section (right under the gray line or below the Beginning Balance). You should never get a negative balance. If you do, re-check to see if you posted the entry correctly to either the debit or credit column. I have protected cells in these sheets so that you shouldn't be able to inadvertently mess up the formulae Balance key...simply hit the backspace key to clear the cell. Hitting delete w e an error in the formulae and then your trial balance will Use the perpetual inventory method to update your inventory as discussed in class. The unadjusted balances will post automatically into the Unadjusted Trial Balance on the "Worksheet" page of the electronic spreadsheet. After you finish with the monthly transactions (pages 3& 4 of your transaction packet) you need to check the Unadjusted Trial Balance to make sure it balances! (Refer to check figure.) Note: Beginning balances have already been entered into the general ledger. 3. Enter the adjusting entries in the General Journal in the electronic spreadsheet. (The section is titled "General Jounal - Adjusting Entries".) You are provided with a partial listing of adjusting entries on page 5 of the transaction packet. These are only the adjusting entries that require additional information-you will need to go back to the original transactions to determine what other accounts require adjustment and how much the adjustment should be. Inventory shortfalls get debited to "Loss on Shrinkage." You should have a total of eight adjusting entries when you finish (depreciation counts as only one entry and loss on shrinkage counts as only one entry). Post the adjusting entries into the "General Ledger" using cell referencing. Do not use negative numbers. Put the entry into the appropriate cell on the line below the "Balance before Adjustment" The adjusting entries will automatically post into the "Adjustments" column of the "Worksheet" page in the electronic spreadsheet. When you are done with your adjustments, make sure that the debits and credits in the "Adjustments" columns are equal. The adjusting entries will be combined automatically with the unadjusted balances to provide the final "Adjusted Trial Balance" on the "Worksheet". The Worksheet" page is automated; you will do all of your work on the "General Jounal", "General Ledger" and the "Financial Statements" pages. Enter the closing entries in the "General Journal", (titled "General Journal-Closing Entries"). Post these entries into the electronic spreadsheet on the line above the "Ending Balance After Closing" Your ledger t-accounts will be reviewed to verify that all temporary accounts show a zero balance after closing. The Worksheet will be automatically updated after closing entries are posted to reflect an after closing trial balance Theal ba

Answer & Explanation Solved by verified expert

See Answer