Check, Deposit and Adjustment Entry

 

Window Details

 

 

Navigation

 

   

Overview

 

   

Fields

 

   

 

How Do I...

 

 

Enter Void Checks and Checks with Zero Amount

   

Adjust an Out-of-Balance Condition

   

Post from General Ledger to Bank Reconciliation

   

Connect a Bank to Sage Bank Feeds    

 

Related Topics

 

 

Search Grid

Effect on the Bank Balance

Bank Code Maintenance

Reconcile Bank

Integrating Other Modules with Bank Reconciliation

Positive Pay Export

Bank Reconciliation Report

Accounts Payable Options

Manual Check and Payment Entry

Bank Reconciliation Transaction Register

 

Navigation

Select Bank Reconciliation Main menu > Check, Deposit and Adjustment Entry.

Overview

Use Check, Deposit and Adjustment Entry to enter checks and deposits, and record bank account adjustments. You can enter the outstanding checks and deposits that have been updated in the General Ledger, Accounts Payable, Accounts Receivable, Payroll, and Purchase Order modules, but are included on your last bank statement.

Wire transfer payments updated through the Accounts Payable module appear in this task. Also, electronic payments appear as adjustments.

During normal operations, all checks and deposits processed and updated through the General Ledger, Accounts Payable, Accounts Receivable, Payroll, and Purchase Order modules are recorded automatically. Use Check, Deposit and Adjustment Entry to enter the cleared documents shown on your bank statement that were not recorded automatically (for example, miscellaneous bank charges, noncheck withdrawals, and interest earned).

If other modules are not integrated with the Bank Reconciliation module, you must enter all documents for the month (for example, checks, deposits, and adjustments).

Click Bank Recap Report to review the transactions when reconciling the bank statement. Click B/R Transaction Register for the bank code selected to update the transactions to the General Ledger module. These buttons are available only with the appropriate security setup.

Sage Bank Feeds

If the selected bank is connected to Sage Bank Feeds, click Get Bank Feed Transactions to import transactions from your bank. A message tells you how many transactions were imported, and the program attempts to match them to the transactions recorded in Sage 100 that have not been cleared.

Checks are matched based on the check number and amount, and the check date must be no later than the date posted for the Sage Bank Feeds transaction.

The program uses the following criteria to match adjustments: 

  • If the reference number, amount, and adjustment type match, and the Sage 100 transaction date is no later than the date posted for the Sage Bank Feeds transaction, the transaction is considered a match.
  • If there is no matching reference number, but the adjustment type and amount match, and the Sage 100 transaction date is no later than the date posted for the Sage Bank Feeds transaction, the transaction is considered a match.

If a match is found, "Matched" appears in the Source field for the transaction. If there is no match for a transaction imported from Sage Bank Feeds, the Action Req. check box is automatically selected and a flag icon appears in the first column.

When a transaction is imported from Sage Bank Feeds, the Cleared check box is automatically selected.

If a Sage Bank Feeds transaction is not automatically matched to a Sage 100 transaction, you can manually process a match. For example, you can select the Cleared check box for one of the two transactions, and the cleared date is automatically entered. You can then delete the other transaction.

If there is no corresponding Sage 100 transaction for a Sage Bank Feeds transaction, you can enter the general ledger posting account number in the grid.

When you click Get Bank Feed Transactions after the initial import, only transactions that have not previously been imported are added to the grid.

Note Transactions are imported into Sage 100 only when you click Get Bank Feed Transactions. However, the service used to sync with your banks retrieves transactions multiple times throughout the day. This service uses the same sign-in credentials used when connecting a bank to Sage Bank Feeds. If you need to change the sign-in ID or password for a bank, first disconnect the bank from Sage Bank Feeds in Bank Code Maintenance by clicking the arrow button in the top-right corner and selecting Disconnect Bank Feeds. After you've updated your sign-in credentials, use them to reconnect the bank to Sage Bank Feeds.

Fields

 

Bank Code

Current Bank Balance

Description

 

 

 

1. Checks

 

Check No.

Entry No.

Check Date

Reference

Payee Name

Amount

Source

Action Req.

Cleared

Cleared Date

Exported

Wire Transfer No.

Module

Select For G/L Posting

Distribution Account No.

Comment

 

 

2. Dep/Adjust

 

Document Date

Entry No.

Adjustment Type

Reference

Amount

Source

Action Req.

Cleared

Cleared Date

Module

Select For G/L Posting

Distribution Account No.

Comment