Budget vs Actual now shows spent amounts by fiscal month in YTD and Full year views. In Accounting, open Budgets , then open the budget you want to review. Choose YTD or Full year to see fiscal month...
Last updated
Budget vs Actual now shows spent amounts by fiscal month in YTD and Full year views.
YTD and Full year show the fiscal months across the grid.
| Account / group | Jul | Aug | Sep | Total |
| 6410, Repairs & Maintenance | $0.00 | $2,274.22 | $0.00 | $2,274.22 |
Export uses the same period as the budget performance view.
The export follows whichever period you are viewing.
From YTD or Full year, each row is an account, and the columns are Account Code, Account Name, Group, then one column per fiscal month, then Budget, Actual and Variance. Note that the file names the spend column Actual, where the screen calls it Total; there is no column called Total in the file.
From Month, the file is a fuller per-row breakdown instead, adding the working behind the figure: base budget, carryover in, reallocations out and in, effective budget, actual, variance and variance percent. Use this one when you need to show how a month's available budget was arrived at. It lists both a category's own row and its member accounts, so add up one or the other, not both.
An export stops at 10,000 rows. The file still downloads, and URBI tells you it was cut short with "Export truncated at 10,000 rows - narrow your date range for a complete file." Narrow the period and export again if you need the rest.