Learn more

Importing a G/L Batch

General Ledger’s batch importing command lets you:

Transfer batches of transactions created by non-Sage HRMS Payroll programs to General Ledger, where you can edit, print and post them.
Transfer batches exported by Sage HRMS Payroll ledgers at other physical sites.

Sage HRMS Payroll Import Batches

Generally, you only use import to transfer Sage HRMS Payroll batches that are created in another location for posting to your General Ledger. If your subledgers are in the same database as your General Ledger, they will create batches directly in the G/L.

Import batches can be created off-site in one of two ways:

By using the Export G/L Batch File window in the remote site to create the batch.

Then using the Export command on the Export G/L Batch File window's File menu to create a batch that can be imported by your General Ledger.

By creating a General Ledger batch in a database that doesn't have General Ledger activated.

For example, if you have a branch office database that contains Accounts Receivable or Accounts Payable ledgers but no General ledger Sage HRMS Payroll will create a G/L import batch file when you choose to create a batch for posting to General Ledger.

Import batches created automatically by Sage HRMS Payroll are in CSV text format (comma separated values).

If you are exporting a batch manually (using the File, Export command in the Journal Entry window), you can choose from a variety of formats. However, if you are creating the file for Sage HRMS Payroll, there is no reason to use another format.

Non-Sage HRMS Payroll import batches

Batches created by non-Sage HRMS Payroll applications must be imported into General Ledger. This is the only way to transfer them to G/L.

As with transactions generated by Sage HRMS Payroll subledgers, the source code attached to the detail indicates the transactions’ source ledger and type. You must define your source codes in the source application, then add them to General Ledger before you export transactions.