close books

Ken Heard ken at heard.name
Fri Dec 3 11:15:16 EST 2010


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Derek Atkins wrote:
> Ken Heard <ken at heard.name> writes:
> 
>> David T. wrote:
>>>> But including the zeroing transaction in any report will throw your
>>>> numbers off. If you have $1200 of Electric expenses in 2009, you
>>>> will have a $1200 zeroing transaction on January 1 (or December 31,
>>>> etc.), which will throw off the figure for the month of which it is
>>>> a part. Month to month, you'll have $100--until that ZTM (zeroing
>>>> transaction month), when you'll have -$1100. Yuck.
>> How?  If for example the opening balance as of 1 January is $1200, and
>> on that day you zero the income and expense accounts, the account
>> balance at the end of that day will be zero.  Then if on 15 January you
>> pay the electric bill of $100, and if there are no other entries except
>> those made on those dates, the balance as of 31 January will be $100.
>> Consequently any report which includes this account made to show the 31
>> January position will show the balance of $100.  A report of the
>> transactions in that account for the month of January will show the
>> zeroing, but the explanation of the $1200 entry on 1 January is obvious.
> 
> The problem is that if you then run a report from Jan 1 - Jan 31, the
> report will include the $1200 offset from the previous year and throw
> off your numbers.  Sure, if you look at the individual transactions you
> will see the $1200 and then you can manually take that out of your
> numbers.  However you'll be really confused if you run this report and
> see that you spent -$1100 on electricity in January.

No.  Assume that the fiscal year is the calendar year.  Also assume that
 in 2010 your electricity account shows a balance of $1200, meaning --
if the account had zero balance as on 2010-01-01 -- that you spent $1200
on electricity in 2010.  If you run the closing on 2011-01-01-- not
2010-12-31 -- the balance in the account will still be $1200 0n
2011-01-01.  After running the closing on 2011-01-01 but before posting
any other entries on that day, the balance will be zero, because the
- -$1200 offsets the $1200 balance carried over from last year.  So, if
you pay an electricity bill of $100 on 2011-01-31, the balance will be
$100, as follows.

*Transaction details*                         *Balance*
2011-01-01 Opening balance from 2010		$1,200
2011-01-01 Close 2010: less	-1,200		    00
2010-01-31 Electricity bill: add  +100		   100

Regards, Ken Heard



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkz5F5MACgkQlNlJzOkJmTeBigCfdugeFwANPy7Xw5vCUThRM33d
rS4AmwRagAVaZqUtEq1sYebVWUftWDLD
=LJU0
-----END PGP SIGNATURE-----


More information about the gnucash-user mailing list