Use Power BI to drive compelling accounting insights and reports

Accounting Insights provides Power BI templates, connectors, Power BI training and and report development for finance professionals.

  1. Power BI Templates accelerate your report development

  2. Connectors for report automation

  3. Power BI Training specifically for accountants

  4. Report development services – contact us for a quote

Free Sage 50 Accounts Connector now available
Home 4
Financial Controllers

Build flexible, automated, finegrained,  monthly management reports with engaging visuals

Business Owners

Get the precise reports that you really need to manage your business, wherever you are


Grow advisory services and client engagement with online Power BI reports, for clients and sectors

How our customers use Power BI for their accounting insights

Accounting Insights has helped companies to use Power BI to solve a wide range of reporting needs. Here are some examples:

Product demand forecasting

If you are in the wholesale business, your business model may be all about being able to deliver products at short notice, and in the right format and quantity, to your customers.  Perhaps you purchase on long lead-times. Competition is tough and margins are always under pressure. Critical to your business model is to forecast product demand by SKU, perhaps 3, 4 or 5 months ahead.

By holding a rolling 2-year sales history in your Power BI model you can project forward your sales by SKU, taking into account underlying sales trends as well as seasonality.

Home 5
Home 6

Continuous Sales Reporting

Keeping momentum up in a sales team can be hard, but with a good sales reporting model in Power BI, you can do a number of things to change this.

Why not publish live sales data to a screen in your sales room?  Let the heroes of the day be recognised. See how each sales rep is performing against target, as it happens.

Add some objectivity to your sales meetings, not only based on what has happened, but also based on some objective forecasting.  Identify any change in customer buying patterns as it happens, perhaps to trigger that sales call that is needed.

Event Profitability

If you are in the events or hospitality business, you may want to look at you profit & loss around particular days or events.  For example a hotel running a wedding may want to look at certain profit & loss elements just for the period of the event. What is the overall impact of the event on the hotel profitability for those days?

A well-constructed model in Power BI will let you do this, potentially pulling in information from a number of sources such as your bar POS system, staff rostering system as well as your accounting software.

Home 7
Home 8

P&L and variance reports

P&L variance analysis is so much easier to do in Power BI than you are probably used to with other methods.  

Firstly, through its tight integration with Excel, Power BI offers you very flexible ways firstly to set your budgets and then to track them against actual.

Very powerful visualisation options mean that you can pack a wealth of variance analyses onto a single-page report: actual vs budget, actual vs last year or previous month.  Flip between a monthly view or year-to-date; between absolute or % variance. Track variance against previous periods, budgets, and forecasts all in one place.

Accounts Receivable

Accounts receivable reporting is a very popular use for Power BI.  It is a very simple solution to implement and can deliver a high return on investment very quickly.  

The power comes from having all of your receivables data together in a single model that you can then view from a number of different contexts.  

See the big picture, current health of your receivables position.  Forecast cash expected this month based on the current receivables profile and customers histories.  Identify specific customers and receivables that need action. Examine company and debtor trends. Drive down receivables and improve your cash flow.

Home 9

Power BI Training & Specialist Courses

Instructor: Hugh Johnson

Power BI Financial Data Analyst Bundle for Sage 50 Accounts

Course Code: PBIDSage50AnalystBundle

This bundle delivers a combination of training, a ready-made Sage 50 Accounts financials template, and ongoing mentoring. 

  • Power BI Desktop Financials for Accountants (5 x 4-hour modules – public course, max class size of 6) 

  • Get and Transform your Sage 50 Accounts data in Power BI Desktop (2 x 4-hour modules – public course, max class size of 6) 

  • Power BI Financials Template for Sage 50 Accounts 

  • 8 hours one-to-one ad-hoc mentoring (to be used within 12 months) 

If purchased separately: £2,960 

1,960/ Bundle

Enroll Now
Power BI Desktop Training Bundle for Sage 50 Accounts Users

Course Code: PBID-Sage50TrainingBundle 

This bundle delivers the following training courses:

  • Power BI Desktop Financials for Accountants (5 x 4-hour modules – public course, max class size of 6) 

  • Get and Transform your Sage 50 Accounts data in Power BI Desktop (2 x 4-hour modules – public course, max class size of 6) 

If purchased separately: £1,440

1,200/ Bundle

Enroll Now

Starter Plan



Expandable RAM

Fixed Memory – 1GB

Memory Cache

512 MB

Number of Visits


SSL Certificate




Priority Support

SLA – 48 hours

“Power BI has huge potential to transform financial reporting over the next decade….we have been able to create multiple reports in Power BI, including a new debtors report which has significantly improved cash-flow and reduced our debtor days…we see Accounting Insights as a key part of this revolution.“

John Glasgow
Financial Controller at The Berkley Partnership

Subscribe for updates, news & offers.

Privacy Settings
We use cookies to enhance your experience while using our website. If you are using our Services via a browser you can restrict, block or remove cookies through your web browser settings. We also use content and scripts from third parties that may use tracking technologies. You can selectively provide your consent below to allow such third party embeds. For complete information about the cookies we use, data we collect and how we process them, please check our Privacy Policy
Consent to display content from Youtube
Consent to display content from Vimeo
Google Maps
Consent to display content from Google
Consent to display content from Spotify
Sound Cloud
Consent to display content from Sound
Cart Overview