Compiere Training

1
Compiere Training

• Accounting, Tax
• Performance Analysis

2
Agenda
Show Accounting Tools gt PreferenceRole Security

• Performance Analysis
• Information Dimensions
• Calendar Periods
• Accounting Schema
• Charge
• Tax
• Accounting Details

3
Performance Analysis
4
Terminology
5
Information Dimensions

• Organization
• Owning (balance sheet)
• Transacting (executing org or service center)
• Natural Account
• Product
• Business Partner
• Project
• Marketing Campaign
• Location (Warehouse, Business Partner)
• From - To
• Activity (Activity Based Costing)
• User Defined (2)

Accounting Schema Elements (Segments)
6
Principles

• Accounting entry at the lowest level
• (Accounting Fact)
• Any Accumulation
• Trees for Summary Navigation
• Element Values derived from Transaction
• Directly (entered)
• Derived
• Differentiate Document from Accounting
  Consequence
• Multiple Accounting Schema

7
Dimensions Tree Conversion
8
Tree Characteristics

• You can post only to Leaf Level
• You can report on Summary and Leaf Level
• You can change Structure any time
• HQ Operations
• Extra Leaf / Summary required
• E.g. Differentiate Direct Sales level
  transactions from individual Stores
• Different Modeling Options
• Dependent what you want to report on

9
Dimension Tree Alternative
10
Calendar Period

• Two Dates
• Document Date
• Accounting Date
• Calendar Period only for control reporting
  purposes
• No End Period processes
• Period can be automatically opened
• You cannot post in closed periods Change
  accounting date (or re-open)
• Controlling Calendar defined on Client Level

11
Account Element

• Type
• Natural Account
• User defined
• One (or more) Trees for Reporting
• Values
• Account Type Sign
• Posting Type (Actual Budget Stat)

12
Accounting Schema

• From traditional CCC to
• Chart-Of-Account (Natural Account)
• Currency
• (Not Calendar)
• Costing Method
• GAAP
• Selection of Elements

13
Multiple Accounting Schema

• Parallel Accounting of Documents
• No need to derive one from the other
• Differentiate between
• Legal/Tax Accounting
• Multiple Countries
• Management Accounting
• Currency Translation not correct

14
Account Schema Elements

• Information Dimensions
• Balanced
• Postings to this Element must be balanced
• E.g. Organization
• Mandatory
• With every transaction you have to define
• E.g. Organization, Natural Account
• Default Value

15
Accounting Schema Changes

• Change Structure any time
• Add/Change/Delete Elements
• Change Values any time
• Overwrites old ones!
• Change Hierarchy any time
• Reporting Hierarchy of Elements
• Org, Account, BPartner, Product, Project, etc.
• Merge Element Entries any time
• Organization, BPartner (User), Product

16
Accounting Defaults

• Default Hierarchy
• Accounting Schema
• BP Group, Product Category, ..
• Business Partner, Product, ..
• Account Combination
• Combination of Element Values
• Org Natural Account ...
• Posting adds Document Context Values to Account
  Defaults
• E.g. Invoice automatically adds Business Partner

17
Account Combination
Org
Product
BPartner
Project
Account
Default Account
02
_
_
Building
1600
Document
Org
Product
BPartner
Project
Account
Posted Account (dynamically created)
01
Flowers
Joe
Building
1600
18
Posting

• Posted in Background or Explicit
• When document is processed
• Reset Accounting
• For specific/all Document Table
• Allows to correct wrong default accounts
• Resubmit Posting
• After correcting cause for Posting error
• E.g. Open Period

19
Account Info (View)

• View Accounting
• For Document
• For Enabled Account Element Value
• Optional Account Date Range
• Optional Sorting
• Grouping

20
GL Category

• Traditional GL Reporting
• Sources
• Derived from Document Type
• Manually Entered

21
Document Sequence

• Unique numbering of documents
• Gap-less
• Optional Prefix/Suffix
• Assigned via Document Type

22
Charge

