QuickBooks

Estimates—or quotes, or bids—are useful tools when you’re pitching a sale of products or services. Here’s how QuickBooks Online handles them.

Sales estimates are standard procedure in many professions. You wouldn’t authorize a car repair without one. Nor would you OK a remodeling job on your kitchen or a summer’s worth of yard landscaping without knowing what the costs will be upfront.

Estimates don’t have to be formal documents. You could scribble a proposal for products or services and their prices on a paper napkin and have your customer sign it. But as we’ve said before, the quality of your sales documents reflects on your company’s professionalism as well as its image.

QuickBooks Online offers specialized tools to manage this step in the selling process. You can create detailed estimates that the site can easily convert to invoices when you get an approval. And QuickBooks Online reports help you monitor the progress of your quotes. Here’s how it works.

A Dedicated Form

You probably already know how to create an invoice. If so, you shouldn’t have any trouble generating estimates because the forms are very similar. To get started, click the + (plus) sign in the upper right corner of the screen. In the Customers column, click Estimates. A form like this will open:

QuickBooks Online provides a form template for your estimates.

Open the drop-down list in the Customer field and select the correct one (or +Add new).

Note: If you click on +Add new, you’re only required to enter your prospective customer’s name to create an estimate; contact detail, of course, will not appear on the form. You can go back later and complete a customer record, but it’s best to at least enter a physical and email address. Click +Details to open the complete record, then save what you provide there.

The word “Pending” should appear below the Customer field. This refers to the status of your estimate. Click the down arrow to the right of it, then on the down arrow in the small window that opens to see what options you’ll have later. If you want to copy someone else on the estimate, click the small Cc/Bcc link to the right and provide the email address(es).

Enter (or select by clicking on the calendar graphic) the Estimate date. If your offer is only good for a limited period of time, enter an Expiration date; otherwise, leave that field blank. Then go down to the Product/Service grid and select the items for which you’re providing an estimate, one on each line. Fill in the Qty field and check the labeled box if the item is taxable.

If you had created a product record for it already, the other fields should be completed automatically. If not, click +Add new. The Product/Service information pane should slide out from the right side of the screen. Here again, you’re only required to enter a Name, but you should really create the whole record and save it to return to the estimate. If you’ve not been through this process before, we can walk you through it.

You can add a discount to the estimate as either a percentage or a dollar amount in the lower right corner of the screen. You can also edit the customer message that appears in the lower left and attach any files necessary. When you’re done, save the estimate.

Estimate Options

You can work with your estimate from the Sales Transactions screen.

If you’re not already there, click the Sales link in the left vertical toolbar, and then the All Sales tab and the Estimates bar. Find your estimate and look at the end of the row, in the Action column. If you want to convert your estimate to an invoice, click Create invoice. In the window that opens, indicate whether you want to invoice:

• A percentage of each line item,
• A custom amount for each line, or,
• The total of all lines.

Look over your invoice when it opens, complete any other fields necessary, and save it. Your estimate’s status has now been changed to Closed, and the new invoice created from it will appear on the Sales Transactions screen. It will also be included in the Estimates By Customer report.

If you can create an invoice, you can create an estimate. The tricky part comes in when you have to amend an estimate before you bill it – or even alter it and resubmit it. If you’re going to be working with estimates extensively, let us help you get it right from the start.

BookPro offers QuickBooks consulting as part of our package of accounting services for small businesses. Call us at 407-281-7375 or request your free consultation online now and find out how you can leverage QuickBooks to precisely track your finances.

Whether you sell products or services, you may need to create estimates in QuickBooks Online. Here’s how it’s done.

It would be nice if you could just instantly invoice every sale. But sometimes your customers need to know what a particular purchase will cost before they make the decision to buy. So you need to know how to create an estimate. If the sale goes through, you’ll of course want to send an invoice.

QuickBooks Online automates this entire process. It even helps you track the progress of your estimates by providing a special report. Here’s how it works.

Just Like An Invoice – Almost

The process of creating an estimate in QuickBooks Online is almost identical to creating an invoice. You click the New button in the upper left and select Estimate.

Creating an estimate in QuickBooks Online is like creating an invoice, with a few differences.

When the form opens, you’ll notice one difference right away. Directly below the Customer field, you’ll see the word Pending next to a small down arrow. Click it to see what your options are here. You’ll be able to update its status later. Select a Customer to get started. If this is a new customer, click + Add New and enter at least the name. If you want to build a more complete profile at this point, click Details and complete the fields in the window that opens. To send a carbon copy or blind copy of the estimate to someone else, click the Cc/Bcc link.

Next to the Estimate date, there’s a field for Expiration date. Enter that and continue on to add the products and/or services that will be included, just as you would on an invoice. If you’re generating an estimate for a new product or service, click + Add new in the drop-down list. A panel will slide out from the right that allows you to create one.

