Re: Please remove me from the mailing list

[Adonay Felipe Nogueira]

I have been a mailing list administrator for libreplanet-br for a year
now, and I recall that there is a place to put general text in the
mailing list description/listinfo page and in the footer of the email
message. Perhaps they can make use of that to post a link saying "hey,
if you use Nabble, the unsubscription must be done this way: ...".

2018-01-26T13:26:23+1100 Liz wrote:
> There isn't a place on the default mailman pages to put that. I'm sure
> Derek will say "patches welcome"
>
> :)
>
> Liz

-- 
- https://libreplanet.org/wiki/User:Adfeno
- Palestrante e consultor sobre /software/ livre (não confundir com
  gratis).
- "WhatsApp"? Ele não é livre. Por favor, veja formas de se comunicar
  instantaneamente comigo no endereço abaixo.
- Contato: https://libreplanet.org/wiki/User:Adfeno#vCard
- Arquivos comuns aceitos (apenas sem DRM): Corel Draw, Microsoft
  Office, MP3, MP4, WMA, WMV.
- Arquivos comuns aceitos e enviados: CSV, GNU Dia, GNU Emacs Org, GNU
  GIMP, Inkscape SVG, JPG, LibreOffice (padrão ODF), OGG, OPUS, PDF
  (apenas sem DRM), PNG, TXT, WEBM.
___
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

[David T. via gnucash-user]

Adrien,

A small point: there is an option on the reconcile window to include 
subaccounts, so that should not pose a problem.

David

> On Jan 26, 2018, at 12:38 PM, Adrien Monteleone  
> wrote:
> 
> 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

Re: Future allocated money vs Budgets

[Maf. King]

On Friday, 26 January 2018 11:34:52 GMT David T. via gnucash-user wrote:
> Adrien,
> 
> A small point: there is an option on the reconcile window to include
> subaccounts, so that should not pose a problem.
> 
> David
> 

David,

I too thought about that option, but also considered that the transactions to 
allocate funds to the sub-accounts wouldn't show on the statement from the 
bank.  So it will still take a bit of manual figuring out to reconcile such an 
account structure.

0.02
Maf.



-- 
Maf. King
PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542



___
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: MacOS 32-bit support

[Robert Heller]

At Thu, 25 Jan 2018 23:52:00 -0600 Adrien Monteleone 
 wrote:

> 
> Thanks for the heads-up. (I still have a Snow Leopard Macbook, but don’t
> use it for GnuCash any longer)
> 
> Any reason to think a 32-bit vm to run 2.6.x if needed on 10.14 or a 64-bit
> vm to run 2.7/3.0 on older Macs wouldn’t handle those hopefully few cases?
> (other than maybe a performance hit that is)

Is it possible to run a 64-bit VM on 32-bit hardware?  I suspect not.

Note: with Linux/KVM (don't know about other VM systems), you don't actually 
get a "32-bit" VM -- all VMs are 64-bit, just like the host -- you just 
install a 32-bit O/S on the 64-bit machine.  A 32-bit OS installed on a 64-bit 
machine (VM or bare metal) behaves like it was installed on a i686 w/PAE.  At 
least that is the case of Linux.  I have no clue what MacOSX will do if you 
try to install a 32-bit incarnation on 64-bit hardware (unless it is a really 
old version of MacOSX).  I guess you could always install a 32-bit version of 
Linux (not really sure why -- even though RH dropped 32-bit *kernels* from 
CentOS 7, 32-bit applications can still be run on CentOS 7 -- I would guess 
the same would be true of Ubuntu if/when they stops being 32-bit kernels for 
Ubuntu). 

> 
> Regards,
> Adrien
> 
> > On Jan 25, 2018, at 11:11 PM, John Ralls  wrote:
> > 
> > On the off chance that anyone else is running a Mac with Developer Beta 
> > MacOS installed, the latest developer beta will put up the attached dialog 
> > when you launch Gnucash 2.6.x. What it means is that MacOS 10.14 (they’ll 
> > announce the name at WWDC in June) won’t support 32-bit applications.
> > 
> > GnuCash.app 2.7.x is 64-bit and won’t have a problem. That also means 
> > that it won’t work for the (one hopes very few) users who still have 
> > 32-bit Macs. It actually won’t support anything older than MacOS X 10.9 
> > (Mavericks) which will shut out a few of the early 64-bit Macs as well.
> > 
> > Regards,
> > John Ralls
> > 
> > ___
> > 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.
> 
>   

-- 
Robert Heller -- 978-544-6933
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services
  
___
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: Period End Accounts

[R. Victor Klassen]

Presumably those are PDF copies of the results of running the reports on prior 
years, which the OP now wants to do on the current year.

> On Jan 26, 2018, at 1:22 AM, Adrien Monteleone  
> wrote:
> 
> I have no idea what he means by having PDFs of his reports ‘saved’ in 
> GnuCash. The only thing I can save are report configurations. Not sure what’s 
> going on there…
> 
> Regards,
> Adrien
> 
>> On Jan 26, 2018, at 12:16 AM, David Carlson  
>> wrote:
>> 
>> 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 
>> mailto: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.>> 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
>>> .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 st

Re: Period End Accounts

[David Carlson]

And if he actually lost PDF documents, it was not something GnuCash did,
but something outside of GnuCash moved or deleted them.

David C

On Fri, Jan 26, 2018 at 7:23 AM, R. Victor Klassen 
wrote:

> Presumably those are PDF copies of the results of running the reports on
> prior years, which the OP now wants to do on the current year.
>
> > On Jan 26, 2018, at 1:22 AM, Adrien Monteleone <
> adrien.montele...@gmail.com> wrote:
> >
> > I have no idea what he means by having PDFs of his reports ‘saved’ in
> GnuCash. The only thing I can save are report configurations. Not sure
> what’s going on there…
> >
> > Regards,
> > Adrien
> >
> >> On Jan 26, 2018, at 12:16 AM, David Carlson <
> david.carlson@gmail.com> wrote:
> >>
> >> 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. it 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
> >>> .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 <
> https://www.gnuca

Re: Future allocated money vs Budgets

[Christopher Lam]

Hi Matt
I think there is merit in your idea.
I think some of the logic has already been baked into the Scheduled
Transactions (SX) facility.
So far, we know the transactions in the database are perfect for recording
*past* activity. Sometimes I'll also record transactions in the future e.g.
for upcoming tax payments. These appear under a blue line in the register,
and affects the Future Balance.

However *future* transactions are of the following types
(1) regular expected amounts eg monthly mortgage repayments, utility bills
(eg approx $200/qtr), annual land taxes (eg $1000/yr)
(2) regular budgeting (e.g. I can allocate 30% of my income towards income
tax, and every quarter will actually pay it)
(3) envelope budgeting (e.g. we can allocate $100 /month towards luxuries,
and any luxuries will need to be limited to $100/month, or $600/halfyear
holiday)
(4) long-term planning (e.g. in 15 years' time, my investment of $500/month
at approx 7%pa must reach $160,000)
(5) I must have a cash float of $5000 at hand for emergencies
(6) any other?

The SX is good at (1) and we can count future expenses with the Future
Scheduled Transactions Summary report, which aggregates all future SX
amounts in a time period.
(2) would be in my wishlist: set up formula "(CurrBalance of
Income:Paycheck * 0.3 - CurrBalance of Expense:IncomeTax)" is the expected
approximate tax liability.
(3) is also very popular and enforced by the likes of YNAB. No automated
mechanism within Gnucash. Can be done with the virtual accounts as
described.
 Another way is as follows - "Balance of Expenses:Luxuries must increase by
