Skip to main content
J
JessyM
June 14, 2022
Question

Deposit and Journal Entry matching

  • June 14, 2022
  • 2 replies
  • 0 views

Good evening,

 

I currently use QBO.  I use Shopify POS as my point of sale system, within Shopify, I have an app called A2X that I push my payouts into QuickBooks Online in the form of a Journal Entry.

 

When the credit card transactions get sent over, they auto match together without a problem.  However, when I do my cash & check payouts, the journal entry is created but it is not matching up with the bank deposit.  I see the Deposit on the banking screen, click on "find match" choose "journal entries" but nothing is found.  I can also find the individual journal entry that matches the amount of the deposit but I cannot find a way to link them together.  Anyone know how I can get them to match and/or get the journal entries to pull up when I try to find the match since it isn't finding them on its own to suggest it?

 

Thank you!

Jessica

2 replies

L
LollyNino_C
June 14, 2022

Hello there, @Jessica. 

 

Thanks for joining the Community. I'd be happy to lend a hand with matching transactions.

 

Let's match the check with the journal entry you've already added in QuickBooks Online.

 

Before proceeding, here are a few reasons the match may not have been recognized:

  • The JE was recorded in a different bank account.
  • The JE has been reconciled.
  • The JE has been previously matched to another bank downloaded transaction.

You may want to double-check again that the date, amount, and category, and check numbers of the entries are aligned. This is to make sure those checks will match. In the Match transactions window, we can filter it to see only the journal entries. This is the easiest way to find and match it. You can follow these steps:

  1. Go to Banking, select the transaction, and click Match.
  2. From the Match transactions page, select Journal Entries under Show drop-down.
  3. Make sure the From and To date are correct.
  4. Locate the journal entry, check, then Save.

 

For more in-depth information about finding a match in QuickBooks, refer to these articles: 

I want to ensure that you're able to match these transactions, so please let me know how it goes by posting a comment below. Hoping this response finds you with a smile.

Rainflurry
Rainflurry
June 14, 2022

@JessyM 

 

When you look at the journal entry created by A2X, is it assigning your cash and check payouts (debits) to the appropriate bank account and not to a clearing account or some other account? 

J
JessyMAuthor
June 14, 2022

Thank you for your response and your assistance!  I do see in the datafile in quickbooks that it is a "Shopify clearing" account.  Do you know how I can fix that?  And how do I go back and fix those last payout so they connect to the deposit?

 

Thank you,

Jessica

D
Dr_Safari
March 14, 2024

Hi Jessica,

 

I'm having the exact same issue. Have you been able to resolve this? I would appreciate your response.

 

Thank you,

Meisam

Terms & ConditionsAccessibility statement