The Benefits of Hiring a QuickBooks© ProAdvisor for Your Small Business

Digital TouchstoneLeave a comment

Small business owners often have a lot on their plate, from managing employees to overseeing daily operations, and everything in between. With so many responsibilities, it can be difficult to keep track of financial records and ensure that all finances are in order. This is where a QuickBooks ProAdvisor can help.

A QuickBooks ProAdvisor is a certified professional who is trained in using QuickBooks accounting software. Hiring a ProAdvisor can bring numerous benefits to your small business, including:

  1. Expertise and Knowledge: A QuickBooks ProAdvisor is an expert in using QuickBooks software and can offer advice and support on everything from setting up the software to creating reports and managing your finances. They have the knowledge and experience to help you make informed decisions about your business.
  2. Time-Saving: As a small business owner, you likely have a lot of tasks to manage on a daily basis. By hiring a QuickBooks ProAdvisor, you can save time and focus on other areas of your business that require your attention. A ProAdvisor can take care of your bookkeeping, payroll, and tax-related tasks, leaving you with more time to grow your business.
  3. Accurate Financial Reporting: QuickBooks ProAdvisors can help ensure that your financial records are accurate and up-to-date. This can help you make better business decisions based on accurate financial data.
  4. Cost-Effective: Hiring a full-time bookkeeper or accountant can be expensive for a small business. By hiring a QuickBooks ProAdvisor, you can get the expertise you need at a fraction of the cost.
  5. Training and Support: QuickBooks ProAdvisors can provide training and support to you and your employees, ensuring that everyone is familiar with the software and can use it effectively.
  6. Peace of Mind: With a QuickBooks ProAdvisor handling your finances, you can have peace of mind knowing that your financial records are accurate and up-to-date.

In conclusion, hiring a QuickBooks ProAdvisor can be a valuable investment for small business owners. By providing expertise, saving time, ensuring accurate financial reporting, being cost-effective, offering training and support, and providing peace of mind, a ProAdvisor can help you take your business to the next level.

Do You Need to Add Users in QuickBooks© Online?

Digital TouchstoneLeave a comment

QuickBooks Online allows you to give multiple users access to your account. Here’s how to set them up.

Adding employees to your staff is reason to celebrate. It means you’re growing enough that you need to bring new people on board to get all of your work done.

Adding employees that need access to your QuickBooks Online data, though, requires a high level of trust. Those individuals will be able to see a lot of very sensitive company, customer, and vendor information. You need to make sure that they can only view what they need to and that their ability to enter and modify data is limited.

QuickBooks Online makes this possible with its user management tools. You can provide users with their own login information that restricts where they can go and what they can do. Here’s how it works.

Types of Users

Warning: Your QuickBooks Online subscription allows you to invite a specific number of employees, though you can add more. Ask us about this.

To set up a new user, click the gear icon in the upper right. Select Manage users under Your Company. Or click Get things done in the toolbar and select the Manage users icon in the Company box. 

Graphical user interface, application Description automatically generated

Click the Manage users icon to add a new user to your QuickBooks Online account.

You’ll see a table with your own account information listed there. Click Add user in the upper right. In the window that opens, you’ll have to choose a user type. This can be a:

  • Company admin. This user could see and do everything, like adding users and sending money.
  • Standard user. This user would have full or limited access, without admin privileges. 

Both of these user types would count toward your employee limit. You can also invite someone to have access to Reports only, excluding payroll and contact information (wouldn’t count toward your user limit).

Choose Standard user and select Next in the lower right. The page that opens asks you how much access the individual should have. Your options are:

  • All, including or excluding Payroll.
  • None. User could, though, manage some things and submit timesheets.
  • Limited. You can allow access to Customers and/or Vendors, with access rights spelled out.
Graphical user interface, text, application, letter Description automatically generated

QuickBooks Online shows you what specific users’ access rights are.

After you’ve made your selection on this page, click Next in the lower right. You’ll answer a few Yes, No, or View only questions, things like Do you want this user to add, edit, and remove users? Click Next and provide the user’s name and email address. He or she will receive an invitation (good for 30 days) to set up a password and log in. Click Save to be returned to your user access list. Your user can log in after accepting your invitation.

Other Ways to Keep Your Data Safe

