In addition to loading bank statement information automatically with the Bank Statement Open Interface, you can enter bank statement information manually. You can enable users to update information on a statement that was previously entered manually or loaded automatically, even if the statement is already reconciled.
When you enter a bank statement manually, you enter the bank statement header and the transaction lines. You can reconcile transaction lines as you enter them, or you can reconcile the bank statement (manually or automatically) after you enter all the transaction lines and save your work.
Note: Cash Management assumes that you enter statements in chronological order, and uses this order to calculate cumulative bank account balances.
Prerequisites
Define your banks.
If you plan to use the Bank Statement Import program, you need to define bank transaction codes for the bank account.
Set up Receivables activities and payment methods for miscellaneous transactions.
If you want to use document sequences, you or your System Administrator must set up sequential document numbering for Cash Management.
Note: For document sequencing, the effective date is the statement date.
If you have enabled the Add Lines to Automatic Statements feature in the System Parameters window, you can add lines to automatically-loaded statements.
To enter a bank statement manually:
1. Navigate to the Find Bank Statements window. Choose New.
2. Choose the New button to display the Bank Statement window.
3. Enter the following bank header information: Account Number, Account Name, Bank Name, Bank Branch, and Currency.
4. Enter the new statement Date.
5. If you use manual document sequence numbers, enter the bank statement Document Number.
Additional Information: If you use automatic document sequence numbers, Cash Management creates the Document Number for the statement automatically. You cannot edit an automatically assigned Document Number.
6. Enter the Statement number. The default Statement Number is the statement date.
7. Enter the GL Date--the default is the Statement Date. The GL Date must be in an open or a future-enterable period in Receivables or Payables.
8. Optionally, enter bank statement Control Totals:
Enter the opening and closing balances as needed. Enter control totals for Receipts and Payments, as well as the number of statement lines for each.
Additional Information: You can compare the Control Total amounts to those displayed by Cash Management in the Line Totals tabbed region of the Statements window, to ensure the completeness and correctness of your entered bank statement.
9. Choose Lines to begin entering your statement lines. Optionally, you can save the header information now and enter the statement lines later.
10. Save your work.
When you enter a bank statement manually, you enter the bank statement header and the transaction lines. You can reconcile transaction lines as you enter them, or you can reconcile the bank statement (manually or automatically) after you enter all the transaction lines and save your work.
Note: Cash Management assumes that you enter statements in chronological order, and uses this order to calculate cumulative bank account balances.
Prerequisites
Define your banks.
If you plan to use the Bank Statement Import program, you need to define bank transaction codes for the bank account.
Set up Receivables activities and payment methods for miscellaneous transactions.
If you want to use document sequences, you or your System Administrator must set up sequential document numbering for Cash Management.
Note: For document sequencing, the effective date is the statement date.
If you have enabled the Add Lines to Automatic Statements feature in the System Parameters window, you can add lines to automatically-loaded statements.
To enter a bank statement manually:
1. Navigate to the Find Bank Statements window. Choose New.
2. Choose the New button to display the Bank Statement window.
3. Enter the following bank header information: Account Number, Account Name, Bank Name, Bank Branch, and Currency.
4. Enter the new statement Date.
5. If you use manual document sequence numbers, enter the bank statement Document Number.
Additional Information: If you use automatic document sequence numbers, Cash Management creates the Document Number for the statement automatically. You cannot edit an automatically assigned Document Number.
6. Enter the Statement number. The default Statement Number is the statement date.
7. Enter the GL Date--the default is the Statement Date. The GL Date must be in an open or a future-enterable period in Receivables or Payables.
8. Optionally, enter bank statement Control Totals:
Enter the opening and closing balances as needed. Enter control totals for Receipts and Payments, as well as the number of statement lines for each.
Additional Information: You can compare the Control Total amounts to those displayed by Cash Management in the Line Totals tabbed region of the Statements window, to ensure the completeness and correctness of your entered bank statement.
9. Choose Lines to begin entering your statement lines. Optionally, you can save the header information now and enter the statement lines later.
10. Save your work.
Comments
Post a Comment