Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
Rasa-LilaM
QuickBooks Team

Reply to message

Thank you for turning to the Community regarding your reconciliation concern, Sweetchickie.

 

I understand the inconvenience caused by this issue, which prevents you from reconciling your account. Let's work together to troubleshoot and resolve this, ensuring you can continue balancing your account seamlessly. 

 

Before we start, can you specify whether you're using QuickBooks Online (QBO) or QuickBooks Desktop for Mac? This is to check if there's an existing investigation regarding any missing transactions during the reconciliation process.

 

While we wait for the information, let me guide you on how to handle this in each QuickBooks platform. In the online version, we need to filter the data on the Reconcile page to see it correctly.

 

Here's how:

 

  1. Open your QBO company, navigate to the Transactions menu on the left panel, and choose Reconcile
  2. Click the Account drop-down and choose the correct bank or credit card account. 
  3. Check the beginning balance and make sure the information in QuickBooks matches with the one in your statement.
  4. Type the ending balance and ending date on your statement.
  5. Review the last statement ending date (end date of your last reconciliation). 
  6. Click the Start reconciling or Resume reconciling button when you're ready.
  7. On the Reconcile page, press the Funnel icon to set the correct information in the following fields: Find, Cleared statusTransaction typePayee, and Date.
  8. Tap the Apply for the changes to take effect. 

After setting up everything, let's proceed with reconciling the account. Should you encounter any hurdles or notice any discrepancies in your account, I have resources available to guide you on how to handle the situation. Simply open each link to know the full details:

 

 

For QuickBooks Desktop (QBDT) Mac users, let's uncheck the Hide transactions after statement end date box to show all transactions. Before troubleshooting, create a backup copy of the company file to prevent accidental loss. When you're ready, follow these steps to carry out this task:

 

  1. In your company file, go to the Banking menu at the top bar and choose Reconcile.
  2. The Begin Reconcile window appears.
  3. In the Account to Reconcile field, choose the account you're working on.
  4. Enter the statement date from your account statement in the Statement Date field and type the ending balance on your account statement into the Ending Balance field. 
  5.  Type the amount of that fee into the Service Charge Amount field and input the date your bank charged you the fee.
  6. Click OK
  7. On the Reconcile page, go to the bottom part and untick the Hide transactions after statement end date box.

For more in-depth information, take a look at this article: Reconcile accounts in QuickBooks for Mac. It includes instructions on how to deal with any discrepancy issues.

 

Moreover, you can download this link to gain access to our online resources: User's Guide. It covers topics about taxes, inventory, cash flow management, and banking-related activities such as reconciling your account, writing checks, and making deposits to name a few. 

 

Stay in touch if you have additional concerns or questions about reconciling your account. I'll get back to provide the help you need. Have a good one, Sweetchickie.

Need to get in touch?

Contact us