Excel spreadsheet formatting for GL Entry Batch Import

Each line on the spreadsheet is considered a separate general ledger entry. The column headings are in row 1. The entry information is contained in columns A-V, rows 2-999 of the spreadsheet.

Note: The order of the fields, or columns, does not matter. The columns can be in any order, but the column headings must be specified exactly as shown in row 1 of the tables.


Row	Column A	Column B	Column C	Column D	Column E
1	Division #	Department #	Account #	Sub Account #	Amount
2-999	<GL division #>	<GL department #>	<GL account #>	<GL subaccount #>	<transaction amount>


Row	Column F	Column G	Column H	Column I	Column J
1	Reference	Vendor #	AP Invoice #	Customer #	Invoice #
2-999	<transaction reference>	<valid APSV vendor #>	<vendor invoice number>	<valid ARSC customer #>	<customer invoice number>


Row	Column K	Column L	Column M-V
1	Invoice Suffix	Check #	Extended Reference 1-10
2-999	<customer invoice suffix #>	<check #>	<extended reference>

When you create the spreadsheet, you must limit the name to 14 characters and save the spreadsheet in Comma Separated Value (.csv) format. You cannot have spaces in the file name. You cannot have multiple worksheets in a workbook when you are saving to .csv format. If you do create multiple worksheets, only the active worksheet is saved and imported into the system.

After saving the spreadsheet, before importing the file in GL Entry Batch Import, you must transfer the file to your cloud reports directory using SA File Transfer Administration.

See Importing GL entries from Excel in GL Entry Batch Import.