Power BI with your accounting data

BINominalBudgets - Sage 50 Accounts Nominal Budgets

Posted by Hugh Johnson on 19-Apr-2018 15:44:22
Hugh Johnson
Find me on:

Sage 50 Accounts OData feed for Power BI

This article describes the BINominalBudgets table in the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.  This table provides a list of all of the nominal budgets for each of the nominal accounts and for each accounting period 1 thru 12.  Note that these periods refer to the months of the currently open financial year in Sage 50 and may not necessarily be the same as the periods of the current financial year if the company (for example it the previous year has not yet been closed off in Sage 50 Accounts).

This table is essential if you want to compare actual vs budgeted performance by nominal code.  This table does not hold the breakdown on nominal code budgets by department.

BINominalBudgets table

 

Column Type Description
BudgetID Text Unique record reference
AccountRef Text Link to nominal account
Period Whole Number Accounting period 1 thru 12
Budget Decimal Number Budget for the account and period
Prior    
Balance    

BINominalBudgets relationships

The BINominalBudgets table in the OData feed is related to the BINominalRecords table as shown below.

Nominal Budgets relationships in Sage 50 Accounts

 

 

To try our this OData feed for your Sage 50 Accounts data, why not create your own Suntico BI trial account?

Create Suntico BI Trial Account 

 

Topics: Power BI Desktop, OData, nominal records, Sage 50 Accounts, nominal budgets

Power BI with your accounting data

Time-saving tips, tricks, templates and tutorials

Subscribe to this blog for practical shortcuts to driving real insights from your accounting data with Power BI.

Expect:

  • How-to videos
  • Example reports
  • Sample formulae
  • Data modeling tips
  • Free Power BI templates
  • Tips for optimising Sage 50cloud

Subscribe to Email Updates

Recent Posts