Budgets by Class
Learn how to create budgets subdivided by class or department in Reach Reporting.
Creating Budgets by Class in Reach Reporting
Reach Reporting offers multiple ways to create budgets by class or department, allowing you to subdivide your financial planning for more granular analysis. Whether you're using our native Budgets Pro feature or uploading Excel templates, you can create detailed budgets that break down performance by different business units.
Budgets Pro Budget by Class
Excel Class Budget
Option 1: Budgets Pro with Class Subdivision
Step 1: Create a New Budget
- Click the Budgets section in the left menu
- Select Create New
- Choose the statements you want to budget for
- Ensure your main bank account is selected
Step 2: Enable Class Subdivision
- Enable the Subdivide by Class or Department option
- Select the specific classes or departments to include in your budget
- Note: Budgets Pro with Class Subdivision is only available for the Profit and Loss and is not available for the Balance Sheet and Cash Flow.
- Note: Budgets Pro can handle up to 10 classes or departments at a time. Classes and departments cannot be combined in Budgets Pro. You can either create a budget with just classes or just departments.
- Need more than 10 classes or departments? Email us at support@reachreporting.com for more information.
- Important: Budgets Pro cannot handle subclasses - only parent classes
Step 3: Configure Settings
- Set the budget range and prefill the budget if desired
- Name the budget and click Create
- The creation process may take longer depending on the number of classes included
Step 4: Working with Subdivided Budgets Once created, you'll notice:
- A funnel icon next to the budget name, indicating it's subdivided
- The settings panel opens automatically with detailed options
- Note: Subdivided budgets cannot be converted to normal budgets, and vice versa
Step 5: Navigation and Features
- Use the dropdown menu next to the Profit and Loss tab to switch between classes
- The Profit and Loss total view is read-only and aggregates all subdivisions
- Balance Sheet and Cash Flow tabs function normally with a single shared view
- The Data Sheet provides a single shared view for the entire budget
- An Unspecified option handles unclassed data and classes not included in the subdivision
Step 6: Row Drivers and Management
- Each row driver is tied to individual subdivisions
- Apply specific drivers to selected classes or use different drivers for the same account across classes
- Row structure and comments apply across the entire budget
Option 2: Excel Class Budget Upload
Step 1: Create Template
- Click Budgets Forecast on the left-hand side
- Click Create New and choose Use Excel
- Select statements, budget date range, and pre-fill options
- If pre-filling, you can filter by any loaded classes from a previous period
- Click Download Excel Template
Step 2: Modify Template for Classes
- Add a row at the top after the heading row labeled Class ID
- Use this row to identify classes exactly as they appear in QuickBooks
- For subclasses: Enter the subclass name as the Class ID (Excel budgets support subclasses)
- Note: QuickBooks will display subclasses as “Parent Name: Sub Name”. You do not need to enter “Parent Name: Sub Name” as the Class ID. Instead, just enter “Sub Name” as the Class ID
- Copy the template block for each class you want to budget for
- Adjust numbers for each account and month per class
Step 3: Upload and Use
- Save your modified Excel file
- In Reach, click Choose File and select your Excel budget
- Give it a name - you'll see an Excel icon indicating the file type
- Reach automatically combines all classes to create a consolidated budget
Key Differences
Budgets Pro:
- Maximum of 10 classes or departments, with an option to add up to 25
- Cannot handle subclasses - only main classes
- Native integration with advanced subdivision features
- Cannot convert between subdivided and normal budgets
Excel Class Budgets:
- Can handle subclasses - enter subclass name as Class ID
- More flexible for complex class structures
- Requires manual template modification
QuickBooks Online and Xero Budgets:
- Can handle subclasses when pulled directly from QBO or Xero
- Automatically syncs with your QBO or Xero budget structure
Using Class Budgets
When building statements or metrics with class budgets:
- A funnel icon appears above budget columns
- Filters work the same as actual data with classes
- Can be applied to both columns and rows
- Features carry through to consolidations
Class budgets provide powerful insights for departmental performance analysis, cost center management, and multi-location businesses. Choose the method that best fits your organizational structure and reporting needs.
If you have questions about budgeting by class, feel free to send us a chat!
Go to the Reach Reporting app>
ARE YOU NOT CURRENTLY USING REACH REPORTING?
learn more at reachreporting.com
We are dedicated to helping you.
- Need Additional Help?
Your success is important to us.
Whether you're working as a CFO of a business or part of an accounting firm, Reach Reporting is here to improve your working knowledge of reporting and provide service tips and skills to ensure you're at the top of your game.
We make sure that you have access to staff members that are best suited to help you. We work together to resolve issues and create memorable moments that empower you to enhance your reporting skills.
We are here to listen to you. We understand that using new technology can be frustrating, so we can answer questions or jump on a quick zoom call. Our entire staff has an in-depth knowledge of Reach Reporting and can quickly direct you to best practices to improve your reporting.
We are here focused on providing solutions that save you time and increase your value. We continue to improve each day and look forward to visiting with you. Your communication with us is vital and appreciated.
Please feel free to chat with us by clicking the help chat bubble in the lower right-hand corner of this page.
Reach out to your Reach Reporting Rep and schedule a zoom meeting by clicking the meeting link in their email signature.
Or schedule to join our onboarding webinars
Reach Reporting is dedicated to helping provide a knowledge base that is easy to understand and informative. If you still have questions that have not been answered, please let us know by emailing support@reachreporting.com, chatting with our support team, or calling us at (877) 467-7637. We are here to ensure that you have a positive experience with Reach Reporting, as we want to continue to be the reporting solution you trust.
Need more access to Reach Reporting Resources?
Reach Reporting has a wealth of knowledge and a robust online community to support you as you create reports that provide powerful insight. Please look into the following resources.
Reach Reporting Blog: We add blogs to our site every month to give you great information in a fun and friendly manner.
Case Studies: We interview one company per month to help our clients highlight how they are using Reach Reporting and how it is improving their services and firm offerings. These case studies are invaluable to our community.
Knowledge Center: From simple to complicated, we provide step-by-step guidance to utilize every aspect of Reach Reporting in our robust knowledge center.
Video Tutorials: We know watching is sometimes easier than reading, which is why all of our tutorials are video-based in the video tutorial section of Reach Reporting and Youtube.
Social Networks: Join us on FaceBook, LinkedIn, Youtube, and Twitter.
Competitor Comparisons: We have looked at all the reporting solutions on the market. We provide you with an in-depth look at Reach Reporting compared to some of the strongest competitors out there on our competitor comparison page.
Monthly Newsletter: Go to the footer of reachreporting.com and sign up to receive the Reach Reporting newsletters delivered directly to your inbox. Our newsletters cover tips and tricks, current events in accounting, strategies to improve your advisory services, and much more.
We look forward to helping you build insightful reports,
The Reach Reporting Team.