Daxko Accounting - Forecast

DAXKO ACCOUNTING - FORECAST

Go to Accounting.Daxko.com
Login using your assigned Daxko Accounting User ID and Password.

DAXKO ACCOUNTING - FORECAST

Forecast Report

The forecast report gives projected year-end totals for each account line. The year-end forecast is the sum of YTD actual activity plus user entered estimates for future months. Estimates are initially set at the amount budgeted but can be updated by users as needed.

To access the Forecast Report: Click the Budgeting tab at the top of the screen>click Forecast by Month under Reports.

DAXKO ACCOUNTING - FORECAST

Select Forecast - Select the current year operating fund.

Account Selection and Display - Choose which accounts are to be included in the report. You can drill down as far as needed. For instance selecting a branch will return all branch activity and adding a department will include only transactions for the selected department.

The transactions returned will only include GL accounts that the user has access to. If the user filters only on branch then the report will only include departments and accounts that are assigned.

DAXKO ACCOUNTING - FORECAST

Display Account Rows For:
Entire Account Numbers - Will show the Fund, Branch, Department and Account such as 1-010-101-2540 Program Supplies.
Major Accounts - Will show the total all activity for an account line such as 2540 Program Supplies
Major Account Groups - Will show the total of an account class such as 25 Supplies.

Display Options - These fields control what and how data is displayed in the report.

Summaries & Statements
Display Summary Worksheets - This option will show one summary worksheet and a second tab that gives only Total Revenue, Total Expense and Net for each Branch or each Department.
Display Statement Worksheets - This option will show one summary worksheet and tabs containing worksheets with the detail for each Branch or each Department.

Create Report - Run the report in Excel or as a PDF using the buttons at the bottom right. The PDF option is not available if a Summary Worksheet or Statement worksheet are selected.

DAXKO ACCOUNTING - FORECAST

Update Forecasts

To update the a Forecast: Click the Budgeting tab at the top of the screen>click Manage/Enter my Forecasts under Forecasts.

DAXKO ACCOUNTING - FORECAST

Select Forecast - Select the current year operating fund under Open Status Forecasts.

DAXKO ACCOUNTING - FORECAST

Accountsto Forecast - Choose which accounts are to be included in the Forecast List. You can drill down as far as needed. For instance selecting a branch will return all branch activity and adding a department will include only transactions for the selected department.

The account selection can also be refined using a number of filters:

Account Types - Choose Revenue, Expense or leave blank for both.

Account Name - Filter the results for a GL account name.

Budget vs. Actual/Forecast Variance - Show accounts with a defined dollar or percent variance to budget.

DAXKO ACCOUNTING - FORECAST

All of these selection options can be used together to refine the accounts shown in the Forecast List.

The transactions returned will only include GL accounts that the user has access to. If the user filters only on branch then the report will only include departments and accounts that are assigned.