1. create a charts of accounts table and create a transactions table

TX ID TX Pd TXYr TX AcctID TX DrAmt TX CrAmt TX Description TX Acct Desc TX_Acct_Type 101 100,000.00 Initial Cash In 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 100,000.00 Initial Cash In Paid In Capital 210 101 200,000.00 180 200,000.00 101 500 7,000.00 5005,000.00 200,000.00 Secure Loan Notes Payable Equipment Salaries Expense Secure Loan Purchase Equipment 200,000.00 Purchase Equipment 4 4 4 Clate Salary Nurse Salary Expense Salaries Expense Rent Expense Office Expense Expense 12,000.00 Payroll 560 5,000.00 Rent Expense 5,000.00 Rent 6 570 4,000.00 Office Supplies Expense 4,000.00 Office Supplies 620 1,000.00 210 20,000.00 101 Interest Payment Principle Payment Interest Expense Notes Payable Expense 21,000.00 Loan Payment 100,000.00 Patient Charge Revenue Patient Revenue Contractual Discounts Revenue Contractual Discounts Cash Collections Receivables Recognition Equipment Depreciation 415 65,000.00 101 10,000.00 120 25,000.00 750 4,000.00 185 500 7,000.00 00 5,000.00 101 560 5,000.00 101 Revenue Accounts Receivable Depreciation Expense Accumulated Depreciation Salaries Expense Salaries Expense Expense Asset Expense 4,000.00 Equipment Depreciation Clate Salary Nurse Salary 12,000.00 Payroll Rent Expense Expense 5,000.00 Rent