Skip to Content
0
Former Member
May 13, 2010 at 08:41 AM

GL Cummulative Balance Rate Difference

63 Views

Dear Experts,

I have a GL Bank Account, which is set to a USD currency. My Exchange rate for the month is $1 = Ksh. 80 (LC).

When i generate a General Ledger report, the closing cumulative balance figure does not tally with the FC ($) figure. Below is an example:-

Posting Date	Doc. No.	Deb./Cred.(LC)	Cumulative Bal (LC)	Deb./Cred. (FC)	Cumulative Bal(FC) )								
02/03/10	PS 10000174	-48320.00	767276.23	           -604.00	                436.77	
12/03/10	PS 10000186	-1316963.20	-549686.97	          -16462.04	         -16025.27	
12/03/10	PS 10000186	1316963.20	767276.23	          16462.04	         436.77	
30/03/10	RC 10000655	3255200.00	4022476.23	         40690.00	        41126.77	
30/03/10	RC 10000656	2800000.00	6822476.23	           35000.00	         76126.77	
30/03/10	JE 10021335	-2000000.00	4822476.23	          -25000.00	           51126.77	
30/03/10	JE 10021336	-2000000.00	2822476.23	          -25000.00	           26126.77	
30/03/10	JE 10021337	-2080000.00	742476.23	          -26000.00	            126.77	
31/03/10	BN 10021867	-6320.00	   736156.23	           -79.00		     47.77	

If you notice, $47.77 is the cumulative total figure(FC), and the corresponding LC figure value should actually be (47.77*80 = 3821.6) but it is 736156.23.

How can i have the report showing the period end balance in LC (KSH) to be 3,821.60, instead of 736,156.23.

Your help will be much appreciated.

regards,

Feroz Dosani.