Limiting access for other employees who must log into QuickBooks Online is one way of safeguarding your company file data. Here are some additional suggestions:

  • Try to avoid printing data other than necessary transactions from your QuickBooks Online file. When you do, either store it in a secure place or shred it when you’re done with it.
  • Keep your networks safe. Create policies and put them in writing for employees. Don’t allow workers to download apps onto their work computers, and discourage unnecessary web browsing. Encourage them to practice good email hygiene (no clicking on links or attachments unless they’ve requested the information). Consider network monitoring software, or, if your company is big enough, managed IT.
  • Protect data remotely. If you or your employees have company-issued phones with QuickBooks Online data on them, stress to them that they should never use those phone on public Wi-Fi networks.
  • Don’t leave QuickBooks Online open when you’re not at your desk.
  • Update your applications and operating system when necessary. QuickBooks Online updates itself, but many other applications don’t. These updates sometimes contain system security patches in addition to new features.

One serious security breach could shut you down. Follow these best practices to avoid hackers and other intrusions that could seriously compromise your data or put it in the wrong hands. Your customers, vendors, and employees entrust sensitive information that you’ve added to your QuickBooks company file. Continue to earn their trust by protecting their data as well as your own.

Questions about system security or about QuickBooks Online features? We’re here, and we stand ready to share our accounting expertise with you. We want to see you succeed, and good financial records are essential in making that happen.

How to Receive Payments in QuickBooks© Online

Digital TouchstoneLeave a comment

It’s more enjoyable than paying your bills. Here are three ways to process incoming money from customers.

One of the biggest problems small businesses face is maintaining a positive cash flow. It’s a constant battle. How do you keep your income running ahead of your expenses?

QuickBooks Online can help. It provides specialized forms and a mobile app that help you record and deposit the payments that are coming in. Do you ever receive payments instantly for some products and/or services? Are you ever out of the office and have to document a sale for both you and the buyer? Do you send invoices for products and/or services and need to make sure that payments get reported accurately when they come in?

QuickBooks Online supports all of these situations. It also provides a service that can automate your payments and help you get paid faster. 

Applying Payments to Invoices

If you send invoices to customers for products and/or services, you can receive their payments easily using QuickBooks Online. Businesses can record payments manually, but there’s a better way that can help you get paid faster: QuickBooks Payments. This is a merchant account that allows you to accept credit card and bank payments electronically. 

Graphical user interface, text, application, chat or text message Description automatically generated

Using QuickBooks Online’s mobile app, you can check the payment status of an invoice.

Once you set this up in QuickBooks Online, your invoices will allow bank cards and electronic checks as integrated payment options. Your invoices will go out with a button that customers can click to provide bank card or check information. You’ll be able to see when invoices are viewed, paid, and deposited, as shown in the image above. You can also get notifications of invoice activity. 

Of course, you can also check the payment status of the invoices you’ve sent in the browser-based version of QuickBooks Online on your desktop or laptop. Open your list of invoices on the site and click on one to highlight it. A panel will slide out from the right side of the screen displaying the invoice’s timeline. 

You can also record payments manually. Look at the end of the row for an invoice that hasn’t been paid. You’ll see a Receive Payment link. Click it to open the Receive Payment screen and complete the fields that aren’t already filled in, then save the screen. There’s also a Receive Payment link on the invoice screen itself.

A picture containing text Description automatically generatedYou can record payments for invoices manually from the Invoices screen.

There’s no cost for setting up an account in QuickBooks Payments. There are only per-transaction fees. For ACH bank payments, the rate is 1%, with a maximum of $10 per transaction. Credit and debit cards (plus PayPal, Apple Pay, and Venmo) are 2.9% if they come in through an invoice, 2.4% if you use a card reader, and 3.4% if the payments are keyed in. There’s also a $0.25 fee per transaction. Payments that come in before 3 p.n. PT should be in your account the next business day. 

Payments On the Road

To accept payments remotely, you’ll need to get a free card reader from Intuit that attaches to your mobile phone. Customers can tap or insert their cards or make digital wallet payments. You can also key numbers in, but, as we said earlier, the per transaction fee is higher. You’ll also need to download the GoPayment app to process transactions. The app also allows you to add labels, prices, and images so you can find the item you’re selling quickly. Multiple security measures are used to help keep this method of mobile data transmission safe.

Receiving Payment Instantly

There may be times when you provide a product or service for someone and they pay you on the spot. QuickBooks Online allows you to create and send sales receipts for just those occasions. Click +New in the upper left corner, and then click Sales receipt under Customers. QuickBooks Online then opens a form that should look familiar to you. It looks and works like an invoice or estimate. Select the Customer in the upper left corner and complete the rest of the fields as you would with any sales form. If you click Save and send when you’re done to email a copy to the customer, you can see a preview first.

About Receiving Checks

Graphical user interface, table Description automatically generated

Money from payments you’ve received sometimes* go into the Undeposited Funds account.

When we created a sales receipt just now and indicated we’d received a check, the Deposit to field defaulted to Checking, because QuickBooks Online assumed we’d be depositing this check on its own. When you have multiple checks that you’re going to combine into one deposit, you should have the payment deposited to the Undeposited Funds account. This is an account that holds any payments that have come in but not yet been physically deposited in the bank (usually cash and paper checks from invoices and sales receipts). It’s a good idea to look at this account occasionally to make sure you don’t have money just sitting there.

Questions on any of this? Contact us to set up a consultation. The mechanics of receiving payments are not that difficult, but you need to make very sure you’re recording all payments properly and getting the money into your bank accounts. 

Save Time, Keystrokes with Recurring Transactions in QuickBooks© Online

Digital TouchstoneLeave a comment

Your time as a business owner is valuable. Don’t waste any of it doing duplicate data entry.

Accounting takes time. And the last thing you need when you’re working with your company’s finances is activity that takes unnecessary minutes. If you’ve created a record or transaction once, you don’t want to have to enter the information a second or third time.

That’s why using QuickBooks Online is so far superior to manual accounting. It remembers everything, so you can use data again when you need it. But sometimes you have to give it a little guidance.

That’s the case with recurring  transactions. If you have forms that you create repeatedly, with very few changes (like utility bills), you can “memorize” the transactions. When the bill comes around the next month, you can modify any details necessary and dispatch it again. Here’s how it works.

Three Options

To get started, enter a transaction that you want to save and be able to use again (with changes). Let’s say it’s an invoice that you send to a customer once a month who has a service contract for network maintenance. When you’ve completed the form, look toward the bottom of the screen and click Make recurring. The screen will now read Recurring Invoice, with new content as pictured below.

Graphical user interface, application Description automatically generated

You can specify transactions as recurring and add details like frequency and start/end dates.

If you want to change the Template name to something that will remind you of its purpose, you can do so. In the field beneath Interval, select Daily, Weekly, Monthly, or Yearly, and then indicate what day of the month the transaction should occur. Enter a Start date and End [date] or select None if the length of service is open-ended. In example above, you would receive a reminder from QuickBooks Online three days before the invoice is scheduled to go out. The service contract has no ending date, so you’d continue to get reminders until you change the template.

Next to the Template name is a field labeled Type. QuickBooks Online gives you three options for taking action on the recurring transaction. It can be:

  • Scheduled. This is an automated option that should be used with caution. If you select this, your transaction will go out as scheduled with no intervention from you. Only the date will change.
  • Reminder. QuickBooks Online will send you a reminder ahead of the scheduled date. You can specify how many days ahead you should receive it. Then it’s up to you to make any necessary changes and send it out.
  • Unscheduled. QuickBooks Online will do nothing except save your template.

When you’ve completed all of the required fields, click Save template in the lower left. 

Using Recurring Transactions

If you’ve chosen the Scheduled option for any transactions, you don’t have to do anything more with it until you want to change its content or status. To find your list of recurring transactions so you can process any that are you earmarked as Reminder or Unscheduled, click the gear icon in the upper right of the QuickBooks Online screen. Under Lists, click Recurring transactions.

Graphical user interface Description automatically generated

The Recurring Transactions table

The screen that opens displays a table containing all of your recurring transactions. You can learn just about everything you need to know about those transactions here: Template Name, Type, Txn (Transaction) Type, Interval, Previous Date, Next Date, Customer/Vendor, and Amount. 

The last column in the table, labeled Action, opens a menu that displays different options depending on the  type of transaction. For our Reminder example, you can: 

  • Edit (edit the template, not the transaction)
  • Use (opens the original transaction that you can edit, save, and send)
  • Duplicate (duplicate the template)
  • Pause (stop sending reminders temporarily)
  • Skip next date
  • Delete

Looking Ahead

We’re a month into 2023 now. What does this year look like for you? Is QuickBooks  Online doing everything you need it to do? If you’re starting to outgrow your version, we’d be happy to consult with you about upgrading to another service level (Essentials, Plus, or Advanced). Or if you know the version you’re using is supposed to do something you need but you can’t quite figure it out, let us know. We want 2023 to be a good year for you, and we’d like to make your accounting work as painless and productive as possible.

What Can QuickBooks Online’s Mobile App Do?

Digital TouchstoneLeave a comment

If you haven’t checked out QuickBooks Online’s free mobile app, you might be surprised at how much it can do.

There was a time when leaving the office meant you were done with work for the day. These days, many homes are offices. And easy mobile access has made it difficult to get away from work.

