Re: Future allocated money vs Budgets

[Adrien Monteleone]

The biggest problem with any of this is if the money is actually sitting in a 
bank account. Reconciling is a mess. (I don’t think you can reconcile a parent 
by considering the child accounts to ‘roll-up’)

This works best with physical cash you hold in your hand.

Technically, that cash is still a current asset because it’s liquid, but that’s 
up to you if you want to segregate it out.

I use the following:

Current Assets:Cash:Wallet
Current Assets:Cash:Savings

I’ve tried several sub accounts of Savings, but it was just too messy when I 
had to move money around for other purposes than the savings were intended for.

One thing that might help is simplifying your splits.

I used to use the Savings account only for transfers in and out. I would then 
create separate transactions for the expenditures from Wallet with money either 
going back to Savings, or to Wallet.

But I found in many cases, I was really taking money out of Savings to spend 
directly for a purpose, so I stopped doing most of the out transfers to Wallet 
and just recorded the expense directly from the Savings account. (I prefer to 
always record outflows from the account they are flowing out of - easier to 
keep it straight) If there was any change or a left-over balance (say I broke a 
C-note for something) and didn’t put that back into my physical Savings 
location but in my wallet, then one of the splits would be to Wallet. (I’m 
meticulous and also have a Current Assets:Change account so it’s easy to 
‘reconcile’ my physical cash in my wallet. This also lets me see how much is in 
my change jar if I want to cash it in. Yes, I even track quarters separately 
because I’m currently stuck with coin-laundry so I need to know at a glance if 
I have enough.)

Certainly, if you are allocating money from a checking account to savings held 
at home, don’t use a sub-account of checking. Use a sub-account of Cash, or 
create a same-level account like I did as Savings, or if you want that separate 
still, as ‘Allocated' with sub-accounts there for specific purposes. (I suppose 
even ‘Envelopes’ would work if you’re physically stuffing them, it’s up to each 
individual how they think of it)

I’m not sure where you’re going using the ‘Money Allocated’ account with 
respect to balancing it with its sub-accounts.

To me, the Money Allocated account (or whatever you call it) should likely be a 
placeholder account and never have any transactions in it. Everything happens 
in the subs.

If you want to allocate funds, you’re taking them from some other regular asset 
account like Checking or Cash. (or Savings if that’s a physical account at a 
bank) That’s the credit side. The debit side is the allocated sub-account.

So something like this:

Dr. Assets:Current Assets:Envelopes:Dining Out  $100
Cr. Assets:Current Assets:Cash  $100

Cash is now less $100 and your Dining Out envelope has $100 in it.

When you go out to eat, I would save a transaction and just spend the money 
(which is physical cash) directly from the sub account.

Dr. Expenses:Food:Dining Out$60
Cr. Assets:Current Assets:Envelopes:Dining Out  $60


A more ‘real world’ example might include holding the change in Cash instead of 
putting it back in your envelope stash location, thus:

Dr. Expenses:Food:Dining Out$58
Dr. Assets:Current Assets:Cash  $ 2
Cr. Assets:Current Assets:Envelopes:Dining Out  $60

Looking over your last reply more I think I see where you’re ending up with 
extra transactions and splits. And while I know I said ‘accounts’ are just 
‘reasons’ and not necessarily related to physical things, perhaps treating the 
allocated money as more of a physical asset would help.

It looks like you want to keep track of allocating money and ‘spending it’ out 
of that allocation as a separate ‘layer’ from the actual location of the funds 
and why they leave your hands, that is you want to record the transaction 
TWICE. That’s adding complexity that I don’t think is needed.

This is why the allocated sub-accounts belong under one or more regular asset 
accounts.

If the money physically is in your control, your wallet, a safe, a drawer of 
envelopes or such, I’d put the Allocated and Allocated:Subs like so for more 
regular and discretionary purposes:

Assets:Current Assets:Cash
Assets:Current Assets:Cash:Allocated
Assets:Current Assets:Cash:Allocated:Dining Out
Assets:Current Assets:Cash:Allocated:Movies
Assets:Current Assets:Cash:Allocated:Snacks
Assets:Current Assets:Cash:Allocated:Groceries
etc.

But if the funds really never leave your checking account until you spend them, 
or you regularly write checks/pay online for some purposes I’d use this:

Assets:Current Assets:Checking
Assets:Current Assets:Checking:Allocated
Assets:Current Assets:Checking:Allocated:Rent
Assets:Current Assets:Checking:Allocated:Utilities
Assets:Current 

RE: Future allocated money vs Budgets

[Matt Graham]

 You beat me to the punch on a couple of things. Yes, I have the tendency to 
over-complicate. I think there needs to be a simple way to do what people want 
though...

I started plotting things out more and came to similar conclusions.

First, when I say “fake” I mean “not corresponding to physical money – cash, 
account balance etc”. You’re right, its bad terminology, and I like the way you 
think of accounts as just a “thing”.

Second, I have tried a number of other programs for my financial needs. All of 
them have various advantages and disadvantages. So with no clear winner, I 
thought I’d try to make GNUCash better...

“Categories” is a vague word and risks things getting complicated. Perhaps all 
of this allocation of money concept would work best if GNUCash introduced 
“categories” purely for allocation? Applications where we are allocating things 
on the side without actually changing our accounts? Lets keep that aside and 
see if it works once we agree on everything else – sounds complicated (and I 
cringe at adding a new ‘semi-account’ type).

