Banking for GL - Version 9/22/2014 - Student Guide

Oct 1, 2026

Uploaded by Franzy

Banking for GL（General Ledger）指导性材料，聚焦银行对账与资金往来处理。内容涵盖银行对账目标、系统与银行交易的匹配机制、银行对账数据导入方式、自动与半手工对账流程，以及利息与费用记录。文档还讨论对账中可能残留的未对账差异与异常错误、所需的外部（Excel/Access）补充分录与复核、以及对账后审阅签批要求，并延伸至银行转账、Memo 平衡与电汇流程等主题。

LanguageEnglish

CategoryExam

FormatPDF

Pages82

Reading Time3 h 27 min

AccessFree to download

Bank Reconciliation

Overview of Bank Reconciliation

Entering Bank Statement Information

Running the Automated Reconciliation Process

Running the Semi Manual Bank Reconciliation Process

Recording Interest and Fees

Bank Transfers

Overview of Bank Transfers

Creating a Transfer Template

Approving a Transfer Template

Entering a Bank Transfer

Selecting a Settlement

Approving a Settlement

Running Automated Accounting

Manually Running the Journal Generator

Memo Bank Balancing

Understanding Memo Bank Balancing

Running the Re-balancing Query

Wire Transfers

Dispatching a Payment in Financial Gateway

Reference

Running Queries

Understanding Run Controls

Banking for GL VERSION: 9/22/2014 Table of Contents 1 Bank Reconciliation 3 Overview of Bank Reconciliation 4 Entering Bank Statement Information 7 Running the Automated Reconciliation Process 11 Running the Semi Manual Bank Reconciliation Process 16 Recording Interest and Fees 20 2 Bank Transfers 25 Overview of Bank Transfers 26 Creating a Transfer Template 29 Approving a Transfer Template 32 Entering a Bank Transfer 34 Selecting a Settlement 37 Approving a Settlement 42 Running Automated Accounting 46 Manually Running the Journal Generator 50 3 Memo Bank Balancing 57 Understanding Memo Bank Balancing 58 Running the Re-balancing Query 61 4 Wire Transfers 65 Dispatching a Payment in Financial Gateway 66 5 Reference 73 Running Queries 74 Understanding Run Controls 78 1 Bank Reconciliation This chapter contains: l Overview of Bank Reconciliation l Entering Bank Statement Information l Running the Automated Bank Reconciliation Process l Running the Semi Manual Bank Reconciliation Process l Recording Interest and Fees Overview of Bank Reconciliation Overview Central Office Accounting personnel do monthly bank reconciliations. The objectives of performing bank reconciliations include: l identifying timing differences and imbalances between bank and system transactions l identifying potential accounting or banking errors l detecting instances of fraud or other unauthorized activity This process plays a vital role in managing cash at the University. The system uses functionality which allows bank transactions to be matched with system transactions. The system transactions that need to be reconciled do not come from the General Ledger (GL), but from tables corresponding to the various sub-ledgers, including, for example, Accounts Payable (AP), Accounts Receivable (AR), and Treasury. The first step in the bank reconciliation process is loading bank transaction information using the following methods: l Automatically importing bank statement files for commercial bank accounts l Using the PSBD1 Statement Generator Access database to load bank statement information for NC State Treasurer bank accounts l Entering bank statement information for State budget codes through the system's Enter Bank Statements page, performed by Accounting personnel System transactions are tracked within the various modules in the system when cash transactions occur. When a GL cash account is debited or credited, the transaction information is stored in a table is used for reconciliation purposes. Also, the External Accounts page associates each bank account to a particular GL cash account. In the system, there is a one-to-one relationship between GL cash accounts and external bank accounts. After the bank transaction data is loaded into the system, choose the applicable bank statements to reconcile, and run the Automatic Reconciliation process. The Automatic Reconciliation process reconciles bank transactions to corresponding system transactions . The criteria for determining how transactions are reconciled, including criteria pertaining to dates, amounts, and transaction types, are set up on the Reconciliation Rules page within the system. After the Automatic Reconciliation process runs, unreconciled bank and system transactions may still remain. This happens, for example, when two system transactions for $50 each were presented as a single $100 bank transaction. Use the Semi-Manual Reconciliation functionality to analyze and reconcile these items. The Semi-Manual Reconciliation page presents bank and system transactions inside-by-side lists. You have the ability to select one or more bank transactions, select one or more corresponding system transactions, and reconcile all selected transactions. After the Semi-Manual Reconciliation process is complete, unreconciled transactions may still remain. These remaining items include: l System tra

FAQs

为何需要在外部使用 Excel 或 Access 完成对账补充？

由于系统当前缺少与月初/月末银行与系统余额的必要 tie-outs，且为确保对账过程完整性，银行对账必须在 Microsoft Excel 或 Access 中外部完成。

Oct 1, 2026

Uploaded by Franzy