Resolve to Do These 3 Things in QuickBooks Online This Month

‘Tis the season for making resolutions and setting goals. Try exploring these three areas to dig deeper into QuickBooks Online.

By now, many New Year’s resolutions have already been made. Though they’re usually created with the best of intentions, they’re often just too ambitious to be realistic.

For example, you might decide to learn more about QuickBooks Online and keep up with your accounting chores more conscientiously in 2019. That’s hard to quantify. How will you know if you achieved that goal?

Instead, why not pick three (or more) specific areas and focus on them this month? We’ll get the ball rolling for you by making some suggestions.

Explore the QuickBooks Online mobile app:

Yes, QuickBooks Online itself is already mobile; you can access it from any computer that has an internet connection and browser. But you probably don’t always lug a laptop around when you’re away from the office, and you’re sometimes at locations where using it wouldn’t be practical. But you can always pull out your smartphone and fire up the QuickBooks online app, available for both iOS and Android.


No matter how small your smartphone (this image was captured on an iPhone SE), you can still do your accounting tasks using QuickBooks Online’s app.

QuickBooks Online’s app replicates a surprising percentage of the features found on the browser-based version. You can create, view, and edit invoices, estimates, and sales receipts for example, as well as see abbreviated customer and vendor records. Your product and service records are available there, including tools for recording expenses on the road.

Create a budget for one month:

Budgets are intimidating. That’s one reason why some small businesses don’t create them. So instead of trying to estimate what your income and expenses will be for an entire fiscal year, just build a budget for one month. In QuickBooks Online, you’d click the gear icon in the upper right, then select Budgeting. Click Add budget in the upper right to open the New Budget window.

Give it a name, like “February Budget,” and select FY2019. Leave the Interval at Monthly, and open the Pre-fill data? menu to click on Actual data – 2018 (if you have data from last year). Then click Create Budget in the lower right corner. Look at last year’s February numbers and estimate how they might change in 2019. Replace the old numbers with your new ones.


Creating a framework for a budget in QuickBooks Online is easy.

We’re suggesting you try it for just one month, so you get a feel for how this tool works. And that experiment will probably leave you with some questions. We can help you go further and complete an annual budget.

Customize your sales forms:

Every piece of paper and email you send to your customers contributes to their impression of you. Are you presenting an attractive, consistent image of your business to them? QuickBooks Online can help with this. It offers simple (for the most part) tools that allow you to modify the boilerplate forms offered on the site – without being an experienced graphic designer.

Start by clicking on the gear icon in the upper right and selecting Your Company | Custom Form Styles. Unless you’ve done some work in this area before, the screen that opens will have just one listed entry: your Master form, the one that comes standard in QuickBooks Online. To see what you can do, click Edit at the end of that line. Your four options are:

  • Design. This section contains links to modifications you can make to your sales forms’ visuals. You can, for example, add a logo or color and change the default fonts.

    Want to change your logo or other elements of your sales forms? QuickBooks Online has the tools. 
  • Content. Do you want to add or remove the standard columns (Date, Quantity, etc.) displayed on your invoices? You can do so by checking and unchecking boxes.
  • Emails. QuickBooks Online sends email messages with forms; you can edit them here.
  • Payments. This is a reminder that QuickBooks Online supports online payments, which can help you get paid faster.

There’s more you can do to make your sales forms look professional and polished. We can help you with these tools – and any others you want to explore to expand your use of QuickBooks Online. It’s a new year, and who knows what might come your way over the next 12 months? Contact us if you want to prepare for the new accounting challenges that 2019 might present.

Getting Started with Accounts in QuickBooks Online, Part 2

We covered a lot of ground last month, but there are still some things to know about working with transactions you import from your banks.

Last month, we went over the basics of managing financial transactions once you’ve downloaded them into QuickBooks Online. We walked you through the mechanics of connecting to banks and credit card companies online and described the process of reviewing imported transactions, exploring concepts like:

  • Categorizing them, and marking them as billable
  • Adding them to an account register; matching them to related transactions; or transferring them to another account
  • Using Batch actions to process related groups

 

We explored QuickBooks Online’s Banking features last month, including the site’s ability to work with related transactions as groups.

