Input Budgets and Forecasts
You can load Budgets and Forecasts into IFS IDEAS to streamline review of Budgets and Actuals. IFS IDEAS offers flexibility in how you want to review budgets. You can create monthly, quarterly, yearly or other types of budgets. You can create multiple revisions for budgets and forecasts.
Details
Understand Ways to Load the Budget (and the Recommendation)
Budgets are loaded to the General Ledger in two primary ways:
Load budgets using journals (recommended)
Load budgets using segments
It is recommended to load budgets using journals.
Watch this video for a full explanation and recommendation.
Load in Journal | Load in Journal | Load in Segment | Load in Segment | |
PRO | CON | PRO | CON | |
Audit trail | Requires journal definitions | Quick deploy | Weak audit trail | |
xrefs |
|
| xrefs definition | |
Security |
|
| Difficult to reverse | |
Transactions and balances |
|
| Updates balances only | |
Ability to track budget |
|
|
| |
Can easily be reversed |
|
|
|
Prepare Your System for Budget Upload Using Journals
You will have to define:
List of Segments
List of Transaction Types
List of Journals
Questions to answer that help determine your setup (e.g. which segments are needed):
What is my budget design?
What do I want to accomplish?
How many revisions do I want?
How many forecasts do I want?
Do I want Prior Year segments
Do you want budgets for multiple future years?
Watch this video to learn how.
Enter or Upload Your Budget into Journals
The easiest way to upload journals for your budget is to use Spreadsheet Link.
You can download a simple Example Budget Upload Template.xlsx that is used in the video.
Watch this video to learn how.
Create a Budget vs. Actual Report
Now that you have budgets and actuals in the system, you can create a variety for reports against the data.
Watch this video to see a simple example.
Copyright© 2024 IFS AB. Copying prohibited. All rights reserved.