Cedar River Corporation started operations on July 1, 2018. The transactions that occurred during the month were journalized and posted, and a trial balance was prepared at the end of the month. The month-end adjusting entries are to be journalized and posted to T-accounts. A worksheet is to be used to help prepare the adjusted trial balance.

Requirements
1. Use Excel to journalize the adjusting entries. Use the blue shaded areas for inputs.

a. To record the account name in the journal, click in the Account and Explanation column. A drop down arrow will appear to the right. Click the arrow and select an account from the chart of accounts. Use the explanation to help you with the entry.

                            

b. Indent the account name of the account to be credited using the indent button on the Home tab. Click the Increase Indent button twice.

                                                        

2. Once the adjustments have been journalized, post the amounts to the correct side of the T account. (Note that the balance at the end of the month has been posted as a single entry.)

a. The T-account totals will be calculated automatically.
b. Total debits should equal total credits. The debit-credit balance check appears in the top right hand corner of the T-account worksheet.

3. Use a formula to fill in the Adjustment debit and credit columns on the worksheet by referencing the adjusting entries.
4. Use a formula to add or subtract the adjustments to the trial balance amounts to calculate the amounts in the Adjusted Trial Balance columns.
5. Use a formula to total the Adjustments and Adjusted Trial Balance columns.
6. On the Worksheet

a. Format the cells requiring dollar signs.
b. Format the cells requiring a single underline and cells requiring double underlines.
c. Boldface the totals.