$100/month" please report its variance.
(4) is out of scope.
(5) is somewhat possible by enabling the "Future Minimum" column in the
main Account View, but doesn't take into account the SX amounts.

On 26 January 2018 at 11:29, Matt Graham 
wrote:

> Hi All!
> I’m going to discuss (and get people’s opinions) on a way in which many
> users (myself included) struggle to get “what they want” from GNUCash
> budgeting. GNUcash is very strict on proper double-entry bookkeeping
> practices (which I love). In accounting, “budgeting” means that you are
> plotting out exactly when you are going to change account values in what
> way. It is forecasting the future states of the accounts.
>
> So if you have a monthly bill of $50 you need to pay – easy. You enter it
> into the monthly periods - both expense account and asset account. You know
> you will spend that amount, and you (usually) know what asset account you
> are spending it out of. This is budgeting, and allows you to see that you
> are not losing money overall and sending yourself broke by end of year.
>
> The next thing that people call “budgeting” is when they want to save up
> for something, but don’t have a distinct plan of when it will be spent or
> how it will be paid for. My example is “Spending Money” (but perhaps
> “holiday savings” is a better example). I allocate $100 every month to
> myself and my wife to spend as we want (hobbies, clothes, etc). If we don’t
> spend it, it builds up allowing us to buy bigger stuff later. So I should
> put $100 in each budget period against those two expense accounts, right?
> NO, NO, NO From an accounting perspective, nothing is necessarily going
> to be spent out of my “Spending money” expense account. It is an allocation
> of money, not a spending of money. I can’t predict in advance any real
> changes to my asset or expense accounts from this monthly “allocation of
> money”. What I am doing from an accounting perspective is setting up a
> liability on myself – a promise to give money later to someone (in this
> case a promise to give money to myself). The reduction in my assets (cash)
> is as completely fake as the increase in liability – none of my cash or
> credit accounts have changed in value.
>
> For now I’m going to call this application “Future allocated money”, and
> controversially say that it is NOT “budgeting”.
>
> So if you have some ‘budget’ purpose such as this, and lament that GNUCash
> can’t give you the running total, the way to deal with it is the way this
> person describes:
> http://allmybrain.com/2008/12/15/better-budgeting-with-gnucash/
>
> The fake asset account is used to show the money that has been allocated
> for certain purposes in the future (ie is unavailable). It needs to be a
> fake account, because usually we don’t know in advanced which asset account
> we are going to spend the allocated money out of. If you know which asset
> account you are going to be spending the money out of, then sure you can
> just create a sub-account to record the amount allocated to this. In this
> case, you don’t really need to record the liability at all (the liability
> is effectively shown in your sub-account), and the transactions become
> easier – just transferring between that sub-account and the actual expense
> account when you spend. But for most people, you need a fake asset account
> because you don’t know

Re: info about action field in double-line view

[Jack Slater]

my reconciled transactions display a Y not an R???

On Sun, Jan 21, 2018 at 6:49 PM, Rich Shepard 
wrote:

> On Sun, 21 Jan 2018, Mark Hedges wrote:
>
> It also shows an "Action" field underneath the "Num" field. Where is this
>> described in the manual? What is the purpose of the Action field?
>>
>
> Mark,
>
>   Use this for the type of transaction; e.g., payment, refund, transfer. At
> least, that's what is entered in that cell in my business checking account.
> There might be value for searching for all payments, regardless of method
> or
> expense account and this cell will allow that.
>
> On that note what is the purpose of the Num field?  To enter check numbers?
>>
>
>   I use it for check numbers; both for those I write and for those the
> business receives from clients. If you want to assign numbers to cash
> dispersements or deposits, this is the place to do so.
>
> It also has R and A fields. "R" field is automatically filled with "n" for
>> each transaction. "A" field is blank. What are these for?
>>
>
>   'R' is for reconciled; not sure what the 'A' represents. When a
> transaction appears on a bank's statement click the 'n' (none) and it
> converts to 'c' (cleared). When you reconcile the account the signal is
> changed to 'r.'
>
> HTH,
>
> Rich
> ___
> 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: info about action field in double-line view

[Rich Shepard]

On Fri, 26 Jan 2018, Jack Slater wrote:


my reconciled transactions display a Y not an R???


Jack,

  Could be. I was working from memory.

Rich
___
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

[Jack Slater]

LOL - OK - got scared I was doing more wrong than right! Thanks.

On Fri, Jan 26, 2018 at 10:12 AM, Rich Shepard 
wrote:

> On Fri, 26 Jan 2018, Jack Slater wrote:
>
> my reconciled transactions display a Y not an R???
>>
>
> Jack,
>
>   Could be. I was working from memory.
>
> Rich
> ___
> 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

[Greg Feneis]

I think that's already being used, hence the link at the bottom of every
email I get.

Perhaps just needs an update?

Kind regards, Greg Feneis
(Galaxy S5)

On Jan 26, 2018 2:22 AM, "Adonay Felipe Nogueira" 
wrote:

> I have been a mailing list administrator for libreplanet-br for a year
> now, and I recall that there is a place to put general text in the
> mailing list description/listinfo page and in the footer of the email
> message. Perhaps they can make use of that to post a link saying "hey,
> if you use Nabble, the unsubscription must be done this way: ...".
>
> 2018-01-26T13:26:23+1100 Liz wrote:
> > There isn't a place on the default mailman pages to put that. I'm sure
> > Derek will say "patches welcome"
> >
> > :)
> >
> > Liz
>
> --
> - https://libreplanet.org/wiki/User:Adfeno
> - Palestrante e consultor sobre /software/ livre (não confundir com
>   gratis).
> - "WhatsApp"? Ele não é livre. Por favor, veja formas de se comunicar
>   instantaneamente comigo no endereço abaixo.
> - Contato: https://libreplanet.org/wiki/User:Adfeno#vCard
> - Arquivos comuns aceitos (apenas sem DRM): Corel Draw, Microsoft
>   Office, MP3, MP4, WMA, WMV.
> - Arquivos comuns aceitos e enviados: CSV, GNU Dia, GNU Emacs Org, GNU
>   GIMP, Inkscape SVG, JPG, LibreOffice (padrão ODF), OGG, OPUS, PDF
>   (apenas sem DRM), PNG, TXT, WEBM.
> ___
> 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: MacOS 32-bit support

[Adrien Monteleone]

Yes, with a performance hit, it is possible, at least with Virtualbox to 
install a 64-bit OS on a 32-bit host. Mileage varies based on the host and 
guest. I’ve pulled it off a few times. I don’t know however if you can run apps 
that require 64-bit in such a guest without issue.

As for the other way around, I’ve never had an issue, but then I also didn’t 
have the situation of the host not supporting 32-bit apps either. It’s worth a 
shot I suppose to see if older but still functional hardware can be extended on 
life support a bit longer.


Regards,
Adrien

> On Jan 26, 2018, at 6:46 AM, Robert Heller  wrote:
> 
> At Thu, 25 Jan 2018 23:52:00 -0600 Adrien Monteleone 
>  wrote:
> 
>> 
>> Thanks for the heads-up. (I still have a Snow Leopard Macbook, but don’t
>> use it for GnuCash any longer)
>> 
>> Any reason to think a 32-bit vm to run 2.6.x if needed on 10.14 or a 64-bit
>> vm to run 2.7/3.0 on older Macs wouldn’t handle those hopefully few cases?
>> (other than maybe a performance hit that is)
> 
> Is it possible to run a 64-bit VM on 32-bit hardware?  I suspect not.
> 
> Note: with Linux/KVM (don't know about other VM systems), you don't actually 
> get a "32-bit" VM -- all VMs are 64-bit, just like the host -- you just 
> install a 32-bit O/S on the 64-bit machine.  A 32-bit OS installed on a 
> 64-bit 
> machine (VM or bare metal) behaves like it was installed on a i686 w/PAE.  At 
> least that is the case of Linux.  I have no clue what MacOSX will do if you 
> try to install a 32-bit incarnation on 64-bit hardware (unless it is a really 
> old version of MacOSX).  I guess you could always install a 32-bit version of 
> Linux (not really sure why -- even though RH dropped 32-bit *kernels* from 
> CentOS 7, 32-bit applications can still be run on CentOS 7 -- I would guess 
> the same would be true of Ubuntu if/when they stops being 32-bit kernels for 
> Ubuntu). 
> 
>> 
>> Regards,
>> Adrien
>> 
>>> On Jan 25, 2018, at 11:11 PM, John Ralls  wrote:
>>> 
>>> On the off chance that anyone else is running a Mac with Developer Beta 
>>> MacOS installed, the latest developer beta will put up the attached dialog 
>>> when you launch Gnucash 2.6.x. What it means is that MacOS 10.14 (they’ll 
>>> announce the name at WWDC in June) won’t support 32-bit applications.
>>> 
>>> GnuCash.app 2.7.x is 64-bit and won’t have a problem. That also means that 
>>> it won’t work for the (one hopes very few) users who still have 32-bit 
>>> Macs. It actually won’t support anything older than MacOS X 10.9 
>>> (Mavericks) which will shut out a few of the early 64-bit Macs as well.
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>> ___
>>> 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.
>> 
>> 
> 
> -- 
> Robert Heller -- 978-544-6933
> Deepwoods Software-- Custom Software Services
> http://www.deepsoft.com/  -- Linux Administration Services
> hel...@deepsoft.com   -- Webhosting Services

___
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.

Securities price bug?

[Tj Junior]

I enter a stock purchase and accidentally use today's date, say buy 1 share
@ $100/share.  After I've entered the transaction, if I look at the stock
price history, it shows a new entry of type user:price of $100 for today's
date, all good.

Now say I realize that it was actually a historical transaction, so I go
back and change the transaction date from today to 2 years ago.  If I look
at the price database history again, it still shows the price entry of $100
with today's date (not the newly changed date of 2 years ago).  I didn't
see any existing bug reports on it but wanted to check before I entered a
new bug (or if someone else wants to enter it, by all means).
___
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]

David,

I never noticed that before. Thanks!

Regards,
Adrien

> On Jan 26, 2018, at 5:34 AM, David T.  wrote:
> 
> Adrien,
> 
> A small point: there is an option on the reconcile window to include 
> subaccounts, so that should not pose a problem.
> 
> David
> 
>> On Jan 26, 2018, at 12:38 PM, Adrien Monteleone 
>>  wrote:
>> 
>> 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 disc

Re: Future allocated money vs Budgets

[Adrien Monteleone]

If they are allocations from the parent then the parent should have the 
reversing entry already and it should wash.

The only issue would be if you transfer from say Checking to a sub of Savings.

Regards,
Adrien

> On Jan 26, 2018, at 5:47 AM, Maf. King  wrote:
> 
> On Friday, 26 January 2018 11:34:52 GMT David T. via gnucash-user wrote:
>> Adrien,
>> 
>> A small point: there is an option on the reconcile window to include
>> subaccounts, so that should not pose a problem.
>> 
>> David
>> 
> 
> David,
> 
> I too thought about that option, but also considered that the transactions to 
> allocate funds to the sub-accounts wouldn't show on the statement from the 
> bank.  So it will still take a bit of manual figuring out to reconcile such 
> an 
> account structure.
> 
> 0.02
> Maf.
> 
> 
> 
> -- 
> Maf. King
> PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542
> 
> 
> 

___
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: Securities price bug?

[John Ralls]

> On Jan 26, 2018, at 11:11 AM, Tj Junior  wrote:
> 
> I enter a stock purchase and accidentally use today's date, say buy 1 share
> @ $100/share.  After I've entered the transaction, if I look at the stock
> price history, it shows a new entry of type user:price of $100 for today's
> date, all good.
> 
> Now say I realize that it was actually a historical transaction, so I go
> back and change the transaction date from today to 2 years ago.  If I look
> at the price database history again, it still shows the price entry of $100
> with today's date (not the newly changed date of 2 years ago).  I didn't
> see any existing bug reports on it but wanted to check before I entered a
> new bug (or if someone else wants to enter it, by all means).

I don't find a relevant bug when I searched just now, so go ahead. While you're 
there you might want to click the Search link at the top of the Bugzilla page 
and play around with it a bit so you can search on your own the next time.

Regards,
John Ralls


___
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: MacOS 32-bit support

[GWB]

I have not yet tried this yet with GnuCash on the G4 and G5 PPC Macs
we still have, but it is possible to install FreeBSD 64 bit on the G5
Macs, which does have some virtualisation (weird, but impressive).
That would be a "corner case" scenario for what I'm guessing are a
very few GnuCash users.  And, of course, GnuCash is still ported for
Mac PPC (2.6.19, I think) so the question is will the PPC version only
support 64 bit from 2.7 on, or will it still run on G4 machines.

I think that it's great the devs still port GnuCash for PPC.  Lots of
apps quite that some time ago.

Gordon

On Fri, Jan 26, 2018 at 1:08 PM, Adrien Monteleone
 wrote:
> Yes, with a performance hit, it is possible, at least with Virtualbox to 
> install a 64-bit OS on a 32-bit host. Mileage varies based on the host and 
> guest. I’ve pulled it off a few times. I don’t know however if you can run 
> apps that require 64-bit in such a guest without issue.
>
> As for the other way around, I’ve never had an issue, but then I also didn’t 
> have the situation of the host not supporting 32-bit apps either. It’s worth 
> a shot I suppose to see if older but still functional hardware can be 
> extended on life support a bit longer.
>
>
> Regards,
> Adrien
>
>> On Jan 26, 2018, at 6:46 AM, Robert Heller  wrote:
>>
>> At Thu, 25 Jan 2018 23:52:00 -0600 Adrien Monteleone 
>>  wrote:
>>
>>>
>>> Thanks for the heads-up. (I still have a Snow Leopard Macbook, but don’t
>>> use it for GnuCash any longer)
>>>
>>> Any reason to think a 32-bit vm to run 2.6.x if needed on 10.14 or a 64-bit
>>> vm to run 2.7/3.0 on older Macs wouldn’t handle those hopefully few cases?
>>> (other than maybe a performance hit that is)
>>
>> Is it possible to run a 64-bit VM on 32-bit hardware?  I suspect not.
>>
>> Note: with Linux/KVM (don't know about other VM systems), you don't actually
>> get a "32-bit" VM -- all VMs are 64-bit, just like the host -- you just
>> install a 32-bit O/S on the 64-bit machine.  A 32-bit OS installed on a 
>> 64-bit
>> machine (VM or bare metal) behaves like it was installed on a i686 w/PAE.  At
>> least that is the case of Linux.  I have no clue what MacOSX will do if you
>> try to install a 32-bit incarnation on 64-bit hardware (unless it is a really
>> old version of MacOSX).  I guess you could always install a 32-bit version of
>> Linux (not really sure why -- even though RH dropped 32-bit *kernels* from
>> CentOS 7, 32-bit applications can still be run on CentOS 7 -- I would guess
>> the same would be true of Ubuntu if/when they stops being 32-bit kernels for
>> Ubuntu).
>>
>>>
>>> Regards,
>>> Adrien
>>>
 On Jan 25, 2018, at 11:11 PM, John Ralls  wrote:

 On the off chance that anyone else is running a Mac with Developer Beta 
 MacOS installed, the latest developer beta will put up the attached dialog 
 when you launch Gnucash 2.6.x. What it means is that MacOS 10.14 (they’ll 
 announce the name at WWDC in June) won’t support 32-bit applications.

 GnuCash.app 2.7.x is 64-bit and won’t have a problem. That also means that 
 it won’t work for the (one hopes very few) users who still have 32-bit 
 Macs. It actually won’t support anything older than MacOS X 10.9 
 (Mavericks) which will shut out a few of the early 64-bit Macs as well.

 Regards,
 John Ralls

 ___
 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.
>>>
>>>
>>
>> --
>> Robert Heller -- 978-544-6933
>> Deepwoods Software-- Custom Software Services
>> http://www.deepsoft.com/  -- Linux Administration Services
>> hel...@deepsoft.com   -- Webhosting Services
>
> ___
> 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: MacOS 32-bit support

[Robert Heller]

At Fri, 26 Jan 2018 13:08:06 -0600 Adrien Monteleone 
 wrote:

> 

> Yes, with a performance hit, it is possible, at least with Virtualbox to
> install a 64-bit OS on a 32-bit host. Mileage varies based on the host and
> guest. I’ve pulled it off a few times. I don’t know however if you can
> run apps that require 64-bit in such a guest without issue.

I guess to run 64-bit guests on 32-bit hosts, the virtualization software is
actually *emulating* a 64-bit processor (I guess Virtualbox does that). I
think Linux/KVM does not do that. Actually, I belive 32-bit RHEL/CentOS 6 does
not include KVM and has no virtualization support.

All x86_64 processors can run in i686 mode and can run 32-bit applications, 
but you need the 32-bit shared libraries.  My guess in the case of the newest 
MacOSX, Apple is not  bothering to ship the 32-bit libraries or is not 
shipping "universal" (32-bit/64-bit) libraries, however they handle that.  
Typlically with *Linux* almost every shared library is available as a 64-bit 
and a 32-bit library (RHEL/CentOS uses /usr/lib for 32-bit and /usr/lib64 for 
64-bit, Debian does something different, I think there are 
/usr/lib/i386-linux-gnu/ and /usr/lib/x86_64-linux-gnu/ directories.

> 
> As for the other way around, I’ve never had an issue, but then I also 
> didn’t have the situation of the host not supporting 32-bit apps either. 
> It’s worth a shot I suppose to see if older but still functional hardware 
> can be extended on life support a bit longer.
> 
> 
> Regards,
> Adrien
> 
> > On Jan 26, 2018, at 6:46 AM, Robert Heller  wrote:
> > 
> > At Thu, 25 Jan 2018 23:52:00 -0600 Adrien Monteleone 
> >  wrote:
> > 
> >> 
> >> Thanks for the heads-up. (I still have a Snow Leopard Macbook, but don’t
> >> use it for GnuCash any longer)
> >> 
> >> Any reason to think a 32-bit vm to run 2.6.x if needed on 10.14 or a 64-bit
> >> vm to run 2.7/3.0 on older Macs wouldn’t handle those hopefully few 
> >> cases?
> >> (other than maybe a performance hit that is)
> > 
> > Is it possible to run a 64-bit VM on 32-bit hardware?  I suspect not.
> > 
> > Note: with Linux/KVM (don't know about other VM systems), you don't 
> > actually 
> > get a "32-bit" VM -- all VMs are 64-bit, just like the host -- you just 
> > install a 32-bit O/S on the 64-bit machine.  A 32-bit OS installed on a 
> > 64-bit 
> > machine (VM or bare metal) behaves like it was installed on a i686 w/PAE.  
> > At 
> > least that is the case of Linux.  I have no clue what MacOSX will do if you 
> > try to install a 32-bit incarnation on 64-bit hardware (unless it is a 
> > really 
> > old version of MacOSX).  I guess you could always install a 32-bit version 
> > of 
> > Linux (not really sure why -- even though RH dropped 32-bit *kernels* from 
> > CentOS 7, 32-bit applications can still be run on CentOS 7 -- I would guess 
> > the same would be true of Ubuntu if/when they stops being 32-bit kernels 
> > for 
> > Ubuntu). 
> > 
> >> 
> >> Regards,
> >> Adrien
> >> 
> >>> On Jan 25, 2018, at 11:11 PM, John Ralls  wrote:
> >>> 
> >>> On the off chance that anyone else is running a Mac with Developer Beta 
> >>> MacOS installed, the latest developer beta will put up the attached 
> >>> dialog when you launch Gnucash 2.6.x. What it means is that MacOS 10.14 
> >>> (they’ll announce the name at WWDC in June) won’t support 32-bit 
> >>> applications.
> >>> 
> >>> GnuCash.app 2.7.x is 64-bit and won’t have a problem. That also means 
> >>> that it won’t work for the (one hopes very few) users who still have 
> >>> 32-bit Macs. It actually won’t support anything older than MacOS X 10.9 
> >>> (Mavericks) which will shut out a few of the early 64-bit Macs as well.
> >>> 
> >>> Regards,
> >>> John Ralls
> >>> 
> >>> ___
> >>> 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.
> >> 
> >> 
> > 
> > -- 
> > Robert Heller -- 978-544-6933
> > Deepwoods Software-- Custom Software Services
> > http://www.deepsoft.com/  -- Linux Administration Services
> > hel...@deepsoft.com   -- Webhosting Services
> 
> ___
> 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]

I suppose you’re referring to this:

> ___
> 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.

I would think altering this to say:

> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 
> To do the same if you’re using Nabble:
> (insert link here)
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


would do the trick.

Regards,
Adrien

> On Jan 26, 2018, at 11:57 AM, Greg Feneis  wrote:
> 
> I think that's already being used, hence the link at the bottom of every
> email I get.
> 
> Perhaps just needs an update?
> 
> Kind regards, Greg Feneis
> (Galaxy S5)
> 
> On Jan 26, 2018 2:22 AM, "Adonay Felipe Nogueira" 
> wrote:
> 
>> I have been a mailing list administrator for libreplanet-br for a year
>> now, and I recall that there is a place to put general text in the
>> mailing list description/listinfo page and in the footer of the email
>> message. Perhaps they can make use of that to post a link saying "hey,
>> if you use Nabble, the unsubscription must be done this way: ...".
>> 
>> 2018-01-26T13:26:23+1100 Liz wrote:
>>> There isn't a place on the default mailman pages to put that. I'm sure
>>> Derek will say "patches welcome"
>>> 
>>> :)
>>> 
>>> Liz
>> 
>> --
>> - https://libreplanet.org/wiki/User:Adfeno
>> - Palestrante e consultor sobre /software/ livre (não confundir com
>>  gratis).
>> - "WhatsApp"? Ele não é livre. Por favor, veja formas de se comunicar
>>  instantaneamente comigo no endereço abaixo.
>> - Contato: https://libreplanet.org/wiki/User:Adfeno#vCard
>> - Arquivos comuns aceitos (apenas sem DRM): Corel Draw, Microsoft
>>  Office, MP3, MP4, WMA, WMV.
>> - Arquivos comuns aceitos e enviados: CSV, GNU Dia, GNU Emacs Org, GNU
>>  GIMP, Inkscape SVG, JPG, LibreOffice (padrão ODF), OGG, OPUS, PDF
>>  (apenas sem DRM), PNG, TXT, WEBM.
>> ___
>> 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.

___
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.

Subaccounts [WAS Re: Future allocated money vs Budgets]

[Tommy Trussell]

I was following the budget discussion, and I decided to split my comment
into a different thread. I'm not responding to any particular comment, and
this isn't quite germane to budgeting.

But I want to clear up a few misunderstandings I'm seeing folks express
about reconciling with sub-accounts. Subaccounts work very well, but they
do take a little maintenance.

WHEN TO USE SUBACCOUNTS

You can use subaccounts for several purposes, including budgeting, holding
onto money that isn't "yours" (a bond you're holding from a contractor for
successful completion of a project, for instance), identifying earmarked
funds, OR (as in the example below) simply stopping yourself from spending
down the account more than you'd like.