This month, we’ll look at the process of setting up rules to automatically classify transactions as they come in from your banks. We’ll also provide a brief overview of the Chart of Accounts.

Bank Rules

We’ve already discussed QuickBooks Online’s ability to guess how transactions should be categorized (it’s not always right, but you can change incorrect ones). It also allows you to memorize transactions that recur on a regular basis; this also saves time and improves accuracy. There’s another way the site also uses automation to help minimize keystrokes: Bank Rules. Based on your input, it will scan incoming items and classify them, so you don’t have to. This can be very helpful when you regularly import transactions that share specific attributes.

Let’s look at how this works. Click Banking in the navigation toolbar, then click Bank Rules. Once you’ve created your own rule(s), they’ll appear in a grid on this screen. For now, click New rule in the upper right corner. Basically, you’re going to tell QuickBooks Online that when specific conditions are met, as you can see in the example below, it should take the specified action(s): assign a Transaction type, Payee, and/or Category. You can also have the transaction automatically added to your books.

You can create Bank Rules in QuickBooks Online that will automatically assign a Transaction type, Payee, and Category to imported items that meet specific conditions.

We suggest you meet with us if you’re going to take on this task. If your business processes a lot of transactions, Bank Rules can be incredibly helpful. But set them up incorrectly, and it could take many hours to untangle the errors.

Account Registers, Chart of Accounts

In this column and the last, we’ve been working with transactions as they come into QuickBooks Online directly from your financial institutions, before they appear in your account registers. When you clicked Add after you looked at—and perhaps modified—a transaction listed under For Review on the Banking page, you sent it to that account’s register.

Notice that the site’s registers look similar to their paper counterparts; you may remember recording checks and deposits in the back of your checkbook, if you’ve been in business long enough. There are two ways to see them in QuickBooks Online. When you’re on the Banking page, look over to your right. You’ll see a link labeled Go to Register.  Click it, and you’ll be taken to that page for the account that’s currently active.

You can also open your account registers from the Chart of Accounts. We don’t talk much about this element of financial management because it’s not something you should be modifying. Nevertheless, it’s the heart of your accounting system. It consists of a comprehensive list of your company’s accounts, divided into assets, liabilities, income, expenses, and equity (along with subaccounts). Transactions are assigned to the appropriate account and recorded in the General Ledger, which is another element of accounting that we don’t discuss because you don’t have to deal with it in QuickBooks Online.

You can view your company’s Chart of Accounts in QuickBooks Online, but we recommend you don’t modify it.

Click on the Accounting tab in the navigation toolbar, then Chart of Accounts. You’ll see your individual bank accounts listed here, along with a View Register link.

A Critical Concept

Again, you won’t have to deal with the Chart of Accounts, but it’s very important that you understand how to manage downloaded transactions as you move them into your bank accounts in QuickBooks Online. Mistakes here can trigger errors in reports and taxes, as well as create general confusion. We’d be happy to get you on the right path with this critical function.

Getting Started with Accounts in QuickBooks Online

QuickBooks Online was built to work with transactions downloaded from your online financial institutions. Here’s how to work with them.

The ability to import transactions from financial institutions into QuickBooks Online is definitely one of the best things about the site. You may have even signed up for that very reason. By now, you’ve probably already set up at least one connection. But are you using all of the QuickBooks Online’s account tools? There’s a lot you can do once you’ve imported in data from your bank or credit card provider. We’ll explore these features in this column and the next.

First Steps

If you’re a new subscriber, you may not have established these critical links yet. It’s an easy process. Start by clicking the Banking link in the left vertical navigation pane. In the upper right corner, click Add Account and enter the name of your financial institution if it’s not pictured. Then follow the instructions you’re given on the screen. These can vary depending on the bank or credit card provider, but you’re always at least asked to enter the user name and password that you use to log into each online.

Need help with this? Let us know.

Viewing Your Transactions

Once you’ve made a successful connection, you’ll be returned to the Bank and Credit Cards page. You should see a card-shaped graphic at the top of the screen for each account you’ve linked. Click on one. The table that opens is not your account register. The view here defaults to For Review, which refers to transactions you’ve downloaded. The All tab should also be highlighted; we’ll get to Recognized transactions later.


When you first download transactions into QuickBooks Online, before you’ve done anything with them, many will appear under For Review.

There’s a lot going on here, so don’t be surprised if you’re confused. Review each transaction by clicking on it. QuickBooks Online will have guessed at how it should be categorized, but you can change this by opening the list in the category field and selecting the correct one. It’s critical that you get this right, since it will have an impact on reports and income taxes. If you need to Split it between multiple categories, click on that button found to the right.

If the transaction is Billable, check that box and choose a customer from the drop-down list. If you don’t see this box, click the gear icon in the upper right and select Account and Settings | Expenses. Check to see that Make Expenses and Items Billable is turned On (click on Off, then check the appropriate box to turn it on).

Next, determine how you want to process the transaction by clicking on one of the three buttons at the top of the transaction box. Do you want to accept it and Add it to that account’s register? Do you want QuickBooks Online to Find (a) Match for it (like a payment that matches an invoice, for example)? Or, do you want to Transfer it to another account? Once you’ve made one of these three selections, the transactions that you’ve added or matched will move under the In QuickBooks tab (where you can still Undo them) and will be available in the account’s register.

Other Options


You can save time by using QuickBooks Online’s Batch Actions tool.

Say you run across some duplicate or personal transactions that you don’t want to appear in the current account’s register. Check the box in front of each, then click the arrow in the Batch Actions box. Select Exclude Selected. They’ll then be available under the Excluded tab. You can also Accept or Modify multiple transactions simultaneously by using this tool.

So far, you’ve been viewing All your transactions. Click on Recognized to the right of it. These are transactions that are already familiar to QuickBooks Online because they’ve appeared before and/or have been matched, or because you’ve created Bank Rules for them (we’ll address that concept next month). You’ll need to address these the same way you did the transactions in the For Review section; you can either Add or Transfer them.

If you’re new to QuickBooks Online, this may all sound pretty complicated. It can be at first. But once you’ve worked with downloaded transactions for a while, you’ll understand the flow much better. If you’re not clear on the process from the start, it can lead to trouble. Contact us at your convenience. We’d be happy to sit down with you and go through it all using your own company’s data; the familiarity may help.

How to Enter Bills in QuickBooks

It’s not as much fun as creating invoices, but the bills must be paid. Here’s how QuickBooks helps.

We’re in a bit of a transitional period with business bill-paying. Some paper bills still come via the U.S. Mail, however you may also be getting some through email. Others don’t come at all: You might get a reminder email, but you have to go to the vendor’s site to make a payment.

How do you keep track of it all so you don’t miss any due dates? You could record them on a calendar, but you’d still have to go back to the actual bill to retrieve the amount. But where is it? Is it online, in your email inbox, in a file folder, or hanging on the wall?

QuickBooks can organize this unpleasant process, saving time and helping you avoid confusion. Here’s how it works.

A 2-Step Process

QuickBooks divides your accounts payable tasks into two separate processes: entering bills and paying them. It requires some extra time upfront as you complete the first step, but streamlines the second so that the actual bill-paying only takes a few seconds.

To get started, click Enter Bills on QuickBooks’ home page to open a window like this:

 

Before you can pay a bill in QuickBooks, you need to create a record for it.

The toolbar for the Enter Bills window is not pictured in the image above, but you don’t need it yet. Rather, you start by clicking the down arrow in the field next to VENDOR and selecting the biller’s name from your list (or clicking if you haven’t yet created a record for that entity). The ADDRESS should fill in automatically, as should the date.

If you set up default payment TERMS in that vendor’s record, your preference should show in that field and the BILL DUE date should be correct. Enter the AMOUNT DUE and complete any of the optional fields that the transaction requires (REF. NO., DISCOUNT DATE, and MEMO).

Since this is a utility bill, the Expenses tab should be highlighted, and the amount you entered above should appear in it. Below that is the ACCOUNT field; open that list and choose the right one. Don’t worry about the CUSTOMER:JOB and BILLABLE fields. These will only be completed when you’re charging a customer for an expense or item.

Warning: If you’re not familiar with the concept of assigning accounts to transactions, please schedule some time with us. This is a critical designation that affects so many other areas of QuickBooks.

Saving Your Work


The toolbar from the Enter Bills window

