Skip to content
Bitta Apps

Guide

Bitta Sheets guide

Follow the chapters in order, from the first install to everyday use. Each page tells you what to open in Business Central and what to fill in.

Showing all steps

  1. Chapter 1

    Before you start

    3 pages
    1. 01How Bitta Sheets worksBitta Sheets brings spreadsheets with live data into Business Central: financial reports, budgets with write-back, consolidation, templates and distribution.
    2. 02Licensing and activationWhat stays free in Bitta Sheets, what Pro and Finance add, and how an administrator enters an activation code or pastes a license.
    3. 03Setup, permissions and the role centerSet up Bitta Sheets in Business Central: the Studio Setup switches, the five permission sets, and where people find their workbooks on the role center.
  2. Chapter 2

    Workbooks

    12 pages
    1. 01Workbooks and live dataCreate workbooks in Business Central or import them from Excel, organize them in folders, then insert live data tables, reports and charts and refresh them.
    2. 02Live table editingPut a Business Central table in a sheet, type changes in the pencil columns, check them with Business Central validation, then apply them with an audit log.
    3. 03Bulk changes with a formulaChange many Business Central records at once: fill one formula down a data table, let Business Central check every row, then apply the changes that pass.
    4. 04Spreadsheet essentialsFormat, sort, filter, find and replace in a Bitta Sheets workbook, with Business Central number formats, frozen headers, zoom, full screen and shortcuts.
    5. 05Pivot tables on live dataSummarize any Business Central table in a pivot table: rows, columns and values with totals, quarters, top N with Others, and a drill-down on every number.
    6. 06Charts and KPI cardsAdd charts and KPI cards to a Business Central workbook: chart live data or cells, click a column to drill down, and show a KPI as progress to its target.
    7. 07Cell controls and input rulesAdd checkboxes, drop-down lists and date pickers to a Business Central sheet, set rules for what people type, and highlight values with conditional formatting.
    8. 08Document and journal linesEdit the lines of Business Central sales and purchase documents and general journals in a sheet: change, add and delete lines, checked like the page.
    9. 09Organize workbooks and sheetsOrganize Business Central workbooks in Bitta Sheets with folders, views, favorites and properties, and insert, rename, color, hide or delete sheets.
    10. 10BC functions and filtersBuild a Business Central month-end pack in Bitta Sheets with live BC functions, one month filter, a data table that follows it, and a refresh.
    11. 11Series, queries and report dataBring more Business Central data into a sheet with Bitta Sheets: date and FlowField series, a query result, and a report dataset with its request page.
    12. 12Connected tables and SQLJoin related Business Central tables in a sheet without SQL, run SELECT queries with cell parameters, and put SQL and AL formulas in a single cell.
    1. 01Financial reports and budgetsRun Business Central financial reports in a sheet by period and department, drill down to the G/L entries, and change a G/L budget and write it back.
    2. 02Consolidate companiesConsolidate group companies in one Business Central workbook: set up companies, period and group chart, map accounts, handle ownership, rates and eliminations.
    3. 03Budgets with write-backOpen a G/L budget in a sheet, start from last year's actuals, change it by a percentage, type amounts and formulas, then check and write it back to the budget.
    4. 04Metrics and the Financial Report APIUse Business Central financial report metrics in reports and workbooks, and set up the Financial Report API with addresses and snapshots for Power BI or Excel.
  3. Chapter 4

    Share and distribute

    4 pages
    1. 01TemplatesStart Business Central workbooks from templates that ask for a customer or a period, use the six standard templates, and save any workbook as your own template.
    2. 02Print and PDFPrint a Business Central workbook or save it as PDF from the sheet: add a logo, set the print area, paper, scaling and repeated rows, and a header and footer.
    3. 03Send workbooks on a scheduleEmail a workbook as PDF or Excel on a schedule: set the recipients, the burst mode and the email, preview the file, then schedule it through the job queue.
    4. 04Share, present and export workbooksShare Business Central workbooks in Bitta Sheets at the right access level, present them read-only in a meeting, export to Excel, and move them as packages.

Videos

Watch the full demo

Or watch it one step at a time:

All Bitta Sheets videos

Next step

Want help rolling out Bitta Sheets?

Ask the team that builds it, or book a demo on your own scenario. Prefer email? Write to info@bittaapps.com.