In: Accounting
Worksheet complete through the Trial Balance.
| 
 March Journal Entries  | 
|||
| 
 1-Mar  | 
 Accounts Receivable  | 
 3450  | 
|
| 
 Sales Revenue  | 
 3,450  | 
||
| 
 Cost of Goods Sold  | 
 1450  | 
||
| 
 Inventory  | 
 1,450  | 
||
| 
 3-Mar  | 
 Inventory  | 
 2800  | 
|
| 
 Accounts Payable  | 
 2,800  | 
||
| 
 15-Mar  | 
 Accounts Receivable  | 
 3750  | 
|
| 
 Sales Revenue  | 
 3,750  | 
||
| 
 Cost of Goods Sold  | 
 1950  | 
||
| 
 Inventory  | 
 1,950  | 
||
| 
 20-Mar  | 
 Inventory  | 
 2000  | 
|
| 
 Accounts Payable  | 
 2,000  | 
||
| 
 24-Mar  | 
 Accounts Receivable  | 
 4900  | 
|
| 
 Sales Revenue  | 
 4,900  | 
||
| 
 Cost of Goods Sold  | 
 2600  | 
||
| 
 Inventory  | 
 2,600  | 
||
| 
 #NAME?  | 
|||||||
| 
 PARTIALLY ADJUSTED TRIAL BALANCE  | 
|||||||
| 
 March 31 2018  | 
|||||||
| 
 Part Adj T/B  | 
 March Jes  | 
 Trial  | 
 Balance  | 
||||
| 
 DR  | 
 CR  | 
 DR  | 
 CR  | 
 DR  | 
 CR  | 
||
| 
 Cash  | 
 $253,560  | 
||||||
| 
 Accounts Receivable  | 
 146,800  | 
 12,100  | 
|||||
| 
 Allowance for Uncollectible Accounts  | 
 $2,569  | 
||||||
| 
 Supplies  | 
 85,650  | 
||||||
| 
 Inventory  | 
 2,600  | 
 3,000  | 
|||||
| 
 Prepaid Insurance  | 
 16,800  | 
||||||
| 
 Land  | 
 50,000  | 
||||||
| 
 Building  | 
 125,500  | 
||||||
| 
 Accumulated Depr – Building  | 
 5,670  | 
||||||
| 
 Computer equipment  | 
 52,950  | 
||||||
| 
 Accumulated Depr – Comp Equip  | 
 1,750  | 
||||||
| 
 Office Furniture  | 
 85,960  | 
||||||
| 
 Accumulated Depr - Office Furniture  | 
 890  | 
||||||
| 
 Accounts Payable  | 
 48,526  | 
||||||
| 
 Interest Payable  | 
 3,200  | 
||||||
| 
 Utilities Payable  | 
 8,952  | 
||||||
| 
 Wages Payable  | 
 98,505  | 
||||||
| 
 Long term Note Payable  | 
 90,000  | 
||||||
| 
 Mortgage Payable  | 
 60,000  | 
||||||
| 
 Common Stock  | 
 400,000  | 
||||||
| 
 Retained Earnings  | 
 106,468  | 
||||||
| 
 Dividends  | 
 4,000  | 
||||||
| 
 Service Revenue  | 
 345,650  | 
||||||
| 
 Tablet Sales Revenue  | 
 210,250  | 
||||||
| 
 Cost of Goods Sold  | 
 165,850  | 
 6,000  | 
|||||
| 
 Bad Debt Expense  | 
|||||||
| 
 Depreciation Expense – Building  | 
 1,350  | 
||||||
| 
 Depreciation Expense - Computer Equip  | 
 890  | 
||||||
| 
 Depreciation Expense - Office Furn  | 
 650  | 
||||||
| 
 Interest Expense  | 
 3560  | 
||||||
| 
 Insurance Expense  | 
 38,950  | 
||||||
| 
 Supplies expense  | 
 72,860  | 
||||||
| 
 Bank fee (expense)  | 
|||||||
| 
 Utilities Expense  | 
 75,900  | 
||||||
| 
 Wage Expense  | 
 198,600  | 
||||||
| 
 PARTIALLY ADJUSTED TRIAL BALANCE  | 
||||||
| 
 March 31 2018  | 
||||||
| 
 Part Adj T/B  | 
 March Jes  | 
 Final Adjusted Trial balance  | 
||||
| 
 DR  | 
 CR  | 
 DR  | 
 CR  | 
 DR  | 
 CR  | 