Once you save your bill, you’ll be able to access it when it’s time to apply payment. How will you remember when it’s due, though? QuickBooks can remind you – or even pay it automatically. So, before you leave the Enter Bills window, click Memorize in the toolbar pictured above.

The Memorize Transaction window will open with your vendor already entered in the Name field. You’ll have three options here:

  • Add to my Reminders list. QuickBooks can add this bill to its list of Reminders. To ensure that you’ll see this every time you open the software and can make any changes necessary, open the Edit menu and click Preferences | Reminders | My Preferences. Click in the box in front of Show Reminders List when opening a Company file. Then click the Company Preferences tab (if you’re the administrator) and find the Bills to Pay row. Click the appropriate button to indicate whether you want QuickBooks to Show Summary or Show List, and enter the number of days before due date.
  • Do Not Remind Me. Just what it sounds like.
  • Automate Transaction Entry. You can only select this if the transaction will be exactly the same every time (except for the date). If the number of transactions will be limited, enter the Number Remaining. And tell QuickBooks how many Days in Advance To Enter.

If you choose the third option here, be very careful when you define the automation. You should really only do this if you’re an advanced user.

When you’re done, click OK to close the box, and save the bill.

Let us know if you want to schedule a session to go over any aspect of your accounts payable – or anything else in QuickBooks.

Not Using QuickBooks Online? What You’re Missing Out On

If you dread every minute of the time you spend on accounting, you should know how QuickBooks Online can change your outlook.

How long would it take you to determine:

  • What your total expenses for this quarter are?
  • Whether or not your business is profitable as of today?
  • How much you’ve sold every month this year?
  • Which invoices are overdue?

If you’re using QuickBooks Online, you can get answers to all those questions—and more—in the time it takes you to sign on to the website.

That’s not an exaggeration. The first thing QuickBooks Online displays is what’s called its Dashboard. This is the site’s home page, which contains an array of charts and account balances that provide a quick overview of your finances. Click on an element here—say, a checking account balance—and you’ll be able to drill down and see the details behind it (in this case, an online account register). Click on the Expense graph, and a transaction report opens.

Your First Hours with QBO

QuickBooks Online is not one-size-fits-all. Its setup tools help you customize it to meet your own company’s needs.

QuickBooks Online works like other online productivity applications you may have used. It uses toolbars and buttons for navigation, drop-down lists and blank fields for data entry, and clickable links to open new related screens to trigger actions. Which is to say, the site is easy to use once you understand its structure. We can walk you through the early steps that are required, which involves tasks like:

  • Using the provided setup tools to customize the site.
  • Connecting QuickBooks Online to your bank and credit card company websites so you can work with transactions.
  • Creating records for your customers, vendors, and the products and services you sell (you’ll be able to add new ones as your business grows).
  • Learning about QuickBooks Online’s pre-built reports.
  • Familiarizing yourself with the site’s workflow.
  • Making the transition from your current accounting system.

How You’ll Benefit

Once you’re comfortable using QuickBooks Online, you’ll discover what millions of small businesses have already learned, that the site helps you:

Get paid faster. You can sign up with a payment processor to accept credit cards and direct bank withdrawals, which can speed up your customers’ responses to invoices. You’ll also be able to accept payments when you’re out of the office on your mobile devices.

Minimize errors. Once you enter data, QuickBooks Online remembers it. No more duplicate data entry that can cause costly mistakes.

Find any detail in seconds. QuickBooks Online has powerful search tools that allow you to find what you’re looking for quickly.

Better service customers. Because your customer profiles include transaction histories, you’ll be able to deal with questions and problems quickly and accurately.

Bill time as well as invoice products. QuickBooks Online supports sales of time-based services with capable time-tracking tools.

Improve your customers’ and vendors’ perception of you. Your business associates will know that you’re using state-of-the-art technology by the forms you share and the customer service you provide.

Save money and time. It does take some time to make the transition to QuickBooks Online. But you’ll quickly make that up with the hours you’ll save on accounting tasks, and be able to concentrate on tasks that improve your bottom line.

Be prepared to grow. Because all of your financial data is organized and easily accessible, you’ll be able to quickly generate reports that help you plan for a more profitable future. Banks and investors will need some of these if you decide to seek financing.

