Export an existing payment batch and make yours look like that.

Do as Jay says, but also, you can only make a payment on an invoice so it requires an invoice number. If you don't have that, then you need to make sure that you import as a prepayment. You can set the document numbers in a couple of fields so that when the invoice does come it it is automatically linked to the prepayment but you don't need to do that if you don't have the numbers. I can't recall the field names off the top of my head.

Sage also sometimes interprets numbers as blank, so be sure your invoice numbers in Excel are text (apostrophe prefix to be sure).  If the first one is interpreted as text, you might not have to change all rows.  This differs from one type of import to another.

When you export a batch, you'll find over 450 fields on 7 pages.  If you just want to a simple import of invoice payments (single currency, no discounts, no taxes, etc), you need only these 16 fields:

Payments_Adjustments tab:  BTCHTYPE,CNTBTCH,CNTENTR,IDRMIT,IDVEND,AMTRMIT,DATERMIT

Applied_Payments tab:  BATCHTYPE,CNTBTCH,CNTRMIT,CNTLINE,DOCTYPE,IDINVC,IDVEND,CNTPAYM,AMTPAYM

Thank you very much for your reply. I will try it today. I have been trying to do it by retaining and eliminating some columns. I will try the above columns you mentioned.