Bitta Sheets · Part 4 · 2:35 · YouTube
Business Central Budget Entry by Department
What this video covers
Let each department head enter their own Business Central budget, in a sheet, and change nothing else.
Start from the Department Budget Entry template, get a line per department under every account, spread a yearly amount like last year or evenly, then share the workbook so people can edit budget amounts only.
Transcript
Every department head should enter their own budget, and only their own. Here's a department budget sheet they can fill in, and nothing more.
Bitta Sheets puts a line per department under every account. Owners spread or type their amounts, and a share level lets them change budget amounts only. Open the Sheet Template Gallery and choose Department Budget Entry.
Pick the budget, check the period, and list the expense accounts your departments plan. Every account gets a line per department, with last year's actuals beside each period.
Switch the columns to quarters, and the whole year fits on one screen. Administration plans nine thousand eight hundred for electricity. Select their line and choose Spread Budget Amount. Like Prior Year Actuals follows last year's pattern,
quarter by quarter, and the preview shows every amount first. Apply, and the quarters follow last year, highest in the third. Rent is flat, so Administration spreads it evenly over the four quarters.
Type the yearly amount, choose Evenly, and check the preview. Nine thousand eight hundred twenty eight in each quarter, in one step. Now share the workbook with the people who use Sheets,
through their permission set. Pick their permission set from the list. Choose Can edit budget amounts only: they change the budget amounts, and nothing else in the workbook.
The share list now shows the permission set and its level. In Business Central, every amount lands on the budget with its department. Use it for department budgets, budget owners outside finance, or any budget many people fill in.
Next: consolidation, starting with the wizard.
More Bitta Sheets videos
All videos
1:18OverviewEdit Business Central Tables Live in a Spreadsheet
2:08Part 1Edit Business Central Data in an Excel-Style Sheet
3:08Part 2Business Central Bulk Update Without Export and Import
2:50Part 3Business Central Budget in a Spreadsheet, Written Back Live
2:56Part 5Business Central Consolidation: Companies and Account Mapping
2:29Part 6Business Central Consolidation: Ownership, Rates and Minority Interest