The Life of an Estimate in QuickBooks Online

Estimates—or quotes, or bids—are useful tools when you’re pitching a sale of products or services. Here’s how QuickBooks Online handles them.

Sales estimates are standard procedure in many professions. You wouldn’t authorize a car repair without one. Nor would you OK a remodeling job on your kitchen or a summer’s worth of yard landscaping without knowing what the costs will be upfront.

Estimates don’t have to be formal documents. You could scribble a proposal for products or services and their prices on a paper napkin and have your customer sign it. But as we’ve said before, the quality of your sales documents reflects on your company’s professionalism as well as its image.

QuickBooks Online offers specialized tools to manage this step in the selling process. You can create detailed estimates that the site can easily convert to invoices when you get an approval. And QuickBooks Online reports help you monitor the progress of your quotes. Here’s how it works.

 

A Dedicated Form

You probably already know how to create an invoice. If so, you shouldn’t have any trouble generating estimates because the forms are very similar. To get started, click the + (plus) sign in the upper right corner of the screen. In the Customers column, click Estimates. A form like this will open:


QuickBooks Online provides a form template for your estimates.

Open the drop-down list in the Customer field and select the correct one (or +Add new).

Note: If you click on +Add new, you’re only required to enter your prospective customer’s name to create an estimate; contact detail, of course, will not appear on the form. You can go back later and complete a customer record, but it’s best to at least enter a physical and email address. Click +Details to open the complete record, then save what you provide there.

The word “Pending” should appear below the Customer field. This refers to the status of your estimate. Click the down arrow to the right of it, then on the down arrow in the small window that opens to see what options you’ll have later. If you want to copy someone else on the estimate, click the small Cc/Bcc link to the right and provide the email address(es).

Enter (or select by clicking on the calendar graphic) the Estimate date. If your offer is only good for a limited period of time, enter an Expiration date; otherwise, leave that field blank. Then go down to the Product/Service grid and select the items for which you’re providing an estimate, one on each line. Fill in the Qty field and check the labeled box if the item is taxable.

If you had created a product record for it already, the other fields should be completed automatically. If not, click +Add new. The Product/Service information pane should slide out from the right side of the screen. Here again, you’re only required to enter a Name, but you should really create the whole record and save it to return to the estimate. If you’ve not been through this process before, we can walk you through it.

You can add a discount to the estimate as either a percentage or a dollar amount in the lower right corner of the screen. You can also edit the customer message that appears in the lower left and attach any files necessary. When you’re done, save the estimate.

Estimate Options


You can work with your estimate from the Sales Transactions screen.

If you’re not already there, click the Sales link in the left vertical toolbar, and then the All Sales tab and the Estimates bar. Find your estimate and look at the end of the row, in the Action column. If you want to convert your estimate to an invoice, click Create invoice. In the window that opens, indicate whether you want to invoice:

  • A percentage of each line item,
  • A custom amount for each line, or,
  • The total of all lines.

Look over your invoice when it opens, complete any other fields necessary, and save it. Your estimate’s status has now been changed to Closed, and the new invoice created from it will appear on the Sales Transactions screen. It will also be included in the Estimates By Customer report.

If you can create an invoice, you can create an estimate. The tricky part comes in when you have to amend an estimate before you bill it – or even alter it and resubmit it. If you’re going to be working with estimates extensively, let us help you get it right from the start.

Social media posts

Does your business ever provide estimates (bids, quotes, etc.) to customers? QuickBooks Online can help you create them.

Did you know that you can add a discount when you create a customer estimate in QuickBooks Online? Ask us about this.

QuickBooks Online can convert an estimate to an invoice with one click, but amending before sending it can be tricky. We can help.

Did you know that QuickBooks Online contains an Estimates By Customer report, so you can easily keep track of their status? Find out more here.

Working with Employee Records in QuickBooks Online

Payroll requires countless details about each employee. QuickBooks Online will walk you through the process of entering them. And if you have a lot of employees working from home then you simply must use some work from home tracking software so that you can see what they are doing to make sure that none are doing other things.

If you’ve only been on the receiving end of a paycheck, you may not know just how much prep work went into your neatly-organized paystubs. Those official-looking columns of numbers that described how much you earned and how much was taken out – and for what purpose – were the result of a tremendous amount of data entry when you were hired.

Now it’s your turn to discover how complex that recordkeeping task is. QuickBooks Online was designed for small businesspeople who weren’t schooled in the intricacies of double-entry outsourced accounting, so it simplifies the process of preparing for payroll as much as possible. Still, it will probably be the most challenging element of your web-based bookkeeping.

We can help you navigate these sometimes-choppy waters so that you’ll be ready to run your payroll with confidence. Here’s an overview, though, of one of the most critical steps: creating employee records comprehensively and accurately.

Just the Facts

The left vertical toolbar in QuickBooks Online contains a link for Employees. This is where you’ll add and edit staff records. Once you’re set up and have begun running payrolls, the page that this link opens will display your current year’s payroll cost totals. There will also be a list of employees and their pay rates and payment methods; you’ll be able to click on their entries to view and edit their record details.

To get started, though, you’ll click on Add Employee. This opens a page that asks for the individual’s:

  • Full name,
  • Withholdings (you’ll enter W-4 information here),
  • Pay frequency,
  • Pay type and amount (multiple options are available here besides salary and hourly),
  • Deductions (retirement, health care, etc.), and
  • Pay method (check or direct deposit).

Figure 1: QuickBooks Online and its payroll component contain many screens like this that employ common data entry conventions. The mechanics are easy, but 100 percent accuracy is required.

Some of these requests for information have a small pencil icon next to them. This means that there are additional screens where you can provide the needed details. In the example above, you’re defining pay types that will be available to the employee, like sick pay and vacation pay.

Depending on your company’s benefits, entering deduction information may be the most detailed and time-consuming task. QuickBooks Online first lets you choose between entering a deduction/contribution or garnishment. If it’s health insurance, for example, you’ll have to indicate how much money will be deducted from employees’ earnings each pay period (in dollars or a percentage) and what the company-paid contribution will be (if any). If there’s an annual maximum, you’ll also enter it here, and you’ll indicate whether the premium amount is taxable or pre-tax.

A sample check is displayed in the right column of this page. As you enter information, the check will be filled in with the correct amounts. If you don’t have a particular detail at hand, you can save what you’ve done and come back later to finish the record. And you can always return to edit data you’ve supplied.

When you’ve completed all of this and clicked Done, you’ll be back at the Employees screen.

Click on the name of the staff person whose records you just created, and you’ll see something like this:

Figure 2: Once you’ve created an employee’s record, you can view all of its details and edit it as needed.

There will undoubtedly be times when you’ll want to see your employee data in report form rather than clicking through numerous individual records. QuickBooks Online offers several report templates that accommodate this. You’ll click on Reports in the left vertical toolbar, and then All Reports | Manage Payroll. The most relevant here in terms of viewing employee-related information are:

Running your first payroll can be daunting. We hope you’ll let us help you prepare for it.

…from the Team of Professional at RE-MMAP We are just a click or call away. www.re-mmap.com and phone # (561-623-0241).

How to Add Documents in QuickBooks

Accounting is about more than just numbers. QuickBooks lets you make documents available from within the program itself.

You could call QuickBooks a “green” computer program. It can conserve reams of paper by storing customer and vendor records, for example, emailing transaction forms, and accepting online payments.

Most small businesses are a long way from being “paperless offices,” despite the predictions so many people made when PCs became commonplace. Even though you’re making an effort to be as digital as possible with your accounting files, not everyone else is yet. So you still have to deal with paper.

And you’re probably still consulting paper documents or stored computer files or scanned images that relate to your accounting data. QuickBooks makes it possible to keep this information close at hand, easily accessible from the software itself.

The Doc Center

QuickBooks provides a centralized area for managing the documents you want to keep close at hand. The Doc Center contains tools you’ll need to work with your documents. From here, you can:

· Add them by locating them in your storage device or scanning them indirectly,

· See their details and add to them,

· Search for them, and,

· Either remove or detach them.

Figure 1: You’ll use the tools in the QuickBooks Doc Center to work with the documents you want to have available from within the program.

There are probably times when you have supporting documentation for invoices or customer and item records, for example. In these cases, you can attach those background documents to the related QuickBooks forms.

Easy Operation

It’s not difficult to work with documents in QuickBooks. But if you don’t have much experience working with file attachments or scanning paper forms, we can walk you through the process. To get started, click on the Docs tab in the left vertical pane or open the Company menu and select Documents | Doc Center. You’ll see a screen that looks like the one pictured above.

Let’s say you have a special price list you often need to consult. Click the Add icon. A window then opens that contains a directory of all of the folders and files on your PC and any external storage areas. Browse to the pricing document you created earlier and double-click it.

QuickBooks will return you to the main Doc Center screen, and you’ll see the name of your file and the time added in the first row of the data table there.

Deeper Descriptions

Figure 2: Once you’ve added files to the Doc Center, you can view and add details or open the original document.

Click in the box in front of the file name, and buttons in the lower right of the screen will light up. Click on View Details, and a small window opens. You can enter information in fields here to add a Title, Description, Keywords, and Comments. Click Save & Close when you’re done. Other buttons here let you Open the file or Remove it.

Note: To bring in documents, you can also drag and drop them from Outlook, folders, or your desktop. We can help you learn how to do this.

Scan a Document

You can also scan documents directly from your scanner into QuickBooks. Click Scan. The QuickBooks Scan Manager should open and locate your printer or scanner. After you’ve selected it and your other Scan Options, click the Scan button. If you’ve opted to see a preview, that page will appear for your approval.

Click Done, and you’ll have several options for working with the image. When you’ve finished, click Done Scanning and enter any desired descriptive details. Click OK, and the Doc Center will display again with your new scanned document in the list.

Attach to Forms

Figure 3: Many QuickBooks forms display the Attach File icon.

If you have supporting documentation for an invoice, for example, you can easily make it available from the form itself. Click the Attach File icon and select your file using the Doc Center’s tools. Once you’ve added an attachment to a form, the icon will display the number of documents that are available there.

Your computer’s storage space may be well organized, but you can still waste time trying to hunt down the document you want right when you want it. QuickBooks’ Doc Center can minimize your search time and ensure that important documentation is at hand.

…from the Team of Professional at RE-MMAP We are just a click or call away. www.re-mmap.com and phone # (561-623-0241).

Why You Should Use QuickBooks’ Snapshots

QuickBooks provides multiple ways to get information about your customers, and their payments, and your company itself. The software’s Snapshots provide quick, thorough overviews.

What do you do when you need to get information in QuickBooks about customers or about payments they’ve made in QuickBooks? You have several options. You could, for example:

  • Create a report
  • Go to their Customer pages
  • Click on Receive Payments on the Home Page and use the Findarrows (not very elegant or fast, but would be an easy way to find recent payments).

One of QuickBooks’ strengths is its flexibility. It helps you find the exact information you’re looking for in a variety of ways. Which one you choose at any given time depends on what screen you’re working on at the moment and precisely what slice of data you need.

A Home Base

The desktop version of QuickBooks doesn’t have a “dashboard,” like web-based financial applications do. Dashboards are like home pages on steroids. Rather than just providing navigational tools and menus, Snapshots display charts and grids and lists representing the data that you’d most likely want to see when you first log on, like account balances, summaries of income and expenses, and high-priority tasks, with links to related activity screens. You can usually customize these.

QuickBooks’ Reminders tell you what needs to be done either today or very soon. But they don’t reveal anything about your financial status. Snapshots do. There are three versions: Company, Payments, and Customer.

QB-4

Figure 1: The QuickBooks Customer Snapshot sums up each customer’s activity and history in a one-page view.

Many Sections

Let’s look at the Customer Snapshot to see how these work. To find it, click on Snapshots in the left vertical navigation pane. When the window opens, make sure that the Customer tab is active; if not, click on it. Click on the arrow next to the CUSTOMER field in the center of the very top to select a customer.

You’ll see three columns of information here. The left pane displays some commonly sought numbers (like Total Sales) and some numbers that you might have trouble finding any other way (Average days to pay, etc.). In the middle, you’ll see Recent Invoices and Recent Payments. And the right section (not shown in the screen shot) includes two customizable graphs, Sales History, and Best Selling Items.

This is the default layout, the information boxes you’ll see when you first open the Company Snapshot. To remove any of them, click on the X in the upper right corner. You can restore them at any time by clicking the arrow next to Add Content in the upper left and then click the +Add button next to the one you want.

You can also move the blocks into different positions on the page. Grab one by clicking on its header and holding it, dragging it to the preferred position, and releasing it.

Personalized Pages

QB-5

Figure 2: You can add, delete, and move blocks of data around in the Customer Snapshot.

Users who have been assigned access to the data that each Snapshot contains can customize their own views by adding or deleting sections and rearranging them. So each employee can have his or her own unique-looking Snapshots, though the real-time data in all of them will be the same.

Note: If you’ve given employees besides yourself access to QuickBooks, it’s important that you assign permission levels to them. You probably don’t want everyone to be able to see and modify everything in your file. We can help you set these up.

Other Snapshots

The other two Snapshots are more complex, containing more data options. They can, however, be customized in the same ways that you personalized the Customer screen. The Payments Snapshot can give you a quick update on things like Recent Transactions and A/R by Aging Period.

The Company Snapshot lets you display up to 12 lists and charts, including:

    • Account Balances,
    • Customers Who Owe Money,
    • Expense Breakdown, and,
    • Vendors to Pay.

This would be a good page to use as your dashboard (home page), especially since it can also show you your Reminders. With the Company Snapshot open, go to Edit | Preferences | Desktop View | My Preferences and click on the button in front of Save current desktop. Remove the checkmark in front of Show Home page when opening company file if one is there.

QuickBooks’ Snapshots can get you up to speed quickly on critical elements of your accounting file, but there are other reports that you should run regularly, including complex standard financials reports that require expert analysis. We can help you interpret these, which in turn will help you make smarter, more informed business decisions.

…from the Team of Professional at RE-MMAP We are just a click or call away. www.re-mmap.com and phone # (561-623-0241).

What You Should Know About the QBO Mobile App

QuickBooks Online’s as a result of Android and iOS app creation, lacks some features found in the browser-based version, but it provides mobile access to tools you may want on the road.

First, it’s free (except for your mobile data plan costs). Second, it’s good. And QuickBooks Online’s mobile app offers more functionality than you might expect. Available for iOS and Android smartphones and tablets, it gives you remote access to the features that you probably use most frequently on your desktop or laptop.

Figure 1: The navigational menu in QuickBooks Online’s mobile app slides out from the left side (iPhone 6+ version pictured here).

Why Mobile?

Since you can already access QBO on a laptop, why would you need an app that’s missing some of the main site’s functionality?

You don’t, necessarily. If your work doesn’t take you out of the office much and you don’t travel for the business, downloading the app may just create one more icon on your smartphone screen that you always see but never open. Check out https://www.sandcastle-web.com/ for best mobile solutions.

