Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help to produce Balance Sheet, Statement of Retained Earnings, Income Statement, but I need to send you file excell with data, how can

I need help to produce

  1. Balance Sheet,
  2. Statement of Retained Earnings,
  3. Income Statement,

but I need to send you file excell with data, how can I do? can you send me your mail please, if I upload photo here may be is not clear.

Inside the file there are all the info to be able to complete the 3 requests above

Waiting your answer, than thanks for your attention.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

f X Unit 3_ Accounting Templates_ (1).xlsx Apricon Apri con B D E F G . 52 53 54 55 Common Stock Dividend Retained Earnings 56 Debit Credit Debit Credit Debit Credit 57 $20,000 (1) (12) $800 $5.850 58 $800 $800 59 $5.050 60 61 62 63 64 65 66 67 68 69 + 70 71 Cover General Journal Entries T Accounts Trial Balance Income Statement Statement of Retained Earnings Balance Sheet X Unit 3_Accounting Templates_(1).xlsx Apricon Apri con B D E F G H . N. O ZT 28 29 30 31 Revenue Salaries Payable Debit Credit Debit Credit Gas & Oil Expense Debit (11) $600 Credit Salaries Expense Debit (3) $1,700 Credit 32 $500 (e) 33 34 $4,800 (5) $1,900 (10) $6 700 5500 (e) $500 $2.200 35 36 $2,500 (a) 37 S9 200 $9.200 38 39 40 41 42 Income Summary Insurance Expense Debit 43 Depreciation Expense Debit Supplies Expense Debit (d) 5600 Credit Credit Credit Debit Credit $8.100 c) $150 (b) $200 45 $150 $600 $200 46 47 $2.200 $ $600 $500 $200 $150 48 49 50 $4.450 + $4.450 51 52 53 Cover General Journal Entries T Accounts Trial Balance Income Statement Statement of Retained Earnings Balance Sheet X Unit 3_Accounting Templates_(1).xlsx Apricon Apri con A B D E G H . N O 1 2 3 Cash Accounts Receivable Pre-Paid Insurance Supplies 4 Debit Credit Credit Debit Credit Debit Credit Debit (5) 84,800 $20,000 (4) $1,800 (3) $900 $4.000 (2) 5 6 7 7 8 $1,2009) (10) $1,900 $150 (6) $600 (d) $6.700 9 10 11 " 12 $1,800 (4) $1,500 (6) $500 (7) $1,700 (8) la) $2,500 (9) $1,200 $500 (11) $800 (12) $10.400 13 14 15 16 17 18 19 20 21 Equipment: Van Dabit Accounts Payable Debit Accum. Depreciation Debit Credit $200 (b) Bank Loan Debit Credit Credit $900 (3) Credit $7000 (2) (2) $11,000 (7) $500 (6) $1,500 $100 $5.500 22 23 24 25 26 Q + 27 Cover General Journal Entries T Accounts Trial Balance Income Statement Statement of Retained Earnings Balance Sheet 6 x Unit 3_Accounting Templates_(1).xlsx Apri con Apri con B D D E F G . 66 $150 67 Pre-paid Insurance Adjust for the use (expense) of one month's pre-paid insurance 68 69 (d) $600 70 10/31/2018 Baking Supplies Expense Baking Supplies Adjust for the use (expense) of $600 of supplies $600 71 72 73 (e) 10/31/2018 Salaries Expense $500 74 Salaries Payable $500 $ 75 To accure for employee salaries 76 77 78 79 80 81 82 83 + 84 85 Cover General Journal Entries T Accounts Trial Balance Income Statement Statement of Retained Earnings Balance Sheet 6 x Unit 3_Accounting Templates_(1).xlsx Apri con Apri con B C D E F G . 47 #11 10/31/2018 Gas & Oil Expense $500 48 Cash $500 49 Gas and Oil (expense) 50 51 #12 10/31/2018 Dividend $800 52 Cash $800 53 Payment of dividend to shareholders 54 55 Adjusting entries: 56 Debit Credit 57 ( (a) 10/31/2018 Accounts Receivable 2500 58 2500 59 Service Revenue Adjust for unbilled fees eamed in October 2018 60 61 (6) 10/31/2010 Depreciation Expense $500 62 Accumulated Depreciation $500 63 Record depreciation 64 + 65 (c) 10/31/2010 Insurance Expense $150 66 $150 Cover General Journal Entries Accounts Trial Balance Income Statement Statement of Retained Earnings Balance Sheet X Unit 3_Accounting Templates_(1).xlsx Apri con Apri con + B D E F G . 23 #5 10/12/2018 Accounts Receivable $4.800 24 $4.800 25 Service Revenue Billing for baking services rendered 26 27 #6 10/18/2018 Bank Loan $1.500 28 Cash $1.500 29 Loan payment on van loan 30 31 #7 10/18/2018 Accounts Payable $500 32 Cash $500 33 Payment to baking supplies vendor 34 35 #8 10/20/2018 Salaries Expense $1.700 36 Cash $1.700 37 Payment of salaries 38 39 #9 10/21/2018 Cash $1.200 40 Accounts Receivable $1.200 + 41 Collections of Accounts Receivable 42 Cover General Journal Entries T Accounts Trial Balance Income Statement Statement of Retained Earnings Balance Sheet X Unit 3_Accounting Templates_ (1).xlsx Apri con I A B D E F G . J 1 General Journal 2 3 Journal # Date Accounts and Description Debit Credit 4 5 6 #1 10/1/2018 Cash $20.000 7 Common Stock $20.000 8 Initial investment: Cash received for stock ownership 9 10 #2 10/1/2018 Delivery Van - Equipment $11.000 11 Cash $4.000 12 Bank Loan $7.000 13 Purchase delivery van with cash and bank loan 14 15 #3 10/3/2018 Baking Supplies $900 16 Accounts Payable $900 17 Purchased supplies on account 18 - + 19 #4 10/5/2018 Pre-paid Insurance $1.800 20 $1.800 Cover General Journal Entries T Accounts Trial Balance Income Statement Statement of Retained Earnings Balance Sheet X Unit 3_Accounting Templates (1).xlsx Apri con 3 I B C D E H . J L M N O 4 5 Account Beginnng Balance Adjused Trial Balance Adjusting Entries Credit 6 Debit Credit Debit Debit Credit 7 Cash Unadjusted Trial Balance Debit Credit $10.400 $5.500 $900 $10.400 8 Accounts Receivable 0 $2.500 a $8.000 0 $600 d $300 9 10 0 $1.800 $150 $1.650 11 Baking Supplies Prepaid Insurance Equipment Accumulated Deprec. 0 $11.000 $11,000 0 12 13 $200 b $200 14 15 0 $400 $100 Accounts Payable Salaries Payable Bank Loan 0 $500 $500 0 $5.500 $5.500 16 17 18 Common Stock 0 $20.000 $20.000 19 Retained Earings 0 Dividends 0 20 21 $800 $800 22 0 $6.700 $2.500 a $9.200 23 24 O $500 $500 0 $600 d $600 Service Revenue Gas & Oil Expense Baking Supplies Expense Depreciation Expense Insurance Expense Salaries Expense 0 $200 b $200 0 25 26 27 28 29 $150 $150 $500 0 $2,200 $1.700 $32.600 SO $0 $32.600 $3.950 $3.950 $35.800 $35.800 30 31 - + 32 33 Cover General Journal Entries T Accounts Trial Balance Income Statement Statement of Retained Earnings Balance Sheet

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

Students also viewed these Accounting questions