Please forgive my ignorance... I am fairly new to the Quickbooks database and am trying to solve a problem.

I have an excel sheet with charges and payments that I need to write into QB.

I have gotten far enough that I am writing all charges into the Charge table successfully.  What I am not able to figure out is how to apply a payment to a specific charge that I have just written.  Some payments will be for the full amount, and some payments will be under/over the full amount of the charge... So I would also need to know if there is a difference mechanism for applying partial / over payments as well. 

I'm assuming I will need to retrieve the transaction # for the charge I just wrote and then write the payment info into some sort of payment table?  Unfortunately this is about as far as I've gotten.

Thanks in advance for any insight you might be able to lend me.

Brian

I'm hoping that by the Charge table, you don't mean Statement Charges?

The traditional approch is:  How do I create a new Customer, invoice them and mark the invoice as paid?  or if the sale is already paid, it's to use Sales Receipts: How do I create a Sales Receipt using QODBC? 

To pay charges, use the Charge.TxnID. See: Add Statement Charges to QB. 

See also : How can I receive payments or credits against customer invoices? and Statement Charge Insert statement fails for more.