But you may want to consider using it if you, for example:

  • Want to work at home or in a coffee shop on your off hours,
  • Regularly purchase items or services that you will submit as expenses to your company,
  • Sell something on the spot and want to create a sales receipt,
  • Need to nail down a sale by creating an invoice immediately,
  • Get a question from a customer or vendor about a past transaction, or,
  • Have to look up a price and description for a product or service.

Figure 2: Using QuickBooks Online’s mobile app, you can create sales transactions wherever you are.

Many Limitations

QuickBooks Online’s mobile app is far from a replacement for the browser-based version. It has numerous limitations. For example, there’s no dashboard – no home page that gives you an overview of your finances and provides reminders about tasks that need to be done. Rather, the app opens to Company Activity, a list of the most recent transactions.

Customer and vendor records are not quite as detailed, and you can’t view or work with your Chart of Accounts. Some settings can be altered, but not nearly as many as on the main site.

There are only two reports available, Profit & Loss and Balance Sheet, which is a tiny percentage of what’s offered online. You can’t enter and pay bills, create purchase orders, or work with payroll. And you can’t check inventory levels.

But the app isn’t designed to be a management or everyday tool. You wouldn’t begin your QuickBooks Online experience with the mobile version; setup and high-level functions like reports, bank reconciliation, and assignment of user roles would be done online by the administrator. There’s a separate application for Intuit’s online payroll, and activities like issuing credits and defining recurring transactions would more likely be done from the office.

While they’re laid out differently, the QuickBooks Online mobile app manages to pack a lot of detail in a small space. It includes the features that a remote worker would most likely need to use. And some of those are quite comprehensive. Forms in the app, for example, lack very little compared to those in the browser-based version, especially those that deal with expenses and payments, which are often done outside of the office.

Figure 3: The QuickBooks Online mobile app looks different from the browser-based version, but it’s very easy to use, and some screens are quite detailed.

Examine Your Workflow

The ability to do accounting work on an app away from the office offers convenience and flexibility that browser-based QuickBooks Online doesn’t. First off, mobile applications show a degree of professionalism and responsiveness to customers and vendors you meet with outside the office. And it keeps you in touch with some of your financial data when you’re on the move.

But can using it create problems? Possibly. Data entered in the app shows up in the browser-based version as soon as it’s entered and saved. But you or your administrator wouldn’t necessarily know to look for an onslaught of expenses or invoices, and by the time they’re discovered, there could be some complications.

So if you’re planning to let employees loose on the QuickBooks Online mobile app and you expect that they’ll use it frequently, it’s best to establish policies ahead of time and make sure that the work that’s done remotely will mesh with the rest of your accounting activities. We can help you prepare well for your new mobile capabilities.

…from the Team of Professional at RE-MMAP We are just a click or call away. www.re-mmap.com and phone # (561-623-0241).

Why You Should Be Using Mobile Apps with QuickBooks

Intuit discontinued its own QuickBooks mobile app a while back, and decided to shift its focus on creating the best logo animation online software, which, by the looks of it, is impressive.

In days gone by, running a company was a 40 hour per week proposition. You might have taken work home some evenings or gone into the office on weekends.

Those days are over, thanks to the internet and mobile technology. This fundamental change in the way we do business means that it’s now hard to get away from work.

Your smartphone and tablet are usually within easy reach, and they’re always tempting you to check in.

On the flip side, that kind of 24/7/365 accessibility has numerous benefits. There are, for example, apps that can be integrated with your desktop QuickBooks company file, which enable you to:

  • Make sales wherever you are,
  • Document expenses as they’re incurred, and
  • Monitor employee time for payroll purposes.

Let’s take a look at these in more detail.

Mobile Sales

Figure 1: One of the oldest apps that integrates with QuickBooks is GoPayment. You can process transactions on your smartphone or tablet from anywhere.

Payment-processing on smartphones has become commonplace these days. You’ve probably seen merchants accepting credit cards on mobile phones in one of two ways: by swiping the card on a small card reader that attach to their device or by entering bank cards numbers directly.

