Skip to main content
W
weslaughton
January 16, 2023
Question

Matching payouts in QB online

  • January 16, 2023
  • 1 reply
  • 0 views

Hi~ I am trying to match transactions with payouts. My bank is linked with QB and all payments from Shopify are synced with QB online. oneSaas had to resync my account as we switched bank accounts of where the payments were being deposited. Since the new resync, I am now not able to match transactions with payouts. It says not transactions can be found. Can someone please help? 

QB chat gave me these suggestions 

To settle your accounting, add each payout to your accounts. We'll help you match each transaction to your bank deposits.

1 reply

S
SarahannC
January 16, 2023

Hello there, weslaughton.

 

I can help you get the transactions and match them accordingly in QuickBooks Online.

 

QuickBooks always depends on what your bank share with us. Since you've updated a bank account, we can manually disconnect and reconnect the application to refresh the system and its connection within QuickBooks. If you haven't tried it, here's how: 

 

  1. Go to the App menu and select My apps.
  2. Choose Shopify and click Disconnect.
  3. Once done, we'll have to go back to the Apps section. 
  4. Find and install Shopify Connector by QuickBooks. 
  5. Select Connect.
  6. You be redirected to the Connections tab in QuickBooks Connector (OneSaas).
  7. A new page will pop up on your screen. It will ask you to enter the domain URL. Once done, select Connect to Shopify.
  8. Follow the on-screen instruction to complete the process.

 

If you got the same outcome, let's review the transactions by accessing an incognito window. This mode doesn't store cache and old files, which helps us use QuickBooks efficiently.

 

  • For Chrome, press and hold Ctrl + Shift + N.
  • For Firefox, press and hold Ctrl + Shift + P.
  • For Safari, press and hold Command + Shift + N

 

If still the transactions aren't recorded within QuickBooks, we can follow the suggestion shared by our chat support in the meantime. This can keep your bank data accurate from what you have in your provider or bank statement.
 

I've gathered these articles about organizing bank transactions and reconciling accounts in QBO:

 


Please let me know if you have more concerns about syncing applications and transactions. I'll be around to help a hand anytime. Also, you can post another one below if you've seen other errors while doing this task. Take care and stay safe. 

W
weslaughtonAuthor
January 16, 2023

Thank you for your help. I was able to reconnect to Shopify and the payments were imported into QB and they could be matched. 

 

It is a bit different now as all of the deposit/payment information is appearing in the “app transactions” portion of the banking area. When I do to this section I can then click add and the transaction is automatically matched to the transactions imported from the bank account. I wanted to confirm if the payout information (deposit, invoice #, sales tax, shipping, refunds)will appear in the reconcile area or appear in the account if my accountant needs to review? I used to manually input this information, so it would be amazing and save me so much time if this information is automatically added. Please see below. THnaks, Wes

LieraMarie_A
LieraMarie_A
January 16, 2023

I'm glad you're able to reconnect Shopify to QuickBooks Online successfully, @weslaughton.

 

Your Shopify payouts will be matched against deposits in the bank feeds. Payout info depends on what's acquired from the app. You'll want to verify it by clicking the link under the Added/Matched column. 

 

Here's how:

 

  1. Go to Banking and select App transactions.
  2. In the Reviewed tab, open a transaction by clicking the link under the Added/Matched column.
  3. You may add any necessary info. 
  4. Click Save and close.

 

You may also review your transactions or make quick edits right from your account register. It has filtering and sorting tools that speed up your search.

 

Additionally, these transactions are already marked on the Reconciliation page, speeding up the bank reconciliation process. The screenshot below shows you the available columns you can view or add.

 

Let me know if you need more help and if you make any discoveries along the way! I'd love to chat about it. 

Terms & ConditionsAccessibility statement