QuickBooks

One way to keep your company’s cash flow positive is by sending email reminders to overdue customers. QuickBooks Online can automate this.

Most small businesses struggle with cash flow. How do you get customers to pay by the due date, or at least not long after? We’ve written about some of the possible solutions. Accept credit/debit cards and direct bank payments. Send statements regularly. Offer a discount for early payment if it makes financial sense for you.

QuickBooks Online offers another tool for accelerating incoming payments: automated reminders. If you set these up, you won’t have to spend so much time keeping up with past-due remittances. It’s easy to do, and you can personalize your messages. You can even do this manually if you come across an individual customer who needs a nudge.

What about reminders for yourself? QuickBooks Online doesn’t come with a to-do list that you can use to enter tasks that must be done. But there are still ways to tie a digital string around your finger so you don’t fall behind on your own critical chores.

If you feel like you’re being too intrusive by sending out payment reminders, think about how you feel when you receive one yourself. Often, a financial obligation has simply slipped your attention. You want to maintain a good working relationship with your vendors, so you might even welcome such an email or letter.

Setting Up the Automation

To get started, click the gear icon in the upper right corner. Under Your Company, click on Account and Settings. Click the Sales tab and scroll down to Reminders. Click the pencil icon way over to the right to open the options here, then click the on/off button next to Automatic invoice reminders to activate them. Click the down arrow next to Default email message for invoice reminders to open the template.

If you’ve ever done a mail merge, this will look familiar to you. QuickBooks Online replaces the text in [brackets] with data from your company file. So it will prepare an email for every customer that is past due and replace the bracketed content with your own customer and company names and invoice numbers. Of course, you can choose not to personalize the emails, but it’s likely to be more effective if you do. Everything in the template can be edited, and you can check a box to have a copy sent to you.

Below this email template are three reminder-scheduling blocks. Click the button next to Reminder 1 to turn it on. You’ll see that you can set up a reminder to go out to customers either on the due date or a specified number of days (3, 7, 14, 30, or 90) before or after.

QuickBooks Online checks the due dates for your invoices and will automatically send the email reminder out to everyone who meets the criteria. If a customer record has an email address in it, a reminder will be dispatched even if you didn’t send the original invoice through email.

To set up additional, different reminders, you can do so in the Reminder 2 and Reminder 3 blocks. When you’ve finished, click Save. You can always go back in and edit these. To see who received reminders, click on Sales in the left vertical toolbar, then Invoices. The word Reminded should appear in the Status column.

If you’d rather dispatch reminder emails manually, you can do so in QuickBooks Online. With the same Sales | Invoices screen open, click on the down arrow next to Receive payment at the end of the row and select Send reminder. If you want to send reminders to multiple customers, click the box in front of each name to create a checkmark. Click the down arrow next to Batch actions right above the table and select Send reminder.

Reminding Yourself

We wish that QuickBooks Online had a reminder feature like QuickBooks Desktop does, that greets you every time you launch the software and displays tasks that need to be done. But there are still ways to remind yourself that invoice and bill payments are running late. You just have to make a habit of checking certain data screens regularly. For example, you should be visiting:

• The Business Overview element of the home page. There’s an Income graph that shows you how much money is tied up in overdue invoices (and open invoices).
• The Invoices and All Sales screens that you can see by clicking on Sales in the left vertical toolbar.
• Reports, like Accounts receivable aging detail, Open Invoices, Unbilled charges, and Unbilled time.

If you just started using QuickBooks Online this year and are struggling with it, we’re available to set up training sessions and answer questions. And, of course, we’re always here for longtime users, too. The COVID-19 pandemic is still affecting a lot of small businesses, and we understand you may be facing difficult issues. If we can help you better use QuickBooks Online to manage your finances, please contact us.

Your customers are your company’s lifeblood. Make sure their records are thorough and up-to-date.

When companies buy other companies, what’s often considered the most critical asset? The customer list. When a business is damaged and data possibly lost, which set of records do they most hope to recover? The customer list.

You probably spend most of your time in QuickBooks Online working with transactions and reports, but your customer records deserve equal time. If they’re incomplete or otherwise not maintained well, you lose time filling in the blanks when you’re trying to complete a task that requires complete customer profiles. Your searches and reports may not tell the whole picture. Your relationships can suffer, and you may miss out on sales opportunities.

QuickBooks Online provides excellent tools for creating and maintaining comprehensive customer and sub-customer records. Here’s a look at how it all works.

Moving Your Customer Data In