Intuit’s GoPayment lets you do either. You can download the free app and process a customer’s payment on your smartphone. However, you still have to download it into QuickBooks and either create a sales receipt or match it to an open invoice. This isn’t a difficult process once you understand it, but you must be sure to do it correctly from the start. We can do some practice runs with you.

Benefit: Improved sales that aren’t dependent on location

Travel Expenses On the Go

One of the smartest, most useful apps that has ever been created is the expense reporter – particularly when used by your road warriors for on-the-go expenses. There are a handful of these. Travelers can record expenses in two ways: they can either enter the information directly or snap a picture of a receipt with a smartphone. When your employees get back to the office, they’re able to prepare complete expense reports, whose approved data can be transferred into QuickBooks.

Concur is one of these apps. When you set it up, it imports Account Codes, Customers, Jobs and Classes, and Vendor and Employee Records from QuickBooks so that these can be assigned for each expense entry. Credit card transactions can be imported directly. When an expense report is completed, it can be sent to a manager for approval, and reimbursement is then deposited in the employee’s bank account.

Figure 2: Intuit’s App Center is home to hundreds of add-on applications for QuickBooks.

Tallie works similarly. It can automatically categorize expenses and alert approvers to expense policy violations. Used in conjunction with Bill.com and SmartVault, it can accommodate a sophisticated, seamless accounting workflow. We’ll see more multi-app integration as cloud-based financial solutions mature, but if you’re going to attempt such a setup, let us help you with the initial mechanics.

Benefit: More accurate, policy-compliant expense reports

Time-Tracking and Timesheets

If all of your employees walk through the office door every morning and stay there, you don’t need a mobile app for time-tracking. But for businesses whose cash flow depends on recovering and recording every minute of billable time, a smartphone time-tracker is ideal

 

TSheets Time Tracker can help improve your bottom line in numerous ways. This particular app:

  • Accomodates real-time mobile data entry,
  • Tracks employee locations using GPS, and
  • Creates timesheets that can be synchronized with QuickBooks, tracking billable time by customer, job, employee, etc.

Benefits: Employee accountability; recovery and correct classification of all billable hours; and less time required to create timesheets.

Moving Toward Integration

Given the size limitations of smartphones, some mobile apps contain only a subset of the features found in their desktop counterparts. But that subset is chosen based on the needs of mobile users.

Fewer features mean that your learning time for the mobile apps that integrate with QuickBooks will be minimal. But the steps to sync with QuickBooks must be followed to the letter, and you may not be familiar with such a process. We want you to experience the benefits that these smartphone solutions can offer without compromising the integrity of your QuickBooks company file. Let us introduce you to these forward-looking, beneficial tools.

…from the Team of Professional at RE-MMAP We are just a click or call away. www.re-mmap.com and phone # (561-623-0241).

Working With Your Accounts in QuickBooks Online

“Account” can mean more than one thing in QuickBooks Online. Here’s a look at its multiple concepts.

Until you started doing your company’s accounting, the word “account” probably meant a checking or savings account at a bank or your identifying information at a place like a brokerage.

In QuickBooks Online, “account” can mean the same things. It can also refer to one entry in your Chart of Accounts or your Intuit payment account, a customer or vendor account, and more.

You’ll probably work with all of these in the course of your lifetime with QuickBooks Online, except one: the Chart of Accounts. Although the site allows you to modify the Chart of Accounts by adding, deleting, or renaming accounts, please talk to us if you feel a change is in order. The Chart of Accounts forms the framework of your QuickBooks Onlinecompany, and altering it could have adverse effects on your entire accounting operation.

Everyday Use

One of the first things you probably did when you created your company was to create at least one banking account, probably checking accounts. You can set this up without connecting to a bank site; however, that defeats the purpose of QuickBooks Online, which is to have access to your web-based accounts.

Figure 1: QuickBooks Online’s home page displays balances for all of the accounts you’ve connected.

