QuickBooks

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!

The new year is well underway. Does your accounting to-do list look like a clean slate, or are critical tasks from last year still nagging?

Getting all of your accounting tasks done in December is always a challenge. Besides the vacation time you and your employees probably took for the holidays, there are those year-end, Let’s-wrap-it-up-by-December-31 projects.

How did you do last month? Were you ready to move forward when you got back to the office in January? Or did you run out of time and have to leave some accounting chores undone?

Besides paying bills and chasing payments, submitting taxes and counting inventory in December, there’s another item that should have been on your to-do list: creating end-of-year reports. If you didn’t get this done, it’s not too late. It’s important to have this information as you begin the New Year. QuickBooks can provide it.

A Report Dashboard

You may be using the Reports menu to access the pre-built frameworks that QuickBooks offers. Have you ever explored the Report Center, though? You can get there by clicking Reports in the navigation toolbar or Reports | Report Center on the drop-down menu at the top of the screen.

QuickBooks’ Report Center introduces you to all of the software’s report templates and helps you access them quickly.

As you can see in the image above, the Report Center divides QuickBooks’ reports into categories and displays samples of each. Click on one of the tabs at the top if you want to:

• Memorize a report using any customization you applied.
• Designate a report as a Favorite
• See a list of the most Recent reports you ran.
• Explore reports beyond those included with QuickBooks, Contributed by Intuit or other parties.

Recommended Reports

Here are the reports we think you should run as soon as possible if you didn’t have a chance to in December:

1. Budget vs Actual

We hope that by now you’ve at least started to create a budget for this coming year. If not, the best way to begin is by looking at how close you came to your numbers last year. QuickBooks actually offers four budget-related reports, but Budget vs Actual is the most important; it tells you how your actual income and expenses compare to what was budgeted.

Budget Overview is just what it sounds like: a comprehensive accounting of your budget for a given period. Profit & Loss Budget Performance is similar to Budget vs Actual. It compares actual to budget amounts for the month, fiscal year-to-date, and annual. Budget vs Actual Graph provides a visual representation of your income and expenses, giving you a quick look at whether you were over or under budget during specific periods.

2. Income & Expense Graph

You’ve probably been watching your income and expenses all year in one way or another. But you need to look at the whole year in total to see where you stand. This graph shows you both how income compares to expenses and what the largest sources of each are. It doesn’t have the wealth of customization options that other reports due, but you can view it by date, account, customer, and class.

3. A/R Aging Detail

QuickBooks’ report templates offer generous customization options.

Which customers still owe you money from last year? How much? How far past the due date are they? This is a report you should be running frequently throughout the year. Right now, though, you want to clean up all of the open invoices from last year. A/R Aging Detail will show you who is current and who is 31-60, 61-90, and 91+ days old. You might consider sending Statements to those customers who are way past due.

4. A/P Aging Detail

Are you current on all of your bills? If so, this report will tell you so. If some bills slipped through the cracks in December, contact your vendors to let them know you’re on it.

Sales by Item Detail

January is a good time to take a good look at what sold and what didn’t before you start placing orders for this coming year. We hope you’re watching this closely throughout the year, but looking at monthly and annual totals will help you identify trends – as well as winners and losers.

QuickBooks offers some reports in the Company & Financial and Accountant & Taxes categories that you can create, but which really require expert analysis. These include Balance Sheet, Trial Balance, and Statement of Cash Flows. You need the insight they can offer on at least a quarterly basis, if not monthly. Connect with us, and we can set up a schedule for looking at these.

5. Social media posts

January is a good time to run reports you didn’t have time to in December. Talk to us about which are most important.

QuickBooks provides templates for some reports that you probably need help analyzing, like Balance Sheet. We can help with these.

Have you explored QuickBooks’ Report Center? It offers a variety of tools and guidance for managing reports.

Did you create a budget last year? Now’s the time to run QuickBooks’ Budget vs Actual report.

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.