(If folks have additional suggested uses for subaccounts, bring em on!)

EXAMPLE: MINIMUM BALANCE VIEW

Here's a real-world (well it's real in MY world) example -- avoiding
"minimum balance" fees. The bank name has been changed to protect the
bookkeeper. ;-)

I have a checking account at BigBank.

Assets:Current Assets:BigBank Checking

The terms on that bank account say it doesn't cost me anything UNLESS the
balance drops below $2500, at which point I have to pay $8.50/month. (There
are some other miscellaneous fees, all higher when the balance goes low.)

SO to help avoid the $8.50/month expense, I created a sub account:

Assets:Current Assets:BigBank Checking:Minimum Balance

Then I created a transaction dated 2/15/2015, transferring $2500 from the
account to its subaccount:

(This is a representation of the BigBank Checking two-line auto-split
register. Items in the right column are "cr" and items in the left column
are "dr".)

  2/15/2015 min Minimum Balance   2500.00cr
Assets:Current Assets:BigBank Checking:Minimum Balance   $2500.00dr
Assets:Current Assets:BigBank Checking   $2500.00cr

When I reconciled my account the first time after creating this
transaction, I made sure to tick the "Include Subaccounts" checkbox on the
Reconcile Information dialog. I (as always) verified the ENDING balance
information exactly as it was shown on the bank's statement.

Also that first time I reconciled, I noticed TWO items to clear that
weren't actually on the bank statement -- $2500 in the funds in side and
$2500 in the funds out side of the reconcile window. I marked them BOTH as
"cleared."

>From now on, I notice a few things have changed from before --

o - My default balance when I reconcile AND the running balance in the
BigBank Checking register will always show $2500 lower than I actually
have.

o - When I reconcile I always have to remember to override the default and
enter the ENDING balance as it is shown on BigBank's statement.

o - When I reconcile the "Include Subaccounts" checkbox is ticked and it
needs to stay ticked. (It seems to "remember" the setting from session to
session, as you would hope.)

o - I also notice when I'm reconciling that when I "jump" to a transaction
by double-clicking on an item in the funds in / funds out lists, the
transaction opens into a different kind of "general ledger" style register
that includes ALL transactions in the account and subaccounts. It exactly
resembles the kind of register that appears when you search for
transactions. It has a "plus" (+) mark in its tab and looks different from
the "ordinary" register.


Obviously at any time I can "overspend" and the primary account balance
will go negative, with either dire or negligible real-world repercussions.
But if I ignore the red (negative) balance numbers and keep the balances in
the red, I've eliminated the reason for having the subaccount in the first
place.

I can raise or lower the minumum balance at any time by creating another
transaction between the account and subaccount.


-
> 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: MacOS 32-bit support

[John Ralls]

I won't be bundling Gnucash for PPC after 2.6.20, for lack of a suitable--i.e. 
C++11 capable--compiler. Linux runs well on PPC machines and GnuCash passes 
Debian's tests on their PPC buildbot, so that's the way to go if you're still 
running an old PPC mac.

Regards,
John Ralls


