Category: Uncategorized

QuickBooks Online may work for you just fine as is. After all, it was designed to meet the needs of the millions of small businesses that want to manage and track their income and expenses, create records and transactions, and run reports to gauge their financial health. 

QuickBooks Online was also designed to grow along with your business. But there’s no need for Intuit to add internal features to do so. In fact, that would make it too expensive and unwieldy for many companies.

Instead, Intuit has partnered with other small business websites to provides add-ons—applications that extend the usefulness of QuickBooks Online in one or more areas, like accounts receivable and payable, inventory, and expense-tracking. They integrate easily to share data and do the extra work you need. Here are some of them to consider.

You can certainly enter and pay bills using QuickBooks Online. And you can send invoices to customers and receive payments. But adding a connection to Bill.com gives you more advanced options for accounts receivable and payable. Simply send your bills to Bill.com by scanning, emailing, faxing, or taking a picture with your smartphone. The site’s automation tools turn them into digital records and route them through your specified approvers. Once approved, they’re paid electronically or by paper check. Invoices are just as easy to process; customers can pay by using PayPal, credit card, or ACH. Bill.com’s mobile app makes it possible to keep up with invoices and bills while you’re out of the office.

Are your employees still paper-clipping receipts to handwritten expense reports? This method is unnecessarily time-consuming – and often inaccurate. Expensify solves both problems. Your staff can take photos of receipts with their smartphones. Expensify then converts the expense information into coded digital records and submits them for approval based on your company’s policies. Credit card purchases can be automatically imported, too. All data is synchronized with QuickBooks Online in real-time and coded to reflect your preference of QBO’s expense accounts, customers/jobs, etc. Once you’ve approved a report, you can have the money deposited in the employee’s bank account the next day.

TSheets employee scheduling software automates tasks that QuickBooks Online doesn’t do: scheduling and remote time-tracking for your hourly employees. Your staff no longer has to fill in paper timesheets. Instead, they can use their smartphones to track their hours and GPS location points. And while Excel is certainly better for creating schedules than paper, TSheets takes over that task, too. After you’ve approved timesheets, that information is sent over to QuickBooks, ready for use in your payroll processing.

QuickBooks Online performs some basic inventory management tasks. You can create records for items and use them in transactions, and keep track of the number of items in stock so you know when to reorder (or have a sale). SOS Inventory goes well beyond those capabilities. You can create sales orders, track cost history and serial numbers, and document work-in-progress (WIP). SOS Inventory supports multiple locations and the entire pick/pack/ship process.

You can create thorough customer records in QuickBooks Online and document some of your interaction. But it doesn’t facilitate true Customer Relationship Management (CRM) nor project management. Insightly CRM does both. It lets you build exceptionally thorough customer profiles so that you can view social streams, email history, and any events, opportunities, or events related to them. Its project management features include the ability to track by pipelines or milestones, define contact roles and custom fields, and generate advanced project reporting.

All of these apps can work in standalone settings, but their integration with QuickBooks Online and their mobile capabilities create powerful partnerships that help you serve both your customers and your employees in ways that QuickBooks Online alone can’t.

We’re not trying to sell you applications here. Our concern is that you’re getting as much out of QuickBooks itself as you can. We can steer you toward add-on solutions if that seems necessary, but we’re always happy to work with you on getting to know QuickBooks Online better and matching its capabilities to your company’s needs.

Since early January of this year, you’ve been faithfully creating new records, entering transactions, and recording payments. You’ve run basic reports. You’ve done your collection duties. You may have paid employees and submitted payroll taxes.

Now the end of the year is rapidly approaching. In the midst of holiday get-togethers, gift shopping, and perhaps preparing for travel, you probably have a list of work tasks that must be completed by December 31.

​Is your annual QuickBooks wrap-up on that list? It should be. Here are some of the things we suggest you fit into your busy schedule sometime this month.

In an ideal world, all of the invoices that are currently due would be paid off by the end of the year. We all know that that’s not usually the reality. Two reports can help you here: the A/R Aging Summary and Open Invoices.