Mobile Access

Although you may do the bulk of your accounting work on your desktop or laptop, you’ll have access to many of the site’s features on your smartphone. Your home page displays both an abbreviated version of your browser-based dashboard and a list of recent transactions. You can view, edit, and build new customer, vendor, and product or service records. Snap a photo of a receipt to document an expense and look up or create invoices, estimates, and sales receipts. Record payments, view critical reports, and add notes. Of course, your mobile data is always synchronized with the site itself.

 

QuickBooks Online lets you do much of your accounting work when you’re away from the office with its mobile app.

Happy to Help

QuickBooks Online was designed for small businesspeople, not accountants. But it includes features that are best used in conjunction with our consulting services, like advanced reports, payroll, and the Chart of Accounts. In fact, the site makes it easy for us to have access to your data so we have the ability to monitor and troubleshoot.

We’ve helped countless sole proprietors and small businesses move their accounting operations to QuickBooks Online, and we’ve seen the difference it’s made in their productivity as well as their attitude toward financial management. Contact us, and we’ll be happy to do the same for you.

How QuickBooks Online Can Improve Your Company’s Financial Health

QuickBooks Online is more than just an online bookkeeper. It can help improve your cash flow, your customer relationships, your inventory readiness, and your future.

If you’re already using QuickBooks Online, you know how much impact its bookkeeping abilities have had on your company’s accounting operations. You’re saving time, which in-turn saves money, and you’re reducing errors. When a customer or vendor calls with a question, or you yourself need to track down a critical detail to solve a problem, you’re able to find solutions quickly.

You may already have learned, though, that QuickBooks Online’s benefits include much more than simply getting the numbers right. When you take advantage of all it can offer, you’re likely to notice more far-reaching effects.

The Specifics

Let’s look at how QuickBooks Online accomplishes all of this. You can do much of it on your own, but we’re trained to help small businesses get the most out of QuickBooks Online. We can help you maximize the effectiveness of your accounting time so your company can:

Better balance between income and expenses.


QuickBooks Online provides quick, real-time overviews of your sales status.

You can’t begin to improve your company’s cash flow until you understand where the financial bottlenecks are. QuickBooks Online provides that information for both income and expenses in a variety of ways. In the image above, you can see that there are seven past-due invoices. Click on the orange bar to see a list of them, and you can automatically send reminders. QuickBooks Online also automates the process of sending statements.

You can also run accounts receivable and accounts payable reports that will show where you stand with customers and vendors, like Open Invoices, Uninvoiced Time, Unpaid Bills, and Accounts Payable Aging Detail. If you determine that one of your consistent problems with cash flow is late customer payments, you can set up a merchant account through QuickBooks Online to support credit card payments and bank transfers.

More repeat business because of improved customer interaction.

Your customers are like gold. To build the best relationships possible with them, you need a clear, updated picture of their transactions, their payment details and history, and your interaction with them. QuickBooks Online provides templates for Customer Information records that provide all of that, along with their contact information and a real-time update of the status of their invoices and payments, estimates, time activities, etc. The latter is provided in the form of an interactive list with links to immediate actions you can take.

A more stable, profitable inventory of products.

If your business sells products, you know that you have to be smart about inventory levels. Stock too much and you have too much money tied up unnecessarily. Too little, and you’ll be turning customers away and possibly losing their future business. QuickBooks Online’s inventory-tracking tools help you achieve and maintain that balance, so you know both when and how much to reorder.


It’s easy to evaluate your inventory status very quickly in QuickBooks Online.

QuickBooks Online also offers multiple inventory reports, like Inventory Valuation Detail, Physical Inventory Worksheet, and Sales by Product/Service Detail.

Readiness for growth.

You may never want to acquire another company, or move into more spacious offices, or employ dozens of individuals. However, it’s not often that a company doesn’t want to be in a position to grow. And you never know when an opportunity will present itself that would require additional capital. Would you be ready?

If you’ve never applied for a business loan or tried to attract investors, you don’t know how much financial information you’ll need to provide, or in what format. There are very specific reports your potential lenders or investors will want to see, standard financial statements. QuickBooks Online includes templates for these, which include a Balance Sheet, Profit and Loss, and Statement of Cash Flows.

