Back to top

Blog

How to Setup a Wage Garnishment Order

Posted by Lance Wilkins Posted on Sept 13 2017

Those who do payroll in QuickBooks will find it necessary from time to time to create a payroll item. One of the most common is when a wage garnishment order for an employee is received.

When that happens, here is how to accomplish the task.

Navigate to Lists->Payroll Item list in order to display the list of payroll items. Either select the Payroll Item button in the lower left, or right-click your mouse anywhere within the actual list itself.

From the resulting menu, pick New.

In this post, we will use the Custom Setup method. It allows us more flexibility setting up the item.

You can see the many types of payroll items that can be selected in the graphic above. While the examples for the type selected suggest union dues, retirement plans, etc., a wage garnishment is definitely a deduction. So, we will choose Deduction as the payroll item type.

The next window in the wizard wants a name for the item. If you create a wage garnishment item for each wage garnishment order received, you will be able to create the checks to disburse the withheld amounts more easily. That’s what has been done in this example. Gregg Schneider is the employee whose wages will be garnished.

This screen allows you to specify the agency for payment of the withheld funds. It also contains a field for the number that identifies your employee to the agency. This is why we created the payroll item for only one specific garnishment order. Otherwise, this information could not be filled in here.

There is also a field for the liability account QuickBooks will use when creating paychecks and withholding the specified amounts. By default, QuickBooks will suggest Payroll Liabilities. Using an account like Wage Garnishments Payable allows much better tracking of the amounts coming in and going out of the account.

The Tax Tracking Type window is critical. The selection made from the dropdown menu shown, will determine the taxability of wages, how those wages are reported on government forms, and how they affect W2’s.

There’s quite a list of available options and if setting up something other than a simple wage garnishment, you’re likely to find on the list exactly what you are looking for. For our purposes, a wage garnishment does not affect taxes. None is the correct choice.

The next window (not shown) will allow very specific setup of the effects the new payroll item will have on tax withholdings. Generally, if you feel something in that window needs to be changed, you should seek professional payroll advice from your accountant or bookkeeper. Rarely would anything in that window need to be altered.

If the payroll item were to be based on quantity, like mileage, we could specify that in this window.

A wage garnishment will be deducted from net pay.

The last window in the setup process allows us to set a default rate. This can be either a dollar amount of a percentage. In the example, we have specified 25% of the employee’s net check.

If there were an annual limit, that could be set in this window as well.

In next week’s post, we’ll detail how to set this up with an employee to automate payroll processing.

 

A Simple Way to Write Off Uncollectible Invoices

Posted by Lance Wilkins Posted on Sept 08 2017

From time to time, it becomes necessary to write off a customer balance that has become uncollectable.  Let’s look at how to record this transaction in QuickBooks.

Step 1 - Add a new Item for Bad Debts

     ► Open the item list, click the Item button in the lower left corner, and select New.

     ► Select 'Other Charge' as the item type.

     ► Name the item "Bad Debt".

     ► Do not enter a default amount

     ► Make the item taxable and in the Account field, select the expense account for Bad Debt Expense. If you don’t already have an expense account for this purpose, you can create one without leaving item setup.

 

Step 2 - Issue a Credit Memo

     ► Choose the Refunds and Credits icon from the Home Page or select Create Credit Memos/Refunds from the Customer drop-down menu

     ► Enter the customer, a current date, etc. in the header of the credit memo.

     ► Use the bad debt item just created as the line item in the credit memo.  Enter the amount to be written off exclusive of any sales tax amounts.

     ► Enter the appropriate Sales Tax Code. Use a non-taxable code if there is no sales tax to be written off.

     ► If applicable, select the appropriate Sales Tax Item from the drop down list at the bottom of the Credit Memo form

     ► Click Save and Close.

Step 3 - Apply the Credit Memo

Choose the selection to Apply to an invoice when this popup appears.

Be sure the correct invoice, if there is more than one, is selected in this window, and click Done.

That’s it. This method allows the recovery of any sales tax that may have been paid on the customer’s original invoice. As long as you use a current date for the credit memo, it preserves the account balances from previous periods. Your accountant will thank you for that.

Anyone using this method already?

Getting Paid Faster

Posted by Lance Wilkins Posted on Aug 18 2017

