Author Box
Articles Categories
All Categories
Articles Resources

Budgeting in QB

February 28, 2012 | Comments: 0 | Views: 197

An under-used tool in QuickBooks is the Budget and this is a good time of year to set it up. I know many businesses don't even take the time to work on a budget. But your budget is a powerful feature that can help you in a few ways. First it helps you control your costs. I realize some costs are hard to estimate especially as we see gas prices going up. But it still helps give you some guidelines in operating your business. You can also use it as an incentive when you're looking at certain goals that you'd like to achieve in your business. A phrase I like is you can't hit a target you can't see. So having a budget helps you view those goals... It can also be a jumping-off point for discussions about long-term planning.

I'll go through the steps today for setting up a budget for your company based on income, cost of goods and your expenses. But for those of you who use Classes in your QuickBooks, you may also want to do a budget for each Class.

To get started, click on the Company menu. Select Planning & Budgeting, and then Set Up Budgets. If you've already set up a budget, that one will appear. You'll be able to edit it or create a new one.

Select Profit and Loss to include all of the previous year's activity and click Next.

On the next screen, you'll also be able to include the criteria, (Customer: Job or Class),so you can budget for individual customers/jobs or classes instead of by account only. Leave this box unchecked for now. Click Next.

Determining the Content

Next, you'll indicate whether you want to start from scratch with your own figures or let QuickBooks pre-populate your budget with last year's numbers. Sometimes I let QuickBooks populate just to get an idea, but you don't have to keep it. But I know many businesses prefer to simply starting from scratch which is what we'll do for this example. Select Create budget from scratch. Click Finish.

Click on Rent Expense and enter 3,500 in the January column. Hit Tab. You'll notice that the Annual Total column changes to reflect that entry. If you expect that your number will fluctuate over the year, continue to enter those figures in the month columns. If it will remain the same, click Copy Across in the lower left corner. Every column (except for Annual Total) now displays 3,500. (If you would prefer to enter in an annual total and have QuickBooks spread the amounts across the months, click on Help> Send Feedback and let Intuit know. It's definitely on my wish list.)

When you're satisfied with your budget, click Save. You can easily access and edit it anytime from the Company menu.

More Budgeting Tools

QuickBooks' budget flexibility doesn't end there. Let's say that your major office supply vendor has just lowered its bulk prices by 5%, halfway through the year. It's easy to make this change to your existing budget. Click the Office Supplies row, and then click on Adjust Row Amounts at the bottom of the screen.

At the top of the window, you can choose to have the change begin at the first month of your budget or at the currently selected month. Check one of the two buttons below that to indicate whether you want an increase or decrease, and then enter the numerical value in the box.

Tip: Want to start over? Click on the Clear button in the lower right corner. This deletes all of the data in the current page of the budget.

To switch back and forth among budgets, click the arrow under Budget in the upper left corner of the window. A list of your budgets drops down. To build a new one, click on the Create New Budget button in the upper right corner.

Seeing the Fruits of Your Labor

Keep in mind that you can only create one budget per fiscal year for each account, customer or job, and class combination. This still gives you a lot of budgeting power.

Of course, the real power of QuickBooks budgets lies in its budget reports. Using these, you can get an instant, insightful look at how your income and expenses are performing. Go to Reports | Budgets and Forecasts to find them. They include Budget Overview, Budget vs. Actual, and Profit & Loss Budget Performance.

If you need help working with the budget features in QuickBooks, let us know - we'll be happy to assist.

Muir & Associates helps businesses use their Intuit products more efficiently and more effectively so businesses can focus on their business and make more informed decisions. We provide sales and support services. Monica Mitchell Muir has been helping businesses with their QuickBooks products since 1996.

Source: EzineArticles
Was this Helpful ?

Rate this Article

Article Tags:






In India, employment opportunities are set to grow by a good margin in the coming year, a phase which was started in the turn of the second decade of the 21st century. organisation, candidates with

By: Sarkariexam l Business > Careers Employment l April 01, 2013 lViews: 11709

Sometimes it is amazing to see that certain jobs can precipitate huge turnouts in the recruitment drives. It is as if thousands of people were waiting for the vacancy advertisements and the moment

By: Sarkariexam l Business > Careers Employment l December 30, 2012 lViews: 690

In recent times, jobs in healthcare segments have grown tremendously. It is anticipated that this growth curve will continue for the times to come. Various factors are responsible for this

By: Sarkariexam l Business > Career Advice l December 27, 2012 lViews: 448

Are you in a dilemma whether to choose web based CRM or not? If yes, don’t worry. You aren’t the sole person having this doubt.There are numerous firms trying to make out whether investing in a

By: Reneta Vasileva l Business > Customer Service l December 23, 2012 lViews: 409

If you think about it you will realize the fact that each business has its own set of risks that are involved in it.The trade secrets that you have and the information related to the business is what

By: brumbrum1 l Business > Risk Management l December 23, 2012 lViews: 263

As the time is changing, concierge management services are now growing despite the slowing economies of the world. The main reason of it is the need that is highly specific to the people who like to

By: willsmith10 l Business > Management l December 23, 2012 lViews: 334

Many start-up firms are launched by entrepreneurs who try to handle the financial side of the business themselves. However, even the best bookkeeping software does not compare to the services offered

By: Jane J Harlowl Business > Accountingl June 12, 2012 lViews: 197

Why spend your valuable time toiling through accounts? Speak to some specialist business advisors today who can provide you with quality accounting solutions at an affordable price.

By: Steve Mackiel Business > Accountingl June 12, 2012 lViews: 220

The process of keeping books repeatedly and correctly requires tons of time and manual effort. Online bookkeeping is the new trend that big and small businesses are using to save time and avoid

By: Amitaabh Sabool Business > Accountingl June 12, 2012 lViews: 233

You may be concerned that, by hiring an outsourced controller, you'll be giving up "control" of your company. That couldn't be further from the truth. A financial controller provides you with the

By: Tim Garrisonl Business > Accountingl June 11, 2012 lViews: 217

There has been a lot of confusion in the business world about the differences between accounting and bookkeeping. Ultimately, it comes down to the size of the company employing them and the purpose

By: Daryl Jamesl Business > Accountingl June 11, 2012 lViews: 222

The investors who invest money in any company are called as the stakeholders. The main purpose of investing money is to improve monetary gains by receiving regular dividends and by virtue of growth

By: Gauri Sankarl Business > Accountingl June 10, 2012 lViews: 222

An underused feature in both QuickBooks and Point of Sale (POS) is Type. This feature can help you identify your most profitable type of customer. Both products have reports to show Sales by Customer

By: Monica Muirl Finance l April 18, 2012 lViews: 134