In Beta
This feature is in beta. Contact your CSM to learn more.
The R365.BUD formula pulls Reporting Budget amounts from R365 into Excel. It compares actual spending against plan, tracks budget consumption by period, and builds variance reports inside a workbook the user controls, without exporting a canned report each time the user needs updated numbers. Because it is a formula, it can be combined with other Excel calculations, placed into an existing template, or refreshed for the whole workbook with one click. See Install Excel Bridge before writing a formula for the first time.
R365.BUD supports one location per formula in this release. It does not support legal entities, proration across periods, or multi-location budgets. The budget being pulled must be a Reporting Budget, with the Reporting Budget checkbox enabled in R365.
Enter a Formula
Click a cell and type
=R365.BUD(.
Excel lists R365.GL and R365.BUD under User Defined Functions while typing.Review the argument hints.
Excel showsR365.BUD(accounts, location, startDate, endDate). All four arguments are required.Complete the formula and press Enter. The cell shows an hourglass.
In the task pane, click Refresh Sheet or Refresh Workbook.
The cell fills in, and Sheet / Workbook last updated shows the refresh time. This can be earlier than when you clicked Refresh Sheet / Workbook.

The task pane must stay open and signed in while working. Formulas get data only after the user clicks Refresh Sheet or Refresh Workbook; the task pane also adds quotes around unquoted dash numbers and dates automatically.
What R365.BUD Returns
R365.BUD returns the total Reporting Budget amount for the listed accounts at one location for a date range, as a number. It uses the same accounting sign as R365.GL: a revenue account returns a negative number, and an expense account returns a positive number. A valid account with no budget returns 0, not an error. Data can be up to about 15 minutes behind R365. Data last updated in the task pane shows when R365 last updated the reporting data. A formula returns data only for the accounts and locations the user's role can access.
R365.BUD accepts multiple accounts and one location
R365.BUD accepts one or more accounts: a single account number, a comma-separated list, or a range using a colon. Put lists and ranges in quotes. It accepts only a single location number, not a list or range.
Syntax
=R365.BUD(accounts, location, startDate, endDate)
Argument | Required | What to enter | Examples |
|---|---|---|---|
accounts | Yes | One account number, a comma-separated list, or a range using a colon. Put lists and ranges in quotes. Up to 350 accounts per formula. |
|
location | Yes | One location number only. Lists and ranges are not supported.
|
|
startDate | Yes | A date. |
|
endDate | Yes | A date. |
|
Important — Argument order is fixed: Accounts, location, start date, end date.
R365 Tip
To see a description of each argument while building a formula, click Insert Function to open the Function Arguments dialog (Windows) or Formula Builder (Mac). Arguments can be entered on this dialog as well as directly in the cell.
How date ranges work
R365.BUD matches budget data by end date: it includes in full any week or period whose end date falls inside the requested range, and excludes entirely any week or period whose end date falls outside the range — it never prorates budget amounts. For example, if a weekly budget period runs Monday through Sunday and the request covers January 1–7, R365.BUD includes the entire week's budget if Sunday, January 7, is the end date; setting the end date to Saturday, January 6, excludes that week.
Accounts
Account order in the formula does not affect the result, and a duplicate account counts once. A range such as "5000:5999" includes only accounts that actually exist in R365, not every number in the sequence — a statistical account inside a range is skipped without an error. Every listed account must exist in R365, be visible to the user's role, and not be a statistical account; if a listed account fails any of these checks, the entire formula returns an error.
Examples
Goal | Formula |
|---|---|
One account, one location, one month |
|
Account range, one location, a quarter |
|
Several accounts, one location, dates from cells |
|
Limits
A formula can cover up to 350 accounts by default. Each refresh can calculate up to 1,000 Excel Bridge formulas, R365.GL and R365.BUD combined.
Refresh Sheet counts the formulas on the sheet in view. Identical formulas in the same workbook count once. Formulas in other open workbooks do not count toward this limit. When Refresh Workbook is selected, all formulas across the workbook are refreshed.
When a refresh is over the limit, the task pane shows a message. The message gives the number of formulas and suggests moving some to another workbook. A company that needs a higher limit can ask R365 Support, who will determine whether it can be raised.
Budget vs. Actual
To compare budget against actual in the same sheet, use both formulas for the same account, location, and date range.
For a like-for-like comparison, use dates that match the start and end of your budget periods.
Column | Formula |
|---|---|
Actual |
|
Budget |
|
Cell Errors
When a formula cannot return a number, the cell shows an error message as text. SUM skips these cells.
Formula Problems
Message | What to do |
|---|---|
Account numbers are required | Enter an account number in the first argument. |
Invalid account range notation | Use the form |
Start date must not be after end date | Swap the dates. |
Error: Start date is not a valid date. Use "mm/dd/yyyy" or "mm-dd-yyyy". | Use |
Invalid start date / Invalid end date | A quoted date was not read as a valid date when the formula refreshed. Use |
Account range start must not be greater than end | Put the lower account number first. |
Error: This formula requests more than 350 GL accounts. Split it into several formulas. | Split the formula into smaller account sets. |
Location is required | Enter one location number. |
BUD() supports a single location only | Use one location per formula. |
Start date is required / End date is required | Enter both dates. Both are required for R365.BUD. |
No period or week ends within this date range. | Widen the range to include the end of at least one budget period or week, or check that the location has a Reporting Budget for that year. |
Error: {value} is not a valid start date. | A whole number landed in a date argument, usually because a list of accounts or locations isn't in quotes. Put lists in quotes. |
Fiscal year {year} is not configured for this location | Check that the fiscal year is set up in R365 for that year, or change the date range. |
No matching data
Message | What to do |
|---|---|
Error: The formula includes a value/range with no matching GL Codes | Check each account number and range. Every listed account must exist, be visible to the user's role, and not be a statistical account. |
Error: The formula includes a value/range with no matching locations | Check the location number. |
Failed to retrieve data. | The financial reporting database may not be provisioned. Reach out to your CSM. |
The cell shows #ERROR and the message appears in the task pane. Your role needs the View Locations and View GL Accounts permissions to use R365 Excel Bridge. Ask your administrator to add them to your role. | Ask an administrator to add the permission. Changes can take up to 5 minutes to apply. |
Access Issues
Message | What to do |
|---|---|
The cell shows #ERROR and the message appears in the task pane. Your role needs the View Locations and View GL Accounts permissions to use R365 Excel Bridge. Ask your administrator to add them to your role. | The task pane message names only the permission that's missing. Ask an administrator to add it to the role. Changes can take up to 5 minutes to apply. |
Excel Formula Errors
Error | Cause | What to do |
|---|---|---|
#VALUE! | The formula has more arguments than R365.BUD accepts. This usually happens because a list of accounts is not in quotes, so Excel reads each one as a separate argument. | Put lists of accounts in quotes, for example |
#NAME? | Excel does not recognize R365.BUD. | Reselect the add-in: Home > Add-ins > Advanced… > SHARED FOLDER, select R365 Excel Bridge, then click Refresh Sheet / Refresh Workbook. |
#CALC! | An account range is not in quotes, so Excel tries to calculate it instead of reading it as text. | Put the range in quotes, for example |
#REF! | A cell reference in the formula points to a deleted or moved cell. |
See Excel Bridge Troubleshooting for errors that are not specific to this formula, such as task pane messages and connection errors.
FAQ
Why does R365.BUD return 0 instead of a dollar amount?
R365.BUD returns 0 when a Reporting Budget period or week ends inside the date range but has no budgeted amount for those accounts at that location. Sometimes no Reporting Budget period or week ends inside the range at all, for example because the location has no Reporting Budget for that year. In that case, the cell shows No period or week ends within this date range. instead of 0. See Excel Bridge Troubleshooting for other reasons a formula might not return the expected value.
Why does my formula show #NAME? instead of a result?
#NAME? means Excel does not recognize R365.BUD, usually because the add-in is not loaded for that workbook. Reselect the add-in from Home > Add-ins > Advanced... > SHARED FOLDER, choose R365 Excel Bridge, then click Refresh Sheet or Refresh Workbook. See Install Excel Bridge if the add-in is not listed there at all.
Can R365.BUD pull budget data for more than one location in a single formula?
No. In this release, R365.BUD supports one location per formula.
What happens if my formula includes an account number that does not exist in R365?
If any listed account doesn't exist, isn't visible to the user's role, or is a statistical account, the entire formula returns an error instead of skipping just that account. Check each account number and range against what is accessible to the user's role. See Excel Bridge Troubleshooting for the full list of formula error messages.
