cancel
Showing results for 
Search instead for 
Did you mean: 
awmcclain
Level 2

How do I keep track of expenses for a large project from a single vendor?

I'm doing books for my small HOA using quickbooks, and we're embarking on a major repair from a single vendor. I want to keep track of the total (estimated) expenses for the project and be able to create bills so I can write checks using billpay as the vendor progressively bills us. I also want to track each owner's expected assessment for the repair and then write invoices against that to collect money to cover the costs.

What type of account should I create to track the total amount owed to the vendor "ABC Painting"? Liability or expense? Should I just use an existing account? I'd like to create bills that would reduce the balance in that account, so when it reaches zero, we know we're done. Alternatively I could just create one bill and make partial payments against it, but that seems more difficult to line up the vendor bills us as the project progresses.

Likewise, I want to do something similar for the assessment -- to track the total that we're assessing to cover the payment. Is that a separate income account that I'd create invoices in, or would I create line items for the invoices that apply to the same expense/liability account I created above?

3 Comments 3
Kiala_S
QuickBooks Team

How do I keep track of expenses for a large project from a single vendor?

Hello @awmcclain, hope you had a great weekend!

 

QuickBooks Online does have a Projects feature, but it isn't set up to support your HOA project in the way you describe. Typically the project is assigned to one customer and then you can enter in expenses, invoices, purchase orders, etc., towards that customer. It sounds like the best way for you to use QuickBooks is to create a bill for that vendor every time they send you an invoice.

  1. Log into your account and click on +New, then select Bill under Vendors. 
  2. Fill in the fields with the vendor, amount, description, etc.
  3. Lastly, choose Save or Save and Schedule Payment

 

To keep track of all of the bills, you could run one of these vendor reports: "Purchases by vendor" or "Transaction by vendor". Here's a great article on running reports in QuickBooks: Run reports in QuickBooks Online.  From there, you'd manually calculate how much each homeowner owes to that project. 

 

If you did want to take a look at the Projects Feature, I'll attach a useful article about Projects to explain how it works. You may find you can get creative. :)

 

Also please feel free to reply to this post with any other questions you have. We are all happy to help!

 

awmcclain
Level 2

How do I keep track of expenses for a large project from a single vendor?

Thank you for the response!

One of the things I'm trying to do is keep track of _future_ expenses. e.g. we know the project will cost say $45K. Given that, I can invoice our owners that amount. As the project progresses, I'd like to apply the bills to that estimated total so we can see if we're over/under and then reassess if necessary.

The question is -- how to collect and apply the incoming bills to that total? Is that just assigning all the line items to a specific account?

RCV
QuickBooks Team
QuickBooks Team

How do I keep track of expenses for a large project from a single vendor?

Thanks for coming back, awmcclain.

 

We can collect and apply the incoming bills to that total by creating a billable expense transaction. This is an expense you incur on your customer’s behalf when you perform work for them. Then, you can record and track billable expenses so your customer can reimburse them when they receive their invoice. Let's turn on the billable expense tracking feature first on your account. Let me show you how: 

  1. Go to the Gear icon on the top menu.
  2. Select Account and Settings.
  3. Go to the Expenses tab.
  4. From the Bills and expenses section, tick Edit.
  5. Turn on the Show Items table on expense and purchase forms, Track expenses and items by customer and Make expenses and items billable options. 
  6. Hit Save.
  7. Press Done

To create a billable expense and add it to an invoice, see Enter billable expenses article. You can also enter bills to record an incoming one. Feel free to visit our Expenses and vendors page for more insights about managing your vendor transactions. 

 

I'd like to know how you get on after trying the steps, as I want to ensure this is resolved for you. Just reply to this post and I'll get back to you. Take care always.

Need to get in touch?

Contact us