QuickBooks

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

 

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

 

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

 

The Specifics

 

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

 

Better balance between income and expenses.

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

 

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

 

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

 

More repeat business because of improved customer interaction.

 

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

 

A more stable, profitable inventory of products.

 

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

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

 

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

 

Readiness for growth.

 

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

 

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

 

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

 

Social media posts

 

Cash flow problems? Before you can solve them, you need to learn where the bottlenecks are. QuickBooks Online can help. Contact us to find out how.

 

Is your company ready to grow? You’ll need reports to show lenders and investors. QuickBooks Online can create them, and we can analyze them for you.

 

How well do you know your customers? Could you assemble a quick, thorough overview of their history with you? QuickBooks Online can, and we can show you how. Are you dealing with product inventory problems due to overstocks or insufficient orders from vendors? QuickBooks Online can help.

ValueMetrik CFO offers QuickBooks support as part of our package of accounting services for small and midsized businesses. Call us at 479-242-1236 now and find out how you can leverage QuickBooks to precisely track your finances or request your complimentary consultation online.

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.

Call us at 479-242-1236 now and find out how you can leverage QuickBooks to precisely track your finances or request your complimentary consultation online.

Even if you’ve been using QuickBooks Online for a long time, it’s good to step back and evaluate your actions.

“Best practices” aren’t enforceable rules. They’re simply guidelines businesses commonly follow in one area or another. If you’re in retail, for example, one best practice might be to always ask customers checking out if they found everything they were looking for. This serves two purposes: It conveys a feeling of concern for the customer’s shopping experience, and it may also lead to increased sales.

QuickBooks Online has many best practices, some of which may serve multiple purposes, including these:

• • They keep your company data safe and clean.
  • They provide insight on your financial status.
  • They save time.
  • They can lead you to better relationships with customers and vendors.

Are any or all the following common practices for your business?

Reconcile accounts regularly.

One of QuickBooks Online’s most useful features is its ability to connect to your financial institution’s websites and download cleared transactions. QuickBooks Online also offers tools to help you keep your accounts reconciled online, like you used to do every month when your paper statement came. Reconciling accounts can help you uncover errors. It gives you a truer picture of your cash flow, and it improves the accuracy and timeliness of some reports.

It’s not a particularly pleasant process, but you should be reconciling your accounts regularly in QuickBooks Online. We can help.

Clean up your lists.

Some lists in QuickBooks Online aren’t overly long. You don’t have to worry about, for example, Payment Methods, Terms, or Classes. Your lists of customers and vendors, products, and services, on the other hand, can grow unwieldy over the years. This means it can take more time than it should to scroll through lists when you’re using those entities in transactions. It also puts unnecessary stress on your company file. If you can’t delete any, at least make them inactive.

Never leave QuickBooks Online open when you leave your work area.

This goes for everyone, even people who work alone and don’t access their company files away from their work areas. The obvious reason is to keep someone else from getting in and authorizing payments, for example, or otherwise compromising your financial information. It also protects the integrity of your data file in case your internet connection suffers some kind of outage.

Keep track of 1099 vendors.

Whether your company uses 10 vendors or a hundred or more, you may have to supply at least some of them with an IRS Form 1099 at about the same time you’re preparing W-2s for employees. Your 1099-related tasks will be much easier if those individuals and/or companies are earmarked. If you think vendors might need 1099s when you create their records in QuickBooks Online, click in the box to the left of Track payments for 1099 in the lower right corner. Not sure? Ask us.

Classify everything with care.

Every time you have to create a record or transaction where categories are involved (i.e., Classes, Customers and Vendors, Territories), check and double-check that you’ve assigned them the correct classification. Errors here can result not only in problems with daily workflow, but your reports will not be accurate. A related best practice: Create a meaningful group of Classes, and use them faithfully. They’ll help you make better business decisions.

View reports on a regular basis.

There are some advanced financial reports in QuickBooks Online that we should be creating for you on a regular basis, either monthly or quarterly. These include Profit and Loss, Balance Sheet, and Statement of Cash Flows. The mechanics of creating them aren’t difficult, but analyzing them is. You should be running reports on your own at frequencies that you think would be helpful, like A/R Aging Detail, Unpaid Bills, and Sales by Class Detail.

If you’ve been using QuickBooks Online for a while, you could probably come up with your own list of best practices. If you’re new to the site, consider scheduling some time with us to go over more of them. Develop good habits from the start, and there won’t be nearly as much need for troubleshooting down the road.

