Skip to main content

Bank Statements

Cash Management maintains information for each bank statement you want to reconcile. You can use the Cash Management Bank Statement Open Interface to load bank statement information supplied by your bank, or you can enter and update bank statements manually. The system retains all bank statement information for audit and reference purposes, until you purge it.
Each Cash Management bank statement is composed of one bank statement header and multiple bank statement lines. The bank statement header identifies the statement number, bank account number, and statement date. It also contains optional information including the bank and branch names, bank account currency, and control amounts.
Note: If a bank gives you multiple account information on a single bank statement, you must enter a separate Cash Management bank statement for each bank account, for the specific statement date.
Bank Statement Lines
A bank statement line can refer to one or more payments, receipts, miscellaneous transactions, open interface transactions, or journal entry lines. Each line has a line number, transaction type, date cleared (bank transaction date), and amount. Optional line information includes the bank transaction code, number, bank transaction identifier (such as the payment or deposit number), currency information (currency code, original amount in transaction currency, exchange rate), value date, agent (customer or supplier), agent bank account, a comment, and a descriptive flexfield for user-defined additional information.
A bank statement line's status can be one of the following:
Reconciled: Some transactions have been matched against this line. The statement line may not be fully reconciled.
Unreconciled: No transactions have been matched.
Error: This status is a warning that the line cannot be reconciled because of a bank error in the statement that cannot be resolved. You must manually mark the statement line as Error. The transaction remains unreconciled because there is no corresponding transaction to which the line can be reconciled.
External: The line does not correspond to any transaction in General Ledger, Payables, Receivables, Payroll, or the Reconciliation Open Interface, but corresponds to a transaction in another system. You then manually mark the statement line as External. Cash Management treats it as reconciled.
Bank Statement Error Reconciliation
You can efficiently manage bank errors. You can automatically or manually reconcile correcting statement lines against error statement lines, thereby providing an audit trail you can use to verify correction of bank errors.
For example, if your bank erroneously records a $50 payment as $500, your bank statement may show three statement lines for $500, <$500>, and $50. You can reconcile the <$500> correction against the $500 error statement line, and the $50 statement line against the original payment.
Bank Statement Transaction Codes
Bank statement lines are coded to identify the type of transaction the line represents. Since each bank might use a different set of transaction codes, you need to map each code a your bank uses.

Comments

Popular posts from this blog

Applying Prepayments to Invoices

You can apply the available amount of Item type distributions from a Temporary type prepayment to one or more invoices to offset the amount you pay on the invoice(s). If you entered the prepayment as a Permanent type and want to apply it, you can query the prepayment in the Invoices window and change the Prepayment Type to Temporary. If you use Automatic Offsets then your setting for the Prevent Prepayment Application Across Balancing Segments Payables option controls whether you can apply a prepayment to an invoice or expense report with a different balancing segment. Prerequisites The invoice type is Standard, Mixed, or Expense Report. Today's date is on or after the Settlement Date of the prepayment. The invoice date is on or after the date of the prepayment. The prepayment is type Temporary, fully paid, validated, not cancelled, has no active holds, and has not already been fully applied. The prepayment has the same supplier, invoice currency and payment currenc...

Overview of Encumbrance Accounting

With General Ledger you can record pre-expenditures commonly known as encumbrances. The primary purpose of tracking encumbrances is to avoid overspending a budget. Encumbrances can also be used to predict cash outflow and as a general planning tool. To use the full capabilities of encumbrance accounting, you must enable the budgetary control flag for a set of books. When you enable the budgetary control flag, the system automatically creates encumbrances from requisitions, purchase orders and other transactions originating in feeder systems such as Purchasing and Payables. When you do not enable the budgetary control flag, you can still enter manual encumbrances via journal entry, but you cannot generate encumbrances from requisitions and purchase orders. You have two options for using encumbrance data to monitor over-expenditure of a budget: After actuals and encumbrances have been posted, you can generate reports to show over-expenditures. You can also can use funds checking to preve...

Apply/Unapply Prepayments Window Reference

Payables provides two ways to apply prepayments to an invoice. You can do either of the following: i-> Create or query an invoice and apply one or more prepayments to the invoice. ii-> Create or query the prepayment and apply it to one or more invoices. Selecting an Invoice and Applying it to a Prepayment When you select an invoice and choose the Apply/Unapply Prepayment option in the Invoice Actions window, the Apply/Unapply Prepayments window opens. It automatically displays all prepayments that have been applied to the invoice, and all available Prepayment distributions that you can apply to the invoice. Payables displays prepayment item type distributions that meet the following criteria: same supplier, and invoice currency as the invoice. The prepayment's Settlement Date is on or before today's date. The prepayment's date is on or before the date of the invoice. The prepayment is type Temporary with a status of Available. If you use Automatic Offsets, you can se...