Using QuickBooks to prepare 2024 budgets and forecasts

As year end nears, many businesses and nonprofits are planning for 2024. QuickBooks® provides budget and forecast features to help management make financial predictions, as well as assess “what if” scenarios to help make more-informed business decisions.

Nirali Thakkar
January 8, 2024

Here’s how you can use these tools for your year-end financial planning.

Budgets vs. forecasts

The budget function in QuickBooks is typically used to manage expenditures during the year to ensure that departments and locations spend according to authorized levels. QuickBooks allows you to create a new budget from scratch. However, budgeted amounts often are based on the prior year with adjustments for new projects and expected growth.

For example, your marketing department’s salaries might be based on the prior year with adjustments for raises (if any). Suppose the department hired a new team member in October 2023. When preparing the department’s 2024 budget, you’d make an adjustment for that individual’s full-year salary based on the prorated amount from the prior year.

The forecast function is used to make projections and perform “what if” analysis. To illustrate, you might run worst, most-likely and best-case scenarios for revenue and expenses for the coming year.

For example, suppose your company plans to build a new facility in the third quarter of 2024, and you plan to finance a significant portion of the cost. Because it’s unclear whether the Federal Reserve Bank will raise or lower interest rates in the coming months, you might run multiple financing scenarios with varying interest rates. You also might vary other inputs, such as expected construction costs and revenue and expenses related to opening the new facility, when you perform your scenario analysis.

How QuickBooks features work

To access these tools in QuickBooks, select “planning & budgeting” from the company menu. A budget or forecast can be created for both the profit and loss statement (also known as the income statement) and the balance sheet. You can increase the detail of a budget or forecast by adding figures at the customer/job or class level (or both).

Each budget and forecast created is saved in a unique file and managed separately. If your organization has multiple departments or locations, you can budget and forecast using QuickBooks classes. If you track job costs, you can even prepare forecasts and budgets for individual jobs.

QuickBooks also allows you to view different sets of reports for budgets and forecasts. You can use these reports to review your entries. In addition, you can view comparisons of how the company’s budget or forecast compares to actual results for income and expenses, classes, jobs or balance sheet account balances.

There are two advanced options to consider when using QuickBooks. One is the cash flow projector; this tool also allows you to determine sources and uses of cash to plan ways to avert projected shortfalls in cash. The second is the business plan tool, which allows you to develop a complete master plan for your business.

Planning in uncertain times

Many businesses are currently facing rising costs, uncertain demand and labor shortages. In today’s volatile marketplace, preparing reports that plan for the financial future is critical to survival. It’s also important to monitor progress throughout the year — not just at year end. The hard part is creating the underlying assumptions that will drive your budget or forecast. The easy part is entering the information into QuickBooks. Contact us to help you plan for 2024 and beyond.

How to Cut Costs, Not Corners with an Outsourced CFO

How can you cut costs for your startup without hiring a full-time CFO? A fractional CFO is the answer and here’s why. 

4 NetSuite Hacks To Optimize Your Supply Chain

To gain a competitive advantage in today’s fast-paced world, you have to stay on top of supply chain challenges. Utilize these 4 NetSuite hacks to optimize your supply chain and boost your bottom line. 

7 Common Bookkeeping Mistakes That Hurt Profitability From A Fractional CFO

Are you making these seven common bookkeeping mistakes that are hurting your profitability? Follow the tips in this blog post to protect your bottom line. 

6 Budgeting Tips for Business Success from a Fractional CFO

Read these 6 budget tips to help you define a clear financial roadmap for every decision you make as a company, and to drive a culture of financial accountability. 

Top 7 Reasons Mid-Market Leaders Choose NetSuite’s Cloud ERP

If you’re managing complex financial situations on outdated systems, it’s time to upgrade to this customized-to-fit-all solution of NetSuite’s Cloud ERP. 

When Is The Right Time To Hire A Fractional CFO

When is the right time to hire a fractional CFO? When you meet at least one of these five criteria.

The 7 Best Tax Strategies for Scaling Businesses from a Fractional CFO

As a business, you want your money working for you as efficiently as possible. Follow these 7 best tax strategies to reduce tax liability and grow your business. 

5 Financial Metrics Every CEO Should Track

If you do a Google search on important financial metrics for your business, you’ll come up with dozens of “must-have” metrics. But you only need 3-5 to succeed!

10 Ways NetSuite Helps Optimize Cash Flow and Minimize Burn Rate

Are you a founder or CEO struggling with cash flow problems and an out-of-control burn rate? Read the top 10 ways NetSuite can help solve all your biggest financial problems within a single solution.

EBITDA vs. Free Cash Flow: Which Metric Matters More?

EBITDA vs. free cash flow are two financial metrics that often find themselves head-to-head for companies between $2 million and $10 million in revenue. Which is better?

3 Signs Your Business Is In Desperate Need of a Fractional CFO

Do you have leaky cash flow problems, inaccurate forecasting, and a general lack of time or money to manage your organization’s financials? It may be time to hire a fractional CFO to save your business.

Solid financial reporting can help attract debt and equity financing

Financial reporting plays a key role when a business needs funds for continued operations and strategic investment opportunities.

Did your business buy the wrong software?

No one likes to make a mistake. This is especially true in business, where a wrong decision can cost money, time and resources. According to the results of a recent survey, one of the primary ways that many companies are committing costly foibles is buying the wrong software.

Best practices for M&A due diligence

Participating in mergers and acquisitions (M&A) offers growth opportunities for businesses, but also comes with its share of risks. It's crucial for buyers to have a thorough understanding of the strengths and weaknesses of potential partners or acquisition targets before proceeding with any deals.

Perform an operational review to see how well your business is running

In the wide, wide world of mergers and acquisitions (M&A), most business buyers conduct thorough due diligence before closing their deals. This usually involves carefully investigating the target company’s financial, legal and operational positions.

Tax-favored Qualified Small Business Corporation status could help you thrive

Opting to run your small enterprise as a Qualified Small Business Corporation (QSBC) might be a smart tax strategy.

Navigating Year-End Finances: A Real Estate Broker’s Guide to Cost-Effective CPA Solutions

As a real estate broker, you're accustomed to navigating complex deals and managing a multitude of tasks. However, when it comes to managing year-end finances, even the most seasoned brokers can find themselves in murky waters

Unleashing the Power of NetSuite: Why Your Business Needs an Expert CPA Firm

In the realm of business management, NetSuite stands out as a powerful tool designed to streamline operations and enhance financial visibility.

Financial Mastery Without Full-Time Costs: The Strategic Edge of Fractional CFOs for Tech Leaders

In the ever-evolving landscape of the tech industry, where innovation is the currency of success, financial management plays a pivotal role in shaping the trajectory of your tech firm.

New Year, New Numbers: Top 10 Accounting Priorities for a Smoother Tax Season

As the calendar flips to a new year, business owners find themselves at the threshold of a crucial period—tax season

Countdown to Tax Time: Affordable CPA Strategies for E-Commerce Success

As an e-commerce business owner using the powerful NetSuite platform, the countdown to tax time can bring both anticipation and anxiety.

Key 2024 inflation-adjusted tax parameters for small businesses and their owners

The IRS recently announced various inflation-adjusted federal income tax amounts. Here’s a rundown of the amounts that are most likely to affect small businesses and their owners.

Best practices for effective board meeting minutes

If you think the recorded minutes of your nonprofit’s board meetings are just a formality, think again

Businesses: Know who your privileged users are … and aren’t

Given the pervasiveness of technology in the business world today, most companies are sitting on treasure troves of sensitive data that could be abducted, exploited, corrupted or destroyed

Accounting for M&As

Business merger and acquisition (M&A) transactions have significant financial reporting implications. Notably, the company’s balance sheet will look markedly different than it did before the business combination.

Tips for QuickBooks users: 5 mistakes to avoid during bank reconciliation

Reconciling bank accounts is critical to ensuring the accuracy of your company’s accounting records. The primary purpose of a bank reconciliation is to confirm that the transactions recorded in your bank statement match those shown in your accounting records.

Shareholder advances: Debt or equity?

From time to time, owners of closely held businesses might need to advance their companies money to bridge a temporary downturn or provide funds for an expansion or another major purchase

Revitalize Sales Strategies for the Digital Marketplace

E-commerce business owners, as the year draws to a close, you and your leadership team are likely fine-tuning your vision for 2024.

Maximizing Cash Flow in Real Estate: The Power of Cost Segregation Studies

Is your real estate business fully capitalizing on the depreciation of your property investments?

Some businesses may have an easier path to financial statements

There’s no getting around the fact that accurate financial statements are imperative for every business. Publicly held companies are required to not only issue them, but also have them audited by an independent CPA

Key Performance Indicators (KPIs) for SaaS Businesses: A Comprehensive Guide

Software as a Service (SaaS) has revolutionized the software industry. The transition from traditional software licensing models to subscription-based, cloud-hosted services offers businesses scalability, flexibility, and significant cost benefits

3 types of internal benchmarking (KPI) reports for businesses

As each year winds to a close, owners of established businesses can count on having plenty of at least one thing: information.

Are you ready for year-end inventory counts?

As year end approaches, it’s time for some calendar-year businesses to perform physical inventory counts. This activity is more than a time-consuming chore; it’s an opportunity to improve your company’s operational efficiency.