Thinking about things further (and trying it) I agree 100% that liabilities 
aren’t involved. Allocating money to something decreases the amount of cash 
(agree with your term – LET “cash” = “liquid assets”), which would correspond 
to a decreased liability... Makes no sense having negative liabilities. My bad.

I tried fiddling with equity as you (tentatively) suggested too, but this 
didn’t really make sense either. You end up with negative equity accounts 
showing how much you have to spend...

So yes – I agree It is asset to asset... Decreasing cash available (asset) is 
balanced by increasing cash to spend on a purpose later (asset).

Creating a sub-account to your physical cash or bank account to track allocated 
money is only good if you are always going to spend out of that account. If I’m 
tracking my spending money from my bank account, but then spend out of my cash 
on spending money...
Dr increase Expense
Cr decrease physical cash I used to pay
Cr decrease the amount in that sub account – gets it out of that sub account
Dr increase the amount in parent account – puts it back in the parent...
It works, I guess, but just seems weird transferring balance between the child 
and parent like this.

So they way I’m thinking of trialling is having a separate asset account 
“Allocated Assets” (separate from Current and Fixed assets). That way when 
allocating money the decrease (cr) in current assets (an account I’ve put as 
“Money Allocated”) is balanced by the increase (dr) in the specific “Allocated 
Assets”:”Spending Money” account.
Spending is the same as above, but the increase to make  “Money Allocated” less 
negative is balanced by the decrease in the relevant Allocated assets 
account

Of course, all of this still means i’m entering four lines for one expenditure. 
The good news is that I only really have four accounts that involve allocated 
money like this (2 spending money, Holiday, and restaurant/café spending). 
Since all of this is a very common application for most personal users, I’m 
wondering if there is an easier way – “categories” defined against an expense 
account that just track how much you have “allocated” to that purpose? Would 
need both aspects – viewing “how much I have left” to spend for that purpose 
(budget line item?), but also ensuring “I have the money in my accounts to be 
able to buy it”. That all sounds too complicated – it would be easier to allow 
the user to tag an expense account, and have GNUCash automatically maintain the 
necessary “Allocated” asset accounts...

I don’t think I am overthinking too far though, purely because it seems like a 
common thing people want. Hence, solution required... Philosophy of accounting 
tells us that this kind of allocation is: double entry on Asset/Asset when 
allocating, two double entries (Asset/Expense and Asset/Asset) when spending.

Hmmm Same conclusion as before – I’m going to try it out for a while before 
suggesting any program changes...

Thanks and regards,

Matt

From: Adrien Monteleone
Sent: Friday, 26 January 2018 4:32 PM
To: GNU Cash User
Subject: Re: Future allocated money vs Budgets

Here’s my attempt to save you a few months…

I think you’re spinning wheels into something more complicated than it needs to 
be.

For starters, there’s no reason any liability account or expense account should 
enter the picture of ‘saving’ for any particular purpose. ‘Spending Money’ 
savings is NOT an expense. Why would anyone think to record it that way?

An expense is when you actually receive something of value and you owe someone 
else in exchange. (goods or services)

If you pay for those goods or services at the same time you receive them, you 
just record the expense.

If however, you receive the goods or services and then pay later - an accrued 
expense - then you use a liability 

Re: Period End Accounts

[David Carlson]

The saved reports-2.4 folder is in the .GnuCash (hidden) folder in the user
directory as described in the WIKI where other program specific settings
are stored.

However, the OP should have kept printouts or electronic backups such as
PDFs, so the custom reports would not be needed.

David C

On Fri, Jan 26, 2018 at 12:07 AM, Adrien Monteleone <
adrien.montele...@gmail.com> wrote:

> I just had #2 happen to me recently.
>
> It was the result of not being careful in using the command line to delete
> a folder. I inadvertently deleted a large portion of my
> "~/Library/Application Support" folder. (I’m on a Mac, not sure of the
> location for Linux or MS)
>
> I realized what a I did after about a second or two, and managed to kill
> the rm process, but it was too late. That bugger was fast. Naturally, I
> happened to be so careless while in-between a physical volume change on my
> Time Machine backup, (the last one died 6 months ago and I haven’t had the
> scratch for a new one) thus I had no way to restore anything and lost
> several months worth of preferences. (Contacts wiped out entirely, that was
> rough)
>
> My GnuCash register data was all intact, because I store it in my User
> folder, but my saved report configurations, as well as some custom reports
> I obtained on this list were all gone.(luckily, I saved a copy of those
> reports to a special User folder, so I didn’t have to go hunting the list
> archives for them)
>
> Perhaps something (or someone) either removed those similar files on
> Mike’s computer or else caused them to not be found where they were
> expected by GnuCash.
>
> I’m not sure if the naming conventions hold across platforms, but at least
> the saved-report config for me is called "saved-reports-2.4”. If a file
> search for that name turns something up, he might be able to get those
> configs back.
>
>
> Regards,
> Adrien
>
> > On Jan 25, 2018, at 11:28 PM, DaveC49  wrote:
> >
> > Mike,
> >
> > 1. it is unlikely but it is possible to unset the reconciliation status
> but
> > a warning with an opt out of the change is issued before it is changed
> and
> > it is possible to edit a reconciled split of a transaction but you will
> > normally get a warning even if the split you are editing is not into a
> > reconciled account.  The most likely possiblity is that you may have
> opened
> > one of the backup files from before the reconciliation rather than the
> main
> > file. The mainfile will be .gnucash while the backup files have
> a
> > format .gnucash..gnucash where  looks
> like
> > "20161215163750". Each time a backup file is created (when gnucash is
> > closed) a corresponding log file is created
> > .gnucash..log.  If you find files with a format
> > .gnucash..gnucash. is
> > highly likely you have opened up a backup file in error at some point. (I
> > lost 3 months of reconciliations through doing this recently).
> >
> > The other files you can expect to see in the data directory will be
> > filename>.gnucash.LCK ( a lock file to prevent the file being opened
> > more than once) and a .gnucash.. > number>.LNK. These are normal
> >
> > 2. Unsure of what is happening here. I have just saved a custom report
> using
> > Reports->Save Report Configuration
> > and recalled it using
> > Reports->Saved Report Configuration.
> >
> > After closing Gnucash and Reopening the report is still there so the
> > mechanism is fine. I wonder if your problem may be related to a similar
> > possibility as 1 where an earlier backup file has been opened as the main
> > file?  As far as i can tell the saved reports are in the main gnucash
> file
> > (I couldn't find them elsewhereon my Linux setup).
> >
> > 3.  Yes there is a mechanism for period end. Tools->Close Book.  (see
> > https://www.gnucash.org/docs/v2.6/C/gnucash-help/tool-close-book.html)
> in
> > the Gnucash Help manual
> > (https://www.gnucash.org/docs/v2.6/C/gnucash-help/help.html). This
> should
> > create transactions to zero the income and expense accounts to Equity as
> > described in the documentation referenced.  There is much discussion
> about
> > whether this is necessary in Gnucash as the reports can be set to
> generate
> > for any specified period but if you have a pedantic accountant it is
> there.
> >
> > Setting in stone is another question. Any computer file on a read/write
> > medium is always alterable ( any file locking only helps with accidental
> > writing not a deliberate attempt to change the file). Most people drop a
> > copy of their file as it is when the financial reports are generated
> onto a
> > readonly medium like CDROM, DVD and store that as a set in stone copy of
> the
> > state of the finances at that time. You will also find a lot of
> discussion
> > of this issue in the forum archives.
> >
> > David
> >
> > David
> >
> >
> >
> > -
> > David Cousens
> > --
> > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-
> f1415819.html
> 

Re: Period End Accounts

[Adrien Monteleone]

I just had #2 happen to me recently.

It was the result of not being careful in using the command line to delete a 
folder. I inadvertently deleted a large portion of my "~/Library/Application 
Support" folder. (I’m on a Mac, not sure of the location for Linux or MS)

I realized what a I did after about a second or two, and managed to kill the rm 
process, but it was too late. That bugger was fast. Naturally, I happened to be 
so careless while in-between a physical volume change on my Time Machine 
backup, (the last one died 6 months ago and I haven’t had the scratch for a new 
one) thus I had no way to restore anything and lost several months worth of 
preferences. (Contacts wiped out entirely, that was rough)

My GnuCash register data was all intact, because I store it in my User folder, 
but my saved report configurations, as well as some custom reports I obtained 
on this list were all gone.(luckily, I saved a copy of those reports to a 
special User folder, so I didn’t have to go hunting the list archives for them)

Perhaps something (or someone) either removed those similar files on Mike’s 
computer or else caused them to not be found where they were expected by 
GnuCash.

I’m not sure if the naming conventions hold across platforms, but at least the 
saved-report config for me is called "saved-reports-2.4”. If a file search for 
that name turns something up, he might be able to get those configs back.


Regards,
Adrien

> On Jan 25, 2018, at 11:28 PM, DaveC49  wrote:
> 
> Mike,
> 
> 1. it is unlikely but it is possible to unset the reconciliation status but
> a warning with an opt out of the change is issued before it is changed and
> it is possible to edit a reconciled split of a transaction but you will
> normally get a warning even if the split you are editing is not into a
> reconciled account.  The most likely possiblity is that you may have opened
> one of the backup files from before the reconciliation rather than the main
> file. The mainfile will be .gnucash while the backup files have a
> format .gnucash..gnucash where  looks like
> "20161215163750". Each time a backup file is created (when gnucash is
> closed) a corresponding log file is created
> .gnucash..log.  If you find files with a format
> .gnucash..gnucash. highly likely you have opened up a backup file in error at some point. (I
> lost 3 months of reconciliations through doing this recently). 
> 
> The other files you can expect to see in the data directory will be
> filename>.gnucash.LCK ( a lock file to prevent the file being opened
> more than once) and a .gnucash.. number>.LNK. These are normal
> 
> 2. Unsure of what is happening here. I have just saved a custom report using 
> Reports->Save Report Configuration 
> and recalled it using 
> Reports->Saved Report Configuration. 
> 
> After closing Gnucash and Reopening the report is still there so the
> mechanism is fine. I wonder if your problem may be related to a similar
> possibility as 1 where an earlier backup file has been opened as the main
> file?  As far as i can tell the saved reports are in the main gnucash file
> (I couldn't find them elsewhereon my Linux setup).
> 
> 3.  Yes there is a mechanism for period end. Tools->Close Book.  (see
> https://www.gnucash.org/docs/v2.6/C/gnucash-help/tool-close-book.html)  in
> the Gnucash Help manual
> (https://www.gnucash.org/docs/v2.6/C/gnucash-help/help.html). This should
> create transactions to zero the income and expense accounts to Equity as
> described in the documentation referenced.  There is much discussion about
> whether this is necessary in Gnucash as the reports can be set to generate
> for any specified period but if you have a pedantic accountant it is there.  
> 
> Setting in stone is another question. Any computer file on a read/write
> medium is always alterable ( any file locking only helps with accidental
> writing not a deliberate attempt to change the file). Most people drop a
> copy of their file as it is when the financial reports are generated onto a
> readonly medium like CDROM, DVD and store that as a set in stone copy of the
> state of the finances at that time. You will also find a lot of discussion
> of this issue in the forum archives.
> 
> David
> 
> David
> 
> 
> 
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Future allocated money vs Budgets

[Adrien Monteleone]

Here’s my attempt to save you a few months…

I think you’re spinning wheels into something more complicated than it needs to 
be.

For starters, there’s no reason any liability account or expense account should 
enter the picture of ‘saving’ for any particular purpose. ‘Spending Money’ 
savings is NOT an expense. Why would anyone think to record it that way?

An expense is when you actually receive something of value and you owe someone 
else in exchange. (goods or services)

If you pay for those goods or services at the same time you receive them, you 
just record the expense.

If however, you receive the goods or services and then pay later - an accrued 
expense - then you use a liability account to track what you owe. (you still 
record the expense when you receive the goods or services)

If you pay for goods or services *before* receiving them, it’s not an expense 
yet. (a deferred expense) It’s a shift from one asset, likely 'cash', to 
another asset called 'prepaid expenses.’ (cash is generic for liquid assets, 
this includes checking and savings) When you actually use that asset, that is, 
either receive the service or the goods, then you record the expense. (you’d 
also do this for other assets you acquire and use up later - like supplies. 
Depreciation is an example of a deferred expense for special assets you paid up 
front for but use up slowly)

If however, you’ve not received any goods or services, and you don’t know if 
you actually will and haven’t yet paid for them, then expenses and liabilities 
aren’t even in the picture.

All you are doing is segregating assets for informational purposes. (the 
practice of ‘envelope budgeting’ fits this model) The only accounts involved 
are asset accounts.

They aren’t ‘fake’ any more than any other account in your books is fake. If by 
‘fake’ you mean they don’t correspond to a real world account held at some 
institution then that goes for nearly all accounts in your ledger save a small 
handful. (unless you are quite the prolific banker, borrower, investor or 
credit spender)

The point of accounts is to track where money comes from and goes to. Some of 
those accounts *might* have real-world counterparts, but they are all no more 
‘real’ or ‘fake’ than any other. Accounts are ‘reasons’, not physical things. 
(note, ‘account’ is not some special term. You have an ‘account’ at a bank, 
because they created one in their books to track the money you gave them. They 
have lots of other accounts on their books that don’t correspond like you think 
they do. Your ‘account’ at your bank is simply their ‘reason’ for having money 
that doesn’t belong to them.) I might draw the ire of those wanting to have 
GnuCash stand apart from Intuit products, but basically, your Chart of Accounts 
is just a Chart of Categories, Chart of Classifications, or Chart of Reasons to 
be more accurate. It is a system of classification. Don’t think even of 
‘account’ as a thing, it’s a really a verb in this sense - you are ‘accounting’ 
for why something is or why it happened.

For the purpose of planning expenses, the GnuCash budgeting module can help. 
(certainly, it is limited and needs improvement)

For the purpose of putting money aside or segregating it so you don’t 
‘accidentally’ spend it, that’s just financial discipline. Some people find 
that they can utilize sub-accounts or special savings/asset accounts for this 
purpose to ‘hide’ the money from themselves. This can cause a mess with 
reconciliation though.

Budgeting is the process of planning your expenses. Saving is the process of 
not spending. The two are not the same thing. (but certainly one influences the 
other)

Using sub-accounts or other asset accounts has the advantage of being able to 
see how much you’ve saved, but not how much you have left towards a goal. I 
suppose one could get creative with equity accounts in this regard, but it 
might be more work than necessary. (I hesitated to even mention it) Certainly a 
special set of ‘savings goals’ liability accounts could be used as well, but 
there again, this is confusing the issue of what a liability really is or 
isn’t. Your balance sheet would be all out of whack. (unless you don’t care)

With the envelope method, you aren’t creating liabilities by saving. (even 
negative liabilities!) You’re just taking some of your assets and putting them 
inside envelopes. Those are still assets. They don’t change their nature 
because of the envelope. You don’t suddenly have this not-quite nefarious 
non-expense or imaginary negative debt. You just separated your cash to keep it 
out of your wallet so you can pay your bills, buy gifts, make charitable 
donations, or have a small savings to cover emergencies instead of splurging on 
impulse buys or going out to dinner instead of cooking.

What you have are assets that you want to earmark, at least temporarily and not 
even by hard and fast rule necessarily. You really don’t *owe* that money to 
anyone.

So I would 

Re: Period End Accounts

[DaveC49]

Mike,

1. it is unlikely but it is possible to unset the reconciliation status but
a warning with an opt out of the change is issued before it is changed and
it is possible to edit a reconciled split of a transaction but you will
normally get a warning even if the split you are editing is not into a
reconciled account.  The most likely possiblity is that you may have opened
one of the backup files from before the reconciliation rather than the main
file. The mainfile will be .gnucash while the backup files have a
format .gnucash..gnucash where  looks like
"20161215163750". Each time a backup file is created (when gnucash is
closed) a corresponding log file is created
.gnucash..log.  If you find files with a format
.gnucash..gnucash..gnucash.LCK ( a lock file to prevent the file being opened
more than once) and a .gnucash...LNK. These are normal

2. Unsure of what is happening here. I have just saved a custom report using 
Reports->Save Report Configuration 
and recalled it using 
Reports->Saved Report Configuration. 

After closing Gnucash and Reopening the report is still there so the
mechanism is fine. I wonder if your problem may be related to a similar
possibility as 1 where an earlier backup file has been opened as the main
file?  As far as i can tell the saved reports are in the main gnucash file
(I couldn't find them elsewhereon my Linux setup).

3.  Yes there is a mechanism for period end. Tools->Close Book.  (see
https://www.gnucash.org/docs/v2.6/C/gnucash-help/tool-close-book.html)  in
the Gnucash Help manual
(https://www.gnucash.org/docs/v2.6/C/gnucash-help/help.html). This should
create transactions to zero the income and expense accounts to Equity as
described in the documentation referenced.  There is much discussion about
whether this is necessary in Gnucash as the reports can be set to generate
for any specified period but if you have a pedantic accountant it is there.  

Setting in stone is another question. Any computer file on a read/write
medium is always alterable ( any file locking only helps with accidental
writing not a deliberate attempt to change the file). Most people drop a
copy of their file as it is when the financial reports are generated onto a
readonly medium like CDROM, DVD and store that as a set in stone copy of the
state of the finances at that time. You will also find a lot of discussion
of this issue in the forum archives.

David

David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Question

[Adrien Monteleone]

Final note, the software doesn’t auto-balance anything. The reconciliation 
process is something you do manually by marking transactions as ‘reconciled’ 
when your statement comes in. If it doesn’t balance, you have the option of 
cancelling the reconciliation, or making an adjusting entry to an account of 
your choice to make it balance. (such as Expenses:Miscellaneous, the Imbalance 
account , or the Orphan account)

Regards,
Adrien

> On Jan 25, 2018, at 4:12 PM, Bill Hessinger via gnucash-user 
>  wrote:
> 
> Question to GNUcash Mailing list:
> 
> I have just loaded version 2.6.19 onto my Mac laptop.  Could someone walk me 
> thru (via an email) setting up the following procedure?
> 
> Primary checking account (all funds stored here).  No web connection to bank 
> required.
>   10 sub-accounts where  funds will be transferred on a monthly basis out 
> of the primary account in order  to accumulate to pay a yearly due bill.  At 
> payment time the accumulated funds will be transferred back into the primary 
> account and a check will be deducted from the primary balance. 
>   It sounds so simple, but I can’t seem to set it up properly.  Hopefully 
> once a month the software will balance GNUcash ledger to the bank statement.
> 
> Hope you’re having a good day,
> 
> Billy
> wahes...@yahoo.com
> 770-335-2431
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Question

[Adrien Monteleone]

What exactly is the hang up?

You're describing needing 10 ‘virtual savings accounts’ to segregate funds that 
exist in a real bank account.

Have you managed to set up the bank account and the child virtual accounts?

Are you transferring funds to them manually or do you want an automatic ‘draft’ 
out of checking?

If you want something automated, look into scheduled transactions. (SX)

I don’t think they’ll fire on any particular event (like a deposit) but they 
can fire on a schedule. It is possible to use formulas in them to calculate 
amounts, but I’ve never messed with that part to know if you can base this off 
of the current account balance or not.

Setting up say to pull $100 a month at the end of the month for example into 
each account is fairly straightforward. You can certainly transfer different 
amounts on different schedules, but if you don’t mind doing it all at the same 
time for each sub-account, you can use a single SX with splits and custom 
amounts for each one.

If you want to do this manually, just use the transfer button as desired, or 
enter the transaction directly.

Depending on how you want to handle payment, you could transfer the funds back 
as a separate transaction, or make it part of the payment transaction.

Is it the entry for these you are having issue with?

A transfer out of checking and into a sub-account would look something like 
this:

Dr. Assets:Checking:Sub-1   $100
Cr. Assets:Checking $100

A transfer back at the end of the year, would be the opposite.

Doing multiples at once would look like this:

Dr. Assets:Checking:Sub-1   $100
Dr. Assets:Checking:Sub-2   $ 50
Dr. Assets:Checking:Sub-3   $ 25
Dr. etc.
Cr. Assets:Checking $175(+)

The payment combined with the annual transfer can look like this (assuming you 
aren’t using business features to make the payment):

Dr. Assets:Checking $1000
Dr. Liabilities:Annual Bill Account $1000
Cr. Assets:Checking:Sub-1   $ 700
Cr. Assets:Checking:Sub-2   $ 200
Cr. Assets:Checking:Sub-3   $ 100
Cr. etc.
Cr. Assets:Checking $1000

or you could skip the use of Assets:Checking parent account to make the payment 
and just ‘pay’ the bill out of the ‘virtual’ sub-accounts directly.

Dr. Liabilities:Annual Bill Account $1000
Cr. Assets:Checking:Sub-1   $ 700
Cr. Assets:Checking:Sub-2   $ 200
Cr. Assets:Checking:Sub-3   $ 100
Cr. etc.

If you’re using the business features to pay the bill, then doing a transfer 
back to checking will make life easier. Again, this can be each account 
separately, or as a single transaction with 11 splits. (1 split for each sub 
account as a credit and one for the parent real account as a debit)

Regards,
Adrien

> On Jan 25, 2018, at 4:12 PM, Bill Hessinger via gnucash-user 
>  wrote:
> 
> Question to GNUcash Mailing list:
> 
> I have just loaded version 2.6.19 onto my Mac laptop.  Could someone walk me 
> thru (via an email) setting up the following procedure?
> 
> Primary checking account (all funds stored here).  No web connection to bank 
> required.
>   10 sub-accounts where  funds will be transferred on a monthly basis out 
> of the primary account in order  to accumulate to pay a yearly due bill.  At 
> payment time the accumulated funds will be transferred back into the primary 
> account and a check will be deducted from the primary balance. 
>   It sounds so simple, but I can’t seem to set it up properly.  Hopefully 
> once a month the software will balance GNUcash ledger to the bank statement.
> 
> Hope you’re having a good day,
> 
> Billy
> wahes...@yahoo.com
> 770-335-2431
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Please remove me from the mailing list

[Liz]

On Thu, 25 Jan 2018 17:11:25 -0600
David Carlson  wrote:

> In that regard, where-ever there are instructions about subscribing
> and un-subscribing it would be useful to have a link to the Nabble
> mirror, if it is appropriate to call it that.
> 
> David C

There isn't a place on the default mailman pages to put that. I'm sure
Derek will say "patches welcome"

:)

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Question

[Bill Hessinger via gnucash-user]

Question to GNUcash Mailing list:

I have just loaded version 2.6.19 onto my Mac laptop.  Could someone walk me 
thru (via an email) setting up the following procedure?

Primary checking account (all funds stored here).  No web connection to bank 
required.
10 sub-accounts where  funds will be transferred on a monthly basis out 
of the primary account in order  to accumulate to pay a yearly due bill.  At 
payment time the accumulated funds will be transferred back into the primary 
account and a check will be deducted from the primary balance. 
It sounds so simple, but I can’t seem to set it up properly.  Hopefully 
once a month the software will balance GNUcash ledger to the bank statement.

Hope you’re having a good day,

Billy
wahes...@yahoo.com
770-335-2431

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Reports very slow to open

[John Ralls]

David,

Maybe just to rule it out as an issue you could temporarily put it on a local 
drive.

How big is it? It's XML, right? See if turning compression on or off makes a 
difference.

Regards,
John Ralls


> On Jan 25, 2018, at 3:15 PM, David Carlson  
> wrote:
> 
> I failed to mention that my data file is not on my "C" drive, it is on a
> LAN file-server, but the entire path is via 100 MHz Ethernet, no Wi-Fi.
> 
> David C
> 
> On Thu, Jan 25, 2018 at 2:45 PM, David Carlson 
> wrote:
> 
>> Preliminary results comparing release 2.6.18-3 with 2.7.3 on a Dell
>> Precision 7510 laptop running Windows 7 sp1 64 bit with a Intel(R) Core(TM)
>> i7-6820HQ CPU @2.70Ghz and 24.0 GB installed RAM and all updates installed
>> except a recent Dell display driver update and the Spectre patch update is
>> not installed yet(?):
>> 
>> Opening a copy of my current data file with scads of tabs including
>> several reports, and a read-only register tab.
>> 
>> In 2.6.18-3 it took 3 minutes 54 seconds to complete opening the file with
>> no Since Last Run interruption.
>> 
>> In 2.7.3 first touch it took 8 minutes 25 seconds to the metadata migrated
>> window.
>> 
>> Second opening 7 minutes 5 seconds.  I have many more details to share
>> elsewhere.
>> 
>> David C
>> 
>> 
>> On Thu, Jan 25, 2018 at 1:09 PM, Geert Janssens <
>> geert.gnuc...@kobaltwit.be> wrote:
>> 
>>> Op donderdag 25 januari 2018 17:17:48 CET schreef David Carlson:
 About not seeing Geert's message in the Gmail instance in Firefox on my
 laptop, on that machine gmail put it into spam because it did not meet
 their lofty standards for authentication.  On the Gmail app on my
>>> Samsung
 phone, it was in the Inbox.  Most of Geert's other messages this morning
 went to my inbox on the laptop.  Go figure!?!  樂
 
 David C
 
>>> Yeah, I don't know what I ever did to upset Google that much they want to
>>> delegate me to the spam box... I tried to say I'm sorry but they didn't
>>> want
>>> to hear it ;)
>>> 
>>> Geert
>>> 
>>> 
>>> 
>> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Reports very slow to open

[David Carlson]

I failed to mention that my data file is not on my "C" drive, it is on a
LAN file-server, but the entire path is via 100 MHz Ethernet, no Wi-Fi.

David C

On Thu, Jan 25, 2018 at 2:45 PM, David Carlson 
wrote:

> Preliminary results comparing release 2.6.18-3 with 2.7.3 on a Dell
> Precision 7510 laptop running Windows 7 sp1 64 bit with a Intel(R) Core(TM)
> i7-6820HQ CPU @2.70Ghz and 24.0 GB installed RAM and all updates installed
> except a recent Dell display driver update and the Spectre patch update is
> not installed yet(?):
>
> Opening a copy of my current data file with scads of tabs including
> several reports, and a read-only register tab.
>
> In 2.6.18-3 it took 3 minutes 54 seconds to complete opening the file with
> no Since Last Run interruption.
>
> In 2.7.3 first touch it took 8 minutes 25 seconds to the metadata migrated
> window.
>
> Second opening 7 minutes 5 seconds.  I have many more details to share
> elsewhere.
>
> David C
>
>
> On Thu, Jan 25, 2018 at 1:09 PM, Geert Janssens <
> geert.gnuc...@kobaltwit.be> wrote:
>
>> Op donderdag 25 januari 2018 17:17:48 CET schreef David Carlson:
>> > About not seeing Geert's message in the Gmail instance in Firefox on my
>> > laptop, on that machine gmail put it into spam because it did not meet
>> > their lofty standards for authentication.  On the Gmail app on my
>> Samsung
>> > phone, it was in the Inbox.  Most of Geert's other messages this morning
>> > went to my inbox on the laptop.  Go figure!?!  樂
>> >
>> > David C
>> >
>> Yeah, I don't know what I ever did to upset Google that much they want to
>> delegate me to the spam box... I tried to say I'm sorry but they didn't
>> want
>> to hear it ;)
>>
>> Geert
>>
>>
>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Please remove me from the mailing list

[David Carlson]

In that regard, where-ever there are instructions about subscribing and
un-subscribing it would be useful to have a link to the Nabble mirror, if
it is appropriate to call it that.

David C



On Thu, Jan 25, 2018 at 3:41 PM, Geert Janssens 
wrote:

> Op donderdag 25 januari 2018 22:31:26 CET schreef Adrien Monteleone:
> > If he successfully unsubscribes, how does he report back?
> >
> > I guess he could re-subscribe, report, then unsubscribe again.
> >
> > Regards,
> > Adrien
> >
> We have a list moderator that could manually allow the message to pass
> even if
> the original poster has now unsubscribed. Particularly as someone on list
> asked about it.
>
> Geert
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Please remove me from the mailing list

[Tommy Trussell]

On Thu, Jan 25, 2018 at 3:31 PM, Adrien Monteleone <
adrien.montele...@gmail.com> wrote:

> If he successfully unsubscribes, how does he report back?
>
> I guess he could re-subscribe, report, then unsubscribe again.
>
> Regards,
> Adrien
>


if he's using Nabble he can report back without being subscribed to the
list at all.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Please remove me from the mailing list

[Adrien Monteleone]

If he successfully unsubscribes, how does he report back?

I guess he could re-subscribe, report, then unsubscribe again.

Regards,
Adrien

> On Jan 25, 2018, at 2:58 PM, Tommy Trussell  wrote:
> 
> On Thu, Jan 25, 2018 at 3:27 AM, Megagrumpy  wrote:
> 
>> Tried to do it myself but going around in circles!
>> 
>> 
>> --
>> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 
> 
> Greg Feneis just sent an image showing you how to unsubscribe from the
> mailing list. IF you cannot get that to work, I note that you're apparently
> reading this list through Nabble, which is a completely separate service
> that mirrors the list and duplicates some of the functionality of the
> OFFICIAL GnuCash list. You may actually be getting your email messages from
> THEM, instead. I clicked the link at the bottom of your message (that came
> through the GnuCash email list) and noticed the Nabble site includes a
> similar email subscribe/unsubscribe page.
> 
> I hope you'll report back and let the list know in case this is helpful to
> others.
> 
> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Please remove me from the mailing list

[Tommy Trussell]

On Thu, Jan 25, 2018 at 3:27 AM, Megagrumpy  wrote:

> Tried to do it myself but going around in circles!
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user


Greg Feneis just sent an image showing you how to unsubscribe from the
mailing list. IF you cannot get that to work, I note that you're apparently
reading this list through Nabble, which is a completely separate service
that mirrors the list and duplicates some of the functionality of the
OFFICIAL GnuCash list. You may actually be getting your email messages from
THEM, instead. I clicked the link at the bottom of your message (that came
through the GnuCash email list) and noticed the Nabble site includes a
similar email subscribe/unsubscribe page.

I hope you'll report back and let the list know in case this is helpful to
others.

-
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Reports very slow to open

[David Carlson]

Preliminary results comparing release 2.6.18-3 with 2.7.3 on a Dell
Precision 7510 laptop running Windows 7 sp1 64 bit with a Intel(R) Core(TM)
i7-6820HQ CPU @2.70Ghz and 24.0 GB installed RAM and all updates installed
except a recent Dell display driver update and the Spectre patch update is
not installed yet(?):

Opening a copy of my current data file with scads of tabs including several
reports, and a read-only register tab.

In 2.6.18-3 it took 3 minutes 54 seconds to complete opening the file with
no Since Last Run interruption.

In 2.7.3 first touch it took 8 minutes 25 seconds to the metadata migrated
window.

Second opening 7 minutes 5 seconds.  I have many more details to share
elsewhere.

David C


On Thu, Jan 25, 2018 at 1:09 PM, Geert Janssens 
wrote:

> Op donderdag 25 januari 2018 17:17:48 CET schreef David Carlson:
> > About not seeing Geert's message in the Gmail instance in Firefox on my
> > laptop, on that machine gmail put it into spam because it did not meet
> > their lofty standards for authentication.  On the Gmail app on my Samsung
> > phone, it was in the Inbox.  Most of Geert's other messages this morning
> > went to my inbox on the laptop.  Go figure!?!  樂
> >
> > David C
> >
> Yeah, I don't know what I ever did to upset Google that much they want to
> delegate me to the spam box... I tried to say I'm sorry but they didn't
> want
> to hear it ;)
>
> Geert
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Reports very slow to open

[Geert Janssens]

Op donderdag 25 januari 2018 17:17:48 CET schreef David Carlson:
> About not seeing Geert's message in the Gmail instance in Firefox on my
> laptop, on that machine gmail put it into spam because it did not meet
> their lofty standards for authentication.  On the Gmail app on my Samsung
> phone, it was in the Inbox.  Most of Geert's other messages this morning
> went to my inbox on the laptop.  Go figure!?!  樂
> 
> David C
> 
Yeah, I don't know what I ever did to upset Google that much they want to 
delegate me to the spam box... I tried to say I'm sorry but they didn't want 
to hear it ;)

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Reports very slow to open

[David Carlson]

About not seeing Geert's message in the Gmail instance in Firefox on my
laptop, on that machine gmail put it into spam because it did not meet
their lofty standards for authentication.  On the Gmail app on my Samsung
phone, it was in the Inbox.  Most of Geert's other messages this morning
went to my inbox on the laptop.  Go figure!?!  樂

David C

On Thu, Jan 25, 2018 at 9:52 AM, David Carlson 
wrote:

> Hi All,
>
> I am in the process of downloading 2.7.3 and preparing a test file to see
> if that release is improved.  I cannot see the email asking for that here
> in this instance of Gmail on my real laptop, but I am sure there was one.
>
> On a related note I have a question about splash screen behavior.  On this
> computer I have easy access to release 2.6.18-3 in Windoze, 2.6.11 in Linux
> Debian Jessie and another release in Ubuntu 16.04.  I think in all three
> instances the splash screen , once it has appeared, will disappear if I try
> to touch it with the mouse pointer.  This is a pain if there are other
> windows in the way so I cannot see if it is still rendering reports.  If I
> use an indirect method to move the focus back to that screen it will come
> to the foreground as expected, but I do not know how to move it around on
> the desktop.  I will be testing that as well when I am testing 2.7.3, but
> if others have comments, I would like to hear them.
>
> David C
> ​
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: info about action field in double-line view

[Adrien Monteleone]

Geert,

Could the install not include a particular required font as a dependency or as 
part of the installer?

Perhaps even better would be to use a GPL licensed icon font, though I’m not 
sure if you can specify different fonts for different cells in the register. 
Doing so would provide a cleaner look regardless of the desktop theme. Maybe 
the combination of an icon font and mapping the desired symbols to the common 
unicode tables for them might work.

Just a thought.

Regards,
Adrien

> On Jan 25, 2018, at 2:20 AM, Geert Janssens  
> wrote:
> 
> Op woensdag 24 januari 2018 23:14:29 CET schreef Tommy Trussell:
>> Geert:
>> 
>> Maybe the legacy register code cannot handle icons, but instead of using a
>> letter such as "F", can it handle Unicode glyphs?
>> 
>> Here are a few of many available glyphs (including example URLs in case
>> they get mangled in email):
>> 
>>  paperclip http://graphemica.com/%F0%9F%93%8E
>> 
>>  link symbol http://graphemica.com/%F0%9F%94%97
>> 
>>  file folder http://graphemica.com/%F0%9F%93%81
>> 
>>  floppy disk http://graphemica.com/%F0%9F%92%BE
>> 
>>  pushpin http://graphemica.com/%F0%9F%93%8C
>> 
>> ✓check mark http://graphemica.com/%E2%9C%93
>> 
>>  page with curl http://graphemica.com/%F0%9F%93%83
>> 
>>  wastebasket http://graphemica.com/%F0%9F%97%91
>> 
>> ⛔ no entry http://graphemica.com/%E2%9B%94
> 
> Hi Tommy,
> 
> That's a neat idea! I didn't think of this at all.
> 
> Text is rendered by the gtk default rendering code, which appears to handle 
> unicode glyphs just fine. I have just copy-pasted the paperclip glyph above 
> in 
> a register in gnucash 2.6.19 (!) and it is rendered correctly.
> 
> The only reservation I'd have is we don't control the user's 
> default/preferred 
> system font. If the chosen font doesn't have the chosen glyphs, the field 
> would display a "glyph-not-found" character. I have no idea what glyphs the 
> default fonts on the various platforms we support provide. That would need 
> some experimentation first.
> 
> Geert
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Please remove me from the mailing list

[Megagrumpy]

Tried to do it myself but going around in circles!





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Reports very slow to open

[Keith Myers]

This is happening on Window7 64bit too.  I didn't have this issue until I
installed 2.6.19. Now even the simplest report of summing up an expense
report of less than 50 entries takes a couple of minutes to appear with the
"GnuCash is not responding" error message.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: counter number format not used in tax invoice (solved)

[Geert Janssens]

Op donderdag 25 januari 2018 02:46:23 CET schreef Derek Atkins:
> Geert Janssens  writes:
> > li works because it represents an integral number.
> > ld does not work because it represents a decimal number. Telling gnucash
> > to
> 
> This isn't quite right.  'd' is still an integer value.  The issue is
> that some platforms use 'li' to represent long integers, and others use
> 'ld'.  It depends on the underlying 'printf' function, which is platform
> dependent.

Oops, indeed.

Thanks for correcting me.

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.