Forum

Ask, reply and learn. Join the community of Akaunting.

New Discussion

Negative value items

Matei-Ma-Ngai Holdings   ( User )

Commented 1 year ago

Good day all.

I have an installation of Akaunting running your cloud-hosted.

In my invoices, I would like to use negative values for items.
The reason is I would like to show the tax amount on the invoice. However, I do not pass this amount on to my clients. how can I show this in the invoice?

Example .
I have a service item that I charge 10,000
I have a normal tax calculation amount at 10% which equals 1,000
The total for the invoice is now 11,000

However I only charge 11000

Using discounts to do this could work. but can be tricky because the discounts is applied across all items as a percentage not the discount amount which has already lead to a number of invoices being 9998 after applying the discount.

The easier solution would be to be able to use a new item entry with a negative value
Ie tax normalization - 1000
Therefore the total amount in the invoice remain unchanged at 10,000

Is there anyway you could assist with this issue.




Matei-Ma-Ngai Holdings   ( User )

Commented 1 year ago

I have also tried all the tax calculation variations. At 10%
For Inclusive tax, the taxed amount is too low but the total amount for the invoice is correct.
For Withholding the total amount on the invoice is incorrect as it deducts the withholding amount.
Fixed amount is fixed.
Compound tax and normal tax are the same the tax amount is correct the total amount that I would like to charge is too high ( increased by the tax amount

John Brand   ( User )

Commented 1 year ago

Could you perhaps do this with an item that has no tax - and no price? I.e., just a line item that is a description of the logic, not changing the actual calculation? I haven't tested it but it might be worth investigating. I've had problems with rounding errors on items exactly as you have described. I had to get around it using a similar technique to above - basically putting in a line item for 'adjustment' and then manually editing the value.

Matei-Ma-Ngai Holdings   ( User )

Commented 1 year ago

Hello.

Thanks for the suggestions regarding the rounding errors. I will try that.

For my problem, I ended up breaking the invoices into multiple parts and removing the taxes. It's unfortunate I can't show this cost to my clients. It is what it is.

Appreciated.

Please login or register to leave a response.

Showing 1 to 4 of 4 discussions