It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Banking and General Ledger → 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.
Banking & GL => Trial Balance
already has the drill down to the account numbers of interest links.
What drill down are you expecting beyond this?
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
Assets
Total Assets 0.00
Liabilities
Total Liabilities 0.00
Calculated Return 0.00
Total Liabilities and Equities 0.00
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.
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
@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
@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
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
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
Thanks @cedricktshiyoyo for the use case and @joe for the quick update.
Updated Post Release Fixes.
Hi Joe,
I am on 2.4.9 and I do not see this selection on the trial balance report. Why would that be?
(Do not worry, found it on the drill-down, not the report.) Thanks
FrontAccounting forum → Banking and General Ledger → Trial Balance drilldown
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.