QuickBooks’ Finance Charge Feature

 

Statements and finance charges can help small businesses receive more timely payments from their customers.

There is a little setup in order to use finance charges in QuickBooks. Let’s look at that first.

Navigate to Preferences->Finance Charges->Company Preferences.

The first field asks for an annual percentage rate the finance charge computation should use. Keep in mind this is an annual rate. In the sample company, QuickBooks will compute what the annual amount should be, then divide to only charge for the appropriate period, usually one month.

What is the minimum amount QuickBooks should charge. This field should really be filled in. Otherwise, the amount could be very small, making it less than the cost of charging the fee.

A grace period is often a good idea. Where this is most useful is preventing a customer payment and a statement with a finance charge from crossing in the mail.    

As an example, say the customer has terms allowing thirty days before payment is due. They pay on the thirtieth day. At the same time, finance charges are computed and statements sent by the business. The customer will receive notification they are late and have been charged a finance charge even though they paid on time. 

Finance Charge Account allows the selection from the chart of accounts. Finance Charge income will post to this account. A best practice is to use an Other Income type of account.

Most QuickBooks users will charge from the due date as shown.

Rarely does anyone want to print an invoice for each finance charge created. Most companies will leave the final checkbox unchecked.

To calculate the finance charges, either the menu option on the Customer menu or the icon on the Home Page can be selected. The following window shows the Assess Finance Charges window from the sample company Rock Castle Construction.

Only one customer has overdue invoices as of 12/31/2018 (the date in the sample file).

The overdue balance is $3500.  If we looked up the details of this balance, we would find an invoice that was due on 11/14/18. The amount is overdue by several weeks.

Ten percent (the amount of our annual rate) of $3500 is $350. At December 31 the invoice is forty-seven days late. The result of that calculation is a finance charge of $45.07.

Different states may have regulations controlling the amount that can be charged customers for late payments and when those can be assessed. Be sure when you set your preferences you are in compliance with these regulations in your state.

Do you charge your customers finance charges? Does it help you get paid faster?

 

The Customer’s Check Bounced, Now What?

Posted by Lance Wilkins Posted on Aug 07 2017

There is a feature, introduced in QuickBooks 2014, that will make the entries for a customer’s bounced check in QuickBooks. It uses the method we have suggested to QuickBooks users in the past, but those entries had to be created manually. Now, the software does it automatically.

Above is a screenshot showing a typical payment transaction in QuickBooks and highlighting the icon on the transaction ribbon that will activate the Bounced Check feature. Note the manner in which the payment is currently allocated.  

Above is the window that opens once the Bounced Check icon is selected. Note that all the fields in this popup window are editable. You are able to choose the amount the bank has charged you for the bounced check. You are also able to set the transaction date, the expense account charged for the bank fee, class (if you use the class feature), and the fee you wish to charge your customer.

Once the information is filled in correctly, you may select the Next button at the bottom of the window.

This is an informational window, explaining what entries QuickBooks will make.

Note that in section 1, QuickBooks is explaining that the two original invoices paid by this payment, are now marked as open, or unpaid. Section 2 explains that the amount of the bad check, $7,633.28 and the service amount charged by the bank, $25.00, have both been deducted from the QuickBooks bank balance.

Section 3 informs you that a new invoice will be created for the customer, charging them and adding to their balance, the amount you, the QuickBooks user, chose to charge your customer for the returned check. We chose $35.00. 

The customer name in the graphic is “Remodel Bathroom” which can seem a little confusing. This sample file is for a contractor who tracks income and expense by job. The payment was for a particular job, Remodel Bathroom. In your QuickBooks file, if you used an actual customer name on the invoice, rather than a job, that name would show here.

This last graphic is the portion of the Customer Center showing the customer’s transactions. It has been filtered to show only open transactions. Note that there are only three invoices open.

The bottom two are the invoices originally marked paid when the payment from the customer was first received. QuickBooks has marked these as open. This procedure allows these invoices to age properly, as of the original invoice date since, in reality, they were never really paid.

The third invoice, the one shown on line one in the graphic, is the invoice charging the customer the $35.00 fee for the dishonored check.

Recording a customer’s bounced check is as easy as a couple of mouse clicks.

Since this feature has been available since the 2014 version, have you ever used it?