> On Jan 26, 2018, at 12:41 PM, GWB  wrote:
> 
> I have not yet tried this yet with GnuCash on the G4 and G5 PPC Macs
> we still have, but it is possible to install FreeBSD 64 bit on the G5
> Macs, which does have some virtualisation (weird, but impressive).
> That would be a "corner case" scenario for what I'm guessing are a
> very few GnuCash users.  And, of course, GnuCash is still ported for
> Mac PPC (2.6.19, I think) so the question is will the PPC version only
> support 64 bit from 2.7 on, or will it still run on G4 machines.
> 
> I think that it's great the devs still port GnuCash for PPC.  Lots of
> apps quite that some time ago.
> 
> Gordon
> 
> On Fri, Jan 26, 2018 at 1:08 PM, Adrien Monteleone
>  wrote:
>> Yes, with a performance hit, it is possible, at least with Virtualbox to 
>> install a 64-bit OS on a 32-bit host. Mileage varies based on the host and 
>> guest. I’ve pulled it off a few times. I don’t know however if you can run 
>> apps that require 64-bit in such a guest without issue.
>> 
>> As for the other way around, I’ve never had an issue, but then I also didn’t 
>> have the situation of the host not supporting 32-bit apps either. It’s worth 
>> a shot I suppose to see if older but still functional hardware can be 
>> extended on life support a bit longer.
>> 
>> 
>> Regards,
>> Adrien
>> 
>>> On Jan 26, 2018, at 6:46 AM, Robert Heller  wrote:
>>> 
>>> At Thu, 25 Jan 2018 23:52:00 -0600 Adrien Monteleone 
>>>  wrote:
>>> 
 
 Thanks for the heads-up. (I still have a Snow Leopard Macbook, but don’t
 use it for GnuCash any longer)
 
 Any reason to think a 32-bit vm to run 2.6.x if needed on 10.14 or a 64-bit
 vm to run 2.7/3.0 on older Macs wouldn’t handle those hopefully few cases?
 (other than maybe a performance hit that is)
>>> 
>>> Is it possible to run a 64-bit VM on 32-bit hardware?  I suspect not.
>>> 
>>> Note: with Linux/KVM (don't know about other VM systems), you don't actually
>>> get a "32-bit" VM -- all VMs are 64-bit, just like the host -- you just
>>> install a 32-bit O/S on the 64-bit machine.  A 32-bit OS installed on a 
>>> 64-bit
>>> machine (VM or bare metal) behaves like it was installed on a i686 w/PAE.  
>>> At
>>> least that is the case of Linux.  I have no clue what MacOSX will do if you
>>> try to install a 32-bit incarnation on 64-bit hardware (unless it is a 
>>> really
>>> old version of MacOSX).  I guess you could always install a 32-bit version 
>>> of
>>> Linux (not really sure why -- even though RH dropped 32-bit *kernels* from
>>> CentOS 7, 32-bit applications can still be run on CentOS 7 -- I would guess
>>> the same would be true of Ubuntu if/when they stops being 32-bit kernels for
>>> Ubuntu).
>>> 
 
 Regards,
 Adrien
 
> On Jan 25, 2018, at 11:11 PM, John Ralls  wrote:
> 
> On the off chance that anyone else is running a Mac with Developer Beta 
> MacOS installed, the latest developer beta will put up the attached 
> dialog when you launch Gnucash 2.6.x. What it means is that MacOS 10.14 
> (they’ll announce the name at WWDC in June) won’t support 32-bit 
> applications.
> 
> GnuCash.app 2.7.x is 64-bit and won’t have a problem. That also means 
> that it won’t work for the (one hopes very few) users who still have 
> 32-bit Macs. It actually won’t support anything older than MacOS X 10.9 
> (Mavericks) which will shut out a few of the early 64-bit Macs as well.
> 
> Regards,
> John Ralls
> 
> ___
> 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.
 
 
>>> 
>>> --
>>> Robert Heller -- 978-544-6933
>>> Deepwoods Software-- Custom Software Services
>>> http://www.deepsoft.com/  -- Linux Administration Services
>>> hel...@deepsoft.com   -- Webhosting Services
>> 
>> ___
>> 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.
> __

Unable to retrieve stock prices

[Pawel Wocjan]

Hello,

I have installed GnuCash 2.6.19 on Windows 10. I have also installed the 
finance quote package.

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check
("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" 
"australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero" 
"canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" "dwsfunds" 
"europe" "fetch_live_currencies" "fidelity" "fidelity_direct" "fidelityfixed" 
"financecanada" "finanzpartner" "finland" "fool" "france" "ftfunds" 
"ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" "greece" "hex" 
"hu" "hufund" "hungary" "hustock" "indiamutual" "known_currencies" "lerevenu" 
"maninv" "morningstar" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx" 
"platinum" "romania" "seb_funds" "sixfunds" "sixshares" "stockhousecanada_fund" 
"tdefunds" "tdwaterhouse" "tiaacref" "tnetuk" "troweprice" "troweprice_direct" 
"trustnet" "tsp" "tsx" "uk_unit_trusts" "ukfunds" "unionfunds" "usa" 
"usfedbonds" "vanguard" "vwd" "yahoo" "yahoo_asia" "yahoo_australia" 
"yahoo_brasil" "yahoo_europe" "yahoo_json" "yahoo_nz" "yahoo_yql" "za" 
"za_unittrusts")

Unfortunately, I am not able to retrieve the price for AMZN. I either get 
"There was an unknown error while retrieving the price quotes." or "Unable to 
retrieve quotes for these items: NASDAQ:AMZN".

Could you help troubleshoot these problems?
___
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: Unable to retrieve stock prices

[David Carlson]

Check here:
https://wiki.gnucash.org/wiki/FAQ

David C

On Fri, Jan 26, 2018 at 10:13 PM, Pawel Wocjan  wrote:

> Hello,
>
> I have installed GnuCash 2.6.19 on Windows 10. I have also installed the
> finance quote package.
>
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check
> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia"
> "asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse"
> "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch"
> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct"
> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france"
> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney"
> "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual"
> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp"
> "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds"
> "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse"
> "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx"
> "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd"
> "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe"
> "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts")
>
> Unfortunately, I am not able to retrieve the price for AMZN. I either get
> "There was an unknown error while retrieving the price quotes." or "Unable
> to retrieve quotes for these items: NASDAQ:AMZN".
>
> Could you help troubleshoot these problems?
> ___
> 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.