Like the reports we mentioned earlier, they’re easy to generate on the site, thanks to intelligent, customizable templates. Analyzing them, though, and making sure they’re ready to be seen by third-parties takes professional expertise. We can provide that for you. We can also help you better understand and use other elements of QuickBooks Online so that you’re taking advantage of all of its benefits. Contact us soon to set up an initial consultation.

5 QuickBooks Online Reports You Should Run Regularly

There are numerous QuickBooks Online reports that you should be consulting at regular intervals. But you need these five at least every week.

QuickBooks Online’s Dashboard, the first screen you see when you log in, provides an effective overview of your company’s finances. It contains at-a-glance information about your recent expenses, your sales, and the status of your invoices. It displays a simple Profit and Loss graph and a list of your account balances. Scroll down and click the See all activity button in the lower right and your Audit Log opens, a list of everything that’s been done on the site and by whom.

You can actually get a lot of work done from this page. Click the bar on the Invoices graph, for example, and a list view opens, allowing you access to individual transactions. Click Expenses to see the related Transaction Report. Below the list of account balances, you can Go to registers and connect new accounts.

Other Pressing Questions

The Dashboard supplies enough information that you can spot potential problems with expenses and sales, accounts, and overdue invoices. But you’re likely to have other tasks that require attention. How’s your inventory holding up? Are you staying within your budget? How about your accounts payable – will you owe money to anyone soon?

QuickBooks Online offers dozens of report templates that answer these questions and many more. If you’ve never explored the list, we suggest that you do so. It’s impossible to make plans for your company’s future without understanding its financial history and current state.


QuickBooks Online has many reports that can provide real-time, in-depth insight into your company’s financial health.

Comprehensive and Customizable

When you click Reports in your QuickBooks Online toolbar, the view defaults to All. The site divides its report content into 10 different sections, including Business Overview, Sales and Customers, Expenses and Vendors, and Payroll. Each has two buttons to the right of its name.

Click the star, and that report’s title will appear in your Favorites list at the top of the page. This will save time since you’ll be able to quickly find your most often-used reports. Click the three vertical dots and then Customize to view your customization options for that report (you’ll have access to this tool from the reports themselves).

Necessary Knowledge

You can, of course, run any report you’d like as often as you’d like. Most small businesses, though, don’t require this frequent intense scrutiny. But there are five reports that you do want to consult on a regular basis. They are:

1. Accounts Receivable Aging Detail. Displays a list of invoices that haven’t yet been paid, divided into groups like 1-30 days past due, 31-60 days past due, etc.

2. Budget vs. Actuals. Just what it sounds like: a comparison of your monthly budgeted amounts and your actual income and expenses.

Warning: Some reports let you choose between cash and accrual basis. Do you know the difference and which you should choose? Ask us.


You can customize QuickBooks Online reports in several ways.

3. Unpaid Bills. Helps you avoid missing accounts payable due dates by displaying what’s due and when.

4. Sales by Product/Service Detail. Tells you what’s selling and what’s not by displaying date, transaction type, quantity, rate, amount, and total.

5. Product/Service List. An accounting of the products and/or services you sell, with columns for price, cost, and quantity on hand.

Customization, Complex

Reports Note that there’s a category of reports in QuickBooks Online named For My Accountant. That’s where we come in. The site includes templates for reports that you can run yourself, but that you’d have difficulty customizing and analyzing. These standard financial reports—which, by the way, you’ll need if you create a business plan or try to get funding for your business—include Balance Sheet, Statement of Cash Flows, and Trial Balance.

You don’t need to have these reports generated frequently, but you should be learning from the insight they provide monthly or quarterly. We can handle this part of your accounting tasks for you, as well as any other aspect of financial management where you need assistance. Contact us, and we’ll see where we might help provide the feedback and bookkeeping expertise that can help you make better decisions for the future of your business.

Don’t Have a Budget? QuickBooks Online Can Help

The hardest part of creating a budget is getting started. QuickBooks Online provides tools that can jump-start the process.

You know you should have a budget. You’re aware that it can help you stay on track with your company’s income and expenses throughout the year. Maybe you’ve even tried to make one before, but you got discouraged by the mechanics or by the difficulty of estimating money in and out for the next 12 months.

