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.

Forum|Forum|5 years ago
September 27, 2020
26 replies
111 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.

QuickBooks Online

M

MirriamM

QuickBooks Team

Welcome to the Community forum, amy-yachtsalesin.

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

In the left menu, click the + New button.
Choose Bill.
Select the vendors name in the Vendor field.
Under Category details or Item details, enter the details like cost and account, then choose a specific Customer/Project.
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

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.

K

ksm283

It is well over a year since this original question was asked yet QuickBooks has still not resolved this huge accounting problem. Businesses commonly order large quantities from a vendor to be separated into numerous orders, or projects. Sometimes they all ship at the same time, sometimes not. Why an item and it's total amount can't show up in it's project that is completely separate from the next line item and its project, doesn't even make sense since they aren't connected. The P.O. TO the vendor and the bill FROM the vendor should be accounted to the project each line item references, and that should be an easy fix for large accounting firm like QuickBooks. This is a problem that should take top priority with QuickBooks and I ask that you do that. Thank you.

Chiming into this discussion as I've just realized this is an issue for my bookkeeping as well.

I specifically upgraded my subscription so I could manage transactions through Projects, and just realized that I've overcharged customers because the entirety of a transaction was uploaded to each project when I had divided expenses per project in the expenses entry.

Any update on where QB stands with this? I'm about to downgrade my subscription is there isn't a reasonable work-around.

L

LMM12

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

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.

Sign up

Login with SSO

Let's get you signed in

Login with SSO