Administrator Guide > System Management > Recovery > GL Export |
On the Elements tab, select the System Management button on the toolbar. Under the Elements group on the menu, select Collection, then select GL Export from the GL Settings for Recovery Accounts on the Configure tab. Access to this form is controlled by your Security Profile.
The GL Export provides an extract file detailing the GL allocations of all transactions posted since the last extract was finalized. GL allocations will only be available if the GL option has been selected in the GL Settings page under System Preferences.
GL File Format
The GL File is a comma-delimited text file that includes a single record for each GL transaction. There will be one GL transaction per GL account for each transaction posted against a particular loan.
Field | Comment |
Record Type | Fixed Value = H |
Creation Date and Time |
Date Format = mm/dd/yyy Time Format = hh:mm:ss using a 24 hour clock notation |
Field | Comment |
Record Type | Fixed value = D |
GL Account Number | |
Cost Center | |
Corporation | |
Allocation Amount | No commas, decimal included |
Debit/Credit Flag | Dr or Cr |
Record Type (Trailer) | Fixed value = F |
Number of Records (Trailer) | Total number of detail ("D") records |
Total Amount (Trailer) | No commas, decimal included |
Debit/Credit Flag (Trailer) | Dr or Cr |