We’re currently making some incredible improvements to SmartScan! During this time, you may experience delays of up to 24 hours for receipts completing SmartScan. This should be a short-term inconvenience that results in significant improvements to both SmartScan processing times and accuracy going forward. Thank you for your patience and please accept our apologies in advance! 

Importing Expense/Receipts into Quickbooks Credit Card v Debit Card

OfObjectOfObject Posts: 5 Expensify Newcomer

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: 2,006 Expensify Success Coach

    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 Expensify Newcomer

    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: 2,006 Expensify Success Coach

    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.

  • MKirchmanMKirchman Posts: 6 Expensify Newcomer

    I have the same problem: I carry a business DEBIT card and a business CREDIT CARD from 2 banks – Bank of America and American Express, respectively. You mean to tell me I have to separate the expenses before I export them!!!??? Is managing 2 accounts not a basic functionality of Expensify?

  • RachCHopkinsRachCHopkins Posts: 880 Expensify Success Coach

    Thanks for your comments @MKirchman I'm so glad you got it sorted! And I'm glad you found the answer! This scenario only applies when it's a mix of debit & credit cards. All Debit = fine, all Credit = fine, but when it's both, the system doesn't know which setting to look at so you have to separate it by Policy.

Sign In or Register to comment.