Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
F
feline99
March 8, 2019
Question

Matching Square Transactions

  • March 8, 2019
  • 1 reply
  • 2 views

Working in QB Online and I have several thousand dollars in Undeposited Funds from Square, from over 1,000 small individual sales transactions.

 

The Square deposits were manually entered and the bank account has been reconciled.

 

I was planning to delete the manually entered deposits, then match the transactions to the deposits, then re-reconcile, but I’m not familiar with how it works exactly.  Will QB recognize each deposit by date and automatically select the corresponding transaction included in each deposit? Each deposit contains 50 - 100 individual sales.

If anyone had any other ideas/solutions, I’m open to suggestions.

1 reply

R
RaymondJayOQuickBooks Team
QuickBooks Team
March 8, 2019

You've come to the right place, @feline99. 

 

I'll help ensure you're able to re-reconcile your Square sales transactions. 

 

Yes, you can delete the manual deposits in QuickBooks Online (QBO). Here's how to find and delete them: 

 

  1. Go to the Gear icon at the upper right. 
  2. Under Your Company, select Chart of Accounts.
  3. Locate the account in the Chart of Accounts.
  4. From the Action column, select View Register.
  5. Select the deposit, and select Edit to open it.
  6. Make a note of all the payments in the deposit, or select Print from your browser menu to print a copy of the entire page for easy reference.
  7. Select More, then choose Delete. 

After that, you'll need to recreate the deposit from the Undeposited Funds. This way, QBO will recognize the deposits and you can match them to your downloaded transactions. Here's how: 

 

  1. Go to the Plus icon (+) at the upper right. 
  2. Under Other, select Bank Deposit. 
  3. Select the Date and add all the payments that were on the original deposit. 
  4. Choose Save and close. 

 

Once done, QBO analyzes all the information received from the bank for each downloaded transaction to give you the best possible suggestions for accepting the transaction. You'll need to manually review and accept a downloaded transaction. Here's how: 

 

  1. From the left menu, select Banking, and choose Banking.
  2. On the For Review tab, select a transaction to open it.
  3. The Description column entry indicates the type of transaction.
  4. Verify that the Payee, Category, Class, and Location you specified for the transaction are accurate.
  5. Select Add.

Then, you can also mark "R" the transactions to the Bank register to help fix the reconciliation balances. For more information about reconciliation in QBO, here's an article you can check out: Reconcile Accounts. 

 

The steps above will help you achieve your goal, @feline99. Should you have additional questions about this reconciliation process, please get back to me by leaving a reply below. I'm always here to help you out. Stay positive always!

P
panda88
March 9, 2019

Thank You Raymond

<<Go to the Plus icon (+) at the upper right.  Under Other, select Bank Deposit.  Select the Date and add all the payments that were on the original deposit.  Choose Save and close. >>

 

The manual deposits were entered as a lump sum, not using each individual sale as it appears in Undeposited Funds.

Selecting payments from Undeposited Funds doesn't produce a total that is even moderately close to what the deposit amount should be.  Random amounts show in Undep. Funds as 'Deposited' under the Reconciliation Status column, yet transactions above and below for the same date show as blank in in the same status column.

I'm perplexed.

R
Rasa-LilaMQuickBooks Team
QuickBooks Team
March 9, 2019

Welcome back to the Online Community, panda88.


I appreciate for sharing additional details. This gives me a quick overview of what exactly happened to the transactions.


I can help ensure your financial records are in tiptop shape. To resolve the issue, you’ll have to manually open each invoice and unlink the payment.


Here’s how:

 

 

  1. Go to Sales on the left panel, then choose Customers.
  2. Select the customer you’re working on.
  3. Mark the box of the invoice you’re working on, then click on it.
  4. Click 1 payment under the PAID status, then click on the Date link.
  5. In the Receive Payment page, click on the Clear Payment button.
  6. Choose Save and close.
  7. Click Yes to confirm.

Once done, you can now match the transactions to the correct deposits and re-reconcile your account.


Before doing so, make sure to unreconcile the transactions first. I’ve laid out the steps below:

 

  1. Go to Accounting on the left panel.
  2. Select the bank you’re working on, then click View register.
  3. Click the Funnel icon to filter the dates, then choose Apply.
  4. Locate and click the transaction, one at a time.
  5. Between the Deposit and Balance (USD) columns, keep clicking the R field until the status changes to blank (unreconciled) or C (cleared).
  6. Click Save.

 

You’ll find more information in this article: Clear, unclear, reconcile or unreconcile transactions. If you’re an accountant, the Undo Reconciliation tool will help you unreconciled transactions by batch.

 

These steps should get you pointed in the right direction.


Reach out to me if you have additional questions. Please know I’m just a comment away for help. Have a great rest of your day!

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement