Skip to content
Bitta Apps

Bitta Sheets Excel-Compatible Spreadsheets and Financial Reporting for Microsoft Dynamics 365 Business Central

Excel-compatible spreadsheets that run inside Business Central on live data. Run financial reports from your own row and column definitions, write G/L budgets back to Business Central, consolidate companies with intercompany eliminations, and check every change against Business Central validation before it is saved.

App on Microsoft Marketplace

Free

Free tier. Pro $899, Finance $1,499 per Microsoft Entra tenant per year. Available now on Microsoft Marketplace.

Bitta Sheets at a glance

Publisher
Bitta Apps
Platform
Microsoft Dynamics 365 Business Central online, version 28.0 or later
Price
Free tier. Pro $899, Finance $1,499 per Microsoft Entra tenant per year. Available now on Microsoft Marketplace.
Last updated
full demo

See Bitta Sheets end to end

Bitta Sheets for Business Central: Full Demo, a Month Without Exports12:09Chapters and transcript
before and after

From problem to outcome

  • Bulk changes mean export, edit and import

    Fixing many records means exporting to Excel, editing and importing again, with no check until the import fails. In Bitta Sheets you edit the live table, check the changes against Business Central validation, then apply them.

  • Month-end lives in exported spreadsheets

    Exported numbers go stale the moment they leave Business Central. In Bitta Sheets the data tables and financial reports refresh from Business Central when you ask.

  • Budgets are typed in twice

    Change a G/L budget in the grid and write it back, or copy it from actuals and change it by a percentage, instead of keying it in again.

  • Consolidation is a workbook only one person understands

    New Consolidation builds one workbook with companies, account mapping, trial balances, eliminations, consolidated statements and an audit trail.

  • Reports are sent by hand every month

    Distributions send finished workbooks by email through your Business Central email accounts, on a schedule, with a log of every send.

how it works

How it works

  1. 1

    Open a table

    Open any Business Central table as a live spreadsheet. Edit in place and fill down, then check your changes and apply them.

  2. 2

    Create a workbook

    New Workbook, Import from Excel or New from Template. Every workbook can be exported back to Excel.

    Watch 2:08Read the chapter
  3. 3

    Insert live data

    Insert a data table, financial report, budget, journal lines, document, pivot table, chart or KPI card, and refresh all live data at any time.

    Watch 2:08Read the chapter
  4. 4

    Report and consolidate

    Add financial reports by period, write budgets back to the G/L, and consolidate several companies in one workbook.

    Watch 2:50Read the chapter
  5. 5

    Share and send

    Share a workbook with other users, present it full screen, print it, or send it by email on a schedule.

    Watch 2:27Read the chapter
feature tour

Bitta Sheets in Business Central

Bitta Sheets workbook with a live financial report by quarter

