Compiere Training Bonn `04
Download
Report
Transcript Compiere Training Bonn `04
Compiere Training
Accounting, Tax
Performance Analysis
May-04
Accounting
1
Show Accounting
Agenda
Tools > Preference
Role Security
Performance Analysis
Information Dimensions
Calendar & Periods
Accounting Schema
Charge
Tax
Accounting Details
May-04
Accounting
2
Performance Analysis
May-04
Accounting
3
Terminology
Mandatory
Elements
Optional
Elements
01-1200-2000-Joe
Org
Natural
Account
Value
|
Name
Element
HQ-Payables-Flower-JoeBrown Inc
May-04
Account
Combination
Accounting
Description
4
Information Dimensions
Organization
Natural Account
Accounting Schema
Product
Elements
Business Partner
(Segments)
Project
Marketing Campaign
Location (Warehouse, Business Partner)
Owning (balance sheet)
Transacting (executing org or service center)
From - To
Activity (Activity Based Costing)
User Defined (2)
May-04
Accounting
5
Principles
Accounting entry at the lowest level
Element Values derived from Transaction
(Accounting Fact)
Any Accumulation
Trees for Summary & Navigation
Directly (entered)
Derived
Differentiate Document from
Accounting Consequence
May-04
Multiple Accounting Schema
Accounting
6
Dimensions Tree Conversion
*
MyCompany
HQ Operations
Direct Sales
Direct Sales HQ
Direct
Sales
Web
Sales
Stores
City Store
Country Store
City
Store
May-04
Web Sales
Country
Store
Accounting
7
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
Different Modeling Options
May-04
E.g. Differentiate “Direct Sales” level transactions from
individual Stores
Dependent what you want to report on
Accounting
8
Dimension Tree Alternative
*
MyCompany
HQ Operations
Direct Sales
Direct Sales HQ
Direct
Sales
Web
Sales
City Store
Country Store
Web Sales
City
Store
May-04
Country
Store
Accounting
9
Calendar & Period
Two Dates
Document Date
Accounting Date
Calendar & Period only for
control & reporting purposes
No End Period processes
Period can be automatically opened
May-04
You cannot post in closed periods
– Change accounting date (or re-open)
Controlling Calendar defined on Client Level
Accounting
10
Account Element
Type
Natural Account
User defined
One (or more) Trees for Reporting
Values
May-04
Account Type & Sign
Posting Type (Actual – Budget – Stat)
Accounting
11
Accounting Schema
From “traditional CCC” to
May-04
Chart-Of-Account (Natural Account)
Currency
(Not Calendar)
Costing Method
GAAP*
Selection of Elements
Accounting
12
Multiple Accounting Schema
Parallel Accounting of Documents
No need to derive one from the other
Differentiate between
Legal/Tax Accounting
Document
Multiple Countries
Management Accounting
Accounting
Accounting
Consequence
Accounting
Consequence
Consequence
Currency Translation not correct
May-04
Accounting
13
Account Schema Elements
Information Dimensions
Balanced
Postings to this Element must be balanced
Mandatory
With every transaction you have to define
E.g. Organization
E.g. Organization, Natural Account
Default Value
May-04
Accounting
14
Accounting Schema Changes
Change Structure any time
Change Values any time
Add/Change/Delete Elements
Overwrites old ones!
Change Hierarchy any time
Reporting Hierarchy of Elements
Org, Account, BPartner, Product, Project, etc.
Merge Element Entries any time
May-04
Organization, BPartner (User), Product
Accounting
15
Accounting Defaults
Default Hierarchy
Accounting Schema
BP Group, Product Category, ..
Account Combination
Business Partner, Product, ..
Combination of Element Values
Org – Natural Account – ...
Posting adds Document Context Values to
Account Defaults
May-04
E.g. Invoice automatically adds Business Partner
Accounting
16
Account Combination
Default Account
Org
Account
Project
BPartner
Product
02
1600
Building
_
_
Document
Posted Account
(dynamically created)
May-04
Org
Account
Project
BPartner
Product
01
1600
Building
Joe
Flowers
Accounting
17
Posting
Posted in Background or Explicit
Reset Accounting
When document is processed
For specific/all Document Table
Allows to correct wrong default accounts
Resubmit Posting
After correcting cause for Posting error
May-04
E.g. Open Period
Accounting
18
Account Info (View)
View Accounting
For Document
For Enabled Account Element Value
Optional Account Date Range
Optional Sorting
May-04
Grouping
Accounting
19
GL Category
Traditional GL Reporting
Sources
May-04
Derived from Document Type
Manually Entered
Accounting
20
Document Sequence
Unique numbering of documents
Gap-less
Optional Prefix/Suffix
Assigned via Document Type
May-04
Accounting
21
Charge
The Link (“Alias”) between
(Multiple) Chart-of-Accounts
Attributes
Natural Account (Account Combination)
Option to distinguish Dr/Cr Posting
Tax Category & Tax Inclusive Handling*
Creation
May-04
Manually
Generate Charges from Natural Account
Accounting
22
Tax Overview
Product
Commodity
Code
Tax
Category
Org
Ship From
Bill From
BPartner
Tax Rate
Ship To
Bill To
May-04
Accounting
23
Tax
Tax Category
API* for Tax Vendors
Link to Product (Commodity Code)
Commodity – Invoice/Ship – From/To
Maintain Tax Rate
May-04
Invoice From/To
For simple tax situations
Accounting
24
Multiple Tax Rates
More than one tax rate on the same net
amount
100.00
5.00
4.00
If “Tax on Tax” calculate rate as if from net
Enter % for Summary Level
Line
Tax1 (5%)
Tax2 (4%)
Summary (9%)
9.00
Summary Level used while entering data
Correct Taxes calculated when Processed
May-04
Accounting
25
Tax Issues
Tax Calculation
On Header
Total Amount per Tax * Rate
Tax Inclusive
The Amount includes all taxes
Define in
May-04
Price List
Charge*
Accounting
26
Budgeting
Define Budget & Status
Enter Budget
Journal Entry
Post to Budget
Report
May-04
Accounting
27
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*
May-04
Accounting
28
Accounting Details
Optional Material
May-04
Accounting
29
Details: No Sub-Ledger
Traditional Systems
Sub-Ledger Documents create GL Journals
GL Journals are posted
Compiere
All Documents are directly posted
Simulating a Sub-Ledger
GL Category defined in Document Type
Create “Sub Ledger” Reports based on GL Category
Creating Sub-Ledgers (Customization)
Create Accounting Trx Exports for other Client
May-04
With the desired level of Summarization
Accounting
30
Detail: Balancing
Defined per Accounting Schema
Source Amount Balancing
Segment / Element Balancing
If Suspense Balancing enabled
Post to Suspense Acct – Otherwise fail
Implemented for Organization (Due To/From)
Accounting Amount Balancing
With Currency Balancing
Without Currency Balancing
May-04
Difference posted to Currency Balancing Account
Difference added to biggest Balance Sheet Account Amount
Accounting
31
Details: Reverse (Correction)
Differentiate between
Motivation: Correct Account Debit / Credit Sum
Account 1
Account 2
Dr 50
Reverse
E.g. Differentiate between Invoice Correction and Voiding Invoice
Example - Original Trx
Reversals (Accruals)
Correction “Undo”
Account 1
Account 2
Reverse Correction
May-04
Account 1
Account 2
Dr 50
Dr -50
Cr 50
Cr 50
Cr -50
Accounting
Trx
Reverse
50
Reverse 50
50
50
Reverse Correction
Trx
50
Reverse -50
0
0
32
Details: Invoice Allocation
Payment
Dr
Cr
Per Allocation Transaction
In Transfer (Bank)
Unallocated Receipts
Unallocated Receipts Dr
Accounts Receivables
Write-Off
Payment Discount
Cr
Cr
Cr
View Allocations in “Reverse Allocation”
May-04
Accounting
33
Details: Realized Gain & Loss
Created when posting Invoice Allocation
Difference between converted
(Partial) AR/AP Amount
Allocation Amount
Accounts Receivables
Realized Gain
Dr 22
Cr 22
Conversion Rate on Allocation Trx Date
May-04
E.g.
Is Payment Date when 1:1 with Payment
Manual Allocation Date defaults to Login Date
Accounting
34
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/120*5)
Tax2 Correction = $0.21 (5/120*5)
Journal Entries (e.g. Sales Trx)
May-04
Discount
Tax1
Tax2
Cr 0.84
Dr 0.63
Dr 0.21
Accounting
35
Details: Document Action
Invalid
Complete
Prepare
Complete
Prepare
Drafted
Waiting
Reverse
Approve
In
Progress
Approved
Re-Activate
Completed
Close
Reopen
Reject
Void
Reject
Prepare
Not
Approved
Void
May-04
Reversed
Voided
Accounting
Closed
36
Hands-on
Check / Post
Document
Enter manual
Journal
May-04
Accounting
37