Give everyone a chance to clear their accounts before December 31 by sending statements. Click Statements on the Home page (or Customers | Create Statements) to open the window pictured above.

You have multiple options here that are fairly self-explanatory. The screen above is set up to create statements for all customers who have an open balance as of the date you select, but not for inactive customers or those with a zero balance or no account activity. That way, no one who’s paid in full to date will receive a statement. Of course, if you didn’t want statements created for anyone who’s less than 30 days past due, you’d click in the box in front of Include only transactions over and enter a “30” in the following field. Questions about all of this? Give us a call.

​Tip: You can also find out who’s overdue by clicking on the Customers tab in the left vertical pane to open the Customer Information screen. Click on the down arrow to the right of the field just below Customers & Jobs. QuickBooks provides several filters for your list.

The week between Christmas and New Year’s Day might be a good time to sell excess inventory by having a sale. If you only sell a few products, you probably know what hasn’t sold well in 2016. If your stable of products is larger, you can run QuickBooks reports like Inventory Stock Status by Item and Sales by Item Detail to identify your slow-sellers and discount them. You may need to filter your reports to see the right data. Talk to us about customization options if you’re unsure of this.

Clean up your contact lists.
If you don’t maintain your customer and vendor lists, you’ll eventually start wasting time scrolling through them when you enter transactions. So this would be a good time to designate those contacts that you’ve not dealt with in 2016 as Inactive (you can delete their records entirely, but we advise against that). Simply open a Customer record, for example, and click the small pencil icon in the upper right to edit it. Click on the box in front of Customer is inactive.

Send holiday greetings to customers and vendors.
It’s getting a little late to send a holiday greeting/thanks-for-your-business note in December. Consider doing this in January (Best Wishes for a Successful 2017!) when your customers’ and vendors’ lives have slowed down a bit. You’re less likely to get lost in the crowd. If your lists are short enough, personalize these cards as much as possible. At least sign them by hand if you can.

Tip: You can print customer labels for your cards directly from QuickBooks. Open the File menu and then click Print Forms | Labels.

Run advanced reports.
Here’s where we come in. If we’re not already creating and analyzing QuickBooks’ advanced financial reports (found in the Accountant & Taxes submenu of Reports) monthly or quarterly, talk to us about it. They’re important, and they give you insight that you can’t get on your own. This is another activity that can spill into January.

We’d like to thank you for being a client this year, and to wish you a successful 2017!

Stock image courtesy of FreeDigitalPhotos.net

We recently laid out the benefits of using QuickBooks Online for bill entry and payment. It’s faster than manual methods. It leaves an electronic record of your accounts payable. And it helps ensure that bills are paid accurately and on time.

As we discussed, QuickBooks Online employs a two-step process for bill payment. Once you’ve completed the first (setup), the hard part is done, and you can move on to fulfilling your financial obligations. Let’s take a look.

​
Warning: Because you may be “handling” a lot of your bills twice in QuickBooks Online, this system can take some getting used to. We’ll be happy to walk you through the process until you’re comfortable.

To review quickly, we created a bill by clicking on the plus (+) sign at the top of the screen and selecting Bill under Vendors. Once you’ve created a bill, you can click on Make recurring at the bottom of the screen to establish periodic payments (as pictured above). You can choose to have payments that are always the same sent automatically, or you can request a reminder so that you can change the amount before emailing or printing. Those reminders appear when you first log into QuickBooks Online. You can access them by clicking on the corresponding link under Tasks.

Making Payments
QuickBooks Online makes it very easy to pay bills. You can do so from a handful of different screens on the site – sometimes in multiple places on the same page.

• Click on the Vendors tab in the vertical toolbar on the left side of the screen. The page that opens displays a horizontal chain of bars near the top, color-coded to indicate what they represent: Purchase Order, Open Bills, Overdue, and Paid Last 30 Days. Each segment tells you how many transactions share that status as well as their total dollar amount. When you click on a segment, the table below changes to include a list of the actual transactions. At the right end of each line is a Make Payment link that you can click to get a payment screen. If you want to see the actual bill that was sent, click on the Vendor name itself.
• You can click on the plus (+) sign at the top of any screen where it appears and go to Vendors | Pay Bills.
• Open the bill itself and click on the Make Payment link in the upper right corner.

When you’ve opened a bill that you want to pay, double-check the information in the upper part of the screen. The Vendor details should, of course, be correct, but make sure the date reads as it should. And look in the box to the right of the vendor’s name. If it’s not displaying the correct account for the transaction, click on the double arrows and select the right one.

QuickBooks Online will follow its own numbering system for bill payments. If you want to assign your own by entering a reference number of some kind, delete what’s showing in the Ref no. field and add your own. The Bill Payment # in the upper left will change to reflect that.

​If there are multiple bills in the list below, click in the box in front of the one(s) you want to pay to create a checkmark. Look at the end of each line, too. QuickBooks Online defaults to a full payment for bills. If for some reason you’re planning to make a partial payment, replace the dollar amount in the Payment box with your own. In the bottom left portion of the screen, you can enter a Memo if you’d like and add an Attachment. When you’ve checked everything for accuracy, click Save and close or Save and new in the lower right corner.

Paying bills manually can be painful. Beyond the fact that you’re watching money leave your accounts, the mechanics of writing checks and/or dispatching electronic payments on time—and keeping everything organized—can be a constant challenge. QuickBooks Online’s bill-paying tools can help with that.

QuickBooks makes your bookkeeping faster, safer, and more accurate than what you could do using a manual system. Still, you may occasionally tire of your daily tasks. You want to know what all of these forms and records mean in terms of your overall financial health. You want to see reports.
​
The actual mechanics of creating reports in QuickBooks are fairly straightforward. You can go to the Report Center, make a selection, maybe change the date range, and voila! Your company’s related data appears in neat rows and columns.

But perhaps you to see different columns than what QuickBooks’ report templates include. Further, you might like to filter your output for more meaningful, targeted analysis. And frankly, some of QuickBooks’ reports—particularly those included in the categories Company & Financial and Accountant & Taxes—can be a little advanced for the average small businessperson with little bookkeeping experience. They’re easy to run, but difficult to understand.

So we strongly encourage you to let us run these more complex reports, like the Balance Sheet, for you on a regular (monthly or quarterly) basis. They can provide valuable insight as you continue to make critical business decisions.

​But we don’t want to discourage you from working with QuickBooks’ reports on your own. You could run A/R Aging Detail, for example, to keep an eye on past-due payments, or Unpaid Bills Detail to see where you stand with your own financial obligations.

Sometimes, QuickBooks’ own report output is a bit too broad for your needs. So the program provides sophisticated customization options. You can work with these to narrow down and shape the data that appears in your reports.

First, columns. Building reports from scratch would be too time-consuming and frustrating for you to do all of the time. And it’s unnecessary, since QuickBooks provides templates for its reports, sets of columns and data filters that would serve some businesses well, but which can be modified by each user.

​Try this. Open the Profit & Loss Detail report and click on the Customize Report button in the upper left corner. The Modify Report window opens.

The Display tab should be highlighted. Change the Report Date Range if necessary by clicking on the down arrow to the right of the Dates field. You can also create your own custom date range by deleting the dates in the From and To fields and entering new ones, or by clicking on the small calendar icons and clicking on the desired dates.

Warning: Do you understand the difference between running reports as either Accrual or Cash? This is important. If you don’t, let’s get together to go over some basic report concepts.

It’s easy to change the default columns that appear in reports. You can either enter a column label in the Search Columns box or scroll down the list of all possible labels. Click in the space in front of the ones you want to include, and click on existing checkmarks if you want to remove those labels. You can also designate a sort order, either Ascending or Descending.

​If you want to work with the Advanced options, or if you come across a Display screen that puzzles you (depending on the report, you may have some complex choices), let us know.

When you’re done here, click on the Filters tab. This is a powerful element of QuickBooks report customization. You can limit your report output to data that meet certain criteria. In the image above, for example, you can tell QuickBooks which subset of Accounts should be included. Click on the Billing Status filter, and you can limit the results to Any, Not Billable, Unbilled, or Billed. You get the idea.

