Tuesday, 4 June 2019

Account Payables Setup Steps - Oracle EBS R12

https://oracleaccountingall.blogspot.com/2019/06/account-payables-setup-steps-oracle-ebs.html



S.No
Steps
1
Create Operating Unit
2
Run Replicate Seed Data
3
Profile Options for AP Responsibility: GL Ledger Name, GL: Data Access Set, MO: Default Operating Unit, MO: Operating Unit
4
Create Inventory Responsibility
5
Profile Options for INV Responsibility: HR: with Payroll User, GL Ledger Name, GL: Data Access Set, MO: Default Operating Unit, MO: Operating Unit
6
Workday Calendar
7
Create Inventory Org
8
Create Security Profile
9
Run Security List Maintenance Program
10
Profile Options for AP & INV Responsibility : HR: Security Profile, MO: Security Profile
11
Financial Options
12
Payable Options
13
Period Opening in AP
14
User Management Setup for Bank
15
Create Payment Process Profile
16
Create Supplier
17
Create Bank
18
Create Tax Codes

Friday, 12 April 2019

Pension Funds and Accounting Entries

https://oracleaccountingall.blogspot.com/2019/04/reference-httpscorporatefinanceinstitute.html

Reference: https://corporatefinanceinstitute.com/resources/knowledge/accounting/pension-accounting/

In addition to salaries, many companies offer other benefits to their employees such as pension’s plans, health insurance, stock option benefits, fitness memberships, or life insurance plans.  There are very specific requirements around pension accounting, which will be outlined in this article.

For regular benefits, the accounting is relatively simple – the employer records an expense for the amount of the benefits employees earn in a year.

However, the accounting treatment becomes more complicated when employees earn the rights to the benefits NOW but receive those benefits later in the FUTURE. A clear example of such a benefit is the pension.

How a pension works:

A pension trust is a legal entity that holds the pension investments and disburses the funds later, when necessary.

Trusts are managed by trustees, who are independent of the company.

Relationship 1: Employees provide services to the employer and in return, they receive wages.
Relationship 2: Employers make contributions to the pension trust.
Relationship 3: Funds are used from the pension trust to pay the employee in the future and sometimes, employees can also make contributions to the trust.

Two types of pensions:

There are two kinds of pensions available today. One is the defined contribution plan and the other is the defined benefits plan. Below is a tabular comparison between the two:

Defined Contribution Plan
Defined Benefits Plan
This plan specifies how much money the employer needs to contribute to the pension plan.
This plan specifies how much employees will receive in payments during their retirement.
Investment risk is on the employees.
Investment risk is on the employer. Outflows from the pension trust to employees are pre-specified.
Journal Entry:
DR Pension Expense
CR Pension Liability

Funds Transfer:
DR Pension Bank
CR Operational bank

When gratuity is paid to an employee:
DR Pension Liability
CR Employee Liability Account
Journal Entry: More complicated. Explained below.
  
Defined benefits plan

Under the defined benefits plan, the employee is guaranteed a certain amount of benefits/payments in the future. Because pension payments are usually made much later in the future, there is a clear time difference between when employees receive the future payments and when employees actually earn those benefits. Because of this difference, companies must use the accrual basis of accounting instead of when cash changes hand.

The pensions accounting treatment for defined benefit plans require:
  1. To determine the fair value of the assets and liabilities of the pension plan at the end of the year
  2. To determine the amount of pension expense for the year to be reported on the income statement
  3. The net asset or liability position of the pension plan on a fair value basis
Pension expense is an expected value and when the actual value of the pension differs, those deviations are recorded through other comprehensive income (OCI) under IFRS. For Canadian private companies that adhere to ASPE, there is no such OCI account.

Pension accounting example:

XYZ Company has a defined benefit pension plan. At the end of 2015, the fair value of the assets and liabilities in the pension amounted to $6 million. In 2016, the pension expense was $10 million and the company contributed $5 million to the pension plan. At the end of 2016, the fair value of the pension assets and liabilities was at $10 million.  Let’s see how the pension accounting works.

To record company contribution to pension
DR Defined Benefit Pension Liability             5,000,000
CR Cash                                                          5,000,000
To record pension expense
DR pension expense                                       10,000,000
CR Defined Benefit Pension Liability              10,000,000
To adjust pension liability to fair value
DR Other comprehensive income (OCI)         1,000,000
CR Net defined benefit liability                       1,000,000
            
https://corporatefinanceinstitute.com/resources/knowledge/accounting/pension-accounting/

Thursday, 11 April 2019

Gratuity Funds and Accounting Entries

https://oracleaccountingall.blogspot.com/2019/04/gratuity-funds-and-accounting-entries.html

Gratuity can be defined as an after-retirement social security benefit, provided to the employees by the employer on account of the services provided by them to the establishment. Simply put, gratuity is a mark of recognition, that an employer gives to his/her employee for his contribution to the company when he/she leaves or retires. Under this scheme, a lump sum amount is paid to the employee depending on the years of service and last drawn salary.

An employee is eligible for receiving a gratuity, when there is termination of employment after he/she has served the organisation for five years of more, due to superannuation, retirement/resignation or death/disablement, as a result of accident or disease. Nevertheless, the completion of service for five years is not mandatory, where the employment contract ends out of disablement or death.

The amount of gratuity is given to the employee himself but on the demise of the employee, the amount is handed over to the nominee, when the nomination is performed and to the legal heirs, in the absence of any nomination.


The gratuity contribution is an expense for the organization. Thus on one side the expenses is charged and on other side the liability payable to employee is created by the following entry

Date
Particulars
Dr
Cr
Gratuity Expense A/c
      XXX
  Gratuity Payable
 XXX

Journal Entry for Fund Transfer

