Client Trust Bank Reconcilliation + Ledger

[rsikin]

Hello

I am creating a spreadsheet for users that are not very familiar wit
excel. I need to create a list of transactions that will feed into
monthly bank reconcilliation form. Also I would need at least tw
reports 1. client name 2. total activity.

the bank reconcilliation should have an option for cleared checks b
the bank and receipts not deposited.

Below is the bank reconcilliation

Balance in Book of 34,805.18 Balance on Statement 34,373.18

Cash Receipts:
Outstanding Checks Formula Outstanding Deposits
Formula
Deposits Formula
Electronic Deposits 0.00
Miscellaneous 0.00

Cash Disbursements
Bank Charges 0.00
Check Order Fees 0.00
Cash Disbursements Formula
Miscellaneous Formula

Balance in Book 34,805.18 Adj Bank Balance 34,373.18

This is the transaction list

Date Check Number Case Name Client Name Amount
04/09/01 Aguilar v. Viva Mexico Alicia Caballero 997.61
05/11/01 Aguilar v. Viva Mexico Alicia Caballero 1,140.88
06/11/01 Aguilar v. Viva Mexico Alicia Caballero 1,114.18
07/09/01 Aguilar v. Viva Mexico Alicia Caballero 2,207.26
09/18/01 Aguilar v. Viva Mexico Alicia Caballero 1,104.63
08/09/04 Aguilar v. Viva Mexico Alicia Caballero 1,110.28
10/05/04 1001 Aguilar v. Viva Mexico Robert Sikin (500.00)
10/04/04 Aguilar v. Viva Mexico Robert Sikin 600.00
10/05/04 Mondavi Robert Sikin 50.00
10/04/04 Mondavi Robert Sikin 75.00
02/26/99 Dun-Rite Gustav
Cuevas 217.05
10/05/04 1002 Dun-Rite Joe Smith
(200.00)
12/12/02 Mondavi J orge De Haro 49.32


Every month there will be additional transactions. I am not sure
pivot table will work.

Any suggestions.
Thanks
Rober