Bank reconcilations report

hi all , is there any way can export a report same with bank reconciliation page ? showing credit and debit by dates ? basically a report with date / descriptions/debit/credits column

Use the General Ledger Transactions report.

1 Like

actually i want to have the actual receipt and payments done at bank account instead , so that easier for bank reconciliation … if the bank reconciliation page had option to copy to clipboard would have been great

If you mean you want the report to be generated in the Bank and Cash Accounts tab, that will not happen. All reports are created under the Reports tab. If you mean something else, please explain in more detail.

A bank reconciliation View screen is the display of results of hard-coded processing of data in the database. It is not something you can manipulate. But if you want a copy of it, use the print-to-PDF feature of your operating system.

So, if I understand correctly, the aim is to make a printout of the transactions of one specific bank or cash account so that these transactions can be compared with the transactions as stated on, for example, the bank statement.
Unfortunately, since the various bank and cash accounts have been merged under [Cash and cash equivalents, it is no longer possible to print out a report per bank account. As far as I know.
The closest thing to it is [Reports]-[General Ledger Transactions]-[Account Cash & cash equivalents].
But that report therefore includes the transactions of, for instance, Cash and or another bank account.
Definitely not useful if you have a lot of transactions.
I have therefore chosen to enter the bank transactions per day so that the number of mutations, and thus the risk of errors, is clear and small.
But that is a personal solution, and certainly not given to everyone.
If anyone has a bright idea, I’m all ears.

You can create a custom control account for each bank account, rather than leaving them all in the default control account. Then, you will be able to create a General Ledger Transactions report for an individual bank account.

Got it! Thank you!

ok my issue is like this - its retail store so we have lots of transactions - so usually from pos we sumup and make entries , so when trying to do the bank reconciliation , i am really stuck …
now i am doing a manual way - going to bank transactions - actual balance and copy to clipboard the in /out , then comparing against bank statement entries , but too time consuming :frowning:

@Sooraj, I don’t think I fully understand what you are trying to do. If you are entering summaries from your point of sale system, you are never going to be able to match those summary entries to individual transactions on the bank statement. According to your description, you are entering a single transaction for the entire day into Manager, but the bank may have dozens or hundreds of individual transactions that same day.

If you want to reconcile these transactions with the bank statement, you should be comparing the statement to the output from the point of sale system, not Manager.