There are two ways to create customer records in QuickBooks Online. If you have an existing database in Outlook, Excel, Gmail, or Google Sheets, you can import it. This will save you an enormous amount of time, but it’s a challenging process. You select the file you want to import, and then you have to “map” it by matching the fields in your database to fields in QuickBooks Online. You’ll likely need our help with this.

To import a customer file into QuickBooks Online, you’ll have to “map” its fields. We can help you with this.

Your other option is to enter records manually. This is time-consuming, but the more information you can include about your customers from the start, the better. You can always edit your records to add, delete, or modify what you originally entered.

To get started, hover over Sales in the toolbar and click on Customers. Then click on New Customer in the upper right corner to open the Customer information window. The only field you’re required to complete is Display name as. You may want to do this if you have a new customer on the phone and you want to concentrate on the conversation. You can take notes about their contact information and fill in the record later, when you’re off the phone.

But wherever possible, as we’ve already said, complete as many fields as you can. You’ll enter name and billing and shipping address and phone number(s) on the opening screen. You can also supply contact details like fax number and website.

Creating Sub-customers

You’ll notice a checkbox that says Is sub-customer. QuickBooks Online lets you “nest” related records under the “parent” record. This can be an actual customer, but many people use it to document jobs they’re doing for the customer. So if you’re a contractor, for example, you might have sub-customers like Sun deck and Spa.

If you want to set up such a record, enter the job name and click in the box next to Is sub-customer. Two fields will open below that allow you to select the parent customer and to indicate the sub-customer’s billing status. The remainder of the fields will automatically fill in with the parent customer’s contact information.

You can set up jobs as sub-customers in QuickBooks Online.

Supplying Details

When you’re setting up individual customers, you should add as much detail as you possibly can to each record, beyond basic contact information. QuickBooks Online’s record templates display a number of tabs running horizontally across the window. The most important of these are:

• Tax info. Are the customers taxable or exempt? If taxable, what is his or her Default tax code? (If you haven’t set up sales taxes yet and need to, please let us help. It’s complicated.)
• Payment and billing. Do they have preferred payment and/or delivery methods? Will you be assigning default payment terms, like Net 30 or Due on receipt? What is their Opening balance? If they’re brand-new customers who have never ordered from you, this will be $0.00. If they’re existing, active customers, enter any outstanding balance they have with you as of the date that you enter. This must be correct, to avoid any problems with the customers’ ongoing balances. Questions? Ask us.

Other tabs here are self-explanatory. When you’ve entered everything you can, click Save. The new record will now appear in the Customers list and will be available to select from the drop-down list in transactions.

There will be times when you have to refer back to these forms to answer questions. By maintaining detailed, accurate customer records, you’ll be ready to respond. If you have questions about any of the information requested, or about other elements of QuickBooks Online that are puzzling you, please contact us so we can set up a consultation.

If you purchase several items and services away from the office, QuickBooks Online can help you record them while you’re out and about.

QuickBooks Online’s mobile app, available at the Apple App Store and Google Play, can do many of the same tasks that it performs on your office desktop. You can, for example:

• Check account balances.
• Add and edit estimates, invoices, and sales receipts.
• Add and edit customers, vendors, products, and services.
• Record invoice payments.

One of the most common uses of the app, though, is the recording of expenses. Rather than coming home from a trip with your briefcase stuffed full of receipts and notes about purchases you made, you can document them on the road using your mobile device. When you get back to the office and log on to QuickBooks Online, they’ll all be there.

How It Works

You can snap a photo of a receipt with your smartphone and attach it to an expense you record in QuickBooks Online’s mobile app.

Open your QuickBooks Online mobile app and click the plus (+) sign at the bottom, then tap the Expense icon. The New Expense screen will open. If you have a paper receipt, lay it flat on a table in a well-lighted area. Click the camera icon and then the Take Photo link. If you took the picture outside of QuickBooks Online for some reason, you’d select the Choose Existing link. Your device’s camera will open, and you’ll see four squared corners on the edges of the screen.

Hover your device over the receipt. You’ll need to position the camera so the receipt area that you want captured appears within the four corners. QuickBooks Online will provide advice along the way to help you do this. When you’re in the right place, you’ll see the phrase, Great! Snap the pic. Click the shutter icon below, and your device will snap the photo and display it. If you want to use it, click Use this photo (if you want to try again, click the X in the upper left of the screen).

QuickBooks Online will open the New Expense screen. You’ll see a miniature version of your receipt in the upper left corner. Looking at your original version—it will be too small to see here—fill in the blanks with the data from the purchase. Be sure to click the Billable button if you can bill someone else for it. Make any notes you’ll need in order to remind yourself of the transaction, and Add a Split if you need to divide the transaction between categories, customers or vendors, or billable status. Click Save when you’re done.

