cancel
Showing results for 
Search instead for 
Did you mean: 
JSpiers667x
Level 3

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

@bradnic I just got off the phone with QBO Support. I did the screen share with them too, first via the SmartLook bit built into QBO, then with Intuit Glance, their actual screen sharing software. When we did that one, the agent was able to actually see how the connection fails immediately because I was able to pull the popup window out of the way in time. I was told it was going to be escalated.

I will say that this is my first experience with a Customer Service agent who blatantly ignored my request for a Supervisor. Can't wait until I get the survey.

bradnic
Level 3

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

got an email from the quickbooks commerce folks yesterday asking for more info.

no updates after that. still not fixed.  

bradnic
Level 3

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

@JSpiers667x you're right that 571 error pops up immediately when you try to connect to Shopify Balance from QBO. It's there as soon as the login dialog box pops up, before you even enter your user id!

 

The customer service response suggesting a 571 is caused by user error closing the reconnect dialog is clearly wrong.

bradnic
Level 3

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

I'm done trying to get this to work. dropping the shopify connector and switching to a 3rd party service.

bradnic
Level 3

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

so... I deleted the account settings in the shopify connector yesterday as part of a troubleshooting effort with the Commerce support folks. Adding the info back in and connecting failed, and no connector setup was present.  This morning I added the Commerce app and after about an hour it did successfully import the info I needed.

 

There's been no feedback from the support team on my ticket yesterday, and no other updates.

I did try a 3rd party service as well, A2X, which successfully read a few months of shopify transactions.  It's very expensive though for what is basically an API gateway service, even with a discount code.  It also time limits what you can send over to 3 months on the basic service tier.

bradnic
Level 3

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

posting some screenshots that I hope will assist others.  I've also written to the QBO Commerce folks as I think the whole setup is unnecessarily confusing.  

 

1) This was my original setup for Shopify Balance import (shows as "Cash" tile)- a connector that appeared on the bank transactions page.  Shopify Balance transactions would appear on this tab.  This connector stopped working with the 571 and 350 errors people have reported.  This setup stopped working for me Oct 1 2023.

53485010326_bb875489f7_c

 

This is the new setup using the QBO Commerce app.  It does more than Shopify Balance - you see orders, payouts and a summary.  The payout transactions show up in the App transactions tab instead of the bank

transactions tab.  The old Cash / Shopify Balance connector on the bank transactions page is now gone.

53485012026_73a6318843_c

53485152018_31689b675b_c

from the Commerce menu you can now also access order info and a financial summary, which is quite nice.  Other sales channels supported by Commerce would show up too.

mikewiggins
Level 2

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

I have been using "Shopify Connector" and it does the same thing regarding pulling all sales and payout transactions into the commerce section.

 

What I am missing is the standard bank transactions, like paying my credit card bills from the Shopify Balance account,  and the current cash balance in the Shopify Balance account. Those are the transactions that were very helpful from an accounting standpoint that came in fine when connected through the traditional bank and credit card route. Does anyone know of either a paid or free solution to getting those kinds of transactions imported? Thanks!

 

 

 

bradnic
Level 3

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

@mikewiggins confirmed here as well. so clearly QBO Commerce is insufficient.  The previous Shopify Balance setup I had *did* transfer everything until it stopped working.

bradnic
Level 3

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

there is a paid app called A2X that works, but it's pricey for what it does.

https://a2xaccounting.com

 

mikewiggins
Level 2

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

I can’t stomach paying when every other bank account and credit card connects for free and it s simply a coding error that QB is unable to fix. It could be on the Shopify side but the evidence seems to point to QB.

 

Does anyone know anyone who is currently connected to Shopify Balance in the traditional way without a problem? 

bradnic
Level 3

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

still no updates from QBO

bradnic
Level 3

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

QBO team reached out.  They should have some news in the next biz day or two.

JSpiers667x
Level 3

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

Nice, that's good to hear. They still haven't reached out to me but I can't say I'm surprised. I wasn't terribly friendly with the Customer Service Agent I talked to on the phone. My patience didn't last long after having to repeatedly tell him to pull the microphone away from his mouth because he was eating it and I couldn't understand him.

bradnic
Level 3

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

still no word, still not working

goldentallow
Level 1

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

I am also having this issue.

goldentallow
Level 1

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

i'm having this issue also! 

 

THIS is a determining factor if I continue to use QuickBooks or a competitor so I hope you fix it asap. I am switching to Shopify Balance completely as my checking because they don't charge fees like Chase Business Banking. I have 2 QuickBook accounts. 

 

