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

How can I change the date on the reconciliation I did and close before?

After few months past, I realized that statement ending date is not 1st but 30 or 31, 

How can I edit ending date on reconciliation date back to several months ago?

 

企业微信截图_16372291749859.png

16 Comments 16
MadelynC
Moderator

How can I change the date on the reconciliation I did and close before?

I can help you correct the ending date of your reconciliation, John.


In QuickBooks Online, you’ll want to undo or remove the transactions manually from reconciliation to update the ending date to the correct one.


Here’s how:

 

  1. In the left navigation pane, select the Accounting menu.
  2. Go to the Chart of Accounts.
  3. Locate the account holding the transactions, then click View register.
  4. Select the entry you want to unreconcile.
  5. Keep selecting the letter R under the Reconciliation (indicated by a checkmark) column until the box is blank.
  6. Press Save and then press Yes to confirm the modification.


You can also invite an accountant to undo the entire reconciliation for you. Just make sure he/she is using a QuickBooks Online Accountants (QBOA) version. Only QBOA has special tools that can undo reconciled transactions faster.


Once done, redo the reconciliation process and ensure to enter the correct ending date.


I’ve attached this article in case you need help doing or fixing a reconciliation in the future: Learn the reconcile workflow in QuickBooks.


Don't hold back to drop a comment below if you have any other questions or concerns about your reconciled transactions. I’ll be here. Always take care!

johnrebuffreality
Level 1

How can I change the date on the reconciliation I did and close before?

Hi, thank a lot for your reply. 

 

However, transactions are correct and closing balance also fine. I only want to edit ending date from 1st to 30th for old reconciliations. 

 

How can I edit ending dates for old reconciliations?

 

Regards

Charies_M
Moderator

How can I change the date on the reconciliation I did and close before?

Hello there, johnrebuffreality.

 

You can edit the information on your reconciliation by clicking Edit info on the reconciling page if you haven't finished it yet.

 

However, if the reconciliation is done, you'll need to undo the reconciliation through the QuickBooks Online Accountant version.  Once your accountant is invited by you to see your company data, then you can follow the steps below. 

 

To undo a reconciliation using Accountant version:

 

  1. Click the Gear icon and then Reconcile under "Tools." 
  2. Select the Reconcile tab and then History by account
  3. Press History by account
  4. Choose Account and Report Period
  5. From the drop-down arrow beside View report, pick Undo
  6. Click Yes to confirm and then Undo.

 

 This can be done by manually editing the transactions within the register. I'll show you the steps below:

 

  1. Go to the Accounting menu. Then select Chart of Accounts.
  2. Find the account and select Account history or View register.
    1.PNG
  3. Select the transaction you want to unreconciled.
  4. Click the box with "R" and keep clicking it until the box is blank. This removes the transaction from the reconciliation.
  5. Select Save.
    3.PNG

Feel free to read through this article for the entire process on how to undo reconciliation: How to Unreconcile a Transaction or Undo a Reconciliation.

 

However, I'd still recommend checking with your accountant for more guidance on how to handle this situation.

 

It's that simple! Here are a few extra articles that can help you along the way: 

 

Should you need further assistance with reconciliation, don't hesitate to visit us again in the Community. Have a splendid day! 

Tiff4231281
Level 1

How can I change the date on the reconciliation I did and close before?

Hi there,

 

I ran into a similar problem, only I input the incorrect year.  The account was started in November 2018 and I reconciled January 2019 with a 2018 date.  I do not have an accountant and I'm updating our account from day 1. I only have the option to "print" the reconciliation, not delete or modify.  Is there a way to undo this reconciliation if an accountant isn't available? 

 

Thanks for your help.

SarahannC
Moderator

How can I change the date on the reconciliation I did and close before?

Hope you're doing good, @Tiff4231281.

 

Yes, there is. If you don't have an accountant, you still have an option to manually undo the reconciliation. However, this process may not be easy for you since there are lot of transactions to undo.

 

Using QuickBooks Online only allows you to edit/undo each transaction. Here's how:

 

  1. Go to the Accounting menu.
  2. Within the Chart of Accounts tab, locate the appropriate account for the transaction and select View Register on the Action column.
  3. Identify the transaction to edit.
  4. In the reconcile status column (indicated by a checkmark), repeatedly click the top line of the transaction to change the status. Leave it blank.
  5. Click Save.

 

To make everything easier, you can invite your accountant. They can undo an entire reconciliation one at a time. You can find one by visiting this article: Find an accountant

 

