Trial Balance Multiple Viewing range periods

Question

Currently when viewing the Trial Balance (detailed) you can only view one financial period at a time.

It would be beter as accountant that I should be able to select start period and end period. So I could e.g. Say show the the Trial Balance and movement from 1 March 2020 to say 31 May 2020. The trail balance should therefore show the Opening balance as at 1 March 2020, the accumulated Debits and Credits for the period (3 months), and then the final closing balance as at 31 May 2020.

Currently we are limited to only obtaining a trial balance for one financial period at a time. It make analysis of financial results cumbersome to work with, and each financial period needs to be exported and then summed and grouped in excel… very time consuming unnecessarily so.

icon

Best answer by Gabriel Michaud 15 March 2021, 14:44

View original

Gabriel Michaud · Accepted Answer

Hi @Jp89,I was going to sugest using the Accounts by Subaccount inquiry, but realized the same limitation exists there as well.The two options that I see are:Using ARM (Analytical Report Manager). Since it’s not possible to expand by *both* accounts and subaccounts you would need to list everynatural GL accounts in a differentrow of the row set, and for each account using the Expand = “Sub” option to list all your subaccountsIf you’re aVelixo / Excel user, you can use the ACCOUNTSANDSUBACCOUNTSWITHHISTORY function to build something like this in a few seconds…there’s a blog post here explaining how to do it (look for “Does your company produce detailed balance reports by sub-account?”)

Jp89 · Answer

Thanks, Ill give that a try, but Im not a Velixo user.Should, nonetheless, be a standard out-the-box- feature from an ERP solution!

Trial Balance Multiple Viewing range periods

4 replies

Reply

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded