Re: [GNC] Forward payments

2018-06-28 Thread Tony Vanson
My thanks to all respondents. It is finally making sense to my befuddled
brain.
However I have one more spanner in the works. I had already transferred
funds from my Current Assets:Bank account to Expenses:Staff.
My Bank account has been reconciled.
What, if any, process is available to transfer the forward payment funds
from Expenses:Staff to the newly created Current Assets:Forward Payment
Credit account without messing things up, or would I need to delete the
original transfer and re-enter it to reflect the new process?
Thanks again for all your patience.
Cheers


On Fri, Jun 29, 2018 at 12:13 AM, Stephen M. Butler  wrote:

> On 06/28/2018 12:25 AM, Tony Vanson wrote:
> > Thank you for your quick response. My Staff account is set up as an
> Expense
> > not as an Asset. In this particular case would I need to set up a new
> > account Current Assets:Staff - as a child account under Current Assets?
> > Cheers
>
> I would set it up as an asset.  Even if you physically handed them the
> cash and they physically put it into their wallet for future
> disbursement as needed, it is still your asset.  If anything is left
> over when you return it would come back to you for put back into the bank.
>
> I presume you will get periodic statements about how that asset is being
> disbursed so you can make the appropriate entries to transfer funds to
> the appropriate expense accounts (just like you do now, except the asset
> side is not the bank but the "staff accountant").
>
> That way you could notice if the funds were running short and do online
> banking to send more funds to that person.
> > On Thu, Jun 28, 2018 at 2:08 PM, Maf. King  wrote:
> >
> >> On Thursday, 28 June 2018 07:53:02 BST Tony Vanson wrote:
> >>> Hi all,
> >>> Hopefully someone can advise me how to treat the following problem
> which
> >>> stumps me.
> >>> I am using GNUcash 2.6.18 on Windows 10.
> >>> I shall be away for several months and have transferred credit from my
> >>> Savings account to my Staff account with a lump sum amount for her to
> pay
> >>> her Salary, Electricity, Pool chemicals, Internet access etc, on the
> due
> >>> date. All these are set up as expense accounts.
> >>> All accounts, apart from her Salary and Internet access, are variable
> in
> >>> amount and payment date.
> >>> I assume that I have to split the lump sum to the various accounts as
> >> they
> >>> are paid or is there some other method?
> >>> I also need to take into account that the payment I've made to the
> Staff
> >>> account may be too small or too large.
> >>> Any enlightenment to a personally perplexing problem would be greatly
> >>> appreciated.
> >>> P.S. I only use GNUcash for my personal information and does not have
> any
> >>> taxation or other legal requirement.
> >>> Cheers
> >> Hi Tony.
> >>
> >> Do you have accounts in GC that represent your Savings account & Staff
> >> accounts?
> >>
> >> To me it seems that you should let GC reflect reality - you've got a
> >> transaction from Assets:Savings to Assets:StaffAccount.  as the payments
> >> are
> >> made, you have transactions between Assets:StaffAccount & expense
> accounts
> >> as
> >> appropriate. (presumably, you could be emailed details of payments made
> to
> >> keep your GC up to date?)
> >>
> >> If, on your return, you have balance left in Assets:StaffAccount, just
> >> record
> >> a transaction putting it back into savings.
> >>
> >> HTH,
> >> Maf.
> >>
> >>
> >>
> >>
> >>
> >
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>



-- 
*Tony Vanson*

*The older I get,*
*the better I was*
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Fwd: The two modules

2018-06-28 Thread Dale Alspach
I work with an organization that uses QuikBooks. There seems to be a
built in mechanism in the report generator in that software that
automatically adds a line with name [parent account name] Other which
contains the total of the transactions in the parent account not in any
subaccount of the parent. Thus the report shows the parent total as the
sum of the amounts from the real subaccounts and this extra line.

I am not an accountant but the books are audited annually and no one has
raised any questions about this. Perhaps this is an alternative approach
that would satisfy the accountants and not force other users to formally
add an extra subaccount as a dumping place for miscellaneous
transactions that logically belong to the parent but not to any current
subaccount.

Dale

On 06/28/2018 03:48 PM, D via gnucash-user wrote:
> 
> 
> On June 28, 2018, at 1:12 PM, Geert Janssens  
> wrote:
> 
>> Op donderdag 28 juni 2018 18:47:18 CEST schreef Stephen M. Butler:
> [Snip]
>>> Maybe the financial folks can band together to get the developers to
>>> enforce no-transactions to a parent account.
>> I think we should modify the concepts. "Placeholder" is ambiguous and for 
>> the 
>> lack of a better solution is has been abused to make existing accounts read-
>> only.I
> 
> I am under the impression that the placeholder setting is only meant to make 
> an account read-only, so saying that users have "abused" this seems 
> incorrect. We've used the tool we've been given.
> 
>> Perhaps it's time to introduce a "View" type account which is only used to 
>> structure the account tree (and as aggregate account in reports) and next to 
>> that introduce a read-only attribute to normal accounts. Placeholder could 
>> then be phased out in favor of these two. We could even try to automate this 
>> using some heuristics:
>> - if a placeholder account has no transactions, convert it into a view 
>> account
>> - if a placeholder account does have transactions, make it read-only instead.
>> Add in an informational message to the user about what was done so the user 
>> can make corrections if needed (like adding view accounts if an account was 
>> being used for both functions).
>> Geert
> 
> You might even call a View account "Closed," or are there other reasons an 
> account might behave this way?
> 
> I'd also add that eliminating these accounts from drop down controls should 
> go along with the changes, but assume that would be implied from the fact 
> that Placeholder accounts don't appear there currently.I
> 
> David
> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> 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
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] GNUCash locks up when opening a Budget

2018-06-28 Thread Jack Lockard
I am having issues with editing my budget. I am running version 2.6.19 of 
GNUCash. I store the files on a NAS devices so I can access them from both of 
my two computers. One is a Microsoft Surface Pro 3 and the other is an HP 8530P 
laptop.

I can open the data files on both computers but can only successfully open and 
edit the budget on the HP 8530P. If I try to open the budget on the Surface 
Pro, it locks up. I have uninstalled the software, removed the .gnucash under 
AppData folder and removed registry entries that the uninstall process did not 
clean up and then reinstalled to no avail. There must be something somewhere 
else on the Surface Pro that needs to be removed but I have no idea where it 
may be.

Can anyone point me to where all of the install locations may be? There must be 
something on the Surface Pro that causes GNUCash to lock up.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] [GNC-dev] ANNOUNCE: Bugzilla is moving

2018-06-28 Thread Derek Atkins
We should add that these preferences will not get copied over, so after the 
move you will continue to receive email from the new bz instance.


-derek
Sent using my mobile device. Please excuse any typos.
On June 28, 2018 7:04:26 PM John Ralls  wrote:

I should have mentioned that this will result in a ton of bug-change emails 
going out. If you want to avoid getting those emails (and lighten the load 
a bit on Gnome's server), please visit https://bugzilla.gnome.org, log in, 
click "Preferences" at the top of the page, select the email tag, and 
uncheck all boxes on the following two lines:

* "The priority, status, severity, or milestone changes"
* "New comments are added"

You'll also want to remove any gnucash-related date addresses.

Regards,
John Ralls



On Jun 28, 2018, at 1:36 PM, John Ralls  wrote:

As anyone who's used Bugzilla in the last few months already knows, Gnome 
has moved their git repositories to a Gitlab instance at gitlab.gnome.org 
and migrated bug tracking for Gnome projects there as well. They've left 
Bugzilla alone for non-Gnome projects like GnuCash but they're closing it 
to new bugs on Sunday, 1 July.


Most users and contributors know that to get ready we've set up a new 
Bugzilla instance at https://bugs.gnucash.org and copied all of the bugs 
and their history and all user accounts. We'll do a final fetch from 
bugzilla.gnome.org at 2018-06-29 22:00:00 UTC (That's tomorrow at 8PM 
UTC/10PM European Daylight Time/4PM US Eastern Daylight Time). We expect to 
be able to "turn on" https://bugs.gnucash.org within a couple of hours.


The process will be:
* Close bug creation on bugzilla.gnome.org. Unfortunately we can't prevent 
updating already-created bugs, but any changes to bugs on 
bugzilla.gnome.org after this will probably be lost.

* Fetch the latest bug status from bugzilla.gnome.org
* Close all open bugs on bugzilla.gnome.org as "RESOLVED OBSOLETE" with a 
comment pointing to https://bugs.gnucash.org for further discussion. We're 
using RESOLVED OBSOLETE to be consistent with the Gnome project bugs.

* Import the changes to bugs.gnucash.org
* Re-enable updates in the bugzilla code; that's disabled now because 
imports don't work if it's enabled.


User accounts are preserved, but passwords are obviously not preserved. 
Existing bugzilla.gnome.org users should use the "forgot my password" link 
on https://bugs.gnucash.org to get a password reset and to enable their 
accounts after the migration is complete.


Bug CC lists *are* preserved so you will get email notifications for 
changes to bugs that you've commented on or otherwise added yourself to the 
CC list. "Watching" links are *not* preserved so if you were watching 
another user or one of the category users you'll need to reset that in 
Email Preferences (click the Preferences link at the top of the page after 
you log in).


The category users are:
* gnucash-core-ma...@gnucash.bugs GnuCash/Backend-SQL, 
Backend-XML, Budgets, Build system, Business, Currency and Commodity, Engine
* gnucash-documentation-ma...@gnucash.bugsDocumentation, Website, 
GnuCash/Translations

* gnucash-general-ma...@gnucash.bugs  GnuCash/General
* gnucash-import-ma...@gnucash.bugs   GnuCash/Import - *, TXF Export
* gnucash-mac-ma...@gnucash.bugs  Packaging/MacOS, GnuCash/MacOS
* gnucash-reports-ma...@gnucash.bugs  GnuCash/Check Printing, Reports
* gnucash-ui-ma...@gnucash.bugs   GnuCash/Regist2, Register, 
User Interface General
* gnucash-win-ma...@gnucash.bugs  Packaging/Windows, GnuCash 
Windows

* gnucash-all-ma...@gnucash.bugs  All bugs

Since we have the whole bug tracker to ourselves we've created some new 
products and moved some bugs into them:

* GnuCash continues to collect reports on the application itself.
* Documentation   collects documentation reports
* Packaging   collects reports about the all-in-one Windows and MacOS 
packages that are not about GnuCash application code.

* Website collects reports about www.gnucash.org.

More information on https://wiki.gnucash.org/wiki/Bugzilla.

Regards,
John Ralls


___
gnucash-announce mailing list
gnucash-annou...@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-announce


___
gnucash-devel mailing list
gnucash-de...@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] ANNOUNCE: Bugzilla is moving

2018-06-28 Thread John Ralls
I should have mentioned that this will result in a ton of bug-change emails 
going out. If you want to avoid getting those emails (and lighten the load a 
bit on Gnome's server), please visit https://bugzilla.gnome.org, log in, click 
"Preferences" at the top of the page, select the email tag, and uncheck all 
boxes on the following two lines:
* "The priority, status, severity, or milestone changes"
* "New comments are added"

You'll also want to remove any gnucash-related date addresses.

Regards,
John Ralls


> On Jun 28, 2018, at 1:36 PM, John Ralls  wrote:
> 
> As anyone who's used Bugzilla in the last few months already knows, Gnome has 
> moved their git repositories to a Gitlab instance at gitlab.gnome.org and 
> migrated bug tracking for Gnome projects there as well. They've left Bugzilla 
> alone for non-Gnome projects like GnuCash but they're closing it to new bugs 
> on Sunday, 1 July.
> 
> Most users and contributors know that to get ready we've set up a new 
> Bugzilla instance at https://bugs.gnucash.org and copied all of the bugs and 
> their history and all user accounts. We'll do a final fetch from 
> bugzilla.gnome.org at 2018-06-29 22:00:00 UTC (That's tomorrow at 8PM 
> UTC/10PM European Daylight Time/4PM US Eastern Daylight Time). We expect to 
> be able to "turn on" https://bugs.gnucash.org within a couple of hours. 
> 
> The process will be:
> * Close bug creation on bugzilla.gnome.org. Unfortunately we can't prevent 
> updating already-created bugs, but any changes to bugs on bugzilla.gnome.org 
> after this will probably be lost.
> * Fetch the latest bug status from bugzilla.gnome.org
> * Close all open bugs on bugzilla.gnome.org as "RESOLVED OBSOLETE" with a 
> comment pointing to https://bugs.gnucash.org for further discussion. We're 
> using RESOLVED OBSOLETE to be consistent with the Gnome project bugs.
> * Import the changes to bugs.gnucash.org
> * Re-enable updates in the bugzilla code; that's disabled now because imports 
> don't work if it's enabled.
> 
> User accounts are preserved, but passwords are obviously not preserved. 
> Existing bugzilla.gnome.org users should use the "forgot my password" link on 
> https://bugs.gnucash.org to get a password reset and to enable their accounts 
> after the migration is complete.
> 
> Bug CC lists *are* preserved so you will get email notifications for changes 
> to bugs that you've commented on or otherwise added yourself to the CC list. 
> "Watching" links are *not* preserved so if you were watching another user or 
> one of the category users you'll need to reset that in Email Preferences 
> (click the Preferences link at the top of the page after you log in).
> 
> The category users are:
> * gnucash-core-ma...@gnucash.bugs GnuCash/Backend-SQL, 
> Backend-XML, Budgets, Build system, Business, Currency and Commodity, Engine
> * gnucash-documentation-ma...@gnucash.bugsDocumentation, Website, 
> GnuCash/Translations
> * gnucash-general-ma...@gnucash.bugs  GnuCash/General
> * gnucash-import-ma...@gnucash.bugs   GnuCash/Import - *, TXF Export
> * gnucash-mac-ma...@gnucash.bugs  Packaging/MacOS, GnuCash/MacOS
> * gnucash-reports-ma...@gnucash.bugs  GnuCash/Check Printing, Reports
> * gnucash-ui-ma...@gnucash.bugs   GnuCash/Regist2, Register, User 
> Interface General
> * gnucash-win-ma...@gnucash.bugs  Packaging/Windows, GnuCash 
> Windows
> * gnucash-all-ma...@gnucash.bugs  All bugs
> 
> Since we have the whole bug tracker to ourselves we've created some new 
> products and moved some bugs into them:
> * GnuCash continues to collect reports on the application itself.
> * Documentation   collects documentation reports
> * Packaging   collects reports about the all-in-one Windows and MacOS 
> packages that are not about GnuCash application code.
> * Website collects reports about www.gnucash.org.
> 
> More information on https://wiki.gnucash.org/wiki/Bugzilla.
> 
> Regards,
> John Ralls
> 
> 
> ___
> gnucash-announce mailing list
> gnucash-annou...@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-announce

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Fwd: The two modules

2018-06-28 Thread D via gnucash-user



On June 28, 2018, at 1:12 PM, Geert Janssens  wrote:

>Op donderdag 28 juni 2018 18:47:18 CEST schreef Stephen M. Butler:
[Snip]
>> Maybe the financial folks can band together to get the developers to
>> enforce no-transactions to a parent account.
>I think we should modify the concepts. "Placeholder" is ambiguous and for the 
>lack of a better solution is has been abused to make existing accounts read-
>only.I

I am under the impression that the placeholder setting is only meant to make an 
account read-only, so saying that users have "abused" this seems incorrect. 
We've used the tool we've been given.

>Perhaps it's time to introduce a "View" type account which is only used to 
>structure the account tree (and as aggregate account in reports) and next to 
>that introduce a read-only attribute to normal accounts. Placeholder could 
>then be phased out in favor of these two. We could even try to automate this 
>using some heuristics:
>- if a placeholder account has no transactions, convert it into a view account
>- if a placeholder account does have transactions, make it read-only instead.
>Add in an informational message to the user about what was done so the user 
>can make corrections if needed (like adding view accounts if an account was 
>being used for both functions).
>Geert

You might even call a View account "Closed," or are there other reasons an 
account might behave this way?

I'd also add that eliminating these accounts from drop down controls should go 
along with the changes, but assume that would be implied from the fact that 
Placeholder accounts don't appear there currently.I

David

>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see 
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Bugzilla is moving

2018-06-28 Thread John Ralls
As anyone who's used Bugzilla in the last few months already knows, Gnome has 
moved their git repositories to a Gitlab instance at gitlab.gnome.org and 
migrated bug tracking for Gnome projects there as well. They've left Bugzilla 
alone for non-Gnome projects like GnuCash but they're closing it to new bugs on 
Sunday, 1 July.

Most users and contributors know that to get ready we've set up a new Bugzilla 
instance at https://bugs.gnucash.org and copied all of the bugs and their 
history and all user accounts. We'll do a final fetch from bugzilla.gnome.org 
at 2018-06-29 22:00:00 UTC (That's tomorrow at 8PM UTC/10PM European Daylight 
Time/4PM US Eastern Daylight Time). We expect to be able to "turn on" 
https://bugs.gnucash.org within a couple of hours. 

The process will be:
* Close bug creation on bugzilla.gnome.org. Unfortunately we can't prevent 
updating already-created bugs, but any changes to bugs on bugzilla.gnome.org 
after this will probably be lost.
* Fetch the latest bug status from bugzilla.gnome.org
* Close all open bugs on bugzilla.gnome.org as "RESOLVED OBSOLETE" with a 
comment pointing to https://bugs.gnucash.org for further discussion. We're 
using RESOLVED OBSOLETE to be consistent with the Gnome project bugs.
* Import the changes to bugs.gnucash.org
* Re-enable updates in the bugzilla code; that's disabled now because imports 
don't work if it's enabled.

User accounts are preserved, but passwords are obviously not preserved. 
Existing bugzilla.gnome.org users should use the "forgot my password" link on 
https://bugs.gnucash.org to get a password reset and to enable their accounts 
after the migration is complete.

Bug CC lists *are* preserved so you will get email notifications for changes to 
bugs that you've commented on or otherwise added yourself to the CC list. 
"Watching" links are *not* preserved so if you were watching another user or 
one of the category users you'll need to reset that in Email Preferences (click 
the Preferences link at the top of the page after you log in).

The category users are:
* gnucash-core-ma...@gnucash.bugs GnuCash/Backend-SQL, Backend-XML, 
Budgets, Build system, Business, Currency and Commodity, Engine
* gnucash-documentation-ma...@gnucash.bugsDocumentation, Website, 
GnuCash/Translations
* gnucash-general-ma...@gnucash.bugs  GnuCash/General
* gnucash-import-ma...@gnucash.bugs   GnuCash/Import - *, TXF Export
* gnucash-mac-ma...@gnucash.bugs  Packaging/MacOS, GnuCash/MacOS
* gnucash-reports-ma...@gnucash.bugs  GnuCash/Check Printing, Reports
* gnucash-ui-ma...@gnucash.bugs   GnuCash/Regist2, Register, User 
Interface General
* gnucash-win-ma...@gnucash.bugs  Packaging/Windows, GnuCash Windows
* gnucash-all-ma...@gnucash.bugs  All bugs

Since we have the whole bug tracker to ourselves we've created some new 
products and moved some bugs into them:
* GnuCash continues to collect reports on the application itself.
* Documentation   collects documentation reports
* Packaging   collects reports about the all-in-one Windows and MacOS 
packages that are not about GnuCash application code.
* Website collects reports about www.gnucash.org.

More information on https://wiki.gnucash.org/wiki/Bugzilla.

Regards,
John Ralls


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] GnuCash 3.2 Released

2018-06-28 Thread Dennis West
I'm sure you like to get feedback from someone with absolutely no 
problems at all.


I was using 2.6.21 on my primary computer and testing 3.1/3.2 on my 
standby testbed (both on Win 10.1803).  I finally decided to take the 
plunge and upgraded my primary computer form 2.6.21 to 3.2.  The 
experience was flawless and now my testbed pc is eagerly awaiting vs 4.0.


Dennis


On 6/24/2018 22:40, John Ralls wrote:

The GnuCash development team announces GnuCash 3.2, the second release of the 
3.x stable release series.

Changes

Between 3.0 and 3.2, the following bugfixes were accomplished:

• Bug 787401 - Test Report System - Report Definition.
• Bug 794617 - Can't compile with -DWITH_GNUCASH=NO due to 
scm-gnome-utils.
• Bug 795101 - Scroll Bar in Reconcile Window Floats in and covers the 
check boxes.
• Bug 795247 - datepicker broken in Persian. GnuCash passes dates as 
integer y/m/d without using locale-specific formats, so we need to strip out 
'E' and 'O' from the format when scanning dates or determining separators in 
gnc-date. None of '-', 'E', or 'O' are supported by boost (and '-' causes 
errors), so strip them out from formatters in gnc-datetime as well.
• Bug 795253 - Have problems input Chinese.
• Bug 795272 - QIF importer causes application crash if action is 
invalid.
• Bug 795276 - Invalid date on price stops file from being parsed.
• Bug 795362 - Special variable "i" not parsed in function calls. Due 
to balance tests with insane random values.
• Bug 795471 - Impossible to Edit Budget Unless Maximized.
• Bug 795519 - Credit card payment after reconciliation.
• Bug 795666 - Backslash '\' in Description field spoils CSV Import 
without helpful error message.
• Bug 795831 - When read only threshold set, dates are silently 
changed. Display a message box informing the user of the change.
• Bug 795944 - Cannot store change to Business Suppliers data.
• Bug 796079 - Repeatable Crash in Tax Report Options.
• Bug 796081 - Tax Schedule Report - An error occurred while running 
the report.
• Bug 796083 - Reconcile Selection Doesn't Work Anymore.
• Bug 796117 - Connecting 3.1 to an existing mysql db drops all data. 
Provide a backup recovery function that instead of dropping primaries and 
restoring backups merges the primaries and backups. This should handle a 
worst-case safe-save failure where the backup tables don't have a complete set 
of rows for some reason.
• Bug 796256 - Main Window stays hidden when starting after closing 
main window while minimized.
• Bug 796369 - Notes lost or perhaps just not displaying when using 
SQLite backend. This bug caused data loss if you saved your SQLite3 database to 
a different file or database. The problem is that in SQLite3 (though not in 
MySQL or PgSQL) the subquery ((SELECT DISTINCT guid FROM transactions)) (note 
the double parentheses) returns only the first guid in the subquery's results. 
Some transactions are loaded by special queries and those queries are also used 
to retrieve the transaction's slots so they weren't affected.
• Bug 796398 - Restrict accelerator keys to valid date range.
• Bug 796409 - Incorrect Current Value for Stocks. Missed calculating 
the value in the register summary bar.
• Bug 796423 - Cannot Input Chinese, seems does not work with other IME 
too. Toggles not in view with all rows selected weren't being redrawn.
• Bug 796484 - csv import: iostream error. Unfortunately it turns out 
that we can't use filestreams because they can't take path arguments containing 
Unicode on Windows.
• Bug 796527 - invalid currency on scheduled transactions.
• Don't even check for price/exchange rate on template 
transactions, there's no point.
• Check all split commodities are valid, abort transaction 
creation if not.
• If the template transaction's currency isn't used by any of 
the splits set the new transaction's currency to the first-found currency if 
there is one, otherwise to the first-found commodity.
• Bug 796537 - Transaction Report cannot sort by "num".
• Bug 796586 - QIF import incorrectly converts unicode characters from 
UTF8 encoded file.
• Bug 796595 - QIF Import Select Account button to add a new account is 
labled gnc-account-new but should be New.
• Bug 796600 - stock split cash-in-lieu income/asset labels backwards.
• Bug 796614 - Reconciliation report contains incorrect transactions.
• Bug 796638 - configuration not properly saved for CSV transactions 
import form.
The Following fixes and improvemts were not associated with bug reports:

• Transaction report improvements:
• Performance: Do all filtering ops before sorting.
• Move the options summary before the subtotals table.
• New 

Re: [GNC] Fwd: The two modules

2018-06-28 Thread David Carlson
Is the 'frozen' status which is already in place but seemingly unused
supposed to be for this purpose?

David C

On Thu, Jun 28, 2018, 12:31 PM John Ralls  wrote:

