Topic: Trial Balance drilldown

Hello everyone

is it possible to obtain a trial balance in drill down? Just the same way as for Balance SHeet And Profit Loss Drill down.
Without listing all the accounts in details, since account details can be obtained in the general ledger report.

Re: Trial Balance drilldown

Banking & GL => Trial Balance
already has the drill down to the account numbers of interest links.

What drill down are you expecting beyond this?

Re: Trial Balance drilldown

Sorry I meant displaying the summary of account groups just like for Balance Sheet and Profit Loss.

Without listing all accounts details:

example:
   
Account     Account Name     Brought Forward     This Period     Balance
                                                Debit     Credit     Debit Credit     Debit Credit
Class - 1 - Assets
Group - 1 - Current Assets
Total - Current Assets     0.00     0.00     0.00     0.00     0.00     0.00
Group - 2 - Inventory Assets
Total - Inventory Assets     0.00     0.00     0.00     0.00     0.00     0.00
Group - 3 - Capital Assets
Total - Capital Assets     0.00     0.00     0.00     0.00     0.00     0.00
Class - 2 - Liabilities
Group - 4 - Current Liabilities

Total - Current Liabilities     0.00     0.00     0.00     0.00     0.00     0.00
Group - 5 - Long Term Liabilities

Total - Long Term Liabilities     0.00     0.00     0.00     0.00     0.00     0.00
Group - 6 - Share Capital
Total - Share Capital     0.00     0.00     0.00     0.00     0.00     0.00
Group - 7 - Retained Earnings
3590     Retained Earnings - prior years     0.00     0.00     0.00     0.00     0.00     0.00
Total - Retained Earnings     0.00     0.00     0.00     0.00     0.00     0.00
Class - 3 - Income
Group - 8 - Sales Revenue
4010     Sales     0.00     0.00     0.00     0.00     0.00     0.00
Total - Sales Revenue     0.00     0.00     0.00     0.00     0.00     0.00
Group - 9 - Other Revenue

Total - Other Revenue     0.00     0.00     0.00     0.00     0.00     0.00
Class - 4 - Expense
Group - 10 - Cost of Goods Sold

Total - Cost of Goods Sold     0.00     0.00     0.00     0.00     0.00     0.00
Group - 11 - Payroll Expenses

Total - Payroll Expenses     0.00     0.00     0.00     0.00     0.00     0.00
Group - 12 - General & Administrative expenses

9990     Year Profit/Loss     0.00     0.00     0.00     0.00     0.00     0.00
Total - General & Administrative expenses     0.00     0.00     0.00     0.00     0.00     0.00
Total - 06/30/2018     0.00     0.00     0.00     0.00     0.00     0.00
Ending Balance - 06/30/2018     0.00         0.00         0.00

Re: Trial Balance drilldown

Assets
Total Assets     0.00
Liabilities
Total Liabilities     0.00
Calculated Return     0.00
Total Liabilities and Equities     0.00

Re: Trial Balance drilldown

Check if the attachment is what you need.

@joe: if acceptable, it can be placed with a checkbox in the filter fields to achieve this feature.

Post's attachments

GL_TB_Summary_Mod.zip 350.7 kb, 8 downloads since 2020-06-21 

You don't have the permssions to download the attachments of this post.

Re: Trial Balance drilldown

Hello Guys,

Is this really needed? I think the main reason for a Trial Balance is for investigating all the accounts (not the totals).
You get the totals summarized as a feature already now.

If you need the Group Totals only, you could as well use the Balance Sheet and Profit and Loss Drill Downs.

Are there any interest in this change by the Senior Members?

/Joe

Re: Trial Balance drilldown

@joe You're 100% right, actually the FA trial balance has no problem at all.

But a filter could be added to reduce the long list of all accounts, imagine if you have 2000 asset accounts, 1000 liabilities, Income and Expenses,
I doubt you will be able to read and understand your own trial balance. a filter can be added just like No Zero Balance and Balance Only check-boxes. Usually this is solved with subsidiary Ledger which I think is also missing in FA.

A subsidiary ledger contains the details to support a general ledger control account. For instance, the subsidiary ledger for accounts receivable contains the information for each of the company's credit sales to customers, each customer's remittance, return of merchandise, discounts, and so on. With these details in the subsidiary ledger, the Accounts Receivable account in the general ledger can report summary amounts for the accounts receivable activity.

This make it easy to read a trial balance. By the way it is there in FA for Balance Sheet & Profit Loss report. But not for Trial Balance if you noticed. @apmuthu

Re: Trial Balance drilldown

@apmuthu  I have seen the pictures you put in the attachment, that is what I was talking about.

You may  have several accounts under current assets (for example ) but do not need to display all of them, you just need a summary amount, whether debit or credit.

@joe should think about it, if He finds it useful, it can be added to the FA Core.

By the way we have to keep in mind that there many Accounting software today, to become number one choice, we have to contribute not only with programming part, but also providing ideas whererever Senior Programmer have not noticed some things that are lacking.

Regards to all

Re: Trial Balance drilldown

Hello again,

I have been thinking a bit more about this. Even if I don't like it, I will try to implement it with a checkbox. So stay tuned.

/Joe

Re: Trial Balance drilldown

This has now been fixed with an extra checkbox, 'Group totals only'.

Committed to 2.4.8 stable. The fixed file can be downloaded here.

/joe

Re: Trial Balance drilldown

Thanks @cedricktshiyoyo for the use case and @joe for the quick update.

Updated Post Release Fixes.