Account Reconciliation Program
Customer Name:
ABC Company
Acct# 201256398
|
|
Invocie # |
Date |
Billed Amount |
Chk Amount |
Check# |
Check Date |
Amount |
Open Items |
Cust Invoices |
Type |
|
OPEN |
533305 |
07/12/1999 |
416.23 |
|
|
|
0.00 |
416.23 |
|
IN |
|
OPEN |
535590 |
07/28/1999 |
342.40 |
|
|
|
0.00 |
342.40 |
|
IN |
|
OPEN |
536102 |
08/05/1999 |
436.56 |
0.00 |
6601 |
01/21/2000 |
0.00 |
436.56 |
536102 |
IN |
|
OPEN |
536697 |
08/05/1999 |
575.66 |
|
|
|
0.00 |
575.66 |
|
IN |
|
OPEN |
539293 |
08/24/1999 |
575.66 |
|
|
|
0.00 |
575.66 |
|
IN |
|
OPEN |
542441 |
09/20/1999 |
340.26 |
|
|
|
0.00 |
340.26 |
|
IN |
|
OPEN |
542516 |
09/20/1999 |
340.26 |
|
|
|
0.00 |
340.26 |
|
IN |
|
OPEN |
545024 |
10/22/1999 |
38.52 |
0.00 |
2640 |
01/21/2000 |
0.00 |
38.52 |
545024 |
IN |
|
OPEN |
545025 |
10/25/1999 |
1272.23 |
0.00 |
2640 |
01/21/2000 |
0.00 |
1272.23 |
545025 |
IN |
|
CRED |
548224 |
11/05/1999 |
375.57 |
34.85 |
6725 |
02/18/2000 |
675.57 |
-300.00 |
0548224 |
IN |
|
OPEN |
550817 |
12/02/1999 |
340.26 |
|
|
|
0.00 |
340.26 |
|
IN |
|
OPEN |
553014 |
01/17/2000 |
1025.00 |
|
|
|
0.00 |
1025.00 |
|
IN |
|
OPEN |
553409 |
02/24/2000 |
747.93 |
|
|
|
0.00 |
747.93 |
|
IN |
|
OPEN |
553937 |
12/29/1999 |
376.64 |
0.00 |
2640 |
01/21/2000 |
0.00 |
376.64 |
553937 |
IN |
|
OPEN |
553990 |
12/29/1999 |
233.26 |
0.00 |
6601 |
01/21/2000 |
0.00 |
233.26 |
553990 |
IN |
|
OPEN |
556754 |
01/25/2000 |
200.09 |
|
|
|
0.00 |
200.09 |
|
IN |
|
OPEN |
571991 |
05/09/2000 |
194.74 |
|
|
|
0.00 |
194.74 |
|
IN |
|
|
|
|
7831.57 |
|
|
|
|
5231.64 |
2599.93 |
|
Prepared by:
PRO Consulting Services, Inc. (Confidential)
Printed:
October 04, 2001 @ 03:30 PM
Refernce:
51001000
Our reconciliation program was developed to assist clients in resolving disputed accounts with possible payment application problems. We have completely automated the process of matching invoices with payments received in order to illustrate where the customer's money was applied and what invoices are outstanding. Above is an example of what one of our reports looks like.
PRO Consulting Services has won high praise from our clients' who have needed one-time customized reports. Based on our client’s specifications our IT department can build the query, extract and format the data and generate the ad hoc report