Downloading transactions into QBO is the easy part. You still have work to do once they’re on board.
Its ability to download financial transactions is one of the five best things about QuickBooks Online. Without it, you’d spend a lot of time on tedious data entry, verifying which checks and deposits had cleared and entering new ones.
Instead, you can easily connect to your bank and bring in all your activity from the previous hours or day. QuickBooks Online stores this neatly in a register and provides tools for you to further describe and classify each transaction.
Setting Up the Connection
Haven’t connected your financial institution to QuickBooks Online yet? It’s easy. Click the Banking link in the toolbar, then Add Account in the upper right. The Find your bank window opens. Start entering the name of your bank, credit card company, or service like PayPal in the blank field. A list of potential matches will drop down; you simply select the one you want. A window like this will open:
ll you need to do to start downloading transactions into QuickBooks Online is select your financial institution and enter the User ID and Password you use to connect directly to the site.
You will have to go through some security procedures, and then QuickBooks Online will download 90 days of transactions (you can shorten this if you’d like). You’ll also be asked which QBO account should receive the transactions. After a few minutes, the register for that account will appear, displaying the transactions you just downloaded.
Warning: The mechanics of connecting to your bank and downloading your first batch of transactions may sound easy, but if everything is not absolutely clear to you as you’re going through the process, please contact us sooner rather than later.
Working with Transactions
Once you’ve downloaded a set of transactions, you’ll want to look at them. Again, click the Banking link in the navigation toolbar. Your accounts will appear in small boxes at the top of the page, along with two balances: the one that came from the financial institution and the one in QuickBooks Online. Select the one you want by clicking on it, and its register will open.
Tip: QuickBooks Online generally updates your accounts once daily. If you want to launch a manual update at any time, click on Update in the upper right corner.
Let’s look at one downloaded transaction to see what you can do with it. Make sure the For Review column is highlighted above the register. Select a transaction by clicking on it. A window like this will open below it:
QuickBooks Online does more than simply download financial transactions: It lets you define them in greater detail.
There are several options here, including:
- Add to register. If you’re satisfied with the information as is, just click the Add button to the right (not pictured here).
- Split. If you want to split the amount/category (Supplies, Tools, etc.)/class of a transaction, click Split (also off to the right and not pictured). A window will open to let you specify that.
- Assign categories. QuickBooks Online may automatically make assignments to obvious categories, which you can change if incorrect. You can also click the down arrow to the right of that field and select your own from the list.
- Bill an expense to a customer. Did you purchase something that needs to be billed to a customer? Click in the box under Billable and select the correct one from the drop-down list that opens.
- Find matches. This can get complicated, and we recommend you let us work with you on it. Let’s say you entered an invoice in QuickBooks Online, and an income item for that exact amount gets downloaded from your bank. QBO will assume that those two “match,” and display them in the In QuickBooks column. You can click Undo if this is incorrect. But you can also click Find match in the transaction window, and QBO will open a list of possibilities.
As you can see from browsing the lists of downloaded transactions, there’s a lot to learn here. We’d be happy to get together and walk you through your first explorations of these powerful features.
Not finding quite everything you need in QuickBooks Online? Here are some handy add-on apps available.
QuickBooks Online may work for you just fine as is. After all, it was designed to meet the needs of the millions of small businesses that want to manage and track their income and expenses, create records and transactions, and run reports to gauge their financial health. QuickBooks Online was also designed to grow along with your business. But there’s no need for Intuit to add internal features to do so. In fact, that would make it too expensive and unwieldy for many companies.
Instead, Intuit has partnered with other small business websites to provides add-ons–applications that extend the usefulness of QuickBooks Online in one or more areas, like accounts receivable and payable, inventory, and expense-tracking. They integrate easily to share data and do the extra work you need. Here are some of them to consider.
You can certainly enter and pay bills using QuickBooks Online. And you can send invoices to customers and receive payments. But adding a connection to Bill.com gives you more advanced options for accounts receivable and payable. Simply send your bills to Bill.com by scanning, emailing, faxing, or taking a picture with your smartphone. The site’s automation tools turn them into digital records and route them through your specified approvers. Once approved, they’re paid electronically or by paper check. Invoices are just as easy to process; customers can pay by using PayPal, credit card, or ACH. Bill.com’s mobile app makes it possible to keep up with invoices and bills while you’re out of the office.
Are your employees still paper-clipping receipts to handwritten expense reports? This method is unnecessarily time-consuming – and often inaccurate. Expensify solves both problems. Your staff can take photos of receipts with their smartphones. Expensify then converts the expense information into coded digital records and submits them for approval based on your company’s policies. Credit card purchases can be automatically imported, too. All data is synchronized with QuickBooks Online in real-time and coded to reflect your preference of QBO’s expense accounts, customers/jobs, etc. Once you’ve approved a report, you can have the money deposited in the employee’s bank account the next day.
TSheets Time Tracking
TSheets employee scheduling software automates tasks that QuickBooks Online doesn’t do: scheduling and remote time-tracking for your hourly employees. Your staff no longer has to fill in paper timesheets. Instead, they can use their smartphones to track their hours and GPS location points. And while Excel is certainly better for creating schedules than paper, TSheets takes over that task, too. After you’ve approved timesheets, that information is sent over to QuickBooks, ready for use in your payroll processing.
Your employees can easily “punch” in and out using their smartphones. TSheets also uses GPS technology so that your staff members’ locations are always known to you.
QuickBooks Online performs some basic inventory management tasks. You can create records for items and use them in transactions, and keep track of the number of items in stock so you know when to reorder (or have a sale). SOS Inventory goes well beyond those capabilities. You can create sales orders, track cost history and serial numbers, and document work-in-progress (WIP). SOS Inventory supports multiple locations and the entire pick/pack/ship process.
You can create thorough customer records in QuickBooks Online and document some of your interaction. But it doesn’t facilitate true Customer Relationship Management (CRM) nor project management. Insightly CRM does both. It lets you build exceptionally thorough customer profiles so that you can view social streams, email history, and any events, opportunities, or events related to them. Its project management features include the ability to track by pipelines or milestones, define contact roles and custom fields, and generate advanced project reporting.
QuickBooks Online Integration Key
All of these apps can work in standalone settings, but their integration with QuickBooks Online and their mobile capabilities create powerful partnerships that help you serve both your customers and your employees in ways that QuickBooks Online alone can’t.
We’re not trying to sell you applications here. Our concern is that you’re getting as much out of QuickBooks itself as you can. We can steer you toward add-on solutions if that seems necessary, but we’re always happy to work with you on getting to know QuickBooks Online better and matching its capabilities to your company’s needs.
Assessing finance charges is a complicated process. But if you have a lot of late payments coming in, you may want to consider it.
There are many reasons why your customers send in payments past their due dates. Maybe they missed or misplaced your invoice, or they’re disputing the charges. They might not be very conscientious about bill-paying. Or they simply don’t have the money.
Sometimes they contact you about their oversight, but more often, you just see the overdue days pile up in your reports.
You could use stronger language in your customer messages. Send statements. Make phone calls if the delinquency goes on too long. Or you could start assessing finance charges to invoices that go unpaid past the due date. QuickBooks provides tools to accommodate this, but you’ll want to make absolutely sure you’re using them correctly – or you’ll risk angering customers and creating problems with your accounts receivable.
Setting the Rules
Before you can start, you’ll need to tell QuickBooks how you’d like your finance charges to work. It’s at this stage that we recommend you let us work with you. There’s nothing overly difficult about understanding finance charges in theory: you apply a percentage of the dollar amount that’s overdue to come up with a new total balance. But setting up your QuickBooks file with the finance charge rules you want to incorporate may require some assistance. If it’s done incorrectly, you will hear from your customers.
Here’s how it works. Open the Edit menu and select Preferences, then Finance Charge | Company Preferences.
Figure 1: Before you can start adding finance charges to overdue invoices, you’ll need to establish your company preferences.
What Annual Interest Rate percentage do you want to tack onto late payments? This is an issue we can discuss with you. Too low, and it’s not worth your extra time and trouble. To, high, and your customers may stop patronizing your business. And do you want to set a Minimum Finance Charge? Will you allow a Grace Period? If so, how many days?
You’ll need to assign an account to the funds that come in from interest charges. This needs to be an income account. In our example, it’s Other Income.
The next decision, whether to Assess finance charges on overdue finance charges, needs consideration – and some research. This may not be an option depending on the lending laws in the jurisdiction where your business is located. So again, if you want to charge interest on unpaid and tardy finance charges themselves, let’s talk.
When do you want the finance charge “countdown” to begin? When QuickBooks identifies a transaction that has not been paid within the stated terms, do you want the added charge to be applied based on the due date or the invoice/billed date?
Note: If your business sends statements rather than invoices, leave the Mark finance charge invoices “To be printed” box at the bottom of this window unchecked.
Applying the Rules
QuickBooks does not automatically add finance charges to your customers’ invoices. You’ll need to administer these additions yourself, though QuickBooks will handle the actual calculations. Open the Customers menu and select Assess Finance Charges to open this window:
Figure 2: You’ll determine who should have finance charge invoices created in the Assess Finance Charges window.
Make very sure that the Assessment Date is correct, as it has impact on QuickBooks’ calculations. Being even a day off makes a difference. Select the customers who should have finance charges applied by clicking next to their names in the Assess column. QuickBooks will display the Overdue Balance from the original invoice, as well as the Finance Charge it has calculated.
- If you choose not to apply finances charges to a customer because he or she has provided a good reason for the late payment, be sure the box in the Assess column is unchecked.
- If you want to change the finance charge due for a valid reason, you can type over the amount in the last column. This would be a rare occurrence and should be exercised only after consulting with us.
Important: If there is an asterisk next to a customer’s name, there are payments or credit memos that have not yet been applied to any invoice.
When everything is correct, click the Assess Charges button at the bottom. QuickBooks will create separate invoices for finance charges for each customer who owes them.
We can’t stress enough the importance of consulting with us before you start to work with finance charges enough. Keep your company file accurate and your customers happy by getting this complex accounting element right from the start.
If you dread every minute of the time you spend on accounting, you should know how QuickBooks Online can change your outlook.
How long would it take you to determine:
- What your total expenses for this quarter are?
- Whether or not your business is profitable as of today?
- How much you’ve sold every month this year?
- Which invoices are overdue?
If you’re using QuickBooks Online, you can get answers to all those questions—and more—in the time it takes you to sign on to the website.
That’s not an exaggeration. The first thing QuickBooks Online displays is what’s called its Dashboard. This is the site’s home page, which contains an array of charts and account balances that provide a quick overview of your finances. Click on an element here—say, a checking account balance—and you’ll be able to drill down and see the details behind it (in this case, an online account register). Click on the Expense graph, and a transaction report opens.
Your First Hours with QBO
QuickBooks Online is not one-size-fits-all. Its setup tools help you customize it to meet your own company’s needs.
QuickBooks Online works like other online productivity applications you may have used. It uses toolbars and buttons for navigation, drop-down lists and blank fields for data entry, and clickable links to open new related screens to trigger actions. Which is to say, the site is easy to use once you understand its structure. We can walk you through the early steps that are required, which involves tasks like: Using the provided setup tools to customize the site. Connecting QuickBooks Online to your bank and credit card company websites so you can work with transactions. Creating records for your customers, vendors, and the products and services you sell (you’ll be able to add new ones as your business grows). Learning about QuickBooks Online’s pre-built reports. Familiarizing yourself with the site’s workflow. Making the transition from your current accounting system.
How You’ll Benefit
Once you’re comfortable using QuickBooks Online, you’ll discover what millions of small businesses have already learned, that the site helps you:
Get paid faster. According to the business advisory in miami fl you can sign up with a payment processor to accept credit cards and direct bank withdrawals, which can speed up your customers’ responses to invoices. You’ll also be able to accept payments when you’re out of the office on your mobile devices.
Minimize errors. Once you enter data, QuickBooks Online remembers it. No more duplicate data entry that can cause costly mistakes.
Find any detail in seconds. QuickBooks Online has powerful search tools that allow you to find what you’re looking for quickly.
Better service customers. Because your customer profiles include transaction histories, you’ll be able to deal with questions and problems quickly and accurately.
Bill time as well as invoice products. QuickBooks Online supports sales of time-based services with capable time-tracking tools.
Improve your customers’ and vendors’ perception of you. Your business associates will know that you’re using state-of-the-art technology by the forms you share and the customer service you provide.
Save money and time. As the accountant rotterdam has noted, it does take some time to make the transition to QuickBooks Online. But you’ll quickly make that up with the hours you’ll save on accounting tasks, and be able to concentrate on tasks that improve your bottom line.
Be prepared to grow. Because all of your financial data is organized and easily accessible, you’ll be able to quickly generate reports that help you plan for a more profitable future. Banks and investors will need some of these if you decide to seek financing.
Although you may do the bulk of your accounting work on your desktop or laptop, you’ll have access to many of the site’s features on your smartphone. Your home page displays both an abbreviated version of your browser-based dashboard and a list of recent transactions. You can view, edit, and build new customer, vendor, and product or service records. Snap a photo of a receipt to document an expense and look up or create invoices, estimates, and sales receipts. Record payments, view critical reports, and add notes. Of course, your mobile data is always synchronized with the site itself.
QuickBooks Online lets you do much of your accounting work when you’re away from the office with its mobile app.
Happy to Help
QuickBooks Online was designed for small business people, not accountants. But it includes features that are best used in conjunction with our consulting services, like advanced reports, payroll, and the Chart of Accounts. In fact, the site makes it easy for us to have access to your data so we have the ability to monitor and troubleshoot.
We’ve helped countless sole proprietors and small businesses move their accounting operations to QuickBooks Online, and we’ve seen the difference it’s made in their productivity as well as their attitude toward financial management. Contact us, and we’ll be happy to do the same for you.
Social media posts
Still doing your accounting manually? You’re spending unnecessary hours and experiencing needless frustration. Talk to us about QuickBooks Online.
Did you know you can do much of your accounting work and accept customer payments on your smartphone? Let us introduce you to QuickBooks Online.
Are you often away from the office? QuickBooks Online lets you handle accounting tasks from anywhere there’s an internet connection. We can tell you how.
Does your manual accounting system make it hard to keep track of customers and inventory? QuickBooks Online can organize and manage both. Contact us.
QuickBooks Online was built to work with transactions downloaded from your online financial institutions. Here’s how to work with them.
The ability to import transactions from financial institutions into QuickBooks Online is definitely one of the best things about the site. You may have even signed up for that very reason.
By now, you’ve probably already set up at least one connection. But are you using all of the QuickBooks Online’s account tools? There’s a lot you can do once you’ve imported in data from your bank or credit card provider with the help of an accountant. Before you start managing your own money, look for Accountants to get help fast.
We’ll explore these features in this column and the next.
If you’re a new subscriber, you may not have established these critical links yet. It’s an easy process. Start by clicking the Banking link in the left vertical navigation pane. In the upper right corner, click Add Account and enter the name of your financial institution if it’s not pictured. Then follow the instructions you’re given on the screen. These can vary depending on the bank or credit card provider, but you’re always at least asked to enter the user name and password that you use to log into each online.
Need help with this? Let us know.
Viewing Your Transactions
Once you’ve made a successful connection, you’ll be returned to the Bank and Credit Cards page. You should see a card-shaped graphic at the top of the screen for each account you’ve linked. Click on one. The table that opens is not your account register. The view here defaults to For Review, which refers to transactions you’ve downloaded. The All tab should also be highlighted; we’ll get to Recognized transactions later.
When you first download transactions into QuickBooks Online, before you’ve done anything with them, many will appear under For Review.
There’s a lot going on here, so don’t be surprised if you’re confused. Review each transaction by clicking on it. QuickBooks Online will have guessed at how it should be categorized, but you can change this by opening the list in the category field and selecting the correct one. It’s critical that you get this right since it will have an impact on reports and income taxes. If you need to split it between multiple categories, click on that button found to the right. If the transaction is Billable, check that box and choose a customer from the drop-down list. If you don’t see this box, click the gear icon in the upper right and select Account and Settings | Expenses. Check to see that Make Expenses and Items Billable is turned On (click on Off, then check the appropriate box to turn it on).
Next, determine how you want to process the transaction by clicking on one of the three buttons at the top of the transaction box. Do you want to accept it and add it to that account’s register? Do you want QuickBooks Online to Find (a) Match for it (like a payment that matches an invoice, for example)? Or, do you want to transfer it to another account? Once you’ve made one of these three selections, the transactions that you’ve added or matched will move under the In QuickBooks tab (where you can still Undo them) and will be available in the account’s register.
You can save time by using QuickBooks Online’s Batch Actions tool or even with DPS Accounting .
Say you run across some duplicate or personal transactions that you don’t want to appear in the current account’s register. Check the box in front of each, then click the arrow in the Batch Actions box. Select Exclude Selected. They’ll then be available under the Excluded tab. You can also Accept or Modify multiple transactions simultaneously by using this tool.
So far, you’ve been viewing All your transactions. Click on Recognized to the right of it. These are transactions that are already familiar to QuickBooks Online because they’ve appeared before and/or have been matched, or because you’ve created Bank Rules for them (we’ll address that concept next month). You’ll need to address these the same way you did the transactions in the For Review section; you can either Add or Transfer them.
If you’re new to QuickBooks Online, this may all sound pretty complicated. It can be at first. But once you’ve worked with downloaded transactions for a while, you’ll understand the flow much better. If you’re not clear on the process from the start, it can lead to trouble. Contact us at your convenience. We’d be happy to sit down with you and go through it all using your own company’s data; the familiarity may help.
Social media posts
If you’re new to QuickBooks Online, there’s a lot you need to understand about dealing with downloaded transactions out the gate. Let us help.
When you download transactions into QuickBooks Online, the site sometimes automatically “matches” them to existing entries. We’re here to explain and help you navigate this. Tired of reviewing downloaded transactions one by one in QuickBooks Online? Click on the Batch Actions button to explore this feature. We can show you how.
QuickBooks Online often guesses at how downloaded transactions should be categorized. You should always check these for accuracy, and we can show you how.
‘Tis the season for making resolutions and setting goals. Try exploring these three areas to dig deeper into QuickBooks Online.
By now, many New Year’s resolutions have already been made – and broken. Though they’re usually created with the best of intentions, they’re often just too ambitious to be realistic.
For example, you might decide to learn more about QuickBooks Online and keep up with your accounting chores more conscientiously in 2019. That’s hard to quantify. How will you know if you achieved that goal?
Instead, why not pick three (or more) specific areas and focus on them this month? We’ll get the ball rolling for you by making some suggestions.
Explore the QuickBooks Online mobile app:
Yes, QuickBooks Online itself is already mobile; you can access it from any computer that has an internet connection and browser. But you probably don’t always lug a laptop around when you’re away from the office, and you’re sometimes at locations were using it wouldn’t be practical. But you can always pull out your smartphone and fire up the QuickBooks Online app, available for both iOS and Android.
No matter how small your smartphone (this image was captured on an iPhone SE), you can still do your accounting tasks using QuickBooks Online’s app.
QuickBooks Online’s app replicates a surprising percentage of the features found on the browser-based version. You can create, view, and edit invoices, estimates, and sales receipts for example, as well as see abbreviated customer and vendor records. Your product and service records are available there, including tools for recording expenses on the road.
Create a budget for one month:
Budgets are intimidating. That’s one reason why some small businesses don’t create them. So instead of trying to estimate what your income and expenses will be for an entire fiscal year, just build a budget for one month. In QuickBooks Online, you’d click the gear icon in the upper right, then select Budgeting. Click Add budget in the upper right to open the New Budget window.
Give it a name, like “February Budget,” and select FY2019. Leave the Interval at Monthly, and open the Pre-fill data? menu to click on Actual data – 2018 (if you have data from last year). Then click Create Budget in the lower right corner. Look at last year’s February numbers and estimate how they might change in 2019. Replace the old numbers with your new ones.
Creating a framework for a budget in QuickBooks Online is easy.
We’re suggesting you try it for just one month, so you get a feel for how this tool works. And that experiment will probably leave you with some questions. We can help you go further and complete an annual budget.
Customize your sales forms:
Every piece of paper and email you send to your customers contributes to their impression of you. Are you presenting an attractive, consistent image of your business to them? QuickBooks Online can help with this. It offers simple (for the most part) tools that allow you to modify the boilerplate forms offered on the site – without being an experienced graphic designer.
Start by clicking on the gear icon in the upper right and selecting Your Company | Custom Form Styles. Unless you’ve done some work in this area before, the screen that opens will have just one listed entry: your Master form, the one that comes standard in QuickBooks Online. To see what you can do, click Edit at the end of that line. Your four options are:
- Design. This section contains links to modifications you can make to your sales forms’ visuals. You can, for example, add a logo or color and change the default fonts.
Want to change your logo or other elements of your sales forms? QuickBooks Online has the tools.
- Content. Do you want to add or remove the standard columns (Date, Quantity, etc.) displayed on your invoices? You can do so by checking and unchecking boxes.
- Emails. QuickBooks Online sends email messages with forms; you can edit them here.
- Payments. This is a reminder that QuickBooks Online supports online payments, which can help you get paid faster.
There’s more you can do to make your sales forms look professional and polished. We can help you with these tools – and any others you want to explore to expand your use of QuickBooks Online. It’s a new year, and who knows what might come your way over the next 12 months? Contact us if you want to prepare for the new accounting challenges that 2019 might present.
Social media posts
Did you resolve to grow your understanding of QuickBooks Online in 2019? We can help you explore new features.
Go mobile in 2019: Download the QuickBooks Online app for your smartphone. You’d be surprised at how much it can do for you while you’re on the go.
How are things going with your 2019 budget? If you don’t have one yet, let us show you how QuickBooks Online simplifies this critical task.
QuickBooks Online’s sales forms (like invoices) may work fine for you. Do you know, though, how they can be customized to fit the image of your business? Ask us.
QuickBooks Online’s mobile app, available at the Apple App Store and Google Play, can do many of the same tasks that it performs on your office desktop. You can, for example:
- Check account balances.
- Add and edit estimates, invoices, and sales receipts.
- Add and edit customers, vendors, products, and services.
- Record invoice payments.
One of the most common uses of the app, though, is the recording of expenses. Rather than coming home from a trip with your briefcase stuffed full of receipts and notes about purchases you made, you can document them on the road using your mobile device. When you get back to the office and log on to QuickBooks Online, they’ll all be there.
How It Works
You can snap a photo of a receipt with your smartphone and attach it to an expense you record in QuickBooks Online’s mobile app.
Open your QuickBooks Online mobile app and click the plus (+) sign at the bottom, then tap the Expense icon. The New Expense screen will open. If you have a paper receipt, lay it flat on a table in a well-lighted area. Click the camera icon and then the Take Photo link. If you took the picture outside of QuickBooks Online for some reason, you’d select the Choose Existing link. Your device’s camera will open, and you’ll see four squared corners on the edges of the screen.
Hover your device over the receipt. You’ll need to position the camera so the receipt area that you want to be captured appears within the four corners. QuickBooks Online will provide advice along the way to help you do this. When you’re in the right place, you’ll see the phrase, Great! Snap the pic. Click the shutter icon below, and your device will snap the photo and display it. If you want to use it, click Use this photo (if you want to try again, click the X in the upper left of the screen).
QuickBooks Online will open the New Expense screen. You’ll see a miniature version of your receipt in the upper left corner. Looking at your original version—it will be too small to see here—fill in the blanks with the data from the purchase. Be sure to click the Billable button if you can bill someone else for it. Make any notes you’ll need in order to remind yourself of the transaction, and Add a Split if you need to divide the transaction between categories, customers or vendors, or billable status. Click Save when you’re done.
Once you’ve entered an expense in QuickBooks Online’s mobile app, it will be synchronized with your desktop, browser-based version.
Of course, no duplicate data entry is required once you’ve entered a receipt in the QuickBooks Online mobile app – the two versions always update each other.
Once you’re back at your desktop, on the browser-based version of QuickBooks Online, click Expenses in the toolbar to open the Expense Transactions screen. You should see the transaction you just created on your mobile device first in line on the list that displays. Click View/Edit at the end of that line to see it. Look toward the bottom under Item Details to see the link to an attachment that contains the photo you snapped of the receipt.
The record of the expense you entered on your mobile device will contain a link to an attachment that contains the photo of your receipt.
Of course, you don’t have to take a picture of your receipt with your mobile device. You can simply enter the details of your expense and Save the record.
QuickBooks Online’s mobile app can help you save time and improve the accuracy of your work done away from the office. As we mentioned earlier, the app is capable of doing much more than simply recording receipts. We’d be happy to run you through its pieces to make sure your remote accounting work is done correctly and this is done by companies like DPS Accounting which manage the best accounting system.
Social media posts
Have you downloaded and explored QuickBooks Online’s iOS or Android mobile app? There’s a lot you can do away from the office. Let us show you how.
If you come home from trips with a briefcase full of receipts, you should consider entering them quickly and remotely on the QuickBooks Online mobile app.
Collecting a lot of receipts on the road? Snap photos of them using QuickBooks Online’s mobile app. Your expense record will sync with the browser-based version.
Did you know when you take a picture of a receipt using QuickBooks Online’s mobile app, it appears as an attachment in that expense record in your desktop version?
It’s a gig economy. QuickBooks Online makes it easy to track and pay independent contractors.
In days past we used to call it “moonlighting” – taking on a second, part-time job for extra money. And we saw how prevalent this became was when millions of people had to resort to side gigs to keep afloat during the economic downturn of a decade ago. Some who had lost full-time employment even turned one or more of these part-time passions into a small business and became independent contractors for other companies.
If you’re thinking of hiring a freelancer to do some of your work, you’ll find that QuickBooks Online can accommodate your accounting needs for them nicely. Since they’re not W-2 workers, your paperwork needs are minimal. They’ll simply fill out an IRS Form W-9 and you’ll pay them for services provided, dispatching 1099-MISCs after the first of each year so they can pay their taxes.
Here’s how it works.
Creating Contractor Records
Warning: Be sure that any independent contractor you hire cannot be considered an actual employee. The IRS spells out the differences very clearly and takes this distinction very seriously. If you have any doubts, we can help you determine your new worker’s status.
You can either let a new contractor complete his or her own profile or do so yourself.
Like you would with anyone you employ, you’ll need to create records for contractors in QuickBooks Online. Click on Workers in the left navigation pane, then Contractors | Add a contractor. In the window that opens, enter the individual’s name and email address. If you want the contractor to complete his or her own profile, click on the box in front of Email this contractor…
Your contractor will receive an email with an invitation to create an Intuit account and enter W-9 information, which will be transmitted to your QuickBooks Online company account. This will make it easy to process 1099s when tax season arrives. He or she will also be able to use QuickBooks Self-Employed, an Intuit website designed for freelancers. We can walk you through how this works.
If you’d rather enter the worker’s contact details yourself, leave the box blank. A vertical panel containing fields for this information will slide out from the right.
Contractors are also considered vendors. So when you create a record for a contractor, it will also appear in your Vendors list in QuickBooks Online. In fact, you can complete a contractor profile by clicking Expenses in the left vertical pane, then Vendors. Click New Vendor in the upper right and fill in the relevant fields there. Be sure to check the box in front of Track payments for 1099. An abbreviated version of your new record will also be available on the Contractors screen as the two are synchronized.
When you create a Vendor record for an independent contractor, be sure to check the Track payments for 1099 box.
Working with Contractors
You’ll notice in the screenshot above that Brenda Cooper had an Opening balance of $2,450 when you created her record. That’s money you already owed her, and for which she had probably sent you an invoice. QuickBooks Online turned that into an Accounts Payable item that you could find in multiple reports and on both the Vendors and Expenses screens. It will be listed as a Bill in reports, though you haven’t actually created one yet.
You have three options here. You can create a Bill and fill in any missing details if you don’t plan to pay Brenda immediately. If you want to send her the money right away, you can either enter an Expense or write a Check. There are many places in QuickBooks Online where you can do the latter two. We think it’s easiest to return to the Contractors screen since you can accomplish all three from there.
The Contractors screen contains links to the three ways you can handle compensation due to a contractor.
Whenever you receive an invoice from a contractor, you can visit this same screen and choose one of the three options.
You’ll have to select a Category for your payment from the list provided in each of these three types of transactions. The Chart of Accounts contains one called Subcontractors, which may or may not work for your purposes.
We strongly encourage you to consult with us as you begin the process of managing independent contractor compensation to deal with this issue as well as others. QuickBooks Online offers multiple ways to get to the same end result, and it can be confusing. Contact us, and we can schedule a consultation.
Social media posts
Hiring independent contractors? Be sure they should be classified as such, and not employees. We can help you determine how to do this.
QuickBooks Online offers many ways to do the same tasks when you’re working with independent contractors. Here is how we can help you figure this out.
There are three ways to record financial obligations to independent contractors: bill, check, and expense. Do you know the differences? We can help you figure this out.
Though you don’t have the same payroll requirements for contractors as you do employees, it’s very important to get it right. Here are a few ways we can help you with this.
Does your business do work for clients over weeks or months? Consider using QuickBooks Online’s progress invoicing.
Let’s say you’re doing a job or project for a customer that is going to take a long time, but you don’t want to wait until you’re finished to get paid. Or you’ve agreed to let a customer pay for something in multiple payments. QuickBooks can help. You can create an estimate upfront for the work or products and send a series of invoices at different intervals until the bill is paid off. This is called progress invoicing.
Before you can use this tool, you’ll need to make sure it’s turned on. Click the gear icon in the upper right and select Account and Settings. Click the Sales tab. Look for Progress Invoicing in the left column. If that option isn’t On, click the pencil icon in the far-right column and click on the box to create a checkmark and Save it. Then click Done in the lower right corner.
Creating a Template
You’ll need to use a special template for progress invoicing. Click the gear icon again and select Custom Form Styles. In the upper right corner of the screen that opens, click the arrow next to New Style and select Invoice to open the design window. Replace the template name with a descriptive one and click Airy Classic to select it.
You’ll need to select the Airy Classic template and give it a descriptive name.
There are other options on this page – lots of them. You can add a logo, change fonts and colors, and even modify the content on the invoice. Talk to us if you want to explore the possibilities.
Your progress invoice needs you to adjust a couple of other things here. Click on Edit print settings. If there is a check-in front of Fit printed form with pay stub in window envelope, uncheck it. Next, click the Content tab, then click the small pencil icon in the second section of the invoice sample over on the right. At the bottom of the left pane, click Show more activity options. Check the box in front of Show progress on line items if you want your progress invoice to display item details. When you’ve made all the changes you want to, click Done.
Estimate to Invoice
QuickBooks can create both invoices and estimates. They’re very similar, and you’ll complete them in the same way, with one obvious exception: In addition to an Estimate date, you can also specify an Expiration date. Click the + sign in the upper right, select Estimate, and fill out the form. Save and close when you’re done.
When your customer has accepted the estimate and you’ve agreed on a payment schedule, you’ll need to know how to create a progress invoice. Click Sales in the navigation bar on the left, then All Sales. Locate your estimate on the list and click Create invoice at the end of the row. This window opens:
You have three options when the time comes to start your progress invoicing.
You’ll choose Remaining total of all lines when you’re ready to send your final invoice. For your first, you can either enter a percentage of each line item or a custom amount for each. If you choose a percentage, QuickBooks will calculate what that number would be and enter it. You’ll be able to specify your custom amounts when the progress invoice actually opens. Click Create invoice.
The invoice that opens will contain the information you provided on the estimate. You’ll notice a new column here, though, labeled Due. Your calculated percentage will appear there if you chose that option. If you indicated that you wanted to enter a custom amount for each line, that field will say $0.00 of [total]. Go down that column and type in the amount you expect to be paid on each line item. When you’ve finished, Save the invoice and send it to your customer. Now it appears in the invoice list, where you can send reminders, receive payment, etc.
You can send as many progress invoices as you’d like until you can finally bill your customer for the Remaining total of all lines. QuickBooks provides a report so you can see the progress of all of your progress invoices at once. Click Reports and scroll down to Sales and customers to run Estimates & Progress Invoicing Summary by Customer.
Progress invoicing is a simple concept, but it requires many steps, as you’ve seen here. And there are other ways to go about it in QuickBooks. We strongly suggest that you let us help you with this task to make sure your invoices are set up correctly – and that you’ve paid in full.
Social media posts
Do you need to bill customers over time? Let us help you set up progress invoicing.
When you create a progress invoice, you can bill customers for a percentage of what they owe or specify custom amounts. We can help here.
Need to know the status of your progress invoices? Run the Estimates & Progress Invoicing Summary by Customer report. We can show you how.
Did you know when you create an estimate for a customer, you can also set up a payment plan for your work? This is called progress invoicing. We can help show you how.
Every interaction with your customers can enhance your image. Here’s how QuickBooks Online contributes to that.
Getting paid by your customers—on time, and in full—can take some effort on your part. You set smart due dates and enforce them. Price your products and services so they’re both reasonable and profitable. Accept online payments.
But are your invoices working for you here? QuickBooks Online provides sales form templates that you can usually use without modifying. But it also offers tools that support multiple kinds of customization. It helps you shape the content and appearance of your invoices and their accompanying messages to be consistent with your company’s brand.
These may be cosmetic changes, but they can affect the way customers react to communications from you. You have few chances to make an impression, so anything you can do to enhance and personalize every interaction will have impact on their impression of you. Neat, well-designed sales forms convey professionalism and attention to details.
Here’s a look at what you can do.
Unless you use every single field in QuickBooks Online’s default sales form template, your invoices will look sloppier than they might otherwise. The site gives you control over much of the content that your customers will see. To make changes, click the gear icon in the upper right of the screen and select Account and Settings, then Sales. You’ll see Sales form content in the left column. Click on any of the fields to the right to open a more thorough list of options.
QuickBooks Online lets you turn fields on and off in your sales forms and specify other preferences.
Click on the status (On, Off) in the right column to change it. When you’re satisfied with your selections, click Save. Then close that window by clicking the X in the upper right corner.
You have more options than these. Click the gear icon again, and then Your Company | Custom Form Styles. You’ll see that there is already a “master” form. You can either edit it or create a new one. We recommend leaving the master form alone so you always have a clean copy to consult if you get tangled up while you’re working.
Click the down arrow in the New style box in the upper right and select Invoice. In the screen that opens, enter a descriptive name for your template in the field at the top and then click Content. A graphical representation of your invoice will appear in the right pane, grayed out. It’s divided into three sections: header, footer, and table (the middle of the invoice where you describe what you sold). Each displays a small pencil icon on the right side of the screen. Click the one in the middle to make that area more visible.
It’s easy to specify which fields should appear on your invoices, what the labels should say, and how wide space should be.
As you check and uncheck boxes to indicate what content should be included, your invoice on the right will change to reflect your actions. You can preview SodaPDF software by clicking that button in the lower right. When you’re satisfied with the changes you’ve made to all three sections, click on the Design tab.
Changing the Look
You don’t have to be a graphic artist to have QuickBooks Online forms that look attractive and consistent, which highlight your brand. The site provides tools that give you control over the appearance of your invoices, not just their content. Click each link below the Design tab to:
- Choose a template.
- Add your company’s logo.
- Select a color scheme and fonts.
- Change the printer settings to accommodate letterhead, for example.
Choosing Your Words
You have control over the messages that go out with your invoices.
Finally, click the Emails tab. Options here let you customize the emails that are sent to customers along with their invoices. Again, changes you make in the left pane will be reflected in the graphical version on the right side.
When you’ve completed all of your modifications, click Done.
We gave you this whirlwind tour of QuickBooks Online’s invoice customization options so you’d know what was possible. We expect you might need some assistance when you sit down to apply the concepts you’ve learned about to your own company’s sales forms. We’re available to help you present a polished, carefully-crafted image representing your brand to your customers.
Social media posts
Are you satisfied with the image you convey to customers through your QuickBooks Online sales forms? We can help you make them more customized and effective.
You have few chances to interact directly with your customers. Make sure your QuickBooks Online sales forms convey the image you and your brand deserves.
QuickBooks Online comes with sales form templates that may work for your company, but did you know you have control over their appearance and content?
Your customers pay attention to the sales forms you produce for them. QuickBooks Online lets you improve on the default templates it provides making a better impression to your client.