cancel
Showing results for 
Search instead for 
Did you mean: 
Arbooks1
Level 2

Timing with Matching Square Deposits with QBO

I have a client that has QBO synced with Square and operates under the accrual method. Deposits from Square do get matched properly to the bank feeds in QBO but the issue is the timing of revenue recognition which is causing both under and overstatements of revenue. For example, a deposit for June sales gets deposited in July - which QBO recognizes as July income instead of June income. 

 

Is there a way to have QBO recognize a deposit from Square on a different month to properly match the income earned for that month?

 

 

1 Comment 1
RoxanneB
QuickBooks Team

Timing with Matching Square Deposits with QBO

I'll assist your client on how to match bank deposits and revenue recognition in QuickBooks, Arbooks1.

 

Once your client adds a Square transaction from the App transactions page in QuickBooks, it automatically creates a sales receipt and a deposit link to each other. They can now match them on the Bank transaction page. While this is acceptable in a cash-based accounting business, it can change the timing of revenue recognition in an accrual-based accounting business.

 

Since the reconciliation of Square transaction on the bank transaction page is done. Follow these steps to record the invoice payments, and ensure that each of these is posted in Undeposited Funds:

 

  1. Navigate to the + New button. Then, Receive payment.
  2. Select a Customer from the drop-down list.
  3. Enter the Payment Date and choose the appropriate Payment Method.
  4. Choose from Undeposited Funds in the Deposit To drop-down list.
  5. Place a checkmark for the corresponding invoice/s.
  6. Hit Save and close.
  7. Repeat these Steps 1 to 6 for the rest of the invoices.

 

Next, update the deposit record in your bank account. During this process, we'll need to unlink the Sales Receipt associated with the deposit and link it to the recorded invoice payment.

 

  1. In the upper right corner, click on the Gear icon.
  2. Choose Chart of accounts.
  3. Find the bank account where the Square transactions are posted after the matching process. Then, select View register.
  4. Locate the corresponding deposit transaction at issue. To help in this task, click the Funnel icon and choose Deposit from the Transaction type drop-down list.
  5. Select the deposit transaction. Then, hit Edit.
  6. Uncheck the sales receipt linked to it and place a checkmark for the invoice payment.
  7. Hit Save and close.

 

Finally, we can now proceed to delete the sales receipt that was previously linked with the deposit. Check linked attached for the steps.

 

Your client can also consider connecting only their bank and matching it to your recorded invoice in QuickBooks.

 

Once they're ready, here's a link that can help you reconcile and review your transactions in QBO:

 

 

If you have any more questions about managing banking transactions, drop a reply and we'll be here to assist you. Take care.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us