Budget Prep > Accounts > Export Budget Prep Account Details

Recent Change: 
6.134
- Removing validation on dates for Historical budget prep data export.
6.130
- Added account description to the end of the files created. Changed the delimiter from comma to pipe. 
6.126
- Added new menu option to create export files for historical/future budget prep data for use with OpenGov.

Introduction

This option is available only if the 'OpenGov' interface is set in the license file.The Export Budget Account detail feature allows users to export historical account actuals/budgets for specified date range or future budgets for a specified budget version to a .txt file. This was developed to provide export files for clients who want to use OpenGov for Budgeting and Reporting purposes.

Input Criteria

  • Historical/Actual Budgets - If this option is selected the user can select a date range to allow them to export budget/actual transaction details for multiple fiscal years. It will create two .txt files one for Actual and one for Budget amounts.

Export File Layout For Historical budget data :

http://rand-wiki.harriscomputer.com/Page/5774/OpenGovBudgetPrepLayout

  • Future Budgets - If this option is selected the user can select a budget version for a future fiscal year to export as a .txt file.

For Future Budget Export Layout

Field Comments
Account Number fl141.cacct
Fund fl141141Segments.Fund
Fund Name csi21.cfunddesc
Department fl141Segments.Department
Department Name csi25.cdeptdesc
Object fl141Segments.Object
Object Name csi23.cobjname
Account Type
Function fl141Segments.Func
Function Name csi22.cfuncdesc
Location fl141Segments.Location
Location Name csi24.clocdesc
Object Group fl141Segments.ObjectGroup
Object Group Name csi30.cprogdesc
Cost Center fl141Segments.CostCenter
Cost Center Name csi36.ccostdesc
Job Class fl141Segments.JobClass
Job Class Name csi35.cjobdesc
Modifier fl141Segments.Modifier
Modifier Name csi34.cmodifdesc
Fiscal Year
Recommended AccountBudget.Recommended
Requested AccountBudget.Requested
Forecasted AccountBudget.Forecasted
AccountDescription fl141.cacctdesc