Record the journal entries for all items (#1 – #28) in the GJ (General Journal)…

Record the journal entries for all items (#1 – #28) in the GJ (General Journal) for Fifth Cousin Media LLC in
EXCEL. Use Data-validation tool ?List (for the list use chart of accounts) for column C in GJ. This tool is
explained in the instructional video.
2. Post the transactions shown above in the appropriate general ledger accounts, use T-accounts tab in
EXCEL. Post the transactions by referencing cells in the GJ tab. Do not simply re-type the amounts. Use
formulas to calculate balances for all T-accounts.
3. Prepare an Adjusted Trial Balance in EXCEL. Use cell references from T-accounts or the GJ when
appropriate; use formulas to total the debits and credits.
4. Name your file using your initials (e.g. ACC3313 FCM_Part1_LK.xls) and upload the file to TRACS in the
“Assignments” section by 7:30am Tuesday, Sept. 4, 2018. PRINT OUT AND BRING hard copies of your GJ
entries, t-accounts and Adjusted Trial Balance to class on Tuesday, Sept. 4. The solution will be reviewed in
class.
5. A correct Adjusted Trial Balance will be available on TRACS at 9am on September 4. Use it to prepare an
Income Statement, a Statement of Retained Earnings, and an unclassified Balance Sheet in EXCEL. Use
formulae as appropriate.
6. Prepare closing entries on the separate tab in EXCEL.
7. Prepare a Post-Closing Trial Balance in EXCEL; use formulae to total the debits and credits. Name your file
using your initials (e.g. ACC3313 FCM_Part2_LK.xls) and upload the file to TRACS in the “Assignments”

"Is this question part of your assignment? We can help"

ORDER NOW

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *