Required: Complete each tab of the excel worksheet.
- General Journal
- T Accounts in: Cash, Acc. Rec., Notes Rec., Interest Rec., Supplies, Inventory, Prepaid Insurance, Prepaid Rent.
(Accumulated Depreciation T Accounts): Equipment, Accounts Payable, Unearned Service Rev, Salaries and wages payable, common stock, retained earnings, income summary, service revenue, sales revenue, sales return and allowances, sales discounts, interest revenue, COGS, Depreciation expense, supplies expense, salaries and wages expense, rent expense, advertising expense.
- Trial Balances before & after adjustment
- General Journal with adjusted entries
- Financial Statements: Income statement (multi step format) for month ended December 31, 2022, retained earnings statement for month ended December 31, 2022, balance sheet for month of Decemeber 31
- General Journal: Post closing entries
- Post closing trial balance
thank you so much!
France 1 11 Merge Center Formatting Table St Cipboard Fox Alignment Number G62 1 D E F G H Account Titles Debit Credit A B 1 General Journal 2 3 Date 4 S 6 7 8 9 10 11 12 13 14 15 16 TR Font 1 B E G H board Alignment Number Styles fo Instructions: Record all General Journal Entries into T Accouts below and calculate total account balance to carryforward to Trial D Instructions: Record all General Jurnal Entries into T Accouts below and calculate total account balance to carryforward to Trial Balance. Next, prepare Adjusting Journal Entries and record those into the T Accounts, calculate total and carryforward to Adjusted Trial Balance. Cash 1 Accounts Receivable Es Merge & Center - - % * Formatting table Styles mat 3 Format Printer Coboard A teler Fort 15 Alimen Number A6 A B D G 1 Divine Distributing Company 2 Trial Balances 3 31-Dec-22 5 Prepare from T Accounts Before Adjustment After Adjustment Dr. Cr. Dr. Cr. 3 0 1 2 3 1 2 WIJ TONE Accounting Piste Ila Copy Format Painter Clipboard 15 o BIU. AI 3 Merge & Center % 948 Condition Formatting Font 1 Alignment Number F23 > B D E H 1 2 Date 3 C General Journal Account Titles Debit Credit 4 5 6 7 8 9 10 11 12 13 D32 fo G H 1 Divine Distribuing Company 2 Income Statement (Multi-Step format) 3 For the Month Ended December 31, 2022 4 5 6 7 9 10 11 12 13 14 15 16 17 10 19 Divine Distribuing Company 20 Retained Earnings Statement 21 For the Month Ended December 31, 2022 Clipboard Font Formatting Table Alignment Number Styles B24 A D E G H 1 Divine Distribuing Company 2 Post-Closing Trial Balance 31-Dec-22 3 4 5 Debit Credit 6 7 8 9 10 11 2 3 4 5 France 1 11 Merge Center Formatting Table St Cipboard Fox Alignment Number G62 1 D E F G H Account Titles Debit Credit A B 1 General Journal 2 3 Date 4 S 6 7 8 9 10 11 12 13 14 15 16 TR Font 1 B E G H board Alignment Number Styles fo Instructions: Record all General Journal Entries into T Accouts below and calculate total account balance to carryforward to Trial D Instructions: Record all General Jurnal Entries into T Accouts below and calculate total account balance to carryforward to Trial Balance. Next, prepare Adjusting Journal Entries and record those into the T Accounts, calculate total and carryforward to Adjusted Trial Balance. Cash 1 Accounts Receivable Es Merge & Center - - % * Formatting table Styles mat 3 Format Printer Coboard A teler Fort 15 Alimen Number A6 A B D G 1 Divine Distributing Company 2 Trial Balances 3 31-Dec-22 5 Prepare from T Accounts Before Adjustment After Adjustment Dr. Cr. Dr. Cr. 3 0 1 2 3 1 2 WIJ TONE Accounting Piste Ila Copy Format Painter Clipboard 15 o BIU. AI 3 Merge & Center % 948 Condition Formatting Font 1 Alignment Number F23 > B D E H 1 2 Date 3 C General Journal Account Titles Debit Credit 4 5 6 7 8 9 10 11 12 13 D32 fo G H 1 Divine Distribuing Company 2 Income Statement (Multi-Step format) 3 For the Month Ended December 31, 2022 4 5 6 7 9 10 11 12 13 14 15 16 17 10 19 Divine Distribuing Company 20 Retained Earnings Statement 21 For the Month Ended December 31, 2022 Clipboard Font Formatting Table Alignment Number Styles B24 A D E G H 1 Divine Distribuing Company 2 Post-Closing Trial Balance 31-Dec-22 3 4 5 Debit Credit 6 7 8 9 10 11 2 3 4 5
