Hi Jean,

Thanks for posting the rest of the information - that shows what the problem is. You have 11 fields selected in the import template, but only 10 columns in your Excel file. This doesn't batch and thus gives the invalid layout message. In fact, you should have 12 fields and columns to fit everything.

As identified by your column outlining, column G is being used for both a GL account and Job number - this is not correct. Each column in the Excel spreadsheet must represent a specific field from the import template. Also, you have not selected the 'Det-Detail Type' field in the import template

I believe your template should be: (with matching Excel column letter)
(A)Hdr-Record Type ‘H’
(B)Hdr-Vendor Number
(C)Hdr-Trans Type (string)
(D)Hdr-Invoice Number
(E)Det-Record Type ‘D’
(F)Det-Detail Type
(G)Det-GL Account (3020 - gst)
(H)Det-GL Dept (blank)
(I)Det-Job (WATR)
(J)Det-Phase (SW)
(K)Det-Category (DEMO)
(L)Det-Amount Payable


In Excel the data should be laid out as follows:
Line 1:
Column A: H
Column B: AGAPPE
Column C: IN
Column D: 39034
Column E: D
Column F: 1 (Det-Detail Type)
Column G: 3020
Column H: (blank)
Column I: (blank)
Column J: (blank)
Column K: (blank)
Column L: 48.00

Line 2:
Column A: H
Column B: AGAPPE
Column C: IN
Column D: 39034
Column E: D
Column F: 3 (Det-Detail Type)
Column G: (blank)
Column H: (blank)
Golumn I: WATR
Column J: SW
Column K: DEMO
Column L: 800.00

This should work, and though it may have been slower than manual entry this time, it will be a lot faster the next time!