• The Link (Alias) between
• (Multiple) Chart-of-Accounts
• Natural Account (Account Combination)
• Attributes
• Option to distinguish Dr/Cr Posting
• Tax Category Tax Inclusive Handling
• Creation
• Manually
• Generate Charges from Natural Account

23
Tax Overview
24
Tax

• Tax Category
• Link to Product (Commodity Code)
• API for Tax Vendors
• Commodity Invoice/Ship From/To
• Maintain Tax Rate
• Invoice From/To
• For simple tax situations

25
Multiple Tax Rates

• More than one tax rate on the same net amount
• Line 100.00
• Tax1 (5) 5.00
• Tax2 (4) 4.00
• If Tax on Tax calculate rate as if from net
• Enter for Summary Level
• Summary (9) 9.00
• Summary Level used while entering data
• Correct Taxes calculated when Processed

26
Tax Issues

• Tax Calculation
• On Header
• Total Amount per Tax Rate
• Tax Inclusive
• The Amount includes all taxes
• Define in
• Price List
• Charge

27
Budgeting

• Define Budget Status
• Enter Budget
• Journal Entry
• Post to Budget
• Report

28
Planned Functionality

• Automatic GL Distribution
• You define Source e.g. 01-1200
• Multiple Targets e.g. 50 - 01-2500
• Recursive Use
• Currency Revaluation
• Allocations
• Alerts
• Cockpit

29
Accounting Details

• Optional Material

30
Details No Sub-Ledger

• Traditional Systems
• Sub-Ledger Documents create GL Journals
• GL Journals are posted
• Compiere
• All Documents are directly posted
• GL Category defined in Document Type
• Simulating a Sub-Ledger
• Create Sub Ledger Reports based on GL Category
• Creating Sub-Ledgers (Customization)
• Create Accounting Trx Exports for other Client
• With the desired level of Summarization

31
Detail Balancing

• Defined per Accounting Schema
• Source Amount Balancing
• If Suspense Balancing enabled
• Post to Suspense Acct Otherwise fail
• Segment / Element Balancing
• Implemented for Organization (Due To/From)
• Accounting Amount Balancing
• With Currency Balancing
• Difference posted to Currency Balancing Account
• Without Currency Balancing
• Difference added to biggest Balance Sheet Account
  Amount

32
Details Reverse (Correction)

• Differentiate between
• Reversals (Accruals)
• Correction Undo
• Motivation Correct Account Debit / Credit Sum
• E.g. Differentiate between Invoice Correction and
  Voiding Invoice
• Example - Original Trx
• Account 1 Dr 50
• Account 2 Cr 50
• Reverse
• Account 1 Cr 50
• Account 2 Dr 50
• Reverse Correction
• Account 1 Dr -50
• Account 2 Cr -50

33
Details Invoice Allocation

• Payment
• In Transfer (Bank) Dr
• Unallocated Receipts Cr
• Per Allocation Transaction
• Unallocated Receipts Dr
• Accounts Receivables Cr
• Write-Off Cr
• Payment Discount Cr
• View Allocations in Reverse Allocation

34
Details Realized Gain Loss

• Created when posting Invoice Allocation
• Difference between converted
• (Partial) AR/AP Amount
• Allocation Amount
• E.g. Accounts Receivables Dr 22 Realized
  Gain Cr 22
• Conversion Rate on Allocation Trx Date
• Is Payment Date when 11 with Payment
• Manual Allocation Date defaults to Login Date

35
Details Tax Correction

• Enabled in Accounting Schema
• If you have to pay tax only on the actually
  received (not invoiced) Amount VAT
• Example
• Lines 100 Tax1 15 Tax2 5 Total 120
• Payment of 115 (5 Payment Discount or
  Write-Off)
• Tax1 Correction 0.63 (15/1205)
• Tax2 Correction 0.21 (5/1205)
• Journal Entries (e.g. Sales Trx)
• Discount Cr 0.84
• Tax1 Dr 0.63
• Tax2 Dr 0.21

36
Details Document Action
37
Hands-on

• Check / Post Document
• Enter manual Journal