Corporate Card Imports Not Going to Correct Account In Quickbooks Online

eben_clark1

Hello,

I've recently integrated a client firm's corporate cards to import expenses directly into Expensify, which should then be going to Quickbooks (one approved) to specific cardholder accounts.

Except- the export to Quickbooks is still functioning the same way as it was before the integration. Expenses are only going to the 'master' GL ledger in Quickbooks, instead of being sorted to the correct cardholder sub-account.

I've mapped the cards to specific sub-account per the company card page in Expensify, and the user guides aren't going into further detail. Does anyone know if there is another step that needs to be taken in Quickbooks, or is there another step that needs to be completed in Expensify?

Thank You,

Eben

Brigid Bello

Hi Eben,

I'd love to help you out. There are a couple of things that might be causing this.

One important thing to keep in mind is that the Expensify user that is exporting these reports from Expensify to QuickBooks Online needs to be a domain admin in order to export expenses to the specific sub-accounts that you've mapped your cards to in your Company Card settings. If the exporter is not an admin on the domain, the expenses will be mapped to the default account selected in the policy connection's general configuration settings.

Another thing that you can check is that you have the correct export option selected in your configuration settings. For example, even if you have a specific Debit Card account selected in your Company Card settings, the expenses will still go to the Credit Card account if you have Credit Card selected in your configuration settings.

Do you want to double check how things are set up for your client and see if one of these two things might be the cause?

TYeh

Hi Ebin and Brigid,

Were you able to resolve this? I am encountering a similar issue, where I have designated a default account at the QBO connection configuration level, and different credit card GL accounts at the card level under domain admin. However, the import seems to consistently be feeding to the account designated at the QBO connection configuration level. I am a domain admin.

Is there a special method of initiating the import, such that the accounts post at the card level?

Thank you,
Tina

Rachael Hopkins

Hi @TYeh , Welcome to the Community!

Do you have a Report ID of an example report please? I'd like to take a look at the expenses and the configuration.

TYeh

Appreciate the quick reply @RachCHopkins! It is ID: 29981745.

Thank you!

Rachael Hopkins

Hi @TYeh - thanks for that!

You know what's weird? Tina no longer has a card assigned in Domain Control. Clearly she did in past, because that report shows the credit card with lock icon, but the card has somehow been unassigned.

If you go to Settings > Domain Control > [Domain Name] > Company Cards and click 'Assign cards' you will see two cards which are unassigned.

Once the card is assigned to Tina again, the report should export to the correct place. I imagine at the moment it's going to your generic SVB card.

TYeh

Hi @RachCHopkins,

Thank you for pointing that out! I re-assigned the card to me, and re-initiated the import but received the same result. Transactions are still hitting the generic account. Any other suggestions on how we can import each card transaction to a respective QBO GL account vs. the generic account assigned at the QBO integration set up level?

Thank you,
Tina

Rachael Hopkins

Hi @TYeh , are all the transactions in report 29981745 hitting the wrong account, or just certain ones?

TYeh

@RachCHopkins On the expense side (Debit in QBO), they're hitting the correct account. It is the credit side (that hits the credit card account) that is hitting the incorrect account, and is occurring for all of the transactions on the report.

Rachael Hopkins

Hi @TYeh I think you've just had a response from Concierge on this too. If you wouldn't mind replying there, I think we're narrowing it down in that thread.

TYeh

@RachCHopkins will do! thank you for your help!

john_sts

I know this ended up going through the concierge but it would be really helpful to see the steps to correct this problem. I've noticed it with our corporate cards as well even after making sure that the cards are assigned to the correct GL accounts before importing transactions.