Setting up a connection to your online bank, brokerage, credit card, orother online financial service like PayPal is easy. On the home page or the Transactions | Banking page, click the Add account button in the upper right. QuickBooks will display logos for some of the most popular financial institutions. If yours isn’t there, enter its name or URL in the box at the top.

QuickBooks Online will then create a link between itself and your account, and it will download the most recent transactions (usually 90 days’ worth). Sometimes, it might recommend a chartered accountant to help with your small business needs. Now when you click on
Transactions | Banking, you’ll see all of your activity in table form with columns labeled Date, Description, Payee, Category or Match, Spent, Received, and Action.

Most of these are self-explanatory; they just provide information about the transaction. You may be unfamiliar, though, with Category or Match and Action (Add). We recommend that you let us guide you the first time you launch and work with a transaction download. It’s very important that transactions are classified correctly.

The Chart of Accounts
The Chart of Accounts, which is a standard, required element of any double-entry accounting system, is a very different set of accounts. To display it, you’d click on your company name in the upper right corner, then Settings | Chart of Accounts. We see a mini-spreadsheet that lists all of your accounts. QuickBooks Online selected these based on the information you provided when you were first setting up your company on the site.

Each account is assigned a Type that describes its accounting function.

Figure 2: Every transaction that represents money you spend on Advertising/Promotional activities should be assigned to this Expense in the Chart of Accounts.

Category Types are used by all businesses for classification purposes. There are only a few of them, such as:

  • Expenses (Bad Debts, Bank Charges, Insurance, Job Materials, etc.)
  • Income (Billable Expense Income, Gross Receipts, Markup, etc.)
  • Cost of Goods Sold (Cost of Labor, Freight & Delivery, etc.)

You don’t have to do anything with your Chart of Accounts. In fact, we suggest you don’t try. As we’ve said, if we see a reason in your bookkeeping to add, edit, or delete an account, we’ll be happy to do it for you. But you will encounter these accounts in numerous QuickBooks Online activities.

Sometimes they’ll be pre-selected for you by the site, but other times you’ll need to make a choice. For example, when you create a Product or Service, there will be three account fields that will already be populated. They are:

  • Inventory Asset Account = Inventory Asset
  • Income Account = Sales of Product Income
  • Expense Account = Cost of Goods Sold

The word “account” is used in so many different ways that it can get confusing. For example, if you wrote a check at the UPS Store for some shipping charges, you’ll be asked for the Account when you enter this in QuickBooks Online. It’s an Expense, but one of its more specific sub-categories.

Figure 3: QuickBooks Online provides the correct drop-down list in form and record fields.

QuickBooks Online takes care of a lot of the background work of double-entry accounting. But it necessarily exposes you to the concept of accounts. We’re here to help if this causes confusion in your daily bookkeeping.

…from the Team of Professional at RE-MMAP We are just a click or call away. www.re-mmap.com and phone # (561-623-0241).

Setting Up User Access in QuickBooks

Will multiple employees be working with your QuickBooks company file? You’ll need to define their permission levels.

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 username and password that unlocks only the areas he or she should be visiting.

To help minimize errors, maintain data integrity, and preserve confidentiality, QuickBooks lets you restrict users to designated areas in the software.

Here’s how you as the Administrator can define these roles. Open the Company menu and select Set 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.

When you give employees Selective Access in a particular area, you can further define their roles there.

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.

A summary of user access rights

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.

…from the Team of Professional at RE-MMAP We are just a click or call away. www.re-mmap.com and phone # (561-623-0241).

Using Sales Receipts: The When and How

Some types of businesses always use sales receipts. Some use them occasionally. Here’s what you need to know about them.

How do you let your customers know how much they owe you, and for what products or services? In these days of ecommerce and merchant accounts, your customers may provide a credit card number over the phone or on a website. Or perhaps you send invoices after a sale and receive checks or account numbers in the mail. QuickBooks can help you both create the invoices and record the payments.

