We are currently experiencing higher than normal support inquiries and response times. The Community is here to support you as well so please help each other out when you can. Please visit our status page to subscribe to updates.

Proper Importing of Expenses and HST in QB Desktop

DesDes Expensify NewcomerPosts: 2Expensify Customer Expensify Newcomer

My issue that I am having is we have a tax rate "H" for a 13% tax set up in Expensify which matches the tax rate "H" in QB Desktop. When importing, QB is adding another 13% to the total if my account is set up to default to "H". If the account is not set up with the "H", the tax does not import.

So for every transaction, either I have to take 13% off, or I have to add the HST in. What is the correct configuration of QB and Expensify to ensure that HST is imported correctly so I don't have to adjust the HST in every single transaction?

Automation isn't worth it if you have to check every entry.

I echo the sentiment that phone support would be beneficial. Chat and email don't work and I don't see a lot of solutions on this board.

Answers

  • Nicole TrepanierNicole Trepanier Expensify Success Coach Posts: 699Expensify Success Coach - Admin Expensify Success Coach

    Hi @Des! Because our QuickBooks Desktop integration doesn't support tax export, if you have tax set in QuickBooks, it will add the tax on top of the expense. You'll need to make tax inclusive on the QuickBooks side in order to have it show the correct total.

    To do this go to Edit > Preferences > Sales Tax > Company preferences and check the box to allow inclusive tax, then select HST from the dropdown. Let me know if you have any questions!

  • VinceVince Expensify Newcomer Posts: 2Expensify Customer Expensify Newcomer

    Hi there, having the same issue with GST; have followed the above steps under preferences, but the total in QB desktop adds the tax to the total transaction every time. Any ideas?

  • Sheena TrepanierSheena Trepanier Expensify Success Coach Posts: 1,992Expensify Success Coach - Admin Expensify Success Coach

    Hi @Vince, thanks for sharing. Just confirming that you've followed the steps Nicole shared and selected GST from the drop down, not HST?

    If so, just let me know and I'll ask my team for more information.

  • DesDes Expensify Newcomer Posts: 2Expensify Customer Expensify Newcomer

    Hi Sheena,

    The issue I see is that I don't want to change the rest of my accounting process for importing of credit cards.

    Right now I am dealing with the issue by going into every single transaction and making adjustments if the transactions has HST. I still have to add it in if not included and then change the transaction by 1.13, or I have to take it out if the account it was put in has automatic HST.

  • VinceVince Expensify Newcomer Posts: 2Expensify Customer Expensify Newcomer

    Hi Sheena, yes, following the steps and selecting GST. Same issue Des is having, just with GST instead of HST.

  • Nik12Nik12 Expensify Newcomer Posts: 4Expensify Customer Expensify Newcomer

    Hi @Sheena Trepanier @Vince were you able to resolve this issue? Or find a work around?

    I would like the sync to go through without it resulting in a double tax (having to manually change the transactions for the HST).

  • daveICCdaveICC Expensify Newcomer Posts: 2Expensify Customer Expensify Newcomer

    Hi all,

    I'm having the same issues with expensify and quickbooks desktop not having GST/HST integration.

    Has anyone figured out a work-around so that you don't have to manually add inclusive tax on each transaction in quickbooks?

  • daveICCdaveICC Expensify Newcomer Posts: 2Expensify Customer Expensify Newcomer

    @Des @Sheena Trepanier @Vince were any of you able to figure out a work-around for this issue?

    It doesn't seem like Expensify is working to solve the issue and considering how cumbersome it would be to manually change each transaction after import, I would be forced to use another expense management software.

  • Nicole TrepanierNicole Trepanier Expensify Success Coach Posts: 699Expensify Success Coach - Admin Expensify Success Coach

    @daveICC Because we don't integrate QuickBooks Desktop tax with Expensify, this isn't something that we are inserting when we create transactions in QBD. The tax that is being applied to expenses is being added after we've exported the report so it's something on the Intuit side.

  • SoSimpleSoSimple Expensify Newcomer Posts: 4Expensify Customer Expensify Newcomer

    @Nicole Trepanier it is an issue on Expensify's side. Also we don't need tax integration we just need an option to export the subtotal instead. Why are we forced to only export the total after tax? You have tax tracking enabled in your software just subtract the total from the calculated tax that calculation yields the subtotal before tax and just let us export that amount into QuickBooks. Solving everyone's problem...

  • Nicole TrepanierNicole Trepanier Expensify Success Coach Posts: 699Expensify Success Coach - Admin Expensify Success Coach

    @SoSimple We only send over the total amount of the transaction in the API call. If the direct integration won't work for you because you need tax to integrate correctly, you do have the option of using Transaction Pro Importer with your QuickBooks Desktop account. You would then just export your Expensify reports to a CSV and import them the way you need them into QuickBooks Desktop.

  • SoSimpleSoSimple Expensify Newcomer Posts: 4Expensify Customer Expensify Newcomer

    @Nicole Trepanier Hi Nicole yes that's what I'm saying, why won't you give us an option to send the subtotal amount of the transaction to the API? Why would that be difficult, you'd solve a lot of problems rather than making everyone do 5-6 extra steps for no reason.

  • Nicole TrepanierNicole Trepanier Expensify Success Coach Posts: 699Expensify Success Coach - Admin Expensify Success Coach

    @SoSimple As I said on the other thread. We are not considering any new features for QuickBooks Desktop. Our engineering resources are focusing on cloud based integrations only.

Sign In or Register to comment.