Budget – Dillner's Accounting Tools

This Budget window is used to set up the budget that is used on all Income Statement reports where the comparative period is set to Budget.

Select Setup>Budget.

Enter Values Manually

Enter a value in the Total column. That amount will automatically be divided by 12 and spread through all periods for that account. Values may also be manually entered for each account/period, as desired.

Budget—Cannot be changed at this time.
Year—Type in the desired year for the Budget.
Type—Select Budget Dollars or Budget Quantity. Quantity can be used to enter Budget fuel gallons.

Import from Text File

Budget values may be imported from a tab delimited text file. The file must have a column for each period the amounts will be imported to. Rows will be mapped to existing accounts.

To import a text file into the budget:

Click Import.
Click the Browse button to browse for the text file.
Select the desired file and click Open.
Select the desired Year from the drop-down list.
Click OK.

Note: A warning dialog box will appear if a budget already exists for the selected year. Click Yes to overwrite the existing budget. Click No to cancel the import.

The Import Generic Budget window which appears has all of the rows, columns and data from the saved text file. A drop-down list is available in the first row of each column. The program defaults the column value in each of these fields to Ignore.
Select the appropriate action or period in each column of the first row of the Import Generic Budget window.
Check the Exclude box for any row that should not be imported. (Usually title and total type rows.)
Click OK.
Enter the appropriate accounts in the Map To column on the Import Generic Budget Account Map.

Note: If a row should have been marked exclude on the Import Generic Budget and was not, map it to Ignore.
Click Print to print the Account Map, if desired.
Click OK to begin the import.
Click OK when the Import of data files is complete message appears.

Create from Prior

Budget values may be created based on actual data from prior years or the current year. The system will also increase or decrease the actual amount by an entered percent. The percent of increase or decrease is entered for each account class for each period.

To create a budget for the current year from prior actual or budget amounts:

Click Create from Prior.
Select the desired value from the drop-down list.

Note: Current Value—Use to keep current budget values intact or modify by percent entered.
Enter an amount for the percent of increase in the Period #%, if desired. Leave blank if no increase is projected. Enter a negative value if the amount is to be decreased. Enter percent as whole number. For example, 3.5% is entered as 3.50.
Repeat for all desired periods and account classes. If a given class is going to have the same selection value and percent for most or all of the periods, enter the selections in Period 1 and double-click on the Class label to populate all columns. Modify any periods that may be unique.
Click OK to create the budget.
Click the Save icon to calculate the totals.

Create budget for future year(s)

A budget may be created for next year or a future year based on the current actual values and/or prior year actual values and/or prior budget values. If the client file is currently in period 10, use actual current year for all periods completed for the current year. Use the actual amounts from the prior year and add the appropriate percent or use the budgeted values, if there is a budget for the current year, for periods which have not been completed for the current year.

Deleting a budget or classification section

To delete all amounts or amounts by classification:

Entered the desired year.
Select Create From Prior.
Select Current Values in the Period 1 column for the desired Class.
Enter -100.00 in the Period #% column.
Double-click on the Class to copy to all columns for the row.
Click OK.