Automatic Synchronization

Once you’ve entered an expense in QuickBooks Online’s mobile app, it will be synchronized with your desktop, browser-based version.

Of course, no duplicate data entry is required once you’ve entered a receipt in the QuickBooks Online mobile app – the two versions always update each other.

Once you’re back at your desktop, on the browser-based version of QuickBooks Online, click Expenses in the toolbar to open the Expense Transactions screen. You should see the transaction you just created on your mobile device first in line on the list that displays. Click View/Edit at the end of that line to see it. Look toward the bottom under Item Details to see the link to an attachment that contains the photo you snapped of the receipt.

The record of the expense you entered on your mobile device will contain a link to an attachment that contains the photo of your receipt.

Of course, you don’t have to take a picture of your receipt with your mobile device. You can simply enter the details of your expense and Save the record.

QuickBooks Online’s mobile app can help you save time and improve the accuracy of your work done away from the office. As we mentioned earlier, the app is capable of doing much more than simply recording receipts. We’d be happy to run you through its pieces to make sure your remote accounting work is done correctly.

If you have one or more people besides yourself using QuickBooks Online, you’ll need to know how to set up their accounts.

Your QuickBooks Online file contains a great deal of very sensitive information, like customers’ credit card numbers and employees’ Social Security numbers – data you don’t want to have fall into the wrong hands. You obviously trust your employees or you wouldn’t have hired them, but when it comes to security, you should implement all the safeguards you can.

QuickBooks Online can help you stay safe by limiting the access that other users have to your company file. Here’s how it works.

To get started, click the gear icon in the upper right and select Manage users. You should be listed there, of course, as the Master Administrator. Click Add user. The screen that opens will ask you what type of user you’re adding. There are four of them:

• Standard user. You can assign full or limited access to standard users, but they won’t have administrator privileges.
• Company admin. At this level, the user can see and do everything.
• Reports only. These individuals have access to all reports except those that contain payroll or contact information.
• Time tracking only. You’d assign this type to employees who only need to enter their own timesheets.

The first step in adding a user in QuickBooks Online is to specify their type.

The first two count toward your user limit, but the second two do not. Make your selection and click Next. We’ll select standard user for this example.

On the screen that opens, you’ll be assigning actual access rights, telling QuickBooks Online what the user’s restrictions are. You can choose All (with or without payroll access), None (allows some activities), or Limited. Select Limited, then click in the box in front of Customer to create a check mark. You’ll see the list of specific actions that that individual can take (like creating invoices, sales receipts, and statements) and the screens that they can see (customer registers and reports, tax rates and agency settings, etc.).

There’s also a list of what they can’t do, including printing checks, viewing bank registers, and preparing a sales tax return.

Click in the box in front of Customer again to uncheck it and select Vendor. You’ll see a similar list here of what your new user can and can’t do, only its activities relate to your accounts payable.

QuickBooks Online provides lists of what standard users can and can’t do and see for both customers and vendors.

Click Next If the user will be entering his own her own timesheets in QuickBooks Online, click the button in front of Yes, then select the correct name from the drop-down list. Click Next. Answer the user settings questions on the next screen and click Next. Enter the user’s name and email address (user ID), then click Save. QuickBooks Online will return you to the Manage Users screen, where you’ll see that your new user has been added to the list. The individual you just invited will receive an email invitation to set up an account, with instructions on how to do so.

Other Security Tips

There are other ways you can keep all of your company’s data safe. Here are some suggestions to consider if your business has returned to its offices.

• Always update your operating system and applications when prompted. These often contain security patches in addition to bug fixes and new features.
• Keep backups out of reach of others. Cloud backups are best, but if you use a local device, don’t leave it out in the open.
• Log out of QuickBooks Online when you’re not at your desk.
• Shred anything you print from QuickBooks Online or store it in a locked drawer.
• Protect your networks. Discourage excessive web browsing by employees. Don’t allow extraneous app downloading on company equipment and ask employees not to use company mobile devices on public networks. Consider network monitoring software if you can’t afford managed IT.

We follow security best practices in our own offices, and we hope you’ll do the same. Applying safeguards proactively will help prevent data theft that can be nearly impossible to recover from.

Intuit employs industry-standard security practices to keep your data safe, too, and it handles all backup and upgrades. Often, those updates include new features, like the recent addition of transaction “tags.” Let us know if you need our help with these or with any other element of QuickBooks Online.