Budget Export to Excel

Use the Budget Export to Excel to modify your budget and then import the new figures into Budget Management using the Data Import feature on the Administration menu.

The report can be reached by selecting Reports > Budget > Budget Export To Excel. Sample

The worksheets contain the following information:

• Budget Export Comments: Description of how to use the export file.

• Budget Headers: Lists the cycle name, fund element value, and element order.

• Budget Detail: Includes cycle name, fund element value, pool number, account code, proposed amount, auto-create indicator, comment/description, adopted amount, GL budget, GL encumbrances, and GL actuals.

Step 2: Edit the data

Budget header worksheet

1. Review the budget header to make sure it contains all the fund element values for which you want to import a budget.

2. If it doesn't, add the needed fund element values with their cycle, and save the file as .txt.

Budget detail worksheet

1. Insert a column immediately after the account code, and fill this column with the account type name — Asset, Liability, Expenditure, Revenue, Other Financing Uses, Other Financing Sources, or Fund Balance/Retained Earnings.

2. Change the amounts to the proposed amounts.

3. Save the file as .txt.

Step 2: Prepare the data for import

When you're satisfied with the new budget data, prepare the data for the import back into AptaFund.

Budget Headers worksheet

Copy the data without headers, paste it into Notepad, and save the .txt file.

Use this .txt file for the Identify New Budgets process.

Budget Detail worksheet

Copy the data in columns A through G without headers for the rows with proposed amounts. Paste it into Notepad, and save the .txt file.

Step 3: Import the data into Budget Management

Use the header and detail .txt files in the Data Import as needed to create, adjust, and revise budgets.

Return to Budget Reports Overview