>
>
> > On Jun 28, 2018, at 10:10 AM, Geert Janssens 
> wrote:
> >
> > Op donderdag 28 juni 2018 18:47:18 CEST schreef Stephen M. Butler:
> >> On 06/27/2018 04:41 PM, DaveC49 wrote:
> >>> An active non-placeholder account should not have child/subaccounts,
> >>> although I don't think GnuCash actually prevents this. In this case,
> the
> >>> parent account total is the sum of the child subaccount totals plus the
> >>> sum
> >>> of any transactions into the parent account itself. This will make a
> >>> report
> >>> look to be incorrect as the sum of transactions into the parent
> account is
> >>> not presented separately and its total will not be the sum of the child
> >>> account totals. I can't think of a use case where this would be
> desirable,
> >>> but some people may be happy with that behavior. I don't think this
> >>> behavior has changed since I first checked it out in an earlier version
> >>> (around 2.2 I think).
> >>
> >> This is a problem.  In a good report the parent with transactions should
> >> show a line for the parent so that the column total for that parent (on
> >> the balance sheet) is correct.
> >>
> > This seems to make most sense to me:
> > If a parent has transactions put it twice:
> > Once as aggregate account and once as an account on it's own. That would
> meet
> > both needs. The aggregate will total it's own transactions with those of
> its
> > child accounts. Or put differently the aggregate account would treat
> itself as
> > a child account.
>
> +1
>
> >
> >> At least, as a former IT software development manager, I would insist
> >> that a column total show all of it's inputs.
> >>
> >> Maybe the financial folks can band together to get the developers to
> >> enforce no-transactions to a parent account.
> >
> > I think we should modify the concepts. "Placeholder" is ambiguous and
> for the
> > lack of a better solution is has been abused to make existing accounts
> read-
> > only.
> >
> > Perhaps it's time to introduce a "View" type account which is only used
> to
> > structure the account tree (and as aggregate account in reports) and
> next to
> > that introduce a read-only attribute to normal accounts. Placeholder
> could
> > then be phased out in favor of these two. We could even try to automate
> this
> > using some heuristics:
> > - if a placeholder account has no transactions, convert it into a view
> account
> > - if a placeholder account does have transactions, make it read-only
> instead.
> > Add in an informational message to the user about what was done so the
> user
> > can make corrections if needed (like adding view accounts if an account
> was
> > being used for both functions).
> >
>
> I propose that we combine “placeholder” and “hidden” to “inactive” which
> removes an account from the picker list and from the Accounts page unless
> “show inactive accounts” is selected from the filter.
>
> While marking an account “placeholder” prevents adding transactions to it,
> there’s no requirement in GnuCash that an account with children have the
> placeholder flag set. To strictly follow David Cousen’s advice we’d have to
> impose that restriction, but some users might find that a bit drastic.
> Perhaps we could make it a book option?
>
> Regards,
> John Ralls
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Fwd: The two modules

2018-06-28 Thread John Ralls


> On Jun 28, 2018, at 10:10 AM, Geert Janssens  
> wrote:
> 
> Op donderdag 28 juni 2018 18:47:18 CEST schreef Stephen M. Butler:
>> On 06/27/2018 04:41 PM, DaveC49 wrote:
>>> An active non-placeholder account should not have child/subaccounts,
>>> although I don't think GnuCash actually prevents this. In this case, the
>>> parent account total is the sum of the child subaccount totals plus the
>>> sum
>>> of any transactions into the parent account itself. This will make a
>>> report
>>> look to be incorrect as the sum of transactions into the parent account is
>>> not presented separately and its total will not be the sum of the child
>>> account totals. I can't think of a use case where this would be desirable,
>>> but some people may be happy with that behavior. I don't think this
>>> behavior has changed since I first checked it out in an earlier version
>>> (around 2.2 I think).
>> 
>> This is a problem.  In a good report the parent with transactions should
>> show a line for the parent so that the column total for that parent (on
>> the balance sheet) is correct.
>> 
> This seems to make most sense to me:
> If a parent has transactions put it twice:
> Once as aggregate account and once as an account on it's own. That would meet 
> both needs. The aggregate will total it's own transactions with those of its 
> child accounts. Or put differently the aggregate account would treat itself 
> as 
> a child account.

+1

> 
>> At least, as a former IT software development manager, I would insist
>> that a column total show all of it's inputs. 
>> 
>> Maybe the financial folks can band together to get the developers to
>> enforce no-transactions to a parent account.
> 
> I think we should modify the concepts. "Placeholder" is ambiguous and for the 
> lack of a better solution is has been abused to make existing accounts read-
> only.
> 
> Perhaps it's time to introduce a "View" type account which is only used to 
> structure the account tree (and as aggregate account in reports) and next to 
> that introduce a read-only attribute to normal accounts. Placeholder could 
> then be phased out in favor of these two. We could even try to automate this 
> using some heuristics:
> - if a placeholder account has no transactions, convert it into a view account
> - if a placeholder account does have transactions, make it read-only instead.
> Add in an informational message to the user about what was done so the user 
> can make corrections if needed (like adding view accounts if an account was 
> being used for both functions).
> 

I propose that we combine “placeholder” and “hidden” to “inactive” which 
removes an account from the picker list and from the Accounts page unless “show 
inactive accounts” is selected from the filter.

While marking an account “placeholder” prevents adding transactions to it, 
there’s no requirement in GnuCash that an account with children have the 
placeholder flag set. To strictly follow David Cousen’s advice we’d have to 
impose that restriction, but some users might find that a bit drastic. Perhaps 
we could make it a book option?

Regards,
John Ralls


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Fwd: The two modules

2018-06-28 Thread Stephen M. Butler
On 06/28/2018 10:10 AM, Geert Janssens wrote:
> Op donderdag 28 juni 2018 18:47:18 CEST schreef Stephen M. Butler:
>> On 06/27/2018 04:41 PM, DaveC49 wrote:
>>> An active non-placeholder account should not have child/subaccounts,
>>> although I don't think GnuCash actually prevents this. In this case, the
>>> parent account total is the sum of the child subaccount totals plus the
>>> sum
>>> of any transactions into the parent account itself. This will make a
>>> report
>>> look to be incorrect as the sum of transactions into the parent account is
>>> not presented separately and its total will not be the sum of the child
>>> account totals. I can't think of a use case where this would be desirable,
>>> but some people may be happy with that behavior. I don't think this
>>> behavior has changed since I first checked it out in an earlier version
>>> (around 2.2 I think).
>> This is a problem.  In a good report the parent with transactions should
>> show a line for the parent so that the column total for that parent (on
>> the balance sheet) is correct.
>>
> This seems to make most sense to me:
> If a parent has transactions put it twice:
> Once as aggregate account and once as an account on it's own. That would meet 
> both needs. The aggregate will total it's own transactions with those of its 
> child accounts. Or put differently the aggregate account would treat itself 
> as 
> a child account.

I like that approach.
>> Maybe the financial folks can band together to get the developers to
>> enforce no-transactions to a parent account.
> I think we should modify the concepts. "Placeholder" is ambiguous and for the 
> lack of a better solution is has been abused to make existing accounts read-
> only.

Surprise!  Given enough rope we will tie knots.
> Perhaps it's time to introduce a "View" type account which is only used to 
> structure the account tree (and as aggregate account in reports) and next to 
> that introduce a read-only attribute to normal accounts. Placeholder could 
> then be phased out in favor of these two. We could even try to automate this 
> using some heuristics:
> - if a placeholder account has no transactions, convert it into a view account
> - if a placeholder account does have transactions, make it read-only instead.
> Add in an informational message to the user about what was done so the user 
> can make corrections if needed (like adding view accounts if an account was 
> being used for both functions).
>
> Geert
>
>
This would help the non-accountant to setup their books in a more
traditional form.  Especially if GnC enforced parent accounts to become
"View" accounts.
It would also help the report writers to present the information
logically without having to resort to extra decision making about how to
handle a parent who has transactions.
--Steve
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Forward payments

2018-06-28 Thread Stephen M. Butler
On 06/28/2018 12:25 AM, Tony Vanson wrote:
> Thank you for your quick response. My Staff account is set up as an Expense
> not as an Asset. In this particular case would I need to set up a new
> account Current Assets:Staff - as a child account under Current Assets?
> Cheers

I would set it up as an asset.  Even if you physically handed them the
cash and they physically put it into their wallet for future
disbursement as needed, it is still your asset.  If anything is left
over when you return it would come back to you for put back into the bank.

I presume you will get periodic statements about how that asset is being
disbursed so you can make the appropriate entries to transfer funds to
the appropriate expense accounts (just like you do now, except the asset
side is not the bank but the "staff accountant"). 

