Skip to main content
Solved

Trial Balance Multiple Viewing range periods


Jp89
Varsity I
Forum|alt.badge.img

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.

 

Best answer by Gabriel Michaud

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 every natural GL accounts in a different row of the row set, and for each account using the Expand = “Sub” option to list all your subaccounts
  • If you’re a Velixo / 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?”)

 

View original
Did this topic help you find an answer to your question?

4 replies

Gabriel Michaud
Captain II
Forum|alt.badge.img+10

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 every natural GL accounts in a different row of the row set, and for each account using the Expand = “Sub” option to list all your subaccounts
  • If you’re a Velixo / 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
Varsity I
Forum|alt.badge.img
  • Author
  • 71 replies
  • March 15, 2021

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!


  • Freshman I
  • 7 replies
  • May 26, 2021

We were wanting the same report as well. We had to pay for a consultant to create this report for us... 


Forum|alt.badge.img
  • Freshman I
  • 35 replies
  • September 27, 2023

Shocked that this isn’t standard, out of the box report.  It seems like it would be supper common to need a trial balance for a quarter or a year to date to support financial reporting and other closing procedures.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings