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
Report is not showing bank Name, only showing Cash at Bank
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.
1 Like
Thanks
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.
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
Thanks @Joe91, I am trying to get a yearly or periodic ledger of the bank account.
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
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?
@Joe91, sometimes the people from the management require the bank ledgers. Thought it is not necessary but sometime legacy prevails.
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?
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?
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”.
You could also create a Custom Report to do this
@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.
This makes it sound like you created an ordinary account rather than a custom control account for bank accounts.
@Tut you are right, I have created ordinary account and not that control account. I got your point.