Question
SWARS Consulting & Sales and Sales Inc PARTIALLY ADJUSTED TRIAL BALANCE March 31 2018 Adjusting Part Adj T/B March Jes Trial Balance & Bank Rec
SWARS Consulting & Sales and Sales Inc | |||||||||||
PARTIALLY ADJUSTED TRIAL BALANCE | |||||||||||
March 31 2018 | Adjusting | ||||||||||
Part Adj T/B | March Jes | Trial | Balance | & Bank Rec | Jes | Adusted TB | |||||
DR | CR | DR | CR | DR | CR | DR | CR | DR | CR | ||
Cash | $ 253,560.00 | $ 9,405.00 |
| ||||||||
Accounts Receivable | $ 146,800.00 | $12,100.00 | $12,150.00 |
| |||||||
Allowance for Uncollectible Accounts | $ 2,569.00 | $ 2,650.00 | $ | ||||||||
Supplies | $ 85,650.00 | $ | |||||||||
Inventory | $ 2,600.00 | $ 4,800.00 | $ 6,000.00 | $ | |||||||
Prepaid Insurance | $ 16,800.00 | $ | |||||||||
Land | $ 50,000.00 | $ | |||||||||
Building | $ 125,500.00 | ||||||||||
Accumulated Depr Building | $ 5,670.00 | $ | |||||||||
Computer equipment | $ 52,950.00 | $ | |||||||||
Accumulated Depr Comp Equip | $ 1,750.00 | $ | |||||||||
Office Furniture | $ 85,960.00 | $ | |||||||||
Accumulated Depr - Office Furniture | $ 890.00 | $ | |||||||||
Accounts Payable | $ 48,526.00 | $ 4,800.00 | $ 54.00 | $ | |||||||
Interest Payable | $ 3,200.00 | $ | |||||||||
Utilities Payable | $ 8,952.00 | $ | |||||||||
Wages Payable | $ 98,505.00 | ||||||||||
Long term Note Payable | $ 90,000.00 | ||||||||||
Mortgage Payable | $ 60,000.00 | ||||||||||
Common Stock | $ 400,000.00 | ||||||||||
Retained Earnings | $ 106,468.00 | $ | |||||||||
Dividends | $ 4,000.00 | ||||||||||
Service Revenue | $ 345,650.00 | ||||||||||
Tablet Sales Revenue | $ 210,250.00 | $12,100.00 | $ | ||||||||
Cost of Goods Sold | $ 165,850.00 | $ 6,000.00 | |||||||||
Bad Debt Expense | |||||||||||
Depreciation Expense Building | $ 1,350.00 | ||||||||||
Depreciation Expense - Computer Equip | $ 890.00 | ||||||||||
Depreciation Expense - Office Furn | $ 650.00 | ||||||||||
Interest Expense | $ 3,560.00 | ||||||||||
Insurance Expense | $ 38,950.00 | ||||||||||
Supplies expense | $ 72,860.00 | ||||||||||
Bank fee (expense) | $ 95.00 | ||||||||||
Utilities Expense | $ 75,900.00 | ||||||||||
Wage Expense | $ 198,600.00 | ||||||||||
|
|
|
|
|
|
|
|
| |||
TOTALS | $1,382,430.00 | $1,382,430.00 | $22,900.00 | $22,900.00 |
|
| $ 12,150.00 | $12,204.00 | |||
|
|
|
|
|
|
|
|
| |||
811 10 Submission 3 -due Saturday June 30 before 5pm -You must submit your Adjusting Journal Entries, the worksheet with the Trial Balance, adjusting journal entries and Bank Reconciliation entries, and Adjusted Trial Balance Columns completed, and the Multistep Income Statement completed, the Bank Reconciliation, worksheet and the financial statements formulas tabs completed. The entire excel file must be submitted to the correct assignments link on the class Canvas site. Your file must be named correctly "Your name (first and last) Project 2 part 3. Failure to name your file correctly will result in a 1 point deduction
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