1. How To .... for Bank Reconciliation
1.1. Generate Automatic Deductions

Enter Manex.exe   Accounting/Accounts Payable/Bank Reconciliation
 
This is the companion screen to the Automatic Bank Deduction tab in the Check Payment Scheduling module.  In this screen, the automatic deductions which were set up previously will be generated. Upon generation, the appropriate journal entry will generate and the outstanding check list will display the automatic deduction.

Upon entering the Bank Reconciliation module, the following screen will display: 
 
 
 

Note that the Generate Automatic Deductions tab is enabled. 

 

Click on the Generate Automatic Deductions tab and the following screen will appear:

 

 

To generate an automatic deduction, depress the Add button and enter your password.   

 

Depress the down arrow next to the Bank Name field.  Select the appropriate bank.  The Account Title and the Account Number will fill in automatically.  Type in the date you want to generate to and depress the Generate Automatic Deductions bar.  The list of all of the automatic bank deduction will appear:

 

In the Y/N field, check the ones you want to be generated.  Depress the Save button.

1.2. Adding a Bank Reconciliation
1.2.1. Initial Bank Reconciliation
Initial Bank Reconciliation
 
Enter Manex.exe
Accounting/Accounts Payable/Bank Reconciliation

 

The following screen will appear:




Depress the Add button and type in your password.  Depress the down arrow next to the Bank Name field.  Highlight the bank of your choice.

 
If this is the very first bank reconciliation for that bank, the following message will appear:
 
To continue, depress the OK button.

The following Bank Reconciliation Setup screen will appear:

Select "This is a New Bank Account" If this is a brand new bank account that has just been created and never used by the customer before, check the box next to that statement. 
 
 
If the bank account has been used by the users for some time (maybe a different software other than ManEx), but this would be the first time that they are actually using the ManEx system to reconcile the account and the system is asking for previous statement information.  Then you would enter the Prior Book Balance Date and the applicable balance.  

Upon completion of your entry, the following message will appear:

Depress the OK button.
 
The screen will populate with the following information:
 
 
 
Enter the Last Stmt Reconciled date, the Last Ending Balance per Bank amount, the Statement Date and the New Ending Balance per bank al the rest of the information will default in and account will be reconciled.  
 
 
 
Save Reconciliation
 
 
  
 
 
 
 


 
1.2.2. Subsequent Bank Reconciliation
Subsequent Bank Reconcilliations 
 
Enter Manex.exe
Accounting/Accounts Payable/Bank Reconciliation

 

The following screen will appear:




Depress the Add button and type in your password.  Depress the down arrow next to the Bank Name field.  Highlight the bank of your choice.
 
.

All of the pertinent header information will automatically load, along with the Last Stmt Reconciled date and the Last Ending Balance per Bank amount which will also appear in the appropriate fields:



From your bank statement you are currently reconciling, enter the bank Statement Date, the Book Balance Date and the New Ending Balance per Bank. Enter the total deposits cleared per the bank statement and enter the Checks cleared per the Bank Statement.  If applicable, enter the Interest earned per the bank statement.  If applicable, enter the bank service charge per the bank statement.
 
 
 
Depress the Deposits tab. Check on the Cleared Y/N box if the deposit has cleared the bank per the bank statement.  (NSF records will display as a negative entry and will allow users to check them off the same way as a regular depost once they have cleared the bank).   If there are any corrections to the bank statement (most unusual), type in the net correction and then enter a complete explanation into the Correction Detail screen.   Note:  No general ledger entry is created for this amount.
 
 
Depress the Checks screen.  Check on the Cleared Y/N box if the deposit has cleared the bank per the bank statement.   If there are any corrections to the bank statement (most unusual), type in the net correction and then enter a complete explanation into the Correction Detail screen.   Note:  No general ledger entry is created for this amount.
 
 
Return to the Summary Screen.  Bank Reconciliation after the Checks and Deposits had been cleared     Note:  The Balance Per Books field goes off the Posted Date for JEs and NOT the Transaction Date.  See the Word attachment <<PS_for_JE_071114.docx>>  for an example.
 
 
Save Reconciliation