Crossing to a new year (was Re[2]: Extracting Account names)
Rusty Carruth
rcarruth@tempe.tt.slb.com
Thu, 3 Jan 2002 09:50:50 -0700 (MST)
Paul Lussier <pll@mclinux.com> wrote:
>
> In a message dated: Thu, 03 Jan 2002 08:48:10 MST
> Rusty Carruth said:
>
> >(Note that I've not included the list. Probably a mistake,
> >so feel free to reply to the list with you answers if you
> >think they should go to the world.)
>
> Nah, too lazy to change the headers :)
Well, I managed to overcome *my* laziness, but it sure wasn't
easy! ;-)
I'm going to include a little more than I normally would, so others
can get a running leap at what's been said... (as it were ;-)
> >That's what I was thinking. How do you handle the fact that your
> >last year's balances will keep changing for a while till all last
> >year's stuff comes through? (You know, the things you forgot to
> >record (nah, we NEVER forget! ;-)
>
> Well, that's an interesting dillemma.
> ...
>
> In both cases, I'd reconcile as best I could, then, if it didn't come
> out right, I'd adjust the "Ending Balance" by the difference shown in
> GnuCash's reconcile window. Once everything was reconciled with
> statements, I'd use the number GnuCash said I had as the "carry
> forward to next year" number.
> ...
> >Does anything strange happen when you do a reconcile across years?
>
> Yeah, my eyes go blurry, I feel a little feint, get nauseas, mouth
> goes dry, etc. That's when I know I should quit for the night ;)
>
> >or do you just do it 'twice'?
>
> Are you insane! Do it twice! After what I just described, why would
> I want to do that! ;)
>
> Well, I guess I actually do. I reconcile for the December portion of
> the statement, then again for the January portion of the statement.
>
> >(Trying to plan ahead here! :-)
>
> Yeah, me too. I say that every year, though for the first time in
> years, I think I may actually be able to stay on top of all this
> stuff! (yeah, right, sure I will ;)
So, having looked at what its going to be like to run split accounts
till everything catches up, I'm beginning to think there's got to
be a better way.
So, here's a couple of options I see:
1 - do nothing. Use the date select feature of gnucash for getting
year-based reports. (Need to investigate to be sure everything
I want to use date-based can be used that way, especially the
'expenses in a year' amounts)
2 - do nothing until ALL of the previous year is reconciled and cleared.
Then, write a script of some kind to split the xml file up
across the year (and maybe add beginning balances while I'm
busy going insane anyway ;-).
3 - same as 2, but modify gnucash to do the split instead of writing
a script.
4 - something else?
So, I'm soliciting comments and ideas on what's the best way to cross
years when I want to be able to look at the expenses on a per-year
basis. Hmm - maybe I need to add the following option to the above
list:
5 - add a report to gnucash which makes time-based reports on any
category tree (e.g. montly expense amounts for the last 12 months)
(assuming that its not already there)
rc