You can apply multiple filters to a report. Every one you select will appear in the list under Current Filter Choices.

​We’ll skip the Header/Footer and Fonts & Numbers tabs, since these are primarily cosmetic options you can explore on your own. But you can see from this brief overview how you can use many QuickBooks reports as is or customize them extensively. And we do recommend that you work with reports regularly, both on your own and with us. The insight they provide can help your company grow and flourish instead of just getting by.

Your company’s “brand” can be composed of many things (and has many definitions), but it’s really about what pops into your customers’ minds when they think of you. Key components include your logo, your color scheme, and any other identifying visual element that people associate with your business.
​
A good way to reinforce this image is by making sure that a unifying graphic theme runs through every piece of print or web-based customer content you create, like your website, brochures, blog, and ebooks. Your brand should also be visible on all sales forms you dispatch, like invoices and receipts.

QuickBooks Online comes with its own default sales form style; this is the layout and content that will automatically display when you start a new transaction. You can easily change this and have it apply to all transactions.

Here’s how it works. Click on the gear icon in the upper right of the screen, next to your company name. Select Custom Form Styles to open the table of existing styles. There should be one labeled Standard, though there may be another labeled Classic. You can make either the default by clicking Make Default or Remove as default using the down arrows and links under ACTION at the far right of each row.

Click the Edit link for the default style. This screen contains many of QuickBooks Online’s customization tools. The Style tab in the left vertical toolbar is automatically highlighted. In the column to its right, click through the five design options available and leave the desired one selected. Then click the plus (+) sign in the upper right of the screen. Browse for your logo file when the directory opens and double-click on it to add it to the top of your sales forms. Choose the color scheme you want by clicking in the correct box displayed below.

​When you’re done there, click on the Appearance tab to specify your logo’s placement and change any other settings.

You won’t necessarily need to make every data field available on your sales forms. But you want to include every field you might possibly need without displaying extraneous content areas. QuickBooks Online lets you turn fields on and off and change their labels easily by checking and unchecking boxes.

Click the Header tab on the left to start this process. Among your options here are:

• Form names. Do you want invoices to say “Invoice,” for example? Do you want to use form numbers and allow custom transaction numbers?
• How much of your company’s contact information should appear?
• Do you want fields for Terms, Due date, etc?
• Do you need to define custom fields?

You’ll see more options when you click on the Activity Table tab in the left vertical pane (see image above). Not only can you choose what content appears and how its labels read, but you can also indicate what percentage of that line each entry should occupy. Under WIDTH%, click on the plus (+) and minus (-) buttons to the right of each number to size it (your numbers, of course, should total 100).

Warning: Many of the decisions you have to make when customizing sales forms are simple. Others take some consideration, like custom fields and the handling of billable time. We can help you with these.

Click on the final tab in the left navigation pane, Footer, to add or edit text that should be displayed at the bottom of your sales forms. Click Save in the lower right when you’re done.

Note: As you’re browsing through the content options available as described above, you may find that a field appears to be missing or needs a default setting changed. If this occurs, click on the gear icon in the upper right of the main screen, then on Your Company | Account and Settings. Click on the Sales tab in the left vertical pane to get to Sales form content.
​
Consistent, well-designed sales forms will help promote your brand and present a polished, professional image to your customers.

Reports are your reward for all that hard work you put in entering records and transactions in QuickBooks. Sure, you can always find individual invoices, sales receipts, and customers by using the software’s search tools, but in order to make smart business decisions, you need to be able to see related subsets of the information you so carefully entered in neat rows and columns.

You’ve probably created at least some basic reports in QuickBooks. You may have, for example, wanted to see who’s late paying you, or whether you have unpaid bills. You might need to know your stock levels, or which purchase orders are still unfilled. You certainly want to keep a close eye on whether you’re making or losing money.

QuickBooks makes it easy to get those answers in only a few seconds. But to get really meaningful, targeted views of your accounting information, you’ll want to shape your reports so that they reveal precisely what you need to know. You can do some of this on your own, but you might want to enlist our help to drill down even further – and to create and analyze the more complex output that some reports can provide.

