Back to top

Blog

Invoices That Look Great

Posted by Lance Wilkins Posted on May 19 2017

This week we’re taking a break from QuickBooks Online. A number of you have expressed less interest in the online version than in the desktop version of QuickBooks. Accordingly, this blog post is about QuickBooks desktop.

We still want to finish our series on QuickBooks Online. It is good to have an overview of what online accounting programs will do for you. They are growing tremendously. So, as a compromise, we’ll alternate between both QBO and desktop for the next few weeks until out QBO series is complete.

 

Forms like invoices can be customized in QuickBooks to a much greater degree than many people realize. There are many options to creating forms that will make your business look unique in a world of standard QuickBooks forms.

The customization option we want to look at today is adding a logo to an invoice or other forms. A logo can be added to invoices, sales orders, credit memos, purchase orders, reminder statements, estimates, and sales orders.

In order to accomplish this, you need to have a digital copy of your company logo. This can be a digital photo, a scanned in copy, almost any copy of your logo that is saved on your computer.

When customizing forms in QuickBooks we are working with templates. There is a list of templates available at Lists->Templates. This list will show all the saved templates in your company file. You can edit some of them. Some, the defaults that come with QuickBooks, can be easily copied and then edited.

Another way to edit an existing template is to open it. Then, from the format tab of the ribbon, select Customize Data Layout.

https://secure.emochila.com/swserve/siteAssets/site12942/images/2_invoice_customize_icon.png

After either selecting a template from the list and choosing edit, or clicking the customize icon from the form itself, a screen opens with many options. Along the bottom of the screen are several buttons. One is labeled Basic Customization. Choose this button.

https://secure.emochila.com/swserve/siteAssets/site12942/images/2_customization_screen.png

You can see in the screenshot the checkbox that tells QuickBooks you want to use a logo. Once that is selected, click the Select Logo button to navigate to the location on your computer where the graphic file of the logo exists.

https://secure.emochila.com/swserve/siteAssets/site12942/images/2_logo_selected.png

Once the logo is selected, QuickBooks copies it into the folder where the company file resides. The name of the graphic file now shows next to the Use logo checkbox.

QuickBooks has also placed the logo on the invoice template. You can see that in the Preview panel where the arrow is pointing.

We may not be happy with the placement. To change that, we would click on the Layout Designer button.

In Layout Designer we can drag text and data boxes to the locations we desire. We can also change fonts, sizes, colors, etc. to control how the information on our form appears.

In the end, we can create something that looks more like this:

https://secure.emochila.com/swserve/siteAssets/site12942/images/2_final.png

How about you? Have you added a logo to your invoice template? Any tips for someone who hasn’t done this before?

 

Bank Transactions Made Easy With QBO

Posted by Lance Wilkins Posted on May 12 2017

One of the time-saving features in QuickBooks Online (QBO) is the ability to automatically download bank transactions. Those transactions can then be matched to existing ones in QBO, or entered as new.

 

https://secure.emochila.com/swserve/siteAssets/site12942/images/z_1_home_page.png

Note the arrow in the screenshot of the QBO company home page. One of the bits of handy information on this page is the bank balance.

The balance in QBO, resulting from the transactions we have entered manually, is $1201.00. According to the bank though, it is -3621.93.

We must have transactions to enter.

https://secure.emochila.com/swserve/siteAssets/site12942/images/z_2_banking_page.png

The above screenshot is the banking page. We navigated here by selecting Banking in the Transactions section of the menu located in the left-hand blue panel.

There are twenty-five bank transactions that need to be either matched or entered into QBO. We have already selected the “Recognized” link (see the arrow). Choosing this option filters the QBO bank account transaction list to those that are recognized as a match between our records and the bank.

We’ll select them all, then from the Batch actions dropdown list, choose Accept Selected.

This leaves us with nine transactions in the list. QBO has not found definite matches for these nine.

It did find a possible match for one, but it waits for us to make a decision and complete the transaction.

https://secure.emochila.com/swserve/siteAssets/site12942/images/z_3_possible_match.png

The circled transaction above is a possible match. It didn’t match automatically with the others.

If we click on the transaction, a window showing more detail opens. In that window we learn that there are two possible matches. QBO lets us verify which should be the accurate match, and this transaction can then be processed.

The others need to be added. Notice that they each have a link in the right-hand column to Add. QBO doesn’t really know what account to post to, so you can see that the account column for all of them is filled in with Uncategorized Expense.

That’s definitely not how we want these amounts to post. A profit and loss report with a large amount in uncategorized expense is not very helpful.

https://secure.emochila.com/swserve/siteAssets/site12942/images/z_4_add_trans.png

The above screenshot shows the first transaction after it has been selected by clicking on it with the mouse. Now, with this detail window open, QBO gives us the option to select the correct account.

The vendor is Books by Bessie. It is a deposit. We’ll assume this is a refund from the company bookkeeper.

We change the expense account to Bookkeeper, a subaccount of Legal & Professional. Now we can click Add.

When we do, the transaction is added to our check register, posting to the correct account.

We can repeat that process with the remaining amounts in just a couple of minutes. Our check register is updated and these transactions will already be marked as cleared when we reconcile the bank account.     

 

