cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
David Rich
Level 1

Tracking stock cost on projects

Hello

 

I have been trying to find a way to calculate cost of stock on projects without showing this directly on customer invoices.

 

For example we are a construction company and may order £10,000 of stock such as fixings and set this as a tangible asset. I would like to put an expense on projects say £2000.00 which would show this as a expense on that particlar project and at the same time lowering the value of the company asset by the same figure.

 

Any ideas would be much appreciated 

Solved
Best answer May 14, 2022

Accepted Solutions
JenoP
Moderator

Tracking stock cost on projects

There's a feature called Billable Expenses in QuickBooks Online. David. 

 

This will let you track all expenses you've made on behalf your customers or projects while the work is begin done. 

 

When you purchase stock items, they are reported and increases your stock asset account. Once the item is sold and added to your sales transactions, the amount in the stock asset account is also reduced with the same amount. 

 

I'll share the steps on how to activate and use the feature. Here's how:

 

  1. Go to the Gear or Settings ⚙ icon, then select Account and settings.
  2. Proceed to the Expenses tab.
  3. Click Edit ✎ under the Bills and expenses section
  4. Turn on the following:
    • Show Items table on expense and purchase forms
    • Track expenses and items by customer.
    • Make expenses and items billable.
  5. Select Save.

 

 

Once done, you will see a Customer/Project column when creating expense transactions every time you buy stocks. Aside from that, you can also mark transactions as billable to the projects when you record them. Just check the Billable box if you want to add the transaction when creating invoices. 

 

 

 

In terms of lowering a tangible asset, you can do that via a journal entry, we'd recommend speaking with an accountant for advice on that.

 

Check out these articles for more details: 

 


Don't hesitate to reach out to us again if you need anything else. We're always here to offer our help anytime you need it. 

View solution in original post

1 REPLY 1
JenoP
Moderator

Tracking stock cost on projects

There's a feature called Billable Expenses in QuickBooks Online. David. 

 

This will let you track all expenses you've made on behalf your customers or projects while the work is begin done. 

 

When you purchase stock items, they are reported and increases your stock asset account. Once the item is sold and added to your sales transactions, the amount in the stock asset account is also reduced with the same amount. 

 

I'll share the steps on how to activate and use the feature. Here's how:

 

  1. Go to the Gear or Settings ⚙ icon, then select Account and settings.
  2. Proceed to the Expenses tab.
  3. Click Edit ✎ under the Bills and expenses section
  4. Turn on the following:
    • Show Items table on expense and purchase forms
    • Track expenses and items by customer.
    • Make expenses and items billable.
  5. Select Save.

 

 

Once done, you will see a Customer/Project column when creating expense transactions every time you buy stocks. Aside from that, you can also mark transactions as billable to the projects when you record them. Just check the Billable box if you want to add the transaction when creating invoices. 

 

 

 

In terms of lowering a tangible asset, you can do that via a journal entry, we'd recommend speaking with an accountant for advice on that.

 

Check out these articles for more details: 

 


Don't hesitate to reach out to us again if you need anything else. We're always here to offer our help anytime you need it. 

Need to get in touch?

Contact us