cancel
Showing results for 
Search instead for 
Did you mean: 
DLA2016
Level 1

Bank reconciliation

I have several checks that cleared (one in August and one in November 2018) and now appear uncleared when doing February 2019 bank reconciliation.  

 

Help I don't know what to do!!

 

 

3 Comments 3
SophiaAnnL
Moderator

Bank reconciliation

You have two options to fix this, DLA2016.

 

Before you begin, it would be best to back up your company file first. This is to ensure that your current data file is securely saved.

 

Your options to resolve the discrepancy would be to undo the previous reconciliation or leave it as it is. If you chose the latter, the transaction will show as cleared on the report once the statement date has been reached.

 

Here's how to undo the reconciliation:

  1. Click Banking at the top, and then click Reconcile.
  2. In the Begin Reconciliation window, select the appropriate account then click Undo Last Reconciliation.
  3. Click Continue when prompted to back up your company file.
  4. Click OK when the message Undo Previous Reconciliation has completed displays. Note that the last reconciled on date has reverted to the previous date.
  5. Reconcile the transactions again.

I'll be here if you need a hand with the reconciliation. Just let me know by leaving a reply.

es122532
Level 1

Bank reconciliation

Help me please.

The customer has a zero beginning balance which is not suppose to be zero.

RaymondJayO
Moderator

Bank reconciliation

Thanks for posting here in the Community, @es122532

 

It could be you have not entered an opening balance when you set up the customer. This is likely the reason your customer has a zero beginning balance. 

 

To help fix this, let's perform some steps for the two scenarios. If this is a new customer, you can add the opening balance in the Opening Balance section under the Customer Name. This creates an invoice posting to your Accounts Receivable and Uncategorized Income accounts. See the screenshot below for your visual reference. 

AddOpeningBalance.PNG

 

However, if this is an existing customer, you'll have to record an invoice to add the balance. Let's first create an item with an Uncategorized Income account. Here's how: 

  1. Go to Lists from the top menu.
  2. Select Item List.
  3. Click the Item drop-down, then choose New
  4. Select Service as an item type.
  5. Enter Opening Balance as the Item Name/Number
  6. Choose Uncategorized Income beside Account.
  7. Click OK.

The screenshot below shows you the last four steps. 

CreateAnItem.PNG

 

After that, create an invoice and choose the appropriate customer. Then, select the item you just added and enter the beginning balance. Once saved, the balance is now added to your customer. 

 

You can run any customer, job, and sales reports. These reports allow you to easily keep track of your sales and accounts receivable in the program. 

 

I'll be right here to help if you need further assistance. Have a great day, @es122532

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

Need to get in touch?

Contact us