General Ledger Export

MAIN MENU >   Report > Payroll Reports > General Ledger Summary

To ensure that the general ledger data will import correctly, the pay stub accounts must first be mapped to the existing ledger accounts in the accounting software. See General Ledger Mapping.

TimeTrex supports several General Ledger export formats so the report can be imported into accounting software.

The general ledger export can be customized by using various templates; the most common being, by employee, branch, department or pay period.

General Ledger exports can include accrual journal entries for pay periods that span two months, negative debit or credit amounts when the accounting format requires them, and data for multiple legal entities when the report is filtered for more than one legal entity.

General Ledger Export Formats
EXPORT FORMAT DESCRIPTION
Excel (CSV) Exports general ledger data to a CSV file.
Excel (CSV) [Flat] Exports general ledger data to a flat CSV file.
Quickbooks GL Exports general ledger data for Quickbooks.
Sage 50 GL Exports general ledger data for Sage 50.
Sage 300 GL Exports general ledger data for Sage 300.
Thrive UX GL Exports general ledger data for Thrive UX.
Multiview GL Exports general ledger data in Multiview ERP format.
Xero Manual Journal Exports general ledger data for a Xero manual journal.

To create a General Ledger Export file:

  • Click Report, Payroll Reports, then General Ledger Summary in the main menu.
  • Select the type of Template, Time Period, Section, Pay Period Schedule, and Legal Entity criteria to export. If you are generating accrual journal entries, review the accrual reference period as well.
  • Click View in the button bar to review the report prior to exporting.
  • Click the Export button drop-down on the right side of the button bar and select the format that matches your accounting software.

 

Importing into an Accounting Software

Each accounting software differs in how to import the general ledger data. We recommend you refer to importing instructions for the particular software being used.

The following is an example of how to import into Quickbooks:

  • Select File, Utilities, Import, IIF
  • Select the .iif file previously exported from TimeTrex and click the Open button to import the data.
  • Check to make sure the data has been imported correctly by viewing a report. One method might be to:
    • Click Reports, Accountant & Taxes, Transaction Detail by Account.
    • Select the Date the data was imported, Total by Account List, Sort by Default.