ManEx KB

Find:
Advanced Search

Table of Contents

. . . . . . . . . . . . .

Hardware and Software Requirements for Installing SQL Server

List of Modules Converted to MANEX Client Server

Installing SQL Server

Accounts Receivable (AR)

Accounts Payable (AP)

General Ledger (GL)

Bank Reconciliation

Prerequisites

Fields & Descriptions

New Statement Information

Deposits

Checks

Generate Automatic Deductions

How To .....

System Utilities

SQL Server Memory Settings and Performance

Definitions

How to schedule and automate backups of SQL Server databases in SQL Server Express

SQL_FAQ's

Deposits Tab

Field Defintions - Bank Reconciliation Deposits tab:

NOTE: Users have the ability to sort by all the grids. If you click on the same header twice the sort order will switch from ascending to descending.

Statement Date	The date of the bank statement
Reconciliation Status	The status of this reconciliation – In Process, Reconciled
	If Displayed in RED, there is an existing note pertaining to the Reconciliation, entered by the user
	Depressing this button will bring up the Enter New Statement Information screen
	Depress this button when the Unreconciled Difference is zero to reconcile the Bank Account
	If the user wants all of the deposits checks as cleared, this button is used.
	The user highlights the first deposit to be checked and then uses this button to check all of the rest.

AR Deposits

Date	Original date the deposit was created
Amount	Total Dollar Amount of the Deposit
Customer	Name of Customer Deposit was received from
Invoice	Invoice number deposit was applied to
Check/Advice #	Customer Check Number
Cleared	Check if Cleared from Bank Account

AR Non Sufficient Funds

Date	Original date the Non-Sufficient Fund record was created
Amount	Total Dollar Amount of the AR Non-Sufficient Fund Record
Customer	Name of Customer for Non Sufficient Funds
Check/Advice #	Check Number that the Non Sufficient Funds are applied against
Cleared	Check if Cleared from Bank Account
	Depress this button to add a new NSF

Journal Entries (Debits)

Date	Orginal date the JE was Created
Amount	Total Dollar Amount of the Journal Entry
Journal Entry	Journal Entry Number
Reason	Reason for the Journal Entry
Cleared	Check if Cleared from Bank Account
	Depress this button to add a New Journal Entry

Deposits Cleared per Bank	This information will be defaulted in from the New Statement Information
Deposits Marked as Cleared	This is the sum of all deposits that were marked as cleared
Difference in Deposits	This is the difference between the Deposits Cleared per Bank and the Deposits Marked as Cleared. This should be zero
Un-Cleared Deposits	This is the sum of all of the deposits listed which were not marked as cleared

Checks Cleared per Bank	This information will be defaulted in from the New Statement Information
Checks Marked as Cleared	This is the sum of all checks that were marked as cleared
Difference	This is the difference between the Checks Cleared per Bank and the Checks Marked as Cleared. This should be zero
Un-Cleared Checks	This is the sum of all of the checks listed which were not marked as cleared

Beginning Balance	Beginning Balance for this account
Ending Balance	The ending balance per the bank statement
Unreconciled Difference	This would be any difference between the New Ending Balance per Bank and the Calculated Balance per Bank. This amount should be zero

Article ID: 5313