Navigating QuickBooks Online

Posted by Lance Wilkins Posted on Apr 25 2017

Sometimes, the best intentions…

It had been our goal to stay on schedule with the blog through all seasons. Including tax season. But the crush of the last few weeks made that impossible. The good news is we’re back!

We are in a series of posts about QuickBooks Online. If you’ve ever wondered about the advantages/disadvantages of using online accounting software, stay with us for a few weeks and we’ll give you a taste of what QuickBooks Online will and will not do for you.

This is the second in the series.

To use QuickBooks Online (QBO), it’s necessary to use an internet browser. Here are some tips you should know going in.    

First, it’s important to choose the right browser. Everyone is familiar with Microsoft’s Internet Explorer, it comes with Windows. We all have it on our computer.

Internet Explorer, however, is not recommended for use with QBO. The recommended browser is Google Chrome. Using Chrome will make life easier.

If you don’t have Google Chrome, a simple internet search on the name will provide you a link for the free download. It is simple to install. You are up and running in moments.

Internet browsers retain information as we visit various sites on the internet. This information conveniently remembers things like logins, data from our favorite sites to speed the loading of those pages, and so on.

This remembered data can sometimes be a problem for QBO. When the software just doesn’t act as it ought to, one recommendation will be to clear cookies and cache. On the other hand, continually clearing that data can make using the internet for other things less convenient.

An alternative is to use a separate user in Chrome, especially for use with QBO. From Settings, this can easily be done.

https://secure.emochila.com/swserve/siteAssets/site12942/images/2_Chrome_settings.png

Select the menu (arrow 1) and click on Settings (arrow 2). Arrow 3 is inserted to point out the location of the Chrome User’s name. You can see we have already created a special user just for QBO.

Remember, you are accessing Chrome settings, not QBO.

After you click on Settings from the dropdown menu, a tab with multiple sections opens. Navigate to the section labeled People. Click on the button that reads (Add person…). Create your new QBO user.

Another helpful tip. In QuickBooks Desktop, it is possible to have multiple windows open at one time. A common complaint from new QBO users is the lack of this functionality.

Actually, we can replicate this in QBO. The difference is that with online, this is a function of the browser rather than the accounting software.

As an example, we’ll open both the banking transactions list and a profit and loss report.

https://secure.emochila.com/swserve/siteAssets/site12942/images/2_menu_new_tab.png

In the above screenshot, we have navigated to the banking transaction list in QBO. There is also a menu open in the middle part of the screen. This resulted from a right-click of the Chrome tab on which we are working.

From the menu, we select Duplicate.  

The result is a new tab in our Chrome browser that is logged into the same site as the one above. We have the transaction list open in two tabs.

We’ll simply select one of the tabs and navigate to the new function we want in QBO, in this case, a report.

5

As you can see from the above graphic, we now have a profit and loss report open in our company file. At the same time, the tab with our banking transaction list, same company file, remains open.

If needed, we could create more duplicate windows, using various parts of the program. It’s a good idea to refresh the windows as you move between them.

 

 

Is QuickBooks Online Right for You?

Posted by Lance Wilkins Posted on Mar 20 2017

One of the great tech changes of the last few years has been the explosion of computer applications on the internet.   

In the past, our computer applications, including accounting programs like QuickBooks, have been installed on our local computer or a local network. That’s how we’ve been used to working. So why the move by so many to online computing?

QuickBooks desktop isn’t going away any time soon. As an older product with many years of added features built in, the desktop version of QuickBooks has features that the online version (QBO) only dreams of at this point.

On the other hand, online apps bring capabilities that have just never worked all that well in desktop software.

First, be aware. QBO isn’t QuickBooks desktop online. They are very different. The screens look very different.

This comes as a surprise to many who are used to the familiar QuickBooks Pro on their office computer. They decide to move to the online version and discover it bears little resemblance to what they are used to.

https://secure.emochila.com/swserve/siteAssets/site12942/images/QBO_main_screen.png

Freedom and Mobility

QuickBooks Online (QBO) offers great freedom and mobility. If you like the idea of jumping into your accounting program from office, home, or wherever you have an internet connection, you will love QBO.

Your QuickBooks company file actually exists on a huge computer server somewhere else and is only accessible over the internet. The advantage to this is the ability to access that company file from anywhere. Whether you are in your office or hundreds of miles away, as long as you have an internet connection, you have complete access to your QuickBooks.

Connectivity is another advantage. This could be a long, detailed article all its own, so we’ll just use bank transactions as an example. 

More and more of the world’s information is stored online. Online sites can ‘talk’ to one another. Speculation is that a few years hence, we may do a small fraction of the computer entry we do now. Online business programs may exchange and create transactions, a sale for one and an expense to another. The only human interaction at this level may be an approval process.

Even now, once QBO is linked to your bank account, all bank transactions upload to your company file overnight. Each night. You still have to accept the entries. There won’t be any surprises waiting for you, like you bank balance suddenly taking a big hit.

But the list of what cleared the bank last night is waiting for you each morning. You decide what should happen to each of those transactions.

We’ll look at that closer in a future section.