Being Mobile With QuickBooks

Posted by Lance Wilkins Posted on July 27 2017

One of the selling points of QuickBooks Online is the anytime, anywhere access. While having access to your business books from anywhere there’s an internet connections, there’s more.

QBO is also mobile. QBO has an app for  iPhones/iPad and Android devices. Let’s get a brief overview of what’s possible on an Apple iPhone.

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

Above is a screenshot of the QBO menu on an iPhone screen. The menu items give access to almost all of the information in your QBO accounting program. Your customers and vendors are here. So is your list of products and services.

From your phone you are able to access transactions downloaded from your bank. Add, match, and accept them.

You can add expenses with a check or credit card transaction.

Account registers are accessible. View reports like a profit and loss or balance sheet.

It’s possible to create a number of different transactions for customers. In the following screenshot, we have accessed the sample company Rock Castle Construction. 

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

On the iPhone screen is an estimate for the customer Kristy Abercrombie. The estimate can be created on your phone. In this case, we accessed one that already existed.

Note the dark blue area with the total and the link that will allow us to turn this estimate into an invoice. 

As an example, let’s assume that someone from Rock Castle just completed the estimated task at Kristy’s home. Now he wishes to create the invoice for the completed job. Tap the instruction “convert to invoice.”

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

QBO creates the invoice. The red dots next to the items allow you to delete that line. The green dot just visible at the bottom would allow you to add additional items to the sale.

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

Above is the invoice. It’s been saved without any changes from the estimate. The area in the dark blue section allows the user to receive a payment if Kristy decided to pay now. If not, there is a signature line at the bottom. Tap there and the customer can sign the invoice with their finger.

This completes the transaction. It’s not necessary to download the transaction to QBO or sync information between devices. Back at the office, the bookkeeper working in QBO from their desktop sees the new transaction on their screen.  

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

Can creating invoices and accepting payments in the field help your business?  

 

When a Customer is Also a Vendor

Posted by Lance Wilkins Posted on July 20 2017

What to Do When  a Customer is Also a Vendor

This is a common scenario for small businesses. Another business buys product from you. They are a customer. But, they also sell to you. They are a vendor. 

This is an issue in QuickBooks because a name cannot be both a customer and a vendor. And there is no way to trade services or products between customers and vendors.

At least, not in a straightforward, documented way. There is a solution.

Creating a name as both a customer and a vendor is not difficult. Change the name a little.

Let’s say we have a customer named Greg Aackerman. We want to put Greg on the vendor list as well.

In vendor setup, use the vendor name ‘Greg Aackerman (vendor)’, and fill in the “Print on Check as” field with the name only.

Create a new bank type of account. You’ll see why in a few paragraphs. Name the new bank type of account “Clearing Account.”

Recording transactions is simple. Use the customer, in our case Greg Aackerman, to record sales on invoices. Use the vendor, in our case Greg Aackerman (vendor), to record purchases on bills.  

Saving the above transactions results in the following customer/vendor balances.

The puzzling part for most QuickBooks users comes now. How do we offset the balances?

First, note the amounts. Greg owes us $1125. We owe him $560. So whatever we do, we want to end up with a zero balance due to Greg the vendor and a balance due us of $565 ($1125 - $560) from Greg the customer.

Receive a customer payment from Greg in the amount of $560.

Navigate to Pay Bills and pay the bill we owe to Greg the vendor. Use the Clearing Account as the bank account to pay from.

Record a bank deposit. Deposit only the $560 payment we received from Greg and deposit it to the Clearing Account.

The result is that we no longer have a balance due to Greg in accounts payable. We show a balance due from Greg in accounts receivable of $565.

It’s important to double check and be sure we have created the transactions correctly. If we have, there should be a zero balance in the bank type account, Clearing Account.   

 

 

QBO – Easier Time Entry for Workers

Posted by Lance Wilkins Posted on July 07 2017

This option isn’t for everyone, but it is a unique capability of QBO. If you sell services to your customers, most likely you are purchasing those services either from contractors or employees.

If you sell those services based on time, X number of hours at X dollars each, you need a record of that time in order to invoice the customer/client.

QuickBooks Online (QBO) has some features that can help you with this process. The Plus version of QBO includes time tracking features that simplify the entry and sale of the services you provide. 

