Adding Fields to Bills

A feature was added to QuickBooks Enterprise 14 allowing forms like checks, bills, and credit cards to be customized. It’s a big change since we, as QuickBooks users, haven’t really been able to customize these forms.

What’s an example of how this might be useful?

Some companies pay sales people on a commission basis. The more you sell, the more you make.

Some companies take that a step further and pay commission on the gross margin of a sale. That is, if you are the sales person, you get paid a commission on the difference between the cost and the selling price of the goods you sell.

How would we track that in QuickBooks?

It has not been an easy task in the past. Now, for QuickBooks Enterprise users, it is possible.

Open a bill and right click on the column header bar on the stub portion of the form.

Note the last command on the popup menu. Customize Columns. Following is a graphic showing what appears in QuickBooks when that selection is made.

Note that there are two columns that can be added, Sales Rep and Retail Price.

In some cases there may be several columns that can be deleted from the form. Only leaving those columns that will be used streamlines and hastens the data entry process.

With the Sales Rep field added to bills, our form now looks like this.

Now, the same list of sales reps that is available for invoices, is also available for bills. As purchases of products are made, they can be traced back to the customer involved (Customer:Job column) and the sales rep who initiated the sale of those products to a customer.

We can also create reports like the above that shows both the cost and sale of product made by VMI sales reps. We have the information needed to create a commission check based on the margin, not on the total sale.

Hector Garcia, CPA
Certified Advanced QuickBooks ProAdvisor
12401 Orange Drive #136
Davie, FL 33330
954-414-1524
hector@garciacpa.com

Hector Garcia

Hector Garcia

Hector Garcia is a CPA and QuickBooks Consultant.
Share on linkedin
Share on facebook
Share on twitter
Share on whatsapp
Share on email
Share on print

Use our link to get 30% off for a year, valid through 07/31/2022

5 Responses

  1. We are not able to export GL detail for bills that have sales rep. You can see the sales rep on the screen but it won’t export the data. Do you know why?

Leave a Reply

Your email address will not be published.



Popular Courses

Private QuickBooks Training onsite

Customized Training

Accounting & Bookkeeping Services

Video-Based Virtual QuickBooks Course

Share

Share on linkedin
Share on facebook
Share on twitter
Share on whatsapp
Share on email
Share on print

30% Off QuickBooks

Use our link to get 30% off for a year, valid through 07/31/2022