The following table shows the import format for each budget record type. Import order | Item | Type | Length | Notes |
|---|
1 | Record ID | Alpha | 3 | Required, must be GLB. | 2 | Budget Year | Numeric | 4 | Required, must enter all 4 digits of the budget year. | 3 | Budget Type | Numeric | 2 | Required, must be between 1 and 10 . | 4 | Account | Alpha | 25 | Accounts may be entered with or without punctuation (e.g., 12-456-100 or 12456100). | 5 | Annual Amount | Numeric | 11 | See note below. | 6 | Period 1 Budget | Numeric | 11 | See note below. | 6 | Period 2 Budget | Numeric | 11 | See note below. | 6 | Period 3 Budget | Numeric | 11 | See note below. | 6 | Period 4 Budget | Numeric | 11 | See note below. | 6 | Period 5 Budget | Numeric | 11 | See note below. | 6 | Period 6 Budget | Numeric | 11 | See note below. | 6 | Period 7 Budget | Numeric | 11 | See note below. | 6 | Period 8 Budget | Numeric | 11 | See note below. | 6 | Period 9 Budget | Numeric | 11 | See note below. | 6 | Period 10 Budget | Numeric | 11 | See note below. | 6 | Period 11 Budget | Numeric | 11 | See note below. | 6 | Period 12 Budget | Numeric | 11 | See note below. | 6 | Period 13 Budget | Numeric | 11 | See note below. | 7 | Accrual or Cash | Option | 1 | See note below. | Notes: - The Accrual or Cash option is required if the Accounting Method is set to Both. If the Accounting Method is not set to Both, the Accrual or Cash option field may be left blank and the default value (either 1 for Accrual method or 2 for Cash method) will be used.
- The import file may contain both cash and accrual budget records.
- Eleven digits plus the decimal point and sign (e.g., -9.2) may be entered for the annual amount, and for each of the period amounts.
Example: ;This is a comment in a sample Import Budgets input file ;The next line provides an example of 12-period accounting (notice that a comma is needed after the 12th period amount if you are not using 13 periods) GLB, 1997, 2, 10-1001, 1200, 100,100,100,100, 100,100,100,100,100,100,100,100,,1 ;The next line is purposely split into two physical lines, which is accomplished by adding a + to the end of line one GLB, 1997, 2, 10-1001, 1200, 100,100,100,100, 100,100, + 100,100,100,100,100,100,,1 ;The next line gives an example of 13-period accounting GLB, 1997, 1, 10-1001, 1300, 100,100,100,100,100,100,100,100,100,100,100,100,100,2 For further information regarding Budget Imports, please see the Help Topic "Import Budgets (Tools menu)" under the General Ledger Help Menu. |