ppt-stdl.png

Jaromír Skorkovský
November 2017, Brno ,Czech Republic
C:\Documents and Settings\lkyncl\Plocha\mat\navertica\PPT\logo-prusvitne10%.png
Basics of  Budget and its use

Basic principles
•Purchase Order
•
•Account 8420
•(Entertainmnent and PR)
•
•F9
•Account 8420
•(Entertainment and PR )
•07.11.14
•General Ledger Item Entries (Debit amounts)
•1500
•07.12.2014
•100
•
•1002
•
•
•
•8420
•
•
•
•9510
•Budget for chosen Year
•(Business Plan)
•D1
•D2
•D3
•D 4
•
•
•2000
•
•1500
•
•
•Difference = 500=2000-1500
•
•
Direct Posting field
must be ticked !!!
•
•
•Difference = 1400
•(1500-100)
•
•
•Dimensions

Simple budget example



PO lines-generation of G/L Entries
4
Dimension = SALES
1.3.19,Cost=1200=20x60
Dimension = ADM
1.3.19, Cost=600=10x60
Post PO 1 and change of Working date  to 1.4.2017
From Icon Line,
Dimensions
Dimension = ADM
1.4.19, Cost=1800
Dimension = SALES
30.1.19,Cost=2400
Purchase Order Line 2

General Ledger Entries (filtered for just created ones)
5
See next slide to se G/L Entries

General Ledger Entries – what was posted =impact of two posted purchase orders
6


Setup data in Budget matrix
7
We have to go back in time

Budget  Matrix
8
Setup of expected (budgeted) values
for chosen dimension

Setup of budget -  values-manually entered
9


Setup of budget -  values-manually entered
10
To  see new setup of budget fro chosen account you must close
 and open budget in order to refresh it !!

Budget
11


Budget calculation for March
12


Budget calculation for April
13


Creation of new  Accounting Schedule view  - home study
14
Use recently created Accounting Schedule TEST (see Intro PWP XIV)
It is necessary to update Analysis view in order to use data
created by this method in period which is not so far included

Account Shcedule
15
Enter data manually

Accounting  Schedule
16
Add  Default column  from predefined set of columns templates

Template of budget Account Schedule (Edit Account Schedule)
17


Overview of Accounting Schedule with use of filters ( SALES)
18
•Net change =600 (1st PO line 1) for ADM dimension ->0
•Net change =1200(2nd PO line 1) for SALES dimension->1200
•Budget is 1000 difference is 20 %
•

Navertica.png
THANKS FOR YOUR ATTENTION AND  TIME