PANTHEON™ Help

 Toc
 Početna stranica - PANTHEON uputstva
[Collapse]PANTHEON
 [Collapse]PANTHEON priručnici
  [Expand]Vodič po Datalab PANTHEON FarmAccounting
  [Expand]Vodič po PANTHEON Retail
  [Expand]Vodič po DataLab PANTHEON™
  [Expand]Vodič po PANTHEON VET
 [Collapse]PANTHEON korisnički priručnici
  [Expand]Korisnički priručnik za DataLab PANTHEON
  [Expand]Korisnički priručnik za PANTHEON Vet
  [Expand]Korisnički priručnik za PANTHEON Maloprodaju
  [Expand]Korisnički priručnik za PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Vodiči po PANTHEON Web
  [Expand]Vodič za PANTHEON Web Terminal
  [Expand]Vodič po PANTHEON Web Light
  [Expand]Vodič za PANTHEON Web Legal
  [Expand]Arhiva starih proizvoda
 [Collapse]Korisnički priručniki za PANTHEON Web
  [Expand]Kako započeti s programom PANTHEON Web
  [Expand]Korisnički priručnik za PANTHEON Web Light
   Korisnički priručnik za PANTHEON Web Terminal
  [Expand]Korisnički priručnik za PANTHEON Web Legal
  [Expand]Arhiva starih proizvoda
[Collapse]PANTHEON Granule
 [Collapse]Vodič za PANTHEON Granule
  [Expand]Granula Kadrovi
  [Expand]Granula Putni nalozi
  [Expand]Granula Dokumenti i zadaci
  [Expand]Granula Nadzorna ploča
  [Expand]Granula B2B naručivanje
  [Expand]Granula Servis na terenu
  [Expand]Inventar Fiksne Imovine Granula
  [Expand]Granula Inventura skladišta
 [Collapse]Korisnički priručnik za PANTHEON Granule
   Početak
   Primjer korištenja PANTHEON Granula u fiktivnom preduzeću
  [Expand]PANTHEON Granule i aktivacija
  [Expand]Granula Kadrovi
  [Expand]Granula Putni nalozi
  [Expand]Granula Dokumenti i zadaci
  [Expand]Granula B2B Naručivanje
  [Expand]Granula Nadzorna ploča
  [Expand]Granula Servis na terenu
   PANTHEON Granule - česta pitanja i odgovori
  [Expand]Inventar Fiksne Imovine Granula
  [Expand]Inventar u skladištu granula
  [Expand]Arhiva
[Collapse]Korisničke stranice
  Test 2
  Test 3
  Test 5
  TEST_Kreiranje noveg zaposlenika 1000003067
  TEST_Kreiranje noveg zaposlenika 1000003067-MK
  TEST3_Kreiranje novog dokumenta 1000003410-SL
  TEST2_Uređivanje kontaktnih podataka 1000003415-SL
  Test
 [Collapse]Test za CG
   Test podređeni 1
  TEST_Kreiranje noveg zaposlenika 1000003067-BA
  TEST_Kreiranje novog zaposlenika 1000003067-SR
  TEST_Kreiranje noveg zaposlenika 1000003067_EU_ORIG
 [Collapse]Pantheon hosting
  [Expand]Hosting robot
  [Expand]DEMO hosting
  Porez ( cookies )
 [Collapse]Prijava na korisničke stranice
   Registracija za Pantheon korisnike
   Glavna stranica
   Prva posjeta korisničkom sajtu
  Novosti
  Uvod u Wiki
  Upute za stranicu izbornika
 [Collapse]Potpora
  [Expand]Tehnička podrška
   Podrška na daljinu za Host korisnike
  [Expand]Daljinska podrška
  Kako upotrebljavam i dopunjujem wiki ?
 [Collapse]Pomoć
   Pantheon Hosting
   Uporedba verzija pantheona
  [Expand]Dokumentacija
   Vsa navodila
   Video uputstva
   Video novosti
   Pitaj druge korisnike
   Postanite PANTHEON svetovalec
   Sve vijesti
   Svi događaji
   Pregled opomb i planova
   Plan
 [Collapse]Informacije
   Obavijesti
  [Expand]Nastavitev deviznih tečajev
 [Collapse]Moji podaci
   Ugovor o osvježavanju
   Podaci o kompaniji
  [Expand]Pooblaščene osobe
   Dovoljenja
   Lični podaci
   Kontaktni podatci
   Osveževalna pogodba
 [Collapse]Forum
   Spremljanje foruma
 [Collapse]Video
   Instruktivni videozapisi
   Video Ažuriranja
  Portal za razvijače
  Tržnica
 [Collapse]Wiki uputstva
  [Expand]Uvod u wiki
  [Expand]Pretraga po Wikiju
  [Expand]Uređenje Wiki-a
   Pripenjanje dokumentov

