cancel
Showing results for 
Search instead for 
Did you mean: 
dengberg
Occasional Member - Level 2

Tracking Sales/Use Tax within Expense

How are companies tracking the sales/use tax for expenses submitted for reimbursement?  We are trying to determine the most efficient way to track tax for reimbursable expenses within Concur Expense, that is only applicable for a few of our locations.

5 REPLIES 5
Munari_alEXPert
Frequent Member - Level 1

dear @dengberg 

could you please provide more details on your question?

Because from my side at the moment the answer would be that to track taxes or specific expenses which are relevant for taxes, are possible to get them via a Cognos reporting which you can filter by location/country.

 

Kind Regards

Alessandro Munari - Travel Expense Project Manager
https://www.linkedin.com/in/alessandro-munari/
dengberg
Occasional Member - Level 2

As of now, the reporting through Cognos wouldn't help us because we don't capture the sales tax piece at all in expense and our use tax is manually monitored by us sending the transactions that didn't have tax on them to our tax department for review.  However, I do like the idea of adding the sales tax field especially since we are about to roll out a corporate card program. 

JessicaL
Frequent Member - Level 1

I agree that using a report would be a good way to track use taxes. We use Concur for our Purchasing Card program and during implementation, added two custom fields:

Was Sales Tax Collected? Yes/No

Amount of Sales Tax - which was required if "Yes" was chosen.

Since we had a credit card feed into Concur, the "Amount of Sales Tax" would fill in automatically for larger vendors that utilized Level 3 data. We found that with many of our vendors, this field would pre-populate. When the month-end journal entry had to be done, we would review the "No" transactions to see if sales tax should have been collected and then, we would pay that amount to the appropriate state. It really worked well for our program.

Jessica
Travel and Expense System Administrator
dengberg
Occasional Member - Level 2

We are still in the process of rolling out a corporate card/p-card program but I really like the idea of creating the additional fields.  With those fields though, do they put the gross or the net in for the transaction total?

JessicaL
Frequent Member - Level 1

For our build, we have the gross in the transaction total. 

Jessica
Travel and Expense System Administrator