Here's how to invite your accountant:

 

  1. Click the Gear icon in the upper-right corner and select Manage Users.
  2. Select the Accounting firms tab.
  3. Click the Invite button.
  4. Enter your accountant's information and click Save.

 

You'll want to review these articles for more tips and information about undoing reconciliation in your QuickBooks Online account.

 

I'll be around to help you more if still need my assistance, Tiff4231281. Stay safe and have a good one.

Phil in SB
Level 1

How can I change the date on the reconciliation I did and close before?

I am trying to reconcile a new month. I put in the correct ending date and ending balance (starting balance is already there and correct). I click reconcile now and nothing happens. I click summary and it does not give me the choice of the correct new month, only previous months.

 

This is my first month reconciling myself instead of my accountant. I was able to do another of my companies without any issue.

 

Thanks,

DivinaMercy_N
Moderator

How can I change the date on the reconciliation I did and close before?

I want to ensure you'll be able to reconcile your account seamlessly, @Phil in SB.

 

In QuickBooks Online (QBO), you'll see a prompt once you successfully completed the reconciliation (please see the snip for reference). reconcile 1.PNGWhen you select Done, the program will automatically record that session. Since you're having trouble seeing the reconciliation for the new month, possible that it did not go through. To narrow down the cause of the issue, we can perform some browser troubleshooting steps.

 

Let's start with accessing your QBO account in incognito mode. This will prevent storing of cache that sometimes causes a problem when running websites. Once opened, perform the reconciliation for the new month again. 

 

When finished, go back to the Reconciliation page and this time select the History by account option. This will provide you with more detailed information and a list of reconciliations you've completed for a specific year. Here's how:

 

  1. On the Reconciliation page, click the History by account option.
  2. From the Report period field, choose All Dates.
  3. Next, select the dropdown arrow beside the year. This will show all the completed reconciliations for each month. reconcile2.PNGreconciliation3.PNG

 

If you're able to see it, I recommend clearing the cache of your regular browser. This will give you a clean slate and will eliminate the damaged and corrupted files that may cause the unusual behavior of QBO. 

 

On the other hand, you can also check your Audit Log to see if the reconciliation for the new month is successful. If it is, check your History by account again to view the details for that month. 

 

To further guide you in reconciling your account, feel free to visit our Reconciliation hub

 

Also, running a report to get a handy copy of your reconciliations is a breeze. You can use this as a reference to avoid mistakes when performing a new reconciliation. 

 

I'm always ready to lend you a hand in case you have any other concerns about reconciling your account. Just leave a reply below and I'll circle back to help you out. Have a good day.

Phil in SB
Level 1

How can I change the date on the reconciliation I did and close before?

Hi Davina:

 

Still no luck. I opened in incognito mode and also tried using another PC.

 

I select my bank account, which is linked then fill in the ending balance and end date of 3/31/22. The correct starting balance is already there and correctly from last month. Then I click on Reconcile Now and nothing happens. History shows last month 2/2//22.

 

Seems like I am stuck. I was able to do my other company without a hitch. Any other suggestions? 

 

 

 

 

CharleneMaeF
QuickBooks Team

How can I change the date on the reconciliation I did and close before?

Thanks for updating us on this, Phil in SB. I'm surprised the basic troubleshooting steps didn't work. Let me make it up to you by making sure this gets investigated.

 

I'd recommend contacting our QuickBooks Support Team. They're equipped with tools to check the cause. It'll also allow them to submit a ticket to our engineering team to alert them about the issue if necessary. 

 

Here's how:

 

  1. Go to the Help (?) icon at the top.
  2. On the Assistant tab, click Talk to a human.
  3. Enter your concern in the Type something field, then click the send icon.
  4. Select I still need a human.
  5. Click Get help from a human.
  6. You can either select the Chat with us or Have us call you option.

 

To ensure that you'll be assisted on time, please see our support hours

 

Additionally, I've included an article that'll you learn how to help keep a handy copy of your reconciled data: View, Print, or Export a Report.

 

Please keep us posted on how it goes, Phil in SB. It's our priority to make sure your accounts are reconciled.

Phil in SB
Level 1

How can I change the date on the reconciliation I did and close before?

Hi Charlene:

 

Problem solved. I had not set up payment yet, thinking this month was paid for by my former accountant. I got a message elsewhere about the needed payment. Everything works great.

 

It might be nice if a message pops up telling you to check on the payment status.

 

Onward!

MaryLandT
Moderator

How can I change the date on the reconciliation I did and close before?

I'm happy to hear that your reconciliation concerns have bee fixed, Phil in SB.

 

Right now, you need to manually check the status of your transactions in QuickBooks. Here's how:

 

  1. Go to Sales then, then select All Sales.
  2. Select Get paid & pay and select Invoices.
  3. Check the Status column to see where invoices are in the sales process.
     

Check out this article to learn more about the status: Learn how to create and send invoices in QuickBooks Online. It'll also tell you how to review payments you've recorded in the system.

 

Don't hesitate to post again if you have other questions. The Community Forum is always open to help you with any QuickBooks concerns.

 

Thank you and have a great day ahead!

thomas3762
Level 2

How can I change the date on the reconciliation I did and close before?

it would be nice to get an answer for quickbooks desktop as well.  I search the question and online get online answers.  Also, this should be incredibly easy, why does it appear, qbs has made this change more difficult than necessary.

JenoP
Moderator

How can I change the date on the reconciliation I did and close before?

Hi there, thomas3762.

 

Can you tell us more details about your concern? We just want to make sure that we give you the right steps and information to help with your question. 

 

Please add a reply below to share more details. We look forward to it. 

thomas3762
Level 2

How can I change the date on the reconciliation I did and close before?

completed bank rec for 5/31 on 6/17 for to put in date so qbs used today's date.  I want to correct date and cannot.

Then when you send in questions, the answers are always geared towards online version.  I use 21 desktop

ZackE
Moderator

How can I change the date on the reconciliation I did and close before?

Thanks for getting back with the Community, thomas3762.

 

You can correct invalid dates on previous reconciliations by undoing them.

 

Here's how:

  1. In your top menu bar, go to Banking.
  2. Choose Reconcile.
  3. From the Begin Reconciliation window, select Undo Last Reconciliation.

 

Now your previous reconciliation will be undone and need to be reconciled again. If you need to undo more than one reconciliation, you can repeat the numeric steps above to undo one at a time in the order they were originally done in.

 

When undoing prior reconciliations, it's recommended that you work with an accounting professional. If you're in need of one, there's an awesome tool on our website called Find a ProAdvisor. All ProAdvisors listed there are QuickBooks-certified and able to provide helpful insights for driving your business's success.

 

Here's how it works:

  1. Go to our Find a ProAdvisor page.
  2. Use the City or ZIP search field to specify a location.
  3. Select Find a ProAdvisor.
  4. Browse through your results and find one that works best for the business. You can click on each ProAdvisor's profile to learn more information about them.

 

Once you've found an accountant, they can be contacted through their Send a message form:

  1. Use the available text box to introduce yourself. Be sure to include details about which services you're looking for.
  2. Enter your appropriate info in the Your nameYour email, and Your phone number (optional) fields.
  3. Hit Send message.

 

You'll also be able to find many detailed resources about using QuickBooks in our help article archives.

 

I'll be here to help if there's any additional questions. Have a wonderful day!

thomas3762
Level 2

How can I change the date on the reconciliation I did and close before?

I understand I could undo the reconciliation and start over but that is a ridiculous fix for a date change.


@ZackE wrote:

Thanks for getting back with the Community, thomas3762.

 

You can correct invalid dates on previous reconciliations by undoing them.

 

Here's how:

  1. In your top menu bar, go to Banking.
  2. Choose Reconcile.
  3. From the Begin Reconciliation window, select Undo Last Reconciliation.

 

Now your previous reconciliation will be undone and need to be reconciled again. If you need to undo more than one reconciliation, you can repeat the numeric steps above to undo one at a time in the order they were originally done in.

 

When undoing prior reconciliations, it's recommended that you work with an accounting professional. If you're in need of one, there's an awesome tool on our website called Find a ProAdvisor. All ProAdvisors listed there are QuickBooks-certified and able to provide helpful insights for driving your business's success.

 

Here's how it works:

  1. Go to our Find a ProAdvisor page.
  2. Use the City or ZIP search field to specify a location.
  3. Select Find a ProAdvisor.
  4. Browse through your results and find one that works best for the business. You can click on each ProAdvisor's profile to learn more information about them.

 

Once you've found an accountant, they can be contacted through their Send a message form:

  1. Use the available text box to introduce yourself. Be sure to include details about which services you're looking for.
  2. Enter your appropriate info in the Your nameYour email, and Your phone number (optional) fields.
  3. Hit Send message.

 

You'll also be able to find many detailed resources about using QuickBooks in our help article archives.

 

I'll be here to help if there's any additional questions. Have a wonderful day!


 

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

Need to get in touch?

Contact us