Thanks to everyone pushing to get QuickBooks to fix something that should absolutely be working. I refuse to pay a 3rd party and will just find a different platform. As someone mentioned, this is like not being able to connect any other bank like WellsFargo or any major credit card companies.

mikewiggins
Level 2

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

It still doesn't work but there seems to be a new message on the sign-in screen. I had already tried this several times. I would imagine this is a sign that Shopify and QB have been talking about this issue?

Screenshot_2024-01-31_at_7_37_01 AM.png

bradnic
Level 3

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

I do see that new info.  I also noticed the "immediate fail with a 571" behavior is different.  It takes several seconds to fail now, not immediate.  I still get the. blank dialog after logging in to Shopify.

bradnic
Level 3

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

 what really gets me is the lack of communication and poor documentation on error messages.  Still have no clue on what the 571 is for.  seems to be a 'something went wrong and we have no clue' message.  that leaves their support team in a terrible place.  in the meantime we're reading tea leaves.

 

I have no doubt shopify is partially responsible for the lack of progress here.  you call their support folks and they feign ignorance.  it's an INTERFACE.  there are two ends to it.  BOTH parties have support obligations here.

CGI2016
Level 2

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

Please fix it!

mikewiggins
Level 2

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

I would imagine that "Shopify Balance" is more like a stand-alone bank than an internal division of Shopify. This makes me wonder, does 'SB' have it's own support team? Or dies the standard Shopify team have to deal with things like this? The federal regulations regarding banking have got to be a whole different ball of wax in regards to data safety, etc. Has anyone had any luck feeling confident they are dealing with Shopify folks who are experts on the banking side? I have not.

bradnic
Level 3

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

Shopify Balance is from Evolve Bank & Trust

ShopPay is Stripe

they know what they're doing...

CGI2016
Level 2

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

It is an online bank covered just like any other bank by the FDIC up to $450,000.00. It just offers you easy access to your money, no fees, and good interest on balance. I hope Intuit gets it together or we will have to find another solution. When trying to connect to Shopify Balance Account it is the Intuit pop up window that is going blank and not verifying Shopify login. Customer support does not know what they are doing. They wanted me to add the Shopify connection to intuit. I already use a much better connection for my store. The part they can't get in there head is this is not store connection its Shopify Balance Bank Connection. I have pasted some info below in hope that someone from Intuit will be able to figure this out and resolve it very quick as we are not waiting months for an update. If it was not available to connect to Shopify Balance then it would not have it as a bank choice when trying to connect it to Intuit.

--------------------------------------------------------------------------------------------------------------------------------

Banking services provided by Evolve Bank & Trust. Money transmission services by Stripe Payments Company. Card products are issued by Celtic Bank and serviced by Stripe, Inc. and its affiliate Bootstrap Servicing, Inc. Use of Shopify Balance must be in accordance with the Terms of service.

Shopify rewards you with an Annual Percentage Yield (APY) on money in your Balance account(s). Rates can change without notice. APY is accrued daily, is compounded, and paid out into your Balance account(s) on the 5th of each month.

From Shopify:

Managing your Shopify Balance account
From the Shopify Balance home page, you can access your accounts, view statements, and transfer funds.

If you click an account from the Balance home page, then you can access your account details with the following information:

statements
cash flow insights for that specific account
Balance card associated with the account and your cashback rewards, if applicable
You can also transfer funds from your account details page.

To learn more about your Shopify Balance card, refer to managing your card. To learn more about earning annual percentage yield (APY) and other rewards programs, refer to the Shopify Balance rewards.

Shopify doesn't charge any fees for using your Balance card, but ATM provider fees may apply. You can find more information about fees in your Terms of Service.

On this page
Shopify Balance account requirements
Set up your account
Manage your account
Receiving payouts with a Shopify Balance account
Changing your payout account
Connecting to third-party apps
Enabling low balance alerts
Allow staff to view Balance account activity
Cash flow insights
Shopify Balance account requirements
Shopify Balance accounts are not available to all merchants. To open a Shopify Balance account, you need to meet the following requirements:

be a store based in the United States or Puerto Rico (other United States territories are not supported)
have Shopify Payments set up or sign up for Balance when signing up for Shopify Payments
have a valid US Social Security Number (SSN)
have a single account owner for Shopify Payments
the Legal Representative must have a physical personal address in the United States or Puerto Rico (other United States territories are not supported).
be on any Shopify plan except for Shopify Plus
not be a prohibited business, as outlined in Stripe's Prohibited and Restricted Businesses.
Note
You must activate two-step authentication to use your Shopify Balance account.

Set up your account
If you're eligible for a Shopify Balance account and have not yet activated Shopify Payments, then an account is created for you when you set up Shopify Payments. If you're eligible and already using Shopify Payments, then you can use the following steps to set up your Balance account.

