EZ Accounts Payable Audit

EZ Accounts Payable Audit^SM

Example of a Type2 Report

This is an example of the type2 reports. All the other reports, credits, voids, and not used

files are in the same formats. The two separate files (text & delimited) are shown together on

this page for your convenience. They will be separate reports when they are sent to you.

This page shows an example of how credits are shown with the duplicate payment.

These are actual records from a client with the vendor names altered.

************************************************************************************************************************************************

YOUR COMPANY NAME HERE

TYPE2 MATCHES: INV NUMBER - INV AMOUNT - INV DATE

VENDOR ID      INV NBR                          INV AMT INV DATE   VNDR NAME                      CK NBR     CHECK DATE   CHECK AMOUNT VOUCHER

-------------- ------------------------- -------------- ---------- ------------------------------ ---------- ---------- -------------- -------

3916           GK-052300007                      624.00 2005-06-06 AAAAAAAAAA & FFF PPPP INC      5054341    2005-06-20         624.00 16021   *

2156           GK-052300007                      624.00 2005-06-06 MMM SSSSSSSS NNNNNNN INC       5057860    2005-07-04         624.00 16160   *

3916           GK-052300007 CR                  -624.00 2005-06-06 AAAAAAAAAA & FFF PPPP INC      5057730    2005-07-04        -624.00 16166   *

3022           396890 RI                       29079.06 2006-10-04 DDDDDDDDDD PPPP CORP           5135971    2006-11-13       29079.06 20545   *

2818           396890 RI                       29079.06 2006-10-04 DDDDDDDDDD HHHHHHH INC         5133827    2006-10-30       29079.06 20401   *

3609           DMX 385089                       9405.22 2006-04-11 DDDDDDDD CORP                  5110824    2006-05-15        9405.22 18983   *

3022           DMX 385089                       9405.22 2006-04-11 DDDDDDDDDD PPPP CORP           5109832    2006-05-08        9405.22 18745   *

3979           121372                          21979.64 2006-11-16 KKK CCCCCCC SSSSSSS            5137665    2006-12-04       21979.64 20767   *

1658           121372                          21979.64 2006-11-16 MMMMMM DDDDDDDDD SSSSSSSS INC  5138442    2006-12-11       21979.64 20664   *

"VENDOR ID","INV NBR","INV AMT","INV DATE","VNDR NAME","CK NBR","CHECK DATE","CHECK AMOUNT","VOUCHER"

"3916","GK-052300007","624.00","2005-06-06","AAAAAAAAAA & FFF PPPP INC","5054341","2005-06-20","624.00","16021"

"2156","GK-052300007","624.00","2005-06-06","MMM SSSSSSSS NNNNNNN INC","5057860","2005-07-04","624.00","16160"

"3916","GK-052300007 CR","-624.00","2005-06-06","AAAAAAAAAA & FFF PPPP INC","5057730","2005-07-04","-624.00","16166"

"3022","396890 RI","29079.06","2006-10-04","DDDDDDDDDD PPPP CORP","5135971","2006-11-13","29079.06","20545"

"2818","396890 RI","29079.06","2006-10-04","DDDDDDDDDD HHHHHHH INC","5133827","2006-10-30","29079.06","20401"

"3609","DMX 385089","9405.22","2006-04-11","DDDDDDDD CORP","5110824","2006-05-15","9405.22","18983"

"3022","DMX 385089","9405.22","2006-04-11","DDDDDDDDDD PPPP CORP","5109832","2006-05-08","9405.22","18745"

"3979","121372","21979.64","2006-11-16","KKK CCCCCCC SSSSSSS","5137665","2006-12-04","21979.64","20767"

"1658","121372","21979.64","2006-11-16","MMMMMM DDDDDDDDD SSSSSSSS INC","5138442","2006-12-11","21979.64","20664"

Home