MCTA Treasurer’s Manual

Sample Reconciliation Sheet

    First
Checking 		Second
Checking 		Tax
Collector's
Lockbox 		First
Investment 		Second
Investment
Third
Investment 		Total
RW1. Beginning Balance $ 15,936.91 $ 12,519.10 $ 65,298.25 $ 103,995.15 $ 204,635.80 $ 600,000.00 $ 1,002,385.21
               
RW 2. a. Deposits     $ 518,638.96 $ 129,700.12   $ 52,838.00 $ 701,177.08
RW 2. b. Interest earned       $ 639.14 $ 1,542.42 $ 3,965.38 $ 6,146.94
               
RW 3. a. Payments $ (416,005.25) $ (49,552.98)         $ (465,558.23)
RW 3. b. Other Charges $ (34.67)   $ (15.00) $ (1.00)     $ (50.67)
               
RW 4. Transfers $ 106,156.91 $ 40,000.00   $ 200,000.00   $ 250,000.00 $ 596,156.91
In $ 155,000.00         $ 300,000.00 $ 455,000.00
  $ 204,969.50           $ 204,969.50
               
RW 5. Transfers     $ (250,000.00) $ (40,000.00)   $ (200,000.00) $ (490,000.00)
Out     $ (300,000.00) $ (155,000.00)   $ (106,156.91) $ (561,156.91)
        $ (125,000.00)   $ (204,969.50) $ (329,969.50)
               
RW 6. Ending Balance $ 66,023.40 $ 2,966.12 $ 33,922.21 $ 114,333.41 $ 206,178.22 $ 695,676.97 $ 1,119,100.33
               
RW 7. a. Less Checks $ (59,888.25) $ (18,425.50)         $ (78,313.75)
Outstanding              
               
RW 7. b. Less interest recorded in CB next month     $ (639.14) $ (1,542.42) $ (3,965.38) $ (6,146.94)
Add bank charges in error $ 34.67   $ 15.00 $ 1.00     $ 50.67
RW 7. c. Add Deposits in Transit     $ 19,545.09     $ 125,000.00 $ 144,545.09
RW 8. Ending Reconciled Balance $ 6,169.82 $ (15,489.38) $ 53,482.30 $ 113,695.27 $ 204,635.80 $ 816,711.59 $ 1,179,235.40
  Plus cash on hand             $ 14,951.50
  Accountant's ledger balance             $ 1,194,186.90

Table of Contents | Forward | Contributor’s List | Chapter 1 | Chapter 2 | Chapter 3 | Chapter 4 | Chapter 5 | Chapter 6 | Chapter 7 | Chapter 8 | Chapter 9 | Chapter 10 | Chapter 11 | Chapter 12 | Appendix