Project controlling and billing in WINPACCS Cloud Michael Bork, mbi - - PowerPoint PPT Presentation

project controlling and billing in winpaccs cloud
SMART_READER_LITE
LIVE PREVIEW

Project controlling and billing in WINPACCS Cloud Michael Bork, mbi - - PowerPoint PPT Presentation

Project controlling and billing in WINPACCS Cloud Michael Bork, mbi GmbH Proj oject ect contr trolli olling ng and billing ng in WINPACCS Cloud ud Workshop 04 Block II (13:30-14:15) Project controlling and billing in WINPACCS Cloud


slide-1
SLIDE 1

Project controlling and billing in WINPACCS Cloud

Michael Bork, mbi GmbH

slide-2
SLIDE 2

Workshop

Michael Bork

Head of Conceptual Design

Learn about the new Project controlling and billing function in WINPACCS Cloud. Discover how to create and edit even complex analyses quickly and easily on your screen. You’ll be impressed by the variety of information and functions available in the new Project controlling and the wide range of analyses they can produce.

Block II (13:30-14:15)

Project controlling and billing in WINPACCS Cloud

04

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

05.11.2019 2

SYMPOSIUM 2019

slide-3
SLIDE 3

Agenda

  • 1. Project controlling basics
  • 2. Postings section
  • 3. Individual postings
  • 4. Analyses section
  • 5. Logs section

05.11.2019

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

3

slide-4
SLIDE 4
  • The Project controlling feature facilitates project controlling that meets the

requirements of development cooperation

  • Internal, donor and partner budgets can be set up and plan/actual comparisons

performed

  • Financial reports can be created to meet the various requirements of donor
  • rganisations
  • Margin costing can be performed
  • Quantity budgets can be drawn up and evaluated
  • Diverse options are available for analysing the posting data for project controlling

purposes

Project controlling and billing

Projec

  • ject cont

ntrol

  • llin

ling an and d billin lling g in n WINP NPACCS CS Cloud

05.11.2019 4

slide-5
SLIDE 5

Basics

05.11.2019

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

5

slide-6
SLIDE 6

Data available in Project controlling

  • Project costs and income from Project accounting and Company

accounting

  • Revenue from Company accounting
  • Partner costs and income – for information purposes
  • Project committed costs (from summer 2020)
  • Donor, partner and internal project budgets
  • Many other classification information items

05.11.2019

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

6

slide-7
SLIDE 7

Postings functional group

  • Contains all the postings of the

Project accounting in separate journals

  • The data cannot be changed

Project controlling functional group

  • Contains all the costs and income from

the Project accounting from own and external journals

  • Includes costs and income from the

Company accounting

  • Contains partner costs and income –

for information purposes

  • Changing data is permitted in certain

areas

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

05.11.2019 7

slide-8
SLIDE 8

Workflow in WINPACCS 2018

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

05.11.2019 8 Upload day-end closing (month-end closing) Return closing View all the relevant postings in Postings FA Confirm the closing in Postings FA WINPACCS Accounting WINPACCS Postings FA Company accounting Company accounting Forward data: WINPACCS Project controlling and CA Creating analyses WINPACCS Project controlling FA Enter posting View all postings Restricted adjustment of postings

slide-9
SLIDE 9

Project controlling and billing

Live demo

Projec

  • ject cont

ntrol

  • llin

ling an and d billin lling g in n WINP NPACCS CS Cloud

05.11.2019 9

slide-10
SLIDE 10

Starting Project controlling

05.11.2019

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

10

slide-11
SLIDE 11

Postings section

05.11.2019

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

11

slide-12
SLIDE 12

Posting overview

05.11.2019

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

12

All cost and income postings posted in this project are displayed in a table. Numerous functions for customising the table are available.

slide-13
SLIDE 13

Selecting views

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

05.11.2019 13

You can create your own views in the navigation area and share them with

  • ther users.
slide-14
SLIDE 14

There are various table columns available to configure your own view.

Selecting columns

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

05.11.2019 14

slide-15
SLIDE 15

