Friday, April 29, 2016

What You Should Know About the QBO Mobile App

QuickBooks Online’s mobile app 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.
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.

Setting Up Settings in QuickBooks Online

You’ll be visiting QuickBooks Online’s Settings screen regularly, so it’s good to know what’s there.
You can get into a rental car and just start driving to your destination. But you soon realize that you need to know where the temperature controls and the radio tuner are. If it starts raining, you must know where the wiper controls are. And when it gets dark, you’d better know how to turn on the headlights.
The same goes for QuickBooks Online. You can create bills and start paying them or begin to invoice customers or record expenses as soon as you set up an account (though you’ll be adding a lot of data on the fly). But you’ll soon discover that those tasks would be easier if you had established all of your Settings first.
If you have multiple employees using QuickBooks Online, for example, it has probably occurred to you that not everyone needs to have access to everything in your company file. You’ll want to connect the site to your financial accounts, build a budget, and specify payment terms and types.
So it’s a good idea to visit your Settings screen early in your QuickBooks Online journey. It’s easy to find: just click the gear icon next to your company name in the upper right corner of the screen.
Figure 1: You’ll want to explore the Settings window early on in your use of QuickBooks Online, but you’ll often have occasion to revisit it.
Critical Functions
Some of the links in the Settings window take you to screens that you’ll have to pop into regularly in the course of your daily work. One that you’re likely to visit often is All Lists. Here, you’ll be able to complete tasks like:
  • Creating records for the products and/or services that you sell.
  • Setting up recurring transactions, regularly-scheduled invoices, bills, etc. that occur at periodic intervals. (Note: You can choose to either be reminded of these or let them be processed automatically. Please consult with us if you’re going to be using this feature, as it can create serious problems if it’s not set up exactly right.)
  • Adding or modifying customer payment terms.
Unless you went through the QuickBooks Online setup process on your own or with help from us, it’s important that you click on the link to Account and Settings under Your Company before you start entering live data. QuickBooks Online comes with its own default settings that many businesses would be likely to use; but you need to evaluate these and see if you need to change any of them to better fit your company.
Going through these settings one by one has another benefit: you will learn about things that QuickBooks Online can do that you may not have discovered.
Figure 2: Work your way through the Account and Settings screens to see what QuickBooks Online can do – and to determine how you want to handle its many features for your company’s accounting.
It’s easy to specify your preferences on these screens. You just click on each tab on the left in succession and go through each setting, toggling between Off and On by clicking on the words and clicking on any buttons whose actions you want to explore.
During this process, you may have to make decisions that you’ve never before considered. For example, do you want to use custom fields or custom transaction numbers? We can schedule a time to go through this together if you’d like to make sure that you know what each option means and whether you should employ it.
Restricting Access
Will anyone besides you be using QuickBooks Online? If so, you’ll need to visit the Manage Users screen. Here, you can assign roles to users and specify what areas of the site they can access, as well as what they can do there. A simple wizard walks you through this critical process.
Figure 3: What limitations do you want to put on additional QuickBooks Online users?
There are many other Settings that you’ll likely want to visit at some point, like when you’re ready to create a budget or do your first account reconciliation. But we can’t stress enough the importance of establishing your accounting settings and defining user roles. Get the most out of QuickBooks Online by customizing it to meet your company’s unique needs.

Are You Applying Finance Charges? Should You Be?


Assessing finance charges is a complicated process. But if you have a lot of late payments coming in, you may want to consider it.
There are many reasons why your customers send in payments past their due dates. Maybe they missed or misplaced your invoice, or they’re disputing the charges. They might not be very conscientious about bill-paying. Or they simply don’t have the money.
Sometimes they contact you about their oversight, but more often, you just see the overdue days pile up in your reports.
You could use stronger language in your customer messages. Send statements. Make phone calls if the delinquency goes on too long. Or you could start assessing finance charges to invoices that go unpaid past the due date. QuickBooks provides tools to accommodate this, but you’ll want to make absolutely sure you’re using them correctly – or you’ll risk angering customers and creating problems with your accounts receivable.
Setting the Rules
Before you can start, you’ll need to tell QuickBooks how you’d like your finance charges to work. It’s at this stage that we recommend you let us work with you. There’s nothing overly difficult about understanding finance charges in theory: you apply a percentage of the dollar amount that’s overdue to come up with a new total balance. But setting up your QuickBooks file with the finance charge rules you want to incorporate may require some assistance. If it’s done incorrectly, you will hear from your customers.
Here’s how it works. Open the Edit menu and select Preferences, then Finance Charge | Company Preferences.


