Question
I NEED FULL AND CLEAR WORK DONE FOR THE FOLLOWING QUESTIONS! I WILL UPVOTE!! Use the following sheets as the starting point for your worksheet
I NEED FULL AND CLEAR WORK DONE FOR THE FOLLOWING QUESTIONS! I WILL UPVOTE!!
Use the following sheets as the starting point for your worksheet and follow the steps as shown in the sample worksheet.
Worksheet:
Entries:
Ledger 1: Date | Particulare | PR | Debit | Credit | Balance| DR/CR
Ledger 2:Date | Particulare | PR | Debit | Credit | Balance| DR/CR
Given the Trial Balance and Additional Information for Llewelyn Moving Consultants prepare a worksheet with adjustments for the year ending December 31, 2020.
Using the Entries tab on the same worksheet, complete the adjusting journal entries required to support the adjustments you planned on the worksheet. Use the proper format for journal entries.
Using the tabs titled Ledger 1 and Ledger 2, open the ledger for Llewelyn Moving Consultants. Then post the adjusting entries. (If you forget how to open a ledger, go back to Chapter 5 and review this procedure).
Additional Information 1.The supplies on hand on December 31, 2020 were valued at $525. 2.The Prepaid Insurance represents a one-year policy purchased on September 1, 2020. 3.The Prepaid Rent represents three months of rent, paid in advance on November 1, 2020. 4.The Automotive Equipment depreciates at the rate of 30% using the declining balance method. 5.The Furniture and Equipment depreciates at a rate of 20% using the declining balance method.
Part B:
Using the same file:
On the tab titled Entries, prepare the first two closing entries required for a Manual accounting system (put them right under the adjusting journal entries).
Post these two closing entries using Ledger 1 and Ledger 2 you began in Assignment 12.1.
On the Entries tab, under the other journal entries, prepare the third and fourth closing entries.
Post these new entries to the Ledger.
Prepare a Post-Closing Trial Balance (include only those accounts with non-zero balances) as of December 31, 2020.
Llewelyn Moving Consultants Worksheet Year Ending December 31, 2020 Company Name General Journal PAGE: LedgerGeneralLedger \begin{tabular}{|l|l|l|l|l|l|l|l|} \hline \multicolumn{2}{|c|}{ Dat9 } & Particularg PR & DEBIT & CREDIT & BALANCE & DR/CR \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|l|l|} \hline \multicolumn{2}{|c|}{ Date } & Particularg & PR & DEBIT & CREDIT & BALANCE & DR/CR \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|l|l|} \hline \multicolumn{2}{|c|}{ Date } & Particularg & PR & DEBIT & CREDIT & BALANCE & DR/CR \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|l|l|} \hline \multicolumn{2}{|c|}{ Date } & Particularg & PR & DEBIT & CREDIT & BALANCE & DR/CR \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline \end{tabular} Company Name General Ledger \begin{tabular}{|l|l|l|l|l|l|l|l|} \hline \multicolumn{2}{|c|}{ Date } & Particularg & PR & DEBIT & CREDIT & BALANCE & DR/CR \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started