What about data safety? You will hear the concern from time to time that information stored online, or in the cloud, is vulnerable. The truth is that information is far less vulnerable than what is on your desktop computer.

Data centers like Intuit’s are staffed by IT professionals, backed up daily, and protected from outside threats. You would need full-time IT professionals in your company in order to approach the level of security of a reputable online service.

The last benefit we’ll mention here is mobility. This ability can be huge in certain industries. With a smart phone you can create invoices, accept payment, and create many other transactions. Your QuickBooks file is updated in real time.

https://secure.emochila.com/swserve/siteAssets/site12942/images/February_27__2017_at_0858AM.png

Any Disadvantages?

Yes, there are disadvantages to QBO. Mostly these fall into the category of features that exist in desktop, but not in the online version.

Trying to catalog them all could make for a tedious list. Mostly, these fall into two areas. If your business needs deep inventory capabilities, QBO probably isn’t there yet for you. If your business tracks jobs or projects, you will want to take a careful look before making the switch to online. While many of the tracking abilities are there, the reporting is weak.

One other thing to keep in mind is the cost. Whether it is more expensive or not depends on your specific situation. A single user will probably see QBO as more expensive. You need to decide if the additional features are worth it.

If you have several desktop users, and maintain a local network for accounting purposes, it’s possible you could find significant cost savings.

Which Online Solution?

There are other online accounting solutions. QBO is nearing the two million subscriber mark. It is the clear front runner in the online accounting world. 

 

Time is Money

Posted by Lance Wilkins Posted on Mar 06 2017

https://secure.emochila.com/swserve/siteAssets/site12942/images/time_is_money_highdefinition_picture_2.jpg

This is the ninth and final installment in a series of blog posts that specifically examine QuickBooks from an agriculture perspective. There is no “QuickBooks for Ag”. So how can we use some of the features in QuickBooks if we are in the ag business?

For this last post, we are going to look at adding a little more technology to features we’ve already demonstrated. Definitely one of the headaches of all the QuickBooks abilities we’ve looked at is the recording of time. Several steps are involved and several people. The communication between those people is critical and that is often the greatest obstacle in any organization.

So how can we make recording time for employees simpler?

A number of developer solutions exist that will record time and automatically import it into QuickBooks. One of the most popular and best known is an Idaho company named TSheets.

A detailed look at the service is far more than what we could cover here, so let’s just hit the high points and examine how this might help you.

With a TSheets subscription, I have a web site login where I, as the administrator, have access to all my company settings. Employees, customer:jobs, class, and more upload directly from QuickBooks. I don’t have to enter this data. 

https://secure.emochila.com/swserve/siteAssets/site12942/images/tsheets_main_page.png

Along the left side of the screenshot above are a number of tools that allow me to setup and mange employees, look at reports of time worked, etc.

There’s a popup window labeled My Time Card which lets me record my own time if necessary. Another window is labeled Who’s Working and would display all employees that were clocked in at that particular moment.

There are several ways the TSheet service can be used. Each employee can clock in and out for themselves as they go through each workday. Or I, as the administrator, can fill in my employee’s time after the fact, although this misses out on some of TSheets’ cool abilities.

https://secure.emochila.com/swserve/siteAssets/site12942/images/tsheets_weekly_timesheet.png

TSheets is mobile-friendly. Employees can clock in and out on their mobile device. Or, managers can be setup to be responsible for groups of employees. Anywhere there is a cell phone connection, the manager can clock his/her crew in and out as needed.

https://secure.emochila.com/swserve/siteAssets/site12942/images/December_08__2016_at_1153AM.png

The above screenshot was taken on an iPhone with the TSheets app.

There are approval steps that can be added to the process. The employee can enter time, or it can be entered by a manager. At the end of the pay period, the time is ‘submitted’ with the click of a button.

Depending on the setup you choose, it may be someone else’s responsibility to approve the time. Once your designated approval process is complete, the time will automatically populate the weekly timesheet in QuickBooks for that employee.

The next step is to simply go to the Payroll Center and issue paychecks.

TSheets, and similar services, have much more to offer than only the features described in today’s post. But this gives you an idea of what is available in the way of automating and simplifying time entry.   

If you would like more information about TSheets, you can contact us. You can also review the TSheets web site and/or sign up for a free trial subscription by clicking here.

 

Time as a Crop Expense

Posted by Lance Wilkins Posted on Feb 20 2017

https://secure.emochila.com/swserve/siteAssets/site12942/images/3841379603_932ce86c11_b.jpg

This is the eighth in a series of blog posts that will specifically examine QuickBooks from an agriculture perspective. There is no “QuickBooks for Ag”. So how can we use some of the features in QuickBooks if we are in the ag business?

Over the last few weeks we’ve looked at a couple of ways to track crop and/or field costs in very specific ways. We’ve also looked at how to set budgets so we can see how the actual results of a particular crop or field compare to our plan.

The one piece that remains is labor cost. If we are using QuickBooks to process our payroll, how do we make sure those costs flow to the right crop, field, location, or other designation?

The feature in QuickBooks built to make this possible is the weekly timesheet. There are two time keeping forms. There is a Time/Enter Single Activity option besides the weekly timesheet. This is just a different way of looking at the same information that can be entered on the weekly timesheet. Kind of like looking at a check form in QuickBooks or viewing the same check in the check register.

Generally, entering time in the weekly timesheet is much more efficient.

https://secure.emochila.com/swserve/siteAssets/site12942/images/weekly_timesheet.png

The form for entering time is pretty straightforward. Let’s examine some of the columns though.

The Customer/Job column allows specifying what crop or project the time should be allocated to. In the above screenshot, Gregg is working on a wheat crop for the 2018/2019 season. This will populate reports for this wheat crop with the expense of Gregg’s time once this payroll is completed.

The service item is from the list of items we created to track various costs we want to record in the process of growing this particular crop. Gregg worked on both irrigation and tractor work this particular week.

The payroll item for Gregg is Regular Pay. If overtime were involved, we could use the overtime pay item for a portion of his time. This designation allows this time to be pulled directly into the payroll part of QuickBooks without re-entering it. If all Gregg’s time is recorded on the timesheet, it’s all there when we open the payroll center to create the paycheck.

The WC Code is the workers’ comp code. We published a post on tracking workers’ comp in QuickBooks on December 12th.

You may not have the Class column. The Ag sample file has three locations and tracks them by using Class. If you don’t have the class feature turned on, you won’t see this column.

The column farthest to the right in the screenshot deserves a mention. You will probably always uncheck the indicator in that column. If the graphic were stretched a little farther to the right, you could see the column header is labeled Billable. This would be used if we wanted to invoice a customer for this time. The way we are recording time, no one is getting invoiced for Gregg’s work.

https://secure.emochila.com/swserve/siteAssets/site12942/images/paycheck.png

Above is the earnings portion of Gregg’s paycheck. All the hours entered into the timesheet flowed automatically to this point. There was no additional entry needed.

It would be possible to enter all the timesheet information here on the paycheck form, but it’s generally easier on the weekly timesheet, especially where multiple lines are needed to track service items, locations, crops, etc.

https://secure.emochila.com/swserve/siteAssets/site12942/images/crop_report.png

Above is a report showing the progress on the wheat crop which has not been harvested or sold yet. The amount on the Tractor Work line comes solely from paychecks that have been created for employees working this particular crop. 

 You can watch the video on using the weekly timesheet here.

 

Crop Budgets, A Creative Alternative

Posted by Lance Wilkins Posted on Feb 06 2017

https://secure.emochila.com/swserve/siteAssets/site12942/images/cotton-harvester-139654_1920.jpg

This is the seventh in a series of blog posts that will specifically examine QuickBooks from an agriculture perspective. There is no “QuickBooks for Ag”. So how can we use some of the features in QuickBooks if we are in the ag business?  

Remember the post from a couple of weeks ago about using the job/project features in QuickBooks to track crop costs? Today’s post is an offshoot from that. More specifically, if we track a crop or field as we would a project, what’s the easiest way to plan or set a budget for that crop/project?

It may sound unusual, but the easiest, most effective way to do this would be by using an estimate in QuickBooks. Stay with us a couple of minutes here as we work through this. See if this can’t work for you as well.

One of the steps in tracking crops/fields as projects was to use items rather than accounts when recording income and expense. The reason for that was that the job/project reports in QuickBooks work with items, not accounts.

Forms like estimates also need items to populate them rather than accounts. Let’s look at how we might create an estimate to budget for a planned crop year.

https://secure.emochila.com/swserve/siteAssets/site12942/images/estimate.png

Create the items that will reflect the major costs of a particular crop/project. This can be a subjective process to a degree. That is, the items may be different from one QuickBooks user to another depending on the costs that are important to each. One may combine herbicide and pesticide costs into one line. Someone else may want to see a line for each.

In the screenshot above, the cost has been entered for each. There are no revenue amounts for these since we will not receive income. These are costs only.

The markup column is usually left blank. But, in an experiment we’ve added a negative 100% to result in a zero for the revenue column. QuickBooks considers the total column to be total revenue.

This hasn’t been ‘field-tested’ yet, but it’s an intriguing idea. It works fine in a sample file. If you try this, let us know how it works for you. You’ll see the difference in the report screenshot below. 

https://secure.emochila.com/swserve/siteAssets/site12942/images/estimate_vs_actual_report.png

Above is the screenshot of the report from this simple example. The income (or revenue) for the crop shows on line three. There is no estimated number for this as it was not included on the estimate form. We only planned or budgeted for costs. We could easily have added the item for the sale of the crop as well.

You can see that all of the lines for cost items, except for the first line, include estimated revenue. That’s because QuickBooks assumes, if we enter no other amounts, the cost will also be the revenue.

In the past we’ve just ignored the revenue column for cost items. The main purpose of using the estimate was to be able to compare the estimated cost to the actual cost. If we didn’t make as much on the crop as we planned, what cost items were the culprits?

The first line though is where we added the -100% markup. It makes for a little cleaner report. Try that if you like and let us know how it works for you.

You can see a video of this topic here.

QuickBooks classes

We are partnering with the Visalia Chamber of Commerce to teach a QuickBooks class on February 22nd. You can find more info here.

