Importing Expense/Receipts into Quickbooks Credit Card v Debit Card

OfObjectOfObject Posts: 5

Hi all, I have an issue where a combination of Receipts, in the same report do not import to the correct Account in Quickbooks.

Receipts are correctly loaded and linked in Expensify to either a Credit Card OR Debit Account originated transaction. However when submitted-closed off to Quickbooks, they can importing collectively as either a Credit Card OR Debit Card expense, as per latest settings saved under Expensify's Admin/Polices[Policy Name}/Connections{Quickbooks Online} /Configure/Export non-reimbursable expenses as/

  • Debit Card (correctly linked to Debit Account, although i have more then one and can only select one at a time)
  • Credit Card (correctly linked to Credit Account)

I assume these settings are mutually exclusive, based on what I've observed with imports to Quickbooks.

As a result this makes it difficult to match transactions via the Quickbooks Banking/For Review process, as the Expenses Bank/Credit Account field, is a criteria for suggestive matching. I've had to find receipts imported to Quickbooks and change the Bank/Credit Account, to enable a match to be found. This is extremely tiresome as you could imagine. I'm on a TEAM plan, to resolve this do I need CORPORATE? If not is there a way to configure the Expensify / Quickbooks to resolve this?

thanks in advance..

Answers

  • Sheena TrepanierSheena Trepanier Posts: 1,638 admin

    Hi @OfObject - great question! Upgrading to the Corporate policy will not give you the ability to export a single report as both a credit card and debit card.

    If you wanted to export some expenses as one and the rest as the other, you'd want to create two separate reports and change the export settings depending on which report you're going to export.

  • OfObjectOfObject Posts: 5

    Hi @SheenaTrepanier, thanks for your response. The above is a little surprising. Is there any development in the works to enable this within Expensify? Alternatively is there any way Expensify is configurable at the Policy / Bank account level. e.g. have a specific account link only to a specific Policy/Policies, so that I don't have to change export settings continuously.. Hope this makes sense.

    thanks

  • Sheena TrepanierSheena Trepanier Posts: 1,638 admin

    Hi @OfObject, thanks so much for circling back to this. You will be able to select a different account to export your expense to, for each policy you have the connection set up on. (Below)

    Any reports submitted, approved, and exported on the policy, will use the account you have set in the configuration.

    Regarding adding that other functionality to our roadmap, it's not something I've heard discussed as an option, but I've shared this thread with my team who can let me know if things change.

Sign In or Register to comment.