QuickBooks Online (QBO) Plus can’t tell you how to plan the next year in terms of numbers, but its tools can make the mechanics of budgeting with QBO.
Your Fiscal Year Start
Do you know exactly when your fiscal year starts? You’ll need this information before you can get started on your budget. Click the gear icon in the upper right next to your company name, and then select Account and Settings | Advanced. The first entry here tells you the First month of your fiscal year.
Creating a Framework
To get started building your budget, click the gear icon again and select Tools | Budgeting. Click New Budget to open the mini-interview wizard (if it didn’t open automatically). QBO Plus creates what are called Profit and Loss Budgets. This kind of budget tracks the numbers in your income and expense accounts.
There are three ways to create one, as you’ll see when you click Next on the first page of the interview. You can:
- Work from historical amounts by copying last year’s data into the spreadsheet,
- Start from scratch, or
- Copy data from an existing budget.
Click in the button in front of No amounts. Create budget from scratch, and then click Next. QBO Plus’ budgets consist of a table divided into months (columns) and accounts (rows). You can break this down into even greater detail by subdividing your budget and tracking accounts separated by Territories, Classes, or Customers if this kind of information is important to you. For now, click the button in front of Don’t subdivide.
When you click Next, you’ll be asked to select the fiscal year for your budget. Click the down arrow to the right of Select fiscal year and choose the appropriate year. Type an easy-to-remember name for your budget in the box below and click Finish. The mini-interview will close, and your budget spreadsheet will open.
Entering the Numbers
QBO Plus defaults to a monthly view when you first open it, but you can change this at any time to Quarter or Year by clicking the arrow in the field next to View by in the upper right corner.
If you had copied income and expense data from the previous year, or from an existing budget, those numbers would appear in the corresponding cells and could be changed to create a new budget. You opted to start from scratch, so the table is empty. You can just start entering individual numbers – not within the spreadsheet cells themselves, though.
Look down to the bottom left corner of the screen. If you’ve highlighted Discounts given, for example, by clicking on that label in the spreadsheet column, you’ll see a line directly below that last row that reads Edit – Discounts given.
This area is where you’ll do your actual data entry. If the drop-down list to the right of Enter by is set to Month, you’ll see 12 boxes below labeled with the months of the year. If you anticipate that every month will contain a different figure, enter the numbers in the correct boxes and click Save & Next. QBO Plus will copy your numbers into the actual budget spreadsheet.
If the number will remain the same for each month, you can enter it in the Jan box and click Copy Across, then Save & Next (click this button after every row change). Your cells for that account will be automatically populated.
If you think more in terms of quarterly income and expenses, you can highlight the correct account and select Quarter from the drop-down box next to Enter by (see above image). Fill in your quarterly totals, and QBO Plus will divide those evenly between each set of three-month periods. The result would look like this:
And of course, if you select Enter by: Year, you’ll only enter one number that QBO Plus will divide evenly into 12 months. When you’re done with your budget, click Finish.
This is a lot of information to absorb all at once, and we imagine you may have some questions on budget projections and on the actual mechanics of creating a budget using QuickBooks Online (QBO) Plus. As always, we’re happy to hear from you and always here to help, so call us at 256-337-5200.