We are also partnering with the Tulare Chamber of Commerce to teach a QuickBooks class on March 1st. You can find more info here. 

 

Crop Budgets

Posted by Lance Wilkins Posted on Jan 24 2017

https://secure.emochila.com/swserve/siteAssets/site12942/images/budget_header_238x160.jpg

 

This is the sixth in a series of blog posts that will specifically examine QuickBooks from an agriculture perspective. There is no “QuickBooks for Ag”. So how can we use some of the features in QuickBooks if we are in the ag business? 

Usually, there is some kind of budget for each particular crop. This may be as simple as a few figures memorized in your head. It may be a more detailed Excel worksheet. A third possibility is QuickBooks.

This week and next, we will examine the tools in QuickBooks that can help with budgets. There’s more than one. And there’s more than one budget. A budget, even if mental, can be for the entire operation. A budget could be for each location if there is more than one. A budget for each crop or animal purchase is a third option.

Let’s start with the highest level budget tool in QuickBooks.

On the Company drop down menu is a section labeled Planning & Budgeting. In this section, choose Set Up Budgets.

https://secure.emochila.com/swserve/siteAssets/site12942/images/budget_screen_1.png

The wizard for creating a budget in QuickBooks will walk you through a couple of steps, asking pertinent questions along the way. Above is the first step. What year is this budget for? Do we want a budget for Profit and Loss or Balance Sheet?

Profit and Loss is by far the usual choice and we’ll use that today.

https://secure.emochila.com/swserve/siteAssets/site12942/images/budget_screen_2.png

The second screen gives us several options, from high-level budgets to very specific.

The ‘No additional criteria’ option allows us to create one budget for the entire operation. The option ‘Customer:job’ will create a budget for one particular customer or project. Think back to last week’s post about setting up crops as customers and projects. The option in this budget setup window would allow a budget to be created for a specific crop or field.

The third option is only available if we are using the class feature in QuickBooks. The ag sample file has three locations and uses the class feature to breakdown the income and expense for each. Using the class option allows us to create a budget for each location.

For today’s example, that is the option we will choose.

https://secure.emochila.com/swserve/siteAssets/site12942/images/budget_screen_3.png

The final step is to tell QuickBooks if we want to create a budget by manually entering estimated income and expense, or base those numbers on the prior year. We will manually add the numbers for our budget.

https://secure.emochila.com/swserve/siteAssets/site12942/images/Budget_screen.png

Since we selected the budget by class option, we have a drop-down list in the set up budget window. The arrow in the screenshot points to that. We’ve chosen ranch #2 for the class.

At this point it’s a matter of entering the estimated income and expense into the appropriate fields. The income and expense accounts form the rows of the budget form, the months of the year, the columns.

There are two buttons in the lower left that provide tools if you are able to automate part of this process. You could automatically copy a single number across all months for a particular expense for example. Or increase it by a set percentage each month.

Once a budget is complete and saved, there are a couple of budget comparison reports at Reports->Budgets & Forecasts. 

https://secure.emochila.com/swserve/siteAssets/site12942/images/budget_report.png

Above is a Budget vs Actual report. Normally this report shows the account totals by month. We reduced the columns to just one for the total year in order to show more of the report results in the screenshot.

In my opinion, this budgeting tool works best on an overall company budget, or a location budget. It will certainly work for crops and fields as well. But it’s a little time consuming.

We have another idea for budgeting at the crop or field level. More on that next time.    

You can watch a video of this QuickBooks feature here.

 

An Innovative Way to Track Crop Costs in QuickBooks

Posted by Lance Wilkins Posted on Jan 06 2017

https://secure.emochila.com/swserve/siteAssets/site12942/images/header_claas_harvester.png

This is the fifth in a series of blog posts that will specifically examine QuickBooks from an agriculture perspective. There is no “QuickBooks for Ag”. So how can we use some of the features in QuickBooks if we are in the ag business?

Determining the profit and/or loss for individual projects is critical for businesses like contracting, architecture, engineering, and others. Agriculture bears some similarity to these other types of businesses. That is, the profitability of the enterprise depends on the financial performance of individual crops grown.

With that established, we can look at features in QuickBooks meant to aid in the management accounting of project-based businesses and see if they might have application in agriculture.

Basically, our desired outcome is the same. To isolate the income and expense for individual projects or crops in order to examine how profitable they actually are.

Let’s try this out in an agriculture setting.

Crops as Customer/Jobs

Some of these steps are going to sound strange. Just be patient, work through the entire solution, and you’ll see where all this takes us in the end.

Setup you crops and/or fields as customers. You don’t need much information, just a name. It may help if you use the Customer-Job hierarchy in QuickBooks.

https://secure.emochila.com/swserve/siteAssets/site12942/images/customer_center.png

In the above screenshot, the customers shown are Wheat and Corn. The indented entries 2018/19 and 2018 are jobs created under those customers. Over time, one can keep the original customers and just add jobs to designate each crop year. As those crop years come to a close, they can be made inactive to keep the length of the customer list as short as possible.

Items Not Accounts

Our next challenge is to think in terms of items rather than accounts. The simple reason is that job or project type reports in QuickBooks gather numerical information from items rather than accounts.

