>Hi all,
>
>
>I need advise & suggestions on the following request:
>
>It's been rumoured that David Maxey said:
>>
>>There is a lack of a feature in Quicken that simply annoys me.
>[...]
>>Thus, [I want] the entries in the
>>register are not in date order, necessarily.
>
>
>Specifically, David asks for a sort by date of entry into register,
>as opposed to date of posting of txn at bank. (other sort orders,
>e.g. alphabetical are possible. so are filters, e.g. all txn's from
>day 1 to day 45 that start with the letter B).
>
>The question is: what balance should be shown in the balance column?
>The balance w.r.t. the new sorted order, or the "real" balance?
The balance that should be shown should be relative to the sort order
that is currently being shown. That way, it would reflect the actual
running balance that I keep in my checkbook register.
Also, and this is just as important, we need a sort order that is
according to the bank statement. Note that they also keep a running
balance, however, their entries may not go in the same order that you
might expect from the xacct "sort-by-date". This is because of the
fact that you may get multiple entries on the same date and also that
you may make a transaction on one date, but the bank may not post it
until at a later date.
In order to force the entries to be sorted in bank statement order,
we need an additional field or sub-field which allows a sequence
number. Thus, an entry may have a number of 0407.3, which means
that it is entry 3 of date 0407 (remembering, of course, that the
first entry should be 0407.0). This sub-field could have a default
chosen for it, but would be an editable field, along with the bank
date. That means, also, that there must be TWO dates. One for the
register as in "this is the date I did this" and one for the bank
that says "this is when we saw/did something with this". This helps
with the problem of having written a check on one date and not seeing
it clear until 2 weeks later.
These two sorts would allow me to:
1. Reconcile against either my checkbook register, or the bank
statement.
2. See the running total to verify that my math/bank's math is
correct.
3. Easily find missing entries by comparing the bank statement
or the register against the xacct record.
This also requires, for reconciling against the bank statement, that
entries which have not cleared the bank should be hidden when I'm
trying to reconcile against the statement, since those entries do
not occur in the statement. The running balance should only reflect
the visable entries, in the current sort order.
- David Maxey (YAD - Yet Another David: [EMAIL PROTECTED])
P.S. Please add me to your mailing list for xacc. I'm not sure
how I'm suppossed to do that.
P.P.S. I have written large amounts of C code over a couple of
decades and would be glad to help in writing some to support the
gnuish effort. Please let me know what I can do. Thanks.
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
--
Gnucash Developer's List
To unsubscribe send empty email to: [EMAIL PROTECTED]