You’ll see more options for your estimate at the bottom of the page. You can add a message in the message box (or leave the default message if there is one). You can also Customize it, Make recurring, or Print or Preview it. When you’re satisfied, Save it, and send it to the customer.

You can preview your estimate to see what the customer will see before saving it.

Updating the Status

Your estimate will not be considered a transaction until you accept it. To do this, click the Sales link in the toolbar, then All Sales. Find your estimate in the list by looking in the Type column. Click the down arow next to Create invoice to see your other options there. You’ll see that you can Print or Send it or save a Copy.

Click Update status. In the window that opens, click the down arow next to Pending. From the list that drops down, select Accepted. You can also mark it Closed or Rejected. If you choose any of the last three options, another window opens that allows you to enter the name of the individual who authorized the action and the date it was done.

Click Create invoice if your estimate was accepted. You’ll have three options here. You can invoice your customer for:

• The estimate total.
• A percentage of each line item.
• A custom amount for each line.

When you locate your estimate on the Sales Transactions page, you’ll have several options for managing it.

After you’ve made your selection, click Create invoice to open the form with the amounts filled in based on your preference. Complete anything that’s unfinished but do not change any of the product or service line items. Save it, and your invoice is ready to go. You can always check the status of your estimates by running the Estimates by Customer report.

Creating and tracking estimates is as easy as working with invoices. You may run into difficulties, though, if you need to do anything beyond that point with estimates, such as modifying it and re-submitting them. We’re here to answer any questions you might have about this. It’s important that you get your estimates and their subsequent invoices exactly right, so you don’t lose money or sales. Let us know if you want to go over these concepts.

BookPro offers QuickBooks consulting as part of our package of accounting services for small businesses. Call us at 407-281-7375 or request your free consultation online now and find out how you can leverage QuickBooks to precisely track your finances.

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

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

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

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

How It Works

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

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

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

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

Automatic Synchronization

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

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

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

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

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

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

BookPro offers QuickBooks consulting as part of our package of accounting services for small businesses. Call us at 407-281-7375 or request your free consultation online now and find out how you can leverage QuickBooks to precisely track your finances.

The COVID-19 pandemic isn’t over, but many small businesses are on the upswing. How QuickBooks Online can help if yours isn’t.

Intuit recently did a survey documenting the financial losses that many small businesses had experienced since March 2020. Not surprisingly, the report, Intuit QuickBooks Small Business Recovery, found that COVID-19 has had a significant impact on the financial health of U.S. small businesses.

But many of the companies surveyed have proved to be resilient. As of March 31, 2021, 61 percent of them saw an annual revenue increase compared to pre-COVID days.

How would you have answered the survey? If indeed you did suffer financial and personnel losses because of the pandemic, has your business started to rebound yet? If not, there are actions you can take in QuickBooks Online to help in your recovery. Here are some of them.

Transactions: Watch your income and expenses like a hawk.

QuickBooks Online provides excellent transaction-tracking tools that help you document income and expenses.

How much time do you spend working with your downloaded transactions? If you take advantage of the excellent tools QuickBooks Online provides, you may notice patterns that you’ll want to explore and modify. For example, are you spending too much in one or more particular areas? When and where is your income dipping?

It’s critical that you connect to as many online financial institutions as possible, so you get a complete picture of your income and expenses. Once you have, click on Transactions in the toolbar, which should open to the Banking page. If you’re only going there to make sure there are no unrecognized entries, you’re missing out on some of QuickBooks Online’s transaction-tracking tools. In the image above, we’ve specified a vendor and chosen a Category and Tags. This will make your reports more meaningful and actionable.

If you don’t know what it means to Find Match, we can show you how that works. It’s a real time saver.

Sales: Make it easier for customers to pay you.

We’ve written about accepting online payments in this column before. It’s especially important if you’re struggling. You may actually be losing sales if you don’t let potential customers pay online through a credit card or bank account transfer. And existing customers may pay faster if they can do business with you in that way.

QuickBooks Payments makes this possible. There are some nominal fees involved, but the potential increase in your income should more than cover them. Let us know if you want us to help you set up a merchant account.

When you set up a merchant account through QuickBooks Payments, you may find that your customer base will grow, and existing customers will pay faster.

Expenses: Categorize expenses with tax time in mind.

You’ve probably already filed your 2020 income taxes, but we’re well into 2021, and it’s not too early to start thinking about your current tax situation. QuickBooks Online helps you track your income carefully, but it’s equally important to make sure you know what your tax-related expenses are. You want to get every deduction and credit you can. So when you’re looking at transactions, like we described above, make very certain that you’re assigning the correct categories to each of them.

We can help you run reports on a quarterly basis that should be of help when you make estimated tax payments. That way, you may be able to reduce your quarterly obligation during the 2021 tax year and won’t have to wait until you file in 2022 to see savings.

Time: Make sure your billable hours are billed.

Unless you have an organized, easy-to-use method for tracking billable time, some hours are likely to fall between the cracks. QuickBooks Online provides effective tools in this area. As you go through your downloaded transactions, you may see expenses that can be billed to a customer. Select the Customer/project and check the Billable box so you’ll be able to include it on their next invoice.

You can mark expenses as billable to customers in your Transactions register.

As you create time entries for you and/or your employees, you can also mark those hours as billable.

Reports: Run basic, critical reports regularly.

You can’t know how your business is doing financially unless you create reports. Besides the quarterly and standard financial reports we can run and analyze for you, you can—and should—be generating reports yourself through QuickBooks Online. Here are some of the ones we suggest:

• Budget vs. Actuals. If you’ve put the time and effort into creating a budget, it’s critical that you gauge your progress regularly and make adjustments as needed.
• Open Invoices. Who have you billed that hasn’t paid?
• Accounts Receivable Aging Detail. Who owes you, and how far behind are they?
• Sales by Product/Service Detail. What is selling well and what isn’t? You can make decisions about your product and service lines by viewing this report. This is especially important when your sales are sluggish.
• Business Snapshot. This is a series of charts and lists that provides a quick visual overview of key data.

QuickBooks Online can’t, of course, revive your business if the pandemic has created conditions that are out of your control. But that shouldn’t stop you from controlling what you can, no matter what your situation is. It was designed not only to automate and streamline your daily accounting work, but also to provide the information you need as you evaluate your present situation and plan for the future. Please call on us if you need help making optimal use of QuickBooks Online.

Sometimes, you have to spend money on your customers. Make sure you’re billing them for it.

Usually, money flows from your customers to your business. But there may be times when you have to purchase items for a job whose costs will eventually be reimbursed. Or you, or an employee, might spend time providing services for customers and get paid for those hours by your company before you receive payment from the responsible party. If you’re a sole proprietor with no payroll and no reserves, of course, you just have to wait to be paid for your work.

In the first two cases, you’re spending money upfront that will eventually be paid back. In all three cases, QuickBooks Online calls these billable expenses and billable time, and it does a good job of tracking these transactions – much better than if you were scribbling notes on a receipt or a paper timecard.

Obviously, you want to be paid for these expenditures as soon as possible to minimize their impact on your own cash flow. So QuickBooks Online “reminds” you that they need to be billed when you create an invoice for a customer. It also offers reports that help you track unbilled time and expenses. Here’s a look at how it works.

Tracking Billable Time

It’s easy to create a billable time activity. Click +New, then Single time activity. Fill in the blanks and select items from drop-down lists until you’ve completed a form. The critical section of this screen is pictured below:

 

In this example, the employee will receive $50/hour for the work done (Cost rate). Because the Service being provided will be billed back to the customer, you click in the box in front of Billable to create a checkmark. You’re charging the customer $65/hour (a $15/hour markup), so you enter that number in the Billable field. You don’t have to worry about remembering that. QuickBooks Online, as it does with all of your other company information, retains that and makes it available to you.

Tracking Expenses

You probably already know how to record expenses in QuickBooks Online. You can either click the +New button and then Expense, or you can click the Expenses link in the toolbar and the New transaction | Expense. Just as you did in recording time activities, you complete the fields and place a checkmark in the Billable column and select the Customer/Project from the drop-down list.

Once you’ve saved a billable expense, it will appear in the table on the Expense Transactions page. To display is again, click View/Edit at the end of the corresponding row. The transaction will open, and you’ll notice that there’s a small View link in the Billable column. Click it, and you’ll see this:

 

In this example, there’s been no markup applied to the transaction. If you want to add markup costs to all billable expenses, click the gear icon in the upper right and go to Account and settings | Expenses. Click the pencil icon to the far right of the Bills and expenses block of options. Click the box in front of Markup with a default rate of to create a checkmark and enter a percentage. All of your billable expenses will now include a markup of that percentage.

Invoicing Time and Expenses

The next time you invoice a customer who has outstanding time and expenses, QuickBooks Online will remind you that they’re pending. Open an invoice form and select a customer who you know has billables. The right vertical pane will contain a box containing information like this:

 

Click Open if you want to see the original expense record. Clicking Add will, of course, include that transaction on the invoice.

QuickBooks Online offers another way to see your pending billables. Click the Reports link in the toolbar and scroll down to the Who owes you section. You’ll see two related reports here: Unbilled charges and Unbilled time.

We want you to make sure that you’re getting reimbursed for all of the time and expenses you incur on behalf of your clients. So please let us know if you have further questions on this topic or if you have other QuickBooks Online issues.

