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.

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.