Power BI with your accounting data

BICharts - Sage 50 Accounts Charts of Accounts

Posted by Hugh Johnson on 19-Apr-2018 15:20:58
Hugh Johnson
Find me on:

Sage 50 Accounts OData feed for Power BI

This article describes the BICharts table in the Suntico Sage 50 Accounts OData feed in the Suntico Power BI Sage 50 integration.  This table provides a list of all of your Sage 50 Charts of Accounts.

This table is essential if you want to perform profit & loss or balance sheet analysis at the nominal account (nominal code) category level for a given specified Chart of Accounts.

BICharts table


Column Type Description
Chart Whole Number Chart number link to BICategories
Name Text Category name e.g. "Motor Expenses"
Ref Whole Number Internal reference

BICharts relationships

The BICharts table in the OData feed is related to the BICategories table as shown below.

BICharts 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?

Use free for 30 days 


Topics: Sage 50, Power BI Desktop, OData, chart of accounts

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.


  • 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