Wednesday, March 20, 2019

How Do You Track Jobs in QuickBooks? Part 2

In this second of a two-part series, we’ll explore how you use the job-related records you’ve created.


Last month, we showed you how to start building a foundation for tracking jobs in QuickBooks. We explained that you can use the software’s jobs tools to track income and expenses for any related group of items and/or services (you can think of them as projects, if you prefer).


We covered three elements of preparing to use “jobs”:


  • Creating job records that you can use in transactions (example: develop promotional materials)
  • Creating item records that can be assigned to jobs (example: website development)
  • Determining whether you’ll need to create a new account in your Chart of Accounts for your job income and expenses. You should consult with us anytime you think it might be necessary to modify the Chart of Accounts.  


Using Your Job-Related Records
Now that you’ve recorded the items and jobs themselves, you can start using them in transactions, and eventually track your progress by generating reports.


Let’s say you worked eight hours on website development for your promotion job. You’d open the Employees menu and select Enter Time | Time/Enter Single Activity to open this window:


You can enter individual, billable activities and assign them to jobs.


In the example above, you’re limited to recording one day’s work on a specific SERVICE ITEM. You’d verify the date and select from the drop-down lists to complete the fields for employee NAME, CUSTOMER:JOB, and SERVICE ITEM. You can either use the timer to time the job or enter the number of hours manually in the DURATION box. Click in the Billable box to create a checkmark and add NOTES if you’d like. The CLASS field is optional; talk to us if you’re not familiar with this feature.


If you worked on two separate service items on the same day for that CUSTOMER:JOB, you would create two individual records. You can also enter billable activities directly on a timesheet by clicking Employees | Enter Time | Use Weekly Timesheet. Once you select the employee NAME at the top, any single activity(ies) you created that week will appear as individual records, and vice versa.


Writing a check or using a credit card for a job-related purchase that should be billed to the customer? You’d fill out these forms in QuickBooks like you usually do, making sure that you document the items or services by highlighting the Items tab, select the correct CUSTOMER:JOB, and make a checkmark in the BILLABLE? column.


If you write a check or charge your credit card for purchases that can be billed to a CUSTOMER:JOB, be sure to record it in QuickBooks.


If you’ll be doing some billable driving for your job, you should also be tracking your mileage in QuickBooks. Open the Company menu and select Enter Vehicle Mileage. If you haven’t created a VEHICLE record in QuickBooks, click <Add New> and easily do so. Complete the rest of the fields and save.


Tip: Do you want to see some of your overhead expenses on job costing reports? Create a CUSTOMER:JOB named “Overhead” and assign related costs to it.


Billing the Billables
When the time comes to invoice your customers (Customers | Create Invoices), you’ll see how your careful work in QuickBooks simplifies that task. Open an invoice form and select a CUSTOMER:JOB. If you’ve entered billable items for him or her, this small window will open:


When you create an invoice for a CUSTOMER:JOB who has billable time, mileage, or other expenses, QuickBooks can automatically add them.


If you leave the first option checked and click OK, another window will open that lists all of the expenses you’ve marked as billable to the customer, arranged by type. Click in the first column of each expense you want to include and click OK. Your invoice containing those entries will open. Do any editing necessary, and then save it.
Note: You’ll probably notice two fields in the Choose Billable Time and Costs window that refer to Markup. This is an advanced concept that we can explore with you, should you want to charge customers more for expenses you’ve incurred on their behalf.


Related Reports


QuickBooks contains a wide variety of reports related to your work billing customers for jobs. Click Reports in the navigation pane or Windows menu, then Jobs, Time & Mileage to see what’s available. Choose a date range and click Run to see them appear with your own data.


If you’ve never worked with jobs in QuickBooks, we strongly recommend that you let us help you here. There are a lot of moving parts, and you don’t want to miss out on any of your efforts or expenses that are billable.


Social media posts
Do you do projects for customers that involve billable time and other expenses? QuickBooks allows you to set them up as jobs.  Find out how here.


If you assign time and other expenses to a job in QuickBooks, the software can automatically import them into an invoice.  We show you how here.


