# Changing End Date for Reconciliation

**URL:** <https://forum.manager.io/t/changing-end-date-for-reconciliation/6347>\
**Category:** Uncategorized\
**Created:** [July 14, 2016, 6:27am UTC](https://forum.manager.io/t/changing-end-date-for-reconciliation/6347 "2016-07-14T06:27:49Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![vickis](https://avatars.discourse-cdn.com/v4/letter/v/9e8a1a/32.png) [@vickis](https://forum.manager.io/u/vickis)\
**Post date:** [July 14, 2016, 6:27am UTC](https://forum.manager.io/t/changing-end-date-for-reconciliation/6347/1 "2016-07-14T06:27:49Z")

</div>

I’ve searched for this answer and as yet can’t find it.

I want to change the END date for reconciliation, here’s a screenshot of what I want to change.

Thank you.

 ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/f/f353bd161afadbfd4640e0f4fd2811dce4c27de4.jpg)

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [July 14, 2016, 7:03am UTC](https://forum.manager.io/t/changing-end-date-for-reconciliation/6347/2 "2016-07-14T07:03:36Z")

</div>

Click on the Edit button next to the date

---

<div class="post-metadata">

**Author:** ![vickis](https://avatars.discourse-cdn.com/v4/letter/v/9e8a1a/32.png) [@vickis](https://forum.manager.io/u/vickis)\
**Post date:** [July 14, 2016, 7:50am UTC](https://forum.manager.io/t/changing-end-date-for-reconciliation/6347/3 "2016-07-14T07:50:37Z")

</div>

I did click the edit button, there is no option to change the date only put the closing balance.

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [July 14, 2016, 7:56am UTC](https://forum.manager.io/t/changing-end-date-for-reconciliation/6347/4 "2016-07-14T07:56:20Z")

</div>

Sorry, quoted the wrong Edit  
Go to Reports - Bank Reconciliation Statement and click on the “Edit” next to View

![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/7/7ff1acdd494c61a2a25034f9393d68845cf6142f.jpg)

---

<div class="post-metadata">

**Author:** ![vickis](https://avatars.discourse-cdn.com/v4/letter/v/9e8a1a/32.png) [@vickis](https://forum.manager.io/u/vickis)\
**Post date:** [July 14, 2016, 9:41pm UTC](https://forum.manager.io/t/changing-end-date-for-reconciliation/6347/5 "2016-07-14T21:41:31Z")

</div>

Thanks it has the correct date there 30.6.2016 but the reconciliation button is red.

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [July 14, 2016, 10:52pm UTC](https://forum.manager.io/t/changing-end-date-for-reconciliation/6347/6 "2016-07-14T22:52:54Z")

</div>

If the button is red then the reconciliation is incomplete, do you have the correct end balance entered ? If its a credit card, has the balance been entered as a negative (-1234.56) ?

If you scroll down on the report you showed in your opening post screenshot there will be a list of data - has this been matched to your statement

---

<div class="post-metadata">

**Author:** ![vickis](https://avatars.discourse-cdn.com/v4/letter/v/9e8a1a/32.png) [@vickis](https://forum.manager.io/u/vickis)\
**Post date:** [July 14, 2016, 10:56pm UTC](https://forum.manager.io/t/changing-end-date-for-reconciliation/6347/7 "2016-07-14T22:56:10Z")

</div>

It will only show entries to 26 May, and that’s the date that I can’t change. It changed for everything else just not for there. So if I hit the view button I can put the balance as at 26 May, but not 30 June. I sat for hours yesterday trying to work it out.

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [July 14, 2016, 11:08pm UTC](https://forum.manager.io/t/changing-end-date-for-reconciliation/6347/8 "2016-07-14T23:08:26Z")

</div>

> [@vickis](#):
>
> So if I hit the view button I can put the balance as at 26 May, but not 30 June

Are you saying that under the View button the closing balance (0.00) can’t be changed ?

Why don’t you delete your existing report and then re-create a new report in case there is some data problem.

---

<div class="post-metadata">

**Author:** ![vickis](https://avatars.discourse-cdn.com/v4/letter/v/9e8a1a/32.png) [@vickis](https://forum.manager.io/u/vickis)\
**Post date:** [July 14, 2016, 11:12pm UTC](https://forum.manager.io/t/changing-end-date-for-reconciliation/6347/9 "2016-07-14T23:12:35Z")

</div>

Brucanna the closing balance can be changed but the closing balance I need is for 30 June. It had the closing balance for 26 May. I have the bank statement going to yesterday 14 July, so it’s not missing data. And when I scroll down the ‘view’ it only showed entries to 25 May. Thanks for going through this with me.

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [July 14, 2016, 11:46pm UTC](https://forum.manager.io/t/changing-end-date-for-reconciliation/6347/10 "2016-07-14T23:46:49Z")

</div>

@vickis, you need to supply Manager what’s the closing balance as of May 26th. This is part of the reconciliation process to break down reconciliation period into smaller chunks so they can be reconciled individually.

Also, make sure you are not using a version that is too old. There has been improvements to reconciliation workflow in the past month.

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [July 14, 2016, 11:48pm UTC](https://forum.manager.io/t/changing-end-date-for-reconciliation/6347/11 "2016-07-14T23:48:20Z")

</div>

> [@vickis](#):
>
> the closing balance can be changed but the closing balance I need is for 30 June.

If the closing balance can be changed, why can’t you change it then to the 30 June closing balance

To start from the beginning - for a Reconciliation to 30 June go to Reports - Bank Rec

![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/7/7ff1acdd494c61a2a25034f9393d68845cf6142f.jpg)

Click Edit and enter 30/6/2016 (the cash account required should be displayed)  
Click View and enter Jun 30 closing balance

Show screenshot of results

---

<div class="post-metadata">

**Author:** ![vickis](https://avatars.discourse-cdn.com/v4/letter/v/9e8a1a/32.png) [@vickis](https://forum.manager.io/u/vickis)\
**Post date:** [July 15, 2016, 11:27pm UTC](https://forum.manager.io/t/changing-end-date-for-reconciliation/6347/12 "2016-07-15T23:27:08Z")

</div>

Thanks Brucanna, I did this here’s the screen shots, step 1 I changed the date to 30.6.2016 and it shows.

Then I click view and it shows 26.5.2016 not 30.6.2016?

 ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/8/8c68d9e02b4695734267ebe1a1c7c6b1b84c8c41.jpg)  
 ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/d/d6ee4d431664f8cd6845ed30a8de78e5be466de3.jpg)

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [July 16, 2016, 12:27am UTC](https://forum.manager.io/t/changing-end-date-for-reconciliation/6347/13 "2016-07-16T00:27:05Z")

</div>

OK, it appears that your Bank Reconciliation can’t balance to Jun 30 so its asking for the balance on May 26, therefore go to your Statement and find the last balance for May 26 and enter that under View and see what result you get.

If the result asks for another date (either earlier or later) then enter the Statement balance for that date until you get a reconciliation. Once this has occurred then it would appear that there is a mismatch of data just after that date.

---

<div class="post-metadata">

**Author:** ![vickis](https://avatars.discourse-cdn.com/v4/letter/v/9e8a1a/32.png) [@vickis](https://forum.manager.io/u/vickis)\
**Post date:** [July 16, 2016, 12:28am UTC](https://forum.manager.io/t/changing-end-date-for-reconciliation/6347/14 "2016-07-16T00:28:26Z")

</div>

Thank you so much I’ll do it now. Fingers crossed.

---

<div class="post-metadata">

**Author:** ![vickis](https://avatars.discourse-cdn.com/v4/letter/v/9e8a1a/32.png) [@vickis](https://forum.manager.io/u/vickis)\
**Post date:** [July 16, 2016, 5:54am UTC](https://forum.manager.io/t/changing-end-date-for-reconciliation/6347/15 "2016-07-16T05:54:02Z")

</div>

Thank you so much Brucanna, I DID IT! I had not recorded dates in some of the paid dates, and as you said I had to go a few dates at a time and sort out what I’d done wrong until ‘bingo’ it reconciled. Here’s a screen shot of what I was missing circled, for other who may have the same issue.

As they say you learn the most by your mistakes, thank you everyone for your help.

 ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/f/fbb18a76e7015563338eb6923ee3ee92635bb9e8.jpg)

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [January 18, 2023, 3:32pm UTC](https://forum.manager.io/t/changing-end-date-for-reconciliation/6347/16 "2023-01-18T15:32:07Z")

</div>

Closed on January 18, 2023, 3:32pm UTC


