The Mt. Washington Valley Economic Council
QuickBooks® Desktop Boot Camps
with Rhonda Rosand, CPA – Advanced Certified QuickBooks® ProAdvisor
Tuesday, October 2nd, 2018, 9 AM -11 AM
Whether you are starting from scratch or starting over, there is a right way and several wrong ways to set up a QuickBooks® file. Learn how to do it right the first time.
Avoid some of the common mistakes we see people make.
Accounts and Items
Users and Permissions
Tuesday, October 16th, 2018, 9 AM – 11 AM
Learn how to customize forms and templates and create QuickBooks® reports that are useful management tools for your business. Understand the difference between profits and cash.
Customize Forms and Templates
Cash Flow Management
Tuesday, October 23rd, 2018, 9 AM-NOON
This is a session designed exclusively for tax preparers, enrolled agents and accountants. We will cover advanced level topics to help you streamline the process and best practices for troubleshooting your client QuickBooks® file during this busy tax season.
What’s New in QuickBooks® 2019
In Product Demonstration of Features
Client Data Review and Accountant Toolbox
Common Issues and Troubleshooting
Courses are $35 each and held in the Community Room at Granite State College-Conway.
To register please call Susie at (603) 447-6622, email firstname.lastname@example.org, or register online.
A quick glance is all you need to check your fuel gauge, speed limit, engine temperature, and RPM when you’re driving down the road. Your car’s dashboard is designed to focus you on what’s important and what you need to know to have a safe trip.
Your car’s dashboard items, if they applied to business, would be called key performance indicators or KPIs. Unlike a car’s, the KPIs of your business vary depending on your business goals and what’s important to you. Common ones might include your cash balance, how fast you get paid, how much revenue is coming in, and whether you’re making plan. There are literally hundreds of them to choose from, and many of them are not derivable from your financial statements, such as number of orders, client satisfaction levels, and employee turnover.
Would it be useful to have a dashboard of KPIs for your business so you can know what’s working and get alerted to what needs focus? Here are the steps to creating a dashboard for your business:
- Decide on the KPIs you want to track. Selecting 6-10 to create and track is a good place to start.
- Select a tool that will provide you with the KPIs in the format you desire. There are many great add-ons to your accounting software that will instantly crunch the financial KPIs for you and present them in insightful formats, including charts, graphs, dashboards, and reports.
- Create any new processes to calculate the new KPIs and get them entered into the dashboard app.
- Hold a review meeting to go over the KPIs and determine any action based on the review.
There are many great KPIs available right in your accounting system, which might be plenty to get started with. And there are some real gems outside your accounting system that will take a bit of work to calculate. In any case, we can help you through this process. Feel free to reach out to us any time to discuss the possibilities of having a dashboard in your business.
If you have employees, you have the distinct honor once per year of being part of a worker’s compensation audit. You likely receive a form in the mail, an email request, or a phone call that will ask you about your payroll numbers and employees for the prior year.
Worker’s compensation is an insurance program that covers employees in the case they get hurt on the job. Each employee receives a classification code that describes the type of work they do, and a rate is figured based on the classification and its risk factors.
If you’ve hired anyone throughout the year, you might need to get a new classification by contacting your provider. If you have employees working in different locations (especially different states), that matters too.
The audit form will typically ask for gross payroll numbers by employee or by category or location of employee. That’s easy enough, but seldom does the policy run along your fiscal year, so the payroll figure needs to be prorated to match the policy period.
Your numbers need to tie back to the numbers reported on your quarterly payroll reports for both state and federal. The provider may also want copies of your 941s and your state payroll reports.
The auditor may also ask for subcontractor payments and certificates of expenses.
Once you’ve submitted your numbers, the insurance provider will calculate whether they owe you or you owe them additional fees.
You should do the math yourself to make sure their calculations are correct.
The worker’s compensation audit happens every year (even if you pay worker’s comp premiums each pay period, some companies still request an annual audit). It’s not difficult, but it is time-consuming. If this is something you’d like our help with, please feel free to reach out.
The products and services your business sells make it unique. The same thing is true of how these items are set up in your accounting software. Whether you’re using QuickBooks Online or something else, getting your products and services set up right can impact the quality of the information you can get out of your accounting system.
Here are the types of items you can set up in most systems.
Inventory items are used in retail and wholesale businesses. They are physical items that the system can keep count of for you. You can purchase or make the items, and the associated cost is usually tracked when a shipping receipt or bill is entered. They are sold when a sale is made and an invoice or sales receipt is entered.
Transactions using inventory items impact a lot of accounts on both the balance sheet (cash, accounts payable, accounts receivable, and inventory) as well as the income statement (cost of goods sold, sales, and returns). The inventory item can be tied to default sales and purchase accounts in most systems.
QuickBooks offers a type of item called a non-inventory item. There’s a big difference in that non-inventory items do not have quantities associated with them. They don’t increase or decrease the inventory account. But they are able to be tied to default sales and purchase accounts like inventory items above.
Examples of non-inventory items include items purchased for a specific jobs, such as a contractor purchasing appliances for a custom home, items you sell but do not buy, such as an ebook or other digital product, and items you purchase but do not sell, such as shopping bags.
A service item is a special type of non-inventory item. There are no quantities, which makes sense because services are not physical items. They also are only connected to a sales account and not a purchase account.
With service items, you could set up service packages or hourly rates.
A bundled item is a group of items that were designed to be sold together. For example, if you sell a gift basket of coffee products, you would bundle the items used to create the basket.
An assembly item is a special type of inventory item where the quantity is tracked, but it differs from an inventory item in that it can’t be sold separately because it is a component and not a whole item. Assembly items are available in larger accounting and inventory apps, such as QuickBooks Enterprise, and are used in conjunction with a Bill of Materials or other build feature.
An example is a set of shelves. The assembly components are the individual shelves and the frame pieces that you may want to keep counts of. An inventory item that contains the shelves, the frames, and other parts is “built” from the assembly items. The nuts and bolts could be non-inventory items or assembly items, depending on whether you wan to keep count of them or not.
Sales tax is a very special type of item used on an invoice or sales receipt to calculate sales tax due on the order. In many accounting systems, it’s usually kept in a separate list from the other product and service items. Rates can be entered for each sales tax jurisdiction.
Some systems have an “other” category to capture items such as freight, shipping, handling, and other add-ons to the sale.
Setting up the right type of products and services is critical to matching costs and revenue for accurate insights into gross margin. This section of your accounting system is also the one that’s most different from industry to industry and company to company. Be sure you get professional help from experts who know both the software and your industry for best results.
What the New Business Directions team is up to for the summer!
Rhonda – Rhonda is working away going through all her notes after attending Scaling New Heights, a premier unique educational experience for accounting professionals & small business advisors. For FUN, Rhonda is out hiking with Mr. Freckles the dog
Wayne – “I am working on my house and going to the lake or ocean as much as I can.” Wayne lives right here in the Mount Washington Valley and we often see him out and about around town!
Suzy – “I am out sailing, getting together with friends and family and enjoying the coast of Maine.” Suzy works remotely for New Business Directions and spends her summers on the coast of Maine and winters in Puerto Rico.
Britney – “I plan to work full-time and on my off time, I plan to do as much as possible with my family. Tom and I will do a lot of things with our four daughters. We plan to go to the beach a lot, amusement parks, hiking, camping, etc. We are hoping it will be a fun packed summer and we get lots of sun.”
Kendra – “I am working on enjoying every ounce of sunshine this summer has to offer with lots of trips to the beach and lake. I am spending most of my time swimming with my husband and my dog Olive as well!” Kendra lives in Freedom, NH and works in the Mount Washington Valley!
Trudi – “I am so enjoying the longer days and warmer temps!! Trying to work on many projects that have been put off over the long winter! Many of my Sunday afternoons are spent on Conway Lake with friends enjoying their boat and pot-luck cookouts! The best treat will be…. 10 days in Ogunquit … a family reunion and my daughters will be coming home!”
Kristen– Kristen is busy crushing the Art Scene in Portland, ME and traveling to different artist residencies in New England!