Issues with line item taxes on Expenses | v5.2.17-C56

[charles]

Hi,

After a lot of head banging from reading conflicting info through the forums, I finally learned that there is a possibility to add taxes to expenses natively (without custom fields tricks), yay - as seen here: Expenses taxes - Feature request - Self-Hosted | v5 - Discourse (invoiceninja.com)

I must say that this was not an intuitive find in my experience, as “Item tax rates” made me think of invoices, not expenses. It does not help that the taxes options on expenses only appear after the “Item Tax Rates” option has been turned on. May I suggest leaving this section displayed at all times, but greyed out until the Item Tax Rates have been turned on, with a temporary description or tooltip explaining to turn it on?

So anyway, I now see tax fields on Expenses, great.

I noticed however that if I add for an expense taxes by rate, the second tax field gets duplicated:

It still gets calculated only once, though, so that’s just a UI glitch.

I also noticed that I can’t get IN to show individual taxes in separate columns for expenses, I only get the total:

It’s weird, because I can add columns for separate tax rates and tax names:

So, it would be nice to get also Tax Amount 1, Tax Amount 2 and Tax Amount 3 - and of course “Tax Amount Total” could still be there as an option for those who want that.

I understand that if custom tax amounts are paid with custom names, IN probably cannot merge those tax names with registered taxes, but it would make sense IMO to have the option to select a registered tax (say, in my case, TVQ @ 9,975%) and override the amount it calculates to account for some rounding errors appearing on actual invoices I pay. So, say on an invoice I pay the TVQ tax, but instead of 9,975% it’s being calculated by the vendor @ 9,98%, I could still select “TVQ” in the dropdown menu, enter the real amount paid instead of letting IN do the calculation with the official rate, and have IN still list that amount in the “TVQ” column, where other, auto calculated of custom entered values would appear for other expenses.

Finally, it’s not related to expenses taxes directly, but I also noticed that expenses titles are fetched from the Public Notes field; however this makes titles overflow their container in the preview pane:

Thanks!

[hillel]

Thanks for the feedback! We’ll work to correct these issues.

[charles]

Hello @hillel,

I’m currently running v5.3.79 and expense taxes are still bundled together in the reports, AFAIK.

Is there still a plan to make separate the amounts linked to each particular tax appear in different columns in the expense reports in order to calculate them separately?

Edit: For now, as a workaround, I added custom labels as toggles to indicate if a tax has been applied, and which one - then based on that “yes” nor “no” value included in an expense report I can ask Excel to recalculate an individual tax, which ends up unobfuscating the bundled tax amounts. Still, that’s quite a bit of additional work to recalculate something that was already calculated in IN, but then hidden - we would just need to be able to print separate taxes amounts separately on the reports (and in the admin panel too, by the way, please).

Edit 2: I noticed that the expenses custom labels are not printed in the reports: instead, we get “Custom1, Custom2, Custom3, etc.”.

Edit 3: Also, the “Tax Amount” and “Amount” columns in the reports no longer show the rounded values (there should be only two decimals):

Edit 4: The toggles I created to identify the taxes being paid do not show the “No” value unless toggled on and off. By default, the toggle is on the “Off” position, yet it’s like it’s deactivated according to the data it does not output. I have to “wake it” by turning it on then back off if I want to get a “No” value. Is this normal?

Thanks

[hillel]

Thanks for following up on this and the additional issues.

[dosplus]

Hi,

In the expense report, i do not have the taxes shown, should they be there?

[hillel]

Which app are you using?

Note: this is an old post, it’d be helpful if you could create new posts for your questions.