Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:

image text in transcribed

Entries:

image text in transcribed

Ledger 1: Date | Particulare | PR | Debit | Credit | Balance| DR/CR

image text in transcribed

Ledger 2:Date | Particulare | PR | Debit | Credit | Balance| DR/CR

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Documentation Improvement Methods The New Accounting Manual

Authors: Athar Murtuza

2nd Edition

0471379387, 978-0471379386

More Books

Students also viewed these Accounting questions