月結作業 - 應收帳款系統 AR

Step 1. Reconcile Transaction Activity for the Period

Run Transaction Register

   列印當期所有輸入並Complete之交易, 含Invoices, Debit Memo, Credit Memo, Deposit, GuOEantee.

Run Sales Journal By Customer Report & Sales Journal By GL Account Report

   Sales Journal By GL Account之總額應等於Transaction Register 中Postable Items之總額, 若有差異, 可列印Sales Journal By Customer Report 查客戶

   餘額.

  檢核: Transaction Register(Postable Items) + 2 * Credit Memo Total = Sales Journal (Debit + Credit).

  注意: Transaction Register中Credit Memo 為負數

Step 2. Reconcile Outstanding Customer Balance

試算公式

   Period-End Balance (Aged Trial Balance)

   = Outstanding Balance at StOEt of Period (Aged Trial Balance)

   + Transactions (Transaction Register)

   + Adjustments (Adjustment Register)

   - Invoice Exceptions (Invoice Exceptions Report)

   - Applied Receipts (Applied Receipt Register)

   - Receipts (Unapplied Receipt Register)

注意: Invoice Exception Register為Transaction Type not Open to Receivable, 故總額不出現於Aged Trial Balance.

Step 3. Reconcile Receipts

Run Receipt Register Report

Run Receipts Journal Report & Journal Entries Report

兩報表皆含一般收款與雜收.

Receipts Register為Receipts Journal Report之明細.

Receipts Journal Report為Journal Entries Report 之明細.

檢核: Receipts Journal Report 總額 = Receipt Register 總額.

檢核: Journal Entries Report中Receipt之總額= Receipts Journal Report 總額 .

注意: 執行報表時之參數GL Date Range需一致.

Step 4. Post to the General Ledger

Run OE General Ledger Transfer

  將OE之Invoice與Receipt資料拋轉至GL Interface.

  自動產生Execution Report列印拋轉之總數.

Run GL Journal Import

  由GL Interface將子系統傳票轉入.

  自動產生Execution Report, 並列印出有問題無法轉入之資料或成功轉入之Batch與總額.

Step 5. Reconcile the General Ledger Transfer Process

檢核: GL Transfer Execution Report 總額 = Sales Journal 與Receipts Journal 總額

若有無法拋轉之資料,系統自動產生Unposted Items Report

檢核: Sales Journals與Receipts Journal之總額 = Journal Entries Report之總額

   Sales Journals與Receipt Journals為OE已立帳之交易, Journal Entries Report則為已過帳之資料.

注意: Journal Entries Report 之參數“Detail by Account” 最適合核帳.

Step 6. Reconcile the Journal Import Process

檢核: GL Transfer Execution Report 總額 = Journal Import Execution Report 總額

檢核: Unposted Journals Reports (General Journal Report, Posting Status: Unposted) ), 其總額 = Journal Import Execution Report 總額

Step 7. Reconcile Posted Journal Entries

執行GL之Post (過帳)

Run GL之 Posted Journals Report (General Journal Report, Posting Status: Posted)

檢核: Posted Journals Report 總額 = Journal Import Execution Report 總額