That can be a good thing, especially if you’re a small business owner who must keep a close eye on what goes on outside of regular hours. Many productivity websites have mobile companion apps that make it possible to pick up where you left off when you were sitting at your laptop or desktop.

QuickBooks Online is one of them. Its mobile apps (iOS and Android, which look and work similarly) can’t replicate absolutely everything on the website. For example, you can’t work with projects or pay contractors or define sales taxes or run most reports. But they do a good job of providing the tools you’d most likely need when you’re away from your regular workspace. Let’s take a look at them.

A Terrific User Experience

Intuit did a great job designing its mobile apps to be easy to use on small screens. It takes very little time to learn how to navigate around, and individual working screens are clean, attractive, and understandable. 

When Should You Use Apps?

There are only two things that QuickBooks Online’s apps can do that the desktop version can’t: track mileage and snap photos of receipts. There are other situations when it’s very convenient to have the apps available, like creating a sales receipt or invoice for a customer in person, adding basic details for a new customer or vendor, or checking your account balances. It’s probably best to do the bulk of your work on your desktop or laptop when you can, to avoid errors caused by small—and abbreviated—screens.

Navigation Icons

The apps open to a screen called Today, which is their version of a desktop application’s Dashboard. There are links to actions like creating an invoice and looking up a customer, as well as a to-do list, the QB Assistant (a support tool), your account balances, a link to recent transactions, and real-time information about the status of your invoices and bills.

The other three icons at the bottom of the screen serve as navigation tools. The one on the far right labeled Menu opens two screens that can be toggled back and forth. One is Shortcuts, pictured below, a series of links to common actions. The other, All, opens a more traditional, comprehensive menu of links to individual app functions, like a Profit and loss report, Sales receipts, and Products & services.

The QuickBooks Online app’s Shortcuts screen

Besides those functions, there are links to other financial activities on the All screen. The ones you’d be most likely to use remotely are:

  • Transactions. The ones you’ve imported from your banks are available via this shortcut, as well as any you’ve entered manually on your desktop or phone. You can also get to the list by clicking on an account name on the Today screen.
  • Receipt snap. Using your phone’s camera, you can take a picture of a receipt. The app will pull some of its data and deposit it on an expense form that’s accessible on the app and the desktop version, where you can fill in the blanks and see the picture. 
  • Invoices and Estimates. View, modify, and add them.
  • Customers and Vendors. Abbreviated versions of your records.
  • Expenses and Bill Pay.
  • Mileage. Enter trip data manually or automatically, through your phone’s location services.

Data entry on the mobile apps is as easy as it is on the browser-based version of QuickBooks Online.

About Your Business

Another bottom-of-screen icon takes you to My business, which provides an update (charts and numbers) of your income, expenses, and profitability. And another is Cash flow. Cash flow is actually a pretty complex accounting concept that you can’t fully absorb on a mobile phone screen, but it’s very important that you have a good understanding of how your company is doing. You can ask us about this.

Give It A Try

January is always a good time to develop new habits. We’ll be talking about some of these next month, but in the meantime, you might download and explore QuickBooks Online’s mobile app. You probably won’t need our help learning to use it, but we’re always happy to step in and assist when you’re having trouble with desktop QuickBooks Online.

Use QuickBooks Online Effectively: 7 Best Practices

Digital TouchstoneLeave a comment

Here are seven ways you can be safe, compliant, and productive when you’re using QuickBooks Online.

“Best practices” is a phrase that human resources professionals have been using for decades. But every type of profession has its own best practices, whether they call it that or not. These guidelines are not enforceable rules, though some managers may build them into their official policies. They just describe the way work should be done to achieve optimal outcomes and keep data organized and secure.

You may have heard of Generally Accepted Accounting Principals (GAAP). Public companies are required to adhere to them, and many other businesses large and small follow these rules and procedures.  

We’re not going to discuss GAAP in this month’s column. Rather, we’re going to talk about more general best practices for accounting, actions you can build into your QuickBooks Online work to make that time more productive and in line with what other successful businesses do.

How Do They Help?

Accounting best practices have numerous benefits. For example, they:

  • Help maintain the integrity of your QuickBooks Online data files.
  • Improve the  accuracy of your accounting work.
  • Save time.
  • Provide insight on the financial health of your business.

When you incorporate best practices into your work, you may even find that your relationships with customers and vendors get better because you’re handling their businesses ? conscientiously.

7 Suggestions For You

Here are seven guidelines that we try to follow. We hope you will, too.

Track your 1099 vendors

Graphical user interface, text, application Description automatically generated

If your business employs contractors, make sure that you indicate their 1099 status in their vendor records.

