Friday, September 29, 2017

Are You Using QuickBooks Online's Mobile App?

Even if you don’t travel for work (but especially if you do), you should explore what QuickBooks Online’s mobile app has to offer.
You already know how convenient it is to be able to access your company’s financial data from any desktop or laptop computer that has an internet connection. Still, there are times when you’d like to be able to complete some of your accounting tasks without firing up a full-blown browser and logging on to QuickBooks Online.
If you haven’t yet tried out the site’s companion mobile app, you might be surprised at how much you can actually accomplish on your smartphone. Take a look at the app’s main menu (with a partial view of the Activity screen to the right):




You can’t do everything on QuickBooks Online’s smartphone app that you can do in the browser-based version, but there’s a surprising amount of functionality here.
Once you’ve downloaded the app and signed in with your QuickBooks Online user name and password, you’ll see a home page divided into two vertical sections; you can toggle back and forth between them. One is your Dashboard, which displays current account balances and a graph showing an abbreviated version of your Profit and Loss report, as well as a graphical summary of paid and unpaid invoices. Click on Activity to see a list of your most recent actions and transactions.
Click on the three horizontal lines in the upper left of the screen, and the app’s main menu slides out. As pictured in the image above, this interactive list also serves as the app’s primary navigation tool. Any data that you’ve entered in the browser-based version (as well as anything you add here) will appear in list form when you click on an entry here. To add customers, invoices, sales receipts, etc., click on the + (plus) sign. You can also enter new transactions from each individual list screen.
Adding Transactions
If you’ve worked with mobile apps at all, you know that the user interface is different from what you see in full versions of applications accessed through a browser. QuickBooks Online’s app, though, is exceptionally easy to understand and use – perhaps even easier than the browser-based QBO.
Take the app’s New Expense screen, for example. At the top of the page is a camera icon. Click it to take a picture of a receipt. You can also enter the total manually in a field to the right. Below that are three buttons representing Credit, Check, and Other, so you can indicate how you paid for the purchase.
You’ll describe the expense by clicking on links that contain labels like:
  • Who did you pay?
  • What kind of expense is this?
  • Who was it for?
When you click on one, the app opens your list of related data. So, Who did you pay? opens your list of Payees. You can select one or add a new one. Click on the Billable button if the expense can be charged to a customer, and click Add a Split if you need to separate some of the items. There’s also room to add a Ref # and Memo. When you’re done, click Save to add it to your main QuickBooks Online file.
Viewing Existing Information






Besides entering data in the QuickBooks Online app, you can look up existing information.
You can just as easily find records and transactions you’ve entered either in the browser-based version of QuickBooks Online or on the app. You can follow the journey of an invoice as pictured in the screen shot above. QBO even prompts you to complete steps you haven’t taken. Click on the pencil icon in the upper right, and you can edit the data that appears on that screen.
Warning! Editing transactions that have been processed is risky. If you’re making errors that need correcting, we can help you determine when this is safe.



The QuickBooks Online app can also provide quick overviews of customer activity, with links to actions.

You may never need to access your QuickBooks Online data remotely on your smartphone. If you do, though, we can help you get set up with the site’s companion app so you’ll learn how they work together.

Wednesday, September 20, 2017

Using QuickBooks’ Income Tracker

QuickBooks provides numerous ways to learn about your company’s health. Income Tracker is one of the most effective.
You can get an enormous amount of useful information from QuickBooks’ reports – especially if you customize them to isolate the precise data you want. Reports included with the software range from the very simple, like Open Invoices, to output that’s exceptionally complex, like Trial Balance and Profit & Loss.
Warning: Standard financial reports like Trial Balance are easy to run in QuickBooks, but very difficult to understand and analyze. You should, though, be aware of what they’re telling you at least once a quarter – even once a month in some cases. We can help with this.
Sometimes, especially first thing in the morning as you’re planning your day, you just want to cut to the chase and get a quick overview of your company’s finances. That’s where QuickBooks’ Income Tracker comes in. It not only provides that overview, but it also contains links to related screens where you can do the work that’s needed there.
A Simple Layout
Click the Income Tracker link in the toolbar to open the tool’s main screen. If you’ve been using QuickBooks for a while, you’ll see a framework like this with your own company’s data already filled in.

QuickBooks Income Tracker displays both summaries of income types and the specific transactions that contribute to those totals.
Look first at the top of the screen. You’ll see six horizontal bars, each of which represents groups of transactions that either require immediate attention or will at some point in the future. Besides identifying the type of transaction, each block displays the number of transactions involved and their total dollar amount. They are:
  • Estimates – estimates that have been created and shared with customers, but haven’t yet turned into sales
  • Sales Orders – orders that have been entered but have been neither fulfilled nor converted to invoices
  • Time & Expenses – hours that have been recorded for customers but not yet invoiced
  • Open Invoices – invoices that have been created and sent to customers, but no payments have been received
  • Overdue – open invoices that have passed their due dates
  • Paid Last 30 Days – payments that have been received within the last 30 days