Configure Preliminary Settings
As we often do when we’re starting a tutorial on a specific QuickBooks feature, we’re going to send you to the Preferences window first thing. Open the Edit menu and select Preferences, then Reports & Graphs. With the My Preferences section open, you can instruct QuickBooks on some of the ways reports should be handled. You can choose to:

• Have the Modify Report window open every time you create a report (to remind you to make any necessary changes first).
• Set your Refresh options. If you always want to have the most current data displayed when you generate a report, you can tell QuickBooks to Prompt me to refresh or Refresh automatically by clicking on the button in front of the appropriate response. Choose Don’t refresh—the fastest method—if you don’t want to be interrupted when you’re working with a report. You can refresh when you’re done.
• Draw graphs in 2D to make them run faster, and Use [black and white] patterns instead of colors to better differentiate between segments.
• Each person who has access to QuickBooks can set these Preferences any way he or she wishes.

You can decide on your own whether Aging Reports should start the aging process from the due date or the transaction date. Decide how you want Items and Accounts to appear in reports. And if you click the Format button located directly below Default formatting for reports, you can alter their appearance, for example, by changing fonts and indicating what information should appear in the header and footer.

For other preferences, you may need our help. Do you understand the difference between running Summary Reports as Accrual or Cash? And have you worked with a Statement of Cash Flows before so you can assign accounts to various sections? This is a report we should be generating and analyzing periodically for you, so don’t worry about dealing with it on your own.

​Note: QuickBooks was designed for small businesspeople, not accountants. But if you really want to get the most out of it to make the best business decisions possible, let us help you with those concepts you don’t understand.

Unless you’re working with a very old version of QuickBooks, you have two options for accessing the software’s reporting functions. You can simply click on Reports in the left vertical pane to open the Report Center. Or you can get there by opening the Reports menu (which includes links to other areas, like the Transaction Journal, in addition to lists of QuickBooks’ reports divided by category).
​
Next month, we’ll look at some reports and their customization options in QuickBooks. In the meantime, as always, we’re available to work with you on enhancing your knowledge of QuickBooks reports and their setup.

How does your company keep track of its bills now? If you’re like a lot of small businesses, you’re still dealing with a lot of paper. You may have a paper or electronic calendar where you enter all of the due dates as bills come in. When you see one approaching, you either take out your checkbook or schedule an online payment. Then you store all of your paid paper bills in file folders in case you have to look back at them.

It’s probably pretty clear to you that this isn’t the best system. You occasionally miss payments because a bill was lost in transit or for some other reason didn’t make its way to you. Or you were out of the office for a few days and didn’t look back on deadlines you missed. QuickBooks Online can help keep bill-payment running smoothly and your relationships with vendors on the up-and-up.

Before you can start paying bills, you have to enter them into QuickBooks Online. This will entail a bit of extra work the first time you deal with a particular vendor, but there are numerous benefits to handling your accounts payable in this fashion, like:

• Speed. Once you’ve created a framework (template) for a bill, it will take minimal time to pay it in the future.
• Documentation. All of your bill payments will be recorded in QuickBooks Online, so you won’t have to hunt through checkbook registers or file folders to see if a bill was paid.
• Timeliness. QuickBooks Online will always remind you when a bill must be paid (if you’ve set it up correctly).

To enter a bill, click the plus (+) sign at the top of the screen and click on Vendors and then Bill. This screen opens:

Looks pretty simple, doesn’t it? It is – if you have a simple bill like the one you receive for gas and electric. You select the vendor by clicking on the arrow next to the blank field in the upper left and choosing from the list that opens. The Mailing Address and Terms should fill in automatically if you’ve done all of your initial QuickBooks Online setup. If not, you can add and edit this information.
​
Bill date refers to the date of the bill itself, not the day payment is due to the vendor. That goes in the Due date field. Select your Account from the list that opens when you click in that field, and enter a Description and Amount. If that’s all that’s required for that bill, you can save it and proceed to the next. It’s now recorded as a bill that needs to be paid.

