How Do You Manage Downloaded Transactions in QuickBooks© Online?

Digital TouchstoneLeave a comment

Downloading them is the easy part. QuickBooks Online lets you work with downloaded transactions in numerous ways.

QuickBooks Online was built to import transactions from your online financial institutions. You can enter them manually but downloading them saves an enormous amount of time and minimizes errors. It also makes reconciliation much easier, since you can see which transactions have cleared without calling the bank or waiting for a printed statement.

Once they’re in QuickBooks Online, your transactions are stored in a list, waiting for you to further define and categorize each one. Let’s look at how you can work with them to make sure your records are as thorough as possible.

Getting Connected

As long as you have online access to your bank and credit card accounts, you can set up QuickBooks Online to import cleared transactions. Click the Transactions tab in the toolbar, then click Banking. On the next screen, click Connect account. You’ll see links to popular financial institutions on the next page. If yours isn’t listed, enter its name in the search box at the top of the screen. Follow the onscreen instructions to make your initial connection and start downloading transactions. 

When you’ve completed the connection, you can click Link account in the upper right to add more.

Dealing With Transactions

After you set up a connection to a bank or credit card account, its account information will appear in a box on the Banking page.

Once you’ve finished adding accounts, you’ll still be on the Banking page. Each of your connected accounts will appear in a box that includes the balance and the number of transactions that need to be reviewed. There will probably be quite a few, dozens or hundreds, the first time you download, since most financial institutions send you 90 days’ worth the first time. Every time your accounts are updated after that, you’ll only get new ones that have cleared since your last connection.

Tip: QuickBooks Online generally updates once every day. If you want to see your new cleared transactions at any time, click Update in the upper right corner.

Click on any of the account boxes, and its list of downloaded transactions will appear below. Make sure that For review is highlighted. You’ll notice that each row has one of two icons at the far right. Review means that QuickBooks Online has not assigned a category to the transaction. Confirm means it has, and it wants you to either approve it or change it. Check these carefully. Sometimes QuickBooks Online gets it right, but not always.

Click on a transaction in the register to open its action box. Here’s a partial view:

QuickBooks Online allows you to add a great deal of information about each individual transaction in the register.

Categorize is checked by default, since this is the most common action you’ll take in the list. Click Find match if, for example, you received a payment on an outstanding invoice, or Record as transfer. We can help you work with the latter two options.

Select a Vendor/Customer and a Category (if QuickBooks Online hasn’t assigned one or it’s not the best one for that transaction). Click in the Billable box if you want to bill this transaction to a Customer/project. You can also Split transaction if you need to divide it between multiple categories and/or billing statuses. 

There are several other options below the section pictured above that allow you to:

  • Add Tags.
  • Attach a file.
  • Create a Rule for how similar transactions should be recorded.
  • Exclude the transaction if you have, for example, a duplicate one or a personal expense.

Before you take either of the latter two actions, talk to us. We don’t want you to do anything that might adversely affect your bookkeeping.

When you’ve finished, click Confirm. The transaction will move from the For review list to the Categorized one. It will now appear in the register for that account.

Once you’ve confirmed a transaction, it moves into the Categorized list.

As you might imagine, it’s a good idea to keep up with your downloaded transactions so you have time to give each the attention it needs. We recommend you review them daily. Your transactions, of course, flow into your reports and taxes, so you want to be sure you’re categorizing them correctly. Let us know if you’d like help with this.

How to Use Tags in QuickBooks Online

Digital TouchstoneLeave a comment

Where is your money coming from? Where is it going? You can use tags in QuickBooks Online to find out.

QuickBooks Online offers numerous ways to help you track your sales, expenses, and profitability. If you’re using QuickBooks Online Plus or Advanced, you can create and assign Classes to transactions to differentiate between, for example, store departments or product lines. Some of the site’s reports are designed specifically for these tools, like Sales by Class and Profit and Loss by Class. 

You can assign Categories to products and services to gain insight into your sales and inventory. There’s a different set of Categories that you’ll use when you record bills and expenses. These are important for reporting and tax purposes. You can also add a Location field to sales transactions so you can track sales by stores, sales regions, or counties, for example.

What Are Tags?

Then there are Tags, which are fairly new to QuickBooks Online. These are customizable labels that you can assign to transactions (invoices, expenses, and bills). They’re more flexible than the tools we’ve already mentioned – they allow you to track your money any way you want. They don’t affect your books, and they’re not included in the customization criteria for reports. But there are two reports specifically designed for them: Profit and Loss by Tag Group and Transaction List by Tag Group.

Creating Your Own Tags

Once you’ve given your group a name, you can start adding tags to it.

Before you create a tag, you need to create a Group. Groups consist of related tags that share a common theme. For example, say you do some event planning. You might have a group titled Events. Individual events might read, for example, Grayson Wedding, Spring Art Show, and Hillman Conference.

To get started, click the gear icon in the upper right. Under Lists, click Tags to get to the tool’s home page. (You can also click on the Transactions link in the toolbar, then click the Tags tab.) Click New, then Tag group. A vertical panel slides out from the right. Enter a name in the Group name field. Click the down arrow to select a color, then click Save. 

Enter your tags one by one in the fields labeled Tag name. Click Add after each one until your list is complete. Click the Edit button to make any changes. When you’re finished, click Done. The main Tags page will open again, and you’ll see your new group under Tags and Tag Groups. Repeat to add as many as you’d like, up to 300 tags.

Using Tags

You can add tags to any transaction that contains a field for them

.

Let’s look at how you’d use tags in an expense. Click the Expenses link in the toolbar, then New transaction | Expense in the upper right. Click the down arrow in the Payee field in the upper left and select + Add new. Enter Billy’s Bridal in the Name field Leave the Type as Vendor and click Save. Back on the Expense screen, select the Payment account, Payment date, and Payment method for the expense (reference number is optional).

Directly below those fields, you’ll see the Tags field. Click Manage tags if you need to add or edit one; the right vertical pane you saw before will slide out. Otherwise, click in the field below Tags. Your list of tags will drop down. Select Grayson Wedding to move it into the field. You can assign as many tags as you’d like to transactions, but you can only select one tag from each group. Finish the expense and save it. 

Go back to the Tags home page, and you’ll see that there’s a link to one transaction in the Events row. At the end of each row is the Action column, where you can run a report, add a tag, and enter or delete a group. Your expense total appears in the Money Out (by tag) box above it. 

Tags are a great addition to the tools QuickBooks Online provides to help you track incoming and outgoing funds. If you’re not familiar with the others we mentioned at the beginning of this column and want to learn how to explore them, let us know. We’d be happy to walk you through their use and help you understand how they can make your finances more understandable.

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.