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.