AccountsReport.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2011 Lluis Turró Cutiller <http://www.turro.org/>
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */
package org.turro.financials.report;
 
public class AccountsReport extends AccountReport {
 
  public AccountsReport() {
    super("Accounts report");
    setShowTotal(true);
    createReport();
    loadData();
  }
 
  private void createReport() {
    AccountReportItem ari1, ari2, ari = addItem("Balance sheet"); // Balanç
    ari1 = ari.addItem("Liabilities"); // Passiu
    ari1.setShowTotal(true);
    ari2 = ari1.addItem("Equity"); // Fons propis
    ari2.setMode(ItemMode.BY_YEAR);
    ari2.addPattern("^1[01234][0-9]*");
    ari2 = ari1.addItem("Long term creditors");
    ari2.setMode(ItemMode.BY_YEAR);
    ari2.addPattern("^1[5678][0-9]*");
    ari2 = ari1.addItem("Short term creditors");
    ari2.setMode(ItemMode.BY_YEAR);
    ari2.addPattern("^4[01][0-9]*");
    ari2.addPattern("^4[68]5[0-9]*");
    ari2.addPattern("^47[5679][0-9]*");
    ari2.addPattern("^499[0-9]*");
    ari2.addPattern("^5[012][0-9]*");
    ari2.addPattern("^56[01][0-9]*");
    ari2.addPattern("^585[0-9]*");
    ari1 = ari.addItem("Assets"); // Actiu
    ari1.setShowTotal(true);
    ari2 = ari1.addItem("Fixed assets"); // Inmobilitzat
    ari2.setMode(ItemMode.BY_YEAR);
    ari2.addPattern("^19[0-9]*");
    ari2.addPattern("^2[0-9]*");
    ari2 = ari1.addItem("Stocks"); // Existències
    ari2.setMode(ItemMode.BY_YEAR);
    ari2.addPattern("^3[0-9]*");
    ari2 = ari1.addItem("Short term debtors");
    ari2.setMode(ItemMode.BY_YEAR);
    ari2.addPattern("^4[34][0-9]*");
    ari2.addPattern("^4[68]0[0-9]*");
    ari2.addPattern("^47[01234][0-9]*");
    ari2.addPattern("^49[034][0-9]*");
    ari2.addPattern("^55[^5][0-9]*");
    ari2.addPattern("^580[0-9]*");
    ari2 = ari1.addItem("Financial investments"); // Inversions financeres
    ari2.setMode(ItemMode.BY_YEAR);
    ari2.addPattern("^5[349][0-9]*");
    ari2.addPattern("^56[56][0-9]*");
    ari2 = ari1.addItem("Outstanding entries"); // Partides pendents
    ari2.setMode(ItemMode.BY_YEAR);
    ari2.addPattern("^555[0-9]*");
    ari2 = ari1.addItem("Liquid assets"); // Tresoreria
    ari2.setMode(ItemMode.BY_YEAR);
    ari2.addPattern("^57[0-9]*");
    ari = addItem("Operating"); // Explotació
    ari1 = ari.addItem("Credit"); // Haver
    ari1.setShowTotal(true);
    ari2 = ari1.addItem("Income"); // Ingresos
    ari2.setMode(ItemMode.BY_TAM);
    ari2.addPattern("^7[01345][0-9]*");
    ari2 = ari1.addItem("Financial receipt"); // Ingresos financers
    ari2.setMode(ItemMode.BY_TAM);
    ari2.addPattern("^76[0-9]*");
    ari2 = ari1.addItem("Nonrecurrent receipt"); // Ingresos extraordinaris
    ari2.setMode(ItemMode.BY_TAM);
    ari2.addPattern("^77[0-9]*");
    ari1 = ari.addItem("Debit"); // Deure
    ari1.setShowTotal(true);
    ari2 = ari1.addItem("Goods"); // Consum
    ari2.setMode(ItemMode.BY_TAM);
    ari2.addPattern("^6[01][0-9]*");
    ari2 = ari1.addItem("Services"); // Serveis
    ari2.setMode(ItemMode.BY_TAM);
    ari2.addPattern("^6[25][0-9]*");
    ari2 = ari1.addItem("Personnel"); // Personal
    ari2.setMode(ItemMode.BY_TAM);
    ari2.addPattern("^64[0-9]*");
    ari2 = ari1.addItem("Tributes"); // Tributs
    ari2.setMode(ItemMode.BY_TAM);
    ari2.addPattern("^63[0-9]*");
    ari2 = ari1.addItem("Financial expenses"); // Despeses financeres
    ari2.setMode(ItemMode.BY_TAM);
    ari2.addPattern("^66[0-9]*");
    ari2.addPattern("^79[0-9]*");
    ari2 = ari1.addItem("Other expenses"); // Altres despeses
    ari2.setMode(ItemMode.BY_TAM);
    ari2.addPattern("^6[789][0-9]*");
 
    AccountReportFormula arf;
    //Operating results - Resultats d'explotació
    arf = addFormula("Operating results");
    arf.setFormula("-@{lIncome} - @{lGoods} - @{lServices} - @{lPersonnel} - @{lTributes}");
    //Cash flow
    arf = addFormula("Cash flow");
    arf.setFormula("@F{lOperatingResults} - @{lFinancialExpenses} + -@{lFinancialReceipt}");
    //Results
    arf = addFormula("Results");
    arf.setFormula("@F{lCashFlow} - @{lOtherExpenses} + -@{lNonrecurrentReceipt}");
    //Return of Equity - Rendabilitat del actiu
    arf = addFormula("Return of equity");
    arf.setFormula("@F{lResults} / (@{lFixedAssets} + @{lStocks} + @{lShortTermDebtors} + @{lFinancialInvestments} + @{lOutstandingEntries} + @{lLiquidAssets})");
    arf.setPercent(true);
  }
 
}