Account Reconciliation Program

 

 

Invoice Reconciliation Report

Matched Invoices Open Only

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
640.72

6725
6601

02/18/2000
01/21/2000

675.57

-300.00

0548224
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