June may not be the beginning of your fiscal year, but that doesn’t mean you can’t make a serious effort to start building a budget that can help you rein in expenses and set revenue goals.

Here’s a look at QuickBooks Online’s budgeting features.

Creating the Framework

Before you begin, you’ll want to make sure that your fiscal year is set correctly in QuickBooks Online. Click the gear icon in the upper right, then click Your Company | Account and Settings | Advanced. If the First month of fiscal year isn’t correct, click the pencil icon over to the right and change it. Then click Save and exit out of this window.

Click the gear icon again and select Budgeting, then click Add budget in the upper right.

QuickBooks Online asks you the questions that need to be answered before you start filling in your budget grid.

The first thing you’ll do is give your budget a descriptive name by entering it in the Name field. Next, open the drop-down list under Fiscal year and select the correct 12-month period. You can create your budget in one of three intervals: Monthly, Quarterly, or Yearly. If you want to populate your budget with numbers from this year or last, make that selection in the Pre-fill data? field.

There’s one more option at the top of the Budgets Grid screen that’s not shown in the image above. You can Subdivide by Customer, Class, or Location. This can be useful if you want to view budget data specific to a subset of entries in each of those categories. You could, for example, choose three customers and view only their numbers in the grid individually, one at a time.

Providing Your Numbers

Once you’re satisfied with the selections you’ve made, click Create Budget in the lower right. The screen will refresh and display a grid that you can edit.

Let’s say you’re working on a budget for the second half of 2018. QuickBooks Online brought in your numbers for January-May. You see that the numbers don’t vary much from month to month on one specific line item, so you’re going to assume that they will continue to be true (unless you know something that will affect it after May). You could enter a rough average of the first five months in the JUN field.

Hover your cursor over the arrow to the side of that field, and this sentence appears in a small bubble: Click to copy the value across on the row. QuickBooks Online will then enter that number in the JUL through DEC fields.

 

QuickBooks Online can save you some time as you enter data in your budget grid fields.

When you’re done entering data in all of the fields relevant to your business, click Save in the lower right and close the window. Your budget will now show up in the list.

Tip: If you have multiple blank rows and don’t want them to be displayed, click the gear icon in the upper right corner of your budget page. Click in the box in front of Hide blank rows to create a checkmark.

The Hard Part

QuickBooks Online simplifies the mechanics of creating a budget, but it’s up to you to supply the numbers. There’s lots of common-sense advice that experts offer for this process, like:

  • Remember seasonal upswings and downswings.
  • Make your goals as realistic as possible. You might want to create separate budgets for “needs” and “wants.”
  • Track your expenses carefully for a period of time so you can estimate more confidently.
  • Create reports regularly that compare your budget vs actuals.

QuickBooks Online can help you with that last piece of advice; it offers a report called Budget vs. Actuals. You’ll find it in the Business Overview group.

We can help, too. Once we understand a little more about your business structure and goals, we can take a look at your income and expense history and make some personalized recommendations. Connect with us soon, and we can start you on the path to a more focused financial future.

QuickBooks Tip: Customizing QuickBooks’ Forms

The invoices and other forms you send to customers and vendors should reflect your company’s attention to detail, accuracy, and consistency.

Every opportunity you have to interact with your customers and vendors is critical. Whether it’s a phone call, an in-person connection, or an email, how you present yourself reveals a lot about you. Are you efficient? Friendly? Do you handle orders and problems and payment issues quickly and carefully?

Your accounting forms can also contribute to your image. They should always be:

  • Neat and attractive.
  • Easy to read, with the most important information displayed prominently.
  • Consistent with any graphics you use on other company materials.
  • Accurate, above all.

You might be able to use at least some of QuickBooks’ form templates as is, without any modifications. But couldn’t they be better? More visually appealing? Formatted to include only the fields that your business most often needs? QuickBooks contains the customization tools you need to make them so.

Improving What Exists

You can personalize your QuickBooks forms and make them consistent with any design themes your brand may use.

We’ll look at the modification options for an invoice, though, depending on what version of QuickBooks you’re using, you can also work with sales receipts, purchase orders, statements, estimates, sales orders, and credit memos. Start by opening the Lists menu and selecting Templates. Highlight Intuit Product Invoice in the list. Click the down arrow next to Templates in the lower left corner and choose Edit Template.

