Hello

I solved journal entries, adjust entries, and I attached all of other information in excel file.

Could you please make worksheet, income statement, retained earnings statement, balance sheet, and post closing trial balance?

Journal Entries Date 2-Jan Manufacturin Overhead Expense 2520 Office Overhead Expense 1080 Cash 2-Jan 3600 Advertising Expense Cash 3-Jan Accounts Payable 490 8413.12 Cash 3-Jan Cash Sales Discount 8413.12 8346.69 84.31 Accounts Receivable 4-Jan Employees Income Taxes Payable Employees FICA Taxes Payable 8431 13176.89 8964.44 Federal Unemployement Taxes Payable 319.19 Statement Unemployement Taxes Payable 406.22 cash 4-Jan Income Taxes Payable 22866.74 7423.36 Cash 4-Jan Accounts Payable 7423.36 10714 Cash 4-Jan Work in Progress (job no.403) 10714 14383 Factory overhead Raw material (requisition no.679) 3624 Employees FICA tax payable 609 Employees Federal income tax payable 1218 Wages Payable 4-Jan 10150 6293 finished goods inventory 14383 Work in progress (job no.403) 5-Jan cost of goods sold 14383 14383 Finished goods Inventory 5-Jan Accounts Receivable 14383 20136.2 sales (job no.403) 8-Jan Factory overhead 20136.2 1241.27 factory supplies 9-Jan Property Tax Payable 1241.27 6321 cash 9-Jan Office Supplies 6321 2243.26 Accounts Payable 9-Jan work in progress (job no.406) 2243.26 5914 Raw material (requisition no.681) 10-Jan Cash Sales Discount 5914 10515.78 106.22 Accounts Receivable 11-Jan Accounts Payable 10622 9100 Cash 11-Jan work in progress (job no.402) 9100 1327.14 Raw material (requisition no.682) 12-Jan Cash Accounts Receivable 1327.14 7214.97 7214.97 15-Jan work in progress (job no.404) 2214.06 Raw material (requisition no.683) 16-Jan factory supplies 2214.06 503 cash 16-Jan work in progress (job no.405) 503 7237.13 Factory overhead Employees FICA tax payable 241.24 Employees Federal income tax payable 482.48 Wages Payable 16-Jan 4020.63 2492.79 Finished goods inventory 45944.63 work in progress(job no.405) 16-Jan cost of goods sold 45944.63 1000 Finished goods Inventory 16-Jan cash 1000 1400 sales 17-Jan Factory overhead 1400 1117.5 factory supplies 17-Jan work in progress (job no.407) 1117.5 4220 Raw material (requisition no.685) 17-Jan Advertising Expense 4220 142.62 Cash 18-Jan Allowance for Bad Debt. 142.62 2173 Accounts receivable 18-Jan cost of goods sold 2173 45944.63 Finished goods Inventory 18-Jan Accounts Receivable 45944.63 64322.475 sales (job no.405) 22-Jan Direct Material 64322.475 10232.16 Accounts Payble 22-Jan work in progress (job no.408) 10232.16 2468.1 Raw material (requisition no.686) 24-Jan Accounts Payable 2468.1 2243.26 cash 25-Jan Work in Progress (job no.402) 2243.26 3735 Factory overhead 2075 Employees FICA tax payable 124.5 Employees Federal income tax payable 249 Wages Payable 25-Jan finished goods inventory 1286.5 5062.14 Work in progress (job no.402) 26-Jan cost of goods sold 5062.14 5062.14 Finished goods Inventory 26-Jan Accounts Receivable 5062.14 7086.996 Sales (job no.402) 26-Jan Work in Progress (job no.408) 7086.996 8190 Factory overhead 4550 Employees FICA tax payable 273 Employees Federal income tax payable 546 Wages Payable 2821 26-Jan finished goods inventory 10658.1 Work in progress (job no.408) 29-Jan cost of goods sold 10658.1 10658.1 Finished goods Inventory 29-Jan Accounts Receivable 10658.1 14921.34 Sales (job no.408) 29-Jan Accounts Payable 14921.34 18622 Cash 29-Jan Cash 18622 22941.61 Accounts receivable 29-Jan Postage Expense 22941.61 500 cash 29-Jan Telephone Expense 500 250 cash 29-Jan Advertising Expense-Internet 250 1000 Cash 29-Jan 1000 Electricity Expense 1054 Factory Overhead 3162 cash 31-Jan Work in Progress (job no.404) 4216 2250 Factory overhead 1250 Employees FICA tax payable 75 Employees Federal income tax payable Wages Payable 31-Jan 150 775 Work in Progress (job no.407) 9495 Factory overhead 5275 Employees FICA tax payable 316.5 Employees Federal income tax payable 633 Wages Payable 31-Jan Work in Progress (job no.406) 3270.5 2610 Factory overhead 1450 Employees FICA tax payable 87 Employees Federal income tax payable Wages Payable 31-Jan 174 899 Factory overhead Superintendent's salary 11220 3100 Employees FICA tax payable 1074.00 Employees Income Tax payable 2148.00 State unemployement tax 773.28 Federal Unemployement tax 11.46 Salary payable Payroll Tax expense-General other salary expense 10313.26 7113.92 18311.09 Employees FICA tax payable 1906.88 Employees Income Tax payable 3813.75 State unemployement tax 1372.95 Federal Unemployement tax 20.34 Salary payable 31-Jan cash 18311.09 25521 Accounts Receivable 31-Jan cash 25521 19713 Accounts Receivable 31-Jan Salary Payable cash 19713 28151.05 28151.05 31-Jan Raw Material 8214 Accounts Payable 8214 Adjusting Entries 31-Jan Factory Overhead 1314 Insurance Expense-Selling 61.25 Insurance Expense-General 268.8 Prepaid Insurance 31-Jan office supplies Expense 1644.05 2493.26 office supplies Expense 31-Jan Depriciation Expense-factory equipment Depriciation Expense-office equipment 2493.26 642 369.7 Accumulated depriciation-factory equipment 642 Accumulated depriciation-office equipment 31-Jan Factoty Overhead 369.7 225 Patent 31-Jan Factory Overhead Property Tax expense 225 485 137.26 Property Tax payable 31-Jan Cost of Goods sold 622.26 1371.24 Factory Overhead 31-Jan Bad Debt Expense 1371.24 5727 Allowance for doubtful debt 31-Jan Income Tax Expense Incoem Tax Payable 5727 6786.48 6786.48 Chart of Accounts General Ledgers:Assets (110-199) Current Assets: Revenues (410-499) 110 cash 410 Sales 111 Accounts Receivables 411 Sales discount 112 Allowance for doubtfull accounts 121 Direct Material 122 Indirect Material and Office supplies 123 work in process 501 Cost of Goods Sold 124 finished goods 511 Factory Overhead 131 prepaid insurance 512 Advertising Expense-Print 132 office supplies 513 Advertising Expense-Internet 514 Electricity Expense 515 Insurance Expense-Selling 516 Insurance Expense-General Fixe Assets: Expenses (501-599) 161 Factory Equipment 517 Sales salaries Expense 162 Accumulated Depriciation - Factory Equipment 518 Officer's Salaries Expense 163 Office Equipment 519 Office Salaries Expense 164 Accumulated Depriciation - Office Equipment 520 Depriciation Expense-Office Equipment 521 Office Supplies Expense 522 Payroll Taxes Expense-General 523 Postage Expense-General Intangible Assets: 171 Organization Costs 524 Property Tax Expense 172 Patents 525 Rent Expense-General 526 Telephone 527 Travel and Entertainment Expense 528 Uncollectible Account Expense 599 Miscellaneous Expense Liabilities (210-299) Expense 210 Accounts Payable 211 Salary Payable 221 Employees Income Tax payable 222 FICA Tax Payable 223 Federal Unemployment tax payable 610 Interest Income 224 State Unemployment tax payable 611 Other Income 225 Property Tax payable 612 Interest Expense 226 Income Tax Payable 613 Other Expense Owners Equity: Other Income and Expense (610-699) Income Tax Expense 310 Common Stock ($10 par) 311 Paid-in capital in excess of par 312 Retained Earnings 313 710 Income Summary Accounts Receivable Ledger:Baehler company Loomis Interior Systems Reedy contractors, Inc. Brock Building Company Loren Builders Smith contractors Hawkins Contractors Oakwood Designers Tsua Design Corporation Kyle Corporation Radcliff sales company Accounts Payable Ledger:Carolina Plastics Company Gabehart Container corporation Nyland Supply Company Deboard Tool Company Liesure Wood Products Company Ramez Hardware, Inc. Income Tax Expense Luxurious SPA, Inc. Trial Balance Jan 1,200-Account Title cash Accounts Receivables Debit $78,597.60 $87,611.02 Allowance for doubtfull accounts Direct Material Credit $3,367.00 $71,200.00 Indirect Material and Office supplies $19,216.27 work in process $130,574.50 finished goods $21,325.77 prepaid insurance $7,140.00 office supplies $1,900.00 Factory Equipment $251,944.33 Accumulated Depriciation - Factory Equipment Office Equipment $101,212.34 $62,943.22 Accumulated Depriciation - Office Equipment $21,336.20 Organization Costs $7,320.00 Patents $13,700.00 Accounts Payable $46,849.12 Employees Income Tax payable $13,176.89 FICA Tax Payable $8,964.44 Federal Unemployment tax payable $319.19 State Unemployment tax payable $406.22 Property Tax payable $6,321.00 Income Tax Payable $7,423.36 Common Stock ($10 par) $375,000.00 Paid-in capital in excess of par $55,000.00 Retained Earnings $114,106.95 TOTAL $753,472.71 $753,482.71 Brock building company $3,240 Hawkins contractors 2173 Kyle corporation 8431 Loomis Interior systems Loren builders Radcliff sales company reedy contractors tsua design corporation 13275.44 19713 7214.97 22941.61 10622 total $87,611 Carolina plastics company $10,714 deboard tool company liesure wood products company ramez hardware total 18622 8413.12 9100 $46,849