Also included

  • Excel-compatible, inside Business Central

    More than 500 Excel-compatible functions in standard Excel formula syntax, real worksheet tabs, conditional formatting, pivots and charts, plus Business Central functions such as BC.GL (any account, period and dimension), BC.BALANCE and BC.BUDGET. Import Excel files, and export values, formatting and native Excel tables at any time.

  • Financial reports on your own definitions

    Runs your Business Central row and column definitions live. Eight one-click column layouts: Actual, Actual vs Budget, Actual vs Prior Year, Full Variance, Period and YTD, Monthly Trend, Quarterly Trend and Companies Side by Side.

  • Drill-down and explanations

    Ctrl+click report, pivot and table amounts to open the entries or records behind them. Explain shows how a formula, subtotal or translated amount was calculated.

  • Metrics from any table on report rows

    Add open orders, backlog, bank balances or headcount to a financial report as Sum, Count, Average, Min, Max, Distinct Count or First Value, from a reusable metric library.

  • Budgets that write back (Pro)

    Edit G/L budgets by period and dimension; spread evenly, by weights, by prior-year actuals, by prior-year budget or by working days; copy from actuals plus or minus a percentage; compare with actuals; lock closed periods.

  • Consolidation that posts (Finance)

    Map different charts of accounts, translate currencies with closing, average, historical, opening or composite rates, match intercompany balances, apply elimination rules, and handle full or proportional ownership with non-controlling interest. Every posting is simulated first and kept in an audit trail.

  • Check changes before they are saved

    Edit Business Central tables like a spreadsheet. Check changes runs Business Central validation without saving and lists the records, amounts and errors your edits would produce; budget, journal and document write-back gets the same check. Apply records every write in the audit log, and table edits also pass through the Bitta Apps Studio Security Guard.

  • Live data blocks

    Data tables, connected tables, queries, report datasets, SQL, journal lines, sales and purchase documents, pivots, FlowField and date series. Data blocks can read from another company.

  • Filters for every reader

    Period presets (this month, quarter to date, year to date, last fiscal year and more), dimension, date and lookup filters drive every block, chart and KPI card at once. Viewers can filter without editing.

  • Board-ready output

    Waterfall, combo and sparkline charts, KPI cards with targets and trends, and server-side PDF with page setup, print areas, repeating rows, headers and footers.

  • Reports that send themselves (Pro)

    Email workbooks or report packs on a schedule through your Business Central email accounts, calculated fresh by the server at send time. Split per recipient, per dimension value or per company, send only when a KPI alert fires, with a log for every recipient.

  • Shared with the right access

    Owner, Edit, Edit Budget Amounts, View and View No Print levels for users, permission sets or everyone. Templates (Pro) open from any customer, vendor, item or G/L account. Users don't need SUPER.

roles

Who it is for

Finance and controllers

Build financial reports, budgets and consolidations on live Business Central data, and send them on a schedule.

Show the steps for Finance and controllers

Accountants

Work in familiar spreadsheets with data that refreshes from Business Central instead of copying exports.

Show the steps for Accountants

Administrators

Give people the Sheets permission sets, set up the email account for sends, and review write-back in the audit log.

Show the steps for Administrators
pricing and fit

Pricing and requirements

Free

Free tier. Pro $899, Finance $1,499 per Microsoft Entra tenant per year. Available now on Microsoft Marketplace.

Requirements

  • Business Central online, version 28.0 or later
  • Essentials or Premium
  • Bitta Apps Studio, installed automatically as a prerequisite
  • Pro and Finance features: a Bitta license per Microsoft Entra tenant, with unlimited users and every environment
  • Sheets users do not need SUPER
  • Scheduled sends use your Business Central email accounts

Integrations

  • Excel import and export
  • Business Central G/L budgets, financial reports and dimensions
  • Business Central email accounts for distribution
  • Financial Report API for Excel and Power BI
videos

Watch Bitta Sheets in Business Central

All Bitta Sheets videos
faq

Frequently asked questions

Ask us something else
What is Bitta Sheets?

Bitta Sheets is an Excel-compatible spreadsheet app that runs inside Microsoft Dynamics 365 Business Central online. Workbooks read live Business Central data, run financial reports and budgets, consolidate companies, and write changes back after Business Central validation.

Can I use an Excel-style spreadsheet inside Business Central?

Bitta Sheets gives Business Central an Excel-compatible spreadsheet with more than 500 Excel-compatible functions, worksheet tabs, pivots and charts, connected live to your data. You can import Excel files and export any workbook to Excel with its values, formatting and native Excel tables.

Which formulas can I use with Business Central data?

Bitta Sheets supports more than 500 Excel-compatible functions in standard Excel syntax, plus Business Central functions including BC.GL, BC.BALANCE, BC.BUDGET, BC.SUM, BC.COUNT and BC.LOOKUP. BC.GL returns G/L amounts for any account, period and dimension.

How do I build financial reports in Business Central without exporting to Excel?

Bitta Sheets runs your existing Business Central financial report row and column definitions live inside a workbook, with eight one-click column layouts such as Actual vs Budget, Period and YTD, and Companies Side by Side. Ctrl+click a report amount to see the entries behind it.

