Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i need help creating an adjusted trial balance. i included the template for the adjusted trial balance that needs to be filled out as well
i need help creating an adjusted trial balance. i included the template for the adjusted trial balance that needs to be filled out as well as some other information that might help.
Try with these photos
all I need is the adjusted trial balance to he completed. the templatecis what needs to be filled out. The rest of the photos is just extra information.
It isnt blurry on my end try these
9:18 entries posted to Taccounts below 9:18 200 w All above entries posted to accounts below From Taccountsending balances taken to Trial Balance Note Depreciation information norghe, so not adused File Edit View insert Format Tools Data Window Help Acclg 1 Practice Set Template, SP19 Addy Burnett now-Seved to my Mac Page Layout Formulas Data Review View 1 Draw 30 AA E = D Wrap Text Accounting Merger S % 9 E F G C D For the Month ended December 31, 2018 Credit Debit 18,670.00 2,450.00 1,200.00 12.750.00 1,005.00 Cash 2 Accounts Recievable Prepaid Insurance 4 Equipment Gas and O1 Accounts Payable Note Payable Uneamed Revenue al Revenue Advertising Expense 10 Mileage Expense 11 Gas and Oil Expense 12 Insurance Expense 12 Supplies Expense 14 Phone Expense Roberts, Capital Roberts, Withdrawal 4,300.00 20,000.00 900.00 3,350.00 800.00 210.00 90.00 375.00 10,000.00 15 1,000.00 W IR Excel File Edit View Insert Format Tools Data Window Help Autolave Insert Draw u Page Layout . Formulas Accg 1 Practice Set Template_SP19 Addy Burm View Home Data Review wat BU O B e rge & Carter 5 % 9 Roberts Lawn Service Adjusted Trial Balance For the Month December 31, 2018 Accor General Journal Und Post Closing Worksheet Sements 400C 1 2.000 Excel File Edit View Insert Format Tools Data Window Help Autolave Insert Draw u Page Layout . Formulas Accg 1 Practice Set Template_SP19 Addy Burm View Home Data Review = A wap Test Mere & Ceneral $ % BI O A E O % Roberts Law Service Adjusted Trial Balance For the Month dad December 31, 2018 Accounts General Journal Post Closing Und Worksheet B e nts 9:40 Art Answer 1 of 1 Done All above entries posted to accounts below: 20 Gas & Cash 28-Dec Mileage expenses Cash 29-Dec Accounts Receivable Service Revenue 29 Dec Cellphone expenses Cash 30 Dec withdrawals Cash Adjusting entries 31-Decinterest expense Interest Payable 31-Dec Insurance expense Prepaid insurance All above entries posted to T accounts below: From T accounts ending balances taken to Trial Balance worksheet as below: Hui Note- Depreciation information not given, so not adjusted Excel File Edit View Insert Format Tools Data Window Help Autolave Insert Draw u Page Layout . Formulas Accg 1 Practice Set Template_SP19 Addy Burm View Home Data Review = A wap Test Mere & Ceneral $ % BI O A E O % Roberts Law Service Adjusted Trial Balance For the Month dad December 31, 2018 Accounts General Journal Post Closing Und Worksheet B e nts Excel File Edit View Insert Format Tools Data Window Help Autolave Insert Draw u Page Layout . Formulas Accg 1 Practice Set Template_SP19 Addy Burm View Home Data Review = A wap Test Mere & Ceneral $ % BI O A E O % Roberts Law Service Adjusted Trial Balance For the Month dad December 31, 2018 Accounts General Journal Post Closing Und Worksheet B e nts Excel File Edit View Insert Format Tools Data Window Help AutoSave A v u Acctg 1 Practice Set Template_SP19 Addy Burn Home Insert Draw Page Layout Formulas Data Review View Arial 8 A A = = = Wrap Text General BI UBEDA A 3 E3Merge E Merge & Center $ - % X fx Roberts Lawn Service Adjusted Trial Balance For the Month ended December 31, 2018 Accounts General Journal Unad To Workshoot ITB Financial Statements Post Closing TB 10:10 Roberts Law Service 3-Dec Cash 2-Dent Dec 801 13-Dec Cash 34 Cash 13 Rece 15-De Gas & 1- Au Payable 2-bec Mileage expenses Masting entries Deciberete pense Date Date De b ate Crede 15- $ 100 23-Dec $ 40 Dec $20.000 Ders 22 Andere 34-es Dec $4. -es rest Payable 31 Dec 17 Dec 10,000 10 Dec 1,000 S967 $ 30,000 Ders 0 23-Dec 21 2-es 200 29-Dec $ 175 10-Der $ LO 11-Ders 200 1-Dec $ 400 24-Dec $ 950 $ 3.150 rest expens poliese en Dets 31-es 100 Nat. S 901 Bal. S 100 From T accounts ending balances taken to Trial Balance worksheet as below: Unadjusted TB Debit Credit 18.670 Adjustments Debit Credit Adjusted to Debit Credit 1670 income statement Debit Credit Balance Sheet Debit Credit 18,670 2.450 1.00 1.100 12.30 1,005 1200 4.300 Roberts Law Service Account Names Cash Accounts Receivable Gas Oil Prepaid Insurance Equipment Accounts Payable Unearned Revenue Interest Payable Notes Payable Capital withdrawals Service Revenue Advertising expense Cellphone expenses Mileage expenses Supplies expense Insurance expense Interest expense Totals Net Income 10.000 1.000 86883 167 1,702 3,350 9:18 entries posted to Taccounts below 9:18 200 w All above entries posted to accounts below From Taccountsending balances taken to Trial Balance Note Depreciation information norghe, so not adused File Edit View insert Format Tools Data Window Help Acclg 1 Practice Set Template, SP19 Addy Burnett now-Seved to my Mac Page Layout Formulas Data Review View 1 Draw 30 AA E = D Wrap Text Accounting Merger S % 9 E F G C D For the Month ended December 31, 2018 Credit Debit 18,670.00 2,450.00 1,200.00 12.750.00 1,005.00 Cash 2 Accounts Recievable Prepaid Insurance 4 Equipment Gas and O1 Accounts Payable Note Payable Uneamed Revenue al Revenue Advertising Expense 10 Mileage Expense 11 Gas and Oil Expense 12 Insurance Expense 12 Supplies Expense 14 Phone Expense Roberts, Capital Roberts, Withdrawal 4,300.00 20,000.00 900.00 3,350.00 800.00 210.00 90.00 375.00 10,000.00 15 1,000.00 W IR Excel File Edit View Insert Format Tools Data Window Help Autolave Insert Draw u Page Layout . Formulas Accg 1 Practice Set Template_SP19 Addy Burm View Home Data Review wat BU O B e rge & Carter 5 % 9 Roberts Lawn Service Adjusted Trial Balance For the Month December 31, 2018 Accor General Journal Und Post Closing Worksheet Sements 400C 1 2.000 Excel File Edit View Insert Format Tools Data Window Help Autolave Insert Draw u Page Layout . Formulas Accg 1 Practice Set Template_SP19 Addy Burm View Home Data Review = A wap Test Mere & Ceneral $ % BI O A E O % Roberts Law Service Adjusted Trial Balance For the Month dad December 31, 2018 Accounts General Journal Post Closing Und Worksheet B e nts 9:40 Art Answer 1 of 1 Done All above entries posted to accounts below: 20 Gas & Cash 28-Dec Mileage expenses Cash 29-Dec Accounts Receivable Service Revenue 29 Dec Cellphone expenses Cash 30 Dec withdrawals Cash Adjusting entries 31-Decinterest expense Interest Payable 31-Dec Insurance expense Prepaid insurance All above entries posted to T accounts below: From T accounts ending balances taken to Trial Balance worksheet as below: Hui Note- Depreciation information not given, so not adjusted Excel File Edit View Insert Format Tools Data Window Help Autolave Insert Draw u Page Layout . Formulas Accg 1 Practice Set Template_SP19 Addy Burm View Home Data Review = A wap Test Mere & Ceneral $ % BI O A E O % Roberts Law Service Adjusted Trial Balance For the Month dad December 31, 2018 Accounts General Journal Post Closing Und Worksheet B e nts Excel File Edit View Insert Format Tools Data Window Help Autolave Insert Draw u Page Layout . Formulas Accg 1 Practice Set Template_SP19 Addy Burm View Home Data Review = A wap Test Mere & Ceneral $ % BI O A E O % Roberts Law Service Adjusted Trial Balance For the Month dad December 31, 2018 Accounts General Journal Post Closing Und Worksheet B e nts Excel File Edit View Insert Format Tools Data Window Help AutoSave A v u Acctg 1 Practice Set Template_SP19 Addy Burn Home Insert Draw Page Layout Formulas Data Review View Arial 8 A A = = = Wrap Text General BI UBEDA A 3 E3Merge E Merge & Center $ - % X fx Roberts Lawn Service Adjusted Trial Balance For the Month ended December 31, 2018 Accounts General Journal Unad To Workshoot ITB Financial Statements Post Closing TB 10:10 Roberts Law Service 3-Dec Cash 2-Dent Dec 801 13-Dec Cash 34 Cash 13 Rece 15-De Gas & 1- Au Payable 2-bec Mileage expenses Masting entries Deciberete pense Date Date De b ate Crede 15- $ 100 23-Dec $ 40 Dec $20.000 Ders 22 Andere 34-es Dec $4. -es rest Payable 31 Dec 17 Dec 10,000 10 Dec 1,000 S967 $ 30,000 Ders 0 23-Dec 21 2-es 200 29-Dec $ 175 10-Der $ LO 11-Ders 200 1-Dec $ 400 24-Dec $ 950 $ 3.150 rest expens poliese en Dets 31-es 100 Nat. S 901 Bal. S 100 From T accounts ending balances taken to Trial Balance worksheet as below: Unadjusted TB Debit Credit 18.670 Adjustments Debit Credit Adjusted to Debit Credit 1670 income statement Debit Credit Balance Sheet Debit Credit 18,670 2.450 1.00 1.100 12.30 1,005 1200 4.300 Roberts Law Service Account Names Cash Accounts Receivable Gas Oil Prepaid Insurance Equipment Accounts Payable Unearned Revenue Interest Payable Notes Payable Capital withdrawals Service Revenue Advertising expense Cellphone expenses Mileage expenses Supplies expense Insurance expense Interest expense Totals Net Income 10.000 1.000 86883 167 1,702 3,350 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