Bank account balance report for all companies on given date

(0) Share

Report

Posted on by Maarija

Hi everyone!

I need to display a report on the balance of all bank accounts of all companies on a specific date.

I found a report "Bank account balance report", but it includes only the active company and request time balance.
Another report in the "Cash overview – all companies" workspace is displayed for several companies (as I understand it, what the administrator defines), but also exclusively request time balance.

So I have a question, is it possible to somehow display the balance on a given date? Perhaps there is some other report that I do not know.

I would be grateful for any help.

Marija

All responses (3)

Answers (1)

Verified answer

Zain Mehmood 3,021 Moderator on at

Like (1)

Report

RE: Bank account balance report for all companies on given date

Hi Maarija,

I had the same two option which Ludwig & Mattguo already shared but in your case you need one report for all companies. I reckon if you manage to built a report on the Management reporter for this aspect. You can achieve your goal, just like Ludwig said the bank account is used in as a different ledger account. You can build a report for your ease which can show you the respective data for the bank accounts for all the companies.

Warm Regards,

Zain
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

RE: Bank account balance report for all companies on given date

Hi Marija,

The bank statement report that Mattguo shared is one option.

Another one are the standard ledger reports, such as the trial balance.

That is because your bank accounts are linked to individual ledger accounts and you can inquire the balance also starting from GL, which literally represents the other side of the same coin ;-)

Best regards,

Ludwig
MATTGUO 22,319 Moderator on at

Like (1)

Report

RE: Bank account balance report for all companies on given date

Hi Maarija,

Please check the bank statement report, and the path is cash and bank management > inquiries and reports > bank reconciliation reports > bank statement.