Need help with this bank reconciliation...this is actually for a job and I am forgetting everything about accounting because I am nervous.

Question

BANK RECONCILATION
==============================================
On Aug 14th, One of our Partner's ( Compuville ) cash book showed a debit
balance of $4,000.00.
His bank statement showed a balance of $4,270.00.
On comparison the following were found:
* check issued amounting to $2,500.00 has not been cashed
* The bank rejected checks amounting to $140
* Standing order for a staples order of $700 was note noted.
* A customer paid $170 directly into the bank without any notice to Us
* Bank charges of $160 were entered in the bank statements only.
* A dividend of $250 was paid directly into the bank and not recorded in the
cash
book
* Checks for $1,650.00 were entered into the cash book and deposited in the
bank
but had not been cleared (deposited).
Prepare a bank reconciliation statement for the month .



balance per bank statement
$ $
(Add )
uncredited
checks
standing order
bank charges
dishonored
checks
_____________________
(Less)
unpresented checks
dividend
credit
transfer

Answer 1

Bank Stmt Balance $4270.00
Add
Rejected Checks 140.00
Deposited Checks 1650.00
Ending Balance $6060.00

Book Balance $4000.00
Add
Checks Issued 2500.00
Cust Pd Direct 170.00
Dividend 250.00
Deduct
Staples Order -700.00
Bank Charges -160.00
Ending Balance $6060.00