# Bank wise Ledger

**URL:** <https://forum.manager.io/t/bank-wise-ledger/30532>\
**Category:** Uncategorized\
**Created:** [September 12, 2020, 2:24pm UTC](https://forum.manager.io/t/bank-wise-ledger/30532 "2020-09-12T14:24:32Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![subrosumon](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/subrosumon/32/30229_2.png) [@subrosumon](https://forum.manager.io/u/subrosumon)\
**Post date:** [September 12, 2020, 2:24pm UTC](https://forum.manager.io/t/bank-wise-ledger/30532/1 "2020-09-12T14:24:32Z")

</div>

Hi Expart,  
I have 6 Bank Number under “Bank Accounts” how can i see individually Bank Transactions? i didn’t see any options to see. .  
Thanks in advance

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/e/f/ef0310e17d5e21fa8768e1abec0d11f761c31dac.png)

Report is not showing bank Name, only showing Cash at Bank

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

---

<div class="post-metadata">

**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\
**Post date:** [September 12, 2020, 2:38pm UTC](https://forum.manager.io/t/bank-wise-ledger/30532/2 "2020-09-12T14:38:01Z")

</div>

The report you are trying to use is linked to the chart of accounts. If you want to use it for each bank account you should assign each bank account to a different general ledger account through control accounts.

---

<div class="post-metadata">

**Author:** ![subrosumon](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/subrosumon/32/30229_2.png) [@subrosumon](https://forum.manager.io/u/subrosumon)\
**Post date:** [September 12, 2020, 4:07pm UTC](https://forum.manager.io/t/bank-wise-ledger/30532/3 "2020-09-12T16:07:35Z")

</div>

Thanks

---

<div class="post-metadata">

**Author:** ![yameen101](https://avatars.discourse-cdn.com/v4/letter/y/8edcca/32.png) [@yameen101](https://forum.manager.io/u/yameen101)\
**Post date:** [June 29, 2021, 10:29am UTC](https://forum.manager.io/t/bank-wise-ledger/30532/4 "2021-06-29T10:29:14Z")

</div>

I have two bank accounts and we have entered data for the last complete years. Now are facing the same problem i.e. system is generating one bank ledger for both banks. How, can I bifurcate where we have already data in bank accounts.

Please guide.

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [June 29, 2021, 10:37am UTC](https://forum.manager.io/t/bank-wise-ledger/30532/5 "2021-06-29T10:37:21Z")

</div>

In the tab Bank & Cash Accounts you can click on the Cleared Balance or the Actual Balance amount to get a list of the transactions in the account

It is not clear what you are trying to do - are you trying to reconcile the accounts?

You could then export them into Excel if you need further reports

---

<div class="post-metadata">

**Author:** ![yameen101](https://avatars.discourse-cdn.com/v4/letter/y/8edcca/32.png) [@yameen101](https://forum.manager.io/u/yameen101)\
**Post date:** [June 29, 2021, 10:42am UTC](https://forum.manager.io/t/bank-wise-ledger/30532/6 "2021-06-29T10:42:24Z")

</div>

Thanks @Joe91, I am trying to get a yearly or periodic ledger of the bank account.

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [June 29, 2021, 10:50am UTC](https://forum.manager.io/t/bank-wise-ledger/30532/7 "2021-06-29T10:50:02Z")

</div>

As it is indicated in the post number 2 above, if you need this then you will have to assign each account to a different control account

Manager, by default, combines all bank accounts into one B/S account, Cash at Bank

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [June 29, 2021, 10:56am UTC](https://forum.manager.io/t/bank-wise-ledger/30532/8 "2021-06-29T10:56:58Z")

</div>

Have you reconciled the bank accounts with the bank statements?

Why do you need a listing of the transactions?

People often continue using paper based reports when moving to a computerised system but is this really necessary?

---

<div class="post-metadata">

**Author:** ![yameen101](https://avatars.discourse-cdn.com/v4/letter/y/8edcca/32.png) [@yameen101](https://forum.manager.io/u/yameen101)\
**Post date:** [June 29, 2021, 11:17am UTC](https://forum.manager.io/t/bank-wise-ledger/30532/9 "2021-06-29T11:17:50Z")

</div>

@Joe91, sometimes the people from the management require the bank ledgers. Thought it is not necessary but sometime legacy prevails.

---

<div class="post-metadata">

**Author:** ![yameen101](https://avatars.discourse-cdn.com/v4/letter/y/8edcca/32.png) [@yameen101](https://forum.manager.io/u/yameen101)\
**Post date:** [June 29, 2021, 11:19am UTC](https://forum.manager.io/t/bank-wise-ledger/30532/10 "2021-06-29T11:19:18Z")

</div>

I have created account in “chart of accounts” under cash and bank group with the code in order to have separate ledger of each bank. However, the said bank is not appearing in “Cash and Bank accounts tab” for receipt and payment.

Any clue?

---

<div class="post-metadata">

**Author:** ![eko](https://avatars.discourse-cdn.com/v4/letter/e/a8b319/32.png) [@eko](https://forum.manager.io/u/eko)\
**Post date:** [June 29, 2021, 11:24am UTC](https://forum.manager.io/t/bank-wise-ledger/30532/11 "2021-06-29T11:24:30Z")

</div>

So why can you not use as @Joe91 suggested: click on Bank and Cash accounts → Click on the cleared balance of the bank account of your choice → Scroll to the bottom of your page and select the Max (…) so that the page will refresh and list all transactions then → click Copy to Clipboard (bottom of refreshed page) → Paste into a Spreadsheet program. Then create any worksheet by copying and pasting the information you need.

However, if you reconcile your bank statements why would management need printed bank ledgers when they could have the bank statements to know what has gone in and out of the bank as reconciled in Manager as well?

---

<div class="post-metadata">

**Author:** ![yameen101](https://avatars.discourse-cdn.com/v4/letter/y/8edcca/32.png) [@yameen101](https://forum.manager.io/u/yameen101)\
**Post date:** [June 29, 2021, 11:41am UTC](https://forum.manager.io/t/bank-wise-ledger/30532/12 "2021-06-29T11:41:46Z")

</div>

Yes, this is the only remain to copy and paste the transaction in a spreadsheet.

I would suggest adding a report showing complete specific bank transactions (selected period of time) in “Cash & cash equivalents”. At the moment, the only option is “Bank Account Summary”.

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [June 29, 2021, 12:07pm UTC](https://forum.manager.io/t/bank-wise-ledger/30532/13 "2021-06-29T12:07:56Z")

</div>

You could also create a Custom Report to do this

---

<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:** [June 29, 2021, 12:46pm UTC](https://forum.manager.io/t/bank-wise-ledger/30532/14 "2021-06-29T12:46:51Z")

</div>

> [@yameen101](#):
>
> Now are facing the same problem i.e. system is generating one bank ledger for both banks. How, can I bifurcate where we have already data in bank accounts.

@yameen101, it is not completely clear what you mean by this. Are you saying you have entered transactions for both real-world bank accounts into the same bank account in Manager? If so, you need to create two separate bank accounts in Manager under the Bank and Cash Accounts tab. At that point, you could then separate receipts and payments into their correct (separate) bank accounts using Batch Update.

If the issue is displaying the balance of the two bank accounts separately on the balance sheet, that can easily be handled with a custom control account. See this Guide: [https://www.manager.io/guides/9256](https://www.manager.io/guides/9256).

> [@yameen101](#):
>
> I have created account in “chart of accounts” under cash and bank group with the code in order to have separate ledger of each bank. However, the said bank is not appearing in “Cash and Bank accounts tab” for receipt and payment.

This makes it sound like you created an ordinary account rather than a custom control account for bank accounts.

---

<div class="post-metadata">

**Author:** ![yameen101](https://avatars.discourse-cdn.com/v4/letter/y/8edcca/32.png) [@yameen101](https://forum.manager.io/u/yameen101)\
**Post date:** [June 29, 2021, 12:53pm UTC](https://forum.manager.io/t/bank-wise-ledger/30532/15 "2021-06-29T12:53:43Z")

</div>

@Tut you are right, I have created ordinary account and not that control account. I got your point.

---

<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, 2:46pm UTC](https://forum.manager.io/t/bank-wise-ledger/30532/16 "2023-01-18T14:46:18Z")

</div>

Closed on January 18, 2023, 2:46pm UTC


