This guide outlines how BI4Cloud processes multi-layered budgets and live monthly forecasts across diverse cloud accounting platforms.
1. Multi-Layered Budget Tracks (Budget vs. Reforecast)
Unlike native accounting systems that restrict users to one static annual layout, BI4Cloud supports an active Budget layer and an independent Forecast/Reforecast layer running concurrently across all ledger accounts.
- Application: Ideal for Not-for-Profits adapting to milestone grant funding adjustments mid-year.
- Deep-Dive Instructions: Learn how to configure Dual-Layer Budget Streams in BI4Cloud.
2. Platform-Agnostic Divisional Mapping
BI4Cloud normalizes transactional dimensions smoothly across different platforms, preserving structural layouts without requiring backend modifications. See Monthly Divisional Budgets for overview and setup. Platform specifics :
- MYOB Integration: Maps directly to MYOB Jobs and Categories to apply granular targets. See our MYOB Budget Setup Guide.
- Xero Tracking Categories: Parses custom hierarchical levels automatically via standard delimiter naming formats. See our Xero Tracking Category Hierarchy Guide.
- QuickBooks Online Classes: Aligns monthly operational performance metrics to QBO Classes and Locations. See our QBO Class Budgeting Guide.
If you don't have Divisions Setup ( Jobs, Classes or Tracking Categories) and coded transaction to these then you can still do Divisional Reporting by using Bi4Cloud GL Tags which map GL Accounts and implements Divisions.
3. Microsoft Excel Round-Tripping (Import / Export)
Finance teams can skip manual web-form entry processes entirely. BI4Cloud supports direct spreadsheet export, enabling complex formula modifications within Excel before importing the update seamlessly back into the live dashboard.
- Step-by-Step Workflow: Review the Excel Export and Import.