Sage 50cloud Accounts - what is it?

Power BI

Sage 50cloud Accounts - what is it?

Sage 50cloud Accounts, formerly known as Sage 50 Accounts is the most widely-used accounting software in the UK and Ireland by businesses with between 10 and 100 employees. Sage claims that over 400,000 businesses use Sage 50cloud Accounts.

What is Sage 50cloud Accounts?

Sage 50cloud Accounts is the latest name for Sage 50c Accounts, that was formerly known as Sage 50 Accounts and before that Sage Line 50.  It is a desktop accounting product family published by Sage Group plc primarily for the UK and Irish markets. 

Accounts Receivable - what they are and why they are important

Accounts Receivable

Accounts Receivable - what they are and why they are important

What are trade receivables or accounts receivable? Why are they important? Who should know about them? When and how should you track them?

What are Accounts Receivable (aka Trade Receivables)?

Accounts Receivable (also known as Trade Receivables) are monies owed to you by customers whom you have invoiced for products or services supplied but for which you have not yet received payment.  Your Trade Receivables are an asset (since you expect to receive cash from them) and in your accounting software, your total trade receivables will be the balance of your Debtors Control Account on your Balance Sheet. 

BIMetaData - Sage 50 Accounts - data about your data

Power BI

BIMetaData - Sage 50 Accounts - data about your data

Details about the BIMetadata table in the Suntico BI data feed for Power BI. Use this table to see in an instant how fresh your Sage 50 Accounts data is on Power BI. You can use Suntico BI to set up your Sage 50 Accounts system as one of your Power BI data sources. Why not try it now?

Sage 50 Accounts OData feed for Power BI

The BIMetaData table is part of the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.  This table provides data about your Sage 50 dataset and your Suntico subscription.  Use this table to determine how up-to-date your Sage 50 dataset is in Power BI.

BIDepartments - Sage 50 Accounts Departments list

Power BI

BIDepartments - Sage 50 Accounts Departments list

Details about the BIDepartments table in the Suntico BI data feed for Power BI. This table provides a list of your Sage 50 Accounts Departments. You can use Suntico BI to set up your Sage 50 Accounts system as one of your Power BI data sources. Why not try it now?

Sage 50 Accounts OData feed for Power BI

This article describes the BIDepartments table that forms part of the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.    The table provides a list of all of your Sage 50 Departments.

It is related to the BITransSplits so that if you can produce Departmental Profit & Loss reports if this is how you are using Sage 50 Departments.  You can also use this table to produce a list of Departments used in your Sage 50 system. 

BINominalBudgets - Sage 50 Accounts Nominal Budgets

Power BI

BINominalBudgets - Sage 50 Accounts Nominal Budgets

Details about the BINominalBudgets table in the Suntico BI data feed for Power BI. Use this table to track your performance against budget for each nominal code. Why not try it now?

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.

BICategories - Sage 50 Accounts Nominal Categories

Power BI

BICategories - Sage 50 Accounts Nominal Categories

Details about the BICategories table in the Suntico BI data feed for Power BI. This is the list of all of your Sage 50 Accounts Nominal Categories. You can use Suntico BI to set up your Sage 50 Accounts system as one of your Power BI data sources. Why not try it now?

Sage 50 Accounts OData feed for Power BI

This article describes the BICategories table that forms part of the Suntico Sage 50 Accounts OData feed for that you have set up as one of your Power BI data sources.  This table provides a list of all of the nominal categories for each chart of accounts that you have defined in Sage 50 Accounts.

This table is essential if you want to perform profit & loss or balance sheet analysis at the nominal account (nominal code) category level.

BINominalRecords - Sage 50 Accounts Nominal Records

Power BI

BINominalRecords - Sage 50 Accounts Nominal Records

Details about the BINominalRecords table in the Suntico Sage 50 Accounts OData feed for Power BI. Use this table for profit & loss or balance sheet reporting - actual or against budget. It contains a full list of your Sage 50 Accounts Nominal Records, including nominal code and balance.

Sage 50 Accounts OData feed for Power BI

The BINominalRecords table is part of the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.  This table provides a list of all of the nominal accounts (sometimes called "general ledger accounts") that form the company's chart of accounts.

This table is essential if you want to perform profit & loss or balance sheet analysis.  

BIPurchaseOrderLines - Sage 50 Accounts Purchase Order Lines table

Power BI

BIPurchaseOrderLines - Sage 50 Accounts Purchase Order Lines table

A description of the BIPurchaseOrderLines table details in the Suntico Sage 50 Accounts OData feed for Power BI. This table contains all of your Sage 50 Accounts Purchase Order Lines from your Sage 50 POP module. Why not try it now?

Sage 50 Accounts OData feed for Power BI

This article describes the BIPurchaseOrderLines table in the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.   This table is derived from the underlying Sage 50 Accounts POP_ITEM ODBC table. 

This table is essential if you want to analyse your Sage 50 Purchase Orders at the product line item level.

BIPurchaseOrders - Sage 50 Accounts Purchase Orders table

Power BI

BIPurchaseOrders - Sage 50 Accounts Purchase Orders table

Description of the BIPurchaseOrders table in the Suntico Sage 50 Accounts OData feed for Power BI. This table is the header information for all of your Sage 50 Accounts Purchase Orders in your POP module. Why not try it now?

Sage 50 Accounts OData feed for Power BI

This article describes the BIPurchaseOrders table in the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.  This table is derived from the underlying Sage 50 Accounts PURCHASE_ORDER ODBC table. 

This table is essential if you want to analyse your Sage 50 Purchase Orders.

BISupplierCurrencies - Sage 50 Accounts Supplier Currencies table

Power BI

BISupplierCurrencies - Sage 50 Accounts Supplier Currencies table

Details of the BISupplierCurrencies table in the Suntico Sage 50 Accounts OData feed for Power BI. This table provides the currency information for all of your Suppliers accounts in Sage 50 Accounts. Use this table if you want to analyse purchases by currency. Why not try it now?

Sage 50 Accounts OData feed for Power BI

This article describes the BISupplierCurrencies table in the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.    This table is a duplicate of the BICurrencies table and included to avoid relational ambiguity between BISuppliers, BICustomers and BITransSplits.

This table is essential if you want to analyse your Sage 50 purchases by currency.

Copyright © 2019,
Accounting Insights Ltd.
All Rights Reserved.

Our Office :
Unit 4, Roof Garden Offices,
Clarehall Shopping Centre,
Dublin,
Ireland
+353 1 567 4069
contact@accountinginsights.co.uk