I have a execution plan do you think that will help ? It shows every cursor loop as a individual query with a cost of 0% though.

I'll let you know what the execution time is after indexing. We're looking at roughly 2,500,000 transactions. (payments/charges combined)

It sure is, the tables most accessed I guess are the 'chargesinserted' , 'paymentsinserted' and 'ar', I will create a composite primary key for the first two. And a PK...

See attached, this would be to do everything in 1 big bulk. (eliminating the code I had in the previous post) 
I had to zip the file it didn't allow...

One of the issues I am having is that while I was testing I wrote my stored procedure for 1 contract specific.
So taking all the charges/payments from the old system,...