--- title: "Excel Bridge Overview" slug: "excel-bridge-overview" status: "new" updated: 2026-11-18T22:14:30Z published: 2026-11-18T22:14:30Z canonical: "docs.restaurant365.com/excel-bridge-overview" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.restaurant365.com/llms.txt > Use this file to discover all available pages before exploring further. # Excel Bridge Overview In Beta This feature is in [beta](/doc/docs/user-research). Contact your CSM to learn more. Excel Bridge is an Excel add-in from Restaurant365 that connects directly to R365 and pulls live general ledger and budget data into a workbook through R365 specific formulas, R365.GL and R365.BUD. For a team that already builds its reports, budget comparisons, and board packages in Excel, these formulas replace exporting a report from R365 and pasting the result into a workbook. Because the data comes from a formula rather than a one-time export, a workbook built once keeps working period after period. A user refreshes it instead of rebuilding it. Excel Bridge is useful for a team that maintains its own Excel templates or models, or needs a custom report or comparison that goes beyond what a built-in R365 report offers. It is also useful for a team that manages multiple locations or entities and wants to combine or compare data across them, or that regularly rebuilds the same report each period and would rather refresh it. R365.GL pulls general ledger net activity for a set of accounts, locations, and dates. R365.BUD pulls the budgeted amount for a set of accounts, one location, and a date range. You can combine the two formulas in the same workbook to build a budget-vs-actual comparison or a period-over-period profit and loss. See [Write GL Formulas](/doc/docs/use-r365-gl-formulas) and [Write Budget Formulas](/doc/docs/use-r365-budget-formulas) for the full formula reference, and [Excel Bridge Quick Start](/doc/docs/excel-bridge-quick-start-guide) for a short walkthrough of the whole flow. Before a user can install and use Excel Bridge, [all prerequisites](/doc/docs/install-excel-bridge#prerequisites) must be met. Once the administrator grants access, a user installs the add-in and signs in. See [Install Excel Bridge](/doc/docs/install-excel-bridge). --- ## Feature Pages, Screens, and Records ### Task pane The task pane (opened from the **R365** button on the Excel **Home** ribbon) contains the sign-in screen, the connection status, the **Refresh Sheet** and **Refresh Workbook** buttons, and the **Sheet/Workbook last updated** timestamp. From the task pane, users can: - Sign into and out of R365 to switch between companies - Refresh the Excel Bridge formulas on the sheet in view with **Refresh Sheet** - Refresh the Excel Bridge formulas on every sheet in the workbook with **Refresh Workbook** - Sign out of the current session ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-4J71511S.png?sv=2026-02-06&spr=https&st=2026-11-18T22%3A58%3A06Z&se=2026-11-18T23%3A58%3A06Z&sr=b&sp=r&sig=NXREtFULHC3WXG%2BledrtCFM0BftXa3hhIIM%2Fz%2F7IqQ8%3D) --- ## Feature Setup ### Enable Custom Financials Excel Bridge shares its underlying financial reporting database with Custom Financial Reports (CFR). The Custom Financials feature must already be enabled for a company before Excel Bridge can be enabled for it. To enable CFR, reach out to your CSM. ### Enable Budgeting & Forecasting R365.BUD requires Budgeting & Forecasting to be turned on for the company. R365.GL does not require it. To turn on Budgeting & Forecasting, contact your CSM or R365 Support. ### Excel Bridge Installer or Manifest file When using Windows, the **Excel Bridge installer** can be used, which installs the file and does not require a separate file download. For Mac users or Windows users who need to manually install for any reason, Excel Bridge can be installed manually. For manual install, the **XML manifest file** is required. Download the installer or XML file below. **Windows Installer** [](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/R365ExcelBridgeSetup(2).exe?sv=2026-02-06&spr=https&st=2026-11-18T22%3A58%3A06Z&se=2026-11-18T23%3A58%3A06Z&sr=b&sp=r&sig=XkLFZSODxXnBGJOXqhkcxOoS8nVbziTXuCy%2Fn%2B5rBvA%3D)R365ExcelBridgeSetup6.25 MB[](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/R365ExcelBridgeSetup(2).exe?sv=2026-02-06&spr=https&st=2026-11-18T22%3A58%3A06Z&se=2026-11-18T23%3A58%3A06Z&sr=b&sp=r&sig=XkLFZSODxXnBGJOXqhkcxOoS8nVbziTXuCy%2Fn%2B5rBvA%3D) **XML File (For Manual Install)** [](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/R365 Excel Bridge.xml?sv=2026-02-06&spr=https&st=2026-11-18T22%3A58%3A06Z&se=2026-11-18T23%3A58%3A06Z&sr=b&sp=r&sig=X7XTc0NEQm%2BrQc3jeLW6ffF3KB7tgmhot4E4u512rk0%3D)R365 Excel Bridge4.70 KB[](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/R365 Excel Bridge.xml?sv=2026-02-06&spr=https&st=2026-11-18T22%3A58%3A06Z&se=2026-11-18T23%3A58%3A06Z&sr=b&sp=r&sig=X7XTc0NEQm%2BrQc3jeLW6ffF3KB7tgmhot4E4u512rk0%3D) ### Permissions Users must have the following permissions to sign in and run formulas: - Reporting → Custom Financial Reports → Reports → Create Reports in Excel using the R365 Excel Add-in - Administration → Locations → View Locations - General Ledger → GL Accounts → View GL Accounts - General Ledger → Budgets → View Budgets > [!NOTE] > This permission is needed to run R365.BUD formulas. Budgeting & Forecasting must also be enabled for the organization. > [!WARNING] > Note about permission and feature changes > > Permission and feature changes can take up to 5 minutes to reach Excel. ### System Requirements Excel Bridge requires Microsoft 365 on Windows (version 2002 or later) or Mac (version 16.35 or later), Office LTSC 2024, or retail Office 2021 or 2024 (version 2311 or later). The following are **not** supported: Office 2016, Office 2019 (any license), volume-licensed Office 2021 or earlier, and Excel on iPad. ### Install the Excel Bridge Plug-in To use Excel Bridge it must first be installed. It can be installed in the following ways: - [Using the installer for Windows](/doc/docs/install-excel-bridge#install-using-the-excel-bridge-installer-windows) - [Manually using the manifest download on Windows](/doc/docs/install-excel-bridge#connect-r365-to-a-local-version-of-excel) - [Manually using the manifest download on a Mac](/doc/docs/install-excel-bridge#connect-r365-to-excel-for-mac) --- ### FAQ #### Why do my Excel Bridge formulas show an error instead of a value? A formula returns an error instead of a number when the financial reporting database for the company is not yet provisioned, formula entry errors (such as an incorrect GL account number), or when the signed-in user's role is missing one of the required permissions. See [Excel Bridge Troubleshooting](/doc/docs/excel-bridge-troubleshooting) for what the task pane shows in each case and how to resolve it. #### How long does it take before Excel Bridge formulas start returning data? Excel Bridge formulas cannot return data until the financial reporting database finishes provisioning. See [Set Up Access to Excel Bridge](/doc/docs/set-up-access-to-excel-bridge) for the provisioning steps and how long this takes. #### Can Excel Bridge be used on Excel on an iPad? No. Excel Bridge requires Microsoft 365 on a computer: version 2002 or later on Windows, or version 16.35 or later on Mac. Excel on iPad is not supported. See [Install Excel Bridge](/doc/docs/install-excel-bridge) for the full installation steps. #### Who can use Excel Bridge formulas? Only a user whose role has all three required permissions: Create Reports in Excel using the R365 Excel Add-in, View Locations, and View GL Accounts.