Load Time: 1000,0123 ms
"
  6613 | 1 | |
Label


Using Different Date in Displaying Financial Reports

Using Date 2 in Displaying Financial Reports

010381.gif010411.gif010382.gif010383.gif

 

000001.gif

As the various financial reports calculated with different date and other criteria, and recorded in various printouts, we recommend that you save these in a template. Templates are tied to a particular form of financial report.

In financial report template there is switch D.2. If it is marked in a position of financial report, the calculation of the positions using a different set of dates as for other financial report positions (see Financial Statement Report - Date 2). . Switch is effective only at the positions, where in the formula appearing value accounts (eg. #K760%).  It can not therefore be used (or is no effect) on positions, where in formula performs a reference to the second positions of the balance (eg. #A51#).

Switch and additional date criteria used in the income statement (see example below) and in the statement of cash flows.

We can mostly avoid usage of Date 2 by not select initial journal as criteria. Such a consideration applies only to cases where the date 2 is used so that we can eliminate the opening balance of each financial report category.

 

An example of annual P&L report:

One of category of  balance sheet or P&L statement  is formula for Change in stock of products, semi products and unfinished products. For this formula Date 2 information is needed. For this purpose they must be fulfilled two conditions:

  • on the first day of the period (current financial year) only initial balance of stock need to be entered in general ledger,
  • in Date 2 enter dates from 02.01. to 31.12. of fiscal year calculation is prepared.

We design a logical formula in a position of financial report as follows:

  • if the debit transaction (excluding the opening balance, which posted on date 01.01.) is greater than the credit turnover, the difference between the two is considered as increase in stock value,
  • if the debit transaction (excluding the opening balance, which posted on date 01.01.) is less than the credit turnover, the difference between the two is considered as decrease in stock value.

 

Date criteria in such case are entered:

  • the dates for all financial report positions, as well as mandatory yet
  • date 2 for financial report positions, which use other date criteria.

 

When we need also data for the previous year, we need to set same pair of dates for the previous year.

 

000001.gif When using formulas from that example for calculating change of the value in stock of production and unfinished production in  interim financial reports, which decrease initial balance, we need to  skip date of opening balance in Date 2 parameter.

 

Example to display the financial report for the month without opening journal:

P&L for March 2015 has set dates in Period:

  • from 01.03.15 (first date of the period),
  • do 31.03.03 (last date in period).

Date in field Period - Date 2 for P&L which has no opening balance journal need dates set:

  • from 01.03.15 (first date of the period),
  • do 31.03.03 (last date in period).

 

Example to display the financial report for the month with opening journal:

P&L for period from January to March 2015 has set dates in Period:

  • from 01.01.15 (first date of the period),
  • do 31.03.03 (last date in period).

Date in field Period - Date 2 for P&L which has no opening balance journal need dates set:

  • from 02.01.15 (second date of the period),
  • do 31.03.03 (last date in period).

 

000001.gif

To simplify our work it would be recommended to use different template for financial reports which include opening balance journal and those without.

 

 

An example of intermediate P&L report:

 

We need to be careful with using formulas and Date 2 for P&L reports by months. If we set formulas without using date 2, document type for initial balance need to be unmarked (DT 400). Else result (value) in first month (January) will be incorrect. The need to find differences between the opening balance and amount at the end of the period fall off.

Setting criteria that do not take into account the opening journal is preferable to use an extract of the income statement by months as the January result does not "spoil" the state of the opening journal in stock items.

 


  

     


Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!