Question: Follow all Instructions & Requirements carefully - Points off for each one not strictly followed: Project Year 2 Steps: Do Steps below on this
Follow all Instructions & Requirements carefully Points off for each one not strictly followed:
Project Year Steps:
Do Steps below on this Year tab apply GAAP to Year events after considering everything in Yeat tab& keep these Steps in Year tab in a format similar to Year s Do not remove the current tabs & do not create any new ones.
Project Tip: Use the CGS & EI tab to keep track of changes in inventory units & LIFO perpetual accounts.
To Start: Study Year & copy Journal, GL & column to Year then delete any Year info na to Year
Input beginning GL real account balances from Yr ATBBS & add RE& make sure TB on Column balances.
Make sure that each GL end acct balance "flows" to TB by copying GL cell info to appropriate iTB account.
Use Excel properly: Copy amount from cell to cell or from Year to Year never type same amount twice
For any calculation show it in a cell's formula using copied cells whenever possible see Year fracmid cell formulas
Steps thru in Year tab:
Record JEs by Date with Ref. # & Explanation as in Yr ; abbreviate each Acet Type & round all to nearest dollar.
Note: Record only JEs in Journal; all AJEs will be shown & calculations described on column Worksheet.
Post JE info to GL accounts with Type & in FS order: A L SE R E D& use JE Ref. # for each amount posted.
Tip: Post each JE after recording it & check that TB balances make sure each GL end acct balance "flows" to TB
Complete column Worksheet see Video in Project Module including all AJEs, with crossreferenced drs & crs & footnoted explanation & calculation below. Abbreviate account type for each new account in TB
Prepare FSs & FS Notes revising any relevant Kellogg's Note language for Fox most Kellogg's Notes will not apply. Prepare SCFsDirect Method up to Points EC for complete Operating SectionIndirect Method in FS Notes.
Prepare closing entry prepare only the single entry version in Year not the entry version in Year
Make it all "Boss Friendly": Each print preview screen easily readable, with complete Headings for each Step.
Note how each print preview screen for Year is easily readable with Headings for each Accounting Cycle Step
Check Common Student Errors at Project beginning & end & all Members should agree on submilting Project.
Each Group must do all Project Steps without help from any other students in other Group, or from TA's, however if you get stuck, email copying all Group Members a conceptual Question along with your proposed Answer to marcocpa@temple.edu, entitling Email Subject Box Conceptual Project Q & Proposed A
Note: Conceptual Qs gencrally do not require amounts & never email entries or any part of your Year Solutions. Warning: Collusion with any Students outside your Group results in course failure for all Studenth involved. Fox events for Year : Keep Yr Instructions & Events at top of this Tab, & do not remove the
original Tabs. See Additional Instructions below & Common Student Errors before preparing Year entries
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
