Oracle Training

Standard Accounting Concept

Table of Contents

 Procure to Pay

 Order to Cash

 Inventory

 Fixed Asset

 General Ledger
Procure To Pay
Procure To Pay

Purchase Purchase
Receiving Inspection Deliver
Requisition Order

Dr. Receiving Accrual/Asset Clearing/ Expense

Cr. AP Accrual Dr. Inventory
Cr. Receiving Accrual
Receiving
Invoice
Process
Delivery
Dr. AP Accrual Process

Cr. Liabilities Matching

Invoice

Payment Payment
Process

Dr. Liabilities

Bank Cr. Cash Clearing / Petty Cash

Reconciliation
Process Dr. Cash Clearing
Bank
Cr. Bank Reconciliation
Procure To Pay

Purchase Purchase
Receiving Inspection Deliver
Requisition Order

Dr. AP Accrual Dr. Receiving Accrual

Cr. Receiving Accrual Cr. Inventory / Asset Clearing / Expense

Return to
Return to
Invoice Vendor /
Vendor /
Correction
Correction
Dr. Liabilities
Cancel
Cr. AP Accrual
Invoices

Payment
Void
Payment
Dr. Cash Clearing / Petty Cash
Cr. Liabilities
Bank
Un-reconciliation Dr. Bank
Bank
Cr. Cash Clearing Reconciliation
Procure To Pay
Invoice Matching process
Dr. AP Accrual Dr. AP Accrual
Dr. VAT In (PPN) Dr./ Cr. Invoice Price Variance
Dr./ Cr. Invoice Price Variance Cr. Liabilities
Cr. Liabilities
Cr. Withholding Tax (PPH)

Invoice Standard
Dr. Expenses
Dr. Expenses
Dr. VAT In (PPN)
Cr. Liabilities
Cr. Liabilities
Cr. Withholding Tax (PPH)
Debit Memo / Credit Memo
Dr. Liabilities
Dr. Withholding Tax (PPH) Dr. Liabilities
Cr. AP Accrual / Expenses Cr. AP Accrual / Expenses
Cr. VAT In (PPN)

Note: If Invoice Canceled reverse journal will be created automatically

Procure To Pay

Withholding Tax
Dr. Withholding Tax (PPH)
Cr. Liabilities

Prepayment

Dr. Prepayment Dr. Prepayment

Dr. VAT Tax (PPN) Cr. Liabilities
Cr. Liabilities
Cr. Withholding Tax (PPH)

Apply Prepayment
Dr. Liabilities
Cr. Prepayment

Note: If Invoice Canceled or Payment Voided reverse journal will be created automatically
Procure To Pay

Payment

Using Bank Reconciliation Direct Payment (Without Bank Reconciliation)

Dr. Liabilities Dr. Liabilities

Cr. Cash Clearing / Bank Clearing Cr. Petty Cash / Bank Dummy

Dr. Cash Clearing / Bank Clearing

Dr. Bank Charges
Cr. Bank

Note: Payment Voided and un-reconciled reverse journal will be created automatically
 Standard Reporting (Closing & Reconciliation)
Receiving Account Distribution Report
 Standard Reporting (Closing & Reconciliation)
Accrual Reconciliation Report
 Standard Reporting (Closing & Reconciliation)
Invoice Aging Report
 Standard Reporting (Closing & Reconciliation)
Posted Invoice Register
 Standard Reporting (Closing & Reconciliation)
Posted Payment Register
 Standard Reporting (Closing & Reconciliation)
Prepayment Status Report
 Standard Reporting (Closing & Reconciliation)
Account Payable Trial Balance Report
Order To Cash
Order To Cash

Book Sales Pick

Shipping
Order Release

Dr. COGS
Cr. Inventory

Ship
Sales
Confirm
Invoices
Process

Dr. Receivables
Cr. Revenue
Auto Invoice

Receipt Receipt
Process

Dr. Cash Clearing / Bank Dummy

Bank Cr. Receivables

Reconciliation
Process Dr. Bank
Bank
Cr. Cash Clearing Reconciliation
Order To Cash

Create Sales RMA

Book
Order Return Receiving

