Check, Deposit and Adjustment Entry - Fields

 

Check, Deposit and Adjustment Entry

Bank Code

Enter the bank code to use to enter or view checks, deposits, and adjustments. Click the Lookup button to list all bank codes.

 

Description

This field displays the description of the bank code selected and can only be viewed.

 

Current Bank Balance

This field displays the current bank balance of the bank code selected and can only be viewed. The current bank balance defaults from Bank Code Maintenance. The current balance is a running total of debits and credits from the general ledger and displays only the balance as of the most future date.

 

1. Checks

 

Check No.

Type the check number of the check to be processed.

 

Entry No.

This field displays a reference number to identify two checks with the same check number (for example, if a check was reversed and reissued) and can only be viewed. If a check with the same check number is encountered during the check update process, the entry number for that check is incremented by one.

 

Check Date

Enter the date of the check, or click the Calendar button to select a date from the calendar. The check date entered for the first check is used for the following checks until another date is entered.

 

Reference

Type a reference to describe the check (for example, a purchase order number or a brief description). This reference is printed on the Bank Reconciliation Report.

 

Payee Name

Type the name of the business or individual to whom the check is written.

 

Amount

Enter the amount of the check, or click the Calculator button to enter an amount using the calculator.

 

Source

This field appears if the selected bank is connected to Sage Bank Feeds, and it shows the source of the transaction.

  • Sage 100 appears in this field if the transaction was created in Sage 100 and no matching transaction was found in Sage Bank Feeds.
  • Bank Feed appears if the transaction was imported by Sage Bank Feeds, and there is either no matching transaction in Sage 100 or there are multiple matching transactions in Sage 100.
  • Matched appears if the transaction was created in Sage 100 and one matching transaction was imported from Sage Bank Feeds.

 

Action Req.

This check box appears if the selected bank is connected to Sage Bank Feeds; it is automatically selected if the transaction was imported from Sage Bank feeds, and there is either no matching transaction in Sage 100 or there are multiple matching transactions in Sage 100.

If this check box is selected, a red flag icon appears in the first column next to the row number. If you clear this check box, the red flag no longer appears.

This check box and the flag icon are a warning that further review is needed to ensure the accuracy of the current bank balance. You can manually select the check box to indicate that a transaction needs further review.

This check does not prevent you from completing any tasks.

 

Cleared

Select this check box if the check cleared the bank. A check has cleared if it appears on the last bank statement for the bank account. Clear this check box if the check has not cleared the bank. The amount of the cleared check is added to the current bank balance of the bank code selected.

If the adjustment was imported from Sage Bank Feeds, this check box is automatically selected.

Note The Cleared check box must be cleared for the check to be selected for Positive Pay.

 

Cleared Date

Enter the date the check cleared the bank, or click the Calendar button to select a date from the calendar. This field defaults to the Bank Reconciliation module date but it can be changed. This field is available only if the Cleared check box is selected.

 

Exported

Select this check box if the check has been exported to a Positive Pay file. Clear this check box if the check should be selected for Positive Pay. This field is available only if Positive Pay Export is set up and an export setting already exists.

 

Wire Transfer No.

This field displays the wire transfer number provided by the bank that was entered in Manual Check and Payment Entry. This field is available only if the Enable Wire Transfers check box is selected in Accounts Payable Options.

 

Module

This field displays the source module for the document and can only be viewed. This field defaults to B/R (Bank Reconciliation) when a new line is entered using this task.

 

Select For G/L Posting

Select this check box to include this transaction when performing the update to the General Ledger module at the time that the Bank Reconciliation Transaction Register is printed. Clear this check box if you do not want to include this transaction when performing the update to the General Ledger module. This field is available only with the appropriate security setup and if a new transaction is made in the Bank Reconciliation module.

 

Distribution Account No.

Enter the distribution account number to use when performing the update to the General Ledger module at the time that the Bank Reconciliation Transaction Register is printed. Click the Lookup button to list all general ledger accounts.

General ledger accounts can be created at this field based on the selection made in the Auto Create when all Segments are Valid field in General Ledger Options.

This field is available only if the Select For G/L Posting check box is selected.

 

Comment

Type a comment for the check. This comment is printed on the Bank Reconciliation Report and the Bank Recap Report. If the Select For G/L Posting check box is selected in Check, Deposit and Adjustment Entry, the comment is also printed on the Bank Reconciliation Transaction Register and will be used as part of the Posting Comment to G/L field.