Question from new subscriber

[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: Question from new subscriber

[Adrien Monteleone]

Bill,

I replied yesterday evening, but I see somehow that got threaded into a 
different discussion, at least on my end. However, there is no need to repost a 
question. If you don’t get an answer right away, be patient.

Here’s what I sent:

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)

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 26, 2018, at 7:01 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 d

File Format : XML v MySQL / postgres / sqllite

[Mike Stillingfleet]

Dear All,

XML is the default when creating a new file.

I have seen various quite dated questions about the decision process of 
selecting which db to use.

I think that the main advantage of using MySQL would be the ability to generate 
custom reports.

Are there any other advantages and are there any differences in the interface 
between the various db's. Does the forum still recommend XML.

Regards

-- 
  Mike Stillingfleet
  mikestillingfl...@fastmail.co.uk
___
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: File Format : XML v MySQL / postgres / sqllite

[Adrien Monteleone]

I switched from XML to SQLite about a year ago. I perceive a performance 
improvement on loading, but that’s about it. (and I generally never shut the 
app down anyway)

I haven’t attempted any custom reporting yet, but I plan to.

I could be mistaken, but I think PyCash is designed to parse the XML file so 
you can still get the reporting you want.

Regards,
Adrien

> On Jan 27, 2018, at 12:55 AM, Mike Stillingfleet 
>  wrote:
> 
> Dear All,
> 
> XML is the default when creating a new file.
> 
> I have seen various quite dated questions about the decision process of 
> selecting which db to use.
> 
> I think that the main advantage of using MySQL would be the ability to 
> generate custom reports.
> 
> Are there any other advantages and are there any differences in the interface 
> between the various db's. Does the forum still recommend XML.
> 
> Regards
> 
> -- 
>  Mike Stillingfleet
>  mikestillingfl...@fastmail.co.uk
> ___
> 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: Subaccounts [WAS Re: Future allocated money vs Budgets]

[Adrien Monteleone]

That’s an interesting use of future dated transactions. Thanks!


Regards,
Adrien

> On Jan 26, 2018, at 5:21 PM, Tommy Trussell  wrote:
> 
> I was following the budget discussion, and I decided to split my comment
> into a different thread. I'm not responding to any particular comment, and
> this isn't quite germane to budgeting.
> 
> But I want to clear up a few misunderstandings I'm seeing folks express
> about reconciling with sub-accounts. Subaccounts work very well, but they
> do take a little maintenance.
> 
> WHEN TO USE SUBACCOUNTS
> 
> You can use subaccounts for several purposes, including budgeting, holding
> onto money that isn't "yours" (a bond you're holding from a contractor for
> successful completion of a project, for instance), identifying earmarked
> funds, OR (as in the example below) simply stopping yourself from spending
> down the account more than you'd like.
> 
> (If folks have additional suggested uses for subaccounts, bring em on!)
> 
> EXAMPLE: MINIMUM BALANCE VIEW
> 
> Here's a real-world (well it's real in MY world) example -- avoiding
> "minimum balance" fees. The bank name has been changed to protect the
> bookkeeper. ;-)
> 
> I have a checking account at BigBank.
> 
> Assets:Current Assets:BigBank Checking
> 
> The terms on that bank account say it doesn't cost me anything UNLESS the
> balance drops below $2500, at which point I have to pay $8.50/month. (There
> are some other miscellaneous fees, all higher when the balance goes low.)
> 
> SO to help avoid the $8.50/month expense, I created a sub account:
> 
> Assets:Current Assets:BigBank Checking:Minimum Balance
> 
> Then I created a transaction dated 2/15/2015, transferring $2500 from the
> account to its subaccount:
> 
> (This is a representation of the BigBank Checking two-line auto-split
> register. Items in the right column are "cr" and items in the left column
> are "dr".)
> 
>  2/15/2015 min Minimum Balance   2500.00cr
>Assets:Current Assets:BigBank Checking:Minimum Balance   $2500.00dr
>Assets:Current Assets:BigBank Checking   $2500.00cr
> 
> When I reconciled my account the first time after creating this
> transaction, I made sure to tick the "Include Subaccounts" checkbox on the
> Reconcile Information dialog. I (as always) verified the ENDING balance
> information exactly as it was shown on the bank's statement.
> 
> Also that first time I reconciled, I noticed TWO items to clear that
> weren't actually on the bank statement -- $2500 in the funds in side and
> $2500 in the funds out side of the reconcile window. I marked them BOTH as
> "cleared."
> 
> From now on, I notice a few things have changed from before --
> 
> o - My default balance when I reconcile AND the running balance in the
> BigBank Checking register will always show $2500 lower than I actually
> have.
> 
> o - When I reconcile I always have to remember to override the default and
> enter the ENDING balance as it is shown on BigBank's statement.
> 
> o - When I reconcile the "Include Subaccounts" checkbox is ticked and it
> needs to stay ticked. (It seems to "remember" the setting from session to
> session, as you would hope.)
> 
> o - I also notice when I'm reconciling that when I "jump" to a transaction
> by double-clicking on an item in the funds in / funds out lists, the
> transaction opens into a different kind of "general ledger" style register
> that includes ALL transactions in the account and subaccounts. It exactly
> resembles the kind of register that appears when you search for
> transactions. It has a "plus" (+) mark in its tab and looks different from
> the "ordinary" register.
> 
> 
> Obviously at any time I can "overspend" and the primary account balance
> will go negative, with either dire or negligible real-world repercussions.
> But if I ignore the red (negative) balance numbers and keep the balances in
> the red, I've eliminated the reason for having the subaccount in the first
> place.
> 
> I can raise or lower the minumum balance at any time by creating another
> transaction between the account and subaccount.
> 
> 
> -
>> 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.