Dr. Inventory
Cr. COGS
RMA
Sales Return Process
Invoice

Dr. Revenue
Invoice
Cr. Receivables
Return

Receipt
Cancel
Receipt
Dr. Receivables
Cr. Cash Clearing
Bank
Un-reconciliation Dr. Cash Clearing
Bank
Cr. Bank Reconciliation
Order To Cash
Sales Invoice (Auto Invoice & Manual Invoice)
Dr. Receivables Dr. Other Receivables
Cr. Revenue Cr. Other Revenue / Customer Advance
Cr. VAT Out (PPN)

Debit Note
Dr. Other Receivables Dr. Other Receivables
Cr. Other Revenue Cr. Other Revenue/ Customer Advance
Cr. VAT Out (PPN)

Credit Note (Sales Return)

Dr. Sales / Revenue Return Dr. Other Revenue / Customer Advance

Dr. VAT Out (PPN) Cr. Other Receivables
Cr. Receivables
Order To Cash
Standard Receipt

Method: Direct & No Matching Method: Direct & By Matching

Dr. Cash / Bank Dr. Cash / Bank Clearing

Cr. Unidentified Receipt Cr. Unidentified Receipt

Dr. Unidentified Receipt Dr. Unidentified Receipt

Cr. Unapplied Receipt Cr. Unapplied Receipt

Dr. Unapplied Receipt Dr. Unapplied Receipt

Cr. Receivables Cr. Receivables

Dr. Bank
Dr. Bank Charges
Cr. Cash / Bank Clearing

Note: Receipt Canceled and un-reconciled reverse journal will be created automatically
Order To Cash

Standard Receipt

Method: Remittance & By Matching

Dr. Remittance
Cr. Receivables

Dr. Cash / Bank Clearing

Cr. Remittance

Dr. Bank
Cr. Cash / Bank Clearing

Note: Receipt Canceled and un-reconciled reverse journal will be created automatically
Order To Cash
Miscellaneous Receipt

Method: No Matching

Dr. Cash /Bank

Cr. Other Revenue (i.e: Interest Revenue, Service Revenue, Capital, Other Advance, etc)

Method: By Matching

Dr. Cash Clearing / Bank Clearing

Cr. Other Revenue ( i.e : Interest Revenue, Service Revenue, Capital, Other Advance, etc)

Dr. Bank
Dr. Bank Charge
Cr. Cash / Bank Clearing

Note: Receipt Canceled and un-reconciled reverse journal will be created automatically
Order To Cash
Adjustment (Impact related with Receivables )

Dr. Adjustment Account (Rounding, Interest Expense, etc)

Cr. Receivables

Write Off ( Impact related with Receipt )

Dr. Cash / Bank Clearing

Cr. Write Off Account (Rounding, Other Revenue, etc)

Dr. Bank
Dr. Bank Charge
Cr. Cash / Bank Clearing
 Standard Reporting (Closing & Reconciliation)
Order / Invoice Detail Report
 Standard Reporting (Closing & Reconciliation)
Order / Invoice Summary Report
 Standard Reporting (Closing & Reconciliation)
Shipments Report
 Standard Reporting (Closing & Reconciliation)
Aged Trial Balance – 4 Buckets
 Standard Reporting (Closing & Reconciliation)
Sales Journal by GL Account Report
 Standard Reporting (Closing & Reconciliation)
Receipt Journal Report
 Standard Reporting (Closing & Reconciliation)
Journal Entries Report
Inventory
Inventory
Delivery Transaction

Dr. Inventory Dr. Asset Clearing Dr. Expense

Cr. Receiving Accrual Cr. Receiving Accrual Cr. Receiving Accrual

Note: If there are correction or return to vendor transaction , reverse journal will be create automatically

Receipt RMA

Dr. Inventory
Cr. COGS

Miscellaneous Issues Miscellaneous Receipt

Dr. Miscellaneous Account (User Defined) Dr. Inventory

Cr. Inventory Cr. Miscellaneous Account (User Defined)
Inventory

Direct Inter-Org Transfer Intransit Inter-Org Transfer

Dr. AR Inter-company Dr. Intransit
Cr. Inventory Cr. Inventory

Dr. Inventory Dr. AR Inter-Company

