Allocate single bill to multiple clients

lerxxst · ‎May 23, 2019

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?

Rustler · ‎May 23, 2019

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

BettyJaneB · ‎May 23, 2019

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.

Rustler · ‎May 23, 2019

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

lerxxst · ‎May 24, 2019

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

Rustler · ‎May 25, 2019

@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

Topics

Training

Community

Resources

Allocate single bill to multiple clients