QuickBooks Online’s Mobile App: The Basics

Ida_BencomoLeave a comment

QuickBooks Online is more portable than you may realize.

In this work-from-home world, millions of people are finding it impossible to get away from the “office”. But there may be times when you’re not at home or work when it would be really convenient to have access to your accounting data in QuickBooks Online. 

The site’s free companion apps make that possible. Available for both Android and iOS, the QuickBooks Online mobile app can do many of the things that you’re used to doing on your desktop or laptop. And of course, everything you do on the app is synchronized with your browser-based version, and vice versa. Both versions look and work similarly and offer a user experience that makes your mobile tasks easy to accomplish. 

Here’s a look at what you can do.

The QuickBooks Online mobile app doesn’t look much like the browser-based version, but it can do many of the same tasks.

Navigation Tools

Once you’ve downloaded the QuickBooks Online mobile app and entered your login credentials from the browser-based version, you’ll see a screen full of shortcuts to the app’s main functions. This is an abbreviated list of what you can actually do, but it takes you to the screens you’ll want to see most often. Click the All tab, and a full set of links for the app opens that includes functions missing from the shortcuts page, like Reports and Products & services. 

Click on the home button in the lower left, and the app opens two more screens. One is a Dashboard that’s similar to the one you see in your browser. It displays charts for profit and loss, invoices, and expenses, as well as a list of your account balances. Click the Activity tab to see a list of the most recent activity. Like most everything on the app, the list is interactive. When you click on an activity, the transaction underlying it opens.

There are two more navigation links at the bottom of the screen. When you want to add a transaction, you can click on the + (plus) sign to open your options there. Click the three horizontal lines to open the Shortcuts page. The gear icon in the upper left takes you to the Settings screen, where you’ll find links to Company Information, Tax Rates, Overdue Invoice Alerts, etc.

Records and Transactions

Customer and vendor records are not as detailed as they are on the browser-based site, but they should serve you well for mobile activities. You can toggle between basic contact details and recent activity. There are also icons that allow you to quickly call, text, or email a contact. Product records are not as complete, however you can see each item’s name, description, sale price, tax status, and account and category assignments. You have the ability to edit records and create new ones on the apps.

You can view the data from your browser-based version of QuickBooks Online on the mobile app.

You can also add and edit transactions on the mobile apps, including invoices, estimates, sales receipts, expenses, and invoice payments. These are very thorough. They include the fields you need to bill customers and record purchases. You can even request signatures on estimates, add notes or attachments to invoices, and view a status bar for invoice progress.

Other Features

There are other tasks you can complete on the QuickBooks Online mobile apps. You can snap photos of receipts with your phone. The apps will then upload them to the main site and move some of their data on to the correct fields on forms. You can work with bank deposits, projects, and categories. And you can record mileage for business trips. If you turn on Auto-tracking, the apps will record your mileage as you drive.

There’s one more feature on the app that’s fairly new to QuickBooks Online – so new that it may not have been rolled out to you yet: Cash Flow. This is divided into two sections on the main site, Overview and Planner. The second deals with cash flow projections, which can be a complex concept to understand. We recommend you let us walk you through this tool so you know when it may be wise to take actions that will prevent an impending cash crunch.

Are you experiencing cash flow problems now because of the economic downturn? We can analyze your data and reports in QuickBooks Online and help you come up with a recovery plan, contact us to help you.

How Do You Create Price Levels in QuickBooks?

Digital TouchstoneLeave a comment

QuickBooks allows you to create Price Levels that you can assign to customers and jobs and to individual items.

You already know that when you create a product or service record in QuickBooks, you must assign a sale price to it. But did you know that QuickBooks gives you a great deal of flexibility when to comes to pricing items you sell? The software allows you to create one or more additional Price Levels that you can access in invoices, estimates, sales receipts, credit memos, and sales orders.

There are three ways you can use these. Once you’ve created them, they’ll be available in a drop-down list in the Rate field. This means you can assign them manually to individual transactions. The second option is to assign them globally to specific customers or jobs. Once you’ve done so, that price will apply every time you create a transaction for one of them. Finally, you can create price levels for selected items.

