<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Trial Balance drilldown]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=8842&amp;type=atom" />
	<updated>2021-04-25T17:49:48Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=8842</id>
		<entry>
			<title type="html"><![CDATA[Re: Trial Balance drilldown]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=39373#p39373" />
			<content type="html"><![CDATA[<p>Hi Joe,</p><p>I am on 2.4.9 and I do not see this selection on the trial balance report. Why would that be?</p><p>(Do not worry, found it on the drill-down, not the report.) Thanks</p>]]></content>
			<author>
				<name><![CDATA[seahawk]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=544</uri>
			</author>
			<updated>2021-04-25T17:49:48Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=39373#p39373</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Trial Balance drilldown]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=37692#p37692" />
			<content type="html"><![CDATA[<p>Thanks @cedricktshiyoyo for the use case and @joe for the quick update.</p><p>Updated <a href="https://frontaccounting.com/punbb/viewtopic.php?pid=37005#p37005">Post Release Fixes</a>.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2020-06-25T05:46:52Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=37692#p37692</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Trial Balance drilldown]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=37677#p37677" />
			<content type="html"><![CDATA[<p>This has now been fixed with an extra checkbox, &#039;Group totals only&#039;.</p><p>Committed to 2.4.8 stable. The fixed file can be downloaded <a href="https://sourceforge.net/p/frontaccounting/git/ci/master/tree/gl/inquiry/gl_trial_balance.php">here</a>.</p><p>/joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2020-06-22T13:18:57Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=37677#p37677</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Trial Balance drilldown]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=37676#p37676" />
			<content type="html"><![CDATA[<p>Hello again,</p><p>I have been thinking a bit more about this. Even if I don&#039;t like it, I will try to implement it with a checkbox. So stay tuned.</p><p>/Joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2020-06-22T12:31:13Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=37676#p37676</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Trial Balance drilldown]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=37672#p37672" />
			<content type="html"><![CDATA[<p>@apmuthu&nbsp; I have seen the pictures you put in the attachment, that is what I was talking about.</p><p>You may&nbsp; 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.</p><p>@joe should think about it, if He finds it useful, it can be added to the FA Core. </p><p>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.</p><p>Regards to all</p>]]></content>
			<author>
				<name><![CDATA[cedricktshiyoyo]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=45118</uri>
			</author>
			<updated>2020-06-21T18:13:50Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=37672#p37672</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Trial Balance drilldown]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=37671#p37671" />
			<content type="html"><![CDATA[<p>@joe You&#039;re 100% right, actually the FA trial balance has no problem at all. </p><p>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,<br />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.</p><p>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&#039;s credit sales to customers, each customer&#039;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.</p><p>This make it easy to read a trial balance. By the way it is there in FA for Balance Sheet &amp; Profit Loss report. But not for Trial Balance if you noticed. @apmuthu</p>]]></content>
			<author>
				<name><![CDATA[cedricktshiyoyo]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=45118</uri>
			</author>
			<updated>2020-06-21T18:02:18Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=37671#p37671</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Trial Balance drilldown]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=37670#p37670" />
			<content type="html"><![CDATA[<p>Hello Guys,</p><p>Is this really needed? I think the main reason for a Trial Balance is for investigating all the accounts (not the totals).<br />You get the totals summarized as a feature already now.</p><p>If you need the Group Totals only, you could as well use the Balance Sheet and Profit and Loss Drill Downs.</p><p>Are there any interest in this change by the Senior Members?</p><p>/Joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2020-06-21T07:48:59Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=37670#p37670</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Trial Balance drilldown]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=37669#p37669" />
			<content type="html"><![CDATA[<p>Check if the attachment is what you need.</p><p>@joe: if acceptable, it can be placed with a checkbox in the filter fields to achieve this feature.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2020-06-21T02:41:01Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=37669#p37669</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Trial Balance drilldown]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=37667#p37667" />
			<content type="html"><![CDATA[<p>Assets<br />Total Assets &nbsp; &nbsp; 0.00<br />Liabilities<br />Total Liabilities &nbsp; &nbsp; 0.00<br />Calculated Return &nbsp; &nbsp; 0.00<br />Total Liabilities and Equities &nbsp; &nbsp; 0.00</p>]]></content>
			<author>
				<name><![CDATA[cedricktshiyoyo]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=45118</uri>
			</author>
			<updated>2020-06-20T15:23:20Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=37667#p37667</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Trial Balance drilldown]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=37666#p37666" />
			<content type="html"><![CDATA[<p>Sorry I meant displaying the summary of account groups just like for Balance Sheet and Profit Loss.</p><p>Without listing all accounts details:</p><p>example:<br />&nbsp; &nbsp; <br />Account &nbsp; &nbsp; Account Name &nbsp; &nbsp; Brought Forward &nbsp; &nbsp; This Period &nbsp; &nbsp; Balance<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Debit &nbsp; &nbsp; Credit &nbsp; &nbsp; Debit Credit &nbsp; &nbsp; Debit Credit<br />Class - 1 - Assets<br />Group - 1 - Current Assets<br />Total - Current Assets &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00<br />Group - 2 - Inventory Assets<br />Total - Inventory Assets &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00<br />Group - 3 - Capital Assets<br />Total - Capital Assets &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00<br />Class - 2 - Liabilities<br />Group - 4 - Current Liabilities</p><p>Total - Current Liabilities &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00<br />Group - 5 - Long Term Liabilities</p><p>Total - Long Term Liabilities &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00<br />Group - 6 - Share Capital<br />Total - Share Capital &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00<br />Group - 7 - Retained Earnings<br />3590 &nbsp; &nbsp; Retained Earnings - prior years &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00<br />Total - Retained Earnings &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00<br />Class - 3 - Income<br />Group - 8 - Sales Revenue<br />4010 &nbsp; &nbsp; Sales &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00<br />Total - Sales Revenue &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00<br />Group - 9 - Other Revenue</p><p>Total - Other Revenue &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00<br />Class - 4 - Expense<br />Group - 10 - Cost of Goods Sold</p><p>Total - Cost of Goods Sold &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00<br />Group - 11 - Payroll Expenses</p><p>Total - Payroll Expenses &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00<br />Group - 12 - General &amp; Administrative expenses</p><p>9990 &nbsp; &nbsp; Year Profit/Loss &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00<br />Total - General &amp; Administrative expenses &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00<br />Total - 06/30/2018 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; 0.00<br />Ending Balance - 06/30/2018 &nbsp; &nbsp; 0.00 &nbsp; &nbsp; &nbsp; &nbsp; 0.00 &nbsp; &nbsp; &nbsp; &nbsp; 0.00</p>]]></content>
			<author>
				<name><![CDATA[cedricktshiyoyo]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=45118</uri>
			</author>
			<updated>2020-06-20T15:20:47Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=37666#p37666</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Trial Balance drilldown]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=37664#p37664" />
			<content type="html"><![CDATA[<p>Banking &amp; GL =&gt; Trial Balance<br />already has the drill down to the account numbers of interest links.</p><p>What drill down are you expecting beyond this?</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2020-06-20T08:12:54Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=37664#p37664</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Trial Balance drilldown]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=37659#p37659" />
			<content type="html"><![CDATA[<p>Hello everyone</p><p>is it possible to obtain a trial balance in drill down? Just the same way as for Balance SHeet And Profit Loss Drill down.<br />Without listing all the accounts in details, since account details can be obtained in the general ledger report.</p>]]></content>
			<author>
				<name><![CDATA[cedricktshiyoyo]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=45118</uri>
			</author>
			<updated>2020-06-18T15:12:00Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=37659#p37659</id>
		</entry>
</feed>