SOCIAL MEDIA POSTS

Do you ever spend money on behalf of your customers? QuickBooks Online calls these billable expenses, and it can track them. Here’s how.

If you provide services for customers, you’ll have to invoice those hours as billable time. Did you know you can record this activity in QuickBooks Online? Here’s how.

Did you know when you invoice customers with outstanding time and expense charges, QuickBooks Online reminds you about them? Find out more here.

Confused about which customers owe you for billable time and expenses? QuickBooks Online provides specific reports for that. Find out more here.

BookPro offers QuickBooks consulting as part of our package of accounting services for small businesses. Call us at 407-281-7375 or request your free consultation online now and find out how you can leverage QuickBooks to precisely track your finances.

New year, new challenges, and the potential for new successes. Here are five ways you can improve your financial management in 2021.

A painful year is drawing to a close. We’ll still be dealing with COVID-19 and a struggling economy in early 2021, but there’s hope on the horizon. There’s a lot you can’t control about the difficulties facing our country, but you can take control of your corner of it, especially in terms of how you manage your finances.

If you’re already using QuickBooks Online, you know how it’s solved the paperwork confusion of the past. But are you taking advantage of all of its capabilities? As you turn your digital calendar to January, consider expanding your use of the website to set yourself up for success in the new year. Here are five features to explore if you haven’t already.

Practice Proactive Reconciliation

QuickBooks Online’s Banking screen display registers for the bank and credit card transactions that have been posted by your banks. Do you review these frequently? It’s easy, and it’s important. It will save time when you do your monthly reconciliations with your bank statements. Hover over Transactions in the toolbar and select Banking. You can see some of your transaction management options in the image below.

When your statement comes and you’re ready to reconcile, you can use QuickBooks Online’s tools that take you step by step through the process. Hover over Accounting in the toolbar and select Reconcile. Let us know if you need help with reconciliation or with managing downloaded transactions.

Start Accepting Online Payments

This is probably the #1 way to encourage customers to pay you faster. When you set up a merchant account through QuickBooks Payments, you’re be able to accept credit cards, debit cards, and ACH bank transfers. Your invoices will include a Pay Now button and will contain the information your customers need to pay electronically. Their funds will go into your bank account.

There are other ways they can pay you directly. You can take their card numbers over the phone. You can also get a free card reader from Intuit and swipe their cards on your mobile device. And you can set up recurring payments that will occur automatically. There are no base fees – you just pay per transaction.

Set Weekly and Monthly Report Schedules

You may just run reports in QuickBooks Online as you need them. Some reports, though, should be created every week at a minimum, like Accounts receivable aging (detail or summary), Accounts Payable Aging, Open invoices, and Unpaid Bills. There are many others, but you need to keep a close watch on what you owe and who owes you.

It’s important to run some other reports on a monthly (or, sometimes, quarterly) basis, including Balance Sheet, Profit and Loss, and Statement of Cash Flows. Rather than just providing snapshots of where you stand with money coming in and going out, they give you a more comprehensive view of your finances that can help you make better business decisions. They’re complex and often difficult to analyze, though, which is why QuickBooks Online categorizes them as For my accountant. We can create and interpret these for you.

Expand QuickBooks Online’s Features by Using Apps

QuickBooks Online is generic enough that it can be used by a wide variety of small businesses. But that flexibility may mean that it’s not quite robust enough in one area or another, like inventory management or time tracking. There are hundreds of apps that you can integrate with QuickBooks Online to fill in the gaps. Some are free. Click on Apps in the toolbar. Again, we’re available to help if you need assistance.

Evaluate the Cost-effectiveness of Your Vendors

It’s easy to stick with the same old suppliers because it’s a hassle to change. But so many companies are hurting because of the pandemic that you may find you can get what you need for less. To go over your whole list, hover over Expenses in the toolbar and click on Vendors. You might clean up your list while you’re at it. Click the down arrow at the end of each row and select Make inactive if you haven’t ordered from specific suppliers over the last year.

As we said earlier, we’re available to meet with you and explain any of the concepts discussed here in more depth. It’s still a hard time for so many small businesses, and we want to be of help wherever we can.

SOCIAL MEDIA POSTS

Don’t have a budget set for your business? QuickBooks Online has tools that can simplify the process of creating one.

When you’re creating a budget, it’s helpful to distinguish between essential and non-essential expenses. QuickBooks Online has tools that can help you, including budgeting for necessities first.

When was the last time you shopped for new suppliers? Now is a good time to see if you could save some money and help with your budget. QuickBooks Online has many tools that can help both you and your business budget.

Did you know QuickBooks Online allows you to use existing income and expense data to create a budget? Here is how this is done.

Get back to the job of running your business and leave the accounting to us! Call us at 407-281-7375 now and request a free consultation to find out how we can work together for your success.