Can I add non-financial numbers to a Business Central financial report?

Bitta Sheets adds metric rows to financial reports that read any table, for example open orders, backlog, bank balances or headcount, using Sum, Count, Average, Min, Max, Distinct Count or First Value. Metrics follow the report's period and dimension filters.

Can I report across several Business Central companies?

Bitta Sheets lets data blocks read from another company and lays out financial reports with companies side by side. Amounts in other currencies are translated at closing or average rates by account type, with a translation-difference row.

Is there a consolidation app for Business Central that handles eliminations?

Bitta Sheets Finance consolidates Business Central companies in one workbook: account mapping across different charts of accounts, intercompany matching, elimination rules for IC balances, IC sales and purchases, account pairs, and investment and equity, and full or proportional ownership with non-controlling interest. Every posting is simulated before it is posted.

How does Bitta Sheets handle multi-currency consolidation?

Bitta Sheets Finance translates each company with closing, average, historical, opening or composite rates, taken from Business Central exchange rates, the business unit or a manual rate, with overrides. Translation differences get their own line.

Can I build and write back G/L budgets in Business Central?

Bitta Sheets is a budgeting app inside Business Central that edits G/L budgets by period and dimension and writes them back (Pro). Spread totals evenly, by weights, by prior-year actuals, by prior-year budget or by working days, compare with actuals, and lock closed periods.

Can department managers enter their own budgets?

Bitta Sheets has an Edit Budget Amounts sharing level, so department managers can enter budget figures without editing the workbook layout.

Can I edit Business Central data in a spreadsheet safely?

Bitta Sheets opens Business Central tables as live rows. Check changes runs Business Central validation without saving and lists the records, amounts and errors your edits would produce; Apply then writes them through the Bitta Apps Studio Security Guard and records each one in the audit log.

Can Business Central email reports automatically?

Bitta Sheets emails workbooks or report packs on a Job Queue schedule through your Business Central email accounts, calculated fresh at send time (Pro). A send can be split per recipient, per dimension value or per company, and can go out only when a KPI alert fires. Every send is logged per recipient.

Does Bitta Sheets work with Power BI?

Bitta Sheets publishes financial report results through a Financial Report API (OData) that Power BI and Excel can read, with each cell returned with its report, column layout and date filter.

Does Bitta Sheets have an AI assistant?

Bitta Sheets includes an AI assistant that connects to your own Anthropic, OpenAI or Azure OpenAI account, so your provider bills you directly, with data masking and caps on what is sent.

Who can see or edit a workbook?

Bitta Sheets shares each workbook at Owner, Edit, Edit Budget Amounts, View or View No Print level with users, permission sets or everyone, on top of normal Business Central permissions.

What does Bitta Sheets cost?

Bitta Sheets has a free tier for up to 5 workbooks with live data, formulas, charts, Excel import and export, and financial reports. Pro costs $899 and Finance, which adds consolidation, costs $1,499, each per Microsoft Entra tenant per year, with unlimited users and every environment included.

Where do I get Bitta Sheets?

Bitta Sheets installs from Microsoft Marketplace into Business Central online version 28.0 or later, Essentials or Premium. Bitta Apps Studio installs with it automatically at no cost, and Sheets users don't need SUPER.

How do I activate Pro?

Bitta Sheets Pro is activated by an administrator on the Bitta Apps Studio License page by entering a code or pasting a license. One license covers every Bitta app in the tenant.

What happens when a license ends?

Bitta Sheets keeps Pro running for 30 days after a license ends, and no workbook or data is deleted when it does.

Can Bitta Apps set up Bitta Sheets for us?

Bitta Sheets is built by Bitta Apps, a Microsoft Dynamics 365 Business Central partner. Our consultants can rebuild your Excel reports as live workbooks, set up budgets and consolidation, and train your finance team.

next step

Ready to try Bitta Sheets?

Prefer to read first?Start the guideBrowse the reference

same foundation

The Bitta Apps Studio suite

more apps

More Business Central apps