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.

5 QuickBooks Online Tasks You Should Do Before January 1

Ida_BencomoLeave a comment

It’s probably your busiest month of the year. But there are things you can do to make your return from the holidays less stressful.

December always goes by so quickly. Seems like you’ve just finished Thanksgiving dinner and it’s time to ring in the New Year. You could probably spend the entire month on your personal obligations. But it’s also the end of the year, which means your busiest period if you’re a retailer. Even if you’re not, you probably have sales goals to try to meet. And you may have employee issues that need to be addressed before the calendar turns over.

On top of all of this, you should be closing out your books for the current year (as much as you can) in preparation for the new one. If you’ve been using QuickBooks Online conscientiously all year, your job will be a lot easier. But you’ll still need to carve out some time for year-end tasks.

We don’t expect that you’ll necessarily be able to wrap absolutely everything up by New Year’s Eve. You may be waiting for your customers and employees to do their part. But here are five things you can do amidst all of your other personal and professional plans that will help you get a jump on January.

Analyze your 2022 sales.

You won’t have your final numbers until the year is over, but you can get a good start in December. There are several QuickBooks Online reports that can give you a clear, understandable look at your 2022 sales. Click Reports in the toolbar and scroll down to Sales and customers. You can run reports that will tell you what your sales were by Class, Customer, Customer Type, and Product/Service, in summary or detail. The reports are customizable, so you can specify date ranges and group the results by, for example, Transaction Type, Customer, and Account.

You can customize and run QuickBooks Online’s Sales reports.

Warning: If you’re not clear about whether you should run reports in Cash or Accrual mode, let us help you with this. The distinction is important.

Know What You Owe

If money is tight at the end of the year, this will be a challenge. But you don’t want to come back from the holidays to a lot of past-due notices. To see what still needs to be paid, click Reports again and scroll down to What you owe. If you want the straight scoop right away, run Unpaid Bills. For a more detailed look, create the Accounts payable aging detail report. This groups your outstanding payables by days past due.

Know Who Still Owes You Money

This is a question that’s probably on your mind all year, but it’s especially important as the year winds down. It may be difficult to get delinquent customers to pay up in December, but you should at least know where you stand with them. Click the Reports tab again and scroll down Who owes you. Generate two reports there: Accounts receivable aging detail and Open Invoices. 

You might also want to spend an hour coming up with some strategies that would encourage customers to pay faster. If you’re at a loss about this, we could sit down together and come up with a plan.

Create statements for past-due customers

Customer statements are something like reports. They display sales transactions within a given period. Statements can serve two purposes. Sometimes, customers just want a list of their invoices and payments for their records. You can also use statements as a reminder to customers who are past due on their accounts.  Click New in the upper left corner, and then click Statement under Other.  There are three types, but you’d be most likely to create and send two of them:

  • Open Item. Displays all open, unpaid invoices for the last 365 days. 
  • Transaction Statement. Lists all transactions for the selected date range.

You can send statements to customers to remind them of overdue payments or just to provide a record of transactions for a given period.

Clean up your customers and vendor lists

If you only have a few of each, your list is probably current. But if you’ve been adding customers or vendors for years without ever editing the list, you’re probably spending too much time scrolling. You don’t have to delete them. You can just make them inactive. Click Sales in the toolbar, then Customers. If you know a customer has no open activity and you want to hide them, click in the box in front of the company or customer’s name. Repeat this for as many as you want, then click Batch actions in the upper left, then Make inactive.

A Busy Month

Don’t worry if you don’t get to all of these by the end of the year. But do add them to your January task list if you don’t. You might also consider having us run the standard financial reports that are available in QuickBooks Online Reports, under For my accountant. You can create reports like Trial Balance yourself, but they can be hard to analyze accurately. We’d be happy to set up a time after the first of the year to go over these after all of your 2022 transactions are in.

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 to Give Your QuickBooks Online Forms a New Look

Ida_BencomoLeave a comment

Your sales forms are a part of your company’s identity. Make them professional, personalized, and polished.

Your first impression of a business probably comes from a website or a mailing or an advertisement. The second might be from an invoice or sales receipt. What does it say about that company if its printed or digital sales forms are poorly designed or hard to read or just plain unattractive?

Customers form opinions about you not only from the quality of your products or services, but also by the professionalism and aesthetics of your written communications. Putting some effort into making them look good isn’t superficial. It’s an important part of your branding.

QuickBooks Online provides the tools you need to make your sales forms appealing, understandable, and consistent. They enhance your image and have impact on your customers’ overall impression of your business. Here’s how you can make them a part of your identity.

Where Do You Start?

QuickBooks Online comes with a default invoice form to get you started. You can either edit this one or create a new one. You can also make your own estimates and sales receipts. 

Click the gear icon in the upper right corner and select Custom form styles under Your Company. You’ll see the default invoice labeled Standard. We’ll leave that one as is and create a new one so there’s always a clean version. Click the down arrow next to New style in the upper right and select Invoice. You’ll see a copy of the default invoice, like this:

Table Description automatically generated

This is QuickBooks Online’s default invoice template. You can make a copy of it and modify it for your own company.

