Sample of the spreadsheet for Batch Create of Sales Invoice

[shahabb]

1st method: Just as @Mahfuzur_Rahman guided you.
2nd method:

@shahabb

Create a dummy invoice in Manager with all the required fields (Custom fields etc) which you would need, with some dummy data in it. Then go to batch update and select only that dummy invoice, copy to spreadsheet. All the columns are gonna be there now.

This 2nd method will help you know where to put the required data.