Trying to match multiple bills to checks issued

I have a list of checks issued and list of bills with a unique tracking numbers and need to match them up (these are in order by transaction ID, which are created sequentially). I sorted both by internal tracking number and need to assign a check number to the bills (or invoice numbers to the check). For instance, once I assigned the first 2 bills for vendor ABC, they total up to the first check amount for ABC. I have 2,000 invoice to match up to 863 checks and going check-by-check visually is going to be a nightmare. Any ideas where to start with this? <BR>

Trans ID	Invoice #	Vendor	Amount	Assigned Ck #	Trans ID	Check #	Vendor Name	Check Amount
1	INV 123	Acme	300.00	1000	9	1000	Acme	650
2	INV 124	Acme	350.00	1000	13	1001	Other Co.	2,000
3	INV 9183	Other Co.	1,200.00	???	18	1002	Test	3,500
4	INV 83	Other Co.	800.00	???	28	1003	Acme	50