Need Trial balance and ledger

Credit Date 24-Dec Debit 25,000 160 24,840 87,500 85,000 2,500 64,000 64,000 8 1,500 75 1,575 17,000 17,000 46,500 1,500 45,000 15,000 15,000 3,000 3,000 1,500 1,500 Entry # Acct. No. Accounts 5 601 Accounts payable 210 Purchase discounts taken 401 Cash Checking 6 401 Cash Checking 101 Pier and lift sales 605 State sales tax payable 7 201 Cost of piers and lifts sold 501 Inventory, piers and lifts 401 Cash Checking 605 State sales tax payable 102 Pier and lift installation labor 9 501 Inventory, piers and lifts 601 Accounts Payable 10 403 Accounts Receivable 605 State sales tax payable 1031 Custom dock sales 11 203 Dock parts costs 601 Accounts Payable 12 203 Dock parts costs 503 Inventory, dock parts 13 503 Inventory, dock parts 601 Accounts Payable 14 401 Accounts Receivable 605 State sales tax payable 104 Seawall installations 15 204 Seawall Costs 601 Accounts Payable 16 401 Cash Checking 605 State sales tax payable 105 Sports equipment sales 17 206 Sports equipment purchases 601 Accounts Payable 18 401 Cash Checking 403 Accounts Receivable 19 319 Advertising Expense 401 Cash Checking 20 317 Fuel Expense 401 Cash Checking 21 322 Freight In 401 Cash Checking 22 314 Utilities Expense 401 Cash Checking 23 311 Salaries expense 603 FICA and Medicare Payable 604 Payroll tax withholdings 602 Wages Payable 17.750 750 17,000 7,000 7,000 13,550 550 13,000 7,000 7,000 23,000 23,000 23,000 23,000 1,000 1,000 1,000 1,000 1800 1,800 13,000 945 3,000 9,055 313 Payroll tax expense 945 945 24 15,000 603 FICA and Medicare Payable 312 Labor Expense 603 FICA and Medicare Payable 604 Payroll tax withholdings 602 Wages Payable 1,475 1,500 12,025 1,475 1,475 25 1,190 860 313 Payroll tax expense 603 FICA and Medicare Payable 323 Interest Expense 611 Mortgage Payable 401 Cash Checking 324 Bad debt expense 404 Allowance for bad debts 335 Depreciation expense - trucks 535 Accumulated depreciation - trucks 2.050 26 945 945 27 8,550 8,550 8,550 15,000 22,150 1,400 28 50,000 40,000 10,000 29 13,000 13,000 30 2,500 2,000 500 31 3,000 3,000 32) 10,000 10,000 331 8,500 8,500 401 Cash Checking 535 Accumulated depreciation 534 Trucks 110 Gain on sale of fixed assests 534 Trucks 612 Installment contracts payable 401 Cash Checking 532 Barge 316 Maintenance Expense 403 Accounts Receivable 401 Cash Checking 107 Permit fee revenue 537 Tools 401 Cash Checking 703 Dividends Declared 401 Cash Checking 401 Cash Checking 6092 Deferred revenue - gift certificate 6092 Deferred revenue - gift certificate 105 Sports equipment sales 605 State sales tax payable 404 Allowance for bad debts 403 Accounts Receivable 401 Cash Checking 106 Sports equipment rental revenue 605 State sales tax payable 600 Customer Deposits 321 Professional fees expense 601 Accounts Payable 405 Accounts receivable - rebates 501 Inventory, piers and lifts 201 Cost of sales - piers and lifts 319 Advertising Expense 607| Estimated liabilites 401 Cash Checking 511 Prepaid Expense 34 8,200 8,000 200 35 1,500 1,500 36 12,500 10,000 500 2,000 37 2.400 2,400 38 10,000 2,000 8,000 39 1,200 600 600 401 1,000 2,000 512 Security deposit 401 Cash Checking 3,000 26-Dec 1 15,000 15,000 2 2,295 3 2,295 1,500 12,353 4 7,075 7,075 5 602 Wages Payable 401 Cash Checking 603 FICA and Medicare payable 401 Cash Checking 604 Payroll tax withholdings 401 Cash Checking 605 State sales tax payable 401 Cash Checking 321 Professional fees expense 403 Accounts Receivable 401 Cash Checking 401 Cash Checking 600 Customer Deposits 402 Cash - money market 401 Cash Checking 402 Cash-money market 109 Interest revenue 321 Professional fees expense 401 Cash Checking 20 12,350 12,370 6 2.000 2,000 7 30,000 30,000 8 900 900 9 75 75 Ozark Requirement 2 Dec. 31, 2016, unadjusted account balances Spring 2021 Important Note on ledger accounts: Accounts with a normal credit balance should keep the balance as a negative. Cells are currently formated as "Accounting" which menas credit balance are in parenteses ()-| Those accounts would include, allowance for bad debts, accumulated depreciation, liabilitres, stockholders' equity and revenue accounts. In all cases, the new balance in every account is: prior balance from cell above + debit on that line - credit on that line (see cell H18 below) The empty space provide should be just right for the entries required. Credit Balance 401 Name: Debit Cash-checking Account Number: Nov. 30 Balance 2-Dec 18,000.00 1,377.00 3,600.00 11,500.00 38,000.00 10-Dec 27,300.00 2,415.00 4,725.00 42,000.00 2 3 4 5 6 8 15 17 18 19 20 24 1 2 3 4 57,660.00 39,660.00 38,283.00 34,683.00 23,183.00 (14,817.00) 12,483.00 14,898.00 19,623.00 61,623.00 60,223.00 59,723.00 58,323.00 45, 123.00 30,301.00 27,545.00 25,745.00 22,980.00 1,400.00 500.00 1,400.00 13,200.00 14,822.00 2,756.00 1,800.00 2,765.00 12-Dec Dec. 31 balance Adjustments December 31, Adjusted Balance 402 Name: Account Number: Nov. 30 Balance Cash-money market 173,092.00 Dec. 31 balance December 31, Adjusted Balance 403 Name: Accounts receivable Account Number: Nov. 30 Balance 10-Dec 10 13 17 21 16,800.00 6,825.00 49,000.00 65,800.00 72,625.00 30,625.00 28,125.00 42,000.00 2,500.00 Dec. 31unadjusted balance December 31, Adjusted Balance 404 Name: Allowance for bad debts Account Number: Nov. 30 Balance 10-Dec 21 25 2,500.00 (3,000.00) (500.00) (736.00) 236.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance Account Number: Nov. 30 Balance 406 Name: Trading investments 12,000.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 4061 Name: Account Number: Nov. 30 Trading In Market adjustment Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 405 Name: Rebate Receivable Account Number: Nov. 30 Balance Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 501 ' Name: Inventory, piers and lifts Account Number: Nov. 30 Balance 10-Dec 7 9 19,000.00 130,000.00 111,000.00 143,000.00 32,000.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 503 Name: Inventory, dock parts Account Number: Nov. 30 Balance 10-Dec 4,100.00 3,760.00 12 340.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 505 Name: Account Number: Nov. 30 Balance Inventory, sports equipment 25,000.00 Dec. 31 unadjusted balance 25,000.00 Dec. 31 Adjusted Balance 510 Name: Account Number: Nov. 30 Balance Supplies 1,800.00 Dec. 31 unadjusted balance 1,800.00 Dec. 31 Adjusted Balance Account Number: Nov. 30 Balance 511 Name: Prepaid expense Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 512 Security deposit Account Number: Nov. 30 Balance Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 520 Name: Land Account Number: Nov. 30 Balance 120,000.00 Dec. 31 balance 120,000.00 530 Name: Account Number Nov. 30 Balance Buildings 450,000.00 Dec. 31 balance 450,000.00 531 Name: Account Number: Nov. 30 Balance Accumulated depreciation buildings (150,000.00) Dec. 31 unadjusted balance (150,000.00) Dec. 31 Adjusted Balance Account Number: Nov. 30 Balance 532 Name: Barge 65,000.00 Dec. 31 balance 533 Name: Account Number: Nov. 30 Balance Accumulated depreciation - barge (26,000.00) Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 534 Name: Trucks Account Number: Nov. 30 Balance 85,000.00 Dec. 31 balance Account Number: Nov. 30 Balance 535 Name: Accumulated Depreciation- trucks (36,000.00) Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 537 Name: Tools Account Number: Nov. 30 Balance 6,700.00 Dec. 31 unadjusted balance 6,700.00 Dec. 31 Adjusted Balance 6,700.00 600 Name: Customer Deposits Account Number: Nov. 30 Balance Dec. 31 balance 601 Name: Accounts payable Account Number: Nov. 30 Balance 10-Dec 38,000.00 5.00 9.00 11.00 14.00 16.00 32,000.00 8,500.00 2,300.00 3,200.00 (46,000.00) (8,000.00) (40,000.00) (48,500.00) (50,800.00 (54,000.00) Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 602 Name: Wages payable Account Number: Nov. 30 Balance 2-Dec 10-Dec (18,000.00) 18,000.00 1.00 22.00 23.00 1.00 4,117.00 10,705.00 (4,117.00) (14,822.00) 12-Dec 14,822.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 603 Name: FICA and Medicare payable Account Number: Nov. 30 Balance 2-Dec 10-Dec (1,377.00) 1,377.00 2.00 22.00 22.00 23.00 23.00 2.00 383.00 383.00 995.00 995.00 (383.00) (766.00) (1,761.00) (2,756.00) 12-Dec 2,756.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 604 Name: Payroll tax withholdings Account Number Nov. 30 Balance 2-Dec 10-Dec (3,600.00) 3,600.00 3.00 22.00 23.00 3.00 500.00 1,300.00 (500.00) (1,800.00) 2-Dec 1,800.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 605 Name: State sales tax payable Account Number: Nov. 30 Balance 2-Dec 10-Dec (11,500.00) 11,500.00 4.00 6.00 8.00 10.00 13.00 15.00 4.00 1,300.00 115.00 800.00 325.00 225.00 (1,300.00) (1,415.00) (2,215.00) (2,540.00) (2,765.00) 12-Dec 2,765.00 Dec. 31 balance 606 Name: Federal Income taxes payable Account Number: Nov. 30 Balance Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 607 Name: Account Number: Nov. 30 Balance Estimated liabilities Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 608 Name: Accrued interest payable Account Number: Nov. 30 Balance Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 6091 Name: Deferred revenue Account Number: Nov. 30 Balance (4,000.00) Dec. 31 balance 6092 Name: Gift Certificate Liability Account Number: Nov. 30 Balance Dec. 31 balance 610 Name: Notes payable Account Number: Nov. 30 Balance (120,000.00) Dec. 31 balance (120,000.00 611 Name: Account Number: Nov. 30 Balance Mortgage payable (269,860.00) Dec. 31 balance 612 Name: Installment contracts payable Account Number: Nov. 30 Balance Dec. 31 balance 613 Name: Account Number Nov. 30 Balance Deferred sport rental Dec. 31 balance 700 Name: Common stock Account Number: Nov. 30 Balance (10,000.00) Dec. 31 balance 701 Name: Account Number: Nov. 30 Balance Paid in excess of par (190,000.00) Dec. 31 balance Account Number: Nov. 30 Balance 702 Name: Retained Earnings (158,791.00) Dec. 31 unadjusted balance (158,791.00) Dec. 31 Adjusted Balance Account Number: Nov. 30 Balance 703 Name: Dividends declared Dec. 31 balance Account Number: Nov. 30 Balance 704 Name: Prior period adjustment Dec. 31 balance 101 Name: Pier and Lift Sales Account Number: Nov. 30 Balance 10-Deci (850,000.00) (876,000.00) 6 26,000.00 Dec. 31 balance 102 Name: Pier and lift installation labor Account Number: Nov. 30 Balance 10-Dec 8 2,300.00 (165,000.00) (167,300.00) Dec. 31 balance 103 Name: Custom Dock Sales Account Number: Nov. 30 Balance 10-Dec 10 16,000.00 (245,000.00) (261,000.00) Dec. 31 balance 104 Name: Seawall installations Account Number: Nov. 30 Balance 10-Dec 13 (180,000.00) (186,500.00) 6,500.00 Dec. 31 balance 105 Name: Sports equipment sales Account Number: Nov. 30 Balance 10-Dec (88,000.00) (92,500.00) 15 4,500.00 Dec. 31 balance 106 Name: Account Number: Nov. 30 Balance Sports equipment rental revenue (31,500.00) Dec. 31 balance 107 Name: Permit fee revenue Account Number: Nov. 30 Balance (4,000.00) Dec. 31 balance 109 Name: Account Number Nov. 30 Balance Interest revenue Dec. 31 balance Account Number: Nov. 30 Balance 110 Name: Gain/Loss on sale of fixed assets Dec. 31 balance 111 Name: Account Number: Nov. 30 Balance Unrealized gain/loss marketable investments Dec. 31 balance 201 Name: Cost of sales-piers and lifts Account Number: Nov. 30 Balance 10-Dec 7 19,000.00 627,000.00 646,000.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 203 Name: Dock parts costs Account Number: Nov. 30 Balance 10-Dec 11 12 8,500.00 340.00 163,000.00 171,500.00 171,840.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 204 Name: Seawall costs Account Number: Nov. 30 Balance 10-Dec 96,000.00 98,300.00 14 2,300.00 Dec. 31 balance Account Number: 205 Name: Sports equipment Cost of Goods Sold Nov. 30 Balance Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 206 Name: Sports equipment purchases Account Number: Nov. 30 Balance 10-Dec 78,500.00 81,700.00 16 3,200.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 210 Name: Account Number: Nov. 30 Balance Purchase discounts taken (3,900.00) Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 311 Name: Salaries expense Account Number: Nov. 30 Balance 10-Dec 89,000.00 94,000.00 22 5,000.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 312 Name: Labor expense Account Number: Nov. 30 Balance 10-Dec 23 13,000.00 195,000.00 208,000.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 313 Name: Payroll tax expense Account Number: Nov. 30 Balance 10-Dec 22 23 383.00 995.00 21,726.00 22, 109.00 23,104.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 314 Name: Utilities expense Account Number: Nov. 30 Balance 18,600.00 Dec. 31 balance 315 Name: Insurance expense Account Number: Nov. 30 Balance 10-Dec 27,000.00 40,200.00 24 13,200.00 Dec. 31 unadjusted balance 40,200.00 Dec. 31 Adjusted Balance 316 Name: Maintenance expense Account Number Nov. 30 Balance 16,900.00 Dec. 31 balance 317 Name: Fuel expense Account Number: Nov. 30 Balance 5,300.00 Dec. 31 balance 318 Name: Account Number: Nov. 30 Balance Property tax expense 12,000.00 Dec. 31 unadjusted balance 12,000.00 Dec. 31 Adjusted Balance 319 ' Name: Advertising expense Account Number: Nov. 30 Balance 10-Dec 32,000.00 33,400.00 18 1,400.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 320 Name: Supplies expense Account Number: Nov. 30 Balance 10-Dec 19 500.00 12,400.00 12,900.00 Dec. 31 unadjusted balance 12,900.00 Dec. 31 Adjusted Balance 321 Name: Account Number: Nov. 30 Balance Professional fees expense 7,300.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 322 Name: Freight In Account Number: Nov. 30 Balance 10-Dec 20 1,400.00 3,200.00 4,600.00 Dec. 31 balance 323 Name: Interest expense Account Number Nov. 30 Balance 27,000.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 324 Name: Bad debt expense Account Number: Nov. 30 Balance 10-Dec 25 236.00 4,250.00 4,486.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 331 Name: Account Number: Nov. 30 Balance Depreciation expense-buildings Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 333 Name: Account Number: Nov. 30 Balance Depreciation expense-barge Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 335 Name: Account Number: Nov. 30 Balance Depreciation expense-trucks Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 337 Name: Account Number: Nov. 30 Balance Depreciation expense-tools Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 340 Name: Account Number: Nov. 30 Balance Inventory write-down Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 341 Account Number: Nov. 30 Balance Exchange Gain/Loss Dec. 31 Adjusted Balance 350 Name: Estimated losses Account Number: Nov. 30 Balance Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 399 Name: Account Number: Nov. 30 Balance Income tax expense Dec. 31 Adjusted Balance Income Statement Debit Credit Retained Earnings Debit Credit Balance Sheet Debit Credit Worksheet Ozark Dock and Lift Company Note: You can manually copy ledger balance into appropriate cell, or better yet, you can just reference the balance from the 'ledger" tab. See my entry in cell D7 If you do reference ledger, start with a minus sign for credit balance so that they appear as a positive number in the credit column. December 31, 2016 Spring 2021 Unadjusted Trial Balance Adjusting Entries Adjusted Trial Balance Debit Credit Key Debit Key Credit Debt Credit Cash-checking 401 Cash-money market 402 Accounts receivable 403 Allowance for bad debts 404 Rebate Receivable 405 Trading investments 406 Trading Invest Market Adj 4061 Inventory, piers and lifts 501 Inventory, dock parts Inventory, sports equipment Supplies Prepaid expense 503 505 510 511 Security deposit Land Buildings Accumulated depreciation-buildings Barge Accumulated depreciation-barge Trucks Accumulated Depreciation-trucks Tools Customer Deposits Accounts payable 512 520 530 531 532 533 534 535 537 600 601 Wages payable FICA and Medicare payable Payroll tax withholdings State sales tax payable Federal Income taxes payable Estimated liabilities Accrued interest payable Deferred revenue Gift Certificate Liability Notes payable Mortgage payable Installment contracts payable Deferred sport rental Common stock Paid in excess of par Retained Earnings Dividends declared Prior Period Adjustment Pier and Lift Sales Pier and lift installation labor Custom Dock Sales Seawal installations Sports equipment sales Sports equipment rental revenue Permit fee revenue Interest revenue Gain/Loss on sale of fixed assets Unrealized gain loss marketable investments 602 603 604 605 606 607 608 6091 6092 610 611 612 813 700 701 702 703 704 101 102 103 104 105 106 107 108 110 111 Cost of sales-piers and lifts Dock parts costs Credit Date 24-Dec Debit 25,000 160 24,840 87,500 85,000 2,500 64,000 64,000 8 1,500 75 1,575 17,000 17,000 46,500 1,500 45,000 15,000 15,000 3,000 3,000 1,500 1,500 Entry # Acct. No. Accounts 5 601 Accounts payable 210 Purchase discounts taken 401 Cash Checking 6 401 Cash Checking 101 Pier and lift sales 605 State sales tax payable 7 201 Cost of piers and lifts sold 501 Inventory, piers and lifts 401 Cash Checking 605 State sales tax payable 102 Pier and lift installation labor 9 501 Inventory, piers and lifts 601 Accounts Payable 10 403 Accounts Receivable 605 State sales tax payable 1031 Custom dock sales 11 203 Dock parts costs 601 Accounts Payable 12 203 Dock parts costs 503 Inventory, dock parts 13 503 Inventory, dock parts 601 Accounts Payable 14 401 Accounts Receivable 605 State sales tax payable 104 Seawall installations 15 204 Seawall Costs 601 Accounts Payable 16 401 Cash Checking 605 State sales tax payable 105 Sports equipment sales 17 206 Sports equipment purchases 601 Accounts Payable 18 401 Cash Checking 403 Accounts Receivable 19 319 Advertising Expense 401 Cash Checking 20 317 Fuel Expense 401 Cash Checking 21 322 Freight In 401 Cash Checking 22 314 Utilities Expense 401 Cash Checking 23 311 Salaries expense 603 FICA and Medicare Payable 604 Payroll tax withholdings 602 Wages Payable 17.750 750 17,000 7,000 7,000 13,550 550 13,000 7,000 7,000 23,000 23,000 23,000 23,000 1,000 1,000 1,000 1,000 1800 1,800 13,000 945 3,000 9,055 313 Payroll tax expense 945 945 24 15,000 603 FICA and Medicare Payable 312 Labor Expense 603 FICA and Medicare Payable 604 Payroll tax withholdings 602 Wages Payable 1,475 1,500 12,025 1,475 1,475 25 1,190 860 313 Payroll tax expense 603 FICA and Medicare Payable 323 Interest Expense 611 Mortgage Payable 401 Cash Checking 324 Bad debt expense 404 Allowance for bad debts 335 Depreciation expense - trucks 535 Accumulated depreciation - trucks 2.050 26 945 945 27 8,550 8,550 8,550 15,000 22,150 1,400 28 50,000 40,000 10,000 29 13,000 13,000 30 2,500 2,000 500 31 3,000 3,000 32) 10,000 10,000 331 8,500 8,500 401 Cash Checking 535 Accumulated depreciation 534 Trucks 110 Gain on sale of fixed assests 534 Trucks 612 Installment contracts payable 401 Cash Checking 532 Barge 316 Maintenance Expense 403 Accounts Receivable 401 Cash Checking 107 Permit fee revenue 537 Tools 401 Cash Checking 703 Dividends Declared 401 Cash Checking 401 Cash Checking 6092 Deferred revenue - gift certificate 6092 Deferred revenue - gift certificate 105 Sports equipment sales 605 State sales tax payable 404 Allowance for bad debts 403 Accounts Receivable 401 Cash Checking 106 Sports equipment rental revenue 605 State sales tax payable 600 Customer Deposits 321 Professional fees expense 601 Accounts Payable 405 Accounts receivable - rebates 501 Inventory, piers and lifts 201 Cost of sales - piers and lifts 319 Advertising Expense 607| Estimated liabilites 401 Cash Checking 511 Prepaid Expense 34 8,200 8,000 200 35 1,500 1,500 36 12,500 10,000 500 2,000 37 2.400 2,400 38 10,000 2,000 8,000 39 1,200 600 600 401 1,000 2,000 512 Security deposit 401 Cash Checking 3,000 26-Dec 1 15,000 15,000 2 2,295 3 2,295 1,500 12,353 4 7,075 7,075 5 602 Wages Payable 401 Cash Checking 603 FICA and Medicare payable 401 Cash Checking 604 Payroll tax withholdings 401 Cash Checking 605 State sales tax payable 401 Cash Checking 321 Professional fees expense 403 Accounts Receivable 401 Cash Checking 401 Cash Checking 600 Customer Deposits 402 Cash - money market 401 Cash Checking 402 Cash-money market 109 Interest revenue 321 Professional fees expense 401 Cash Checking 20 12,350 12,370 6 2.000 2,000 7 30,000 30,000 8 900 900 9 75 75 Ozark Requirement 2 Dec. 31, 2016, unadjusted account balances Spring 2021 Important Note on ledger accounts: Accounts with a normal credit balance should keep the balance as a negative. Cells are currently formated as "Accounting" which menas credit balance are in parenteses ()-| Those accounts would include, allowance for bad debts, accumulated depreciation, liabilitres, stockholders' equity and revenue accounts. In all cases, the new balance in every account is: prior balance from cell above + debit on that line - credit on that line (see cell H18 below) The empty space provide should be just right for the entries required. Credit Balance 401 Name: Debit Cash-checking Account Number: Nov. 30 Balance 2-Dec 18,000.00 1,377.00 3,600.00 11,500.00 38,000.00 10-Dec 27,300.00 2,415.00 4,725.00 42,000.00 2 3 4 5 6 8 15 17 18 19 20 24 1 2 3 4 57,660.00 39,660.00 38,283.00 34,683.00 23,183.00 (14,817.00) 12,483.00 14,898.00 19,623.00 61,623.00 60,223.00 59,723.00 58,323.00 45, 123.00 30,301.00 27,545.00 25,745.00 22,980.00 1,400.00 500.00 1,400.00 13,200.00 14,822.00 2,756.00 1,800.00 2,765.00 12-Dec Dec. 31 balance Adjustments December 31, Adjusted Balance 402 Name: Account Number: Nov. 30 Balance Cash-money market 173,092.00 Dec. 31 balance December 31, Adjusted Balance 403 Name: Accounts receivable Account Number: Nov. 30 Balance 10-Dec 10 13 17 21 16,800.00 6,825.00 49,000.00 65,800.00 72,625.00 30,625.00 28,125.00 42,000.00 2,500.00 Dec. 31unadjusted balance December 31, Adjusted Balance 404 Name: Allowance for bad debts Account Number: Nov. 30 Balance 10-Dec 21 25 2,500.00 (3,000.00) (500.00) (736.00) 236.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance Account Number: Nov. 30 Balance 406 Name: Trading investments 12,000.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 4061 Name: Account Number: Nov. 30 Trading In Market adjustment Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 405 Name: Rebate Receivable Account Number: Nov. 30 Balance Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 501 ' Name: Inventory, piers and lifts Account Number: Nov. 30 Balance 10-Dec 7 9 19,000.00 130,000.00 111,000.00 143,000.00 32,000.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 503 Name: Inventory, dock parts Account Number: Nov. 30 Balance 10-Dec 4,100.00 3,760.00 12 340.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 505 Name: Account Number: Nov. 30 Balance Inventory, sports equipment 25,000.00 Dec. 31 unadjusted balance 25,000.00 Dec. 31 Adjusted Balance 510 Name: Account Number: Nov. 30 Balance Supplies 1,800.00 Dec. 31 unadjusted balance 1,800.00 Dec. 31 Adjusted Balance Account Number: Nov. 30 Balance 511 Name: Prepaid expense Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 512 Security deposit Account Number: Nov. 30 Balance Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 520 Name: Land Account Number: Nov. 30 Balance 120,000.00 Dec. 31 balance 120,000.00 530 Name: Account Number Nov. 30 Balance Buildings 450,000.00 Dec. 31 balance 450,000.00 531 Name: Account Number: Nov. 30 Balance Accumulated depreciation buildings (150,000.00) Dec. 31 unadjusted balance (150,000.00) Dec. 31 Adjusted Balance Account Number: Nov. 30 Balance 532 Name: Barge 65,000.00 Dec. 31 balance 533 Name: Account Number: Nov. 30 Balance Accumulated depreciation - barge (26,000.00) Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 534 Name: Trucks Account Number: Nov. 30 Balance 85,000.00 Dec. 31 balance Account Number: Nov. 30 Balance 535 Name: Accumulated Depreciation- trucks (36,000.00) Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 537 Name: Tools Account Number: Nov. 30 Balance 6,700.00 Dec. 31 unadjusted balance 6,700.00 Dec. 31 Adjusted Balance 6,700.00 600 Name: Customer Deposits Account Number: Nov. 30 Balance Dec. 31 balance 601 Name: Accounts payable Account Number: Nov. 30 Balance 10-Dec 38,000.00 5.00 9.00 11.00 14.00 16.00 32,000.00 8,500.00 2,300.00 3,200.00 (46,000.00) (8,000.00) (40,000.00) (48,500.00) (50,800.00 (54,000.00) Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 602 Name: Wages payable Account Number: Nov. 30 Balance 2-Dec 10-Dec (18,000.00) 18,000.00 1.00 22.00 23.00 1.00 4,117.00 10,705.00 (4,117.00) (14,822.00) 12-Dec 14,822.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 603 Name: FICA and Medicare payable Account Number: Nov. 30 Balance 2-Dec 10-Dec (1,377.00) 1,377.00 2.00 22.00 22.00 23.00 23.00 2.00 383.00 383.00 995.00 995.00 (383.00) (766.00) (1,761.00) (2,756.00) 12-Dec 2,756.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 604 Name: Payroll tax withholdings Account Number Nov. 30 Balance 2-Dec 10-Dec (3,600.00) 3,600.00 3.00 22.00 23.00 3.00 500.00 1,300.00 (500.00) (1,800.00) 2-Dec 1,800.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 605 Name: State sales tax payable Account Number: Nov. 30 Balance 2-Dec 10-Dec (11,500.00) 11,500.00 4.00 6.00 8.00 10.00 13.00 15.00 4.00 1,300.00 115.00 800.00 325.00 225.00 (1,300.00) (1,415.00) (2,215.00) (2,540.00) (2,765.00) 12-Dec 2,765.00 Dec. 31 balance 606 Name: Federal Income taxes payable Account Number: Nov. 30 Balance Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 607 Name: Account Number: Nov. 30 Balance Estimated liabilities Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 608 Name: Accrued interest payable Account Number: Nov. 30 Balance Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 6091 Name: Deferred revenue Account Number: Nov. 30 Balance (4,000.00) Dec. 31 balance 6092 Name: Gift Certificate Liability Account Number: Nov. 30 Balance Dec. 31 balance 610 Name: Notes payable Account Number: Nov. 30 Balance (120,000.00) Dec. 31 balance (120,000.00 611 Name: Account Number: Nov. 30 Balance Mortgage payable (269,860.00) Dec. 31 balance 612 Name: Installment contracts payable Account Number: Nov. 30 Balance Dec. 31 balance 613 Name: Account Number Nov. 30 Balance Deferred sport rental Dec. 31 balance 700 Name: Common stock Account Number: Nov. 30 Balance (10,000.00) Dec. 31 balance 701 Name: Account Number: Nov. 30 Balance Paid in excess of par (190,000.00) Dec. 31 balance Account Number: Nov. 30 Balance 702 Name: Retained Earnings (158,791.00) Dec. 31 unadjusted balance (158,791.00) Dec. 31 Adjusted Balance Account Number: Nov. 30 Balance 703 Name: Dividends declared Dec. 31 balance Account Number: Nov. 30 Balance 704 Name: Prior period adjustment Dec. 31 balance 101 Name: Pier and Lift Sales Account Number: Nov. 30 Balance 10-Deci (850,000.00) (876,000.00) 6 26,000.00 Dec. 31 balance 102 Name: Pier and lift installation labor Account Number: Nov. 30 Balance 10-Dec 8 2,300.00 (165,000.00) (167,300.00) Dec. 31 balance 103 Name: Custom Dock Sales Account Number: Nov. 30 Balance 10-Dec 10 16,000.00 (245,000.00) (261,000.00) Dec. 31 balance 104 Name: Seawall installations Account Number: Nov. 30 Balance 10-Dec 13 (180,000.00) (186,500.00) 6,500.00 Dec. 31 balance 105 Name: Sports equipment sales Account Number: Nov. 30 Balance 10-Dec (88,000.00) (92,500.00) 15 4,500.00 Dec. 31 balance 106 Name: Account Number: Nov. 30 Balance Sports equipment rental revenue (31,500.00) Dec. 31 balance 107 Name: Permit fee revenue Account Number: Nov. 30 Balance (4,000.00) Dec. 31 balance 109 Name: Account Number Nov. 30 Balance Interest revenue Dec. 31 balance Account Number: Nov. 30 Balance 110 Name: Gain/Loss on sale of fixed assets Dec. 31 balance 111 Name: Account Number: Nov. 30 Balance Unrealized gain/loss marketable investments Dec. 31 balance 201 Name: Cost of sales-piers and lifts Account Number: Nov. 30 Balance 10-Dec 7 19,000.00 627,000.00 646,000.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 203 Name: Dock parts costs Account Number: Nov. 30 Balance 10-Dec 11 12 8,500.00 340.00 163,000.00 171,500.00 171,840.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 204 Name: Seawall costs Account Number: Nov. 30 Balance 10-Dec 96,000.00 98,300.00 14 2,300.00 Dec. 31 balance Account Number: 205 Name: Sports equipment Cost of Goods Sold Nov. 30 Balance Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 206 Name: Sports equipment purchases Account Number: Nov. 30 Balance 10-Dec 78,500.00 81,700.00 16 3,200.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 210 Name: Account Number: Nov. 30 Balance Purchase discounts taken (3,900.00) Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 311 Name: Salaries expense Account Number: Nov. 30 Balance 10-Dec 89,000.00 94,000.00 22 5,000.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 312 Name: Labor expense Account Number: Nov. 30 Balance 10-Dec 23 13,000.00 195,000.00 208,000.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 313 Name: Payroll tax expense Account Number: Nov. 30 Balance 10-Dec 22 23 383.00 995.00 21,726.00 22, 109.00 23,104.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 314 Name: Utilities expense Account Number: Nov. 30 Balance 18,600.00 Dec. 31 balance 315 Name: Insurance expense Account Number: Nov. 30 Balance 10-Dec 27,000.00 40,200.00 24 13,200.00 Dec. 31 unadjusted balance 40,200.00 Dec. 31 Adjusted Balance 316 Name: Maintenance expense Account Number Nov. 30 Balance 16,900.00 Dec. 31 balance 317 Name: Fuel expense Account Number: Nov. 30 Balance 5,300.00 Dec. 31 balance 318 Name: Account Number: Nov. 30 Balance Property tax expense 12,000.00 Dec. 31 unadjusted balance 12,000.00 Dec. 31 Adjusted Balance 319 ' Name: Advertising expense Account Number: Nov. 30 Balance 10-Dec 32,000.00 33,400.00 18 1,400.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 320 Name: Supplies expense Account Number: Nov. 30 Balance 10-Dec 19 500.00 12,400.00 12,900.00 Dec. 31 unadjusted balance 12,900.00 Dec. 31 Adjusted Balance 321 Name: Account Number: Nov. 30 Balance Professional fees expense 7,300.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 322 Name: Freight In Account Number: Nov. 30 Balance 10-Dec 20 1,400.00 3,200.00 4,600.00 Dec. 31 balance 323 Name: Interest expense Account Number Nov. 30 Balance 27,000.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 324 Name: Bad debt expense Account Number: Nov. 30 Balance 10-Dec 25 236.00 4,250.00 4,486.00 Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 331 Name: Account Number: Nov. 30 Balance Depreciation expense-buildings Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 333 Name: Account Number: Nov. 30 Balance Depreciation expense-barge Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 335 Name: Account Number: Nov. 30 Balance Depreciation expense-trucks Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 337 Name: Account Number: Nov. 30 Balance Depreciation expense-tools Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 340 Name: Account Number: Nov. 30 Balance Inventory write-down Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 341 Account Number: Nov. 30 Balance Exchange Gain/Loss Dec. 31 Adjusted Balance 350 Name: Estimated losses Account Number: Nov. 30 Balance Dec. 31 unadjusted balance Dec. 31 Adjusted Balance 399 Name: Account Number: Nov. 30 Balance Income tax expense Dec. 31 Adjusted Balance Income Statement Debit Credit Retained Earnings Debit Credit Balance Sheet Debit Credit Worksheet Ozark Dock and Lift Company Note: You can manually copy ledger balance into appropriate cell, or better yet, you can just reference the balance from the 'ledger" tab. See my entry in cell D7 If you do reference ledger, start with a minus sign for credit balance so that they appear as a positive number in the credit column. December 31, 2016 Spring 2021 Unadjusted Trial Balance Adjusting Entries Adjusted Trial Balance Debit Credit Key Debit Key Credit Debt Credit Cash-checking 401 Cash-money market 402 Accounts receivable 403 Allowance for bad debts 404 Rebate Receivable 405 Trading investments 406 Trading Invest Market Adj 4061 Inventory, piers and lifts 501 Inventory, dock parts Inventory, sports equipment Supplies Prepaid expense 503 505 510 511 Security deposit Land Buildings Accumulated depreciation-buildings Barge Accumulated depreciation-barge Trucks Accumulated Depreciation-trucks Tools Customer Deposits Accounts payable 512 520 530 531 532 533 534 535 537 600 601 Wages payable FICA and Medicare payable Payroll tax withholdings State sales tax payable Federal Income taxes payable Estimated liabilities Accrued interest payable Deferred revenue Gift Certificate Liability Notes payable Mortgage payable Installment contracts payable Deferred sport rental Common stock Paid in excess of par Retained Earnings Dividends declared Prior Period Adjustment Pier and Lift Sales Pier and lift installation labor Custom Dock Sales Seawal installations Sports equipment sales Sports equipment rental revenue Permit fee revenue Interest revenue Gain/Loss on sale of fixed assets Unrealized gain loss marketable investments 602 603 604 605 606 607 608 6091 6092 610 611 612 813 700 701 702 703 704 101 102 103 104 105 106 107 108 110 111 Cost of sales-piers and lifts Dock parts costs