QQUBE and AHA – better together
The screen shot shows a chart of accounts that is mapped into different groupings for reporting. In order to 'map' an account you simply drag the account from the Accounts to be mapped over to a row in the reporting model. You can even select more than one account to move.
Aha! enables you to build new reporting models connected to your existing information.
Step # 1 - Build or select a new hierarchy
Reporting Model - A list of groupings that are used to subtotal detailed values.
We have a number of reporting models to choose from and we also allow you to build or import your own reporting model.
Not familiar with QQUBE ?
QQUBE is an incredible tool that pulls ALL of your information out of QuickBooks DESKTOP, makes it available for reporting of all kinds and comes with LOTS of prebuilt templates. Companies interested in reporting QuickBooks data in Power BI, QQUBE is your best solution.
Step # 2 - Select and map your existing list items to where you want to report them in the new
reporting model
The screen shot shows a simple example in Power BI using the QQUBE general ledger detail template with the AHAACCTS added and mapped to the general ledger detail. The left hierarchy is a simple gaap financial hierarchy added and the hierarchy on the right is the same data using a custom gross margin reporting model. This same Power BI model also allows you to toggle to Schedule C Rollup subtotals.
Step # 3 - Use the file saved by aha in your reporting tool of choice to bring in the new subtotals (Power Bi shown here)