The base subscription for the Plus subscription to QBO allows up to five users. In addition to those five, you can create two accountant users which do not count against the limit of five.  

The unique capability we want to highlight here, is that you can add even more users without paying additional fees. Users with report viewing only rights and users with time entry rights can be added. An unlimited number at no cost.

To see how this works, we’ll setup a fictional example. We have a sample company to use,  Rock Castle Construction. Rock Castle provides certain services to its customers. Some of those services are performed by employees, some by subcontractors.

All this time must be tracked so Rock Castle can pay for it and invoice its customer. To ease the burden of tracking the time, we’ll let those who provide the service track the time for us.

The first step is to set up a new user in QBO.

From Settings (gear icon), choose Manage Users. Then Add a new user.

Remember, selecting Time Tracking as the user type, means we can add as many as we want.

Both the list of vendors and the list of employees is available, we can choose a name from either one. In this case, we will choose a vendor, Mendoza Mechanical.

As we proceed through the setup, QBO will ask for the user’s name and email address. We enter the information and continue.

QBO will invite the user to setup an account.

Above, you can see a portion of the email QBO sent to Mendoza Mechanical, inviting them to setup their user account in Rock Castle’s QBO subscription. A link is there allowing the recipient to accept the invitation. There are also instructions for signing in when time needs to be entered.

Above is the very simple screen presented to Mendoza so they can setup their user account login credentials. 

After the one-step setup is completed, Mendoza can access the time activity portion of Rock Castle’s QBO subscription. Here, they can enter time.

Above is a screenshot of Mendoza Mechanical’s access to Rock Castle Construction’s QBO subscription. How much of the program is accessible is always a concern. But you can see from the screenshot that the other menu items do not exist in this window. There is nowhere else in the software this user can go.

Shown is the single activity time entry screen. A weekly timesheet could also be used. Mendoza selects the customer they worked for and what service was performed. They can enter time as a total amount, or opt to include start and end times. 

There is also a help popup window to answer questions they might have about this entry.

Once the time is entered, it is available in the QBO system to pay Mendoza and invoice the customer without further manual entry.   

Is a feature like this something that would be useful to you?      

Updating Costs and Prices Automatically

Posted by Lance Wilkins Posted on June 23 2017

A lot of the work Intuit has done in recent years to improve inventory management in QuickBooks has gone into their Enterprise software. Even without the Advanced Inventory features that are part of the highest subscription level, Enterprise has several inventory features the other versions of QuickBooks don’t have.

One of those is automatic cost and price changes.

It’s very important to note a couple of things about cost information in QuickBooks. First, the value of inventory is maintained on an average cost basis. That is, if we purchase a widget at $5 and one at $10, QuickBooks tracks inventory as 2 widgets valued at $7.50 each.

The sale of one of those widgets will generate a charge to cost of goods sold of $7.50.

An item record actually has two cost fields.

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

The bottom circled area titled Calculated Average, is the QuickBooks generated average cost for this item. It is not an editable field. 

The upper circled area is editable. You can put any number you want in that field. It affects very little. QuickBooks uses the average cost in all accounting entries.

That can change with QuickBooks Enterprise. That user-entered cost field can matter very much when using the automatic cost and price updates. Let’s see how that feature works.

First, turn on the preference.

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

Several settings are available in the Automatic Cost & Price Updates window. The top dropdown field labeled Markup, gives the QuickBooks user two choices. Percent over cost or Amount over cost.

The middle section determines how automatic cost updates will be handled by QuickBooks. The first field is labeled “If item cost changes on a purchase. The choices are Always update item cost, Never update item cost, or Ask about updating item cost. Selecting Always or Ask and then assuming the QuickBooks user responds positively when asked, will cause QuickBooks to update the Cost filed in the item setup window.

The second field is labeled “When item cost changes.” The selections for this field are Always update sales price, Never update sales price, or Ask about updating sales price.

In the sample file is a product named Virus Vac A. The cost field is filled in with the amount 37.50. The price is set at 75.00.

If we enter a bill purchasing Virus Vac A at 30.00, the following popup appears.

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

The popup appears because the setting selected in preferences is “Ask about updating item cost.” Yes has been selected as the answer in the graphic in order to show the price options. If yes is not selected, the price update options are grayed out. If you do not automatically change the cost, there is no way to automatically change the price.

