2008年6月18日 星期三

月結作業 - 固定資產系統 FA

Step 1. Make Sure to post all invoices distribution
which marked as “Track as asset” (AP)

Run Expense Distribution Detail Report

列印所有 Unpost 之Track as Asset交易,
Check un-posted reason , fix it and post associated invoice
into Oracle General Ledger

Submit Create Mass Additions for Assets Program

System will automatically generate
Mass Additions Create report.

Step 2. Make sure to post all “UN-POST” assets

Run Unposted Mass Additions Report

列印所有 Unpost 之Mass Additions
Check un-posted reason , fix it and post associated invoice
into Oracle Fixed Assets

Submit Post Mass Additions

System will automatically generate
Mass Additions Posting report.

Reconcile Unposted Mass Additions Report with
Mass Additions Posting Report

Step 3. Make adjustment for exceptional conditions

Cost Adjustment in “mass-additions”

AP : Dr -- Clearing Acct $20,000
Cr -- AP $20,000
FA : Dr -- Asset Cost Acct $20,200 (Cost Adjustment $200)
Cr -- Clearing Acct $ 20,200
GL : Dr -- Clearing Acct $200 (Adjustment Journal)
Cr -- AP $200

Manual error on AP (non-clearing account)

AP : Dr -- Asset Cost Acct $20,000
Cr -- AP $20,000
FA : Dr -- Asset Cost Acct $20,000 (Manual Addition)
Cr -- Clearing Acct $ 20,000
GL : Dr -- Clearing Acct $20,000 (Adjustment Journal)
Cr -- Asset Cost Acct $20,000

Cancel Original AP -> Re-enter AP -> Approval -> Post to GL -> Post to Mass Additions -> Post to FA

Step 4. Final posting in mass-additions

Run Unposted Mass Additions Report

列印所有 Unpost 之Mass Additions
Check un-posted reason , fix it and post associated invoice
into Oracle Fixed Assets

Submit Post Mass Additions

System will automatically generate
Mass Additions Posting report.

Reconcile Unposted Mass Additions Report with
Mass Additions Posting Report

Step 5. Run projection report to see projected depreciation expense

Step 6. Run Depreciation (Close Current Period & Open Next)

Step 7. Reconciliation Reports with Oracle General Ledger

Reconciling Journal Entry to General Ledger Accounts

Reconciling Asset Cost Accounts

Reconciling CIP Cost Accounts

Reconciling Reserve Accounts

Reconciling Depreciation Expense Accounts