Understanding the Import Budget Process for Spreadsheets

If you create budgets using a spreadsheet program, you can import the budget data directly into the Account Balances - Batch File table (F0902Z1) using the Upload/Conversion Revisions program.

Before you import records into the F0902Z1 table, you should compare the columns in your spreadsheet to those on the Upload Records to F0902Z1 form. Customize the grid and rearrange the columns on the Upload Records to F0902Z1 form so that they match your spreadsheet and the order in which the columns appear on the spreadsheet.

Your spreadsheet must contain an account number, at minimum, for every record. No other fields are required. You can use the Account Number processing option in the Upload/Conversion Revisions program to specify which format to use for the account number. Notice that if you change the Account Number processing option, different fields appear in the detail area to accommodate each account number format.

Before you upload your budget data to the F0902 table, use the Upload/Conversion Revisions program (P0902Z1) to verify that the data is correct and revise the data, if necessary.