You are the accountant for Georgia Company, and you have recently received the bank statement for your company's account and need to reconcile it with your general ledger cash account. Georgia's records show an ending balance for the month of $$12,782,40$ while the bank's records show an ending balance of $$12,576\mathrm{.}86.$ The bank charged $$7\mathrm{.}60$ in service fees and paid $$26\mathrm{.}35$ in interest.

All but three checks written during the month were processed by the bank without incident during the month. The three exceptions were:

Check #$841$ was correctly processed by the bank as $$941\mathrm{.}27$ but was mistakenly recorded by you as $$841\mathrm{.}27.$

Check #$853$ for $$65\mathrm{.}57$ had not yet been processed by the bank.

Check #$855$ for $$743\mathrm{.}46$ had not yet been processed by the bank.

All but two of the deposits made during the month were processed by the bank without incident. The two exceptions were:

A customer check for $$312\mathrm{.}95,$ which had been deposited during the month, was returned NSF$.$

A deposit totaling $$620\mathrm{.}37$ had not yet been processed by the bank.

Required:

Using the information provided above, prepare a bank reconciliation. $($Round your answers to $2$ decimal places.$)$

$\backslash$table$[[$Bank Reconciliation,,,,$],[$Ending Cash Balance per Bank Statement,,,Updates to Company's Books$],[$Additions:$,,$Ending Cash Balance per Books,,,$],[,,$Additions:,,,$],[,,,,,],[,,,,,],[$Deductions:$,,,,,],[,,,,,]]$