Figure 1: Before you can start adding finance charges to overdue invoices, you’ll need to establish your company preferences.
What Annual Interest Rate percentage do you want to tack onto late payments? This is an issue we can discuss with you. Too low, and it’s not worth your extra time and trouble. To, high, and your customers may stop patronizing your business. And do you want to set a Minimum Finance Charge? Will you allow a Grace Period? If so, how many days?
You’ll need to assign an account to the funds that come in from interest charges. This needs to be an income account. In our example, it’s Other Income.
The next decision, whether to Assess finance charges on overdue finance charges, needs consideration – and some research. This may not be an option depending on the lending laws in the jurisdiction where your business is located. So again, if you want to charge interest on unpaid and tardy finance charges themselves, let’s talk.
When do you want the finance charge “countdown” to begin? When QuickBooks identifies a transaction that has not been paid within the stated terms, do you want the added charge to be applied based on the due date or the invoice/billed date?
Note: If your business sends statements rather than invoices, leave the Mark finance charge invoices “To be printed” box at the bottom of this window unchecked.
Applying the Rules
QuickBooks does not automatically add finance charges to your customers’ invoices. You’ll need to administer these additions yourself, though QuickBooks will handle the actual calculations. Open the Customers menu and select Assess Finance Charges to open this window:


Figure 2: You’ll determine who should have finance charge invoices created in the Assess Finance Charges window.
Make very sure that the Assessment Date is correct, as it has impact on QuickBooks’ calculations. Being even a day off makes a difference. Select the customers who should have finance charges applied by clicking next to their names in the Assess column. QuickBooks will display the Overdue Balance from the original invoice, as well as the Finance Charge it has calculated.
  • If you choose not to apply finances charges to a customer because he or she has provided a good reason for the late payment, be sure the box in the Assess column is unchecked.
  • If you want to change the finance charge due for a valid reason, you can type over the amount in the last column. This would be a rare occurrence and should be exercised only after consulting with us.
Important: If there is an asterisk next to a customer’s name, there are payments or credit memos that have not yet been applied to any invoice.
When everything is correct, click the Assess Charges button at the bottom. QuickBooks will create separate invoices for finance charges for each customer who owes them.
We can’t stress enough the importance of consulting with us before you start to work with finance charges enough. Keep your company file accurate and your customers happy by getting this complex accounting element right from the start.

Thursday, April 28, 2016

Use QuickBooks Custom Fields to Improve Insight

QuickBooks’ structure is universal enough to appeal to millions of small businesses. Custom fields help you shape it to meet your company’s unique needs.
If you’re using QuickBooks, you probably know that you’re complying with the rules of double-entry accounting. The software is designed such that you can be compliant with these requirements without even being aware of it. You’re dealing with invoices and purchase orders, bank account reconciliation and bill-paying and payroll, not debits and credits and journal entries. QuickBooks does the double-entry part in the background.
While every business that uses QuickBooks is following those same rules, each has its own unique structure and its own need to modify some elements of the program to do certain tasks, for example:
  • Store more specific information about customers, vendors, and employees in their records,
  • Differentiate between variations of similar inventory items, and,
  • Create more targeted reports.
This is where custom fields come in.
Defining Custom Fields
Figure 1: QuickBooks comes with pre-designed form and record templates.
One of the ways that QuickBooks simplifies your life as your company’s accounting manager is by providing pre-designed record and form templates. Need to create an invoice? There’s a form that already contains the most commonly-used data fields; you just fill in the blanks or select from drop-down lists. Want to store information about your customers and about the items you sell? Ditto.
But if you need more fields than QuickBooks offers on a record or form, you can easily add your own. The software lets you add 15 fields total to customers and jobs, vendors, and employees, and you’re limited to seven for any one record type. (If you want to use the same field in two of these, it will only count as one.) And you’re allowed to define up to five fields for your item records.
This type of modification is easy to do, but it’s critical that you think carefully about what fields you should add. You don’t want to learn three or six months down the road that one isn’t really necessary and two more are needed, for example. This is especially important when you’re creating records for inventory items.
You may want to schedule some time with us to go over this (and to explore QuickBooks’ item-tracking features if you’re new to managing inventory). You can change custom field names, but you need to understand how this will affect your data if you do this.
Figure 2: It’s easy to add custom fields to records, but be sure you give a lot of thought to what will be needed.
Let’s say you want to add some custom fields to your customer records. Open the Customer Center by clicking the tab in the left vertical pane or opening the Customers menu and clicking on Customer Center. Double-click on a customer or click on the small pencil icon in the upper right. The Edit Customer window opens.
Click on the Additional Info tab on the left and then on the Define Fields button in the lower right. The Set up Custom Fields for Names window opens, as pictured above.
Click in the first column, under Label. Enter the name of the field as you would like it to appear in records and reports. Then click in the box or boxes below Cust, Vend, or Empl. If you want to use the same field in more than one record type, enter a check mark in both. Continue to enter field names until you’re done, then click OK.
Now when you create a customer record, you can fill in the blanks. And your new fields will appear as filters in some reports.
Figure 3: Custom fields can sometimes be used in reports.
You’ll follow a similar set of steps when you create custom fields for items in QuickBooks. Open the Lists menu and select Item List. Double-click on any item to open the Edit Item window. Click the Custom Fields bar on the right, then Custom Fields and Define Fields. If your company sells a lot of products with multiple variations, talk to us before you attempt this.
Personalizing your copy of QuickBooks by adding custom fields has a lot of benefits. But this major structural change requires a lot of thought and planning up front to make sure that this feature is a plus for your business.

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 Find arrows (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.
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 clicking 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
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.