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 column contains Y or N (Yes or No) to indicate whether or not the transaction was an automatic posting. |
| Reference Number | This column displays the reference number for the transaction.
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, 200906 for the sixth accounting period in the year 2009). |
| Posting Sequence | This column displays the posting sequence number of the transaction. Vision 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 from the Vision Navigation menu. |
| Trans Type (Post Control) | This column displays the transaction type. |
| User Name | This column displays the Vision 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.
Vision stores the following types of descriptions for each transaction:
|
| 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. |