It’s a simple process. A few minutes setting up a few basic items and you’ll be up and running.

https://secure.emochila.com/swserve/siteAssets/site12942/images/item_list.png

Above is a simple item list setup for an agriculture sample QuickBooks company. Let’s examine the setup of an individual item.

https://secure.emochila.com/swserve/siteAssets/site12942/images/item_setup.png

  We’ve used ‘Service’ as the type of item in the upper left-hand field of the setup window. The name of the item only needs to be something recognizable to you the user. The description is completely up to your discretion.

The account is the most important setting. In this example, Water Expense is used. Normally QuickBooks expects income type of accounts to be used in items like this and you may get a message telling you that. It’s okay. We’re making QuickBooks features created for a purpose work for us in a different way.

Set up items like this for the different major expenses you would want to track as part of a review of the profitability of a certain crop and/or field. You can see a few more examples two graphics ago, in the item list.

Don’t sweat it too much at the initial setup phase. You can add items as you go along. As you use this method, undoubtedly you will make additional alterations as you gain experience and find the right mix of items for your liking.

One last item you will need is for the sale of the crop. The only difference with this item will be the account. The sale will create income and an income type of account should be used in the item setup.

Recording The Transactions

Now that we have customer:jobs(crops:years) and items, the next important step is using these them on transactions.

https://secure.emochila.com/swserve/siteAssets/site12942/images/check_with_item.png

There are two things somewhat unique about the check above. One, the Items tab is used rather than the Expense tab. This allows us to use the items created in the last step, like Water Purchased.

Second, we’ve used the Customer/Job column on the stub portion of the check. This column is only used for tracking jobs or projects. That’s the process we’re imitating. We are thinking of one crop or field as a project. Since we’ve already setup our crops and/or fields as customers, insert that name in this column.

Recording The Sale of The Crop

https://secure.emochila.com/swserve/siteAssets/site12942/images/sales_receipt.png

When the crop is sold, use a sales receipt to record the sale, using the item created for that purpose. This item was discussed a few paragraphs ago when we covered creation of items.

The Result

That’s the procedure for adding the income and expense to QuickBooks. The result is a report showing the financial performance of a particular project, or as we are using these features here, a particular crop or field.

https://secure.emochila.com/swserve/siteAssets/site12942/images/final_report.png

The above report is a Job Profitability Report. It can be accessed in QuickBooks by navigating to: Reports->Jobs,Time,& Mileage->Job Profitability Detail report.

You can watch a video of the above procedure here.

Which Crops/Fields/Locations Made Money?

Posted by Lance Wilkins Posted on Dec 19 2016

https://secure.emochila.com/swserve/siteAssets/site12942/images/3DC9F8D017_238x160.jpg

Using QuickBooks Class for locations, fields, and crops

This is the fourth in a series of blog posts that will specifically examine QuickBooks from an agriculture perspective. There is no “QuickBooks for Ag”. So how can we use some of the features in QuickBooks if we are in the ag business?

QuickBooks has a feature called Class. It provides another “bucket” besides accounts in which to collect transactions.

This is often used in an organization where the same or similar income and expenses need to be tracked for different departments, locations, funds, etc.

For instance, a non=profit organization might track donations as income, but also want to know if those donations are for general use, building fund, or other special purposes, class might be your solution.

A business might have more than one department for which income and expenses are tracked. Or, it could have more than one location and want to track the financial performance of each location.

Turn on the class feature in preferences.

https://secure.emochila.com/swserve/siteAssets/site12942/images/class_pref.png

Once the option is turned on, transaction forms contain an added column for this information.

https://secure.emochila.com/swserve/siteAssets/site12942/images/class_column.png

Classes can be added ‘on-the-fly’ by typing in the name in the class column and selecting Add when QuickBooks does not recognize the name. Or, you can navigate to Lists->Class List and enter your desired classes there.

Using class designations on your transactions results in a profit and loss report that can be analyzed based on whatever criteria you are tracking with the class feature.

https://secure.emochila.com/swserve/siteAssets/site12942/images/profit_loss_by_class.png

Keep the following in mind:

*  Use only one criteria. Using both location and department for classes will create a confusing report.

*  Create a general or administrative class for transactions that do not fit into any of the special class categories. That way, when unclassified transactions show up on the Profit and Loss by Class, you know they need to be corrected.

*  Class is for income and expense, not for assets and liabilities. While QuickBooks offers a balance sheet by class, it is cumbersome and difficult to use and requires stringent guidelines on entering transactions.

What about Agriculture?

This feature can be used in a couple of ways for ag QuickBooks users.

If there is more than one location, locations for which income and expense amounts can be determined, this would be a good use for class.

Here is an example of a profit and loss report for an agriculture-based sample company using this method.

https://secure.emochila.com/swserve/siteAssets/site12942/images/p&l_by_class.png

Another use for the Class feature is for field, crop, and/or year. For instance classes might be created for “Field 3 Corn 2018”. And then a new class “Field 3 Corn 2019” would be created the next year.

The reason for making the class names so specific is to prevent crop income or expense showing on a report and being allocated to the wrong crop year. An expense might be billed late by a supplier, or income is received late, after the new year has already been started.

