QuickBooks Tips

Having Trouble Budgeting? QuickBooks Online Can Help

Creating a budget that works may be the most challenging task you take on as you manage your company’s accounting. Income can be unpredictable, and expenses are hard to estimate. But a well-crafted budget is key to running a successful business.

Maybe you’ve tried before and given up. But maybe you haven’t had the right tools or approached the process with the right mindset. Try using QuickBooks Online’s budgeting tools and following these tips to create and maintain a budget that can serve as a roadmap for your spending.

Creating Your Budget

Click the gear icon in the upper right corner, then select Budgeting under Tools. Click Create budget in the upper right. For Budget type, select Profit and Loss. This is most typical. It allows you to plan your budget around income and expenses over a specific period.

You’ll have to make other decisions about your new budget:

• Time period. We’re going to create our budget for the upcoming fiscal year that starts in October of 2024. So we’ll select FY_2024_2025. Not sure when your fiscal year starts? Click the gear icon in the upper right and click Account and settings, then Advanced.
• What Budget format do you want to use? We’ll select Consolidated, because we want an organization-wide plan. A Subdivided budget would allow you to create individual budgets based on location, class, department, or customer.
• Do you want QuickBooks Online to Pre-fill data? You won’t make a selection here if you’re starting from scratch. Otherwise, you can have numbers from a previous budget plugged into your new budget, which you can then edit.

Click Next when you’re done. Your budget table will open.

Filling In Your Budget

Before you start filling in your budget, make sure the information at the top of the page is accurate. Is the fiscal year correct? The button in front of Compare reference data should be turned off, because we’re starting from scratch. If you have past budget data or a year’s worth of income and expenses you want to bring in, make sure this option is turned on. QuickBooks Online will then ask you whether you want to transfer your Actuals (real money you received or spent) or your budget, and for what year.

Make sure the time span is set correctly for your initial work (Yearly, Quarterly, or Monthly), though you can switch back and forth among them without losing data. Click the gear icon in the upper right to see your options there. You can Autosave budget (recommended), Hide empty rows (you won’t want to do this until you have your budget set up), and make the Display density compact.

To create your budget, you simply enter numbers in the small boxes supplied. Columns are divided by months or quarters, depending on what you specified, and rows are labeled with budget items (Advertising, Gross Receipts, Legal & Professional Fees, etc.). You simply enter numbers in the boxes that apply. You can either:

• Enter an annual total in the Budget totals box and let QuickBooks Online divide it into 12 monthly numbers (click the small “split” icon), or
• Put the monthly amount in the first month’s (or quarter’s) column, and QuickBooks Online will multiply it by 12 and enter the annual number (click the small arrow).

You can also, of course, enter different numbers in each box to reflect changing budget needs.

When you’re done working with your budget, save it. You can come back anytime and make adjustments as needed.

7 Budget Tips

1. Remember seasonal upswings and downswings.
2. Make your goals as realistic as possible and distinguish between essential and nonessential expenses. Enter your budget items for the bills and other expenses that must be covered before you add optional categories.
3. Keep it simple. Don’t budget down to the last paper clip. You risk budget burnout, and your reports will be unwieldy.
4. Build in some backup funding. Just as you’re supposed to have an emergency fund in your personal life, try to create one for your business.
5. Overestimate your expenses, at least a little. This can help prevent “borrowing” from one budget category to make up for a shortfall in another.
6. Make your employees part of the process. Don’t be secretive about the expense element of your budget. Try to get input from staff in areas where they have knowledge.
7. Revisit your budget frequently. Evaluate your progress at least once a month. In fact, you could even start by budgeting for only a couple of months at a time. You’ll learn a lot about your spending and sales patterns that you can use for future periods. The Budget Overview report displays all the data in your budget(s). Budget vs. Actuals shows you how you’re adhering to your budget.

Contact the office for help with budgeting or to answer questions you might have about creating and modifying budgets in QuickBooks Online. You can also contact the office with other accounting issues you may be having.

Previous Tip - Back to tips - Next Tip