|
| 
 Cash  | 
 $ 2,53,560.00  | 
 $ 2,53,560.00  | 
||||
| 
 Accounts Receivable  | 
 $ 1,46,800.00  | 
 $ 12,100.00  | 
 $ 1,58,900.00  | 
|||
| 
 Allowance for Uncollectible Accounts  | 
 $ 2,569.00  | 
 $ 2,569.00  | 
||||
| 
 Supplies  | 
 $ 85,650.00  | 
 $ 85,650.00  | 
||||
| 
 Inventory  | 
 $ 2,600.00  | 
 $ 4,800.00  | 
 $ 6,000.00  | 
 $ 1,400.00  | 
||
| 
 Prepaid Insurance  | 
 $ 16,800.00  | 
 $ 16,800.00  | 
||||
| 
 Land  | 
 $ 50,000.00  | 
 $ 50,000.00  | 
||||
| 
 Building  | 
 $ 1,25,500.00  | 
 $ 1,25,500.00  | 
||||
| 
 Accumulated Depr – Building  | 
 $ 5,670.00  | 
 $ 5,670.00  | 
||||
| 
 Computer equipment  | 
 $ 52,950.00  | 
 $ 52,950.00  | 
||||
| 
 Accumulated Depr – Comp Equip  | 
 $ 1,750.00  | 
 $ 1,750.00  | 
||||
| 
 Office Furniture  | 
 $ 85,960.00  | 
 $ 85,960.00  | 
||||
| 
 Accumulated Depr - Office Furniture  | 
 $ 890.00  | 
 $ 890.00  | 
||||
| 
 Accounts Payable  | 
 $ 48,526.00  | 
 $ 4,800.00  | 
 $ 53,326.00  | 
|||
| 
 Interest Payable  | 
 $ 3,200.00  | 
 $ 3,200.00  | 
||||
| 
 Utilities Payable  | 
 $ 8,952.00  | 
 $ 8,952.00  | 
||||
| 
 Wages Payable  | 
 $ 98,505.00  | 
 $ 98,505.00  | 
||||
| 
 Long term Note Payable  | 
 $ 90,000.00  | 
 $ 90,000.00  | 
||||
| 
 Mortgage Payable  | 
 $ 60,000.00  | 
 $ 60,000.00  | 
||||
| 
 Common Stock  | 
 $ 4,00,000.00  | 
 $ 4,00,000.00  | 
||||
| 
 Retained Earnings  | 
 $ 1,06,468.00  | 
 $ 1,06,468.00  | 
||||
| 
 Dividends  | 
 $ 4,000.00  | 
 $ 4,000.00  | 
||||
| 
 Service Revenue  | 
 $ 3,45,650.00  | 
 $ 3,45,650.00  | 
||||
| 
 Tablet Sales Revenue  | 
 $ 2,10,250.00  | 
 $ 12,100.00  | 
 $ 2,22,350.00  | 
|||
| 
 Cost of Goods Sold  | 
 $ 1,65,850.00  | 
 $ 6,000.00  | 
 $ 1,71,850.00  | 
|||
| 
 Bad Debt Expense  | 
 $ -  | 
|||||
| 
 Depreciation Expense – Building  | 
 $ 1,350.00  | 
 $ 1,350.00  | 
||||
| 
 Depreciation Expense - Computer Equip  | 
 $ 890.00  | 
 $ 890.00  | 
||||
| 
 Depreciation Expense - Office Furn  | 
 $ 650.00  | 
 $ 650.00  | 
||||
| 
 Interest Expense  | 
 $ 3,560.00  | 
 $ 3,560.00  | 
||||
| 
 Insurance Expense  | 
 $ 38,950.00  | 
 $ 38,950.00  | 
||||
| 
 Supplies expense  | 
 $ 72,860.00  | 
 $ 72,860.00  | 
||||
| 
 Bank fee (expense)  | 
 $ -  | 
|||||
| 
 Utilities Expense  | 
 $ 75,900.00  | 
 $ 75,900.00  | 
||||
| 
 Wage Expense  | 
 $ 1,98,600.00  | 
 $ 1,98,600.00  | 
||||
| 
 TOTAL  | 
 $ 13,82,430.00  | 
 $ 13,82,430.00  | 
 $ 22,900.00  | 
 $ 22,900.00  | 
 $ 13,99,330.00  | 
 $ 13,99,330.00  |