The above image displays part of the window that opens. Here, you can add a logo, change the color scheme, and change fonts for your company’s contact information and the labels that identify each field (like Bill To, Terms, and Quantity). The right pane of this window shows you what the form will look like as you make changes.

Nothing you’ve done so far will prevent you from using Intuit’s pre-printed forms. But when you click Additional Customization at the bottom of the screen, you’ll be warned that if you make modifications beyond this point, the forms may not print correctly. To be safe, click Make a Copy. You’ll be able to print this new version on plain paper.

Deeper Customization

The image below shows you part of the window that opens when you click on Additional Customization. The first two columns here are the most important; they let you specify the labeled fields that will appear on your invoices. When Header is the active column, you’ll be able to choose the content that will go at the top of your form, like Date, Invoice Number, and Terms.

Next to each default label, you’ll see boxes for Screen and Print. Click in these boxes to create or delete checkmarks; this will indicate whether each label will appear in the software itself and which will be printed for your customers to see. If you’d like to change the language QuickBooks uses to describe each, enter your preferred word or phrase in the Title column.

 

 

With the Header column highlighted, you can shape the appearance of the top section of your invoices.

Warning: As you’re checking and unchecking boxes, a dialog box may open telling you that your changes will cause some fields to overlap on your form. If you click the Default Layout button, QuickBooks will make automatic adjustments to fix this. Clicking Continue means you’ll have to use the software’s Layout Designer to make your own adjustments. This tool is not particularly intuitive, and it requires some design skills. If you must work with the Layout Designer, let us help.

When you click the Columns tab, you’ll see a list of the fields available for the main body of your invoices, like Description, Quantity, and Rate. This works similarly to how you just modified the Header, with one exception: You’ll be able to enter numbers in the Order column to specify the placement of each field. Here again, you’ll be able to watch a preview of your form change in the right pane.

If you want to start over, click the Default button to revert the form to its original state. When you’re done, click OK.

Neatness Counts

Whether you print and mail your forms or simply dispatch them electronically, we strongly encourage you to make them as professional and polished as you possibly can. Their appearance will enhance or detract from the image your customers and vendors have of your business. Let us know if we can help here. We’d be happy to help you learn about and implement the customization options that QuickBooks offers.

Benefits of Paperless Quickbooks

Here are the areas where Quickbooks online is better than Desktop (without any assistance from apps) and how we can help you:

Data Entry/Automation

  • Automatically schedule and send transactions
  • Delayed Charges–non-posting transactions that you can bill for or apply later
  • Journal Entries can have multiple AR/AP lines
  • Invoices tab—Better payment to invoice and deposited vs. un-deposited visibility
  • Attach documents, images, signatures & more using mobile device
  • Price Rules support date range
  • Re-label your customers if you call them something else

Banking

  • Bank Transactions download automatically each night. Flexibility to “Undo” in Banking Tool
  • Custom Banking Rules can be split by $ or % and you can assign class/ location
  • Rules can be auto-added to register

Job Tracking

  • Project Center
  • Never need to worry about “No Item” Issue on job-related reports
  • Multiple budgets per fiscal year
  • Unlimited time tracking and reports only users, also in Essentials
  • 1099 Contractor self-setup

Reporting

  • Audit Log to review all actions on account and track changes over time
  • Track by Location in addition to Class and choose from multiple location labels
  • Management Reports–presentation ready package of reports from cover page to end-notes
  • Set up multiple budgets per fiscal year

Inventory

  • First in First Out valuation method

Access and Productivity

  • Multiple Users can work in same account at same time
  • No file transfer or versioning
  • Mobile App with expanded functionality to work on the go
  • No Server, Backup, or Hosting Services required
  • Compatible across multiple platforms and devices
  • Access account from anywhere w/ internet connection

QuickBooks Online Accountant

  • Single client list to access all of your clients’ books
  • Toggle between clients w/ a single click
  • Work—manage all firm projects and deadlines
  • Team and client collaboration
  • PTO integration
  • Free ProAdvisor Program, Free payroll in Your Books file