Modifying the View
Click on any of the colored bars, and the list of transactions below will change to include only those that meet that particular criteria. To get back to the default display of all transactions, click the Clear/Show All link in the upper right of the screen.
QuickBooks also lets you display a user-defined subset of the transactions. Click on one of the four drop-down lists above the transaction grid itself to change the view of:
  • Customer: Job – choose just one from the complete list
  • TypeSales Orders, Invoices, Received Payments, etc.
  • Status All, Open, Overdue, or Paid
  • Date – multiple ranges available
You can also modify the toolbar if your company doesn’t use all the sales forms/transaction types supported. To do so, click the gear icon in the far upper right of the screen and click in the boxes in front of Estimates, Sales Orders and/or Time & Expenses to remove them.
Taking Action
QuickBooks’ Income Tracker provides a great way to get a quick look at your finances. But it also serves as a launching pad for related activities.

Click the down arrow in the Action column to take care of tasks related to that transaction.
Highlight a transaction by clicking in the row, then click the down arrow at the end of the row in the Action column. The options that appear there depend on the type of transaction you selected. Choose a Sales Order, for example, and you can Convert to Invoice, Print Row, or Email Row. Options for an invoice are Receive Payment, Print Row, or Email Row.
As we said before, QuickBooks offers numerous reports that can give you more insight about your accounts receivable. If you understand the software’s robust customization tools, you can create reports about your income that will answer questions you may have. If you don’t, let us know. We’ll be happy to work with you on pulling together just the data you need.

Wednesday, September 6, 2017

What Is a Vendor Credit, and How Do You Record One?

Whether you’re getting a vendor credit for a refund or a return, you can record it in QuickBooks Online.
When you’re dealing with your company’s vendors, you’re probably accustomed to money flowing in one direction: theirs. Maybe you send them purchase orders and they send you invoices. Or they send you bills and you pay them. Or you walk into a store and buy something your business needs.
Sometimes, though, vendors owe you money. Probably the most common scenario is a return of merchandise, products that you’ve sent back to the supplier for any of a variety of reasons. You may be issued a credit of some kind simply because you’ve been a loyal customer, and a vendor wants to reward you. You might also get a rebate for an item you bought.
In these cases, you’ll enter a Vendor Credit in QuickBooks Online, which you can apply the next time you buy something from that supplier. Usually, the process is pretty straightforward, but sometimes situations arise that may make it hard for you to know how to record a vendor credit accurately. We can help if this happens.
Simple Steps
Let’s start with a simple example. Let’s say you received a shipment of pens that you’d planned to use as promotional items for your salespeople. The ink on some of the pens had gotten smudged, so your company email address printed on them was illegible. The supplier issued you a credit of $50.00 for future purchases, and sent you a reference number to use.
It’s easy to complete a Vendor Credit form in QuickBooks Online for a simple credit. But other situations are more complicated.


Here’s how it would work. Click the + (plus) sign in the upper right corner of the screen and select Vendors | Vendor Credit. A screen like the partial one pictured above would appear. These are the fields you would need to complete:
Vendor – Click the down arrow in the field in the upper left corner and select the correct vendor, or + Add New.
Payment date – Change the default date if it’s not correct.
Ref no. – Enter a reference number if applicable.
Under Account details, click in the field under Account, and open the drop-down list by clicking the down arrow on the right. Select the account you used when you created the original expense. Enter a Description and the Amount of the credit.
You can add a Memo in the box at the bottom of the screen if you’d like, and select any Attachments to include from your file directories. Otherwise, click Save and close or Save and new.
Additional Input
There’s much more to the Vendor Credit screen that you didn’t need to consider for this example. The row where you entered Account, Description, and Amount contains several additional fields that you may need to complete in some cases. They are Billable, Markup %, Tax, Customer, and Class. If you’re not sure when these fields are required, ask us to go over these concepts with you.
There’s also another section under Account Details you may need to address: Item Details (click the arrow to open if necessary). You would only enter information here if you’re returning items to a vendor. Fields displayed there include Product/Service, Qty (quantity), Rate, and Sales Amt (amount). We don’t recommend that you do this the first time on your own; let us help.
Using Your Credit
How do you redeem this credit? QuickBooks Online reminds you to use it.


QuickBooks Online records your Vendor Credits and reminds you that they’re there when you go to pay that vendor again.


The next time you enter a transaction that involves—or will involve—sending that vendor some money, you’ll see a record of that credit to the right of the Check or Expense screen, for example. In the image above, a small box has opened as soon as the vendor’s name was selected. You can Add that credit to the current transaction or Open it if you want to see the original screen.

Not everyone uses Vendor Credits. Some businesses find workarounds. But we recommend you at least understand when and how they’re used so your bookkeeping is accurate and precise. We’d be happy to spend some time with you going over your financial relationship with vendors, and how QuickBooks Online helps you document it.