You’ll see your modification options in the left pane of this screen. Your choices are divided into three different sections. Before you start working with them, enter a name for your new template in the field at the top. QuickBooks Online will have suggested a name, but you can change it to something descriptive that you’ll remember, like My Modified Invoice 1022. 

Changing the Form’s Look

The first tab, Design, should be highlighted. From here, you can:

  • Change up the template. Choose from one of the six options that QuickBooks Online offers.
  • Add a logo. Browse your system files to find your logo.
  • Splash on some color. Select a color palette from the ones offered.
  • Get choosy with your font. Select a new font type and size.
  • Edit print settings. Change the margins and other print options.

Editing the Content

When you’re done there, click the Content tab. You’ll notice that your invoice, which appears in the right pane, is grayed out. There are three pencil icons on the right side of the form. Click the one in the upper right corner, next to the invoice number. The top third of the form becomes active, and the content in the left pane changes to match the fields on the right. As you make changes in the left pane, like checking a box to add a phone number, the actual sample invoice changes to reflect that.

Graphical user interface, text, application Description automatically generated

When you add, edit, or delete content in the left vertical pane…

Text Description automatically generated

…the changes are reflected in the sample invoice in the right pane. Your company information will appear like this across all of your sales forms.

As you click on the other two pencil icons in the sample invoice, the left pane displays your options for those content areas. You have control over all of the content on your forms. It’s even possible to add your own custom fields. Let us know if you want to do so and we’ll show you how.

Readying Customer Emails 

The third tab on the customization screen, labeled Emails, shows you what your form will look like when you email it to your customer. Again, your working area is in the left pane, with the finished result appearing on the right. You have multiple options here, including text for the subject line, greeting, and message. You can also edit the text for reminder emails. 

When you’re done customizing, you can preview the PDF that will be attached to your customer emails. Then click Done. Your new invoice will appear on the Custom form styles page. Whenever you want to modify an existing sales form, click Edit at the end of its row. You can also make any form the default by opening the Edit menu and clicking Make default. 

Making your sales forms the best that they can be doesn’t really take that long. And it will demonstrate to your customers that you care not only about the quality of your products and/or services, but also about your communications with them. If we can be of any help as you work with forms modification in QuickBooks Online, please let us know. We’ll be happy to walk you through the process.

How QuickBooks Online Tracks Products and Services, Part 2

Ida_BencomoLeave a comment

Last month, we created records for products and services. Now, we’ll talk about where they’re used in QuickBooks Online.

If you’ll recall, we went over two product-related concepts in QuickBooks Online in last month’s column. We first discussed getting the site ready for creating and using product and service records. You click the gear icon in the upper right and select Account and Settings, then click the Sales tab to indicate your preferences.

To create a product or service record, you hover your mouse over Sales in the left vertical pane on the main page and click Products and services. Click New in the upper right corner and open a blank record for an Inventory or Non-inventory part, a Service, or a Bundle (assembly). Once you complete a record and save it, it will appear in the list back on the Product and services page.

Working with Products and Services

That’s where we’ll start today, on the Products and services screen. This is a comprehensive table, a dashboard (or home page) for your products and services. It displays real-time information about your items’ pricing and inventory levels, as well as their type and tax status. At the top of the page, you’ll see big, colorful buttons that provide a total of the number of items that are low on stock or out of stock. When you click on one, a list of those products appears.

Application Description automatically generated with low confidence

QuickBooks Online’s Products and services page displays inventory levels and warns you when your stock is low and at zero.

Each row on this screen contains details about the item listed there, like Description, Sales Price and Cost, and Qty On Hand. If you look down at the end of the row, you’ll see options for several types of Actions: Edit, Make inactive, Run report, and Duplicate. Click the gear icon above the table to modify the columns in the table. 

The More menu at the top of the screen contains more options: Manage categories, Run reports, and Price rules. If you want to know what actions you can take on multiple items simultaneously, check the box in front of each and click the Batch actions menu, over to the right (Adjust quantity, Reorder, etc.).

Warning: Be very careful using the Adjust quantity option. There are legitimate reasons for employing it, but you need to make very sure that you understand how this will affect other areas of your accounting. Please ask us if you’re unsure.

Using Products and Services in Transactions

Once you start using product and service records in transactions, you’ll see why we suggested that you create those early on and make them as comprehensives as possible. While you can add products and services in the process of creating an invoice, for example, it’s much easier if you have them ready to go.

Let’s look at a sales receipt to see how this works. Click +New in the upper right corner and select Sales receipt. Select a Customer in the first field and verify that the related fields on the form were filled out correctly. Check and make any changes necessary in the Sales receipt date, Payment method, and Deposit to fields. 

Graphical user interface, application Description automatically generated

Once you’ve built up a list of products and services, they’ll be available when you create transactions.

Enter the Service Date, and then click the down arrow in the field under Product/Service. The top of the list has an entry labeled +Add new. Click it if you need to add a product or service on the fly, or just select the existing one that you want. QuickBooks Online will fill in the Rate, Amount, and Tax (status). You only have to enter the Qty (quantity) that you’re selling. 

