Journal Entry Export

This comma-separated values (.CSV) file lists all general ledger transactions that pertain to a payroll or group of payrolls, based on a selected payroll run.

View step-by-step tutorial

Header Row

The first row in the spreadsheet shows basic information about the pay run, as defined in the Payroll Processing - Calculations screen.

The top cell in Column A shows the payroll's End Date.
The top cell in Column B shows payroll's Sequence Number.
The top cell in Column C shows payroll's Name, the report Type, the payroll's Sequence Number, Start and End Date, Pay Type and Pay Date.

Column Data (Row 2 and onward)

This section of the report displays the details and totals for your various payroll items and their associated departments as defined the Current Payroll - Distributions screen.

Expense Dept - Starting from the second row in Column A, this column shows the Expense Dept. If you have not defined an expense department for a given item, a zero ("0") will appear.
Account No. - Starting from the second row in Column B, this column shows the Expense Acct. If you have not defined an account number for a given item, a zero ("0") will appear.
Description - Starting from the second row in Column C, this column shows the details and totals of each payroll Item that is included in the Current Payroll - Distributions screen. Expense-related items will contain an "E" suffix.
Total - Starting from the second row in Column D, this column shows the totals Debits and Credits for the period.

See Also

HR Reports