Excel spreadsheet formatting for general ledger import

You can use a Microsoft Excel spreadsheet to create general ledger entries. This is beneficial if you have business data created by an application or service external to the system General Ledger. Create and format the spreadsheet, specify the required information, and then run the GL Entry Batch Import Report to import the spreadsheet.

Each line on the spreadsheet is considered a separate general ledger entry. To create general ledger entries from an Excel spreadsheet, you must format the spreadsheet in a specific way. If you do not format each spreadsheet correctly, an invalid import occurs.

The entry information is contained in columns A-V, rows 1-999 of the spreadsheet.

Row	Column A	Column B	Column C	Column D	Column E
1-999	Division #	Department #	Account #	Sub Account #	Amount

Row	Column F	Column G	Column H	Column I	Column J
1-999	Reference	Vendor #	AP Invoice #	Customer #	Invoice #

Row	Column K	Column L	Column M-V
1-999	Invoice Suffix	Check #	Extended Reference 1-10

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.