ValueMetrik CFO offers QuickBooks support as part of our package of accounting services for small and midsized businesses. Call us at 479-242-1236 now and find out how you can leverage QuickBooks to precisely track your finances or request your complimentary consultation online.

Intuit discontinued its own QuickBooks mobile app a while back, but there’s still plenty of processing power available for your smartphone or tablet.

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.

To learn more about QuickBooks for your business, contact our Fort Smith, AR Accounting Firm* today at 479-242-1236. Or learn more about our QuickBooks™ Setup and Support Services.

You work hard to make sure your QuickBooks data is accurate. Make sure it’s safe, too.

Your QuickBooks company file contains some of the most sensitive information on your computer. You may have customers’ credit card numbers and employees’ Social Security numbers. An intruder who captured all that data could create tremendous problems for you and a lot of other people.

That’s probably the worst-case scenario. But other situations could also spell disaster for your business, which involves losing your company data through fraud, hacking, or simple technical failures.

We can’t overstate the vital importance of protecting your QuickBooks company file, especially your customer and payroll information. Whether someone steals it or it’s inaccessible for another reason, it’s gone. Keeping your business going after such a loss would be very difficult – maybe even impossible.

Here’s what we suggest to prevent that.

Internal Safeguards

No business owner wants to believe that his or her employees could use their QuickBooks access to commit fraud. But it happens. Your company file contains credit card and checking account data that could be used for nefarious purposes. As we discussed last spring, you can restrict user access to specific areas and actions of QuickBooks.

You can limit your employees who have QuickBooks access to certain areas and activities.

To get started, open the Company menu and select Set Up Users and Passwords | Set Up Users. The User List window opens. It should have at least one entry there, for you (Admin). Click Add User and enter the employee’s name and password in the next window that opens, then click Next.

Tip: Your QuickBooks license limits you to a specified number of users. If you’re not sure how many you’re allowed, click F2 to open the Product Information page. The number of user licenses you’ve paid for appears in the upper left.

On the next page of this wizard, click the button in front of Selected Areas of QuickBooks. The following screens will let you define that employee’s access permissions in areas like Sales and Accounts Receivable, Inventory, and Payroll and Employees. When you’ve clicked through every screen and reviewed the summary displayed, click Finish. Your user will now be able to sign in and access the areas you specified.

You can—and should—take numerous other steps to keep your QuickBooks data safe. If your company is big enough to have a dedicated IT expert, he or she will handle most of this. But there’s a lot you can do on your own to prevent data loss and theft.

Keep Your Operating System and Applications Updated

 

Don’t ignore this dialog box.

Software companies’ occasional updates offer more than just adding new features and fixing bugs. They sometimes refresh your software to ensure greater security based on new threats. Don’t forget about those all-important antivirus and anti-malware applications, as well as QuickBooks itself.

Keep Your Networks Safe

Just as a cold virus spreads around your office, so, too, can unwanted intrusions like computer viruses. Don’t allow an electronic epidemic to get started; take steps ahead of time to prevent it:

• Discourage employees from excessive web browsing. This can be a hard rule to enforce, as some employees probably need internet access for research, timecard entry, and other work-related tasks. Create a firm policy legislating what workers can and can’t do on company-issued equipment (including tablets and smartphones) or any personal devices that use your wireless network.
• Ask employees to refrain from using public networks on work equipment. Enforce the rules vigorously, and make compliance an element of performance evaluations.
• Minimize app installations on business smartphones. Employees should ask for approval. Viruses and malware get in that way, as well as through some websites and email attachments.
• Use monitoring software. If you can’t afford to pay for “managed IT” (a la carte, third-party IT services), install an application that alerts you to problems.

Use Common Sense

You can fight data loss and theft by being cautious. Be diligent about backups, and if you create them on a local, portable device, don’t leave them in the office. Cloud-based solutions are better. Shred papers that have sensitive information on them. Log out of QuickBooks when you’re not using it or when you leave your office. Be aware of who may be around you, looking over your shoulder.

We take data security very seriously in our own office, and we strongly encourage you to do the same. Contact our Fort Smith AR, Accounting Firm* at 479-242-1236 if you’re at all concerned with your own data safety, and we’ll come up with a plan together.

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.

At ValueMetrik CFO, we’re Fort Smith, AR Certified QuickBooks ProAdvisors® so we have QuickBooks down to a science. If you need any assistance with your QuickBooks, give us a call at 479-242-1236 – we look forward to helping you!