Here’s how it works. Let’s say you want to be able to create a price level that’s 15 percent below the actual price that you can use in individual transactions. You open the Lists menu and select Price Level List. Click the arrow in the lower left corner next to Price Level and select New. A window like this will open:

You can create price levels in QuickBooks and assign them to individual sales transactions.

Fill in the field next to Price Level Name, and then click the arrow next to Price Level Type. Select Fixed %. Select decrease from the drop-down list on the next line and enter your percentage number. Round up to the nearest is an optional field, Click OK when you’re done. The next time you create a sales transaction, your new price level will be available as an option when you open the drop-down list in the Rate column.

When you need to edit or delete a price level, go to Lists | Price Level List again and click the arrow next to Price Level in the lower left corner. You have several options here. You can, for example, make a price level inactive so it doesn’t appear on the list. The field next to Price Level is labeled Reports. Click on the arrow to see what’s available there.

Customers and Jobs

You can also apply a price level you’ve created to a specific customer or job, perhaps to reward a customer for frequent purchases. When you do so, that rate will appear every time you enter a sales transaction for the customer or job you selected.

Open the Customers menu and select Customer Center. Double click on a customer or job’s name to open the record. Click on the Payment Settings tab. Click the arrow in the field next to Price Level and select the right one, then click OK.

You can assign a Price Level to specific customers or jobs.

Per Item Price Levels

QuickBooks also allows you to set custom prices for specific items that are associated with preferred customers or jobs (this option is only available if you’re using QuickBooks Premier or Enterprise). Let’s say you want to give a 10 percent discount to specific customers who purchase your website development services. Go to Lists | Price Level List and click the arrow next to Price Level in the lower left corner again, then select New (you can also get to the New command by right-clicking anywhere in the window). 

Give your price level a name (like Web Development 10 Off), then select Per Item from the Price Level Type drop-down list. Click in front of the Item you want to include. The fields in the next line should read as pictured in the image below: 10% | lower | standard price. Click Adjust. You’ll see your reduced prices in the Custom Price column in the table above.

You can establish a Price Level for specific items in QuickBooks.

Again, the rounding field is optional. When you’re finished here, click OK. The next time you create a sales transaction for a customer who is eligible for the lower price, you’ll select Web Development 10 Off from the drop-down list in the Rate column.

Feel like you’re outgrowing your current version of QuickBooks, or is it several years old? Talk to us about upgrading. We’re here to support you and to help you more effectively use the software as your business changes and grows.

10 Tips for Better Budgeting…

Ida_BencomoLeave a comment

…and how QuickBooks Online can help you with the mechanics.

If you already have a budget, it’s probably been difficult for you to stick with it for the last several months. Unless you provide products and/or services that have been in great demand since the  COVID-19 pandemic took hold, you’ve had to adjust your budget significantly.

Better days are ahead, though, and now is a good time to start doing some planning for 2021. While there are still likely to be uncertainties next year, creating a budget will give you a starting point. A budget increases your awareness of all of your projected income and expenses, which may make it less likely that you’ll find yourself constantly running short on funds.

Here are some ways you can make your budgeting process more effective and realistic.

Use what you already know. Unless you’re starting a brand-new business, you already have the best resource possible: a record of your past income and expenses. Use this as the basis for your projections.

Be aware of your sales cycle. Even if you’re not a seasonal business, you’ve probably learned that some months or quarters are better than others. Budget conservatively for the slower months.

Distinguish between essential and non-essential expenses. Enter your budget items for the bills and other expenses that must be covered before you add optional categories. 

You can use data from a previous year to create a new budget in QuickBooks Online.

Keep it simple. Don’t budget down to the last paper clip. You risk budget burnout, and your reports will be unwieldy. 

Build in some backup funding. Just as you’re supposed to have an emergency fund in your personal life, try to create one for your business.

Make your employees part of the process. You shouldn’t be secretive about the expense element of your budget. Try to get input from staff in areas where they have knowledge.

Overestimate your expenses, a little. This can help prevent “borrowing” from one budget category to make up for a shortfall in another.

Consider using excess funds to pay down debt. Debt costs you money. The sooner you pay it off, the sooner you can use those payments for some non-essential items.

Look for areas where you can change vendors.  As you’re creating your budget think carefully about each supplier of products and services. Can you find less costly alternatives?

Revisit your budget frequently. You should evaluate your progress at least once a month. In fact, you could even start by budgeting for only a couple of months at a time. You’ll learn a lot about your spending and sales patterns that you can use for future periods.

How QuickBooks Online Can Help

QuickBooks Online offers built-in tools to help you create a budget. Click the gear icon in the upper right corner and select Budgeting under Tools. Click Add budget. At the top of the screen, give your budget a Name and select the Fiscal Year it should cover from the drop-down list by that field. Choose an Interval (monthly, quarterly, or yearly) and indicate whether you want to Pre-fill data from an existing year. 

QuickBooks Online supplies a budget template that already contains commonly used small business items.

The final field is labeled Subdivide by, which is optional. You can set up budgets that only include selected Customers or Classes, for example. Select the desired divider in that field, then choose who or what you want included in the next. Click Next or Create Budget in the lower right corner (depending on whether you used pre-filled data) to open your budget template. If you subdivided the budget, you’ll see a field marked View budget for. Click the down arrow and select from the options listed there.

To create your budget, you simply enter numbers in the small boxes supplied. Columns are divided by months or quarters, depending on what you specified, and rows are labeled with budget items (Advertising, Gross Receipts, Legal & Professional Fees, etc.). You simply enter numbers in the boxes that apply. When you click in a box, a small arrow appears pointing right. Click on this, and your number will automatically appear in the rest of that row’s boxes. When you’re done, click Save in the lower right. You can edit your budget at any time.

QuickBooks Online provides two related reports. Budget Overview displays all of the data in your budget(s). Budget vs. Actuals shows you how you’re adhering to your budget. 
We know creating a budget can be challenging, but it’s so important – especially right now.  We’d be happy to look at your company’s financial situation and see how QuickBooks’ budgeting tools—and its other accounting features—can help you get a better understanding of your finances.

Tracking Mileage in QuickBooks® Online

Digital TouchstoneLeave a comment

If you’re having to drive for work during the pandemic, let QuickBooks Online make sure you’re recording all of your deductible mileage.

Many states are starting to open for business again. If yours is one of them and this is affecting you, we hope you’re taking steps to stay healthy. We also hope that you’ve been keeping up with your changing finances by using QuickBooks Online.

As many will resume back to the day to day of business, if any part of your work involves driving business miles that can be deducted on your income taxes, you’ll want to know about a relatively new QuickBooks Online feature: mileage tracking. You can NOW record trips either manually or automatically, and the site will calculate your deductions. Here’s how it works.

Tracking Trips Manually

Before you get started, you’ll want to create a record for the vehicle you’ll be using. Click Mileage in the navigation toolbar. Hover over the green Add trip button in the middle right of the screen, then click View Vehicles. Then click Add vehicle and complete the fields on the screen that opens. Click Save. Back on the main screen, click directly on Add trip. The New trip panel will slide out from the right.

Enter the Date, then the number of miles driven (Distance). If you’d like, you can enter the Starting point and Ending point for your records. Click either the Business or Personal icon and enter a Description. Select the correct Vehicle if you use more than one and click Save. Your trip will now appear on the main screen with your tax deduction already calculated, as pictured below. Click the More button at the end of the row (not shown here), and you’ll be able to Edit your trips and Duplicate them.

Once you’ve created a record for a trip in QuickBooks Online, it will be added to the list on the main Mileage screen.

Auto-Track Your Miles

There’s another way to track your trips, one that doesn’t involve writing down your odometer readings or mileage. The QuickBooks Online mobile app will automatically track your miles as you drive.

To set this up, open the app and click on the three horizontal lines in the lower right to open the app’s navigation shortcuts. Then click the Mileage icon. Auto-tracking is off by default, so you’ll have to click OFF to open the Mileage settings screen. Click the Auto-tracking button to change it from grayed-out to green. In the small window that opens, click Settings to go to the QuickBooks section of your phone’s Settings screen and make these changes:

Location must be Always On.
Motion & Fitness must be On.
Background App Refresh must be On.
Cellular Data must be On.

Before you can automatically track your mileage in QuickBooks Online, you’ll need to change some settings (image above taken in iPhone; Android phones have similar settings).

Close this screen and return to the QuickBooks Online app’s main Mileage screen after you’ve changed your settings. Auto-tracking should be ON. Click the + (plus) sign in the lower right, then Create trip. The app will automatically detect your starting and stopping locations using your phone’s GPS. When you’ve arrived at your destination, open the Mileage app again.

Swipe left on the trip’s record to categorize it as business and right to mark it personal. Enter the trip’s purpose if it’s a business trip and click Save. You’ll now need to turn off Auto-tracking and reverse the changes you made in your phone’s Settings (unless, of course, you normally leave any of them on).

A Quick Tip

Do you ever find yourself opening QuickBooks Online in a new tab because you need to check something in another part of the site but don’t want to shut down your current screen? If you’re accessing QuickBooks Online through Google Chrome, it’s easy. Right-click anywhere in the navigation toolbar that contains links (not the blank space below) and select Open link in new tab. A new tab will open to a QuickBooks Online page. You can do whatever you need to do in the second tab without disturbing your original page.

Stay in Touch

The COVID-19 pandemic has had impact on both large and small businesses all around the world. We hope you’ve stayed physically and financially healthy during this exceptionally difficult time. Don’t hesitate to contact us if we can help with your use of QuickBooks Online and/or your overall accounting.

Setting Up Sales Tax in QuickBooks®, Part 2

Digital TouchstoneLeave a comment

Now that you have your sales taxes set up, you’ll be able to use them in transactions and reports.

Last month, we talked about the process of setting up sales taxes in QuickBooks. To recap a bit, you first have to go to Edit | Preferences | Sales Tax to make sure the software is set up correctly for this use. This means you’ll need to understand exactly what your state and local sales tax rules are. You can learn this by going to your state’s Department of Revenue or Department of Taxation website.

State sales taxes are considered Items in QuickBooks; you create them like you would create product records. When local sales taxes are also required, you can set up Sales Tax Groups. You’ll be assigning these Items as well as Tax Codes to customers.

Using Sales Taxes

Once you have sales taxes set up, you can start using them in transactions. You can create them on the fly from within transactions, but we recommend taking care of this important housekeeping task before you start.

Image1

QuickBooks applies the Sales Tax Item or Sales Tax Group that you assigned to the customer on your invoices. You can see the others that are available.

Start by creating an invoice. When you reach the Tax column for your first line item, you’ll see that QuickBooks has already assigned Tax or Non to it based on the information in the item’s record.  You can mix taxable and non-taxable items on the same invoice. You can also add a new sales tax on the fly from the invoice itself. Click the down arrow in the Tax column and select <Add New>. 

Be sure you’re not required to pay sales tax on an item when Non is selected. You may not have to charge sales tax on, for example:

  • Nonprofit organizations
  • Out-of state sales
  • Items that your customers will resell

Tip: If you’d like, you can create more specific sales tax codes for these situations. You could use OOS for out-of-state sales, for example, LBR for labor, and NPO for nonprofit organization.

QuickBooks already includes Sales Tax Codes Tax and Non, but you can add additional ones that are more descriptive.

Be very careful with your sales tax classifications in QuickBooks. As we said last month, such errors will be discovered in a sales tax audit, should you ever be subject to one. 

Once you’ve entered all the line items in the invoice, look down toward the bottom of the screen, directly beneath the table containing invoiced items and above the Total. QuickBooks will have calculated the sales tax due using the Sales Tax Item or Group you assigned to that customer during setup, placing it in the Tax field.

Look to the left of those numbers, and you’ll see the actual rate that was applied. To the left of that is a drop-down list containing the correct Sales Tax Item or Sales Tax Group. Click the down arrow if you want to see the list of other options. And in the lower left of the screen, you’ll see the Customer Tax Code.

The Sales Tax Center

Image3

The Manage Sales Tax window

