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.
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:
Go to the Gear icon at the upper right.
Under Your Company, select Chart of Accounts.
Locate the account in the Chart of Accounts.
From the Action column, select View Register.
Select the deposit, and select Edit to open it.
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.
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:
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.
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:
From the left menu, select Banking, and choose Banking.
On the For Review tab, select a transaction to open it.
The Description column entry indicates the type of transaction.
Verify that the Payee, Category, Class, and Location you specified for the transaction are accurate.
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!
<<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.