# Bank Reconciliation Statement

**URL:** https://forum.manager.io/t/bank-reconciliation-statement/8171
**Category:** Uncategorized
**Created:** [December 31, 2016, 6:43am UTC](https://forum.manager.io/t/bank-reconciliation-statement/8171 "2016-12-31T06:43:16Z")
**Posts on this page:** 20
**Page:** 1

<div class="post-metadata">

### Author: ![neatie](https://avatars.discourse-cdn.com/v4/letter/n/edb3f5/32.png) [@neatie](https://forum.manager.io/u/neatie)
#### Post date: [December 31, 2016, 6:43am UTC](https://forum.manager.io/t/bank-reconciliation-statement/8171/1 "2016-12-31T06:43:16Z")

</div>

Hello and Happy New Year.  
I am having some difficulties with my first bank rec. I have read through all the relevant guide material and posts, and I think I have followed all the directions; but I cannot get the ‘Bank Reconciliation Statement’ to appear!  
I have deleted and transferred and started new accounts, and updated but it still does not appear. Any suggestions?

---

<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: [December 31, 2016, 6:50am UTC](https://forum.manager.io/t/bank-reconciliation-statement/8171/2 "2016-12-31T06:50:28Z")

</div>

Bank Reconciliations now appear under Reports - Cash Accounts - Bank Reconciliation Statements, is this where you are looking.

They use to be part of the Cash Accounts tab but were relocated. Some of the older guides may still refer to here.

This release note may help

> [@\[16.4.76\] Decoupled bank reconciliation from "Bank Accounts" tab](https://forum.manager.io/t/16-4-76-decoupled-bank-reconciliation-from-bank-accounts-tab/5782):
>
> In the latest version, bank reconciliation is no longer available under Bank Accounts tab. I know this may come as a surprise as bank reconciliation naturally belongs to bank accounts. With recent addition of bank reconciliation statements under Reports tab, it will make it more intuitive if bank reconciliation workflow is done from bank reconciliation statements. So rather than having Reconciliation Date and Status column under Bank Accounts tab, it’s better to show reconciliation status unde…

---

<div class="post-metadata">

### Author: ![neatie](https://avatars.discourse-cdn.com/v4/letter/n/edb3f5/32.png) [@neatie](https://forum.manager.io/u/neatie)
#### Post date: [December 31, 2016, 7:12am UTC](https://forum.manager.io/t/bank-reconciliation-statement/8171/3 "2016-12-31T07:12:03Z")

</div>

Thanks, I have to go now, so will start again tomorrow!

---

<div class="post-metadata">

### Author: ![neatie](https://avatars.discourse-cdn.com/v4/letter/n/edb3f5/32.png) [@neatie](https://forum.manager.io/u/neatie)
#### Post date: [January 1, 2017, 1:52am UTC](https://forum.manager.io/t/bank-reconciliation-statement/8171/4 "2017-01-01T01:52:33Z")

</div>

Hi Brucanna, my problem is that the actual ‘Bank Statement’ doesn’t show up.

---

<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: [January 1, 2017, 2:03am UTC](https://forum.manager.io/t/bank-reconciliation-statement/8171/5 "2017-01-01T02:03:06Z")

</div>

You will need to explain further, the actual Bank Statement doesn’t show up where ?  
.

---

<div class="post-metadata">

### Author: ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)
#### Post date: [January 1, 2017, 2:07am UTC](https://forum.manager.io/t/bank-reconciliation-statement/8171/6 "2017-01-01T02:07:07Z")

</div>

If you have at least one cash account designated as being maintained by a bank or other financial institution, Bank Reconciliation Statement will appear in the `Reports` tab under Cash Accounts. When you edit the cash account itself, you see this:

![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/4/448185ad3235d5a4812f851efa7281e09043e77b.png)

Then under `Reports`, you see this:

![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/d/d5365329fdfdf01e768af1a1d8d1105467f730de.png)

Manager does not produce an actual “bank statement.” That has to come from your bank, whether electronically or by snail mail. Manager only produces a reconciliation between what you have entered and the statement from the bank.

---

<div class="post-metadata">

### Author: ![neatie](https://avatars.discourse-cdn.com/v4/letter/n/edb3f5/32.png) [@neatie](https://forum.manager.io/u/neatie)
#### Post date: [January 1, 2017, 2:52am UTC](https://forum.manager.io/t/bank-reconciliation-statement/8171/7 "2017-01-01T02:52:53Z")

</div>

I believe there should be a ‘Bank Statement’ generated on this screen,  
I’m not sure if this screenshot is going to work:

 ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/1/1cc295e8f617fe7838103272ab6c8dfb38c9ec5a.png)

---

<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: [January 1, 2017, 3:28am UTC](https://forum.manager.io/t/bank-reconciliation-statement/8171/8 "2017-01-01T03:28:58Z")

</div>

Yes, you will get a Bank Reconciliation Statement on that screen “if” the account reconciles.  
If the account doesn’t reconcile, then you get the screen as posted.

It appears that this is your first reconciliation. The balance in your Cash Accounts tab Cheque Account as at July 29 needs to match the balance on your actual Bank Statement for the same date for the reconciliation to work…

It appears you have entered 7950.36 as the Bank Statement balance for that date. What is the Cash Accounts tab balance for the Cheque Account for that same date.

For ease, the bottom part of the above screen details the entered transactions, you can compare these to the entries on the Bank Statement. they should all match off.

---

<div class="post-metadata">

### Author: ![neatie](https://avatars.discourse-cdn.com/v4/letter/n/edb3f5/32.png) [@neatie](https://forum.manager.io/u/neatie)
#### Post date: [January 1, 2017, 3:40am UTC](https://forum.manager.io/t/bank-reconciliation-statement/8171/9 "2017-01-01T03:40:40Z")

</div>

Ok. Yes, this is my first rec.  
Is this the Cash Accounts tab for the Cheque Account? I have the balance for the starting date of the actual bank statement

 ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/8/86a0541056bca7e19466be9a435fff6f1a250866.png)

---

<div class="post-metadata">

### Author: ![neatie](https://avatars.discourse-cdn.com/v4/letter/n/edb3f5/32.png) [@neatie](https://forum.manager.io/u/neatie)
#### Post date: [January 1, 2017, 3:41am UTC](https://forum.manager.io/t/bank-reconciliation-statement/8171/10 "2017-01-01T03:41:43Z")

</div>

oops I think that pasted the wrong thing!

---

<div class="post-metadata">

### Author: ![neatie](https://avatars.discourse-cdn.com/v4/letter/n/edb3f5/32.png) [@neatie](https://forum.manager.io/u/neatie)
#### Post date: [January 1, 2017, 3:43am UTC](https://forum.manager.io/t/bank-reconciliation-statement/8171/11 "2017-01-01T03:43:54Z")

</div>

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

---

<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: [January 1, 2017, 3:56am UTC](https://forum.manager.io/t/bank-reconciliation-statement/8171/12 "2017-01-01T03:56:42Z")

</div>

> [@neatie](#):
>
> Is this the Cash Accounts tab for the Cheque Account?

No, click on the blue figure balance here and then record the last balance for Jul 29

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

> [@neatie](#):
>
> I have the balance for the starting date of the actual bank statement

You need the balance for the “final” day of the actual bank statement - Jul 29.

The reconciliation compares the balances between the Cheque Account and Bank Statement for a given date

---

<div class="post-metadata">

### Author: ![neatie](https://avatars.discourse-cdn.com/v4/letter/n/edb3f5/32.png) [@neatie](https://forum.manager.io/u/neatie)
#### Post date: [January 1, 2017, 4:06am UTC](https://forum.manager.io/t/bank-reconciliation-statement/8171/13 "2017-01-01T04:06:13Z")

</div>

> [@Brucanna](#):
>
> You need the balance for the “final” day of the actual bank statement - Jul 29.
> 
> The reconciliation compares the balances between the Cheque Account and Bank Statement for a given date

Ok, I am confused. Shouldn’t the starting date be for the beginning of the month (or end of the previous month) and that balance?

---

<div class="post-metadata">

### Author: ![neatie](https://avatars.discourse-cdn.com/v4/letter/n/edb3f5/32.png) [@neatie](https://forum.manager.io/u/neatie)
#### Post date: [January 1, 2017, 4:07am UTC](https://forum.manager.io/t/bank-reconciliation-statement/8171/14 "2017-01-01T04:07:56Z")

</div>

> [@neatie](#):
>
> Ok, I am confused. Shouldn’t the starting date be for the beginning of the month (or end of the previous month) and that balance?

sorry, I missed the previous reply - I’ll check that out

---

<div class="post-metadata">

### Author: ![neatie](https://avatars.discourse-cdn.com/v4/letter/n/edb3f5/32.png) [@neatie](https://forum.manager.io/u/neatie)
#### Post date: [January 1, 2017, 4:15am UTC](https://forum.manager.io/t/bank-reconciliation-statement/8171/15 "2017-01-01T04:15:42Z")

</div>

> [@Brucanna](#):
>
> No, click on the blue figure balance here and then record the last balance for Jul 29
> 
> 00000 Chk Acct.jpg

 ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/3/3081984b65361b754c61d353412bb635708429f7.png)

right, then I clicked on the blue balance

 ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/d/d39c3d36b51dd3f5a5f5aefb2420bded7c791c46.png)  
now I’m not sure where, or how to record the last balance.  
Sorry, I must seem quite dim.

---

<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: [January 1, 2017, 4:25am UTC](https://forum.manager.io/t/bank-reconciliation-statement/8171/16 "2017-01-01T04:25:06Z")

</div>

Just be patient, this is only your first attempt and until you get to know how things working - it can all seem a bit strange.

Now that I can see the Cheque Account Balance, what were your Bank Statement balances for  
Jun 29 - $  
Jul 29 - $

---

<div class="post-metadata">

### Author: ![neatie](https://avatars.discourse-cdn.com/v4/letter/n/edb3f5/32.png) [@neatie](https://forum.manager.io/u/neatie)
#### Post date: [January 1, 2017, 4:39am UTC](https://forum.manager.io/t/bank-reconciliation-statement/8171/17 "2017-01-01T04:39:52Z")

</div>

> [@Brucanna](#):
>
> Now that I can see the Cheque Account Balance, what were your Bank Statement balances for Jun 29 - $ Jul 29 - $

Opening balance (I am calling it Jun 29) is $7785.68  
July 29 balance is $7950.36  
On the paper statements from the bank

---

<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: [January 1, 2017, 5:10am UTC](https://forum.manager.io/t/bank-reconciliation-statement/8171/18 "2017-01-01T05:10:20Z")

</div>

Ok so the opening balances between the Cheque Account and the Bank Statement Match - Big Tick.

Now can you do this - go to the Reports tab and click Bank Reconciliation Statement.  
Click Edit and then click delete.

Now click new report, enter date June 29 and select Cheque Account and click create  
Now click view and enter the balance as 7785.68 and click update.

I will be back in a hour or so.

---

<div class="post-metadata">

### Author: ![neatie](https://avatars.discourse-cdn.com/v4/letter/n/edb3f5/32.png) [@neatie](https://forum.manager.io/u/neatie)
#### Post date: [January 1, 2017, 6:05am UTC](https://forum.manager.io/t/bank-reconciliation-statement/8171/19 "2017-01-01T06:05:48Z")

</div>

> [@Brucanna](#):
>
> Ok so the opening balances between the Cheque Account and the Bank Statement Match - Big Tick.
> 
> Now can you do this - go to the Reports tab and click Bank Reconciliation Statement.Click Edit and then click delete.
> 
> Now click new report, enter date June 29 and select Cheque Account and click createNow click view and enter the balance as 7785.68 and click update.
> 
> I will be back in a hour or so

Yay! Success! Thank you!

---

<div class="post-metadata">

### Author: ![neatie](https://avatars.discourse-cdn.com/v4/letter/n/edb3f5/32.png) [@neatie](https://forum.manager.io/u/neatie)
#### Post date: [January 1, 2017, 7:01am UTC](https://forum.manager.io/t/bank-reconciliation-statement/8171/20 "2017-01-01T07:01:23Z")

</div>

> [@neatie](#):
>
> Ok so the opening balances between the Cheque Account and the Bank Statement Match - Big Tick.  
> Now can you do this - go to the Reports tab and click Bank Reconciliation Statement.Click Edit and then click delete.  
> Now click new report, enter date June 29 and select Cheque Account and click createNow click view and enter the balance as 7785.68 and click update.  
> I will be back in a hour or so

That was great, I now have a Reconciliation Statement as 29/06/2016  
But now I’m still stuck on my 29/07/2016 reconciliation here:

 ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/2/20b3a6f6a90e86420aa9451a8d61e1dda3d06e3a.png)  
I thought the rec statement would show up with the discrepancies for me to work through?

[Next page](https://forum.manager.io/t/bank-reconciliation-statement/8171.md?page=2)
