QuickBooks Online: Location and Class Reporting

logo-qbo.pngBudgeting and Report by Location and Class 

Location and Class Analysis Codes in Transactions

QuickBooks Online provides categorisation of transaction activity with a feature of Locations and Classes in transactions. Location information is entered in the transaction header ( Invoice Header, Bill Header) and Class information can be setup to be entered in the transaction header or transaction detail lines. Conceptually it looks like this.

Screen_Shot_2018-06-20_at_11.06.42_am.png  Location in Header and Class in Line Detail

 

Location and Class can be used for any type of divisional analysis sales centre, regions, activity centres in commercial organisation and programs, funding sources and grants in not for profit organisations. ( See also Analysis Code comparisons )

Transaction reporting 

Bi4Cloud provides reporting of the Location and Class in the Analyse Sales report. This permits reporting by all the transaction dimensions in various formats including Pivot by each of Location and Class.

Sales Pivot By Class vs Location - Detail Metrics

Screen_Shot_2018-06-20_at_1.14.10_pm.png

Sales Pivot By Class vs Location - Less Noise

Screen_Shot_2018-06-20_at_1.14.22_pm.png

Sales Pivot Class vs Month

Screen_Shot_2018-06-20_at_1.23.43_pm.png

Bi4Cloud provides a powerful ability to generate Profit and Loss Reports by the Location and Class. Here are some examples.

Profit and Loss Group By Class pivot by Month

  Screen_Shot_2018-06-20_at_3.43.16_pm.png

Profit and Loss Group By Class pivot by Account Group

Screen_Shot_2018-06-20_at_3.43.30_pm.png

Hierarchy in Class

Classes in QuickBooks Online can be setup to include hierarchy so that one class can be a header class for other sub-classes. In QuickBooks Online the Class hierarchy is defined in Settings > Lists > Class

Screen_Shot_2018-06-20_at_12.47.16_pm.png 

Budgeting by Class

QuickBooks Online provides facilities to enter budgets by Class or by Location. Bi4Cloud integrates the Class Budgets that are entered in QuickBooks Online. Bi4Cloud selects the QuickBooks Online budget to integrate by looking at the QuickBooks Online Budget that is within the range of the current date and and is the last one to be modified.

With Class Hierarchy and Class Budgets integrated some interesting report outcomes are possible.

P&L Account Groups pivot Class

Screen_Shot_2018-06-20_at_3.54.58_pm.png

P&L by Class pivot by Account Group - Actuals v Budgets

Screen_Shot_2018-06-20_at_3.55.11_pm.png

P&L Class pivot by Month Group By Class Level 1 - Actuals v Budgets

 Screen_Shot_2018-06-20_at_3.55.22_pm.png

Switch the Pivot from Monthly to Quarterly - Actuals v Budgets

Screen_Shot_2018-06-20_at_3.55.33_pm.png

All the standard Bi4Cloud facilities of choosing Analyse, Group and Time dimensions is available. You also have the ability to drill through to detail level on any reports without needing a login to your accounting software.

Screen_Shot_2018-06-22_at_2.40.13_pm.png

bi-logo-trans.png Reporting Functionality with Location and Class

Bi4Cloud uses a business intelligence (BI) tool to implement reports. This BI tool summarises your data in various dimensions of the underlying Accounting system. You can choose the dimension to Analysis, Filter by or Group by which gives you complete report flexibility.

This is represented schematically here.

Screen_Shot_2018-06-20_at_11.15.15_am.png

 

Sign up for your free 14 day trial of Bi4Cloud.com and try it with your QuickBooks Online company.

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Please sign in to leave a comment.

Powered by Zendesk