Friday, 16 November 2012

Net Change, Balance at Date and Balance at COA

Net Change, Balance at Date and Balance are 3 important Amount fields in Chart Of Accounts Window. What are the difference among theses fields?

Net Change shows the sum of all G/L Entries within the date range entered in Date Filter flow filter.

Balance at Date shows the sum of all G/L Entries from day one until the ending date entered in Date Filter flow filter. In other words, it shows the balance as at the ending date entered in the Date Filter flow filter.

Balance shows the sum of all G/L Entries from day one until now. Date range entered in the Date Filter flow filter has no effect on Balance field.

For instance, today is 16th Nov 2012 and I entered 01/10/2012..31/10/2012 in the Date Filter flow filter.

Net Change will show sum of all G/L Entries from 01/10/2012 until 31/10/2012.
Balance at Date will show sum of all G/L Entries from day one until 31/10/2012.
Balance will show sum of all G/L Entries.

1 comment:

Anonymous said...

Balance will show ALL entries - not just those upto today's date. I.e. if you post something in the future e.g. 31/12/2012 then this will get included too!