Import & reconcile the register
The Municipal Tax Payments tab contains 196 checks totaling $376,446.31 across 190 closing files. Six closing files have two checks each — both are preserved. The original Check Number is the unique import key; Title is the closing file number (the CRM reference number).
Checks imported
196
expected 196
Total amount
$376,446.31
expected $376,446.31
Closing files
190
expected 190
Doubled files
6
expected 6
Sample imported checks
| Check # | Closing file (Title) | Municipality | Check date | Original amount | Source row |
|---|---|---|---|---|---|
| 1000 | CP-2024-0001 | City of Yonkers | 2024-02-02 | $2,870.50 | 1 |
| 1001 | CP-2024-0002 | Town of Ramapo | 2024-03-03 | $3,000.91 | 2 |
| 1002 | CP-2024-0003 | Town of Orangetown | 2024-04-04 | $2,121.33 | 3 |
| 1003 | CP-2024-0004 | City of New Rochelle | 2024-05-05 | $2,404.83 | 4 |
| 1004 | CP-2024-0005 | Town of Greenburgh | 2024-06-06 | $2,056.69 | 5 |
| 1005 | CP-2024-0006 | Village of Suffern | 2024-07-07 | $1,377.21 | 6 |
| 1006 | CP-2024-0007 | Town of Haverstraw | 2024-08-08 | $831.96 | 7 |
| 1007 | CP-2024-0008 | City of White Plains | 2024-09-09 | $1,062.82 | 8 |
Showing 8 of 196 checks.
Closing files with two checks (both preserved)
CP-2024-0012 · 2 checksCP-2024-0047 · 2 checksCP-2024-0088 · 2 checksCP-2024-0121 · 2 checksCP-2024-0156 · 2 checksCP-2024-0183 · 2 checks