Best Practices For Budgeting In QuickBooks | Planergy Software (2024)

Why are budgets important?

Creating a budget is an important part of managing your business properly. Creating a budget is a necessity for properly planning finances while helping to ensure your business can meet existing financial commitments. Creating a budget also helps businesses plan for additional future expenses.

There are numerous budgets that business owners can create, depending on the needs of the business. But whether you’re asmall businessor a Fortune 500 company, you’ll need to create a yearly budget foryour company. Of course, a single budget may be sufficient for smaller companies, but larger businesses will need to create additional budgets such as departmental, project, or even location.

You’ll also want to consider creating monthly and quarterly budgets, so you’ll need software that can do that as well.

Budgets must include fixed costs such as facility rent and insurance, variable costs including labor and materials, and any one-time costs that are expected such as funding for a special project. When preparing a budget be sure to includecash flowestimates as well as any expected profits for the upcomingfiscalyear.

The easiest way to create a budget for your business is to use software that can assist in the budget creation process. Using software will also allow you to properly track income and expenses against the created budget, making it easy for business owners, managers, and CFOs to review budget totals versus actuals. In addition, using accounting orbudgetingsoftware will provide you with a warning when an expenditure puts you in danger of exceeding your budget.

For example, when you create your budget in November, the monthly rent for your office space was $850 per month, so you budgeted $10,200 for rent expenses for the coming year. However, on December 31, your landlord increased your rent to $1,200 per month, meaning that you’ll quickly approach your budgeted amount much earlier than you expected. If you have goodbudgetingsoftware, you’ll be given a warning when you approach the $10,200 total that you included in your budget.

Usingbudgetingoraccounting softwarecan also help to minimize errors that can commonly occur when using spreadsheets instead ofbudgetingsoftware to create a budget.

What is the difference betweenbudgetingandforecasting?

In many cases,budgetingandforecastingterms are used interchangeably, since both look at past company performance and estimate performance for an upcoming period. However, even with all the similarities, there are some subtle differences. Budgets are usually created using historic financial data, while forecasts typically look forward to predicting future performance.

For example, while budgets are primarily used as a summary outline for future business performance, forecasts are used to indicate how your business is performing, and whether it’s reaching itsbudgetinggoals. Though the differences are small, if you’re torn between the two, you may find that creating a financial forecast for your business is more useful for longer projections, while a budget can be the more useful tool for businesses that need to adhere to a strict financial plan. However, when used together, they can bring the most benefit.

What are the different types of budgets?

There are many different types of budgets that you can create. The most common budgets used by companies include an operating budget, a financial budget, and a master budget.

A financial budget predicts income and expenses for a specific period. Financial budgets are typically prepared monthly, quarterly, or yearly, depending on the needs of the business. For organizations that struggle to managecash flowproperly, preparing a financial budget can be helpful.

An operating budget offers a detailed projection of company revenue and expenses for the coming year. Typically created at year-end using data from the year, an operating budget is typically static and used to compare the budget to actual totals throughout the year. Operating budgets can also be adjusted mid-year if any unexpected revenue or expenses occur.

A master budget includes all lower-level budgets that have been prepared for your business including both operating and financial budgets. Typically used by larger companies with multiple departments or locations, a master budget is used as a planning tool for the company as a whole. Along with operating and financial budgets, labor and materials budgets and manufacturing overhead budgets are also included in a master budget.

If you’re already using QuickBooks you can easily create some basic budgets. For deeper budgeting options an integrated tool like Planergy can help.

Tips for preparing a budget

When preparing a budget there are numerous things you can do to simplify the process while helping to ensure that the budget is as accurate as it can be.

• Use historical data when available:If you’re a brand-new business, this is not an option, but for those preparingnext years’ budget, the best way to estimate budget totals is not to guess but to use theprevious year’s actual data.
• Budget according to your business cycle:If you own a seasonal budget, be sure that your budget totals reflect that. For example, if you earn the majority of your revenue during the spring, be sure that your budget reflects higher revenue during that period.
• Get your employees involved in thebudgetingprocess:If you’re preparing a departmental budget, be sure to get your employees involved in the budget preparation process. No one knows departmental costs better than the person running that department.
• Overestimate expenses and underestimate revenue:It’s always a pleasant surprise when revenue is higher than budgeted – not so much when expenses come in higher than expected. Always be a little conservative when it comes to estimating revenue while tacking on an additional 10% to 15% to your expenses. This can help you manage any unexpected costs and help keep you on budget.
• Make adjustments as needed:Static budgets can provide good information for your business, but if they’re not adjusted, when necessary, they can quickly become obsolete. Be sure to revisit your budget regularly and make any adjustments as needed.

What program should I use to prepare my budget?

If you’re already usingQuickBooks DesktoporQuickBooks Online, you can easily create some basic budgets. Both applications can create monthly, quarterly, or yearly budgets, with the option to prefill budget totals withprevious years’ totals.

QuickBooks Budgets can be created by class, customer, or location, as aprofit &lossbudget, or as abalance sheetbudget. Businesses are limited to creating one organizational budget per year, though multiple smaller budgets can be created. In addition, you can access twobudget reports; theBudget Overviewreport and theBudget vs.Actualsreport.

To create a budget inQuickBooks Desktop, just follow these simple steps:

1. UnderCompany, choose thePlanning andBudgetingoption. You can choose betweenSet Up BudgetsandCash FlowProjector.
2. After choosingSet Up Budgets, click on theCreateNew Budgettab at the top right-hand side of the screen.
3. Under theCreateNew Budgetoption, you can choose between aProfit andLossbudget, which reflects all activity for the current year, or aBalance Sheet, which only includes ending balances.

The Create aNew Budgetoption inQuickBooks Desktop

4. Highlight theProfit and Loss
5. Add anyadditional criteriasuch as customer job or class.
6. Choose whether you wish to create a budget from scratch or want to uselast year’s data to create your budget.

Choose whether to use previous data or create your budget from scratch.

7. If you choose to create a budget from scratch, you’ll have access to the budget template withinQuickBooks Desktop.

TheQuickBooks Desktopbudget template lets you enter data from a single screen.

You can enter all of your budgeted totals from this screen. However, if you choose to useprior years’ totals, you can do that from the screen below.

Last year’s data is available for those that wish to utilize it.

Those using Premier, Enterprise of Accountant versions ofQuickBooks Desktopcan also create a forecast in the application as well.

To create a forecast, follow these steps:

1. Under theCompanymenu, choose thePlanning &Budgetingoption, and then selectSet Up Forecast.
2. SelectCreate New Forecast.
3. Choose thefiscal yearthat you would like to create a forecast for. Like thebudgetingoption, you can also choose to addadditional criteriasuch as Jobs or Class.
4. ChooseCreate Forecast from Scratchif you wish to create a new forecast. If you wish to create a new forecast based on previous data, chooseCreate Forecast fromPrevious Year’s Data.

Once budgets have been created, you can opt to run several budget-related reports. These reports include:

• Budget Overview
• Budget vs. Actual
• Profit &LossBudgetPerformance
• Budget vs. ActualGraph

If you’re usingQuickBooks Desktopto create a budget, you may also want to set up thecash flowprojector option in the application as well. Thecash flowprojector looks at business finances based on a variety of scenarios. Though this feature has been discontinued inQuickBooks Desktop2022, you can continue to use it in older versions of the application.

Creating a budget inQuickBooks Online

Setting up a budget inQuickBooks Onlineis relatively simple, though it’s not obvious from the main screen. Instead, you’ll have to access thebudgetingfeature under Tools, which is found under Accountant view. To get started, follow these steps.

1. Click on thegear iconat the top of the screen.
2. UnderTools, click onBudgeting.

The Accountant View ofQuickBooks Onlinelists all management features.

3. Click on theAdd Budget tab on the screen.
4. Here, you can name your budget, choose thefiscal yearyou wish to create a budget for, and whether you wish to pre-fill data from previous budgets. There is also an option tosubdividethe budget by customer if you wish. You can alsosubdivideyour budget by location or class if you use them in your business.

In addition,QuickBooks Onlinealso includes a budget wizard that will take you through a complete budget interview process when creating a budget for the first time.

The budget entry screen inQuickBooks Onlineis easy to use.

If you’ve used bothQuickBooks DesktopandQuickBooks Online, you’ll know that creating a budget inQuickBooks Onlineis much easier than doing so inQuickBooks Desktop.

Otherbudgetingoptions

While there are several budget applications on the market, having your budgets integrated with your accounting and financial applications can save you a tremendous amount of time.

While bothQuickBooks DesktopandQuickBooks Onlineapplications can easily prepare basic budgets, the ability tocustomizea budget is limited in both applications. If you’re looking for more custombudgetingor require multi-year budgets, you may want to consider using a software that integrates with QuickBooks and provides more in-depth budgeting and reporting capabilities.

For example, companies that use Planergy to manage spend and accounts payable can benefit from its extensive budget creation and management capabilities. Designed for flexibility, Planergy is suitable for use in any industry and can be used in companies of any size. Planergy offers a variety ofbudgetingtoolsand includes the following features:

• The ability to set budgets by job, department, project, cost center, or person
• The ability to create multiple budgets per company
• The option to create monthly, annual, or custom date range budgets
• Real-time budget reporting with the budget updated each time a purchase order is created or an invoice processed.
• All budgets offer drill-down capability, so users can view detailed information on all orders including who is requesting the order when the order was placed, who the supplier on the order is, and if the expenditure has been approved.

Planergy offers budget details for better real-time expense management.

Particularly useful for any company that need to better manage expenses in real-time, applications like Planergy can provide extensive budget customization capability that other applications such as QuickBooks cannot. Planergy has integration options for QuickBooks Online and QuickBooks Desktop.

Whether you’re using QuickBooks, Planergy, anExcelspreadsheet, or anotherbudgetingtool,creating a budget is an important part of running a business. Be sure you have the tools in place to create a budget that can be a helpful resource for your business going forward.