Bank Reconciliation AssignmentState Bank of Anytown

$500$ Main Ave

Anytown AS $12345$

Statement of Account for:

Walden$-$Martin Family Medical Clinic

$1234$ AnyStreet

Anytown, AS $12345$

Date: $11-30-17$

Account number: $76-375-238$

Deposits:

Checks drawn on account:State Bank of Anytown

$500$ Main Ave

Anytown AS $12345$

Statement of Account for:

Walden$-$Martin Family Medical Clinic

$1234$ AnyStreet

Anytown, AS $12345$

Date: $11-30-17$

Account number: $76-375-238$

Deposits:

Checks drawn on account:$\backslash$table$[[$Check Register$],[$Number$,$Date,Description,Payment$/$debit$,$Ref,Deposit$/$credit$,$Balance$],[9703\mathrm{.}63],[18270,10/19/$xx$,$Harmon Medical,$3465\mathrm{.}46,x,,6238\mathrm{.}17],[18271,10/22/$xx$,$Acme Rental,$789\mathrm{.}00,x,,5449\mathrm{.}17],[18272,\frac{10}{22}\frac{?}{?},$Custodial Suppliers,$46\mathrm{.}72,x,,5402\mathrm{.}45],[18273,10/24/$xx$,$Taylor Hudson,$50\mathrm{.}00,x,,5352\mathrm{.}45],[18274,10/24/$xx$,$Bob Smith,$340\mathrm{.}00,x,,5012\mathrm{.}45],[18275,\frac{10}{25}\frac{?}{?},$Timothy Marks,$493\mathrm{.}47,,,4518\mathrm{.}98],[18276,10/25/$xx$,$GM Supply,$50\mathrm{.}00,,,4468\mathrm{.}98],[18277,\frac{10}{30}\frac{?}{?},$Hearty Bakery,$37\mathrm{.}50,,,4431\mathrm{.}48],[18278,\frac{10}{31}\frac{?}{?},$Palm Tree Inn,$395\mathrm{.}00,,,4036\mathrm{.}48],[18279,\frac{11}{1}\frac{?}{?},$Lincoln Mutual,$500\mathrm{.}00,,,3536\mathrm{.}48],[11/5/$xx$,$deposit,,,$2305\mathrm{.}46,5841\mathrm{.}94],[18280,\frac{11}{5}\frac{?}{?},$BAP Printing,$40\mathrm{.}00,,,5801\mathrm{.}94],[18281,11/5/$xx$,$NT Phone Services,$120\mathrm{.}00,,,5681\mathrm{.}94],[18282,11/5/$xx$,$Custodial Suppliers,$324\mathrm{.}52,,,5357\mathrm{.}42],[18283,\frac{11}{5}\frac{?}{?},$Office Suppliers Inc,$35\mathrm{.}50,,,5321\mathrm{.}92],[18284,11/6/$xx$,$Electric Co$-$op$,335\mathrm{.}00,,,4986\mathrm{.}92],[18285,\frac{11}{7}\frac{?}{?},$Harmon Medical,$890\mathrm{.}56,,,4096\mathrm{.}36],[\frac{11}{8}\frac{?}{?},$deposit,,,$456\mathrm{.}38,4552\mathrm{.}74],[\frac{11}{9}\frac{?}{?},$deposit,,,$235\mathrm{.}90,4788\mathrm{.}64],[18286,\frac{11}{12}\frac{?}{?},$TMI Leasing,$1500\mathrm{.}00,,,3288\mathrm{.}64],[18287,\frac{11}{12}\frac{?}{?},$Mary Sanchez,$573\mathrm{.}00,,,2715\mathrm{.}64],[\frac{11}{15}\frac{?}{?},$deposit,,,$4038\mathrm{.}98,6754\mathrm{.}62],[18288,\frac{11}{15}\frac{?}{?},$French Pharmaceuticals,$234\mathrm{.}34,,,6520\mathrm{.}28],[18289,\frac{11}{15}\frac{?}{?},$Goodwin Oil,$470\mathrm{.}00,,,6050\mathrm{.}28],[18290,\frac{11}{17}\frac{?}{?},$Payroll Account,$3310\mathrm{.}00,,,2740\mathrm{.}28],[18291,\frac{11}{19}\frac{?}{?},$GM Supply,$500\mathrm{.}00,,,2240\mathrm{.}28],[18292,\frac{11}{20}\frac{?}{?},$Hearty Bakery,$39\mathrm{.}46,,,2200\mathrm{.}82],[\frac{11}{21}\frac{?}{?},$deposit,,,$2972\mathrm{.}00,5172\mathrm{.}82],[18293,\frac{11}{23}\frac{?}{?},$BAP Printin

Reconcile a bank account using the check register and bank statement attached to answer the following questions:

Ending balance per statement $$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

Plus deposits not included on statement $+\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

Subtotal $$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

Minus outstanding checks $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

Total $$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

Use the below procedure as a guide:

$$ Current month$$s bank statement

$$ Record of checks drawn or check register

$$ Calculator

$$ Pen$/$pencil

$1.$ All checks that have been paid by the bank should be checked on the record of checks drawn or the check register.

$2.$ Any charges applied to the account by the bank should be listed on the record$/$register and subtracted from the balance.

$3.$ Any interest deposits from the bank should be listed on the record$/$register and added to the balance.

$4.$ Take the ending monthly balance on the account and do the following$*$:

a$.$ Add any deposits made by the practice that are not included on the statement.

b$.$ Subtract any checks written by the practice that have not been paid by the bank.

c$.$ The total should then equal the ending balance in the record. If the total does not equal the balance in the record, you should look for errors in addition and subtraction when figuring the ending balance as well as any other errors that may be present in the record$/$register$.$State Bank of Anytown

$500$ Main Ave Anytown AS $12345$

Statement of Account for:

Walden$-$Martin Family Medical Clinic

$1234$ AnyStreet

Anytown, AS $12345$

Date: $11-30-17$

Account number: $76-375-238$

Previous Balance:

$5,012\mathrm{.}45$

Deposits$/$credits:

$10,347\mathrm{.}78$

Checks$/$debits:

$9,385\mathrm{.}13$

Service charges:

$0\mathrm{.}00$

Ending Balance:

$5,975\mathrm{.}10$

Deposits:

Date

$11-5$

$11-8$

$11-9$

$11-15$

$11-21$

$11-28$

Amount

$2,305\mathrm{.}46$

$456\mathrm{.}38$

$235\mathrm{.}90$

$4038\mathrm{.}98$

$2972\mathrm{.}00$

$339\mathrm{.}06$

Checks drawn on account:

Check No$.$

Date

Amount

Check No$.$

Date

Amount

$18275$

$11-1$

$493\mathrm{.}47$

$18285$

$11-16$

$890\mathrm{.}56$

$18276$

$11-2$