Columns available in Posting overview

  • Project number
  • Project
  • Journal number
  • Journal
  • Voucher number
  • Voucher position
  • Posting number
  • Accounting period
  • Voucher date
  • Transaction category
  • Transaction type
  • Recipient / Depositor
  • Partner number
  • Partners
  • Posting text

05.11.2019

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

15

  • Debit account
  • Debit sub-account
  • Credit account
  • Credit sub-account
  • Account
  • Amount D/C
  • VC amount
  • VC
  • CC amount
  • CC
  • Entry number
  • Comment on the posting

text

  • Posting date
  • Internal voucher
  • Funding
  • External project number
  • External project
  • External funding
  • Cost centre number
  • Cost centre
  • {Budget structures 1 - 6}
  • Quantity
  • Unit of quantity
  • External budget line
  • Average rate posting
  • Average rate posting

position

  • Cheque number
  • Order number
  • Personnel number
  • Contract number
  • External invoice number
  • Internal invoice number
  • Reference number
  • Entered by
  • Accountant
  • Voucher scan
  • Posting status
  • Computer-generated

posting

  • Reversed posting
  • Reposted
  • Country
  • Entry system
  • Billed
  • Voucher type
  • Voucher category
  • {Cost category

groups}

  • Reporting currency

scheme

  • Reporting period
  • RC
  • Amount RC
  • Exchange rate RC
  • Posting cost centre
  • External period
  • External voucher

number

  • External voucher

position

slide-16
SLIDE 16

Configuration of the posting overview

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

05.11.2019 16

Individual settings, such as adding quick filters

  • r highlighting postings, can be made in the

configuration area.

slide-17
SLIDE 17

Grouping with totals

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

05.11.2019 17

For groupings, the totals for each group are displayed in all currencies.

slide-18
SLIDE 18

Multiple selection

05.11.2019

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

18

Multiple selection allows several posting positions to be edited simultaneously.

slide-19
SLIDE 19

Individual postings

05.11.2019

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

19

slide-20
SLIDE 20

Posting position view

05.11.2019

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

20

A posting position is displayed clearly.

slide-21
SLIDE 21

Documenting changes

05.11.2019

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

21

All changes to a posting position are logged in detail in the history.

slide-22
SLIDE 22

Posting position with a digital voucher

05.11.2019

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

22

If a digital voucher exists for the posting position, it can be displayed.

slide-23
SLIDE 23

Posting position with comments

05.11.2019

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

23

Comments can be entered for each posting position.

slide-24
SLIDE 24

Splitting a posting

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

05.11.2019 24

A posting position can be split, for example, between several budget lines.

slide-25
SLIDE 25

Analyses section

05.11.2019

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

25

slide-26
SLIDE 26

Various analyses

05.11.2019

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

26

You can create analyses using cost categories, budget structures, or cost category groups.

slide-27
SLIDE 27

Budget lines with quantities

05.11.2019

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

27

Analyses can be created with quantity columns.

slide-28
SLIDE 28

Breakdown of table columns

05.11.2019

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

28

Table columns can be broken down according to different criteria, e.g. by quarter.

slide-29
SLIDE 29

Fields available for breakdown by

  • Year,
  • Quarter,
  • Accounting periods,
  • Journal classes (e.g. Project accounting, Partner accounting and

Company accounting).

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

05.11.2019 29

slide-30
SLIDE 30

Assigned posting positions

05.11.2019

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

30

The posting positions assigned to a budget line can be displayed by a mouse click.

slide-31
SLIDE 31

Margin costing

05.11.2019

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

31

If revenue is imported from Company accounting, the Contribution margin analysis is also available.

slide-32
SLIDE 32

Logs section

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

05.11.2019 32

slide-33
SLIDE 33

Change log

05.11.2019

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

33

All changes to the posting positions are logged in one place.

  • Which field was changed?
  • Who changed this posting position?
  • When was it changed?
  • Why was it changed (optional)?
  • Options for filtering and sorting
slide-34
SLIDE 34

Overview of Change log

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

05.11.2019 34

slide-35
SLIDE 35

Any questions?

05.11.2019

Proj

  • ject

ect contr trolli

  • lling

ng and billing ng in WINPACCS Cloud ud

35