If you're using Sage Bank Feeds, the following information automatically appears in this field for imported transactions. The information is listed in the order shown, but some fields may not contain values:

  • Information supplied by bank
  • Additional information supplied by bank
  • Payee name or description of transaction
  • Reference number
  • Extended name of payee or description of transaction
  • Payee ID
  • Check number

2. Dep/Adjust

 

Document Date

Enter the date of the deposit or adjustment, or click the Calendar button to select a date from the calendar.

 

Entry No.

Type an entry number to identify the deposit or adjustment. Use the entry number to distinguish multiple deposits or adjustments with the same document date.

 

Adjustment Type

Select the type of adjustment to enter.

  • Select Adjustment to enter an adjustment.

  • Select Bank Charge to enter a bank charge.

  • Select Deposit to enter a deposit.

  • Select Interest Earned to enter the interest earned.

  • Select NSF Charge to enter a nonsufficient fund charge.

  • Select Withdrawal to enter a withdrawal.

 

Reference

Type a reference to describe the deposit or adjustment (for example, a purchase order number or a brief description). This reference is printed on the Bank Reconciliation Report. The reference defaults to the adjustment type selected, but it can be changed.

 

Amount

Enter the amount of the deposit or adjustment, or click the Calculator button to enter an amount using the calculator.

Note For information on the effect a transaction can have on the current bank balance, see Effect on the Bank Balance.

 

Source

This field appears if the selected bank is connected to Sage Bank Feeds, and it shows the source of the transaction.

  • Sage 100 appears in this field if the transaction was created in Sage 100 and no matching transaction was found in Sage Bank Feeds.
  • Bank Feed appears if the transaction was imported by Sage Bank Feeds, and there is either no matching transaction in Sage 100 or there are multiple matching transactions in Sage 100.
  • Matched appears if the transaction was created in Sage 100 and one matching transaction was imported from Sage Bank Feeds.

 

Action Req.

This check box appears if the selected bank is connected to Sage Bank Feeds; it is automatically selected if the transaction was imported from Sage Bank feeds, and there is either no matching transaction in Sage 100 or there are multiple matching transactions in Sage 100.

If this check box is selected, a red flag icon appears in the first column next to the row number. If you clear this check box, the red flag no longer appears.

This check box and the flag icon are a warning that further review is needed to ensure the accuracy of the current bank balance. You can manually select the check box to indicate that a transaction needs further review.

This check does not prevent you from completing any tasks.

 

Cleared

Select this check box if the adjustment cleared the bank. An adjustment has cleared if it appears on the current bank statement for the bank account. Clear this check box if the adjustment has not cleared the bank.

If the adjustment was imported from Sage Bank Feeds, this check box is automatically selected. If a Sage Bank Feeds transaction is not automatically matched to a Sage 100 transaction, but you locate the corresponding Sage 100 transaction in the grid, select the Cleared check box for the Sage 100 transaction, enter the cleared date, and then delete the Sage Bank Feeds transaction.

 

Cleared Date

Enter the date the adjustment cleared the bank, or click the Calendar button to select a date from the calendar. This field defaults to the Bank Reconciliation module date but it can be changed. This field is available only if the Cleared check box is selected.

 

Module

This field displays the source module for the document and can only be viewed. This field defaults to B/R (Bank Reconciliation) when a new line is entered using this task.

 

Select For G/L Posting

Select this check box to include this transaction when performing the update to the General Ledger module at the time that the Bank Reconciliation Transaction Register is printed. Clear this check box if you do not want to include this transaction when performing the update to the General Ledger module. This field is available only with the appropriate security setup and if a new transaction is made in the Bank Reconciliation module.

 

Distribution Account No.

Enter the distribution account number to use when performing the update to the General Ledger module at the time that the Bank Reconciliation Transaction Register is printed. Click the Lookup button to list all general ledger accounts.

General ledger accounts can be created at this field based on the selection made in the Auto Create when all Segments are Valid field in General Ledger Options.

This field is available only if the Select For G/L Posting check box is selected.

 

Comment

Type a comment for the deposit or adjustment. This comment is printed on the Bank Reconciliation Report and the Bank Recap Report. If the Select For G/L Posting check box is selected in Check, Deposit and Adjustment Entry, the comment is also printed on the Bank Reconciliation Transaction Register and will be used as part of the Posting Comment to G/L field.

If you're using Sage Bank Feeds, the following information may automatically appear in this field for imported transactions. The information is listed in the order shown, but some fields may not contain values.

  • Information supplied by bank
  • Additional information supplied by bank
  • Payee name or description of transaction
  • Reference number
  • Extended name of payee or description of transaction
  • Payee ID
  • Check number