Some of your bills are just one-offs,but others arrive on a regular basis. So QuickBooks Online has tools that will minimize the time required to process them after you’ve entered the basic information once. After you’ve completed a bill, click Make recurring at the bottom of the page to see this screen:

This screen is self-explanatory. You simply tell QuickBooks Online how much notice you want before a bill’s due date so you can process the payment. Take care with this screen to avoid paying bills too early, which affects your cash flow unnecessarily, or too late.
You have three options when you’re creating a Recurring Bill template. You’ll choose one from the list that opens when you click the arrow in the Type field:

•  Scheduled. This is best used when the details of a transaction don’t change, like rent or a loan payment. You don’t have to do anything for the payment to be dispatched; it’s done automatically for you at the interval you set. You can, however, ask to be notified every time this occurs.
• Reminder. You could use this for periodic payments that will require editing before they’re sent. For example, you’ll probably need to change the amount on your utility bills every month. QuickBooks Online will place a reminder in your Activities list on the home page.
• Unscheduled. If you have bills that contain a great deal of detail but aren’t due on a set schedule, you can save the template and call it up when you need it by clicking the gear icon in the upper right and selecting Recurring Transactions.

Next month, we’ll talk about the process of actually paying bills. If in the meantime you start entering bills and find that you’re having trouble completing the fields required for more complex bills, call us to schedule a session or two.

Considering processing your own payroll in QuickBooks? Whether you’re moving from a payroll service or getting ready to pay your first employee, you’re taking on a complex set of tasks that requires a great deal of setup and absolute precision. But the reward is complete control over your compensation records and transactions, and constant access to your payroll data.

If you have no experience dealing with paychecks, deductions, and payroll taxes, we strongly recommend that you let us help you get started. QuickBooks simplifies the actual mechanics of setting up and running payroll, but there’s still a lot you need to know.

That said, we’ll give you a brief preview of how QuickBooks Payroll Items work. You must first make sure that payroll is turned on. Open the Edit menu and click Preferences, then click Payroll & Employees | Company Preferences.

Under QUICKBOOKS PAYROLL FEATURES, make sure the button in front of Full Payroll is filled in by clicking on it. If you’re interested in exploring Intuit’s online payroll service, we can tell you about that, as well as advise you on the other options displayed here.
​
This element of your accounting is complicated enough that QuickBooks has a separate setup tool to guide you through the myriad details you’ll need to provide. You find this tool by going to Employees | Payroll Setup. This is a multi-screen, wizard-like tool that walks you through the process of providing information about employees, compensation, benefits and other additions/deductions, and taxes. Each page poses questions, and you provide answers by entering data and selecting options from drop-down lists. In doing so, you’re creating Payroll Items.
​
This is a time- and labor-intensive process, one that will send you scrambling for all of the minutiae that make up your payroll system. Once you have your payroll framework established, though, as we said earlier, everything will be in one place and easily accessible.

The information you entered in Payroll Setup is likely to change and need modification. Maybe you forgot to account for something while you were working in the wizard, or perhaps you just want to look up a bit of payroll data. To do any of these, open the Lists menu and click on Payroll Item List.

The window that opens contains a list of the Payroll Items you created. It looks like a checkbook register, with one line devoted to each item. You’ll be able to view, for example, its Type, any Limit imposed, the Payable To name, and Tax Tracking designations. At the bottom of this list, you’ll see three drop-down menus: Payroll Item, Activities, and Reports. When you click on the down arrow next to Payroll Item, you’ll see the menu displayed in the above image.

Warning: There are many options in this menu for altering Payroll Item definitions. QuickBooks allows you to do this, but we would caution you here. If it involves an action that we have not gone over with you, please ask us about it.

​This is fairly self-explanatory. To Edit or Delete a Payroll Item or make it Inactive, highlight it in the list and click on the correct option. You can also Customize Columns in the table and perform other related tasks. When you click on New Item and select EZ Setup on the next page, this window opens:

QuickBooks will help you here by asking questions and building a Payroll Item based on your responses. There’s much more to know about working with Payroll Items and assigning them to employees. We’re ready to help introduce you to payroll processing in QuickBooks – once you’re ready to take it on.