There’s always that possibility, that if there is only one class for Field 3, some transaction for the year 2018 gets recorded in 2019, thus compromising the accuracy of the report for both years.

Using class in this way will work fine for some. It could create a very long class list over time. There’s another solution that you should consider.

More on that in the next post.

You can watch a video demonstration using Quickbooks Class here.

 

 

Quicker and Easier Workers’ Comp Reporting

Posted by Lance Wilkins Posted on Dec 12 2016

https://secure.emochila.com/swserve/siteAssets/site12942/images/3_header_graphic.png

This is the third in a series of blog posts that will specifically examine QuickBooks from an agriculture perspective. There is no “QuickBooks for Ag”. So how can we use some of the features in QuickBooks if we are in the ag business?

QuickBooks has a feature that will allow the cost of workers’ compensation to be tracked in the system. This will accrue the expense so it appears in the correct period on financial reports. It also results in the ability to run reports that will show wages subject to workers’ compensation, the rates and classifications, and the amount of premium due for a specific time period.

Tracking this expense as it accrues rather than when it is paid also allows it to be associated with various jobs and/or classes. 

The first step to tracking workers’ compensation costs is to set the preference.

https://secure.emochila.com/swserve/siteAssets/site12942/images/3_wc_pref.png

Once the preference is set, a wizard is available under the Employees dropdown menu to help you complete the setup. Employees->Workers’ Compensation->Manually Track Existing Workers’ Comp Policy.

The wizard will take you through a number of steps setting up the workers’ comp accrual. You will need information like:

  •  The name of your workers’ comp insurance carrier.

  •  Job classifications and rates.

  •  Experience modification factor.

  •  Policy Number (optional, but good to have).

You may assign each employee the appropriate workers’ comp code. Often, in agriculture, a worker may be subject to various workers’ comp codes depending on various required functions on the farm or ranch. It’s possible to leave employees unassigned.  Alternatively, if an employee can be classified under more than one code, but commonly fall under one specific designation, Make that most-common selection in this window.

You will need to enter your Experience Modification as this affects your premium.

https://secure.emochila.com/swserve/siteAssets/site12942/images/3_wc_code_list.png

Enter the rates for each workers’ comp code.

If you pay overtime wages, a screen will allow you to specify whether or not the overtime premium is included for insurance premium calculations.

Let’s say a worker earned $10 per hour for regular time and $15 per overtime hour. Excluding the overtime premium would cause QuickBooks to calculate the premium for every hour as though it were paid at $10. The additional $5 paid for overtime hours would be ignored.

Using multiple workers’ compensation categories for employees means that their hours worked must be broken down into those categories. That can be acconplised in two ways.

When creating payroll checks, the paycheck detail screen will need to be opened for each employee. Here, the workers’ compensation information can be entered.

https://secure.emochila.com/swserve/siteAssets/site12942/images/3_paycheck_detail.png

Some QuickBooks users will prefer entering time on the weekly timesheet from which it will automatically flow to payroll. There is a column for workers’ comp rates here as well.

https://secure.emochila.com/swserve/siteAssets/site12942/images/3_weekly_timesheet.png

The result of all this tracking work in QuickBooks is a report detailing the wages paid, under which categories, and the premium that will be owed.

https://secure.emochila.com/swserve/siteAssets/site12942/images/3_WC_report.png

A little more work up front saves a lot of time at the end.

Call us if you would like to try this feature but need help with the implementation. You may view this feature setup as a video here.

 

An Easy File and Repair Record QuickBooks Solution

Posted by Lance Wilkins Posted on Dec 05 2016

https://secure.emochila.com/swserve/siteAssets/site12942/images/blog_head_edited.png

 

This is the second in a series of blog posts that will specifically examine QuickBooks from an agriculture perspective. There is no “QuickBooks for Ag”. So how can we use some of the features in QuickBooks if we are in the ag business?

QuickBooks has the ability to keep electronic copies of documents and files of various sorts. It stores them with a link to transactions or list elements like customers or employees.

This is not a specific agriculture problem. But it can be useful both on a general business level, and as a specific solution for ag users. We’ll examine the feature first, then look at a unique ag application.

https://secure.emochila.com/swserve/siteAssets/site12942/images/2_customer_center.png

You may not have noticed before, but inside various windows in QuickBooks are found small paperclip icons and, in the case of one of the centers like the customer center, an entire column with the header “Attach”.

These are both indicators of the Attached Documents feature. The paper clip graphic in the ATTACH column of the customer list indicates that a document is attached to this customer.

The paper clip icon at the top of the screen opens the Attach Documents function.

A click on the paper clip next to the customer name, in this case MWI, opens a list of one or more documents linked to this customer. See the following graphic.  

https://secure.emochila.com/swserve/siteAssets/site12942/images/2_document_list_for_customer.png

From this window, the pdf document can be selected and opened.

The icons along the top of the Attachments window show the variety of ways QuickBooks will accept a document for attachment.

It could be scanned in from a paper copy.

If the document is already on the computer, the computer icon could be selected. The user would then navigate to the correct location and select the file to be attached.

Other documents like Word docs and Excel worksheets can also be attached.

