月結作業 - 總帳管理系統 GL

Step 1. Ensure the Nexting Accounting Period Status is Set to Future Entry

確認Open下一期間為Future Enterable, 於Open Period Form 中將下一期Open為Future Enterable

Future Enterable 之期間可輸入傳票, 但不可過帳.

年結時建議完成所有作業再開啟新年度之第一期.

Step 2. Interfaces to Oracle General Ledger

執行Journal Import轉入子系統傳票

需確定所有子系統(AP, AR, PO, INV, FA, NM)之傳票皆轉入.

注意: FA於Run Depreciation後自動轉入GL, 不需再執行Journal Import.

若Journal Import發生錯誤, 需修改後重新Import

若Journal Import不成功, Review Journal Import Status Report.

Delete Journal Batch或由Correct Form修改GL Interface資料.

重新Import.

Step 3. Review and Verify Journal Details of Unposted Journal Entries

Review Journal Entries (On-Line或Reports)

Update Journal Entries as Appropriate

Useful Reports:

Journal Batch Summary Report (已過帳之傳票批次彙總)

Foreign Currency Journals Report

General Journals Report (總分類帳)

Journal Entry Report (明細分類帳)

Journal Line Report

Journal Source Report

Journals by Document Number Report (日記帳)

Unposted Journals Report (Run General Journal Report)

Step 4. Post All Journal Batches

Post All Journal Batches

含Allocation與Recurring Journal Batches.

Review Posting Results

檢視Posting Execution Report .

若有問題, Run Error Journals Report, 檢視Error Journals.

修改未過帳但有問題的傳票.

重新過帳.

Posting可能發生錯誤之情況:

Control Total不合.

Period Status非Open狀態.

傳票借貸不平.

Step 5. Run General Ledger Trial Balance and Other Preliminary FSG

Run Trial Balance Report

Run FSG Reports

可將期末報表設為Report Set以便於期末執行.

Step 6. Optionally Revalue Balance

Revalue Account Balances

Review and Post Revaluation Journals

Step 7. Optionally Translate Balance

Checklist:

Define New Translated Currencies

Maintain Period-End Exchange Rate for Translated Currencies

Maintain Average Exchange Rate for Translated Currencies

Maintain Historical Exchange Rate for Translated Currencies

Translate Account Balances

Step 8. Optionally Consolidate Sets of Books

a. Consolidate Within a Set of Books

Enter Consolidating Journal Entries

Post Consolidating Journal Entries

Define Reporting Hierarchy that Consolidates All Your Companies

Define FSG with the Reporting Hierarchy

 

b. Consolidate Across Sets of Books

Checklist:

Define Consolidations

Perform Translation of Foreign Currencies as Required

Run Consolidations

Enter Consolidated and Eliminating Entries

Report on this Consolidated Set of Book

 

Step 9. Review and Correct Balances (Perform Reconciliation)

a. Review Detail Account Balances On-Line

AP, AR可Subledger Drilldown至明細資料.

b. Review Account Balances Via Reports

General Ledger Reports e.g. General Ledger Entry Report

Account Analysis Reports e.g. Account Analysis Entry and Account Analysis Line Report, Account Analysis with Payables Detail, Account Analysis with Subledger Detail

Trial Balance Reports e.g. Detail Trial Balance Report

Journal Reports e.g. Unposted, Posts, Error Journal Report

c. Clear Suspense Account

Examine General Ledger and Account Analysis Report to identify Source of entries to the Suspense Account.

Determine the adjusting entries required to net these accounts to zero.

注意:若不允許Suspense Accounting, 則傳票不平時無法過帳.

d. Reconcile Sub-Ledgers

Identify differences between Sub-Ledgers and GL.

Determine which differences are error requiring adjustments to the GL.

Step 10. Enter Adjustments and Post

Create and Post Adjusting Journals

已過帳之傳票無法修改, 只可Reverse.

Adjusting Journals e.g. Accrual Write-Off 之Manual Journals.

Create and Post Reversing Journals

Step 11. Perform Final Adjustments

Post Any Final Adjustments

Step 12. Close the Current GL Accounting Period

Close GL Period

注意: Closed 為Soft Close, 可再Open, Permanently Closed則為Hard Close, 無法再Open.

Step 13. Open the Next GL Accounting Period

Step 14. Run Final FSG for the Closed Reporting Period

Run FSG Reports

Run Trial Balance Report

Step 15. Optionally Perform Encumbrance Year End Procedures

a. Open Your Next Encumbrance Year

於Open and Close Period Form中.

b. Open Your Next Budget Year

於Define Budget Form中.

c. Run Year End Carry Forward

於Year End CarryForward Form中.

可先Perform Preview, 確認後再Run Carry Forward.

 

c. Run Year End Carry Forward

可選擇以下參數:

CarryForward Rule: Encumbrances Only, Encumbrances and the Encumbered Budget, Funds Available.

Encumbrance Type: All或e.g. Commitment.

From/To Budget and Budget Org

Accounting Flexfields Ranges