When you record purchases related to a job in QuickBooks, be sure to define them as Items so they’ll be included in job-costing reports. Find out how here.

Need to start recording job expenses in QuickBooks but not sure how to do it? We can go over this multi-step process with you.

Wednesday, March 6, 2019

Could Your Sales Invoices Be Better? How QuickBooks Online Can Help.

Every interaction with your customers can enhance your image. Here’s how QuickBooks Online contributes to that.


Getting paid by your customers—on time, and in full—can take some effort on your part. You set smart due dates and enforce them. Price your products and services so they’re both reasonable and profitable. Accept online payments.


But are your invoices working for you here? QuickBooks Online provides sales form templates that you can usually use without modifying. But it also offers tools that support multiple kinds of customization. It helps you shape the content and appearance of your invoices and their accompanying messages to be consistent with your company’s brand.


These may be cosmetic changes, but they can affect the way customers react to communications from you. You have few chances to make an impression, so anything you can do to enhance and personalize every interaction will have impact on their impression of you. Neat, well-designed sales forms convey professionalism and attention to details.


Here’s a look at what you can do.


Editing Fields
Unless you use every single field in QuickBooks Online’s default sales form template, your invoices will look sloppier than they might otherwise. The site gives you control over much of the content that your customers will see. To make changes, click the gear icon in the upper right of the screen and select Account and Settings, then Sales. You’ll see Sales form content in the left column. Click on any of the fields to the right to open a more thorough list of options.




QuickBooks Online lets you turn fields on and off in your sales forms and specify other preferences.


Click on the status (On, Off) in the right column to change it. When you’re satisfied with your selections, click Save. Then close that window by clicking the X in the upper right corner.


You have more options than these. Click the gear icon again, and then Your Company | Custom Form Styles. You’ll see that there is already a “master” form. You can either edit it or create a new one. We recommend leaving the master form alone so you always have a clean copy to consult if you get tangled up while you’re working.


Click the down arrow in the New style box in the upper right and select Invoice. In the screen that opens, enter a descriptive name for your template in the field at the top and then click Content. A graphical representation of your invoice will appear in the right pane, grayed out. It’s divided into three sections: header, footer, and table (the middle of the invoice where you describe what you sold). Each displays a small pencil icon on the right side of the screen. Click the one in the middle to make that area more visible.


It’s easy to specify which fields should appear on your invoices, what the labels should say, and how wide the space should be.


As you check and uncheck boxes to indicate what content should be included, your invoice on the right will change to reflect your actions. You can Preview PDF by clicking that button in the lower right. When you’re satisfied with the changes you’ve made to all three sections, click on the Design tab.


Changing the Look
You don’t have to be a graphic artist to have QuickBooks Online forms that look attractive and consistent, which highlight your brand. The site provides tools that give you control over the appearance of your invoices, not just their content. Click each link below the Design tab to:
  • Choose a template.
  • Add your company’s logo.
  • Select a color scheme and fonts.
  • Change the printer settings to accommodate letterhead, for example.


Choosing Your Words


You have control over the messages that go out with your invoices.


Finally, click the Emails tab. Options here let you customize the emails that are sent to customers along with their invoices. Again, changes you make in the left pane will be reflected in the graphical version on the right side.


When you’ve completed all of your modifications, click Done.


We gave you this whirlwind tour of QuickBooks Online’s invoice customization options so you’d know what was possible. We expect you might need some assistance when you sit down to apply the concepts you’ve learned about to your own company’s sales forms. We’re available to help you present a polished, carefully-crafted image representing your brand to your customers.


Social media posts
Are you satisfied with the image you convey to customers through your QuickBooks Online sales forms? We can help you make them more customized and effective.


You have few chances to interact directly with your customers.  Make sure your QuickBooks Online sales forms convey the image you and your brand deserves.


QuickBooks Online comes with sales form templates that may work for your company, but did you know you have control over their appearance and content?

Your customers pay attention to the sales forms you produce for them. QuickBooks Online lets you improve on the default templates it provides making a better impression to your client.