Cr. AP Inter-Company Cr. Intransit

Dr. Inventory
Cr. AP Inter-Company

Sub-Inventory Transfer
Dr. Inventory
Cr. Inventory
Inventory

Adjustment Stock

Adjustment (+) Adjustment (-)

Dr. Inventory Dr. Account Adjustment
Cr. Account Adjustment Cr. Inventory

Adjustment Cost (Average Cost Update)

Dr. Inventory/Account Adjustment
Cr. Account Adjustment/Inventory
 Standard Reporting (Closing & Reconciliation)
Material Account Distribution Detail
 Standard Reporting (Closing & Reconciliation)
Material Account Distribution Summary
Inventory

Invoice Price Variance Report

Fixed Asset
Fixed Asset

Purchase Purchase
Receiving
Requisition Order

Dr. Asset Clearing/ CIP Clearing

Cr. AP Accrual

Receiving
Invoice
Process

Dr. AP Accrual Matching

Invoice
Cr. Liabilities

Asset Run
Mass Addition
Workbench Depreciation
Asset
Journals
Dr. Asset
Journal
Cr. Asset Clearing Creation
Dr. Depreciation Expenses
Cr. Accumulated Depreciation
Fixed Asset

Journal PO Receipt
Dr. Asset Clearing / CIP Clearing
Cr. AP Accrual

Invoice Matching
Dr. AP Accrual
Cr. Liabilities

Asset Addition
Dr. Asset / CIP
Cr. Asset Clearing / CIP Clearing

Asset Depreciation
Dr. Depreciation Expense
Cr. Accumulated Depreciation
Fixed Asset

Transfer Asset
Dr. Depreciation Expense (Location A) Dr. Accumulated Depreciation Expense
Cr. Accumulated Depreciation Expense Cr. Depreciation Expense (Location B)

Capitalize Asset
Dr. Asset
Cr. CIP

Retirement/Disposal Asset

Loss Gain
Dr. Accumulated Depreciation Expense Dr. Accumulated Depreciation Expense
Dr. NBV Retired Cr. NBV Retired
Cr. Asset Cr. Asset
Fixed Asset

Sales of Asset
Oracle Asset
Dr. Accumulated Depreciation Expense
Dr. Proceed of Sales Clearing
Dr. Cost of Removal
Dr. NBV Retired
Cr. Asset Cost
Cr. Proceed Of Sale
Cr. Cost of Removal Clearing

Oracle Receivables Oracle Payables

Dr. Account Receivables Dr. Cost of Removal Clearing
Cr. Proceed of Sales Clearing Dr. VAT In (PPN)
Cr. VAT Out (PPN) Cr. Liabilities
 Fixed Asset
Journal Entry Reserve Ledger Report
Fixed Asset
Account Drill Down Report
Fixed Asset
Account Reconciliation Reserve Ledger Report
 Fixed Asset
Asset Retirements Report
 Fixed Asset

Asset Transfers Report

General Ledger
General Ledger

Manual Journal, Memorial Journal, Recurring Journal, Mass Allocation Journal

Dr. User Defined Account
Cr. User Defined Account

Revaluation Journal

Loss Gain
Dr. Account (Revaluation Range Account) Dr. Unrealized Loss of Exchange Currency
Cr. Unrealized Loss of Exchange Currency Cr. User Defined (Revaluation Range Account)
General Ledger

Inter-company Journal
Dr. Company A – User Defined Account Dr. Company A – User Defined Account
Cr. Company B – User Defined Account Dr. Company B – User Defined Account
Dr. Company B – Intercompany Account Cr. Company C – User Defined Account
Cr. Company A – Intercompany Account Cr. Company D – User Defined Account
Dr. Company C – Intercompany Account
Dr. Company D – Intercompany Account
Cr. Company A – Intercompany Account
Cr. Company B – Intercompany Account

Closing Journal (End Of Year)

Dr. Revenues
Cr. Retained Earning

Dr. Retained Earning

Cr. Expenses
 General Ledger
Account Analysis Report
General Ledger
Account Analysis – With Subledger Detail Report
General Ledger
Detail Trial Balance
General Ledger
Summary Trial Balance