CE_现金银行对账单的手工导入和调节（案例）

2014-07-14 Created By BaoXinjian

一、摘要

---

1. 银行对账

• 导入或者手工输入银行对账单
• 联机更正对账单导入错误
• 自动或者手工对账
• 可以与AP、AR或者其他外部系统中的事物进行对账
• 可以创建杂项事物处理

 

2. 应付付款凭证银行系统对账， 调整对账和直接结清

Payment Status:
Note that the statuses that Payables uses for cleared payments and reconciled payments depends on your setting for the Account for Payment When Payment Clears Payables option.

• Reconciled But Unaccounted.

The bank has disbursed funds for the payment, and the payment has been reconciled and matched to a bank statement in Oracle Cash Management. Payables uses this status when the Account for Payment When Payment Clears Payables option is disabled.

• Reconciled.

The bank has disbursed funds for the payment, and the payment has been reconciled and matched to a bank statement in Oracle Cash Management. Payables uses this status when the Account for Payment When Payment Clears Payables option is enabled.

• Cleared But Unaccounted.

The bank has disbursed funds for the payment and the payment has been cleared but not matched to a bank statement within Oracle Cash Management. Payables uses this status when the Account for Payment When Payment Clears Payables option is disabled.

• Cleared.

The bank has disbursed funds for the payment, and the payment has been cleared, but not matched to a bank statement within Oracle Cash Management. Payables uses this status when the Account for Payment When Payment Clears Payables option is enabled.

 

二、流程分析

---

1. 导入银行对账单

 2. 系统自动对账

3. 系统手工对账

 

三、案例 - 导入银行现金对账单

---

 1. 建立Payment 108500

 

2. 建立Payment 217000

3. payment建立并过账后， 系统可查看可进行银行对账的交易

4. 产看上次银行对账后的该银行账户余额

5. 建立银行对账单的interface文件header / lines

6. 调用request，导入银行对账interface data

7. 查看银行对账单导入情况

8. 对银行对账单和具体的交易进行匹配调整

9. 对账后系统自动清算balance，查看银行余额

10. 查看报表bank statement summary and detail report

 

11. 对应payment状态变为已调整

 12. 查看会计科目

 

 

 

Thanks and Regards