Welcome, Guest. Please Login.
06/06/25 at 06:05:12
News:
Home Help Search Login


Pages: 1
Send Topic Print
BANK RECONCILIATION ON EVO-1ST TIME USER (Read 1528 times)
revco123
Browser
*


Live everyday...like
it's your last!

Posts: 16
Gender: female
BANK RECONCILIATION ON EVO-1ST TIME USER
01/22/08 at 13:35:13
 
Hi,  
 
We've tried to use this module last year but it really didn't happen since we have our own accountant doing this work for us. But this year we would like to keep better track of all finances and I know Evo can do this for us. I would like to start using this module this year and what time to start but now. The problem is I don't remember how we did this last year. Lynn (or anyone that knows) could you help me on this? All I have is the bank statement for November & December of 2007. If you could e-mail me the step by step procedure that would be awesome. Thanks in advance!  embarrassed
Back to top
 
 
WWW   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: BANK RECONCILIATION ON EVO-1ST TIME USER
Reply #1 - 01/28/08 at 07:15:31
 
This is how I use option GL-J, not necessarily the TRUE instructions for this module.
 
The Cash Receipts and Cash Disbursements journal transactions feed info to the Check Register.  So you must be using these journals to capture deposits and disbursements.
 
First, you must enter a beginning cash balance via AD-B, which assumes you have established cash accounts,  If not, you can enter a new cash account in AD-B.
 
Once transactions have been processed in the cash receipts and cash disbursements journals to the provided cash account(s), select GL-J, Reconcile Check Register.
 
Select the cash account you wish to reconcile,  
Then select reconcile to bank statement,
and enter a time frame for recconciliation.
 
For example, if I am reconciling for the month of December, I will select those deposits and disbursements with 00/00/00 beginning date and ending date of 12/31.  This will allow for any uncleared checks processed before December, and any deposits made in November or prior that were deposits in transit as far as the bank was concerned.
 
I then tag the deposit details to the deposits listed on the bank statement.  I make sure the total of deposits selected in GL-J  agrees with the total deposits on the bank statement.
 
Then I tag the cleared checks, wires and other disbursements, ensuring the total also matches that on the bank statement.
 
Anything remaining should be uncleared checks and deposits in transit.  This number is the difference between the Bank's cash balance per statement and my company book's cash balance at 12/31. However, this assumes that last month was recconiled properly.  
 
GL-I, Print Check Register, will print listings of uncleared checks and deposits, so you have the details to the difference.  
 
HOPE this provides a little insight.
 
Linda
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
revco123
Browser
*


Live everyday...like
it's your last!

Posts: 16
Gender: female
Re: BANK RECONCILIATION ON EVO-1ST TIME USER
Reply #2 - 01/29/08 at 09:51:12
 
Thanks! I will defenitely try this!
Back to top
 
 
WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: BANK RECONCILIATION ON EVO-1ST TIME USER
Reply #3 - 02/05/08 at 10:37:01
 
Quote from lmk223a on 01/28/08 at 07:15:31:
I then tag the deposit details to the deposits listed on the bank statement. I make sure the total of deposits selected in GL-J agrees with the total deposits on the bank statement.

 
Note that if you had NSF checks or Reversed Payments, or Voided Checks, you will have to wait to tag them until after you make sure the Total Deposits and Total Checks agrees with your statement as there will be extra Cr and Dr in there. The Net may come out right but you won't be able to compare the Statement Totals with the GL-J Totals.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Pages: 1
Send Topic Print