Changes in the economy over the last few years have led some people to take on part-time (or even full-time) contract work. You should be creating vendor records for these individuals. Click Expenses in the tool bar and then select the Vendors tab. As you’re completing a record, you’ll see a section labeled Additional info. Check the box in front of Track payments for 1099. You can create and deliver your 1099s using QuickBooks Online when the time comes.

Reconcile, reconcile, reconcile

Once you’ve downloaded cleared transactions from your financial accounts, it’s important that you reconcile them. This is probably one of your least favorite tasks to undertake, but QuickBooks Online simplifies it for you some, walking you through the process. Reconciling accounts regularly can help you:

  • Discover errors and missing transactions.
  • Get a more accurate picture of your cash flow.
  • Make your reports more precise

Keep your lists up to date

Your QuickBooks Online company file can grow substantially over the years. Though the site has great search capabilities, you may still be scrolling to find the entries you want. This isn’t as big a problem for lists like Payment Methods or Terms, but overly lengthy lists of Products and Services, Customers, and Vendors can become unwieldy over time. Try to keep them current. If you don’t want to delete them completely, you can make individual records inactive by clicking an Action link in the listing table for each.

Graphical user interface Description automatically generated

If your QuickBooks Online Lists are getting too lengthy, you may be able to make some of the records Inactive.

Categorize and classify everything that you can

Your QuickBooks Online company file consists of hundreds or thousands of individual records and transactions. Though each is a separate entity, there will be many times when you want to be able to assemble groups of related ones. For example, you might want a list of all of your customers in a specific ZIP code or all services that go into the creation of a marketing program.

There’s more than one way to get this information quickly. You can customize reports. Assign Classes, Categories, and Tags. View a Project. Whatever method(s) you choose, do use them consistently. They can provide insight in a wide variety of ways that will help you make better business decisions.

Warning: Before you start making lists of these classification tools and assigning them, think carefully about what they should be. You can always add to and edit the lists, but you’ll want to make them as focused and flexible as you can. Let us know if you need help with this.

Assign user permissions carefully

QuickBooks Online makes it possible to restrict users to specific areas and functions on the site. Use these tools. You can find them by clicking the gear icon in the upper right and then Manage users. You trust your employees or you wouldn’t have hired them, but you need to put controls in place to protect your sensitive company data.

Use QuickBooks Online’s reports

Are you taking advantage of QuickBooks Online’s report templates? It’s absolutely essential that you keep up with reports in areas like Who owes you and What you owe. We can help with this. We can also generate and analyze the standard financial reports that you occasionally need, like Statement of Cash Flows and Profit and Loss.

Don’t leave QuickBooks Online running and walk away

This should go without saying if you’re in a multi-person office. Also, don’t use the QuickBooks Online mobile app on a public Wi-Fi network when you’re out and about. Your company file contains information about your customers, vendors, and employees that should never be compromised.

More Than Common Sense

These best practices may seem like common sense to you if you’ve been using QuickBooks Online for a while. But when you first start using web-based financial applications, they might not be second nature to you. That’s why we’re sharing them with you, to remind you that conscientious use of QuickBooks Online is critical to the safety, accuracy, and usefulness of your company data. As always, we’re here to answer any question you have.

How QuickBooks© Online Tracks Products and Services, Part 1

Digital TouchstoneLeave a comment

What products and services does your company sell? Do you have enough to fulfill existing and future orders? QuickBooks Online can tell you.

Most small businesses maintain a changing inventory of multiple products. Even if you sell one-of-a-kind goods, you need to know what you’ve sold and what’s available. And if your company sells services, you also have to keep track of what you’re able to offer customers.

QuickBooks Online can meet these needs. It allows you to create detailed records for both products and services. If you carry inventory, it can make sure that you always know what’s available to sell. When you enter sales and purchase transactions, the site draws on the records you’ve created to help you complete invoices, sales receipts, purchase orders, etc., without having to leave the form you’re working on.

Creating your records initially can take some time. And your products and services require regular monitoring and maintenance. But if you’re conscientious about these tasks, you’re not likely to run short on inventory or have too much money tied up in products that aren’t selling fast enough.

Preparing QuickBooks Online

Before you begin creating records and tracking inventory, you need to make sure that QuickBooks Online is set up correctly. Click the gear icon in the upper right. Under Your Company, click Account and settings. Click the Sales tab in the toolbar. You’ll see the Products and services section near the middle of the screen.

Graphical user interface, text, application, chat or text message Description automatically generated

Make sure you’ve turned on the Products and services features you’re going to need.

