Many QuickBooks forms have a billable column, do you know what it’s used for and are you using it correctly?
Many QuickBooks forms have a billable column available for you to work with – checks, enter bills, timesheets, enter credit card charges, etc. The purpose of the billable column is to allow you to choose which expenses and/or time entries that you will be passing through to customers when you create an Invoice based on Time & Costs {also know as Time & Materials billings or Cost Plus billing in the construction industry.}
Welcome to Tuesday Training!
Tuesday Training is a new feature here on the QuickBooks for Contractors blog. While everyday focuses on training of one sort or another, Tuesday’s are dedicated to more in-depth training.
We’ll teach you the things you need to know about using QuickBooks, that you won’t find in the QuickBooks Help file, in order to successfully run your construction business and obtain accurate job costing reports; from eBooks, live webinars, and recorded training sessions.
You’ll find high-quality (budget friendly) training without having to leave the comfort of your home or office.
Important Facts About Items Left as Billable
Are you aware that if click into the billable column, which places a checkmark in the column {OR you leave that little Invoice icon found on many forms active and don’t “X” it out older versions of QuickBooks} that the information relating to that transaction line is stored within your QuickBooks file in a “waiting to be billed” status just taking up additional space and making your file larger than normal?
Selecting the billable column doesn’t mean that you want the costs assigned to this job {which is a common thought or assumption} but rather it tells QuickBooks that you want to take the information about that transaction and put it into a temporary database until you create an invoice for a specific customer using the Time/Costs button on the Invoice form.
If you really don’t pass these costs or time entries onto customers using the Time/Costs feature of QuickBooks – then this temporary database is just out there growing and growing – which causes the overall size of your QuickBooks file to become bigger and bigger.
If you are wondering if this is happening to you, an easy way to find out it to run an “Unbilled Costs by Job Report” {Report menu -> Jobs, Time & Mileage -> Unbilled Costs by Job} and look to see if there are a lot of entries in this report, if there are; all of those entries are just sitting there waiting for you to do something with them.
Download our 2 page article for instructions on how to clear out old unbilled costs – without having to edit each item in the report and manually making them unbillable.
We hope that you’ve found today’s Tuesday Training article to be helpful to your business – if so please take a moment to leave a comment or share this with others on your favorite social media network using the buttons below.
Working with taxable and non-taxable items and customers in QuickBooks sometimes just freaks people out and causes them to over think the entire situation. I’m frequently asked how to do this by people who are setting up our AIA billing program – here’s a question that I received recently.
I am getting ready to set the AIA billing program {Construction Application for Payment Solution} up tomorrow and just have a few questions.
Should the income items each be posted to an income general ledger account? Or will I use the subtotal line to point to an income account? If I have to post each income item to an income account – I will have to do 2 sets of them, one for wholesale (no tax) and one for retail (taxable) and I would like to avoid this if possible. I guess though we will have to post them to an income account…..thoughts?
Should we use the group items to setup our labor and materials for the schedule of values? For example, when we bill the customer- we only want DEMOLITION to show up, but for our purposes we have the DEMOLITION broken into labor and material. It seems like this would be a good place to use group items?
Each of your QuickBooks Items/Cost Codes should be set up and linked to BOTH and Income and an Expense/Cost of Goods Sold Account otherwise you’ll never get any decent job costing reports.
Subtotal Items do not link to either an Income or an Expense Account – they simply add up the numbers above it and display the amount on the Estimate and Progress Invoices that you create.
Unless you want to track Wholesale and Retail Income individually on your Profit & Loss Report, there is no need to create two sets of Items. QuickBooks can handle both taxable and non-taxable customers and sales using the same item list. You’ll just want to make sure that you have two Sales Tax Items – one that actually charges the Sales Tax Rate and one that has a 0% rate for Non-taxable sales.
Below is a YouTube video that demonstrates the procedure and shows you what your Sales Tax Liability Report will look like if you do it correctly.
As for using group items to track labor and materials for a specific cost code, there are a couple of different options that you could use, depending upon the amount of detail that you want to track. But group items are definitely the way to go if you want to job cost more information than you want the customer to see.
I hope you’ve found this article to be informative, if so please take a moment to leave a comment or share it with others on your favorite social media network using the buttons below.
So how do you find a “good” bookkeeper and test their knowledge before hiring them? Or, perhaps you are ready to hire a CPA to help you with your business and your books. Congratulations! We all know what a struggle it is to “try to do everything” yourself, and it almost goes without saying that as a busy contractor, we also know that time is best spent on the job and not in the office handling paperwork.
Welcome to Tuesday Training!
Tuesday Training is a new feature here on the QuickBooks for Contractors blog. While everyday focuses on training of one sort or another, Tuesday’s are dedicated to more in-depth training.
We’ll teach you the things you need to know about using QuickBooks, that you won’t find in the QuickBooks Help file, in order to successfully run your construction business and obtain accurate job costing reports; from eBooks, live webinars, and recorded training sessions.
You’ll find high-quality (budget friendly) training without having to leave the comfort of your home or office.
Construction Bookkeeper Test – $25.00
So how do you find a “good” bookkeeper and test their knowledge before hiring them? Well, we have scoured the internet searching for a “good” QuickBooks and Construction Bookkeeping Test, and while we have found some that would test an applicant’s basic knowledge of QuickBooks as well as some basic accounting knowledge, none have addressed any construction related functions. Being disappointed in what we have found, we’ve designed our own – somewhat based on issues that we deal with on a day to day basis supporting our own software which integrates with QuickBooks – and we are happy to offer you a copy {complete with the answers}.
Our Bookkeepers test asks applicants to answer a total of 145 questions, covering 5 different areas of knowledge.
Purchase your copy today for $25.00.
Hiring a Bookkeeper or CPA
We all know what a struggle it is to “try to do everything” yourself, and it almost goes without saying that as a busy contractor, we also know that time is best spent on the job and not in the office handling paperwork.
Before you hire someone to handle your books or your taxes, check their skills and lay the ground rules to make sure that you are getting the right person for your business and never make the big mistake of just “turning” it all over to someone (no matter how enticing that idea may be). Always keep an eye on what is going on.
FREE eBook – click here to download.
Additional Resources from the IRS
Even the IRS feels that this is an important subject, and the IRS urges you to choose that preparer wisely. Most return preparers are professional, honest and provide excellent service to their clients. But it is the taxpayer who is legally responsible for what’s on his or her tax return even if it is prepared by someone else.
We hope that you’ve found today’s Tuesday Training items to be helpful to your business – if so please take a moment to leave a comment or share this with others on your favorite social media network using the buttons below.
The QuickBooks Weekly Timesheet can cause a lot of confusion for users who are implementing employee time tracking for the first time, mainly because the timesheet contains both a Service Item and a Payroll Item. This article will explain what each column is used for and some common pitfalls that can happen.
Job costing and employee time tracking are important aspects of many businesses – not just construction businesses. However, when you initially set up timetracking there are many things that can cause confusion.
About Service Items:
The Service Item column represents the type of work that is being performed and allows you to select/enter/choose the name of the service item/cost code from your Item List that you want to use when your charge/bill your customer for this work – OR – when you pay a subcontractor/non-employee for this item.
Even if you do not intend to charge anyone for this work, entering a service item provides a record of the amount of time spent on this specific type of work. This information will then flow through the the various “Time by” reports as well as your job costing reports..
When a Service Item is brought into an Invoice, it tells QuickBooks which accounts to use to track the income you receive and what Cost of Goods Sold/Expense account to use to track the money your company has spent – so it’s important that your items are set up to capture both Income and Expenses. This provides you with the ability to analyze which types of work/services are the most profitable and how much company time is spent on producing them.
About Payroll Items:
Payroll Item column allow you to select a Payroll Item {that also exists in the employee record} which determines how much the employee should be paid for doing the work that you selected in the Service Item column. This information will then flow through into employee paychecks and perhaps any invoices that you create that are based on billable time and costs.
What if the Payroll Item Column isn’t displayed?
When the Payroll Item column doesn’t appear in the Weekly Timesheet, for one or all employees, it usually means that the employee’s haven’t been setup to utilize timetracking, and you’ll need to check the setup in the employee record to be sure that the “Use time data to create paychecks” option has been checked and that Time tracking has been turned on in the Preferences.
We hope you’ve found this article to be helpful, if so please take a moment to leave a comment or to share it with others on your favorite social networking site using the buttons below.
Wishing you all a happy, successful, and prosperous New Year! I hope you all had a wonderful holiday season with family and friends.
The holiday season is wonderful – but it’s a time of short work weeks and lots of non-work related activities – I don’t know about you but in some ways I’m REALLY glad the holiday season is over! But unfortunately, I feel like a need a vacation just to get myself ready to go back to work and deal with the things ahead!
Coming back to work after the Christmas and New Year’s holidays can be tough – there are all the things that we need to catch up on that were set aside because of short work weeks and of course January means getting ready for W-2′s, final quarterlies, taxes, etc.
Perhaps your company is implementing new software to automate time-consuming tasks, workflow procedures for the new year that will help you all get your jobs done quicker and more efficiently, or you are thinking about signing up for some QuickBooks training classes so that you can perform your bookkeeping tasks more efficiently.
What are your goals for the new year?
Do you have a plan?
Do you have a list of things that you want to accomplish this year?
I have a long list of things that I need and want to do this year.
One of the things that I want to do is to offer more QuickBooks training, for our customers and site visitors, through reasonably priced eBooks, pre-recorded and live webinars. I’m also working on updating many of the eBooks that I’ve previously offered here on the blog for free – once the eBooks have been updated and released, I will be selling them for $7.00 to $35.00 – depending on the length and subject matter. I’ll be announcing their release hear on the blog as they are completed.
As a visitor to our site what would you like to see for upcoming training subjects?
Have a great first week back to work!
