I need help from someone who has knowledge of excel macros. I have project for an Accounting Information Systems class. Here are the instructions and attached excel workbook.

Create a new sheet and add the headings as shown (the date is a variable) In the General Ledger normal balances for accounts are shown as positive numbers. Create a macro, attached to two buttons, one on the top of the General Journal and the other on top of the Adjusting Journal, that:

1 Clears the General Ledger sheet below the headings

2 Save the file everytime the report is started, Last name date and time

3 Imports the General Journal and the Adjusting Journal entries

4 Sorts by account number and then by transaction number

5 Skips lines between each account and add the word Balance

6 Loop for all Accounts

7 Calculate and dispay a running balance and the ending balance of each account

8 Display the account balance of each account in "I"

9 If the balance ever goes negitive change the font to red

10 If the account?s balance is not its normal balance, see chart of accounts, add an error message.

Name Create a new sheet and add the headings as shown (the date is a variable) In the General Ledger normal balances for accounts are shown as positive numbers. Create a macro, attached to two buttons, one on the top of the General Journal and the other on top of th 1 Clears the General Ledger sheet below the headings 2 Save the file everytime the report is started, Last name date and time 3 Imports the General Journal and the Adjusting Journal entries 4 Sorts by account number and then by transaction number 5 Skips lines between each account and add the word Balance 6 Loop for all Accounts 7 Calculate and dispay a running balance and the ending balance of each account 8 Display the account balance of each account in "I" 9 If the balance ever goes negitive change the font to red 10 If the account's balance is not its normal balance, see chart of accounts, add an error messa A Byte of Accounting General Ledger For the Period Ending June 30 Date 6/1 6/1 6/1 6/2 6/10 6/14 6/16 6/16 6/17 6/21 6/21 6/22 6/22 6/23 6/29 6/29 6/29 6/30 Balance 6/21 6/23 6/28 6/29 Balance Transactio Account Name 1 1110 Cash 2 1110 Cash 3 1110 Cash 4 1110 Cash 7 1110 Cash 8 1110 Cash 9 1110 Cash 10 1110 Cash 11 1110 Cash 14 1110 Cash 15 1110 Cash 16 1110 Cash 18 1110 Cash 19 1110 Cash 22 1110 Cash 23 1110 Cash 24 1110 Cash 26 1110 Cash 1110 Cash 13 19 21 22 Description Debit Credit Balance Jeremy's Investment 22,260.00 22,260.00 Courtney's Investment 40,950.00 63,210.00 Mark's Investment 63,000.00 126,210.00 Computer Equip. 31,000.00 95,210.00 Computer Equip. 23,750.00 71,460.00 Insurance 6,312.00 65,148.00 Revenue 7,000.00 72,148.00 Housing Facility 13,700.00 58,448.00 Rent 4,800.00 53,648.00 Fax Machine 650.00 52,998.00 A/P 320.00 52,678.00 Newspaper Ad 275.00 52,403.00 Wages 1,010.00 51,393.00 Revenue 3,605.00 54,998.00 Revenue 5,400.00 60,398.00 Repairs 1,165.00 59,233.00 Wages 1,010.00 58,223.00 Dividends 1,535.39 56,687.61 1120 Accounts RRevenue 1120 Accounts RCollection 1120 Accounts RRevenue 1120 Accounts RCollection 1120 Accounts Receivable 4,500.00 4,750.00 5,700.00 5,650.00 4,500.00 (250.00) 5,450.00 (200.00) 6/4 6/8 6/17 6/21 6/22 Balance 5 6 12 15 16 2101 Accounts POffice Equip. 2101 Accounts POffice Equip. 2101 Accounts PNewspaper Ad 2101 Accounts PA/P 2101 Accounts PNewspaper Ad 2101 Accounts Payable 400.00 80.00 275.00 320.00 375.00 400.00 320.00 595.00 275.00 (100.00) urnal and the other on top of the Adjusting Journal, that: e of each account accounts, add an error message. ### (200.00) NOT A NORMAL BALANCE (100.00) NOT A NORMAL BALANCE Kareem Gay A Byte of Accounting General Ledger For the Reriod Ending June 30, 2016 ### Kareem Gay2016 12 Date Transaction Account Name Description unting ger g June 30, 2016 Debit Credit Balance Number Name 1110 Cash 1120 Accounts Receivable 1130 Prepaid Insurance 1140 Prepaid Rent 1150 Office Supplies 1211 Office Equip. 1212 Accum. Depr.-Office Equip. 1311 Computer Equip. 1312 Accum. Depr.-Computer Equip. 1411 Building Cost 1412 Accum. Depr.-Building 1510 Land 2101 Accounts Payable 2102 Advanced Payments 2103 Interest Payable 2105 Salaries Payable 2106 Income Taxes Payable 2201 Mortgage Payable 2202 Notes Payable 3100 Capital Stock 3200 Retained Earnings 3300 Dividends 3400 Income Summary 4100 Computer & Consulting Revenue 5010 Rent Expense 5020 Salary Expense 5030 Advertising Expense 5040 Repairs & Maint. Expense 5050 Oil & Gas Expense 5080 Supplies Expense 5090 Interest Expense 5100 Insurance Expense 5110 Depreciation Expense 5120 Income Tax Expense Normal Balance Debit Debit Debit Debit Debit Debit Credit Debit Credit Debit Credit Debit Credit Credit Credit Credit Credit Credit Credit Credit Credit Debit Credit Credit Debit Debit Debit Debit Debit Debit Debit Debit Debit Debit Error # 1 2 4 8 Message Debit and Credit on the Same Line Debits Before Credits Need an Account Number Round to Two Decimal Places Jan 01 Jan 01 01 01 1110 Cash 3100 Capital Stock Jeremy's Investment Jeremy's Investment 22,260.00 Jan 01 Jan 01 02 02 1110 Cash 3100 Capital Stock Courtney's Investment Courtney's Investment 40,950.00 Jan 01 Jan 01 03 03 1110 Cash 3100 Capital Stock Mark's Investment Mark's Investment 63,000.00 Jan 02 Jan 02 04 04 1311 Computer Equip. 1110 Cash Purchase Computer Equip. Purchase Computer Equip. 31,000.00 Jan 10 Jan 10 05 05 1311 Computer Equip. 1110 Cash Purchase Computer Equip. Purchase Computer Equip. 23,750.00 Jun 14 Jun 14 06 06 1130 Prepaid Insurance 1110 Cash Purchased Insurance Purchased Insurance 6,312.00 Jun 16 Jun 16 07 07 1110 Cash 4100 Computer & Consulting Received Consulting Revenue Received Consulting Revenue 7,000.00 Jun 16 Jun 16 08 08 5040 Repairs & Maint. Expense 1110 Cash Housing Facility Housing Facility Jun 17 Jun 17 09 09 5040 Repairs & Maint. Expense 1110 Cash Rent Payment Rent Payment Jun 21 Jun 21 10 10 1211 Office Equip. 1110 Cash Purchase Office Equipment Purchase Office Equipment 650.00 Jun 21 Jun 21 11 11 2101 Accounts Payable 1110 Cash Payment on AP Payment on AP 320.00 Jun 22 Jun 22 12 12 5030 Advertising Expense 1110 Cash Newspaper Ad Newspaper Ad 275.00 Jun 22 Jun 22 13 13 5020 Salary Expense 1110 Cash Pay Wages Pay Wages 1,010.00 Jun 23 Jun 23 14 14 1110 Cash 4100 Computer & Consulting Received Consulting Revenue Received Consulting Revenue 3,605.00 Jun 29 Jun 29 15 15 1110 Cash 4100 Computer & Consulting Received Consulting Revenue Received Consulting Revenue 5,400.00 Jun 29 Jun 29 16 16 5040 Repairs & Maint. Expense 1110 Cash Pay for Repairs Pay for Repairs 1,165.00 Jun 29 Jun 29 17 17 5020 Salary Expense 1110 Cash Pay Salaries Pay Salaries 1,010.00 Jun 30 Jun 30 18 18 3300 Dividends 2102 Advanced Payments Paid Dividends Paid Dividends 1,535.39 Jun 30 Jun 30 19 19 2102 Advanced Payments 1110 Cash Paid Dividends Paid Dividends 1,535.39 Jun 21 Jun 21 20 20 1120 Accounts Receivable 4100 Computer & Consulting Service performed on credit Service performed on credit 4,500.00 Jun 23 Jun 23 21 21 1110 Cash 1120 Accounts Receivable Collected payment on Account Collected payment on Account 4,750.00 22,260.00 40,950.00 63,000.00 31,000.00 23,750.00 6,312.00 7,000.00 13,700.00 13,700.00 4,800.00 4,800.00 650.00 320.00 275.00 1,010.00 3,605.00 5,400.00 1,165.00 1,010.00 1,535.39 1,535.39 4,500.00 4,750.00 22,260.00 (22,260.00) 40,950.00 (40,950.00) 63,000.00 (63,000.00) 31,000.00 (31,000.00) 23,750.00 (23,750.00) 6,312.00 (6,312.00) 7,000.00 (7,000.00) 13,700.00 (13,700.00) 4,800.00 (4,800.00) 650.00 (650.00) 320.00 (320.00) 275.00 (275.00) 1,010.00 (1,010.00) 3,605.00 (3,605.00) 5,400.00 (5,400.00) 1,165.00 (1,165.00) 1,010.00 (1,010.00) 1,535.39 (1,535.39) 1,535.39 (1,535.39) 4,500.00 (4,500.00) 4,750.00 (4,750.00) Ba la nc e To ta l Ba la nc e re di t C Description eb it Name D Ac co un t ns ac tio n Tr a D at e General Journal 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Jun 28 Jun 28 22 22 1120 Accounts Receivable 4100 Computer & Consulting Service performed on credit Service performed on credit 5,700.00 Jun 29 Jun 29 23 23 1110 Cash 1120 Accounts Receivable Collected payment on Account Collected payment on Account 5,650.00 Jun 04 Jun 04 24 24 1211 Office Equip. 2101 Accounts Payable Office Equip. on credit Office Equip. on credit Jun 08 Jun 08 25 25 2101 Accounts Payable 1110 Cash Payment on AP Account Payment on AP Account 80.00 Jun 17 Jun 17 26 26 5030 Advertising Expense 2101 Accounts Payable Advertising on Account Advertising on Account 275.00 Jun 21 Jun 21 27 27 2101 Accounts Payable 1110 Cash Payment on AP Account Payment on AP Account 320.00 Jun 30 Jun 30 28 28 2101 Accounts Payable 1110 Cash Payment on Adver. Account Payment on Adver. Account 375.00 5,700.00 5,650.00 400.00 400.00 80.00 275.00 320.00 375.00 5,700.00 (5,700.00) 5,650.00 (5,650.00) 400.00 (400.00) 80.00 (80.00) 275.00 (275.00) 320.00 (320.00) 375.00 (375.00) - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Jun 30 Jun 30 101 101 3300 Dividends 1110 Cash Paid Cash Dividend to Shareholders Paid Cash Dividend to Shareholders 1,401.60 Jun 30 Jun 30 102 102 5010 Rent Expense 1140 Prepaid Rent Rent for June Rent for June 1,700.00 Jun 30 Jun 30 103 103 5080 Supplies Expense 1150 Office Supplies Office Supplies Remaining Office Supplies Remaining 330.00 Jun 30 Jun 30 104 104 5090 Interest Expense 2103 Interest Payable Interest on Mortgage Interest on Mortgage 339.00 Jun 30 Jun 30 105 105 5100 Insurance Expense 1130 Prepaid Insurance Half of June's Insurance Half of June's Insurance 270.00 Jun 30 Jun 30 106 106 1120 Accounts Receivable 4100 Computer & Consulting Unbilled Revenues Unbilled Revenues Jun 30 Jun 30 Jun 30 Jun 30 107 107 107 107 5110 Depreciation Expense Depreciation for June 1412 Accum. Depr.-Building Depreciation for June 1312 Accum. Depr.-Computer EDepreciation for June 1212 Accum. Depr.-Office EquipDepreciation for June Jun 30 Jun 30 108 108 5020 Salary Expense 2105 Salaries Payable Unpaid Salaries Owed Unpaid Salaries Owed Jun 30 Jun 30 109 109 5090 Interest Expense 2103 Interest Payable Interest on Five Year Note Interest on Five Year Note 1,128.33 Jun 30 Jun 30 110 110 5120 Income Tax Expense 2106 Income Taxes Payable Income Taxes Income Taxes 2,247.04 1,401.60 1,700.00 330.00 339.00 270.00 5,000.00 5,000.00 3,888.50 231.48 3,637.67 19.35 516.00 516.00 1,128.33 2,247.04 1,401.60 (1,401.60) 1,700.00 (1,700.00) 330.00 (330.00) 339.00 (339.00) 270.00 (270.00) 5,000.00 (5,000.00) 3,888.50 (231.48) (3,637.67) (19.35) 516.00 (516.00) 1,128.33 (1,128.33) 2,247.04 (2,247.04) - Ba la nc e To ta l Ba la nc e re di t C Description eb it Name D Ac co un t ns ac tio n Tr a D at e A Byte of Accounting, Inc. Adjusting Journal 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Byte of Accounting Trial Balance As of June 30, 2016 1110 Cash 1120 Accounts Receivable 1130 Prepaid Insurance 1140 Prepaid Rent 1150 Office Supplies 1211 Office Equip. 1212 Accum. Depr.-Office Equip. 1311 Computer Equip. 1312 Accum. Depr.-Computer Equip. 1411 Building Cost 1412 Accum. Depr.-Building 1510 Land 2101 Accounts Payable 2102 Advanced Payments 2103 Interest Payable 2105 Salaries Payable 2106 Income Taxes Payable 2201 Mortgage Payable 2202 Notes Payable 3100 Capital Stock 3200 Retained Earnings 3300 Dividends 3400 Income Summary 4100 Computer & Consulting Revenue 5010 Rent Expense 5020 Salary Expense 5030 Advertising Expense 5040 Repairs & Maint. Expense 5050 Oil & Gas Expense 5080 Supplies Expense 5090 Interest Expense 5100 Insurance Expense 5110 Depreciation Expense 5120 Income Tax Expense Total Debit Credit TB_Balance 66,312.61 66,312.61 200.00 (200.00) 6,312.00 6,312.00 1,050.00 1,050.00 54,750.00 54,750.00 420.00 420.00 126,210.00 (126,210.00) 1,535.39 1,535.39 26,205.00 (26,205.00) 2,020.00 2,020.00 550.00 550.00 19,665.00 19,665.00 152,615.00 152,615.00 1.00 Byte of Accounting Worksheet As of June 30, 2016 Trial Balance 1110 Cash 1120 Accounts Receivable 1130 Prepaid Insurance 1140 Prepaid Rent 1150 Office Supplies 1211 Office Equip. 1212 Accum. Depr.-Office Equip. 1311 Computer Equip. 1312 Accum. Depr.-Computer Equip. 1411 Building Cost 1412 Accum. Depr.-Building 1510 Land 2101 Accounts Payable 2102 Advanced Payments 2103 Interest Payable 2105 Salaries Payable 2106 Income Taxes Payable 2201 Mortgage Payable 2202 Notes Payable 3100 Capital Stock 3200 Retained Earnings 3300 Dividends 3400 Income Summary 4100 Computer & Consulting Revenue 5010 Rent Expense 5020 Salary Expense 5030 Advertising Expense 5040 Repairs & Maint. Expense 5050 Oil & Gas Expense 5080 Supplies Expense 5090 Interest Expense 5100 Insurance Expense 5110 Depreciation Expense 5120 Income Tax Expense Total Net Income Balance Adjusting Entries Adjusted Trial Balance Debit Credit Debit Credit Debit 66,312.61 1,401.60 64,911.01 200.00 5,000.00 4,800.00 6,312.00 270.00 6,042.00 1,700.00 330.00 1,050.00 1,050.00 19.35 54,750.00 54,750.00 3,637.67 231.48 420.00 420.00 1,467.33 516.00 2,247.04 126,210.00 1,535.39 1,401.60 26,205.00 2,020.00 550.00 19,665.00 152,615.00 152,615.00 2,936.99 5,000.00 1,700.00 516.00 1,700.00 2,536.00 550.00 19,665.00 330.00 1,467.33 270.00 3,888.50 2,247.04 16,820.47 330.00 1,467.33 270.00 3,888.50 2,247.04 167,563.87 16,820.47 Adjusted Trial Balance Credit Income Statement Debit Credit 1,700.00 330.00 19.35 3,637.67 231.48 1,467.33 516.00 2,247.04 126,210.00 31,205.00 31,205.00 1,700.00 2,536.00 550.00 19,665.00 167,563.87 330.00 1,467.33 270.00 3,888.50 2,247.04 32,653.87 32,653.87 31,205.00 1,448.87 32,653.87 Balance Sheet Debit Credit TB_Balance ADJ_Balanc 64,911.01 66,312.61 (1,401.60) 4,800.00 (200.00) 5,000.00 6,042.00 6,312.00 (270.00) 1,700.00 (1,700.00) 330.00 (330.00) 1,050.00 1,050.00 19.35 (19.35) 54,750.00 54,750.00 3,637.67 (3,637.67) 231.48 (231.48) 420.00 420.00 1,467.33 (1,467.33) 516.00 (516.00) 2,247.04 (2,247.04) 126,210.00 (126,210.00) 2,936.99 1,535.39 1,401.60 (26,205.00) (5,000.00) 1,700.00 2,020.00 516.00 550.00 19,665.00 330.00 1,467.33 270.00 3,888.50 2,247.04 134,910.00 136,358.87 1,448.87 136,358.87 136,358.87 Worksheet_Balance 64,911.01 4,800.00 6,042.00 (1,700.00) (330.00) 1,050.00 (19.35) 54,750.00 (3,637.67) (231.48) 420.00 (1,467.33) (516.00) (2,247.04) (126,210.00) 2,936.99 (31,205.00) 1,700.00 2,536.00 550.00 19,665.00 330.00 1,467.33 270.00 3,888.50 2,247.04 - Byte of Accounting Worksheet As of June 30, 2016 1110 Cash 1120 Accounts Receivable 1130 Prepaid Insurance 1140 Prepaid Rent 1150 Office Supplies 1211 Office Equip. 1212 Accum. Depr.-Office Equip. 1311 Computer Equip. 1312 Accum. Depr.-Computer Equip. 1411 Building Cost 1412 Accum. Depr.-Building 1510 Land 2101 Accounts Payable 2102 Advanced Payments 2103 Interest Payable 2105 Salaries Payable 2106 Income Taxes Payable 2201 Mortgage Payable 2202 Notes Payable 3100 Capital Stock 3200 Retained Earnings 3300 Dividends 3400 Income Summary 4100 Computer & Consulting Revenue 5010 Rent Expense 5020 Salary Expense 5030 Advertising Expense 5040 Repairs & Maint. Expense 5050 Oil & Gas Expense 5080 Supplies Expense 5090 Interest Expense 5100 Insurance Expense 5110 Depreciation Expense 5120 Income Tax Expense Total Net Income Balance 64,911.01 4,800.00 6,042.00 (1,700.00) (330.00) 1,050.00 (19.35) 54,750.00 (3,637.67) (231.48) 420.00 (1,467.33) (516.00) (2,247.04) (126,210.00) 2,936.99 (31,205.00) 1,700.00 2,536.00 550.00 19,665.00 330.00 1,467.33 270.00 3,888.50 2,247.04 64,911.01 4,800.00 6,042.00 (1,700.00) (330.00) 1,050.00 19.35 54,750.00 3,637.67 231.48 (420.00) 1,467.33 516.00 2,247.04 126,210.00 2,936.99 31,205.00 1,700.00 2,536.00 550.00 19,665.00 330.00 1,467.33 270.00 3,888.50 2,247.04 Byte of Accounting Income Statement For the Reriod Ending June 30, 2016 Revenue: 4100 Computer & Consulting Revenue $ 31,205.00 Expenses: 5010 Rent Expense 5020 Salary Expense 5030 Advertising Expense 5040 Repairs & Maint. Expense 5050 Oil & Gas Expense 5080 Supplies Expense 5090 Interest Expense 5100 Insurance Expense 5110 Depreciation Expense Total Expenses $ 30,406.83 Operating Income 5120 Income Tax Expense Net Income After Taxes: 1,700.00 2,536.00 550.00 19,665.00 330.00 1,467.33 270.00 3,888.50 $ 40% 798.17 319.27 $ 478.90