So, the new cost is $30. QuickBooks will change this value in the item window when this transaction is completed. The markup on the old cost is 100%. A cost of 37.50 times 100% yields a price of 75.00.

Now, if QuickBooks updates the new cost to 30.00, in order to maintain the price markup of 100%, the price will be updated to 60.00.

Let’s go back to our Automatic Cost & Price Updates window.

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

The bottom section in the preference window deals with assembly type items. If we are having QuickBooks automatically update costs for inventory items, should these new costs then add up to create a new cost for an assembly item? The checkbox indicates yes, QuickBooks should make that calculation.

If the cost of the assembly total bill of materials changes, should QuickBooks automatically update the sales price? Again, a selection in this checkbox indicates that yes, it should.    

How do you maintain pricing as the costs of the products you sell changes over time?

The Chart of Accounts - What’s Different in QuickBooks Online vs. Desktop?

Posted by Lance Wilkins Posted on June 16 2017

There are two good reasons to review the chart of accounts today. One, there is a setting when creating a new account that is unique to QBO. Two, knowing how to create accounts will make your company’s financial reports more accurate.

The account, from the chart of accounts, tells the financial software how to handle the amounts we post there when we create transactions. If the account is an asset or liability, the balance in the account is increased or decreased depending on the type of transaction we use and that balance remains, even across multiple years. It’s the account type that makes that happen.

On the other hand, with an income or expense type of account, the dollars posted there only appear on reports for certain time periods. We determine that time period when we create the report. A Profit and Loss report for June 2017 will show the expense amount of in particular account for that time period only, regardless of what may have happened in the past.

A 6/30/2017 balance sheet will show the total of all transactions in an asset or liability account since the beginning of the QuickBooks file, up through 6/30/2017.

So, it is very important to use correct account types. QBO takes another step.

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

You can view your chart of accounts by navigating to Transactions on the left panel and then choosing Chart of Accounts.

Above is a screenshot showing how the list appears. Note the column headers.

The first column from the left displays the name of the account. This is usually specified by the QBO user. 

The second column shows the account type as explained a few paragraphs ago. In the graphic, Bank, Accounts Receivable, and Other Current Asset types of accounts appear in the list.

The third column is circled. This is the Detail Type.     

Detail Type is not part of account setup in QuickBooks Desktop, so if you are new to QBO, you may not be familiar with it. It’s a way QBO gathers more information about how you intend to use this account. That information helps QBO decide where the account balance should appear on financial reports like Profit and Loss and Balance Sheet.

The fourth column shows the account balance, but only for balance sheet accounts. Those would fall into the general categories of assets, liabilities, and equity.

Scroll down this list to the income and expense accounts and you find that no balance shows. Income and expense accounts close, that is the balance is zero’d out for reporting purposes, at the end of each year. QuickBooks does not maintain an indefinite running balance for those types of accounts.

Also note that there are two account balances for the bank accounts shown. If the screenshot were long enough that you could see the credit card account type also, you would see both account balance columns filled there as well.

This tells us there is a difference between what our QuickBooks balance in this account is and the balance coming from the financial institution. There are transactions we need to match or enter from our bank feeds.

Once you are more familiar with and understand the QBO chart of accounts, it becomes easier to create new accounts correctly.

 

Get Creative in QuickBooks

Posted by Lance Wilkins Posted on June 09 2017

QuickBooks Premier and Enterprise provide an item type not found in Pro. It’s the inventory assembly type item.

Assembly items are used to create, assemble or manufacture products to sell from different component items already in stock.

Let’s stick with our sample company, Rock Castle Construction. They have one assembly type item. It’s an Interior Door Kit.

Rock Castle buys and maintains in inventory things like doors, door frames, hinges, doorknobs, etc. From these inventory parts, it assembles what it calls an interior door kit. That is, a door assembled with a frame, hinges, doorknob, etc. All the purchaser has to do is slide the mounted door and frame into a wall opening.

Since the component pieces are all in inventory, let’s look at how the assembly item would be created.

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

An Inventory Assembly type item is similar to an inventory part type item. You can see from the three arrows shown in the graphic, it requires the same number of accounts for posting as the item is used in various transactions. Cost of goods sold, income, and asset.

