Are you moving from QuickBooks Desktop to QuickBooks Online and find some reporting functionality you rely on is now missing?
BI4Cloud Business Intelligence is a 3rd Party App on the QuickBooks App Store which allows you to easily create your own, very flexible and customized reports that will fill that gap.
1. Income Statement Format for Month End Reporting
Bi4Cloud Business Intelligence includes as standard, a Profit & Loss statement that shows the following columns for you to choose from:
- Actual vs Budget
- Month To Date vs Year To Date vs Last Year
- Full Year Budget vs Forecast where Forecast = BudgetFullYear - ActualsYTD
- Full Year Budget vs ReForecastNew where ReForecast is a second Budget
- uses QuickBooks multiple Budgets. ReForecast uses the last entered Budget
- Rows can be By Account or Summary P&L
- Filter to run By Class or Location
- Consolidate Multiple QuickBooks Online files together and report over the group
Below is an example of this report displaying all possible columns.
See this link for more details P&L Forecast - Ultimate Month End
2. Create your own Flexible Account Groups and Chart of Accounts (COA)
Do you find the the standard GL account structure (COA) in QuickBooks Online is too rigid and does not allow you to create a summary Income Statement or Profit & Loss?
BI4Cloud Business Intelligence allows QuickBooks Online users to:
- Create new GL Account Groups and Headers e.g. Sales & Marketing Costs
- Drag & drop GL Accounts to re-arrange them under the new Account Groups
e.g. arrange the following accounts under the new Account Group- Advertising
- Sales Commissions
- Google Adwords
- Drag & drop GL Accounts to re-arrange the order they appear in the Income Statement
- Filter to run By Class or Location
- Consolidate Multiple QuickBooks Online files together and report over the group
See this link for more details Flexi Levels - Reorganise Sort and Group your Accounts
Flexi Levels is available in the Cool Stuff (Enterprise 5 user) version of BI4Cloud.
3. Free Trial
Sign up for a BI4cloud 14 Day Free Trial running on your QuickBooks Online file now.