Toggle the slider buttons on and off by clicking on them, and be sure to save your changes when you’re done. One option allows you to turn on price rules. This is still classified as a beta feature, but it’s live on the site. It’s also quite complicated to set up and can create confusion for your customers and revenue loss for you if it’s not done correctly. Let us help if you want to use this tool.

Creating Your Product and Service Records

Your first task, of course, is to build your product and service records. Hover your mouse over Sales in the left vertical toolbar on the home page and select Products and Services. The screen that opens is your home base for dealing with inventory and services. Eventually, it will contain a detailed table containing information about both. Two large buttons at the top of the page warn you when you have Low Stock or you’re Out of Stock.

Click New in the upper right corner. A vertical panel slides out from the right displaying your four options for Product/Service information. They are:

  • Inventory. If you buy and/or sell products whose quantities you must track, these items are considered inventory.
  • Non-inventory. You may have products that you buy and/or sell, but you don’t need to track the amount you have in stock. These are considered non-inventory.
  • Service. These are, well, services that you provide to customers, like landscaping or web design. You might sell these by the hour or project, for example.
  • Bundle. You might call these assemblies. Bundles are multiple products and/or services that you sell as a package for one price.

Click on Inventory for this example. Here is a partial view of the pane you’ll see:

Graphical user interface, text, application, email Description automatically generated

You can track your inventory levels and reorder points when you create inventory product records in QuickBooks Online.

To create a product or service record, just fill in the blanks on the form and save it. Some fields are optional. In fact, only three are required: Name, Initial quantity on hand, and As of date. Of course, your inventory tracking and the use of product and service records in transactions and reports will be much more effective if you complete as many of the fields as possible. We recommend that you at least provide answers in some additional fields (some of which aren’t shown here), including:

  • Category (will be useful in reports, for example)
  • Reorder point (will keep you from running out of items)
  • Inventory asset account (you can leave the default, Inventory Asset)
  • Description (for sales forms)
  • Sales price/rate (what the customer will be charged)
  • Description (for purchase forms)
  • Cost (what you pay to buy it)
  • Expense account (often Cost of Good Sold, but you can ask us to be sure)

Next month, we’ll discuss how QuickBooks Online makes these records available as you complete other tasks, like transactions. In the meantime, please let us know if you have other questions we can answer that would help you use QuickBooks more effectively. We hope you’re enjoying your summer!

Keeping Up With Receivables: Know Who Owes You

Digital TouchstoneLeave a comment

QuickBooks Online provides numerous ways for you to know which customers owe you money – and who is late.

There are so many financial details to keep track of when you’re running a small business. You have to make sure your products and services are in good shape and ready to sell. You have to stay current with your bills. Orders need to be processed as quickly as possible, as do estimates and invoices. And you may have numerous questions from customers and vendors that must be addressed.

Your number one priority, however, is ensuring that your customers are paying you. Whether you accept credit cards or bank transfers or issue sales receipts for cash and checks, you need to always know where you stand with incoming payments. “Are my receivables current?” should be a question you’re asking yourself or your staff frequently.

QuickBooks Online offers numerous ways to know whether you’re being paid for your products and/or services and who might be falling behind. That information is critical to your understanding of how your receivables are stacking up against your payables. You should be able to gauge whether you’re making a profit, staying even, or losing money. Here’s a look at the tools you can use.

Learning When You Launch

QuickBooks Online provides a good overview of your current cash flow as soon as you log into the site and see your two-pronged Dashboard. The first thing you see when you click the Business overview tab is a cash flow forecast that goes up to 24 months. Other content includes a profit and loss graph and charts showing expenses, income (including open and overdue invoice totals), and sales. Your account balances are there, too.

This is helpful data, but it’s broad. To get far more detailed information, hover your mouse over Sales in the toolbar and select All Sales. The horizontal bar across the top displays dollar and transaction totals for estimates, unbilled activity, overdue (invoices), open invoices, and (invoices) paid last 30 days. When you click one of the bars, the list changes to show only that particular set of transactions.

Graphical user interface Description automatically generated with medium confidence

Partial view of the toolbar at the top of the Sales Transactions page

The table of transactions is interactive. That is, there’s an Action column at the end of each row. Click the down arrow next to any of the activity listed there, and you’ll see a menu of options. Depending on the status of each, these options include commands like Receive payment, Send reminder, Print packing slip, Send, and Void. 

Running Reports

The Sales Transactions page provides more of your receivables nuts and bolts than the Business overview screen does. But to get the most in-depth, customizable, comprehensive view of who owes you, you’ll need to run reports. Click Reports in the toolbar and scroll down to Who owes you. 

