Skip to content
Bitta Apps

Bitta Sheets · Part 9 · 2:47 · YouTube

Business Central Financial Reports by Period, with Drill-Down

What this video covers

Run a Business Central financial report in a sheet: by quarter, by department, with a drill-down to the G/L entries behind any number.

Open the income statement from the Financial Reports page, switch the columns to four quarters and total, filter by department, double-click any amount to see the G/L entries, then compare with last year and see how a total is calculated.

Transcript

Your controller wants the 2026 income statement by quarter, and the entries behind fourth quarter sales. Here's that report, straight from Business Central, in a sheet.

Bitta Sheets runs your Business Central financial reports in a sheet. Pick the columns, the period and the departments, then drill into any number. On the Financial Reports page, select the income statement.

Under Actions, choose Open in Sheet. You get a workbook with the report's title, a period filter, and a filter for each dimension. The numbers are the ones Business Central's financial report calculates,

and every cell is read-only. Open the block settings. Here are the report, its columns, the period and the filters. Columns has nine presets: actual, against budget,

against last year, twelve months, and more. Choose Four quarters and total. Display sets the rounding, how negative amounts look, and which lines show.

Save, and 2026 splits into quarters: eight hundred seventy four thousand in sales, and a hundred twenty thousand of net income. Want the same columns in Business Central's own reports? New Column Definition from Preset creates one in a single step.

Pick the preset, name the column definition, and choose OK. Every dimension has its own filter. Choose the Sales department, and every number follows.

Double-click any amount, like fourth quarter sales. Business Central opens the G/L entries behind it. To compare with last year, add a sheet, then choose Insert, Financial report.

Pick the report, choose Actual vs prior year with variance, and type the period. For a group, Consolidate companies chooses the companies, ownership and exchange rates.

Insert, and 2026 sits next to 2025: sales up forty six percent, and net income almost three times last year's. Double-click a total to see how it's calculated: the rows behind it, the calculation, and the result,

shown with the opposite sign, as the report shows it. Use it for monthly and quarterly reporting, board packs, and any number someone asks you to explain. Next: month-end reporting with live formulas.

More Bitta Sheets videos

All videos

Next step

See Bitta Sheets on your own data