cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

Allocate single bill to multiple clients

I recieve a bill from a vendor for products that are then sold to multiple clients.

I wish to allocate the relevant proportion of that bill to each client.

I have attempted to do this using "Item Details" within the bill - which allows me to associate the cost with a client - but I then hit the rounding problem. QBO insists on rounding up by a penny, which leaves my total bill value incorrect.

Does anyone have any suggestions on how to do this?

Solved
Best answer 05-23-2019

Accepted Solutions
Highlighted
Level 15

Allocate single bill to multiple clients

If you are buying for the client and not stocking inventory, list the expense account several times with the amount per client and make it billable or not. Let's face it if you and two friends split a 10.00 food bill, someone is going to pay one penny more.

if you use items, enter the qty and the total cost, QB will do the per item rate out to 5 decimals for cost, but money at least in the US and the UK, is held to two decimal places

View solution in original post

4 REPLIES 4
Highlighted
QuickBooks Team

Allocate single bill to multiple clients

Glad to have you back, @lerxxst.

 

Allow me to help share some insights about allocating a single bill to multiple clients in QuickBooks Online.

 

You're now on the right track in allocating a single bill to multiple clients, however, rounding off of amounts to the nearest hundredths is set as default within the program. For now, you can save the bill that you're trying to create and make a journal entry afterwards to adjust the excess amount. 

 

Our developers are constantly working to meet our customer's needs and demands. I'd encourage you to visit our QuickBooks Online Blog regularly to be updated about our latest news, features, and updates about what our Product Care Team is working on.

 

Don't hesitate to let me know if I can be of additional assistance. Cheering your business to continued prosperity.

Highlighted
Level 15

Allocate single bill to multiple clients

If you are buying for the client and not stocking inventory, list the expense account several times with the amount per client and make it billable or not. Let's face it if you and two friends split a 10.00 food bill, someone is going to pay one penny more.

if you use items, enter the qty and the total cost, QB will do the per item rate out to 5 decimals for cost, but money at least in the US and the UK, is held to two decimal places

View solution in original post

Highlighted
Level 1

Allocate single bill to multiple clients

Hi Rustler,

Many thanks for your swift response - much appreciated.

I'm not too sure how to "list the expense account several times" - but I'll give it another go using Items & see whare I get.

Again thanks

 

Highlighted
Level 15

Allocate single bill to multiple clients


@lerxxst wrote:

Hi Rustler,

Many thanks for your swift response - much appreciated.

I'm not too sure how to "list the expense account several times" - but I'll give it another go using Items & see whare I get.

Again thanks

 


Some thing like this

 

fuel exp, $12, customer A
fuel exp, $22, customer B

etc