There are three columns here. You’ll land on Standard, which is a complete list of all of the pre-formatted reports that QuickBooks Online offers. Click Custom reports to see the reports you’ve customized and saved. Management reports opens a list of three reports that can be viewed by a variety of date ranges: Company Overview, Sales Performance, and Expenses Performance. You can view, edit, and send these, as well as export them as PDF and Microsoft Word files.

There are five reports listed under Who owes you that you should be creating on a regular basis. How regularly? That depends on the size of your business. The greater your sales volume, the more frequently you should run them.

When you select A/R Aging Summary, you’ll see at a glance which customers have current balances and those that are 1-30, 31-60, 61-90, and 91+ days past due. A few customization options appear at the top, like Report period, Aging method, and Days per aging period. To really zero in on the precise data set you want, click Customize. The panel that slides out from the right contains option in several areas: General, Rows/Columns, Aging, Filter (by customer), and Header/Footer.

Graphical user interface Description automatically generated

QuickBooks Online helps you target the data set that you want.

There are four other reports that can help you track your receivables:

  • Open Invoices displays a list of invoices that still contain a balance.
  • Unbilled Time tells you about any billable time that hasn’t been invoiced.
  • Unbilled Charges lists billable charges that haven’t been invoice.
  • Customer Balance Summary simply provides all open balances for you customers.

These are all very simple reports that you shouldn’t have any trouble customizing and running. They can give you a complete picture of where your receivables stand. But there are other reports that will require our help. These are standard financial reports that should be created monthly or quarterly, including Statement of Cash Flows, Profit and Loss, and Balance Sheet. You’ll need these critical financial statements if, for example, you’re applying for a loan or trying to attract investors. Please let us know if you want us to run and analyze these so you can get a detailed, comprehensive view of your financial health.

Too Many Transactions in QuickBooks© Online? Create Rules

Digital TouchstoneLeave a comment

It’s important to categorize transactions, but it takes time. If every day brings several dozen into QuickBooks Online, you can automate this process.

One of the cardinal rules of accounting is this: Go through your new transactions every day. If you wait until there are too many of them, you’re likely to give them short shrift. You may miss problems, just as you might skip categorizing some of them because it simply takes too long.

But correct categorization is essential. Your income taxes and reports will not be accurate if you fail to assign the right category to all of your transactions. QuickBooks Online makes this easy.

The site also provides a way for you to accelerate the process by automating it. It allows you to create Rules. That is, if a transaction contains a specific piece of information, a name or an amount, QuickBooks Online allows you to indicate how it should be categorized. This kind of automation will save you time and may even prevent errors – as long as you use it carefully. Here’s how it works.

Defining Your Rules

We’ll use an easy example to explain how QuickBooks Online’s Rules work. Let’s say your shipping costs have started to increase lately, and you want to make sure you’re seeing any UPS transactions that go above a specified dollar amount, and that they’re categorized accurately. Hover your mouse over Transactions in the toolbar and click on Banking (assuming you’re downloading your bank transactions). Select an account to work with by clicking on it, and make sure the For review bar is highlighted. 

Click on a transaction to open it. (If you’ve never explored what you can do with a downloaded transaction, study this box carefully while you’re there, and contact us with any questions.) On the bottom line, you’ll see a link labeled. Create a rule. Click on it, and a panel slides out from the right, as pictured below:

Graphical user interface Description automatically generated

The upper half of the Create rule panel

This portion of the Create rule panel is fairly self-explanatory. Give your rule a descriptive name (we entered UPS 25 Plus) and indicate whether it should be applied to Money in or Money out. If you want to select a specific bank account or card, click the down arrow in the field to the right and select it. Otherwise, choose All bank accounts. Next, decide whether a transaction has to meet Any of the conditions you’re going to specify or All of them. In this case, we want All. 

Now you have to describe the conditions under which a transaction will be affected. We want transactions whose Description Contains The UPS Store. We also want to identify purchases from The UPS Store whose total is more than $25. So you’d click + Add a condition. In the row that opens, click the down arrow in the Description field and select Amount. Click the down arrow again in the next field and choose Is greater than. The final field in the row should contain 25.00.

You could keep adding conditions, but that’s all we need for this rule. You can click Test rule if you want to find out how many transactions in your For review list would meet your specifications.

Next, you want to Assign attributes to the transactions selected. Your options here are Transaction type, Category, Payee, Tags, Class, and Memo. The first two are required and the third is recommended. The last three are optional. If you want QuickBooks Online to automatically confirm transactions this rule applies to, click the Auto-confirm button so it’s showing green. If you choose this option, your matching transactions will be modified to meet your criteria and moved directly into the Categorized queue. You won’t see them in For review. So consider this carefully.

