取消
Showing results for
Search instead for
Did you mean:
GKTammy
Occasional Member - Level 2

Credit cards - Merchant code mapping

Has any one come up with a quick way of mapping the merchant codes for credit cards to their expense types?

Also if a transactions comes through without being mapped how can you check which merchant code it is and quickly map it?

1 Solution
Solution
Josh
Routine Member - Level 2

Hi@GKTammy,

As for a quick way, I don't think there's any function like an import that can accomplish this, unfortunately. Each Expense Type needs to be assigned any relevant Merchant Codes manually.

To check for transactions that come in, I believe you would need to build a custom report in Analysis / Intelligence (at least this is what must be done in Concur Standard). If you have a specific transaction from a specific cardholder you want to check, you can just build the report to find that info, and list the Merchant Code alongside it. You can use these fields to pull that info:

Expense > Expense Reports > Credit Card > Credit Card Accounts >Name on Card

Expense > Expense Reports > Credit Card > Credit Card Transactions >Posted Date

Expense > Expense Reports > Credit Card > Credit Card Transactions > Amounts >Posted Amount (reporting currency)

Expense > Expense Reports > Credit Card > Credit Card Transactions > Normalized Vendor >Vendor Name

Expense > Expense Reports > Credit Card > Credit Card Transactions > Additional Merchant Details >Merchant Code

From here, you can filter to the cardholder, a date range, and an amount to find the transaction in question.

Now, if you want info about codes that are not currently mapped to an Expense type, add these two fields to that report:

Expense > Expense Reports > Credit Card > Credit Card Transactions >Default Expense Type

Expense > Expense Reports > Credit Card > Credit Card Transactions > Additional Merchant Details >Merchant Description

With this info, you can filter the Default Expense Type to 'Undefined' and the report will return any Merchant Codes that do not have a Default Expense Type assigned to them. The Merchant Description field is a must, as these Undefined transactions most likely will not have any normalized vendor info.

您可以导出Excel报告,检查任何codes that are Undefined, view which merchants the code applies to, and decide internally if you want to map these to avoid coding errors in the future, or if not. Like Jessica said, this process may take some time, but it would definitely be worth it if you're constantly running up against this issue.

Cheers!


Josh

View solution in original post

5 REPLIES5
JessicaL
Frequent Member - Level 1

我们实现了商人的映射。我们拉n an excel output from our credit card company that included a column for Merchant Code. Then, we sorted those and mapped each one to the most correct expense type. It was an exercise worth the few hours it took us as it saves time for our expense users.

Thank you,

Jessica
Travel and Expense System Administrator
Solution
Josh
Routine Member - Level 2

Hi@GKTammy,

As for a quick way, I don't think there's any function like an import that can accomplish this, unfortunately. Each Expense Type needs to be assigned any relevant Merchant Codes manually.

To check for transactions that come in, I believe you would need to build a custom report in Analysis / Intelligence (at least this is what must be done in Concur Standard). If you have a specific transaction from a specific cardholder you want to check, you can just build the report to find that info, and list the Merchant Code alongside it. You can use these fields to pull that info:

Expense > Expense Reports > Credit Card > Credit Card Accounts >Name on Card

Expense > Expense Reports > Credit Card > Credit Card Transactions >Posted Date

Expense > Expense Reports > Credit Card > Credit Card Transactions > Amounts >Posted Amount (reporting currency)

Expense > Expense Reports > Credit Card > Credit Card Transactions > Normalized Vendor >Vendor Name

Expense > Expense Reports > Credit Card > Credit Card Transactions > Additional Merchant Details >Merchant Code

From here, you can filter to the cardholder, a date range, and an amount to find the transaction in question.

Now, if you want info about codes that are not currently mapped to an Expense type, add these two fields to that report:

Expense > Expense Reports > Credit Card > Credit Card Transactions >Default Expense Type

Expense > Expense Reports > Credit Card > Credit Card Transactions > Additional Merchant Details >Merchant Description

With this info, you can filter the Default Expense Type to 'Undefined' and the report will return any Merchant Codes that do not have a Default Expense Type assigned to them. The Merchant Description field is a must, as these Undefined transactions most likely will not have any normalized vendor info.

您可以导出Excel报告,检查任何codes that are Undefined, view which merchants the code applies to, and decide internally if you want to map these to avoid coding errors in the future, or if not. Like Jessica said, this process may take some time, but it would definitely be worth it if you're constantly running up against this issue.

Cheers!


Josh
GKTammy
Occasional Member - Level 2

Thanks Josh this was really helpful!

Josh
Routine Member - Level 2

Glad to help!Smiley Very Happy


Josh
JanAelbrecht
Occasional Member - Level 3

Thanks for this info, now I can link all undefined expenses as we had a lot of them.

Regards Jan

My Settings." disabled class="lia-form-type-text lia-inline-topic-not-allowed" aria-label="Sorry, either you cannot reply to this topic or you have not verified your email address by clicking on the verification link in the email we sent you when you registered. If you did not receive an email from us, or need us to resend it, please visit My Settings."> verify your email address." disabled class="lia-form-type-text lia-inline-topic-not-allowed-mobile" aria-label="Sorry, either you cannot reply to this topic or you must first verify your email address.">