Skip to main content
A
amy-yachtsalesin
September 27, 2020
Question

How can I split an existing bill to multiple projects? When I try, the entire bill shows as cost against each project i.e. 10k bill w/2k cost on 5 projects.

  • September 27, 2020
  • 3 replies
  • 0 views
10k vendor bill where 2k in costs needs to be assigned to 5 projects. Currently, all 5 projects display the full 10k in costs.

    3 replies

    M
    MirriamM
    September 27, 2020

    Welcome to the Community forum, amy-yachtsalesin.

     

    You can assign a customer/project per line item on your bill transaction. Here's how:

    1. In the left menu, click the + New button. 
    2. Choose Bill.
    3. Select the vendors name in the Vendor field.
    4. Under Category details or Item details, enter the details like cost and account, then choose a specific Customer/Project.
    5. Tap Save and close. 

    Once done, the amount designated to each project will show on the Overview tab on your Project page. 

     

    For more information about projects, see below articles:

    If you have any additional questions or concerns about QuickBooks, please reach out to me. Have a great day.

    A
    amy-yachtsalesinAuthor
    September 28, 2020

    Yes, that is what I did however; the full vendor bill amount is being allocated to each project.  For example, I have a vendor bill valued at 2,783 of which 117 belongs on Project A and the rest belongs on Project B.  When I assign the line items appropriately, the full 2,783 shows as costs on both projects.  That being said, the bill in question is from early 2019 before we started using QB Projects.  

      MarsStephanieL
      MarsStephanieL
      September 28, 2020

      Hi there, @amy-yachtsalesin.

       

      I'd be glad to share with you some insights about this feature you've mentioned.

       

      Currently, there isn't a way to get the right cost per project made from one bill. To assign the correct cost, you can create a separate bill for each project. Then, by the time you're going to record your bill payments, you can split it to different projects in one go. To make sure that I've addressed your concern, I've replicated it by creating multiple projects and entering a bill. Here's what I've seen after that:

       

       

      Also, you've mentioned that the bill was made last year, you can continue tracking it individually. Or if you still want to include and track it per project, you can re-enter the outstanding cost through a bill and assign it. But first, make sure that the previous bill cost has been cleared and edited like this:

       

      Subtract the Paid amount of the Bill to the Total bill cost (TOTAL AMOUNT OF BILL - PAID AMOUNT)

       

      Now, you can create a bill transaction in your Project and enter the outstanding cost of the previous bill. Then, add the exact date in the Memo field in every bill transaction that was dated last year. This is done so that it will be easier to locate it.

       

      I've also added a screenshot to see how it looks like when paying multiple bills in one go.

       

      For more information, you can check out this article: Enter and pay bills.

       

      I've added this reference for your future task about assessing our business financials: Reconcile an account in QuickBooks Online. This contains tips on how to successfully finish reconciliation and how to troubleshoot it whenever there's something wrong during the process.

       

      You can always tag my name in the comment section below if you need further assistance or if you have other questions. I'd be happy to guide you through. Take care always.

      L
      LMM12
      October 6, 2020

      I am having a similar problem and it seems like Quickbooks needs to update the process.  I am doing bookkeeping  for a firm and have assigned projects to specific clients.  The firm is renting space, and when the firm receives a bill for rent each month, there is also a charge for copies that were made by the firm.  The copies are chargeable to projects.  When entering the check for payment of the rent and copies, I split the payment into a Rent/Lease Expense and a Client-Related expense.  I assign the appropriate project to the client-related expense, but when I run the project report, the entire amount of the check is charged to the client's project.  I would like for QB to make it so that only the amount for the copies gets charged to the project.  As it stands now, QBO  is creating inaccurate project cost tracking until this is fixed.

        T
        TBKF
        November 8, 2022

        This needs a fix after 2 years. Pivoting to another platform for a number of our clients is looking like more of a possibility as this is a MUST for job costing. The "work around" suggested is not a feasible solution for a modern company. Please escalate the priority on this.

        Terms & ConditionsAccessibility statement