Steps:
From your Shopify admin, go to Finances > Balance.

Click Open account.

Review your Shopify Payments information, and then click Confirm.

Enter your SSN and mobile number, then click Confirm.

Check the box to confirm that you agree with the Shopify Balance Account Agreement and the Shopify Balance Card Agreement, including financial institution partner privacy policies and E-SIGN disclosure, then click Open account.

After your Shopify Balance account is set up, it becomes the account connected to your Shopify Payments account. Your payouts will be deposited into your main Shopify Balance account, including any financing that you receive through Shopify Capital.

Note
If eligible, then you'll automatically receive a Balance account and spending card when activating Shopify Payments for the first time.

Caution
Because your Shopify Balance account is connected to your Shopify Payments account, any Shopify Capital remittances or repayments that you need to pay are also withdrawn from Shopify Balance. If you have financing through Shopify Capital, then ensure that there are funds in your account to pay for remittances or repayments by either transferring funds to Shopify Balance or changing your payout account.

Manage your account
After you have set up your account, you can perform any management tasks from the Shopify Balance page.

Add an additional Shopify Balance account
You can create up to 5 additional accounts for your Shopify Balance.

Steps:
From your Shopify admin, go to Finances > Balance.

Click Add account.

Enter a name for the account.

Click Create account.

Learn more about multiple accounts with Shopify Balance.

View your Shopify Balance account information
You can view your account number and your routing number.


Desktop
Steps:
From your Shopify admin, go to Finances > Balance.

Click an account.

Click Manage account.

Click Show details.


iPhone

Android
For security reasons, you might receive a prompt to authenticate your account again.

View your Shopify Balance account statements
You can view your monthly account statements.

Steps:
From your Shopify admin, go to Finances > Balance.

On the Account activity card, click View statements.

Select the statement to view. The statement opens in a new tab.

Receiving payouts with a Shopify Balance account
After you sign up for a Shopify Balance account, your main account is automatically set as your Shopify Payments payout account. Using your main Balance account, you can receive your Shopify Payments earnings in as little as one business day from the transaction processing date. Business days don't include weekends or US holidays.

Note
If you have Shop Pay Installments active and your customer uses it during their checkout, then the payout takes up to three business days.

Changing your payout account
You can change the account that your Shopify Payments earnings are deposited into at any time.

Steps:
From your Shopify admin, go to Finances > Balance.

Select your payout account.

On the Account details page, click Manage account.

On the Shopify Balance account page, click Change payout account.

Enter your new account information, and then click Save.

On the Change payout account dialog, select a reason for changing accounts from the drop-down menu, and then click Confirm.

Follow the prompts to complete two-factor authentication.

Click Done.

Note
Changing your payout account to a third-party account doesn't close your Shopify Balance account. You can still use any active Shopify Balance payment cards and collect Shopify Balance rewards on transactions made with your Shopify Balance account.

Caution
Changing your payout account might cause delays in your Shopify Payments payouts.

Connecting to third-party apps
Through our integration with Plaid, you can connect your Shopify Balance account to third-party apps, such as Venmo, Wise, Freshbooks, Bench and more to enable you to do even more with your account, like send money, make payments directly to vendors, keep track of expenses and sync Balance with your preferred accounting software. For more information about which third-party apps you can connect to, refer to the Plaid apps page.

Note
You must activate two-step authentication to connect your Shopify Balance account to a third-party app.

Steps:
Log in to the third-party app and follow the steps to set up a payment method.
Select to add a bank and to instantly verify your account by logging in.
Select Shopify Balance account.
From the login screen, log into your Shopify store.
In the third-party app, complete the steps to connect your account.
Enabling low balance alerts
When you have low balance alerts activated, you are sent an email when your account balance drops below a preset value. The default value is 100. Alerts are only available on the main account.

Steps:
From your Shopify admin, go to Finances > Balance.

On the Shopify Balance page, click Manage account.

Under Notifications, click the toggle to activate or deactivate low balance alerts.

Optional: Click Change amount to change the account balance value that will trigger a low balance alert.

Allow staff to view Balance account activity
You can give a permission to your staff members to view Shopify Balance transactions and the amount available to spend.

Staff members with this permission can't do the following actions:

transfer funds
order and manage cards
view account details
manage account settings
view statements
move money between Balance accounts
create new accounts
Steps:
From your Shopify admin, click Settings > Users and permissions.
Click the staff member who you want to give the permission to.
In the Permissions section, select View Balance account activity.
Click Save.
Cash flow insights
The cash flow insights overlay displays an at-a-glance view of your cash flow for the last two months. You can compare your income to your spending to see if you are earning or losing money. Cash flow insights breaks down your spending into the your top five spending categories so that you can ensure that your money is being spent where it should be. You can also view the total on your upcoming Shopify bill.

Cash flow insights are available on the Balance home page for all accounts. If you click into an account, then cash flow insights will display for only that account.

For a more detailed overview of your store's finances, refer to the Finances overview.

Note
Cash flow insights only tracks transactions made with your Shopify Balance account. Any transactions made with external accounts are not reflected in this report.

Steps:
From your Shopify admin, go to Finances > Balance.

Optional: Select an account to view the cash flow insights for that account only.

Under Cash flow this month, click View all insights.

CGI2016
Level 2

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

It is an online bank covered just like any other bank by the FDIC up to $450,000.00. It just offers you easy access to your money, no fees, and good interest on balance. I hope Intuit gets it together or we will have to find another solution. When trying to connect to Shopify Balance Account it is the Intuit pop up window that is going blank and not verifying Shopify login. Customer support does not know what they are doing. They wanted me to add the Shopify connection to intuit. I already use a much better connection for my store. The part they can't get in there head is this is not store connection its Shopify Balance Bank Connection. I have pasted some info below in hope that someone from Intuit will be able to figure this out and resolve it very quick as we are not waiting months for an update. If it was not available to connect to Shopify Balance then it would not have it as a bank choice when trying to connect it to Intuit.

--------------------------------------------------------------------------------------------------------------------------------

Banking services provided by Evolve Bank & Trust. Money transmission services by Stripe Payments Company. Card products are issued by Celtic Bank and serviced by Stripe, Inc. and its affiliate Bootstrap Servicing, Inc. Use of Shopify Balance must be in accordance with the Terms of service.

Shopify rewards you with an Annual Percentage Yield (APY) on money in your Balance account(s). Rates can change without notice. APY is accrued daily, is compounded, and paid out into your Balance account(s) on the 5th of each month.

From Shopify:

Managing your Shopify Balance account
From the Shopify Balance home page, you can access your accounts, view statements, and transfer funds.

If you click an account from the Balance home page, then you can access your account details with the following information:

statements
cash flow insights for that specific account
Balance card associated with the account and your cashback rewards, if applicable
You can also transfer funds from your account details page.

To learn more about your Shopify Balance card, refer to managing your card. To learn more about earning annual percentage yield (APY) and other rewards programs, refer to the Shopify Balance rewards.

Shopify doesn't charge any fees for using your Balance card, but ATM provider fees may apply. You can find more information about fees in your Terms of Service.

On this page
Shopify Balance account requirements
Set up your account
Manage your account
Receiving payouts with a Shopify Balance account
Changing your payout account
Connecting to third-party apps
Enabling low balance alerts
Allow staff to view Balance account activity
Cash flow insights
Shopify Balance account requirements
Shopify Balance accounts are not available to all merchants. To open a Shopify Balance account, you need to meet the following requirements:

be a store based in the United States or Puerto Rico (other United States territories are not supported)
have Shopify Payments set up or sign up for Balance when signing up for Shopify Payments
have a valid US Social Security Number (SSN)
have a single account owner for Shopify Payments
the Legal Representative must have a physical personal address in the United States or Puerto Rico (other United States territories are not supported).
be on any Shopify plan except for Shopify Plus
not be a prohibited business, as outlined in Stripe's Prohibited and Restricted Businesses.
Note
You must activate two-step authentication to use your Shopify Balance account.

Set up your account
If you're eligible for a Shopify Balance account and have not yet activated Shopify Payments, then an account is created for you when you set up Shopify Payments. If you're eligible and already using Shopify Payments, then you can use the following steps to set up your Balance account.

Steps:
From your Shopify admin, go to Finances > Balance.

Click Open account.

Review your Shopify Payments information, and then click Confirm.

Enter your SSN and mobile number, then click Confirm.

Check the box to confirm that you agree with the Shopify Balance Account Agreement and the Shopify Balance Card Agreement, including financial institution partner privacy policies and E-SIGN disclosure, then click Open account.

After your Shopify Balance account is set up, it becomes the account connected to your Shopify Payments account. Your payouts will be deposited into your main Shopify Balance account, including any financing that you receive through Shopify Capital.

Note
If eligible, then you'll automatically receive a Balance account and spending card when activating Shopify Payments for the first time.

Caution
Because your Shopify Balance account is connected to your Shopify Payments account, any Shopify Capital remittances or repayments that you need to pay are also withdrawn from Shopify Balance. If you have financing through Shopify Capital, then ensure that there are funds in your account to pay for remittances or repayments by either transferring funds to Shopify Balance or changing your payout account.

Manage your account
After you have set up your account, you can perform any management tasks from the Shopify Balance page.

Add an additional Shopify Balance account
You can create up to 5 additional accounts for your Shopify Balance.

Steps:
From your Shopify admin, go to Finances > Balance.

Click Add account.

Enter a name for the account.

Click Create account.

Learn more about multiple accounts with Shopify Balance.

View your Shopify Balance account information
You can view your account number and your routing number.


Desktop
Steps:
From your Shopify admin, go to Finances > Balance.

Click an account.

Click Manage account.

Click Show details.


iPhone

Android
For security reasons, you might receive a prompt to authenticate your account again.

View your Shopify Balance account statements
You can view your monthly account statements.

Steps:
From your Shopify admin, go to Finances > Balance.

On the Account activity card, click View statements.

Select the statement to view. The statement opens in a new tab.

Receiving payouts with a Shopify Balance account
After you sign up for a Shopify Balance account, your main account is automatically set as your Shopify Payments payout account. Using your main Balance account, you can receive your Shopify Payments earnings in as little as one business day from the transaction processing date. Business days don't include weekends or US holidays.

Note
If you have Shop Pay Installments active and your customer uses it during their checkout, then the payout takes up to three business days.

Changing your payout account
You can change the account that your Shopify Payments earnings are deposited into at any time.

Steps:
From your Shopify admin, go to Finances > Balance.

Select your payout account.

On the Account details page, click Manage account.

On the Shopify Balance account page, click Change payout account.

Enter your new account information, and then click Save.

On the Change payout account dialog, select a reason for changing accounts from the drop-down menu, and then click Confirm.

Follow the prompts to complete two-factor authentication.

Click Done.

Note
Changing your payout account to a third-party account doesn't close your Shopify Balance account. You can still use any active Shopify Balance payment cards and collect Shopify Balance rewards on transactions made with your Shopify Balance account.

Caution
Changing your payout account might cause delays in your Shopify Payments payouts.

Connecting to third-party apps
Through our integration with Plaid, you can connect your Shopify Balance account to third-party apps, such as Venmo, Wise, Freshbooks, Bench and more to enable you to do even more with your account, like send money, make payments directly to vendors, keep track of expenses and sync Balance with your preferred accounting software. For more information about which third-party apps you can connect to, refer to the Plaid apps page.

Note
You must activate two-step authentication to connect your Shopify Balance account to a third-party app.

Steps:
Log in to the third-party app and follow the steps to set up a payment method.
Select to add a bank and to instantly verify your account by logging in.
Select Shopify Balance account.
From the login screen, log into your Shopify store.
In the third-party app, complete the steps to connect your account.
Enabling low balance alerts
When you have low balance alerts activated, you are sent an email when your account balance drops below a preset value. The default value is 100. Alerts are only available on the main account.

Steps:
From your Shopify admin, go to Finances > Balance.

On the Shopify Balance page, click Manage account.

Under Notifications, click the toggle to activate or deactivate low balance alerts.

Optional: Click Change amount to change the account balance value that will trigger a low balance alert.

Allow staff to view Balance account activity
You can give a permission to your staff members to view Shopify Balance transactions and the amount available to spend.

Staff members with this permission can't do the following actions:

transfer funds
order and manage cards
view account details
manage account settings
view statements
move money between Balance accounts
create new accounts
Steps:
From your Shopify admin, click Settings > Users and permissions.
Click the staff member who you want to give the permission to.
In the Permissions section, select View Balance account activity.
Click Save.
Cash flow insights
The cash flow insights overlay displays an at-a-glance view of your cash flow for the last two months. You can compare your income to your spending to see if you are earning or losing money. Cash flow insights breaks down your spending into the your top five spending categories so that you can ensure that your money is being spent where it should be. You can also view the total on your upcoming Shopify bill.

Cash flow insights are available on the Balance home page for all accounts. If you click into an account, then cash flow insights will display for only that account.

For a more detailed overview of your store's finances, refer to the Finances overview.

Note
Cash flow insights only tracks transactions made with your Shopify Balance account. Any transactions made with external accounts are not reflected in this report.

Steps:
From your Shopify admin, go to Finances > Balance.

Optional: Select an account to view the cash flow insights for that account only.

Under Cash flow this month, click View all insights.

CGI2016
Level 2

I am struggling with connect between Shopify Balance and Quickbook Online. how do you make both linked?

Unfortunately it does not login so we can't set it up. Goes as far as username, password, and code then you hit enter and the pop up goes blank and does nothing from there.

Need to get in touch?

Contact us