General Ledger Export

Use the General Ledger Export report to download general ledger data to a Microsoft Excel spreadsheet file or other file format.

Contents

Column	Description
Account Number	This column displays the number of the general ledger account.
Account Code	This column displays the alternate code for the account.
Account Description	This column displays the description the account.
Detail Account Number	This column displays the detailed version of the account number.
Transaction Type	This column displays the two-letter abbreviation for the type of transaction (for example, TS for timesheet or XD for converted account data).
Trans Sub Type	This column displays the one-letter code for the transaction's sub-type.
Transaction Date	For all transactions except automatic postings, this column displays the date entered for the transaction. For automatic postings, this column displays the period-ending date for the file of transactions that generated the posting.
Bank Code	This column displays the identifier for the bank involved in the transaction.
Auto Entry	This Yes/No column indicates whether or not the transaction was an automatic posting.
Reference Number	This column displays the reference number for the transaction. If the transaction is an implicit posting or an automatic posting, this column displays Auto. If the transaction is historical, this column displays History. If the transaction is related to revenue generation, this column displays REVGEN. If you preview the report, you can drill down on the reference to see a listing of all transactions associated with that reference number. You can drill down on Auto to see all transactions for the posting run.
Fiscal Year and Period	This column displays the fiscal year and period in which the transaction was posted (for example, 201906 for the sixth accounting period in the year 2019).
Posting Sequence	This column displays the posting sequence number of the transaction. DPS assigns sequence number 1 to the first group of transactions posted during an accounting period, sequence number 2 to the second group, and so on. To generate a numbered list of all of the postings for the current accounting period, click Transaction Center > Posting Review Report.
Trans Type (Post Control)	This column displays the transaction type.
User Name	This column displays the user ID of the employee who created the transaction.
Post Comment	This column displays the comments entered during transaction posting.
Post Date	This column displays the date on which the posting occurred.
Description 1, Description 2	These columns display the descriptions for each transaction detail line. DPS stores the following types of descriptions for each transaction: Description 1 is a general description of the transaction (for example, the name of the vendor for an accounts payable voucher). Description 2 is a more specific description of the transaction (for example, the description entered during transaction entry for a single item on a voucher).
Project	This column displays the project number associated with the transaction. If a transaction is not related to a project, this column is blank. This column is blank for all Balance Sheet account transactions, except for those that affect accounts receivable.
Phase	This column displays the phase number associated with the transaction.
Task	This column displays the task number associated with the transaction.
Organization	This column displays the organization associated with the transaction.
Amount	This column displays the total amount of the transaction.
Total Credits	This column displays the total credits posted to the account during the reporting period.
Total Debits	This column displays the total debits posted to the account during the reporting period.
Sort/Select 1-3	These columns display the sort and select fields that are assigned to this account.
Period Start	Select the first accounting period you want to include in the report.
Period End	Select the last accounting period you want to include in the report.