Splitting billable expenses into taxable and non-taxable

[former_member306668]

Hi;

We have a scenario where users post travel expenses (for a project) to one G/L account. Some of the expenses are taxable others are not. For example a kilometer allowance is tax-free where as taxi fare would be taxable. When it now comes to billing them (same project), they are mapped to only one material (e.g. E001), which as per material master is taxable, hence the system calculates tax for both.

Example: Taxi fare is $110 which includes $10 GST. Kilometer allowance is $50 (no GST). The billing side shows a net value of $150 + $15GST. However it show show $150 + $10 GST.

Obviously we can code the initial expenses to two different accounts and have one account mapped to E001 and the other account to another (non taxable) material. But is there a way to achieve this using the same material?

Regards

Thomas

[Feras_Al-Basha · Accepted solution]

Hi Thomas,

The technique you mention is a viable solution (having another material with a corresponding suitable G/L account mapped to it + maintenance of YBPS expense billing cost element groups).

In contrast, are these expenses for internal employees and you are using Concur Expense to book these expenses to the project, the solution you are aiming for (1 material) should be applicable.

Hope this helps,

Thank you,

Feras

[former_member306668 · Accepted solution]

Hi Feras;

Yes we are using Concur Expense. i would think we can have one expense type in Concur and have some rules to assign to one G/L for taxable expenses and another one for non-taxable.

Regards

Thomas

[Feras_Al-Basha · Accepted solution]

Hi Thomas,

Thank you for the clarification. In this case yes, as you mention you should be able to maintain configurations under tax authorities in Concur Expense to obtain the desired results. What is important is to note that the tax codes and related G/L account settings drive the results of the postings - as a function of your localization.

For instance in the Canadian localization, the TB tax code is assigned to business meals expense type. This expense is then 50% reclaimable in the province of Quebec. By maintaining configuration on the Concur expense side (map tax code & jurisdiction) the posting to S4HC is made on two different G/L accounts but with the same tax code (config account determination for taxes in S4HC). And when it comes to billing the expense to a customer project only one material is used.

Hope this information helps,

Thank you,

Feras