If you have more items or services to add, you can do so on the next line(s). When you’re done, check the numbers in the lower right and save the transaction. QuickBooks Online will adjust your inventory to account for any items you just sold. You can see this change by going back to the Products and Services screen. Or you can run reports, including:

  • Sales by Product/Service
  • Product/Service List
  • Inventory Valuation Detail
  • Physical Inventory Worksheet

Supply Chain Woes?

It seems that the serious supply chain problems we were experiencing in previous months have eased up some, but you may still be having trouble stocking some items. We hope this isn’t affecting you too much. 

QuickBooks Online, though, can help ensure that you know ahead of time when you must reorder. Its inventory-tracking capabilities can also alert you to items that aren’t selling well, so you don’t get overstocked on anything. And the ability to pull up product and service records when you’re creating transactions saves time and keeps your inventory levels accurate. Please let us know if you need assistance with this element of your accounting – or any of QuickBooks Online’s other tools.

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.

How QuickBooks© Online Helps You Track Mileage

Ida_BencomoLeave a comment

With gas prices so high, you need to track your travel costs as closely as possible. Consider getting a tax deduction for your business mileage.

If you drive even a little for business, it’s easy to let mileage costs slide. After all, it’s a pain to keep track of your tax-deductible mileage in a little notebook and do all the calculations required. If you do rack up a lot of business miles, you probably forget to track some trips and end up losing money.

QuickBooks Online offers a much better way. Its Mileage tools include simple fill-in-the-blank records that allow you to document individual trips. You can either enter the starting point and destination and let the site calculate your mileage and deduction or enter the number of miles yourself.

If you use QuickBooks Online’s mobile app, it can track your miles automatically as you drive (as long as you have the correct settings turned on). Here’s a look at how all of this works.

Setting Up 

To get started, click the Mileage link in QuickBooks Online’s toolbar. The screen that opens will eventually display a table that contains information about your trips, but you need to do a little setup first. Click the down arrow next to Add Trip in the upper right corner and select Manage vehicles. A panel will slide out from the right. Click Add vehicle.

A picture containing text Description automatically generated

You’ll need to supply information about your vehicles before you can start entering trips.

You’ll need to supply the vehicle’s year, make, and model. Do you own or lease it, and on what date was the vehicle purchased or leased and put into service? Do you want to have your annual mileage calculated by entering odometer readings or have QuickBooks Online track your business miles driven automatically? When you’re done making your selections and entering data, click Save.

Entering Trip Data

You can download trips as CSV files or import them from Mile IQ, but you’re probably more likely to enter them manually. Click Add Trip in the upper right corner. In the pane that opens, you’ll enter the date of the trip and either the total miles or start and end point. You’ll select the business purpose and vehicle and indicate whether it was a round trip. When you’re done, click Save. The trip will appear in the table on the opening screen, and your current possible total deduction will be in the upper left corner, along with your total business miles and total miles.

If you want to designate a trip as personal, click the box in front of the trip in that table. In the black horizontal box that appears, click the icon that looks like a little person, then click Apply. Now, the trip will appear in the Personal column and will not count toward your business tax-deductible mileage. 

Graphical user interface, text, application Description automatically generated

When you select a trip in the Mileage table, you can mark it as personal so it’s not included in your business tax-deductible miles.

Personal Trips Can Count, Too

If you use your vehicle(s) for personal as well as business purposes, tracking some of those miles can also mean a tax deduction. For tax year 2022, you can deduct 18 cents per mile for your travel to and from medical appointments. Note: Medical mileage is only deductible if medical exceeds a certain percent of AGI. Be sure to check with the IRS yearly tax code, as they update the mileage amounts annually.

And if you do volunteer work for a qualified charitable organization, the miles you drive in service of it can be deducted at the rate of 14 cents per mile. You can also claim the cost of parking and tolls, as long as you weren’t reimbursed for any of these expenses. Obviously, the IRS wants you to keep careful records of your charitable mileage, and QuickBooks Online can provide them.

QuickBooks Online doesn’t track these deductions, but you’ll at least have a record of the miles driven.

Auto-Track Your Miles

The easiest way to track your mileage in QuickBooks Online is by using its mobile app. You can launch this and have it record your mileage automatically as you’re driving. Versions are available for both Android and iOS, and they’re different from each other. They also have more features than the browser-based version of QuickBooks Online, like maps, rules, and easier designation of trips as business or personal.

Graphical user interface, application Description automatically generated

The iOS version of Mileage in the QuickBooks Online app

In both versions, you’ll need to click the menu in the lower right corner after you’ve opened the QuickBooks Online app and select Mileage. Make sure Auto-Tracking is turned on. Your phone’s location services tool must be turned on, too. There are other settings that vary between the two operating systems. You can search the help system of either app to make sure you get your settings correct if the onscreen instructions aren’t clear enough.

Of course, you won’t see the fruits of your mileage deductions until you file your 2022 taxes. But you can factor these savings in as you’re doing your tax planning during the year. Please let us help if you’re having any trouble with QuickBooks Online’s Mileage tools, or if you have questions with other elements of the site.

With gas prices so high, you need to track your travel costs as closely as possible. Consider getting a tax deduction for your business mileage.

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.