The amount equal to gratuity expenses is transferred to separate bank account maintained for the purposes. Thus a fund from operation account is transferred to Gratuity Bank Account.

Date
Particulars
Dr
Cr
Gratuity Bank A/c
   XXX
  Operational Bank
XXX

Gratuity Payment Journal Entry

When gratuity is paid to an employee, then liability is decreased and Gratuity bank account also decreased due to payment. The following entry would be recorded.

Date
Particulars
Dr
Cr
Gratuity Payable A/c
XXX
  Gratuity Banks A/c
 XXX

Difference between Gratuity and Pension Funds

https://oracleaccountingall.blogspot.com/2019/04/difference-between-gratuity-and-pension.html

BASIS FOR COMPARISON
GRATUITY
PENSION
Meaning
Gratuity can be understood as a social security benefit provided to the employees by the employer in appreciation of service, after their retirement or death.
Pension is a saving scheme, wherein employer invests certain sum to guarantee payment of definite sum at regular intervals, to the employee or his/her dependent survivors, after retirement or death.
What is it?
Gift
Retirement plan
Payment
Lump sum payment
Installment Payment
Contributory service
Minimum 5 years of service is required.
Minimum 10 years of service is required.

Key Differences between Gratuity and Pension

The difference between gratuity and pension can be drawn clearly on the following grounds:
  1. An after-retirement social security benefit provided to employees by the employer, as a mark of recognition for the services provided by them, is known as a gratuity. Conversely, the pension can be explained as an investment vehicle wherein employer invests a fixed amount to assure payment of definite sum at periodic intervals, to the employee or his/her dependent survivors, after retirement or death.
  2. Gratuity is nothing but a gift or gratitude given by the employer to the employee, for his contribution to the organisation. As against, the pension is a retirement plan, in which a particular sum is invested by the employer to guarantee payment to the employee after the termination of employment.
  3. Gratuity involves one-off payment in which the entire sum is provided by the employer at once. Unlike pension wherein, the employee gets a fixed sum in the form of monthly installments.
  4. For the entitlement of pension, at least ten years of contributory service is required. On the other extreme, to become eligible for gratuity, a person needs to work for a minimum of 5 years with the same organisation.

Provident Funds and Accounting Entries

https://oracleaccountingall.blogspot.com/2019/04/provident-funds-and-accounting-entries.html

  • Provident Fund is the contributory investment fund where both employees and employer contributes
  • Employee’s contribution is deducted from their salary
  • Employer’s contribution is treated as expenses of the company
  • Provident Fund A/c to be maintained separately & company cannot use this fund.
  • Interest earned from PF A/c is also credited to the employee’s account.

What is Provident Fund?

A Provident Fund is one type of investment that is jointly established by the employer and the employee. The purpose of this fund is to create a long-term savings A/c to support an employee upon retirement. It also represents job welfare benefits offered to the employee.
Sources of money invested in the provident fund:
Employees Contribution: Deducted from the employee’s monthly salary
Employer’s Contribution: Employer’s contribution considered as the expenses of the business

Journal Entry for Employer’s Contribution 

When an employer contributes to a provident fund, this contribution is the expenses of the business. Thus expenses are debited and liability towards the employees are credited in the books of accounts. The journal entry for the provident fund contribution is as follows:
Provident Fund Contribution A/cDebit
Provident Fund Payable A/cCredit

Journal Entry for Employee’s Contribution

Both employer and employee may contribute to the provident fund. The provident fund contribution of an employee is normally deducted from the salary. The following entry to be recorded in the books of accounts:
Salary A/cDebit
Provident Fund Payable A/cCredit
Cash/Bank A/cCredit

Journal for Fund Transfer

Both employer’s and employee’s contribution are the liability of the business. As the provident fund cannot be used in business, this fund to be transferred from the company’s operational Bank A/c to Provident fund Bank A//c. The journal entry in this respect are as follows:
Provident Fund Bank A/c (Employers & Employees Contribution)Debit
Operational Bank A/cCredit

Interest on Provident Fund

Interest earned on the provident fund is also credited to the employee’s account in the following manner:
Provident Fund Bank A/c (Interest earned amount)Debit
Provident Fund Payable A/c (Employees PF A/c)Credit

Example

The gross salary of Mr. A is $2,000. Mr. A and his employer contributes to provident fund @ 10% of his salary. In this respect, his contribution to PF is $200 and his take-home pay is $1,800. What is the Journal entry?
Solution:
1) Recording of salary & deduction of Provident Fund: 
Salary A/c                                                               Dr             $2,000
To Employee A/c                                                      Cr             $1,800
To Provident Fund (Employees Contribution) A/c         Cr             $200
2) At the time of Provident Fund depositing to Bank A/c (Both employer’s and employee’s contribution): 
Provident Fund Bank (Employer Contribution) A/c       Dr.             $200
Provident Fund Bank (Employees Contribution) A/c     Dr.             $200
To Operational Bank A/c                                            Cr.             $400
[After this entry Provident Fund (Employees Contribution) A/c will be ZERO]
3) Employer contribution to be transferred to Profit & Loss Account:
Profit and Loss Account                                           Dr.               $200
To Provident Fund (Employer Contribution) A/c          Cr.               $200

Tuesday, 2 April 2019

Oracle AIM Critical Docs

https://oracleaccountingall.blogspot.com/2019/04/oracle-aim-critical-docs.html


Phase
Description
Requirement Gathering
Requirement Questionnaire

Business Requirement Document
Fit Gap Analysis
Future Process Model/To Be Flow
Solution Design
Functional Design Document
Solution Build
Technical Design Document

Technical Installation Document

Application Setup/Configurations
SIT/UAT
Unit Testing

SIT

UAT

Data Conversion Requirement and Strategy

User Guides/SOP
PROD Go Live

Post Prod Support