The big difference is the circled area, the bill of materials. This tells QuickBooks what items go into building this assembly item. From the screenshot, you can see that it takes one doorknob, a door, and three hinges. It also takes a door frame but you would have to scroll down that list in order to see that particular item.

What this means is that when one Interior Door kit is made, inventory of the component pieces will be reduced by the amounts required for the manufacture of the finished product.

In this case, there will be one less door, doorknob, door frame, and three fewer hinges.

QuickBooks has a process in order to create the assembly item, it’s called a Build Assemblies transaction.

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

 We choose what assembly item we want to create at the very top of the transaction window. Once we do that, QuickBooks fills in the middle area of the window with the bill of materials we reviewed in the setup of the assembly item.

The quantity we want to build is entered in the lower right part of the window. You can see in the screenshot that we have decided to build five of this item. Making that selection fills in the right-most column. How many component parts will be used in this transaction?

The quantity on hand of those components will be reduced by the numbers shown in the “QTY NEEDED” column. The on hand quantity of the assembly item, Interior Door Kit, will go up by five.

This is a good basic overview of how the assembly type item works in QuickBooks. It is also possible to add service item(s) to the ‘recipe’ or bill of materials, thus adding the cost of things like labor and overhead to the inventory assembled.

Do you have a use for this QuickBooks feature? How do you use it?

 

QBO’s Easier Bank Reconciliation

Posted by Lance Wilkins Posted on June 02 2017

Since we covered bank downloads in another section, it makes sense for us to take a look at reconciliations as well. While the process is very similar to QuickBooks desktop, there is a major difference allowing the procedure to take significantly less time.

Bank transactions can import into your QBO directly from your bank account. We examined that earlier.

Procedures differ from one organization to another. Some people prefer not to enter bank information manually. They use electronic transfers and/or debit cards. These transactions then download into their accounting software, QBO.

Occasionally an edit is still necessary to be sure a downloaded transaction posts to the right account. But there’s really very little manual data entry.

That same procedure won’t work for everyone. Some QBO users still need to manually enter that data.

Checks written, bill payments to track, and so on, these will require manual data entry even in QBO for some. Perhaps these users want the reduction to the account balance to show now, not when the transaction hits the bank.

So what are the benefits of downloading and matching bank transactions in a case like that? If you enter all your banking transactions manually, why do you care if QBO imports directly from your bank account?

Let’s look at reconciliation.

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

Above is a screenshot showing the transactions that downloaded from the bank. The lower arrow points to those QBO has already matched. You can see the green “match” symbol.

These can all be accepted, entire batches at a time, with a couple of mouse clicks. Simple.

The others, the ones indicated by the upper arrow, do not exist in QBO now. Those will have to be edited so they post to the correct expense account.

Still, you can see the rapid procedure for matching transactions.

We’ll complete this process as a step one. It will take a few minutes at most. 

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

The above screenshot shows the check register after the downloaded bank transactions have been matched or entered.

Note the green icons next to the “C” designation. These transactions were either matched or entered from the bank downloads. Those that have no such designation have not been matched to a corresponding bank transaction.

The “C” indicates this transaction has cleared the bank, but has not yet been reconciled.

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

Now, let’s reconcile the bank account.

Click on the gear icon and select Reconcile from the Tools section. Which account to reconcile will be the first selection you make. Then, the bank or credit card statement date, and the ending balance.

A handy tip is to check the box highlighted in the upper right part of the window. This selection causes QBO to only show the relevant transactions, those dated on or before the statement date.

The green icons indicate transactions that have been matched with the bank already. They show in this window as well. If all the transactions had been matched, there would be no hunting and scrutinizing of the bank statement to match them in this window. QBO has already done that.

Once the transactions listed in the window are marked as cleared to match those shown on the statement, the Difference field, which appears in the bottom central section of the screen should be zero.

At that point, you can click Finish Now.

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

Above is another screenshot of the check register. This one though is after the reconciliation has been completed.

The “C” designation, indicating a transaction had cleared the bank, is replaced with an “R” designation if that transaction had been reconciled in the bank reconciliation window.

If all transactions are downloaded and matched from the bank feed, the reconciliation will be practically complete when you go to perform that function in QBO.  

 

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!