That way you could notice if the funds were running short and do online
banking to send more funds to that person.
> On Thu, Jun 28, 2018 at 2:08 PM, Maf. King  wrote:
>
>> On Thursday, 28 June 2018 07:53:02 BST Tony Vanson wrote:
>>> Hi all,
>>> Hopefully someone can advise me how to treat the following problem which
>>> stumps me.
>>> I am using GNUcash 2.6.18 on Windows 10.
>>> I shall be away for several months and have transferred credit from my
>>> Savings account to my Staff account with a lump sum amount for her to pay
>>> her Salary, Electricity, Pool chemicals, Internet access etc, on the due
>>> date. All these are set up as expense accounts.
>>> All accounts, apart from her Salary and Internet access, are variable in
>>> amount and payment date.
>>> I assume that I have to split the lump sum to the various accounts as
>> they
>>> are paid or is there some other method?
>>> I also need to take into account that the payment I've made to the Staff
>>> account may be too small or too large.
>>> Any enlightenment to a personally perplexing problem would be greatly
>>> appreciated.
>>> P.S. I only use GNUcash for my personal information and does not have any
>>> taxation or other legal requirement.
>>> Cheers
>> Hi Tony.
>>
>> Do you have accounts in GC that represent your Savings account & Staff
>> accounts?
>>
>> To me it seems that you should let GC reflect reality - you've got a
>> transaction from Assets:Savings to Assets:StaffAccount.  as the payments
>> are
>> made, you have transactions between Assets:StaffAccount & expense accounts
>> as
>> appropriate. (presumably, you could be emailed details of payments made to
>> keep your GC up to date?)
>>
>> If, on your return, you have balance left in Assets:StaffAccount, just
>> record
>> a transaction putting it back into savings.
>>
>> HTH,
>> Maf.
>>
>>
>>
>>
>>
>

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Fwd: The two modules

2018-06-28 Thread Geert Janssens
Op donderdag 28 juni 2018 18:47:18 CEST schreef Stephen M. Butler:
> On 06/27/2018 04:41 PM, DaveC49 wrote:
> > An active non-placeholder account should not have child/subaccounts,
> > although I don't think GnuCash actually prevents this. In this case, the
> > parent account total is the sum of the child subaccount totals plus the
> > sum
> > of any transactions into the parent account itself. This will make a
> > report
> > look to be incorrect as the sum of transactions into the parent account is
> > not presented separately and its total will not be the sum of the child
> > account totals. I can't think of a use case where this would be desirable,
> > but some people may be happy with that behavior. I don't think this
> > behavior has changed since I first checked it out in an earlier version
> > (around 2.2 I think).
> 
> This is a problem.  In a good report the parent with transactions should
> show a line for the parent so that the column total for that parent (on
> the balance sheet) is correct.
> 
This seems to make most sense to me:
If a parent has transactions put it twice:
Once as aggregate account and once as an account on it's own. That would meet 
both needs. The aggregate will total it's own transactions with those of its 
child accounts. Or put differently the aggregate account would treat itself as 
a child account.

> At least, as a former IT software development manager, I would insist
> that a column total show all of it's inputs. 
> 
> Maybe the financial folks can band together to get the developers to
> enforce no-transactions to a parent account.

I think we should modify the concepts. "Placeholder" is ambiguous and for the 
lack of a better solution is has been abused to make existing accounts read-
only.

Perhaps it's time to introduce a "View" type account which is only used to 
structure the account tree (and as aggregate account in reports) and next to 
that introduce a read-only attribute to normal accounts. Placeholder could 
then be phased out in favor of these two. We could even try to automate this 
using some heuristics:
- if a placeholder account has no transactions, convert it into a view account
- if a placeholder account does have transactions, make it read-only instead.
Add in an informational message to the user about what was done so the user 
can make corrections if needed (like adding view accounts if an account was 
being used for both functions).

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Fwd: The two modules

2018-06-28 Thread Stephen M. Butler
On 06/27/2018 04:41 PM, DaveC49 wrote:
> Stephen,
>  
> As an accountant I would prefer to have parent accounts as placeholder
> accounts which cannot be the target of transactions directly (this can be
> set in the edit Account dialog and marks the account as read only) as the
> placeholder total should then be the sum of its active child accounts. This
> will give clean easy to read reports which make obvious sense.

My wife is also an accountant and prefers that method also.  I setup my
books that way.  However, I'm trying to help Christopher with modifying
his version of the balance sheet to more fully meet my wife's
expectations (she likes the formatting of the eguile version but hates
the inclusion of the income statement within the equity portion of that
report.

<>
> An active non-placeholder account should not have child/subaccounts,
> although I don't think GnuCash actually prevents this. In this case, the
> parent account total is the sum of the child subaccount totals plus the sum
> of any transactions into the parent account itself. This will make a report
> look to be incorrect as the sum of transactions into the parent account is
> not presented separately and its total will not be the sum of the child
> account totals. I can't think of a use case where this would be desirable,
> but some people may be happy with that behavior. I don't think this behavior
> has changed since I first checked it out in an earlier version (around 2.2 I
> think).

This is a problem.  In a good report the parent with transactions should
show a line for the parent so that the column total for that parent (on
the balance sheet) is correct.

At least, as a former IT software development manager, I would insist
that a column total show all of it's inputs. 

Maybe the financial folks can band together to get the developers to
enforce no-transactions to a parent account.

<>
> Hope this helps make sense and helps you to get GnuCash working as you want
>
> Cheers
>
> David Cousens
>

Thanks David.  Except for the layout of the Balance Sheet and the Income
Statement reports, this has been working out great.

--Steve


Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] The two modules

2018-06-28 Thread D via gnucash-user
Sorry. I misunderstood, and I appreciate your correction and clarification.

On June 28, 2018, at 10:30 AM, John Ralls  wrote:

David T:

No, he didn’t. He said that it’s poor accounting practice and since unlike you 
and me he’s a licensed accountant we should respect his judgement. He also said 
explicitly that GnuCash doesn’t enforce that and he correctly described how 
GnuCash handles placeholder accounts having transactions.

Regards,
John Ralls


> On Jun 28, 2018, at 6:39 AM, D via gnucash-user  
> wrote:
> 
> David,
> 
> You've now misstated twice that Placeholder accounts cannot have 
> transactions, and I feel it is important to make it unambiguously clear to 
> anyone reading this thread that there is nothing in Gnucash that prevents 
> placeholder accounts from having transactions. 
> 
> Setting an account as a placeholder only prevents further transactions from 
> being added to that account. Many of us use the placeholder setting to 
> prevent accidental creation of transactions in closed accounts, for example.I
> 
> David T.
> 
> On June 28, 2018, at 4:58 AM, DaveC49  wrote:
> 
> Stephen,
> 
> As an accountant I would prefer to have parent accounts as placeholder
> accounts which cannot be the target of transactions directly (this can be
> set in the edit Account dialog and marks the account as read only) as the
> placeholder total should then be the sum of its active child accounts. This
> will give clean easy to read reports which make obvious sense.
> 
> Before you convert an existing parent account to a placeholder (by checking
> the placeholder checkbox in the Edit Account dialog), you will need to
> transfer any transactions into it to an appropriate child/sub-account. My
> experience is that a placeholder account can have in turn child accounts
> which are also placeholders as well as child active accounts, which is OK
> and makes sense. 
> 
> An active non-placeholder account should not have child/subaccounts,
> although I don't think GnuCash actually prevents this. In this case, the
> parent account total is the sum of the child subaccount totals plus the sum
> of any transactions into the parent account itself. This will make a report
> look to be incorrect as the sum of transactions into the parent account is
> not presented separately and its total will not be the sum of the child
> account totals. I can't think of a use case where this would be desirable,
> but some people may be happy with that behavior. I don't think this behavior
> has changed since I first checked it out in an earlier version (around 2.2 I
> think).
> 
> The report is a different beast but it should reflect the above behavior and
> a placeholder parent account should only show the total of its
> child/subaccounts totals. If it doesn't tha indicates that it may have
> already been the target of transactions when set as a placeholder and these
> were not transferred to a sub-account. 
> 
> If a parent account is not a placeholder account, it should behave as
> described above and add the total of any transactions into it to the sum of
> any child account totals. I haven't got time at the moment to check all the
> reports out but I have never noticed any problems with the Balance Sheet and
> Income Statement with all parent  accounts set as placeholders. There are
> enough accountants using GnuCash that this would have been picked up pretty
> quickly if it was not behaving as expected. 
> 
> Hope this helps make sense and helps you to get GnuCash working as you want
> 
> Cheers
> 
> David Cousens
> 
> 
> 
> 
> 
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by 

Re: [GNC] The two modules

2018-06-28 Thread John Ralls
David T:

No, he didn’t. He said that it’s poor accounting practice and since unlike you 
and me he’s a licensed accountant we should respect his judgement. He also said 
explicitly that GnuCash doesn’t enforce that and he correctly described how 
GnuCash handles placeholder accounts having transactions.

Regards,
John Ralls


> On Jun 28, 2018, at 6:39 AM, D via gnucash-user  
> wrote:
> 
> David,
> 
> You've now misstated twice that Placeholder accounts cannot have 
> transactions, and I feel it is important to make it unambiguously clear to 
> anyone reading this thread that there is nothing in Gnucash that prevents 
> placeholder accounts from having transactions. 
> 
> Setting an account as a placeholder only prevents further transactions from 
> being added to that account. Many of us use the placeholder setting to 
> prevent accidental creation of transactions in closed accounts, for example.I
> 
> David T.
> 
> On June 28, 2018, at 4:58 AM, DaveC49  wrote:
> 
> Stephen,
> 
> As an accountant I would prefer to have parent accounts as placeholder
> accounts which cannot be the target of transactions directly (this can be
> set in the edit Account dialog and marks the account as read only) as the
> placeholder total should then be the sum of its active child accounts. This
> will give clean easy to read reports which make obvious sense.
> 
> Before you convert an existing parent account to a placeholder (by checking
> the placeholder checkbox in the Edit Account dialog), you will need to
> transfer any transactions into it to an appropriate child/sub-account. My
> experience is that a placeholder account can have in turn child accounts
> which are also placeholders as well as child active accounts, which is OK
> and makes sense. 
> 
> An active non-placeholder account should not have child/subaccounts,
> although I don't think GnuCash actually prevents this. In this case, the
> parent account total is the sum of the child subaccount totals plus the sum
> of any transactions into the parent account itself. This will make a report
> look to be incorrect as the sum of transactions into the parent account is
> not presented separately and its total will not be the sum of the child
> account totals. I can't think of a use case where this would be desirable,
> but some people may be happy with that behavior. I don't think this behavior
> has changed since I first checked it out in an earlier version (around 2.2 I
> think).
> 
> The report is a different beast but it should reflect the above behavior and
> a placeholder parent account should only show the total of its
> child/subaccounts totals. If it doesn't tha indicates that it may have
> already been the target of transactions when set as a placeholder and these
> were not transferred to a sub-account. 
> 
> If a parent account is not a placeholder account, it should behave as
> described above and add the total of any transactions into it to the sum of
> any child account totals. I haven't got time at the moment to check all the
> reports out but I have never noticed any problems with the Balance Sheet and
> Income Statement with all parent  accounts set as placeholders. There are
> enough accountants using GnuCash that this would have been picked up pretty
> quickly if it was not behaving as expected. 
> 
> Hope this helps make sense and helps you to get GnuCash working as you want
> 
> Cheers
> 
> David Cousens
> 
> 
> 
> 
> 
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Fwd: The two modules

2018-06-28 Thread Mike or Penny Novack

On 6/28/2018 9:39 AM, D via gnucash-user wrote:


Before you convert an existing parent account to a placeholder (by checking
the placeholder checkbox in the Edit Account dialog), you will need to
transfer any transactions into it to an appropriate child/sub-account. My
experience is that a placeholder account can have in turn child accounts
which are also placeholders as well as child active accounts, which is OK
and makes sense.
In practice, you might better be doing this by a sequence of account 
name changes. In my experience, the most common situation where an 
account (with transactions) is becoming a parent is when it is observed 
that NOW (the reason for the change) is that these transactions are of 
two (or more) distinct types and so splitting into multiple accounts is 
desired. But the NAME you want for the parent is that of the existing 
account.


a) rename that account to its desired new name.
b) create a new account with the old name, making it a placeholder account.
c) make "a" a child of "b"
d)  create the other child account (or accounts)
e) optional --- move transactions here that are in the wrong child IF 
you want to alter the past << I never do that >>


Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Fwd: The two modules

2018-06-28 Thread D via gnucash-user
David,

You've now misstated twice that Placeholder accounts cannot have transactions, 
and I feel it is important to make it unambiguously clear to anyone reading 
this thread that there is nothing in Gnucash that prevents placeholder accounts 
from having transactions. 

Setting an account as a placeholder only prevents further transactions from 
being added to that account. Many of us use the placeholder setting to prevent 
accidental creation of transactions in closed accounts, for example.I

David T.

On June 28, 2018, at 4:58 AM, DaveC49  wrote:

Stephen,
 
As an accountant I would prefer to have parent accounts as placeholder
accounts which cannot be the target of transactions directly (this can be
set in the edit Account dialog and marks the account as read only) as the
placeholder total should then be the sum of its active child accounts. This
will give clean easy to read reports which make obvious sense.

Before you convert an existing parent account to a placeholder (by checking
the placeholder checkbox in the Edit Account dialog), you will need to
transfer any transactions into it to an appropriate child/sub-account. My
experience is that a placeholder account can have in turn child accounts
which are also placeholders as well as child active accounts, which is OK
and makes sense. 

An active non-placeholder account should not have child/subaccounts,
although I don't think GnuCash actually prevents this. In this case, the
parent account total is the sum of the child subaccount totals plus the sum
of any transactions into the parent account itself. This will make a report
look to be incorrect as the sum of transactions into the parent account is
not presented separately and its total will not be the sum of the child
account totals. I can't think of a use case where this would be desirable,
but some people may be happy with that behavior. I don't think this behavior
has changed since I first checked it out in an earlier version (around 2.2 I
think).

The report is a different beast but it should reflect the above behavior and
a placeholder parent account should only show the total of its
child/subaccounts totals. If it doesn't tha indicates that it may have
already been the target of transactions when set as a placeholder and these
were not transferred to a sub-account. 

If a parent account is not a placeholder account, it should behave as
described above and add the total of any transactions into it to the sum of
any child account totals. I haven't got time at the moment to check all the
reports out but I have never noticed any problems with the Balance Sheet and
Income Statement with all parent  accounts set as placeholders. There are
enough accountants using GnuCash that this would have been picked up pretty
quickly if it was not behaving as expected. 

Hope this helps make sense and helps you to get GnuCash working as you want

Cheers

David Cousens





-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Forward payments

2018-06-28 Thread Maf. King
On Thursday, 28 June 2018 11:31:08 BST Tony Vanson wrote:
> Thank you for your patience
> Yes, I guess, in this instance, it could be considered as a type of
> temporary loan for her to pay the bills. However, my thoughts are, that if
> I change the current classification of Expenses:Staff to Current
> Assets:Staff, when I pay her salary I'm decreasing an Asset (Bank Account)
> but would also be needing to decrease another asset account Current
> Assets:Staff. Am I wrong in assuming that this cannot be done?
> 
> By "transferred from savings to Staff Account" I meant when salary payment
> is made (usually in cash) it is from my Current Assets:Bank Account:Cash in
> Wallet with the offsetting account being Expense:Staff Account"
> Cheers
> 

Hi Tony,


you can have assets:advancetransfer (call it what you like!)  and 
expenses:staff as already existing

instead of transfer from Bank:Cash -> Expenses:Staff (the normal transaction 
for salary)
you do

Bank -> assets:AdvanceTransfer   (ie before you go away)

then as required while you are away

Asset:advanceTransfer -> Expenses:StaffSalary
or
Asset:AdvanceTransfer -> Expenses:PoolChems

when you are back, if there is anything left in AdvanceTransfer, you can bring 
it back to the bank account, or if it is negative, put more into it.  I don't 
see your point about touching 2 asset accounts at the same time.

HTH,
Maf.





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Forward payments

2018-06-28 Thread Tony Vanson
Thank you - short and sweet - and confirms that I need an additional asset
account.
Cheers

On Thu, Jun 28, 2018 at 5:46 PM, Christopher Lam 
wrote:

> You are effectively doing a split transaction.
>
> Assets:Bank -$1250
> Assets:Staff  +$250 (sundries)
> Expenses:Staff +$1000 (salary)
>
> As the staff member spends appropriately, transfer from Assets:Staff to
> Expenses:Various
>
> C
>
>
> On 28/06/18 18:31, Tony Vanson wrote:
>
>> Thank you for your patience
>> Yes, I guess, in this instance, it could be considered as a type of
>> temporary loan for her to pay the bills. However, my thoughts are, that if
>> I change the current classification of Expenses:Staff to Current
>> Assets:Staff, when I pay her salary I'm decreasing an Asset (Bank Account)
>> but would also be needing to decrease another asset account Current
>> Assets:Staff. Am I wrong in assuming that this cannot be done?
>>
>> By "transferred from savings to Staff Account" I meant when salary payment
>> is made (usually in cash) it is from my Current Assets:Bank Account:Cash
>> in
>> Wallet with the offsetting account being Expense:Staff Account"
>> Cheers
>>
>>
>> On Thu, Jun 28, 2018 at 2:57 PM, Maf. King  wrote:
>>
>> On Thursday, 28 June 2018 08:46:41 BST Tony Vanson wrote:
>>>
 Thanks again. Normally the staff salary would be simply paid from my
 Current assets:Bank Account to Expenses:Staff as they become due.
 Similarly with the other payments from my Current:assets:Bank Account to
 the various other expense account: e.g. Expenses:Pool etc. etc.
 Cheers

 Hi Tony,
>>>
>>> That all makes perfect sense -  so have you "loaned" the money to cover
>>> the
>>> time you are away directly to an employee? (ie into someone else's
>>> personal
>>> account)
>>>
>>> I'm trying to understand what you mean by "transferred from savings to
>>> Staff
>>> Account" in your OP.
>>>
>>> But yes, it seems to me in summary you want the Staff Account to be an
>>> asset -
>>> if there is unused money at the end of your trip in the Staff Account it
>>> will
>>> be returned to you, just as if you put it in some other temporary bank
>>> account
>>> (or notes in a shoe bux under the bed!)   Expenses txns then go from the
>>> new
>>> asset account to the expense accounts, very much as you do at present.
>>>
>>> Maf.
>>>
>>>
>>>
>>>
>>>
>>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.




-- 
*Tony Vanson*

*The older I get,*
*the better I was*
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Fwd: The two modules

2018-06-28 Thread Christopher Lam

Hi Dave

It's nice to have input from someone in the know.

I have used the placeholder flag to tag accounts which are now closed, 
e.g. closed bank accounts, loans paid off, old unused expense 
categories. This is not expressly disallowed by the UI, and the 
advantage here is the account does not appear on the transfer dialog.


The approach of the balsheet & profit multicolumn report currently 
in development, is to ignore the placeholder flag, and allow 2 
strategies for parent/child subtotals. (These were also present in the 
old balance-sheet)


1. every parent account will automatically receive amounts from the 
children accounts, "recursive subtotal" e.g.


Asset $110,000 [the so-called placeholder acc]
Asset:Bank $2,000
Asset:Savings $8,000
Asset:House $100,000

I know some users will have subaccounts of their checking account for 
budgeting purposes, so,


Asset:Bank: $2000 [account-total is $1800 but also includes the child $200]
Asset:Bank:Budgeted $200

2. every account displays its own amounts, ignoring children accounts... 
however after each set parent+children, the whole group receives an 
overriding subtotal. "Hierarchical subtotal"


Asset $0
Asset:Bank $1,800
Asset:Bank:Budgeted $200
Total Asset:Bank $2,000

Asset:Savings $8,000
Asset:House $100,000
Total Asset $110,000

The balsheet (and P) report in development offers both, and is 
agnostic to the placeholder status. As a side effect, I've think that it 
makes for a good dashboard-view of your finances. See current output, in 
multicolumn in multicolumn.


https://screenshots.firefox.com/3AGgKiSkmdebjOsf/null

Left-column: profit, with hierarchical subtotals
Middle-column: balance-sheet, with hierarchical subtotals
Right-column: balance-sheet, with recursive subtotals

C

On 28/06/18 07:41, DaveC49 wrote:

Stephen,
  
As an accountant I would prefer to have parent accounts as placeholder

accounts which cannot be the target of transactions directly (this can be
set in the edit Account dialog and marks the account as read only) as the
placeholder total should then be the sum of its active child accounts. This
will give clean easy to read reports which make obvious sense.

Before you convert an existing parent account to a placeholder (by checking
the placeholder checkbox in the Edit Account dialog), you will need to
transfer any transactions into it to an appropriate child/sub-account. My
experience is that a placeholder account can have in turn child accounts
which are also placeholders as well as child active accounts, which is OK
and makes sense.

An active non-placeholder account should not have child/subaccounts,
although I don't think GnuCash actually prevents this. In this case, the
parent account total is the sum of the child subaccount totals plus the sum
of any transactions into the parent account itself. This will make a report
look to be incorrect as the sum of transactions into the parent account is
not presented separately and its total will not be the sum of the child
account totals. I can't think of a use case where this would be desirable,
but some people may be happy with that behavior. I don't think this behavior
has changed since I first checked it out in an earlier version (around 2.2 I
think).

The report is a different beast but it should reflect the above behavior and
a placeholder parent account should only show the total of its
child/subaccounts totals. If it doesn't tha indicates that it may have
already been the target of transactions when set as a placeholder and these
were not transferred to a sub-account.

If a parent account is not a placeholder account, it should behave as
described above and add the total of any transactions into it to the sum of
any child account totals. I haven't got time at the moment to check all the
reports out but I have never noticed any problems with the Balance Sheet and
Income Statement with all parent  accounts set as placeholders. There are
enough accountants using GnuCash that this would have been picked up pretty
quickly if it was not behaving as expected.

Hope this helps make sense and helps you to get GnuCash working as you want

Cheers

David Cousens





-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 

Re: [GNC] Forward payments

2018-06-28 Thread Christopher Lam

You are effectively doing a split transaction.

Assets:Bank -$1250
Assets:Staff  +$250 (sundries)
Expenses:Staff +$1000 (salary)

As the staff member spends appropriately, transfer from Assets:Staff to 
Expenses:Various


C

On 28/06/18 18:31, Tony Vanson wrote:

Thank you for your patience
Yes, I guess, in this instance, it could be considered as a type of
temporary loan for her to pay the bills. However, my thoughts are, that if
I change the current classification of Expenses:Staff to Current
Assets:Staff, when I pay her salary I'm decreasing an Asset (Bank Account)
but would also be needing to decrease another asset account Current
Assets:Staff. Am I wrong in assuming that this cannot be done?

By "transferred from savings to Staff Account" I meant when salary payment
is made (usually in cash) it is from my Current Assets:Bank Account:Cash in
Wallet with the offsetting account being Expense:Staff Account"
Cheers


On Thu, Jun 28, 2018 at 2:57 PM, Maf. King  wrote:


On Thursday, 28 June 2018 08:46:41 BST Tony Vanson wrote:

Thanks again. Normally the staff salary would be simply paid from my
Current assets:Bank Account to Expenses:Staff as they become due.
Similarly with the other payments from my Current:assets:Bank Account to
the various other expense account: e.g. Expenses:Pool etc. etc.
Cheers


Hi Tony,

That all makes perfect sense -  so have you "loaned" the money to cover
the
time you are away directly to an employee? (ie into someone else's
personal
account)

I'm trying to understand what you mean by "transferred from savings to
Staff
Account" in your OP.

But yes, it seems to me in summary you want the Staff Account to be an
asset -
if there is unused money at the end of your trip in the Staff Account it
will
be returned to you, just as if you put it in some other temporary bank
account
(or notes in a shoe bux under the bed!)   Expenses txns then go from the
new
asset account to the expense accounts, very much as you do at present.

Maf.








___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Forward payments

2018-06-28 Thread Tony Vanson
Thank you for your patience
Yes, I guess, in this instance, it could be considered as a type of
temporary loan for her to pay the bills. However, my thoughts are, that if
I change the current classification of Expenses:Staff to Current
Assets:Staff, when I pay her salary I'm decreasing an Asset (Bank Account)
but would also be needing to decrease another asset account Current
Assets:Staff. Am I wrong in assuming that this cannot be done?

By "transferred from savings to Staff Account" I meant when salary payment
is made (usually in cash) it is from my Current Assets:Bank Account:Cash in
Wallet with the offsetting account being Expense:Staff Account"
Cheers


On Thu, Jun 28, 2018 at 2:57 PM, Maf. King  wrote:

> On Thursday, 28 June 2018 08:46:41 BST Tony Vanson wrote:
> > Thanks again. Normally the staff salary would be simply paid from my
> > Current assets:Bank Account to Expenses:Staff as they become due.
> > Similarly with the other payments from my Current:assets:Bank Account to
> > the various other expense account: e.g. Expenses:Pool etc. etc.
> > Cheers
> >
>
> Hi Tony,
>
> That all makes perfect sense -  so have you "loaned" the money to cover
> the
> time you are away directly to an employee? (ie into someone else's
> personal
> account)
>
> I'm trying to understand what you mean by "transferred from savings to
> Staff
> Account" in your OP.
>
> But yes, it seems to me in summary you want the Staff Account to be an
> asset -
> if there is unused money at the end of your trip in the Staff Account it
> will
> be returned to you, just as if you put it in some other temporary bank
> account
> (or notes in a shoe bux under the bed!)   Expenses txns then go from the
> new
> asset account to the expense accounts, very much as you do at present.
>
> Maf.
>
>
>
>


-- 
*Tony Vanson*

*The older I get,*
*the better I was*
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Fwd: The two modules

2018-06-28 Thread DaveC49
Stephen,
 
As an accountant I would prefer to have parent accounts as placeholder
accounts which cannot be the target of transactions directly (this can be
set in the edit Account dialog and marks the account as read only) as the
placeholder total should then be the sum of its active child accounts. This
will give clean easy to read reports which make obvious sense.

Before you convert an existing parent account to a placeholder (by checking
the placeholder checkbox in the Edit Account dialog), you will need to
transfer any transactions into it to an appropriate child/sub-account. My
experience is that a placeholder account can have in turn child accounts
which are also placeholders as well as child active accounts, which is OK
and makes sense. 

An active non-placeholder account should not have child/subaccounts,
although I don't think GnuCash actually prevents this. In this case, the
parent account total is the sum of the child subaccount totals plus the sum
of any transactions into the parent account itself. This will make a report
look to be incorrect as the sum of transactions into the parent account is
not presented separately and its total will not be the sum of the child
account totals. I can't think of a use case where this would be desirable,
but some people may be happy with that behavior. I don't think this behavior
has changed since I first checked it out in an earlier version (around 2.2 I
think).

The report is a different beast but it should reflect the above behavior and
a placeholder parent account should only show the total of its
child/subaccounts totals. If it doesn't tha indicates that it may have
already been the target of transactions when set as a placeholder and these
were not transferred to a sub-account. 

If a parent account is not a placeholder account, it should behave as
described above and add the total of any transactions into it to the sum of
any child account totals. I haven't got time at the moment to check all the
reports out but I have never noticed any problems with the Balance Sheet and
Income Statement with all parent  accounts set as placeholders. There are
enough accountants using GnuCash that this would have been picked up pretty
quickly if it was not behaving as expected. 

Hope this helps make sense and helps you to get GnuCash working as you want

Cheers

David Cousens





-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Forward payments

2018-06-28 Thread Maf. King
On Thursday, 28 June 2018 08:46:41 BST Tony Vanson wrote:
> Thanks again. Normally the staff salary would be simply paid from my
> Current assets:Bank Account to Expenses:Staff as they become due.
> Similarly with the other payments from my Current:assets:Bank Account to
> the various other expense account: e.g. Expenses:Pool etc. etc.
> Cheers
> 

Hi Tony,

That all makes perfect sense -  so have you "loaned" the money to cover the 
time you are away directly to an employee? (ie into someone else's personal 
account)

I'm trying to understand what you mean by "transferred from savings to Staff 
Account" in your OP.

But yes, it seems to me in summary you want the Staff Account to be an asset - 
if there is unused money at the end of your trip in the Staff Account it will 
be returned to you, just as if you put it in some other temporary bank account 
(or notes in a shoe bux under the bed!)   Expenses txns then go from the new 
asset account to the expense accounts, very much as you do at present.

Maf.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Forward payments

2018-06-28 Thread Maf. King
On Thursday, 28 June 2018 08:25:51 BST Tony Vanson wrote:
> Thank you for your quick response. My Staff account is set up as an Expense
> not as an Asset. In this particular case would I need to set up a new
> account Current Assets:Staff - as a child account under Current Assets?
> Cheers
> 

Hi Tony, 

What is the staff account in the real world?  

How have you used it in GC so far - ie what general transactions touch it?

If you were not going away, how would you record the salary and pool chemical 
expenses?

Sorry if this seems like an interrogation, I'm just trying to understand your 
workflow before suggesting changes to it!

Maf.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Forward payments

2018-06-28 Thread Tony Vanson
Thank you for your quick response. My Staff account is set up as an Expense
not as an Asset. In this particular case would I need to set up a new
account Current Assets:Staff - as a child account under Current Assets?
Cheers

On Thu, Jun 28, 2018 at 2:08 PM, Maf. King  wrote:

> On Thursday, 28 June 2018 07:53:02 BST Tony Vanson wrote:
> > Hi all,
> > Hopefully someone can advise me how to treat the following problem which
> > stumps me.
> > I am using GNUcash 2.6.18 on Windows 10.
> > I shall be away for several months and have transferred credit from my
> > Savings account to my Staff account with a lump sum amount for her to pay
> > her Salary, Electricity, Pool chemicals, Internet access etc, on the due
> > date. All these are set up as expense accounts.
> > All accounts, apart from her Salary and Internet access, are variable in
> > amount and payment date.
> > I assume that I have to split the lump sum to the various accounts as
> they
> > are paid or is there some other method?
> > I also need to take into account that the payment I've made to the Staff
> > account may be too small or too large.
> > Any enlightenment to a personally perplexing problem would be greatly
> > appreciated.
> > P.S. I only use GNUcash for my personal information and does not have any
> > taxation or other legal requirement.
> > Cheers
>
> Hi Tony.
>
> Do you have accounts in GC that represent your Savings account & Staff
> accounts?
>
> To me it seems that you should let GC reflect reality - you've got a
> transaction from Assets:Savings to Assets:StaffAccount.  as the payments
> are
> made, you have transactions between Assets:StaffAccount & expense accounts
> as
> appropriate. (presumably, you could be emailed details of payments made to
> keep your GC up to date?)
>
> If, on your return, you have balance left in Assets:StaffAccount, just
> record
> a transaction putting it back into savings.
>
> HTH,
> Maf.
>
>
>
>
>


-- 
*Tony Vanson*

*The older I get,*
*the better I was*
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Forward payments

2018-06-28 Thread Maf. King
On Thursday, 28 June 2018 07:53:02 BST Tony Vanson wrote:
> Hi all,
> Hopefully someone can advise me how to treat the following problem which
> stumps me.
> I am using GNUcash 2.6.18 on Windows 10.
> I shall be away for several months and have transferred credit from my
> Savings account to my Staff account with a lump sum amount for her to pay
> her Salary, Electricity, Pool chemicals, Internet access etc, on the due
> date. All these are set up as expense accounts.
> All accounts, apart from her Salary and Internet access, are variable in
> amount and payment date.
> I assume that I have to split the lump sum to the various accounts as they
> are paid or is there some other method?
> I also need to take into account that the payment I've made to the Staff
> account may be too small or too large.
> Any enlightenment to a personally perplexing problem would be greatly
> appreciated.
> P.S. I only use GNUcash for my personal information and does not have any
> taxation or other legal requirement.
> Cheers

Hi Tony.

Do you have accounts in GC that represent your Savings account & Staff 
accounts?

To me it seems that you should let GC reflect reality - you've got a 
transaction from Assets:Savings to Assets:StaffAccount.  as the payments are 
made, you have transactions between Assets:StaffAccount & expense accounts as 
appropriate. (presumably, you could be emailed details of payments made to 
keep your GC up to date?)

If, on your return, you have balance left in Assets:StaffAccount, just record 
a transaction putting it back into savings.

HTH,
Maf.




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Forward payments

2018-06-28 Thread Tony Vanson
Hi all,
Hopefully someone can advise me how to treat the following problem which
stumps me.
I am using GNUcash 2.6.18 on Windows 10.
I shall be away for several months and have transferred credit from my
Savings account to my Staff account with a lump sum amount for her to pay
her Salary, Electricity, Pool chemicals, Internet access etc, on the due
date. All these are set up as expense accounts.
All accounts, apart from her Salary and Internet access, are variable in
amount and payment date.
I assume that I have to split the lump sum to the various accounts as they
are paid or is there some other method?
I also need to take into account that the payment I've made to the Staff
account may be too small or too large.
Any enlightenment to a personally perplexing problem would be greatly
appreciated.
P.S. I only use GNUcash for my personal information and does not have any
taxation or other legal requirement.
Cheers
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.