When you’re done here, click Save.

Graphical user interface Description automatically generated

The lower half of the Create rule screen

Warning: QuickBooks Online allows you to create new categories directly from this window. But accurate categorization is so critical that we’d rather you schedule a session with us to go over your list of categories and make any modifications necessary.

To recap: Any expense over $25 that comes into your For review queue whose Description reads The UPS Store will be automatically categorized and moved into the Categorized queue.

QuickBooks Online’s Rules can save you time, but if they’re not created correctly, you may have errors in your company file without even knowing it. We recommend that you let us help you set these up from the start to avoid this. If you’re new to downloading transactions onto the site, you may also want to consult with us.

Hiring An Independent Contractor? How QuickBooks Online Can Help

Digital TouchstoneLeave a comment

Are you taking on a worker who’s not an employee? QuickBooks Online includes tools for tracking and paying independent contractors.

The COVID-19 pandemic created millions of self-employed individuals and small businesses. Whether they chose to, or circumstances forced them to, these new entrepreneurs had to learn new ways to get paid and to prepare their income taxes.

If you’re thinking about taking on a contract worker, you, too, will have to educate yourself on the paperwork and processes required to comply with the IRS’ rules for his or her compensation. It’s much easier than hiring a full-time employee, but it still takes some knowledge of how QuickBooks Online handles these individuals.

You’ll also need to make certain that the person you’re hiring is indeed an independent contractor and not an employee. The IRS takes this distinction very seriously. If you’re at all unsure of your new hire’s employment status, we can help you sort it out.

Creating Records for Contractors

Once new contractors have accepted your offer, you’ll need to have then fill out an IRS Form W-9. You can download a copy here. Employees complete the more detailed Form W-4 so that the employer can withhold income taxes correctly, but you won’t have to withhold taxes for your contract workers. They will be responsible for calculating and paying quarterly estimated taxes and filing an IRS Form 1040 every year. 

You, though, will be responsible for sending them an IRS Form 1099-NEC (Non-Employee Compensation) every January if you paid them more than $600 during the previous year. You do not need to send a 1099-NEC to a corporation or to an LLC that is treated as a C Corp or an S Corp. 

Graphical user interface, text, application Description automatically generated

You can complete the Vendor Information window for each independent contractor, checking the box in front of Track payments for 1099.

Using the information the contractors provide, you can create records for them in QuickBooks Online. If you don’t have a QuickBooks Payroll subscription, you can set them up as 1099 vendors. Click the Expenses tab in the toolbar and then on the Vendors tab. Click New vendor in the upper right to open the Vendor Information window. Complete the fields for the worker and be sure to check the box in front of Track payments for 1099, as shown in the partial image above.

The vendor records you create will appear in QuickBooks Online’s Vendors list (again, Expenses | Vendors). Click on one to open it. You can toggle between two tabs here. The first, Transaction List, will eventually display all your financial dealings with that contractor. Vendor Details opens the record you just created, which you can edit from this screen.

Paying Contractors

When independent contractors send you invoices, you’ll return to this same screen. There are three ways you can pay them. Click the down arrow next to New Transaction in the upper right corner to see your options (or look down at the end of the row while you’re in list view). You can record the debt as a Bill if you want to pay it later (or if that’s the way you structure your recordkeeping). If you’re paying it right away, you can create an Expense or write a Check. 

Graphical user interface, text, application, chat or text message Description automatically generated

You can choose an option from this vendor action menu to pay your independent contractors.

When you click one of these, QuickBooks Online opens a form with many of the contractors’ details already filled in. You’ll need to complete any additional fields at the top of the screen, and then either record the payment or debt under Category details or Item details, depending on how you do your bookkeeping. Either way, you’ll be able to enter the quantity and rate and/or amount and mark it billable (with a markup percentage, if you’d like) to a customer or project.

You’re probably going to want our help here, since there’s more than one way to pay independent contractors. If you subscribe to QuickBooks Payroll, you can use the service’s contractor features, which include the ability to invite your contractors to fill out their own records in QuickBooks Online. You may also want to add an account to your Chart of Accounts, and we’d want to offer guidance there. And you need to ensure that you’re classifying payments correctly, so they’ll appear in 1099 reports and 1099s themselves.

Creating records for independent contractors and paying these individuals seem like they should be simple operations. But anytime you’re dealing with payroll issues, you’re dealing with peoples’ livelihoods – and the IRS. We strongly encourage you to let us help you get this right. Contact us, and we’ll make sure you’re handling your worker payments with absolute accuracy.