Reconciliation steps

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
ajeeshmb
Posts: 23
Joined: Wed Nov 15, 2006 2:26 am
Location: India

Reconciliation steps

Post by ajeeshmb »

Hi

Likes to know complete steps to reconcile -

1. AP liability accounts with GL accounts.

* besides payable transfer to GL.

2. FA Capital accounts with GL accounts
sniffing
Posts: 14
Joined: Tue Mar 13, 2007 4:59 pm
Location: USA

Post by sniffing »

To Reconcile AP with GL

First run AP Trial Balance report-Trial Balance report lists your
outstanding accounts payable liability information

Run GL Account Analysis report for the Liability account for the same date range. Thses two should help in reconciliation.

Also For example, you are closing your
accounting period for April and you
have just posted your final
invoice and payment batches to your
general ledger system. To reconcile
your accounts payable activity for April,
make the following calculation:
Accounts Payable Trial Balance as of March 31
+Posted Invoice Register for the period between
April 1 and April 30
-Posted Payment Register for the period between
April 1 and April 30
= Accounts Payable Trial Balance as of April 30
anu_uma
Posts: 456
Joined: Sat Feb 03, 2007 4:39 am
Location: India
Contact:

Post by anu_uma »

AR reconcillation

Report Information
India ? Debtors Trial Balance Report Opening Balance
Transaction Register Transactions
Adjustment Register Adjustments
Applied Receipts Register Applied Receipts
Unapplied Receipts Register Unapplied Receipts
India ? Debtors Trial Balance Report Closing Balance

Formula

Opening Balance
Add Transactions
Add/Subtract Adjustments
Less Applied Receipts
Less Unapplied Receipts
Closing Balance



TIA
ajeeshmb
Posts: 23
Joined: Wed Nov 15, 2006 2:26 am
Location: India

Post by ajeeshmb »

Hi Thanks for your comments.
Is there any concept like reconciliation of FA capital accounts with GL accounts. If there..plz give some tips.
verender
Posts: 5
Joined: Thu May 17, 2007 2:14 am
Location: India

Post by verender »

first run the following report:
payable account analysis report in ap module and give the following parametre:
liabilities a/c.....xyz
summarised report....yes
the report will be generated and u will find dr.and cr.total
this report is generated on code combination,after that pl run the following report in GL >account analysis sub ledger detail
take precaustion that give the same liability a/c as u have given in ap.
after matching both the report u can easily reconicile your a/c.
regards
verender
Posts: 5
Joined: Thu May 17, 2007 2:14 am
Location: India

Post by verender »

your question:Is there any concept like reconciliation of FA capital accounts with GL accounts.
yes
Post Reply

Who is online

Users browsing this forum: No registered users and 5 guests