How do I calculate an annualized budget (13/YY)?
Use Calculate Annualized Budget to estimate what your revenue or expenditure balance will be at the end of the year based on the year-to-date (YTD) balance as of a specific period. The system calculates this by taking the YTD balance for the specified period and dividing that by the number of elapsed periods for the fiscal year to get an average per period. The average is then multiplied by 12 to calculate the estimated ending balance.
For example, Jane is working in April 2000 and she wants to estimate the budget to the end of December 2000. She runs the Calculate Annualized Budget routine to find the average balance per month, and then multiply the total by 12. Like this...
Avg. per Month = [Month 1 + Month 2 + Month 3 + ...] / Number of Months
Annualized Budget = Avg. per Month x 12 Months per Year
What's new?
-
You can round amounts to the nearest whole dollar checkbox and create calculates for periods outside of the current year. (2023.05).
-
We fixed an issue in the 2023.05 release. Annualized budget amounts will be created based on the MM/YY (MM/DD/YYYY) in the As of Period.
Calculating annualized budget (13/YY)
1. Open Connect General Ledger > Budgeting > Calculate Annualized Budget (13/YY).
2. Enter the As of Period.
This routine calculates amounts based on the selected period. Use As of Period to the selected period that will be used to create the annualized budget entries.
As of period
3. Select the Copy to Journal Code.
Enter the destination journal code. This is the place where you will record the annualized budget entries.
Copy to journal code
4. Select the Copy to Budget Level.
Enter the destination budget level. This is the budget level that will be used to create the annualized budget entries.
Copy to budget level
5. Enter the Transaction Description.
Enter the default transaction description for annualized budget entries. Example: Annualized As Of MM/YY - MM/DD/YYYY
Copy to budget level
6. To round budget amounts to the nearest dollar, click to select Round Amounts to the Nearest Whole Dollar.
Round the annualized budget entries to the nearest whole dollar. Amounts that are less than or equal to 49 cents will round down and amounts that are equal to or greater than 50 cents will round up.
Round amounts to the nearest whole dollar
7. Set up the selection criteria.
You can filter the accounts by account number. Use ALL to calculate amounts for all accounts.
Selection criteria
8. Click GO (CTRL+G).
The annualized budget entries are copied to the selected budget and budget level. You can use Account Inquiry to look up the budget level to review the annualized budget entries. If you need to replace the annualized budget entries, run Calculate Annualized Budget (13/YY) again.
Copyright © 2025 Caselle, Incorporated. All rights reserved.
Related Articles
How do I copy to a projected budget (14/YY)?
Use Copy to Projected Budget (14/YY) to copy amounts from the current or annualized budget and paste the amounts in the selected periods. The purpose of this routine is to project the impact of the changes that have been made to the budget. After you ...How do I enter budget notes?
Add a budget note to a GL account when you enter budget amounts. Adding budget notes 1. Open Connect General Ledger > Budgeting > Enter Budget Amounts. 2. At the end of the Account box, click . 3. Select Budget Notes from the list. Budget Notes 4. ...How do I enter budget worksheet amounts?
Make budget entries for a single period or multiple periods. The budget entries will be tied to a budget for a fiscal or calendar year. Usually, an organization enters budget entries at least once a year to prepare a budget. Watch a video Learn about ...How do I copy budget amounts to a single period?
Use Copy Budget Amounts to a Single Period to copy budget amounts from a specific period range into a single period. This routine can (1) Copy Period 14 amounts to Period 0/YY. or (2) Copy your current year's budget to next year's budget. Before you ...How do I import budget amounts from a spreadsheet?
Use a spreadsheet to add budget amounts to a budget journal. Some organizations save their budget to a spreadsheet. Instead of typing in the budget amounts, you can import the budget amounts from the spreadsheet. Connect will create the budget ...