The Doc Center can be opened with the third icon, or is available from Company->Documents. 

https://secure.emochila.com/swserve/siteAssets/site12942/images/2_doc_center.png

Four documents are shown in the Doc Center screenshot. It is easy just to drag the files from other locations and drop them here.

The arrows point to the indicators that signify the last doc of the list is attached. It is attached to the customer MWI as shown in an earlier screenshot.

The other three are not attached to anything.

It is possible to select documents anywhere on the computer or to scan them into the computer while a transaction or list is open. This action attaches them to the open transaction or list element.

It is also possible to drag them into the Doc Center and then find the place in QuickBooks where you want them attached.

Documents can be attached to transactions just as they can to name lists. Simply click on the paperclip icon.

https://secure.emochila.com/swserve/siteAssets/site12942/images/2_bill_with_paperclip_icon.png

There are limitations to the Attached Documents feature in QuickBooks.

When the QuickBooks company file is backed up, the documents are not. They have to be included in a separate backup.

Another shortcoming of the feature is security.

The documents are stored in a folder labeled ‘Attach’ in the location of the company file. There are no security precautions that prevent anyone from browsing through that folder and finding, deleting, or altering those individual documents.

So how about Ag? What special application does this have to the ag industry?

Documents can be attached to Fixed Asset Items. From the Fixed Asset Item list, highlight the item you want to attach to and click the Attach button at the bottom of the list window.

https://secure.emochila.com/swserve/siteAssets/site12942/images/2_fixed_item_attached_doc.png

If we click on the paperclip icon belonging to the JD 8330 tractor item, the attachment will open. The attachment is an Excel spreadsheet, created earlier and attached to this Fixed Asset item. On that spreadsheet is a record of repair and maintenance costs of this particular piece of equipment.

It is an Excel worksheet which many farmers use now to track these costs. The difference is it resides with QuickBooks. I access it from my list of equipment within QuickBooks. I don’t have to maintain a separate folder with Excel worksheets, carefully naming each one so I am sure to record the repair costs on the correct one.

It’s a small thing. But small things that ease workload and save even a little time add up. This is one worth considering.

You can view this in a video here. It’s the same video as last week, we combined both procedures into one video.

Next week: attacking those pesky workers comp rates for employees with multiple classifications.

Lance Wilkins, QuickBooks Advanced Certified ProAdvisor

M Green and Company LLP

 

 

Who Remembers When We Bought The…?

Posted by Lance Wilkins Posted on Nov 28 2016

https://secure.emochila.com/swserve/siteAssets/site12942/images/blog_head_edited.png

This is the first in a planned series of nine blog posts that will specifically examine QuickBooks from an agriculture perspective. There is no “QuickBooks for Ag”. So how can we use some of the features in QuickBooks if we are in the ag business?

The Fixed Item List is a relatively unknown feature in the product. Its intention is to provide a place for businesses to track large asset purchases like vehicles, equipment, and buildings.

It’s not a feature that has really caught on. That may be because it has not generated much excitement in the accountant community. When accountants aren’t encouraging their clients to use it, there’s little motivation to do the extra work.

Often though, a feature can be used in a related, but different way than it was originally intended.

One thing most farmers and ranchers have is lots of equipment. That equipment must be tracked, not just for income tax purposes, but county property tax purposes as well. We’re talking about the dreaded 571 property tax report that is mailed to you at the first of each year.

That report requires some very specific information. Year after year. How can we make that job easier?

https://secure.emochila.com/swserve/siteAssets/site12942/images/1_fixed_item_list_menu.png

Access the Fixed Asset Item List from the menu as shown above. When you select this option, a window similar to the following appears.

https://secure.emochila.com/swserve/siteAssets/site12942/images/2_fixed_item_list.png

The fixed item list in this sample company has many items on it. Yours may have none. New items can easily be added by clicking the Item button in the lower left part of the window.

The window that opens for the setup of a new Fixed Asset Item can be daunting. You’re staring at a screen full of blank spaces waiting to be filled. Don’t fear. You don’t need to fill all those empty fields. Let’s just track a few pieces of information that we find useful.

https://secure.emochila.com/swserve/siteAssets/site12942/images/3_fixed_asset_setup_window.png

Above is the setup window for one of the fixed asset items shown on the list. We could fill in information like a description, where and when we purchased the asset, and so forth. Most of those fields are optional, but they could prove handy for providing information to our accountant at year-end.

In this example, we’ve used an APN number, that is the number on our 571 property tax report, in the Location field. This can be useful if we have multiple locations where we keep equipment. The county will ask for a report on each.

Serial number might be a good piece of information to have, and keeping it in QuickBooks leaves us with one less list or file to keep. There is a lot of room for notes. Keeping repair notes here is one idea. It’s not optimal though as there is only one note field, it must be edited each time we want to add new information, there’s no pattern to the information we put in, and there doesn’t seem to be any way to access this field for reports.

We actually have some other ideas about tracking repair and maintenance data. We’ll look at that in the next blog post.

Watch the video here.

Welcome to Our Blog!

Posted by Admin Posted on Sept 30 2015
This is the home of our new blog. Check back often for updates!