18
18
You'll see here the analysis tools for your company's financial situation, in particular:
20
20
.. i18n: * management indicators,
24
22
.. i18n: * budgets,
26
* the accounting dashboard.
28
24
.. i18n: * the accounting dashboard.
26
* management indicators,
30
30
* the accounting dashboard.
32
32
.. i18n: .. index:: indicators
40
40
---------------------
42
42
.. i18n: .. note:: Financial Indicators
44
Indicators, sometimes called financial ratios, are tools for analyzing a company's finances.
45
They enable you to compare two accounts or sets of accounts from the balance sheet or the profit
46
and loss account, in the form of a ratio.
47
They also let you measure the financial health of a company and make comparisons from one year to
48
the next or against those of other companies.
50
.. i18n: Indicators, sometimes called financial ratios, are tools for analyzing a company's finances.
51
.. i18n: They enable you to compare two accounts or sets of accounts from the balance sheet or the profit
52
.. i18n: and loss account, in the form of a ratio.
53
.. i18n: They also let you measure the financial health of a company and make comparisons from one year to
54
.. i18n: the next or against those of other companies.
44
.. i18n: Indicators, sometimes called financial ratios, are tools for analyzing a company's finances.
45
.. i18n: They enable you to compare two accounts or sets of accounts from the balance sheet or the profit
46
.. i18n: and loss account, in the form of a ratio.
47
.. i18n: They also let you measure the financial health of a company and make comparisons from one year to
48
.. i18n: the next or against those of other companies.
50
.. note:: Financial Indicators
56
52
Indicators, sometimes called financial ratios, are tools for analyzing a company's finances.
57
53
They enable you to compare two accounts or sets of accounts from the balance sheet or the profit
82
78
Indicators defined by default in Open ERP are the following:
84
80
.. i18n: * :guilabel:`Indicators of Working Capital` : determines if the company can pay its short term debts in
85
.. i18n: normal conditions. It's calculated from \ ``(Stocks + Cash + Current Assets) / Current
86
.. i18n: Liabilities``\ .
81
.. i18n: normal conditions. It's calculated from \ ``(Stocks + Cash + Current Assets) / Current
82
.. i18n: Liabilities``\ .
84
.. i18n: * :guilabel:`Financial Ratios` : enables you to calculate the company's liquidity. It is defined as follows:
85
.. i18n: \ ``( Current Assets – Stocks) / Current Liabilities``\ .
87
.. i18n: * :guilabel:`Fixed Assets` : in a going concern, the value of fixed assets are covered in the first place by
88
.. i18n: owners' capital and in the second place by all of the long term liabilities. Ideally this indicator
89
.. i18n: will be greater than 1.
91
* :guilabel:`Indicators of Working Capital` : determines if the company can pay its short term debts in
92
normal conditions. It's calculated from \ ``(Stocks + Cash + Current Assets) / Current
88
95
* :guilabel:`Financial Ratios` : enables you to calculate the company's liquidity. It is defined as follows:
89
96
\ ``( Current Assets – Stocks) / Current Liabilities``\ .
91
.. i18n: * :guilabel:`Financial Ratios` : enables you to calculate the company's liquidity. It is defined as follows:
92
.. i18n: \ ``( Current Assets – Stocks) / Current Liabilities``\ .
94
* :guilabel:`Fixed Assets` : in a going concern, the value of fixed assets are covered in the first place by
95
owners' capital and in the second place by all of the long term liabilities. Ideally this indicator
96
will be greater than 1.
98
.. i18n: * :guilabel:`Fixed Assets` : in a going concern, the value of fixed assets are covered in the first place by
99
.. i18n: owners' capital and in the second place by all of the long term liabilities. Ideally this indicator
100
.. i18n: will be greater than 1.
102
98
* :guilabel:`Fixed Assets` : in a going concern, the value of fixed assets are covered in the first place by
103
99
owners' capital and in the second place by all of the long term liabilities. Ideally this indicator
104
100
will be greater than 1.
106
102
.. i18n: .. tip:: Calculation of indicators
104
.. i18n: Calculating indicators can take quite a while in Open ERP because you have to analyse the whole
105
.. i18n: company's accounting entries.
107
.. i18n: So it's best not to calculate all of the indicators at once, but just a small selection to keep
108
.. i18n: calculation time within limits.
110
.. tip:: Calculation of indicators
108
112
Calculating indicators can take quite a while in Open ERP because you have to analyse the whole
109
113
company's accounting entries.
111
.. i18n: Calculating indicators can take quite a while in Open ERP because you have to analyse the whole
112
.. i18n: company's accounting entries.
114
So it's best not to calculate all of the indicators at once, but just a small selection to keep
115
calculation time within limits.
117
.. i18n: So it's best not to calculate all of the indicators at once, but just a small selection to keep
118
.. i18n: calculation time within limits.
120
115
So it's best not to calculate all of the indicators at once, but just a small selection to keep
121
116
calculation time within limits.
177
174
--> Configuration --> Custom Reporting --> New Reporting Item Formula`.
179
176
.. i18n: .. figure:: images/account_indicator_new.png
181
.. i18n: :align: center
183
*Defining a new indicator*
185
.. i18n: *Defining a new indicator*
178
.. i18n: :align: center
180
.. i18n: *Defining a new indicator*
182
.. figure:: images/account_indicator_new.png
187
186
*Defining a new indicator*
195
194
the instructions at the bottom of the form:
197
196
.. i18n: * Sum of debits in a general account: \ ``debit('12345')``\ ,
199
* Sum of credits in a general account: \ ``credit('12345')``\ ,
201
198
.. i18n: * Sum of credits in a general account: \ ``credit('12345')``\ ,
203
* Balance of a general account: \ ``balance('12345')``\ ,
205
200
.. i18n: * Balance of a general account: \ ``balance('12345')``\ ,
207
* Value of another indicator: \ ``report ('IND')``\ .
209
202
.. i18n: * Value of another indicator: \ ``report ('IND')``\ .
204
* Sum of debits in a general account: \ ``debit('12345')``\ ,
206
* Sum of credits in a general account: \ ``credit('12345')``\ ,
208
* Balance of a general account: \ ``balance('12345')``\ ,
211
210
* Value of another indicator: \ ``report ('IND')``\ .
217
216
.. i18n: * \ ``12345``\ represents the code of a general account,
219
* \ ``IND``\ represents the code of another indicator.
221
218
.. i18n: * \ ``IND``\ represents the code of another indicator.
220
* \ ``12345``\ represents the code of a general account,
223
222
* \ ``IND``\ represents the code of another indicator.
225
224
.. i18n: So, using this notation, the cash ratio is defined by \ ``balance('4', '5') / balance('1')``\ –
257
256
to define a new budget.
259
258
.. i18n: .. index::
260
.. i18n: single: budget revisions
259
.. i18n: single: budget revisions
263
262
single: budget revisions
265
264
.. i18n: .. tip:: Budget Revisions
266
.. i18n: Even though you *can* modify a budget at any time to make a revision of it, it's best if you don't do
269
.. i18n: Rather than edit an existing budget document, make a new version so that you can keep your original
270
.. i18n: estimates safe for comparison. This lets you analyze your changing perspectives of the
271
.. i18n: company from revision to revision.
273
.. tip:: Budget Revisions
267
275
Even though you *can* modify a budget at any time to make a revision of it, it's best if you don't do
270
.. i18n: Even though you *can* modify a budget at any time to make a revision of it, it's best if you don't do
273
Rather than edit an existing budget document, make a new version so that you can keep your original
274
estimates safe for comparison. This lets you analyze your changing perspectives of the
275
company from revision to revision.
277
.. i18n: Rather than edit an existing budget document, make a new version so that you can keep your original
278
.. i18n: estimates safe for comparison. This lets you analyze your changing perspectives of the
279
.. i18n: company from revision to revision.
281
278
Rather than edit an existing budget document, make a new version so that you can keep your original
282
279
estimates safe for comparison. This lets you analyze your changing perspectives of the
283
280
company from revision to revision.
291
288
Then you can define the budgeted amounts within that period, one by one. For each, you define:
293
290
.. i18n: * an :guilabel:`Analytic Account`
295
* a :guilabel:`Budgetary Position` : for example :guilabel:`Sales` or :guilabel:`Purchases`,
297
292
.. i18n: * a :guilabel:`Budgetary Position` : for example :guilabel:`Sales` or :guilabel:`Purchases`,
299
* a :guilabel:`Start Date` and :guilabel:`End Date` for the use of the budget,
301
294
.. i18n: * a :guilabel:`Start Date` and :guilabel:`End Date` for the use of the budget,
303
* a :guilabel:`Planned Amount` in the default currency of the chart of accounts.
305
296
.. i18n: * a :guilabel:`Planned Amount` in the default currency of the chart of accounts.
298
* an :guilabel:`Analytic Account`
300
* a :guilabel:`Budgetary Position` : for example :guilabel:`Sales` or :guilabel:`Purchases`,
302
* a :guilabel:`Start Date` and :guilabel:`End Date` for the use of the budget,
307
304
* a :guilabel:`Planned Amount` in the default currency of the chart of accounts.
309
306
.. i18n: Once it's completed you can save your budget.
323
320
The figure :ref:`fig-accbudg` gives an example of a budget produced by Open ERP.
325
322
.. i18n: .. _fig-accbudg:
324
.. i18n: .. figure:: images/account_budget.png
326
.. i18n: :align: center
328
.. i18n: *Printing a budget*
327
332
.. figure:: images/account_budget.png
331
.. i18n: .. figure:: images/account_budget.png
333
.. i18n: :align: center
337
.. i18n: *Printing a budget*
339
336
*Printing a budget*
341
338
.. i18n: You could also use the menu :menuselection:`Financial Management --> Reporting --> Budgets`
355
352
------------------------
357
354
.. i18n: .. figure:: images/account_board.png
359
.. i18n: :align: center
361
*Accounting Dashboard*
363
.. i18n: *Accounting Dashboard*
356
.. i18n: :align: center
358
.. i18n: *Accounting Dashboard*
360
.. figure:: images/account_board.png
365
364
*Accounting Dashboard*
367
366
.. i18n: .. index::
368
.. i18n: single: module; board_account
367
.. i18n: single: module; board_account
371
370
single: module; board_account
387
386
.. i18n: * :guilabel:`Analytic accounts to close` : when you're managing cases each analytical account is a
388
.. i18n: project or a contract. This area gives the accounts that must be closed (for example, contracts
389
.. i18n: expired, support hours exceeded).
387
.. i18n: project or a contract. This area gives the accounts that must be closed (for example, contracts
388
.. i18n: expired, support hours exceeded).
390
.. i18n: * :guilabel:`Accounts to invoice` : shows analytical accounts where there are charges to be
393
.. i18n: * :guilabel:`Draft invoices` : gives the list of invoices waiting to be approved by an accountant.
395
.. i18n: * :guilabel:`Costs to invoice` : gives the weekly changes which can be, but haven't yet been,
398
.. i18n: * :guilabel:`Aged receivables` : gives a weekly graph of the receivables that haven't yet been
401
.. i18n: * :guilabel:`Aged income` : gives a weekly graph of the company's turnover.
403
* :guilabel:`Analytic accounts to close` : when you're managing cases each analytical account is a
404
project or a contract. This area gives the accounts that must be closed (for example, contracts
405
expired, support hours exceeded).
391
407
* :guilabel:`Accounts to invoice` : shows analytical accounts where there are charges to be
394
.. i18n: * :guilabel:`Accounts to invoice` : shows analytical accounts where there are charges to be
397
410
* :guilabel:`Draft invoices` : gives the list of invoices waiting to be approved by an accountant.
399
.. i18n: * :guilabel:`Draft invoices` : gives the list of invoices waiting to be approved by an accountant.
401
412
* :guilabel:`Costs to invoice` : gives the weekly changes which can be, but haven't yet been,
404
.. i18n: * :guilabel:`Costs to invoice` : gives the weekly changes which can be, but haven't yet been,
407
415
* :guilabel:`Aged receivables` : gives a weekly graph of the receivables that haven't yet been
410
.. i18n: * :guilabel:`Aged receivables` : gives a weekly graph of the receivables that haven't yet been
413
* :guilabel:`Aged income` : gives a weekly graph of the company's turnover.
415
.. i18n: * :guilabel:`Aged income` : gives a weekly graph of the company's turnover.
417
418
* :guilabel:`Aged income` : gives a weekly graph of the company's turnover.
419
420
.. i18n: In each panel of the accountants' dashboard you can click the :guilabel:`Zoom` button at the top