cancel
Showing results for 
Search instead for 
Did you mean: 
k-wright-aps
Level 1

How do I change the beginning amount when reconciling?

 
8 Comments 8
Kristine Mae
Moderator

How do I change the beginning amount when reconciling?

I've got your back, k-wright-aps.

 

Let's get the beginning balance changed/corrected.

 

If the account has never been reconciled, here's how you can change it:

  1. Click Accounting, then choose Chart of Accounts.
  2. Look for the bank account, click the View register drop-down arrow, then choose Edit.
  3. Change the amount in the Balance field, then click Save and Close.

If it has been previously reconciled, here are the most common causes of the discrepancy:

  • A previously reconciled transaction is deleted.
  • A reconciliation status is changed in the register.
  • The opening balance is incorrect.

You can check this article for the steps on how to fix it: Make an incorrect reconcile opening balance match the bank statement.

 

I'm just around if you need more help. Just tag me and I'll get back to you as soon as I can. 

qUICKENWORKER
Level 1

How do I change the beginning amount when reconciling?

i HAVE THE RIGHT AMOUNT IN QUICKEN TO START RECONCILING MY ACCOUNT.  THE  RECONCILE SCREEN SHOWS A LARGER STARTING AMOUNT.  WHAT DO I DO?  jgh

qUICKENWORKER
Level 1

How do I change the beginning amount when reconciling?

i HAVE SP  fEBRUARY OPENING BALANCE IN qUICKEN DOESN'T MATCH RECONCIALITION STATEMENT.ENT 12 HOURS RECONCILING 8 MONTHS.!

Rea_M
Moderator

How do I change the beginning amount when reconciling?

QuickBooks Online (QBO) and Quicken are two different platforms, and each has its own way of reconciling accounts, qUICKENWORKER. We'll route you to the best help available that can assist you in completing your task.

 

Since you encountered issues reconciling your account in Quicken, we'd recommend contacting their support to facilitate you in fixing your beginning amount and accomplishing the process.

 

Also, if you want to bring your Quicken data into QBO, you might find this article handy to guide you: Move your Quicken data to QuickBooks Online.

 

Please let us know in the comments if you have issues reconciling your accounts in QuickBooks. We're always here to assist. Have a great day.

Jwest27
Level 1

How do I change the beginning amount when reconciling?

I have an older version of quickbooks. It’s quickbooks 2017. Do you have instructions how to change your beginning balance in reconciliation for that version?

FishingForAnswers
Level 9

How do I change the beginning amount when reconciling?

@Jwest27  The instructions from @Kristine Mae  apply in general, just small differences.

 

For instance, you would use the menu path of List>Chart of Accounts rather than Accounting>Chart of Accounts.

 

In short, you don't change the beginning balance in the reconciliation window directly.

 

You do change whatever caused the beginning balance to become incorrect.

Ivan_G
QuickBooks Team

How do I change the beginning amount when reconciling?

I've got the steps for modifying the beginning balance in QuickBooks Desktop (QBDT), Jwest27. I'm delighted to walk you through the procedures.

 

What FishingForAnswers mentioned is correct. You can't directly change the beginning balance of the reconciliation. To handle this, you'll need to check what's causing the incorrect balance and fix it according to the method that suits you best. You can pull up the Reconcile DiscrepancyAudit Trail, or Previous Reconciliation reports to locate transactions that impacted your beginning balance.

 

After that, you can proceed with correcting the discrepancy. In this case, you might need to edit or re-enter the transactions that affected your balance. You can use either of the following options below to fix this issue.

 

The first option is to undo the previous reconciliation and redo it. Please know that it's best to seek assistance from an accounting professional to ensure accurate records in your QuickBooks.

 

  1. Store a copy of your QBDT company file.
  2. Go to the Banking menu and select Reconcile.
  3. Pick the Undo Last Reconciliation option and select Continue from the Undo Previous Reconciliation prompt.
  4. Hit OK and close the Reconciliation page.
  5. Re-renter or edit transaction(s) and then redo the reconciliation.

 

Option 2: Ignore the discrepancy and let QBDT enter an offsetting adjustment:

 

  1. Navigate to the Banking menu and select Reconcile.
  2. Choose the Account and enter an Ending Balance.
  3. Fill out the rest of the page and click Continue.
  4. Hit Reconcile Now, and select Enter Adjustment from the Reconcile Adjustment prompt.
  5. Once done, QuickBooks will generate a journal entry and designate it to the expense account called Reconciliation Discrepancies.

 

For additional reference about correcting beginning balances, please review this link: Fix beginning balance issues in QuickBooks Desktop.

 

You may also check this article to learn how to review and manage your cash flows in QBDT. Doing so lets you produce your much-needed expense or sales data by utilizing your reports.

 

You're always welcome to drop by again on this thread if you have more questions about handling beginning balances or need assistance managing your transactions or reports in QuickBooks. I'll be here and ready to help you in any way.

FishingForAnswers
Level 9

How do I change the beginning amount when reconciling?

@Ivan_G  "Option 2: Ignore the discrepancy and let QBDT enter an offsetting adjustment:"

 

I was on-board with your post until I hit this spot.

 

That is a good way to fix your reconciliation errors in the same sense that raising the debt ceiling fixes the national debt.

 

That is to say, it is never an acceptable way to fix your books and QuickBooks should never have included it as a function.

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

Need to get in touch?

Contact us