Activate the QuickBooks Integration

Comments

16 comments

  • Avatar
    Nenad Mirkovic

    This integration is doubling transactions pulled from the bank. P&L statement now shows twice the revenue. Not good! Do not sync your bank if you plan to use this app or else you won't be able to go back and fix financial reports in QuickBooks.

    0
  • Avatar
    Alissa Cimmino

    If you are in a state like NH that does not collect sales tax you may have issues with step 8 as there will be no sales Tax Agency set up in QuickBook. We had trouble with the QB setup for NH , it would not complete because that state does not collect. What we did was to add another state, and disable it. Once we did that we were then able to select "No Tax Agency". It was not there before and we were unable to complete the connect.

    0
  • Avatar
    Sean Smith

    The second bullet point above states the following:

    "Reconcile your books much easier as payments and fees are matched against your bank statement."

    Does Vagaro sync the Merchant fees paid when syncing with Quickbooks, or do I have to manually enter the fees when the credit card deposit hits our bank account?

    I see the transactions under "All Sales" in Quickbooks, and the deposit (minus merchant fees) synced from our bank account to Quickbooks.

    Do I tell Quickbooks that the bank deposit is a transfer from the Vagaro Payment Account? If so, how do I account for the difference in merchant fees taken out prior to the deposit hitting our bank?

    3
  • Avatar
    Donna J

    Sean: I created a support ticket for this issue.

    -1
  • Avatar
    Sarah

    I have the same questions as Sean

    Does Vagaro sync the Merchant fees paid when syncing with Quickbooks, or do I have to manually enter the fees when the credit card deposit hits our bank account?  I don't see the merchant fee expenses coming in from Vagaro in Quickbooks, so I assume not.

    I see the transactions under "All Sales" in Quickbooks, and the deposit (minus merchant fees) synced from our bank account to Quickbooks.

    Do I tell Quickbooks that the bank deposit is a transfer from the Vagaro Payment Account? If so, how do I account for the difference in merchant fees taken out prior to the deposit hitting our bank?

    Also, should the Vagaro Payment Account (this was mapped when the integration started) be considered a bank account?  QuickBooks is treating it that way so when I synced my bank account it basically doubled the Money In.  Can someone at Vagaro help walk me through this?

     

    0
  • Avatar
    Donna J

    I did the same for your question, Sarah, and created a ticket.

    0
  • Avatar
    Sean Smith

    @Sarah Dionne, the current communication back from Vagaro support states that Merchant fees for credit card payments are not currently synced with Quickbooks and we, therefore, have to manually input them into Quickbooks.

    Here is how I am doing it currently...

    First, when the credit card deposits go into our bank account and then sync from the bank to Quickbooks, I tell Quickbooks that the bank deposit is a transfer from the Vagaro Payment Account to keep Quickbooks from counting the revenue twice. Note, that I do this for all deposits into the bank (checks, cash, credit cards) that are checked out through Vagao so Quickbooks does not count the revenue twice.

    Quickbooks only shows the Vagaro Income Account on Profit & Loss reports.

    Second, I've created a "Merchant Fee Payment Account" in our Quickbooks Chart of Accounts as a Bank Checking account. Once the credit card deposit goes into our bank account, I create a Transfer in Quickbooks from the Vagaro Payment Account into the Merchant Fee Payment Account in the amount of the merchant fees shown for the deposit in Vagaro. Then I create an expense in Quickbooks out of the "Merchant Fee Payment Account" in the amount of the merchant fees for the deposit.

    This allows me to account for all merchant fees for credit card payments processed through Vagaro and Quickbooks sees it as a Merchant fee paid expense and shows the expense on our Profit & Loss reports for accounting purposes.

     

    1
  • Avatar
    Sarah

    @ Sean Smith - thank you so much!  It is very disappointing that the $30 per month paid to Vagaro to send transactions to QuickBooks does not include "all" transaction data, but I digress.

    I will go with your process as it seems most logical.

    0
  • Avatar
    Lily Duncan

    Am I understanding this correctly? Vagaro charges $30.00/month to integrate with Intuit PLUS I have to pay for a plan with Intuit? 

    -1
  • Avatar
    Donna J

    Yes, that is correct.

    0
  • Avatar
    Jamie Golden

    This page is out of date a bit.  There is now an option on the page called "Sync transactions after fees are deducted".  This page should have some more detailed explanation on what this option means.

    0
  • Avatar
    Ahsan Qazi

    Hi Jamie. Thanks for bringing this to our attention. The article is now updated. The step (Step 10)  is right before you click Save and the explanation is included in the step. 

    0
  • Avatar
    Jessica Ruby Mullen

    I have been using this integration since 2019 and had my accountant help me set up accounts to match up with transactions from Vagaro. The issue is that it CONSTANTLY comes disconnected and does not alert you. In fact, mine has been disconnected since Nov 18, it is now Dec 21 and nobody from Vagaro has reached out with an update on this from their development team. The concern is that it only goes back 2 months, so what happens if this sync isn't fixed by Jan 18? 

    0
  • Avatar
    John Stewart

    I don't understand how syncing before or after fees helps anything when what should happen is that you synced the details with the fees shown per transaction. What other reason was I paying 30.00 a month just to have to manually manipulate everything to show the actual processing fees somewhere? The reason you would record things this way is to account for the gross sale minus the processing fees. If you just categorize the deposits as sales/service income in QBO without the integration that would be the same as having it synced after fees are taken out. For that matter at 30 per month, you really should sync it with my discounts given too and help me show my real financial statements since we use Vagaro as a business operating software. ( I know the reports do reflect this well, but when syncing with QBO or Xero maybe we should have options on what to sync)  This goes hand in hand with not having a cashout system for the register as well. But I digress. 

    0
  • Avatar
    Drea Woods

    Hi John, I agree!  I have tried it both ways and there doesn't seem to be much difference.  We just started integrating with QuickBooks in October 2022 and it has been a management nightmare to say the least.

    I am told by Vagaro support that I cannot see the details of the deposits to determine how much I am paying in transaction fees, what discounts were given on the sale, what was included in the deposit because I am not the Vagaro account owner.  We also process booth rent through Vagaro and it all comes in as one lump sum -- including sales for the day, less transaction fees -- and determining what we actually received for what has been virtually impossible. Even if I am not the shop owner, I am the person who does ALL the bookkeeping and integration with QuickBooks and trying to determine what we have actually been charged by Vagaro for these transactions and what was rent / sales for services / sales for products, etc. has been an exercise in futility. I have run numerous reports trying to back-in to what is reality and the extra time required to do so would be better spent without the integration.....  I am not getting the bang for the buck here!

    When we pay for the integration, we should get the level of detail necessary to be able to truly do the books, including the transaction fees, what transactions were actually part of what deposit, etc., even if "we" are not the actual account owner / shop owner in Vagaro (and the other owner can't see it either).  I have been given admin rights in Vagaro (all the boxes are checked), and do everything related to the bookkeeping, among other things, and need that level of detail.  I can't even see the detail if I am granted "owner" rights in Vagaro.  This is crazy!  What am I paying $30 a month for?

    0
  • Avatar
    Malanie Killian

    This integration is the worst. For $30 per month, transactions should come across neatly batched as app transactions that can be matched to bank transactions, not just dumped into the income statement in bulk to be manually matched up one-by-one later. Also, the individual transactions on the income statement that are synced from Vagaro don't seem to match up one-to-one with the individual transactions listed in the Vagaro reports, so it is almost impossible to match bank transactions in QBO with the underlying transactions from the daily sync. What took minutes with Square takes hours with Vagaro. The complaints have been ongoing for so many years. Why has Vagaro not fixed this and created an intelligent sync? So many other companies have awesome syncs. Why not Vagaro? Please hire Square to fix the Vagaro sync.

    0

Please sign in to leave a comment.