Bitta Sheets · Part 3 · 2:50 · YouTube
Business Central Budget in a Spreadsheet, Written Back Live
What this video covers
Build next year's G/L budget in Business Central the way you would in a spreadsheet, then write it straight back.
Open the budget in a sheet, start from last year's actuals, change sales by a percentage, type amounts and formulas, compare with actuals, then review and apply.
Transcript
Your controller wants next year's budget in Business Central by Friday. Here's how to build it in a sheet and write it straight back. Bitta Sheets opens a G/L budget as a sheet, with accounts down and months across.
You type or use formulas, review, then write it back. Start on G/L Budgets. Select the 2027 budget and choose Open in Sheet. You get a workbook with the whole year: a column per month,
and a total. In the settings, list the G/L accounts you budget. Save, and every line is one you plan. Start from last year, in the menu on the budget's title bar.
Copy from Actuals, rounded to the hundred. The preview lists every budget entry before anything is written. Apply Changes, and 2027 holds what you really sold and spent in 2026. Now select the sales and cost lines, and change them by six percent.
Change by Percentage: six, rounded to the hundred. The preview shows the change for every month. Sales and cost for 2027 both sit six percent above last year, so the margin holds.
Type an amount like in any spreadsheet. A bigger trade show booth in May: nine thousand five hundred. Last year's rent was three thousand one hundred fifty a month. Type it plus four percent once, and fill it across the year.
Nothing is written yet. Review changes lists all thirteen, and Check changes runs Business Central's own checks without saving anything. Apply writes them to the budget.
Turn on Compare with actuals by quarter, and last year sits next to each quarter of the plan. In Business Central, the G/L Budget Entries hold every amount, described as Entered in a sheet.
Use it in budget season, for a mid-year reforecast, or wherever your team budgets in Excel today. Next: budget entry by department.
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:35Part 4Business Central Budget Entry by Department
2:56Part 5Business Central Consolidation: Companies and Account Mapping
2:29Part 6Business Central Consolidation: Ownership, Rates and Minority Interest