There’s another type of sales document that you can use in certain situations: the sales receipt. You’d probably be most likely to use one of these when customers pay you in full for products or services at the same time they receive them.

If you receive full payment for a product or service at the same time the customer receives it, you should use a sales receipt.

Completing a sales receipt is similar to filling out an invoice or purchase order. Click Create Sales Receipts on QuickBooks’ home page or open the Customers menu and select Enter Sales Receipts. A screen like the one above will open.

Choose a Customer from the drop-down list and a Class (if applicable). If you have created more than one Template (more on that later), make sure that the correct one appears in the field. Verify that the appropriate Date and Sale No. read as they should. Click on the type of payment you’re receiving, and enter the check or credit card number where necessary (a small window will open for the latter).

Note: If you are working with a type of payment that does not appear in the four icons, click on the arrow below More to add it.

Now you’re ready to select the products or services you sold by clicking on the arrow in the field under Item to open the available list (if you have not created a record for what you’re selling, select <Add New> and complete the fields in the New Item window that opens). Enter the quantity (Qty.). The Rate, Amount, and Tax fields should fill in automatically, based on the information you entered when you create the item’s record.

When you’ve entered all of the items that the customer is paying you for, you can choose which Customer Message will appear on the sales receipt (you can see your options in the drop-down list found in the lower left corner of the screen). Anything you enter in the Memo field will be for your internal use only; it will not appear on the printed or emailed sales receipt.

Click Save & Close or Save & New.

Customizing Sales Receipts

 

QuickBooks provides tools for customizing forms, including sales receipts.

QuickBooks’ forms contain the fields most often used by small businesses. But you can alter them in numerous ways to meet your company’s needs. To customize a sales receipt, open the Sales Receipt window and click on the Formatting menu. Select Manage Templates.

You’ll want to make a copy of the original sales receipt so that the original will always be available. Click the Copy button in the lower left. “Copy of Custom Sales Receipt” appears in the list of templates. In the Preview pane on the right, click in the field next to Template Name and replace the existing name with a new, more descriptive one if you’d like. Click OK.

The Basic Customization window opens. Click on Additional Customization at the bottom of the screen. You’ll see a window like the one in the image above. Click the Columns tab. The list on the left displays all of the columns that can be included in the body of your sales receipt.

Click in the boxes below Screen and Print to indicate which columns should display on your QuickBooks screen and which should appear on the customer’s copy. The numbers in the Order column can be changed to reflect which column will come first, second, etc.

Numerous Options

There’s a lot more you can do to customize your QuickBooks forms. And there are other situations where you might want to issue a sales receipt. We’ve only been able to touch on both topics here, but would be happy to schedule time with you to explore these elements of QuickBooks.

…from the Team of Professional at RE-MMAP We are just a click or call away. www.re-mmap.com and phone # (561-623-0241).

Better Budgeting Using QuickBooks Online Plus

Everyone groans when budget time rolls around. QuickBooks Online Plus offers tools that simplify the process.

Budget. The word evokes a sense of dread in most small business managers’ minds. Large corporations have entire teams of accountants Gympie that work on this critical element of financial planning. You, on the other hand, must go it alone – or with the assistance of an external company, such as Phoenix Accountants and Advisors, 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.

Your Fiscal Year Start

Finding the start of your fiscal year in QuickBooks Online Plus

Do you know exactly when your fiscal year starts? You’ll need this information before you can get started on your budget and there is no better place to get it that from professional financial advisor services. 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.

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). 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.
You can choose from these three options to create your budget in QuickBooks Online Plus.

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.

Entering the Numbers

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.

Entering quarterly budget data

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:

QuickBooks Online Plus can divide quarterly totals into monthly budget numbers.

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.

.…from the Team of Professional at RE-MMAP We are just a click or call away. www.re-mmap.com and phone # (561-623-0241).