General Ledger & Accountant

The QQube Data Warehouse connects to QuickBooks to extract relevant general ledger and fixed asset information into multiple data models for generating a variety of custom general ledger and accountant reports:

• Trial Balance – Assembles information from Estimates, Actuals, Payables, Receivables, Payroll, Committed Costs and more.
• Trial Balance Activity – A stand-alone data model for convenience, but also included in Job Cost Details.
• Trial Balance Activity by Class – A stand-alone data model for convenience, but also included in Job Cost Details.
• General Ledger Detail – Convenient way to compare budget and actuals for profit and loss accounts in job cost reports.
• Profit and Loss Detail – Compare budget and actuals for profit and loss job accounts with classes by column or rows.
• Cash Position – Compare budget and actuals for profit and loss job accounts with classes by column or rows.
• Fixed Assets – Compare budget and actuals for profit and loss job accounts with classes by column or rows.

Many of the report examples we include are not even available in QuickBooks such as Trial Balance Activity by Class side by side for 36 months or the ability to have Invoices and Payments in your General Ledger, one underneath one another.

Each data model has hundreds of fields that you can drag and drop in the tool of your choice to create any type of custom accountant or general ledger report. We include starter examples in the QQube Configuration Tool for Excel, PowerPivot, Power BI, Tableau, Crystal Reports, and Access.

There is no need to deal with tables, relationships, or data dictionaries