When it’s time to pay sales taxes, you’ll open the Vendors menu and select Sales Tax | Manage Sales Tax. From the screen that opens, you’ll be able to:

  • Access Sales Tax Preferences.
  • Generate sales tax reports that will help you fill out required forms.
  • Visit related screens.

There are two reports you’ll need to run: Sales Tax Liability (displays total sales, amounts that are taxable and at what rates, taxes collected, and how much sales tax is due to each taxing agency) and the Sales Tax Revenue Summary (breaks down total sales into taxable and non-taxable). These reports are, of course, customizable, so you can filter them, for example, by Sales Tax Code.

A Delicate Balance

Collecting the correct amount of sales tax on taxable items and submitting the right tax totals to the right agencies takes vigilance. You don’t want to charge customers for unnecessary taxes, but you also don’t want to end up paying taxes you should have invoiced out of your own pocket. 

We can help you get this straight from the start. It’s much easier to spend some time setting up sales tax accurately in QuickBooks than it is to go back and untangle inaccurate records. Give us a call and we’ll set up a consultation.

Resolve to Do These 3 Things in QuickBooks® Online This Month

Digital TouchstoneLeave a comment

‘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 where 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.

Who Owes You? 5 QuickBooks Online Reports That Can Tell You Fast

Ida_BencomoLeave a comment

Keep a constant watch on your accounts receivable to improve cash flow.

Quick: How many of your invoices are unpaid? Have any of your customers gone over 30 days past due? Did you bill all of the time and expenses for that project you just completed for a customer?

If you’re doing your accounting manually, there’s simply no way to get that information quickly. Depending on your bookkeeping system, you may not be able to get it at all.

QuickBooks Online has more than one solution for this problem. You see the first one every time you log in. The Dashboard contains a graphic in the upper left corner that tells you how many invoices are overdue and unpaid. Click on the colored bar labeled OVERDUE, and you’ll see a list of invoices with the unpaid ones right at the top.

You can tell at a glance how much of your money is tied up in unpaid invoices.

While this is important information for you to have as you start your workday, it doesn’t tell the whole story. To get that, you’ll need to access some of QuickBooks Online’s reports – five of them in particular. Click Reports in the left vertical pane, and then scroll down to the heading labeled Who owes you.

These reports are listed in two columns. Each has the outline of a star next to it. Click on the star, and the report will be added to the Favorites list at the top of the page. Click on the three vertical dots next to it, and you’ll be able to Customize the report. And as you hover over the title, you’ll see a small, circled question mark. Click on this to get a brief description of the report.

There are several reports in this list that can provide insight into where your outstanding revenue is. We recommend you run five of them at least once a week – more frequently if your business sells large quantities of products and/or services. The suggested are:

Accounts receivable aging detail

This report provides a list of invoices that are overdue, along with aging information. There are several columns in the report, but you’ll want to pay special attention to the last one: OPEN BALANCE.

Tip: If you have many customers or simply a high volume of unpaid invoices, you might consider running the Accounts receivable aging summary instead.

Changing the Content

Before you run the report, you should explore the customization tools provided for it. They won’t be the same for every report, but you can start to get an idea of what can be done. Hover over the report title and click Customize. A panel like the one pictured below will slide out of the right side of the screen.

QuickBooks Online provides deep customization tools for reports.

You can see some of your customization options in the image above. Beyond these, you can also work with filters and headers/footers. When you’re satisfied with your changes, click Run report.

If you want to run a report with its default settings, just click on the report title in the list to display it.  You’ll have access to limited customization from there.

Four other reports you should be generating regularly are:

  • Customer Balance Summary: Shows you how much each customer owes your business
  • Open Invoices: Lists invoices for which there has been no payment
  • Unbilled Charges: Just what it sounds like: tells you who hasn’t been invoiced yet for billable charges
  • Unbilled Time: Lists all billable time not yet invoiced

We don’t expect you’ll have any trouble understanding reports like these; they’re fairly self-explanatory. QuickBooks Online offers many other reports, the standard financial reports that need to be generated monthly or quarterly, like Balance Sheet, Profit and Loss, and Statement of Cash Flows. You’ll absolutely need these should you apply for a loan or need to supply in-depth financials for any other reason. We can help you analyze them to get a comprehensive, detailed picture of your company’s fiscal health.

Do You Need to Bundle Products in QuickBooks®? Create Assemblies

Ida_BencomoLeave a comment

If you frequently sell multiple inventory items grouped together, you need to learn about QuickBooks’ assemblies.

Let’s say you run a home improvement retail outlet, and one of the things you sell is doors. You might sell their parts—door frames, hinges, doorknobs, etc.—individually, in case a customer needs to replace a piece. You may also want to sell all of the individual components as a kit and give your buyer a price break for purchasing them all together.

QuickBooks calls these assemblies; sometimes they’re referred to as kits. Just as you’d create an individual inventory part, you can group related parts together and create an item that you would sell as a package.

A couple of caveats here. You can only build assemblies in QuickBooks Premier and above. If you need this feature and are using QuickBooks Pro, talk to us about upgrading. Second, we know that not all of you are using the latest versions of the software. We’ll use QuickBooks Premier 2018 in the examples here.

Under the Hood

Before you can start working with assemblies, check your QuickBooks settings to make sure they’re correct. Open the Edit menu and select Preferences, then Items & Inventory | Company Preferences. Click in the box in front of Inventory and purchase orders are active in it’s not already checked. If you want QuickBooks to deduct the quantity of items that have already been entered on sales orders, check that box (we recommend this, so you’re not selling items that have already been promised). Then make sure the button in front of When the quantity I want to sell exceeds Quantity Available is filled in, for the same reason.

Before you start building assemblies, you’ll need to make sure your Company Preferences are marked accordingly.

Creating an Assembly Item

Open the Lists menu and select Item List. Open the drop-down list under Item in the lower left corner and click New. In the window that opens, click the down arrow under Type and select Inventory Assembly. Enter an Item Name/Number in the corresponding field in the window that opens. Don’t check the Subitem of or the I purchase this assembly item from a vendor boxes, and ignore Unit Of Measure.

Again, depending on the version of QuickBooks you’re using, you may see different fields in the Inventory Information box at the bottom of this window. But there are some standard elements you should find in this window no matter the version. They include:

  • Cost. How much does it cost you to purchase all of the parts for one assembly?
  • Sales Price. What will you charge your customers per kit?
  • COGS Account. “COGS” stands for Cost of Goods Sold. What account in the Chart of Accounts will you use to track the cost of producing your assemblies? Usually, the default one in QuickBooks is fine.
  • Income Account. Which account tracks your sales of this assembly?
  • Bill of Materials (BOM). This appears as a table in QuickBooks; it’s a list of all the individual inventory parts that make up the kit, along with their Cost (to you), QTY (quantity required for each assembly), and the total BOM Cost.

Your Bill of Materials Cost is the total of all inventory items required to create an assembly.

The Inventory Information box at the bottom of this window might contain fields for information like the Asset Account, quantity On Hand, and the number of items on purchase orders and sales orders. Once your inventory assembly is saved, it will appear in your Item List.

When you need to actually create kits, you’ll open the Vendors menu and select Inventory Activities, then Build Assemblies. You’ll select the Assembly Item from the drop-down list in the upper left corner, which will open a list of the components needed and their quantity on hand. You’d enter the number of kits you want (the maximum possible appears below the table) and then click one of the Build buttons. The next time you look at the kit in your Item List, you’ll see that its quantity has increased.

The concept of assemblies is easy to understand, but if you haven’t worked with accounts and inventory much, you may find creating kits in QuickBooks to be a bit of a challenge. Inventory levels can be a real problem if they get out of whack, and accounts must be assigned correctly to avoid inaccuracies in reports and taxes. We’d be happy to work with you as you get started with this task.

How to Use Progress Invoicing in QuickBooks® Online

Ida_BencomoLeave a comment

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 in 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 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’re paid in full.

Could Your Sales Invoices Be Better? How QuickBooks Online Can Help.

Ida_BencomoLeave a comment

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.

Editing Fields

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 the 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 PDF 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.