QuickBooks

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.

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.

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.

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.

Importing your bank transactions into QuickBooks saves time, improves accuracy, and makes you a better money manager.

It’s been a long time since your only options for learning about your bank balances and cleared transactions involved your telephone and your monthly statement. These days, accounting software and websites allow you to set up online connections to your financial institutions and download cleared transactions.

If you’re new to QuickBooks or you haven’t set up online banking yet, you may not realize how simple it can be (depending on your financial institution), or how safe it is. You can connect to one of your banks and import months of transactions in less than 10 minutes, depending on how active your accounts are, and again, your banks. And QuickBooks uses data protection that is similar to what banks themselves use. As long as you’re following personal security protocols on your own computer, you’re very unlikely to encounter problems.

Online banking saves an enormous amount of time. It provides daily updates on your accounts, and if you entered the original transactions correctly, accuracy is assured. This real-time view of your finances can help you avoid money problems, make better business decisions, and plan for your company’s future.

Here’s how it works.

The Bank Feeds Center

QuickBooks provides the tools required to set up and maintain online banking in the Bank Feeds Center. To get there, open the Banking menu and select Bank Feeds, then Bank Feed Center. Click Add account in the upper right. QuickBooks will display a message saying it needs to close all open windows. Click Yes. In the Bank Feed Setup window that opens, select your bank from the list or enter its name in the search box if it’s not there.

Not every financial institution provides a direct connection to QuickBooks, but many of the major ones do. If yours does, you’ll see a window like this:

Enter the user ID and password that you use to sign on to your bank’s website, then click Connect. You may be told that your financial institution needs more information. If that occurs, just follow the instructions. In our example, Discover Card wanted to send a temporary identification code as an email or text. Select your preference from the drop-down list and click Connect. Once you’ve retrieved your code and entered it, click Connect again. QuickBooks will open a window that displays your account(s) at the institution.

Now you have to tell QuickBooks where to download the transactions. Click the down arrow in the field under QuickBooks Accounts. You can select an existing account or create a new one. We want to create a new one here, so you’d click  Create New Account. You may recognize the Add New Account window if you’ve done this before. QuickBooks already knew that this was a credit card account, so it pre-selected that option in the Account Type field. If you’re connecting a checking account, for example, you would probably want to select Bank. Enter an Account Name. If you want to make it a Subaccount of another account, check that box and select the parent account from the drop-down list (or add a new one).

The rest of the fields here are optional. You can fill in the description and account number if you’d like, but don’t assign Tax-Line Mapping or Opening Balance without talking to us. Just leave them for now. When you’re done, click Save & Close. Click Connect in the window that opens after you’ve made sure your new account is showing in the field below QuickBooks Accounts.

If all has gone well, you’ll get a message saying that your account has been added to QuickBooks. Click Close. Go to Banking | Bank Feeds | Banks Feeds Center again. In the field next to Bank and Credit cards, click the down arrow to see a list if your new account isn’t already showing and select it. Click the rotating circle in the blue card below to download your first set of transactions (or anytime you want to refresh the feed). This will typically bring in 90 days of transactions, depending on your financial institution.

There are many ways financial institutions interact with QuickBooks’ bank feeds. This was the simplest one. You might have to contact your financial institution to get QuickBooks Direct Connect set up (fees may apply) or you may have to go to your bank’s website and select the statement or transactions you want to move into QuickBooks.

Next month, we’ll talk about managing the transactions you’ve downloaded into QuickBooks. In the meantime, we’re happy to help you troubleshoot your bank downloads if you need help.

There are many ways to encourage delinquent customers to pay. QuickBooks Online’s statements may be effective for you.

After the year-plus you’ve just experienced, the last thing your small business needs is customers who are behind on their payments to you. You may have been giving them a break because you know that they’re struggling, too, but things have been looking up for many companies in the past few months. It’s time for you to be more proactive about calling in your debts.

There are numerous ways you can accomplish this. One of the best is to send statements in QuickBooks Online, which are detailed reminder forms that contain multiple transactions. These can be especially helpful if you’ve sent multiple invoices with no response. There are three different types you can send, depending on your needs. Here’s how you create them.

Before You Start

QuickBooks Online offers a couple of options for formatting your statements. To see these, click the gear icon in the upper right corner and select Your Company | Account and Settings. Click the Sales tab and scroll down to the Statements section. Click the pencil icon over to the far right to make any changes needed. You can:

• List each transaction as a single line or include all of the detail lines.
• Display an aging table at the bottom of each statement.

Click the buttons to specify your preference and then click Save and Done.

Three Statement Types

You can choose from among three different types of statements in QuickBooks Online: Balance Forward includes invoices with outstanding balances for a specified range of dates. Open Item statements contain information about all unpaid (open) invoices from the last 365 days. And Transaction Statements show every transaction in a date range that you specify. We’ll describe how to create them so you can decide which makes the most sense for a particular situation.

One Way to Create Statements

Like it does for many other actions, QuickBooks Online offers two ways to create statements. The first is easier. Click the New button in the upper left and select Statement (under Other). Click the down arrow in the field under Statement Type to see the three options there.

If you select Balance Forward, you’ll need to define three criteria (there will be similar options for the other two types):<.p>

• Statement Date
• Customer Balance Status (Open, Overdue, or All)
• Start Date and End Date

When you’re satisfied with your statement parameters, click Apply. QuickBooks Online will display a list of the transactions that meet your criteria, along with the number of them that will be generated. Each row in the list will display the recipient’s name, email address, and balance. In the upper right corner, you’ll see the number of statements again and the total balance these customers represent.

If you want to exclude any of these customers, click in the box in front of each to unselect them and delete the checkmark. When you’re satisfied with your list, click Save, Save and send, or Save and close. If you click Save and send, a window will open containing a preview of your statements. Thumbnails of each will appear in the left pane. Click on any to see their previews. When you’re ready, you can download, print, or send them.

If you click Save or Save and close, you’ll still be able to see the statements you’ve just generated. Click the Sales tab in the toolbar, then All Sales. Click the down arrow next to Filter and open the drop-down list under Type. Select Statements, and your list will appear. You can print or send one by selecting the correct option in the Action column. If you want to dispatch multiple statements, click in the box in front of each, and then click the down arrow next to Batch actions.

Another Method

There’s an alternate way to create statements. Click the Sales tab in the toolbar, then Customers. Select any or all of the customers in the list, then click the down arrow next to Batch actions and select Create statements. QuickBooks Online will open the Create Statements window again so you can select the type and process your statements like you did using the previous method.

We don’t expect that you’ll have much trouble working with statements, though you may want to consult with us on when they’re appropriate. We can also suggest other ways to bring your accounts receivable up to date. As always, we’re available to help you maximize and streamline your use of QuickBooks Online. Keeping your financial books current and organized is one way to ensure that you don’t fall too far behind with customer payments.

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

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

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

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

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

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

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

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

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

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

Other Security Tips

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

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

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

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