I set up a new company and entered a single purchase to test acquisition tax.
I looked at the Reports, Balance sheet, it looked like this:
Assets: 770 (the input tax)
Liabilities: 770 + 10000 (the acquisition tax + purchase price)
The Equity balance is 0. Shouldn’t the equity be negative 10000 to offset the expense?
It depends on our chart of account.
I looked at the acount_uk example, I can’t see any extra fields on the equity accounts. Can you please clarify what I need to add to the XML?
<record model="account.account.type.template" id="capital_profit_and_loss">
<field name="name">Profit and loss account</field>
<field name="sequence" eval="70"/>
<field name="parent" ref="capital_reserve"/>
<field name="statement">balance</field>
</record>
<record model="account.account.template" id="account_profit_loss">
<field name="name">Profit and Loss Account</field>
<field name="code">3200</field>
<field name="type" ref="capital_profit_and_loss"/>
<field name="parent" ref="account_capital_reserve"/>
</record>
and in account_fr
<record model="account.account.type.template" id="report_a_nouveau">
<field name="name">Report à nouveau</field>
<field name="sequence" eval="60"/>
<field name="parent" ref="capitaux_propres"/>
</record>
<record model="account.account.type.template" id="resultat">
<field name="name">Résultat de l'exercice [bénéfice ou perte]</field>
<field name="sequence" eval="70"/>
<field name="parent" ref="capitaux_propres"/>
<field name="income_statement" eval="False"/>
</record>
<record model="account.account.type.template" id="compte_resultat">
<field name="name">Compte de résultat</field>
<field name="sequence" eval="10"/>
<field name="parent" ref="resultat"/>
<field name="income_statement" eval="True"/>
</record>
<record model="account.account.template" id="12">
<field name="name">Résultat de l'exercice (bénéfice ou perte)</field>
<field name="code">12</field>
<field name="kind">view</field>
<field name="parent" ref="1"/>
</record>
<record model="account.account.template" id="120">
<field name="name">Résultat de l'exercice (bénéfice)</field>
<field name="code">120</field>
<field name="type" ref="resultat"/>
<field name="deferral" eval="True"/>
<field name="kind">other</field>
<field name="parent" ref="12"/>
</record>
<record model="account.account.template" id="129">
<field name="name">Résultat de l'exercice (perte)</field>
<field name="code">129</field>
<field name="type" ref="resultat"/>
<field name="deferral" eval="True"/>
<field name="kind">other</field>
<field name="parent" ref="12"/>
</record>
How do you tell Tryton to use these accounts? Is it in the XML or somewhere else?
I had a closer look at this in another application, Postbooks, in particular, View Financial Reports -> Basic Balance Sheet
I notice that all the lines on the report have an account code except the Net Income line, it has no account code.
Looking at the report definition, I found that the Net Income line is calculated SUM(Type:Revenue) - SUM(Type:Expense)
This makes the report balance.
When looking at the Balance Sheet tree report in Tryton, is there any way to add a line like this for Net Income close to the other Equity accounts?
Or is it only possible to see this in a reporting tool like Jasper?
The reports are based on the tree structure of the account types. So it is up to you to make such tree to display the needed information.
Currently the Revenue and Expense accounts are at the top level of the Chart of Accounts. I could create a Net Income account under Equity, then I could put all
the Revenue and Expense accounts under the Net Income account. Is this the type of solution you are suggesting?
This would nest the entire P&L inside the Balance Sheet
This would display correct numbers but then it is a bit bigger than what some people think of as a balance sheet.
No I’m not talking about accounts but account types.
This is what we do for at least two chart of accounts. This allow to have a balance sheet always up to date.
In the Swiss SME Chart of Accounts, the codes 3, 4, 5, 6, 7, 8 all represent Revenue and Expense accounts.
Code prefixes 7 and 8 both contain a combination of Revenue and Expense.
Based on your feedback, I made all of these sub-types of the P&L account type template. Now it balances.
As a software engineer, I understand the logic behind this. I feel this report is useful. I worked with many accountants in different countries around the world, most of them would find this useful but some of them would feel awkward about using the name “Balance Sheet” for this tree. Balance Sheet has a specific meaning in each country and in each system of accounting.
Thanks for your very prompt and helpful feedback about this.