Answered step by step
Verified Expert Solution
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
- Balance Sheet,
- Statement of Retained Earnings,
- 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.
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
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