We are a service company in the events Management Industry.

The company was founded in 2019, and installed Quickbooks Essentials and Quickbooks Standard Payroll to meet its initial reporting and compliance requirements.

The company has gone from strength to strength, despite Brexit and the Covid pandemic and is now looking at upgrading its reporting requirements and has appointed a new CFO who wants to put in place the correct reporting requirements for the business going forward to ensure that management information regards the performance of the business is robust for the future, especially the exit strategy of the shareholders.

We want to set up the following reporting in Quickbooks. Normally I would set up cost centres or departments in the nominal ledger, and capture the data that way, however as i have never used quickbooks before i have discovered that cost centres and departments mean different things in quickbooks and only cover certain types of transactions, not all!

We want to report on the basis attached:

The advice received in initially from Quickbooks was to use Tag Groups and Tags, and upgrade to Advanced Payroll, however we have since been told that the initial advice from Quickbooks was incorrect & that Tag Groups and Tags are not available on advanced payroll, nor can journal postings accept tags during the postings.

As i have never used Quickbooks before, i am looking for advice as to how to utilise Quickbooks to be able to report on the business going forward. i attach a file which hopefully explains what i am looking to do.

Before i commit to upgrading to a different Quickbooks package, i just need someone, to point me in the right direction regards which "functions" are available on the different quickbook packages to allow me to capture the data in the required format to enable the above/attached to be generated, either through excel of via quickbooks reports. 

I believe the way forward might be to use the locations function but having already wasted valuable time on a dead end, getting input from my experienced peers seems the right way forward. 

Thanks 

Thanks