Budget. The word evokes a sense of dread in most small business managers’ minds. Large corporations have entire teams of accountants that work on this critical element of financial planning. You, on the other hand, must go it alone – or with the help of other staff if your company is big enough.

Why is this chore so difficult? Several reasons. The biggest stumbling block is probably the sense of uncertainty. How do you know what your income and expenses will be for the coming year? QuickBooks Online Plus can’t tell you how to plan the next year in terms of numbers, but its tools can make the mechanics of building a budget easier.

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 what the First month of fiscal year is.

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). QuickBooks Online 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. QuickBooks Online Plus’s 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.

QuickBooks Online 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. QuickBooks Online 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 QuickBooks Online 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 QuickBooks Online 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 Plus. As always, we’re happy to hear from you.

If you ever did your bookkeeping manually, you probably didn’t allow every employee to see every sales form and account register and payroll stub. Most likely, you established a system that allowed staff to work only with information that related to their jobs. Even so, there may have been times when, for example, someone pulled the wrong file folder or was sent a report that he or she shouldn’t have seen.

​QuickBooks helps prevent this by setting virtual boundaries. You can specify which features of the software can be accessed by employees who work with your accounting data. Each employee receives a unique user name and password that unlocks only the areas he or she should be visiting.

Here’s how you as the Administrator can define these roles. Open the Company menu and selectSet Up Users and Passwords | Set Up Users. The User List window opens. You should see yourself signed up as the Admin. Click Add User and enter a User Name and Password for the employee you’re adding. Confirm the Password and check the box in front of Add this user to my QuickBooks license. Click Next.

Note: You can have as many as five people working in your QuickBooks company file at the same time, depending on how many user licenses you’ve purchased. Not sure? Press F2 and look in the upper left corner. If you need more than five user licenses, talk to us about upgrading to QuickBooks Enterprise Solutions.

In the next window that opens (see above screen), you’ll be given three options. Probably you’ll most often select the second option, which lets you specify the screens this user can see and what he or she can do there. The first—All areas of QuickBooks—would seldom be granted. And the third allows us to come in and do whatever tasks have been outlined in our work relationship (troubleshooting, monitoring, creating and analyzing reports, etc.).

​Click the button in front of Selected areas of QuickBooks and then Next. You’ll see the first in a series of screens that deal with the software’s functional areas: Sales and Accounts Receivable, Purchases and Accounts Payable, Checking and Credit Cards, Inventory, Time Tracking, Payroll and Employees, Sensitive Accounting Activities (funds transfers, online banking, etc.), Sensitive Financial Reporting, and Changing or Deleting Transactions.

The Sales and Accounts Receivable screen is a good example. You can see the options offered in the above image. By clicking on the buttons pictured, you’re giving this employee permission to both create and print transactions. Below these options, you’ll be able to keep him or her from seeing customers’ credit card numbers in their entirety by clicking in the small box. When you’re finished, click Next.

Keep clicking Next and proceed through the rest of the screens. Your choices will be similar on each. But be sure to read all of the descriptive text very carefully. Keep in mind the importance of confidentiality issues and security as you go along.

The ninth screen, Changing or Deleting Transactions, deserves special attention. First, should this employee be able to change or delete transactions in his or her assigned area(s)? Even though you trusted these employees to work with finances when you hired them, consider this question carefully. Depending on the volume of transactions processed every day, you may want to reserve this ability for yourself.

We may or may not have established and password-protected a Closing Date for your company file. This is the date when the books for a specific time frame have been “closed,” meaning that transactions should not be entered, added, or deleted prior to it. We can talk with you about the pros and cons of such an action.

Here and on every other screen in this multi-step wizard, you can always click the Back button if you want to return to a previous window. When you’re finished, you’ll see a screen like the one in the above image that summarizes the choices you have just made.
​
If you’re feeling any uncertainty or confusion about the whole issue of access rights, we’ll be happy to go over your options with you. These are important decisions. You’ll want to stress to your employees that restricting their permissions does not signal a lack of your trust in them. Rather, QuickBooks provides these tools to protect everyone who uses the software as well as any external individuals and companies that might be affected.