Could you help me with this bank reconciliation

These is the information given

This is the cash book

Check \# 306 is not our check Our policy is to charge the customer for any charges related to NSF checks The Deposit on Jun 16 was incorrectly recorded by the bank. The Deposit on Jun 23 was correctly recorded by the bank. We do not modify the original joumal entry. Bank Statement Ending balance per bank 115,909.80 \begin{tabular}{|l|l|l|} \hline Additions & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline Total & & \\ \hline \end{tabular} Ending Correct cash balance Ending Correct cash balance A Byte of Accounting General Journal Name Descrip \begin{tabular}{|r|r|r|l|l|r|r|} \hline 10 & Jun 16 & 1110 & Cash & Check Serv. Preformed & 7,750.00 & \\ \hline 10 & Jun 16 & 4100 & Computer \& Consulting R & Check Serv. Preformed & & 7,750.00 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 11 & Jun 16 & 1510 & Land & Byte Building & 21,000.00 & \\ \hline 11 & Jun 16 & 1411 & Building & Byte Building & 110,000.00 & \\ \hline 11 & Jun 16 & 1110 & Cash & Byte Building & & 13,100.00 \\ \hline 11 & Jun 16 & 2201 & Mortgage Payable & Byte Building & & 117,900.00 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 12 & Jun 17 & 1140 & Prepaid Rent & Check \#5006 & 10,000.00 & \\ \hline 12 & Jun 17 & 1110 & Cash & Check \#5006 & & 10,000.00 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 13 & Jun 17 & 5030 & Advertising Expense & Invoice Number 26354 & 375.00 & \\ \hline 13 & Jun 17 & 2101 & Accounts Payable & Invoice Number 26354 & & \\ \hline & & & & & & 375.00 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 14 & Jun 21 & 2101 & Accounts Payable & Check \#5007 & 560.00 & \\ \hline 14 & Jun 21 & 1110 & Cash & Check \#5007 & & 560.00 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 15 & Jun 21 & 1211 & Office Equip. & Check \#5008 & 700.00 & \\ \hline 15 & Jun 21 & 1110 & Cash & Check \#5008 & & 700.00 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 17 & Jun 22 & 5020 & Salary Expense & Check \#5009 & 860.00 & \\ \hline 17 & Jun 22 & 1110 & Cash & Check \#5009 & & 860.00 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 18 & Jun 22 & 5040 & Repairs \& Maint. Expense & Bill Comp. Parts and Repair Co. & 1,190.00 & \\ \hline 18 & Jun 22 & 2101 & Accounts Payable & Bill Comp. Parts and Repair Co. & & 1,190.00 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 19 & Jun 22 & 2101 & Accounts Payable & Check \#5010 & 375.00 & \\ \hline 19 & Jun 22 & 1110 & Cash & Check \#5010 & & 375.00 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 20 & Jun 23 & 1150 & Office Supplies & Invoice Number 65498 & 825.00 & \\ \hline 20 & Jun 23 & 2101 & Accounts Payable & Invoice Number 65498 & & 825.00 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 21 & Jun 23 & 1110 & Cash & Cash on Billing & 3,285.00 & \\ \hline 21 & Jun 23 & 1120 & Accounts Receivable & Cash on Billing & & 3,285.00 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 22 & Jun 28 & 1120 & Accounts Receivable & June 25th Billed Services & 5,700.00 & \\ \hline 22 & Jun 28 & 4100 & Computer \& Consulting R June 25th Billed Services & & 5,700.00 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 24 & Jun 29 & 1110 & Cash & June 29 Cash for Bills & 5,400.00 & \\ \hline 24 & Jun 29 & 1120 & Accounts Receivable & June 29 Cash for Bills & & 5,400.00 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 26 & Jun 30 & 5050 & Oil \& Gas Expense & Invoice Number 784537 & 1,015.00 & \\ \hline 26 & Jun 30 & 2101 & Accounts Payable & Invoice Number 784537 & & 1,015.00 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 27 & Jun 30 & 3300 & Dividends & Check \#5013 & 1,035.50 & \\ \hline 27 & Jun 30 & 1110 & Cash & Check \#5013 & & 1,035.50 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|l|l|} \hline 28 & Jun 30 & 3300 & Dividends & Check \#5014 & 480.70 & \\ \hline 28 & Jun 30 & 1110 & Cash & Check \#5014 & & 480.70 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|l|l|} \hline 29 & Jun 30 & 3300 & Dividends & Check \#5015 & 100.51 & \\ \hline 29 & Jun 30 & 1110 & Cash & Check \#5015 & & 100.51 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|l|l|} \hline 30 & Jun 30 & 5010 & Rent Expense & Rent / Prepaid Rent & 2,500.00 & \\ \hline 30 & Jun 30 & 1140 & Prepaid Rent & Rent / Prepaid Rent & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 31 & Jun 30 & 5080 & Supplies Expense & SuperRoutePro FIFO & 1,984.00 & \\ \hline 31 & Jun 30 & 1150 & Office Supplies & SuperRoutePro FIFO & & \\ \hline & & & & & & 1,984.00 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 32 & Jun 30 & 5090 & Interest Expense & Al Mortgage payable & 343.88 & \\ \hline 32 & Jun 30 & 2103 & Interest Payable & Al Mortgage payable & & 343.88 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 33 & Jun 30 & 5100 & Insurance Expense & Expired Half Month's Insurance & 242.00 & \\ \hline 33 & Jun 30 & 1130 & Prepaid Insurance & Expired Half Month's Insurance & & 242.00 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|c|c|} \hline 34 & Jun 30 & 1120 & Accounts Receivable & Byte's Job Unbilled Revenues & 18,750.00 & \\ \hline 34 & Jun 30 & 4100 & Computer \& Consulting R & Byte's Job Unbilled Revenues & & 18,750.00 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 35 & Jun 30 & 5110 & Depreciation Expense & Buil. \& Office Depreciation & 294.28 & \\ \hline 35 & Jun 30 & 1412 & Accum. Depr.-Building & Buil. \& Office Depreciation & & 272.49 \\ \hline 35 & Jun 30 & 1212 & Accum. Depr.-Office Equig Buil. \& Office Depreciation & & 21.79 \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|l|r|r|} \hline 36 & Jun 30 & 5110 & Depreciation Expense & Computer Equipment Depreciation & 7,667.33 & \\ \hline 36 & Jun 30 & 1312 & Accum. Depr.-Computer E & Computer Equipment Depreciation & & 7,667.33 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 38 & Jun 30 & 5090 & Interest Expense & Note pay. Royce Computer & 1,096.00 & \\ \hline 38 & Jun 30 & 2103 & Interest Payable & Note pay. Royce Computer & & 1,096.00 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 39 & Jun 30 & 5120 & Bad Debt Expense & CPA Computer \& Consulting Revenue & 1,089.00 & \\ \hline 39 & Jun 30 & 1121 & Allowance for Doubtful AC & CPA Computer \& Consulting Revenue & & 1,089.00 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 40 & Jun 30 & 1110 & Cash & Bank Reconciliation Increase & 500.00 & \\ \hline 40 & Jun 30 & 1120 & Accounts Receivable & Bank Reconciliation Increase & & 500.00 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 41 & Jun 30 & 1120 & Accounts Receivable & Bank Reconciliation Decrease & 2,870.00 & \\ \hline 41 & Jun 30 & 5140 & Telephone Expense & Bank Reconciliation Decrease & 195.00 & \\ \hline 41 & Jun 30 & 5130 & Bank Expense & Bank Reconciliation Decrease & 50.00 & \\ \hline 41 & Jun 30 & 1110 & Cash & Bank Reconciliation Decrease & & 3,115.00 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|r|r|} \hline 42 & Jun 30 & 5150 & Income Tax Expense & Income Taxes & 4,005.63 & \\ \hline 42 & Jun 30 & 2106 & Income Taxes Payable & Income Taxes & & 4,005.63 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|l|l|} \hline 43 & Jun 30 & 4100 & Computer \& Consulting Re & Closing Revenue & 36,300.00 & \\ \hline 43 & Jun 30 & 3400 & Income Summary & Closing Revenue & 36,300.00 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|l|l|} \hline 45 & Jun 30 & 3400 & Income Summary & Closing Income Summary & 12,016.88 & \\ \hline 45 & Jun 30 & 3200 & Retained Earnings & Closing Income Summary & & 12,016.88 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|l|l|l|l|} \hline 46 & Jun 30 & 3200 & Retained Earnings & Close Dividends & 1,616.71 & \\ \hline 46 & Jun 30 & 3300 & Dividends & Close Dividends & & 1,616.71 \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular}