how to reconcile square in quickbooks

Reconcile Square to QuickBooks: A Step-by-Step Guide

By Joseph Robinson
AD

Are you a business owner struggling to reconcile your Square transactions in QuickBooks? You're not alone. Many entrepreneurs find it challenging to keep their records up-to-date and error-free. But don't worry, we've got a comprehensive guide to help you master this process.

First, ensure that you have connected your Square account to your QuickBooks Online account. This will allow you to import your Square transactions directly into QuickBooks. If you haven't done this yet, follow the steps in the Square Connect app to sync your accounts.

Reconciling Square Deposits

Now, let's dive into reconciling your Square deposits in QuickBooks. This is an essential step to ensure your financial records are accurate and up-to-date.

AD
Learn to Reconcile in QuickBooks Online
Learn to Reconcile in QuickBooks Online
The Quick Start Guide to QuickBooks - Small Business Sarah
The Quick Start Guide to QuickBooks - Small Business Sarah
Set Up QuickBooks the Right Way Avoid Common Mistakes
Set Up QuickBooks the Right Way Avoid Common Mistakes

After syncing your accounts, QuickBooks will import your Square deposits. However, these deposits might not match the amount shown in your bank account due to fees or delayed deposits. To reconcile, follow these steps:

Step 1: Check for Missing Deposits

First, ensure that all Square deposits have been imported into QuickBooks. If any are missing, you can manually add them as income.

Common Mistakes in QuickBooks and Solutions for Reconciliation Discrepancies in QBO
Common Mistakes in QuickBooks and Solutions for Reconciliation Discrepancies in QBO
How to Create an Invoice in QuickBooks - Blog
How to Create an Invoice in QuickBooks - Blog

To do this, go to the '+' icon at the top of any list in QuickBooks, select 'Income', then 'Sales Receipt'. Enter the deposit details, including the date, customer, and amount, then save.

Step 2: Match and Clear Deposits

Next, match the Square deposits in QuickBooks to the corresponding deposits in your bank account. You can do this manually or use the '_match' function in QuickBooks.

AD

To use the 'match' function, go to the 'Banking' tab, select the relevant bank account, then click 'Match’. QuickBooks will suggest matches based on the deposit amounts. Review the suggested matches, then click 'Match’ to clear the deposits.

Reconciling Square Payments

Now, let's look at reconciling your Square payments. This involves matching the payments in QuickBooks to the corresponding invoices or sales receipts.

After syncing your Square account with QuickBooks, any new payments will automatically be added to the open invoices. However, you might need to manually match them. Here's how:

AD

Step 1: Check for Unmatched Payments

Go to the '+' icon at the top of any list in QuickBooks, select 'Payments', then 'Unmatched payments'. This will show any payments that haven't been matched to an invoice or sales receipt.

Review the list and click on any unmatched payment to view its details. You can then match it to the corresponding invoice or sales receipt.

Step 2: Confirm the Match

After matching the payment, QuickBooks will ask you to confirm. If the match is correct, click 'Yes, match'. If not, click 'No, leave as unmatched' and try again.

AD

Regularly reconciling your Square transactions in QuickBooks ensures that your financial records are accurate and helps you identify any discrepancies early. This not only saves you time but also helps you maintain a healthy cash flow. So, why wait? Start reconciling today!

AD