Re: General Ledger

[Mike or Penny Novack]

On 2/25/2018 2:06 PM, Dave H wrote:

Thanks for explaining the distinction Michael.

So I take from all this that the General Journal/General Ledger 
distinction is an historical distinction no longer in real use with 
the advent of computerised accounting software.


No, that wasn't quite what I said. Look at it again.

Even with computerized accounting software might want/need this 
distinction. Might WANT the books partitioned.


For example, in an enterprise of some size (not all that big) you MIGHT 
want (for example)
a) The office manager to have a small fund (petty cash) for things it 
was decided could just be purchased without going through the purchasing 
department.
b) Each sales location to be entering individual sales with only the 
daily totals going to main books.

etc.
Not JUST reducing the work load on the main enterprise bookkeeper. Not 
JUST reducing clutter and unnecessary detail in the main books. Not JUST 
that lower level employees can lack access to look at more than they 
need to (do you want EVERYBODY who needs access to be able to enter data 
to look at, for example, payroll to see what somebody else is getting 
paid. Note that with something like that reduced risk that the office 
manager or somebody in a sales office, etc. could do more than limited 
embezzlement on their own.


Michael D Novack
___
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: Scheduled Vendor Bills vs Schedule Transactions

[Adrien Monteleone]

Fran3,

Looking over Bugzilla, it appears this Request For Enhancement (RFE) has 
already been filed here: 

https://bugzilla.gnome.org/show_bug.cgi?id=114421

Though, I haven’t found anything yet with respect to the payment side. (I would 
guess the proper use case for that would be the receipt of funds using 
automatic recurring billing, but even then, I’d think you want to verify the 
funds actually transferred before creating those transactions.)

There is also an RFE with respect to mass invoicing customers by group if 
you’re interested:

https://bugzilla.gnome.org/show_bug.cgi?id=95780

It won’t hurt to chime in on those two with your own use case stories as part 
of the request. (it won’t make it happen any faster, but your use case 
explanations might assist whomever implements the feature)

Regards,
Adrien

> On Feb 25, 2018, at 11:48 AM, Adrien Monteleone  
> wrote:
> 
> 
> 
>> On Feb 25, 2018, at 9:33 AM, Fran_3  wrote:
>> 
>> The Vendor Report works great so long as we manually post each vendor bill 
>> and then use the Business Features to Process Payment.
>> 
>> I was looking for a way to automate some of that using Scheculed 
>> Transactions... ditto for Invoices to our Customers who are invoiced on the 
>> first of every month for the same amount each month.
>> 
>> But automatic transactions will not associate a customer or a vendor with 
>> the transaction... just the appropriate accounts in the chart of accounts
>> 
>> like for a vendor...
>> 
>> Credit AP, Debit Expenses
>> Debit AP, Credit Checking
>> 
>> or for a customer...
>> 
>> Debit AP, Credit Sales
>> Credit AP, Debit Checking
>> 
>> No worries, We can use the "duplicate" bill or invoice feature to do that 
>> and maybe use the Scheduled Transactions only as a reminder.
> 
> That’s probably the easiest solution for now. It would be a nice feature 
> enhancement though, certainly file it if you get the chance.
> 
>> 
>> Thanks,
>> 
>> Fran3
>> 
>> 
>> 
>> 
>> 
>> 
>> On Sunday, February 25, 2018, 2:18:28 AM EST, Adrien Monteleone 
>>  wrote:
>> 
>> 
>> Does the Vendor Report not give you the info you’re looking for without 
>> involving scheduled transactions? That report shows a full history of bills 
>> and payments for a particular vendor over whatever time period you run the 
>> report for. (that is, bills and payments run through the business features 
>> or properly imported)
>> 
>> Regards,
>> Adrien
>> 
>>> On Feb 24, 2018, at 4:40 PM, Fran_3 via gnucash-user 
>>>  wrote:
>>> 
>>> It seems when you do a "scheduled transaction" there is no way to relate it 
>>> to a vendor... right?
>>> Asking because we like to be able to track how much we paid to Vendor A, 
>>> Vendor B, etc.
>>> Electric Bill for example... With a "Scheduled Transaction" you could 
>>> schedule...
>>> 1 - Credit AP and Debit Utilities Electric
>>> then maybe the next day
>>> 2 - Debit AP and Credit Checking
>>> But there seems no way to affiliate it to the Electric Company as would 
>>> happen if you Created and Posted a Vendor Bill then "Paid" the Bill.
>>> Right? or did I miss something?
>>> Thanks for the help.
>>> Fran
>>> 
>>> 
>>> ___
>>> 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: GnuCash 2.7.5 Released

[John Ralls]

And BTW SourceForge is down right now so if you're in a hurry to download use 
the Github links.

Regards,
John Ralls


> On Feb 25, 2018, at 1:03 PM, John Ralls  wrote:
> 
> 
> The Gnucash Development Team is pleased to release Gnucash 2.7.5, the sixth 
> release of an unstable series leading to Gnucash 3.0
> 
> Notice that we've decided that beginning with the upcoming major release we 
> will use two-digit release numbers and that the next stable release will be 
> 3.0. Maintenance releases will be 3.1, 3.2, etc. The next unstable release 
> will be 3.900 and will lead to 4.0.
> 
> This release is UNSTABLE and SHOULD NOT BE USED in production.
> 
> This release changes file locations, binding APIs, report options, and can 
> make your data file no longer compatible with previous versions. See the 
> Update Notes Page for details.
> 
> See the KNOWN PROBLEMS list at the bottom of the announcement.
> New Features for Users
> 
>  * Locate all user data and configuration files to platform-dependent 
> standard locations:
>  * Windows: CSIDL_APPDATA/Gnucash
>  * MacOS: $HOME/Library/Application Support/Gnucash
>  * Linux: $XDG_CONFIG_HOME/gnucash (or the default $HOME/.config/gnucash)
>GnuCash currently uses the following files in this directory:
>log.conf (to set what gets logged to gnucash.trace)
>config-user.scm (to add custom scheme code like custom reports; 
> replaces config.user and config-.user)
>gtk-3.0.css (For theming)
>On Windows and with the MacOS Gnucash.app we distribute the files will 
> already be in the correct locations; users will  
>need to rename any config*.user files to config.scm. On other platforms 
> except MacOS, where those files were previously 
>stored in $HOME/.gnucash, GnuCash will move log.conf (if it exists) and 
> the most recent config*.user, renaming the 
>latter, automatically. MacOS installations other than our Gnucash.app 
> bundle will have their data and configuration 
>files in $HOME/.gnucash but users will have to copy the files to 
> $HOME/Library/Application Support/Gnucash themselves.
>  * Further improvements to the Transaction and Income-GST-statement reports.
>  * Transaction Report: omit display of $0 in subtotals in other currencies. 
> Previously in dual-subtotal columns, the dual-
>subtotal would attempt to print all commodities in the row. This meant if 
> user chose common-currency thereby triggering 
>additional commodities, the dual-subtotal would attempt to add amounts in 
> other commodities which would be 0, and 
>display the 0 amount.
> 
> For Developers and Distro packagers:
> 
>  * Some cruft removal in libgnucash/scm plus moving some code to its only use 
> location. "main.scm" is renamed to 
>"utilities.scm".
>  * The "printf" family of Scheme custom functions is replaced with the 
> built-in "format" facility.
>  * Change a generally unnecessary warning about being unable to open a module 
> (usually because the file is still being 
>created) to a debug message. It appears mostly during highly parallel 
> builds and was distracting.
>  * Added dependency information to all CMake targets, replacing a dependency 
> on build order that was carried over from 
>autotools. Highly parallel builds in ninja now complete without 
> interuption.
>  * Ensure that all GtkBuilder and GtkUIManager files are correctly installed 
> and that no configuration of build products in 
>those directories are.
>  * Appstream configuration is updated to the latest spec.
>  * Fix installation of a gnucash-only gschemas.compiled overwriting the 
> system one. Note that if you install to a DESTDIR 
>you'll need to re-run glib-compile-scemas after moving the contents of 
> $DESTDIR$PREFIX/share/glib-2.0/schemas to 
>$PREFIX.
>  * Added two functions to the Scheme option API:
>  * gnc:option-make-internal! will hide an existing option. e.g. a derived 
> report can set the value for a Display/* 
>option and hide it from the user.
>  * gnc:unregister-option will unregister option. This is primarily useful 
> for derived options e.g. another report 
>copies from transaction.scm and removes some options and recreates 
> them with different parameters.
>For example, unregister existing option from section "Accounts" name 
> "Accounts", and recreate with different parameters 
>e.g. limited account types.
> 
> Bugs fixed in this release
> 
>  * Bug 787095 - Gnucash Crashes when opening old XML file.
>  * Bug 792157 - Cannot create account with different currency
>  * Bug 792833 - User specifies source of 'num' field'; either transaction 
> number or split action (requires at least GnuCash 
> 2.5.0) Strip leading delimiters from KVP keys when reading 
> them from the database. Leading delimiters are 
> incorrectly included in databases created with GnuCash 2.6.x.
>  * Bug 792883 - cmake: no way to turn 

GnuCash 2.7.5 Released

[John Ralls]

The Gnucash Development Team is pleased to release Gnucash 2.7.5, the sixth 
release of an unstable series leading to Gnucash 3.0

Notice that we've decided that beginning with the upcoming major release we 
will use two-digit release numbers and that the next stable release will be 
3.0. Maintenance releases will be 3.1, 3.2, etc. The next unstable release will 
be 3.900 and will lead to 4.0.

This release is UNSTABLE and SHOULD NOT BE USED in production.

This release changes file locations, binding APIs, report options, and can make 
your data file no longer compatible with previous versions. See the Update 
Notes Page for details.

See the KNOWN PROBLEMS list at the bottom of the announcement.
New Features for Users

  * Locate all user data and configuration files to platform-dependent standard 
locations:
  * Windows: CSIDL_APPDATA/Gnucash
  * MacOS: $HOME/Library/Application Support/Gnucash
  * Linux: $XDG_CONFIG_HOME/gnucash (or the default $HOME/.config/gnucash)
GnuCash currently uses the following files in this directory:
log.conf (to set what gets logged to gnucash.trace)
config-user.scm (to add custom scheme code like custom reports; 
replaces config.user and config-.user)
gtk-3.0.css (For theming)
On Windows and with the MacOS Gnucash.app we distribute the files will 
already be in the correct locations; users will  
need to rename any config*.user files to config.scm. On other platforms 
except MacOS, where those files were previously 
stored in $HOME/.gnucash, GnuCash will move log.conf (if it exists) and the 
most recent config*.user, renaming the 
latter, automatically. MacOS installations other than our Gnucash.app 
bundle will have their data and configuration 
files in $HOME/.gnucash but users will have to copy the files to 
$HOME/Library/Application Support/Gnucash themselves.
  * Further improvements to the Transaction and Income-GST-statement reports.
  * Transaction Report: omit display of $0 in subtotals in other currencies. 
Previously in dual-subtotal columns, the dual-
subtotal would attempt to print all commodities in the row. This meant if 
user chose common-currency thereby triggering 
additional commodities, the dual-subtotal would attempt to add amounts in 
other commodities which would be 0, and 
display the 0 amount.

For Developers and Distro packagers:

  * Some cruft removal in libgnucash/scm plus moving some code to its only use 
location. "main.scm" is renamed to 
"utilities.scm".
  * The "printf" family of Scheme custom functions is replaced with the 
built-in "format" facility.
  * Change a generally unnecessary warning about being unable to open a module 
(usually because the file is still being 
created) to a debug message. It appears mostly during highly parallel 
builds and was distracting.
  * Added dependency information to all CMake targets, replacing a dependency 
on build order that was carried over from 
autotools. Highly parallel builds in ninja now complete without interuption.
  * Ensure that all GtkBuilder and GtkUIManager files are correctly installed 
and that no configuration of build products in 
those directories are.
  * Appstream configuration is updated to the latest spec.
  * Fix installation of a gnucash-only gschemas.compiled overwriting the system 
one. Note that if you install to a DESTDIR 
you'll need to re-run glib-compile-scemas after moving the contents of 
$DESTDIR$PREFIX/share/glib-2.0/schemas to 
$PREFIX.
  * Added two functions to the Scheme option API:
  * gnc:option-make-internal! will hide an existing option. e.g. a derived 
report can set the value for a Display/* 
option and hide it from the user.
  * gnc:unregister-option will unregister option. This is primarily useful 
for derived options e.g. another report 
copies from transaction.scm and removes some options and recreates them 
with different parameters.
For example, unregister existing option from section "Accounts" name 
"Accounts", and recreate with different parameters 
e.g. limited account types.

Bugs fixed in this release

  * Bug 787095 - Gnucash Crashes when opening old XML file.
  * Bug 792157 - Cannot create account with different currency
  * Bug 792833 - User specifies source of 'num' field'; either transaction 
number or split action (requires at least GnuCash 
 2.5.0) Strip leading delimiters from KVP keys when reading 
them from the database. Leading delimiters are 
 incorrectly included in databases created with GnuCash 2.6.x.
  * Bug 792883 - cmake: no way to turn off -Werror Prepend settings to 
CMAKE_C_FLAGS and CMAKE_CXX_FLAGS so that values 
 supplied on the command line can override the fixed settings.
  * Bug 792884 - cmake: gschemas.compiled missing
  * Bug 793122 - 2.7.3: ninja build fails.
  * Bug 793155 - Gnucash 2.7.4 crashes on launch MacOS 10.13.4 PB1
  * Bug 

Re: Testing my installation

[John Ralls]

Last warning: Copy the list on all replies. I won't reply again unless you do.

Please see 
https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F

Regards,
John Ralls


> On Feb 25, 2018, at 12:00 PM, Curtis Frizzell  wrote:
> 
> I get this error message when I try to get quotes for Trimble stock on Nasdaq:
> 
> "There was an unknown error while retrieving the price quotes."
> 
> I am using Windows 7, Firefox 58 and I have installed and enabled 
> Finance::Quote.
> I've done the stock setup as per the gnucash.org setup guide. Some of those 
> settings i'm not sure about.
> I also tried many different settings with no luck.
> 
> The guide suggested running gnc-fq-dump.
> 
> 
> 
> Curtis Frizzell
> 
> 569 Turk Rd.  
>   
> Grafton, Ontario  
> Canada
> K0K 2G0  
> 
> Home:  905-344-5956
> Email: ctech1...@gmail.com
> 
> 
> 
> 
> On Sun, Feb 25, 2018 at 1:26 PM, John Ralls  wrote:
> Please remember to copy the list on all replies.
> 
> 
> That would depend upon the operating system you're using, and you haven't 
> said., If you're completely new to command-line use then perhaps you should 
> explain what problem you're trying to solve as well.
> 
> Regards,
> John Ralls
> 
> 
> > On Feb 25, 2018, at 9:51 AM, Curtis Frizzell  wrote:
> >
> > Thanks John,
> > I am completely new at this.
> >
> > What is the command line and syntax I use in Perl?
> >
> >
> > Curtis Frizzell
> >
> > 569 Turk Rd.
> > Grafton, Ontario
> > Canada
> > K0K 2G0
> >
> > Home:  905-344-5956
> > Email: ctech1...@gmail.com
> >
> >
> >
> >
> > On Sat, Feb 24, 2018 at 7:15 PM, John Ralls  wrote:
> > Perl.
> >
> > Regards,
> > John Ralls
> >
> >
> > > On Feb 24, 2018, at 11:53 AM, Curtis Frizzell  wrote:
> > >
> > > What do I use to run the gnc-fq-dump file?
> > >
> > > --
> > > Curtis Frizzell
> > >
> > > 569 Turk Rd, Grafton, ON, K0K 2G0
> > > email: ctech1...@gmail.com
> > > phone: 905-344-5956
> > >
> > > ___
> > > 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: General Ledger

[Dave H]

Thanks for explaining the distinction Michael.

So I take from all this that the General Journal/General Ledger distinction
is an historical distinction no longer in real use with the advent of
computerised accounting software.  It still doesn't explain for me why the
intent is to rename everything that says General Ledger to General Journal
when General Ledger appears to be the more widely used terminology, at
least in my world.  I work in a large organisation with multiple branches
and many system users having a large Finance Section using dedicated
financial software who will only refer to the "General Ledger", hence my
confusion :-)

Cheers Dave H.


On 26 February 2018 at 02:34, Mike or Penny Novack <
stepbystepf...@dialup4less.com> wrote:

> On 2/24/2018 4:54 PM, Dave H wrote:
>
>> Well from my point of view that is confusing.  Nobody in my world refers
>> to
>> a "General Journal" we refer to the "General Ledger" and we do journals
>> :-)  I've never actually heard the term general journal used anywhere
>> before until this discussion over the weekend !!!
>>
>> Cheers Dave H.
>>
>
> Old time distinction (not that long ago, within my lifetime)
>
> In the really old days (hundreds of years ago) there would be just one
> journal into which all transactions of the enterprise would have been
> entered in chronological order. But as enterprises grew in size and
> complexity, this became burdensome. Can you imagine a merchant enterprise
> that might have thousands of sales a day (perhaps spread over a dozen
> stores). How could some poor bookkeeper get those entered into a single
> journal.
>
> Imagine a solution where at each store was a journal to record the sales
> transaction (a subsidiary journal) while at company headquarters a main
> journal maintained by the company bookkeeper. Call that journal the
> "general journal". So at the agreed time interval (every day, every week,
> etc.) the bookkeeper at each store would transmit a single transaction to
> headquarters (total receipts, total sales) and the head bookkeeper would
> enter those transactions into the "general journal". Things like "petty
> cash" might have their own journal (and ledger) and once a month a
> transaction to "general journal" to the totals of each account and the
> replenishment of cash. Notice that this also allowed restriction of access
> to the main books. The clerks in each store only could access the local
> books.
>
> The term "general journal" (and "general ledger") refer to the MAIN books.
> The confusion for you is that most of us using gnucash are doing so for
> small enough enterprises that we don't need to partition the books this
> way. The only ledger IS the "general ledger" (no subsidiary ledgers) and
> the journal is virtual in any case. We do enter the transaction (and then
> post it) but in effect enter it on already posted form in the ledger an the
> computer can figure out what would have been the journal entry that
> resulted in this. The developers COULD have chosen to have us enter
> transactions into a journal and have the computer auto post those to the
> ledger, but most of us would have found that less direct in terms of
> looking at stuff.
>
> BUT (and this is an important but) perhaps many who are asking for
> "multiple people simultaneously accessing gnucash books" are doing so
> because "too much work for one person" don't know the history, how this WAS
> handled with subsidiary books and gnucash could easily handle it that way.
> With the added benefits that the "local bookkeepers" (the clerks in the
> stores, etc.) can enter the transactions without having access to the main
> books and that main books can avoid the clutter of unnecessary details.
>
> Michael D Novack
>
> Michael D Novack
>
>
>
> ___
> 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: Scheduled Vendor Bills vs Schedule Transactions

[Adrien Monteleone]

> On Feb 25, 2018, at 9:33 AM, Fran_3  wrote:
> 
> The Vendor Report works great so long as we manually post each vendor bill 
> and then use the Business Features to Process Payment.
> 
>  I was looking for a way to automate some of that using Scheculed 
> Transactions... ditto for Invoices to our Customers who are invoiced on the 
> first of every month for the same amount each month.
> 
> But automatic transactions will not associate a customer or a vendor with the 
> transaction... just the appropriate accounts in the chart of accounts
> 
>  like for a vendor...
> 
> Credit AP, Debit Expenses
> Debit AP, Credit Checking
> 
> or for a customer...
> 
> Debit AP, Credit Sales
> Credit AP, Debit Checking
> 
> No worries, We can use the "duplicate" bill or invoice feature to do that and 
> maybe use the Scheduled Transactions only as a reminder.

That’s probably the easiest solution for now. It would be a nice feature 
enhancement though, certainly file it if you get the chance.

> 
> Thanks,
> 
> Fran3
> 
> 
> 
> 
> 
> 
> On Sunday, February 25, 2018, 2:18:28 AM EST, Adrien Monteleone 
>  wrote:
> 
> 
> Does the Vendor Report not give you the info you’re looking for without 
> involving scheduled transactions? That report shows a full history of bills 
> and payments for a particular vendor over whatever time period you run the 
> report for. (that is, bills and payments run through the business features or 
> properly imported)
> 
> Regards,
> Adrien
> 
> > On Feb 24, 2018, at 4:40 PM, Fran_3 via gnucash-user 
> >  wrote:
> > 
> > It seems when you do a "scheduled transaction" there is no way to relate it 
> > to a vendor... right?
> > Asking because we like to be able to track how much we paid to Vendor A, 
> > Vendor B, etc.
> > Electric Bill for example... With a "Scheduled Transaction" you could 
> > schedule...
> > 1 - Credit AP and Debit Utilities Electric
> > then maybe the next day
> > 2 - Debit AP and Credit Checking
> > But there seems no way to affiliate it to the Electric Company as would 
> > happen if you Created and Posted a Vendor Bill then "Paid" the Bill.
> > Right? or did I miss something?
> > Thanks for the help.
> > Fran
> > 
> > 
> > ___
> > 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: Confused by "Reverse"

[Adrien Monteleone]

> On Feb 25, 2018, at 7:16 AM, Stan Brown  wrote:
> 
> 
> Adrien, thanks for replying, but I'm talking about a problem in a
> report.  Please see below.
> 
> -- 
> Regards,
> Stan Brown
> Tompkins County, New York, USA
> http://BrownMath.com
> http://OakRoadSystems.com
> 
> 
> On 2018-02-25 02:43, Adrien Monteleone wrote:
>> 
>> 
>>> On Feb 24, 2018, at 6:51 PM, Stan Brown  wrote:
>>> 
>>> On 2018-02-24 14:09, Adrien Monteleone wrote:
 Set that preference for Reverse Balanced Accounts to ‘credit’.
>>> 
>>> Yes, that's what I did. As I said, it fixed the Balance Sheet, but it
>>> broke the General Ledger.
>> 
>> If you mean the General Ledger register under Tools menu, mine looks just 
>> fine - everything is positive as I expect it to be.
> 
> No, I don't mean that.  I know there are multiple things with similar
> names, so I wrote:
> 
> "but I can't find any way to have it in both the Assets & Liabilities »
> Balance Sheet report and the Assets & Liabilities » General Ledger report."
> 
> Everything is fine in the General Ledger _tool_ (at least with respect
> to this issue). It's one of those two _reports_ that has the problem.
> 
>> If you mean the General Ledger Report under the Assets & Liabilities reports 
>> menu, there’s a report specific option to reverse the sign for Credit 
>> Accounts (as well as Income/Expense) just for that report, but that only 
>> seems to work for the final total for each account, not the running balances.
>> 
>>> BTW, why should we have to set "Reverse Credit Accounts" to get a report
>>> such as Balance Sheet NOT to reverse them? It seems something is
>>> backward there.
>> 
>> You don’t. The ‘normal balance’ of Credit Accounts is negative. 
>> (Liabilities, Equity & Revenue) If you don’t set that option, they show up 
>> as negative (individually) on the Balance Sheet. If you want to Reverse 
>> Balance those accounts, then set the option, and they’ll show up as 
>> positive. (the opposite, or reverse of their ‘normal’ balance)
> 
> Okay, I understand now, but I definitely did not get that from the
> documentation. In fact, if I'm not mistaken, the documentation goes the
> other way, saying that a credit to a liability account increases the
> account balance and a debit reduces the balance. That matches how I
> learned it when I worked for an accounting firm.

Both the documentation and your experience are correct.

A credit to a liability increases that liability. ‘Increase’ does not 
necessarily mean ‘larger in the positive direction from zero’. In the case of a 
liability, it means ‘larger in the negative direction from zero’. The same goes 
for Equity and Income(Revenue), all of which are ‘credit’ balanced accounts, 
that is, accounts whose normal balance is a net credit.

This discussion is an example of why the preference is offered in the first 
place. Most people can usually wrap their heads around a liability increasing 
by becoming a larger negative number but they can have a difficult time with 
Equity and Revenue. Generally you’d think of receiving more money as a positive 
and retaining earnings as a positive and retaining losses as a negative. But 
the signs in this case have everything to do with what side of the accounting 
equation the accounts lie on, not their psychological meaning.
> 
> If it's a programming convenience to have all liability, equity, and
> income accounts negative, I guess I can sort of see that. And I can
> reverse that in Edit » Preferences, so it's a one-time adjustment. 

It is somewhat of a programming convenience, but even before computers the 
accounting equation could be written different ways. I was originally taught it 
looked like this:

Assets = Liabilities + Equity

or expanded:

Assets = Liabilities + (Revenue - Expenses)

But you can also write it this way (and this form was also in my textbook):

Assets - Liabilities - (Revenue - Expenses) = 0

If you distribute the signs and change all the operands to addition, you get 
this:

Assets + (-Liabilities) + (-Revenue) + Expenses = 0

If Revenue is a larger absolute value than expenses the shortened form is this:

Assets + (-Liabilities) + (-Equity) = 0

If Expenses were a larger absolute value (a retained loss) then Equity would be 
‘contra balanced’ and thus have a positive sign:

Assets + (-Liabilities) + Equity = 0


So if you set the preference to ‘reverse balance accounts’ as ‘credit accounts’ 
than those which are normally ‘negative’ signed will be positive signed 
instead. Increasing any account in your tree will lead to a ‘larger from zero 
in the positive direction’ value. (but those accounts still have more value in 
credits than debits)

With this setting, only those accounts which are normally contra-balanced are 
shown as negatives, e.g.—

Assets:
Allowance for Doubtful Accounts
Accumulated Depreciation/Depletion
Reserve for Obsolete Inventory

Liabilities:
Discount on Bonds/Notes Payable
Bond/Debt 

Re: General Ledger

[Mike or Penny Novack]

On 2/24/2018 4:54 PM, Dave H wrote:

Well from my point of view that is confusing.  Nobody in my world refers to
a "General Journal" we refer to the "General Ledger" and we do journals
:-)  I've never actually heard the term general journal used anywhere
before until this discussion over the weekend !!!

Cheers Dave H.


Old time distinction (not that long ago, within my lifetime)

In the really old days (hundreds of years ago) there would be just one 
journal into which all transactions of the enterprise would have been 
entered in chronological order. But as enterprises grew in size and 
complexity, this became burdensome. Can you imagine a merchant 
enterprise that might have thousands of sales a day (perhaps spread over 
a dozen stores). How could some poor bookkeeper get those entered into a 
single journal.


Imagine a solution where at each store was a journal to record the sales 
transaction (a subsidiary journal) while at company headquarters a main 
journal maintained by the company bookkeeper. Call that journal the 
"general journal". So at the agreed time interval (every day, every 
week, etc.) the bookkeeper at each store would transmit a single 
transaction to headquarters (total receipts, total sales) and the head 
bookkeeper would enter those transactions into the "general journal". 
Things like "petty cash" might have their own journal (and ledger) and 
once a month a transaction to "general journal" to the totals of each 
account and the replenishment of cash. Notice that this also allowed 
restriction of access to the main books. The clerks in each store only 
could access the local books.


The term "general journal" (and "general ledger") refer to the MAIN 
books. The confusion for you is that most of us using gnucash are doing 
so for small enough enterprises that we don't need to partition the 
books this way. The only ledger IS the "general ledger" (no subsidiary 
ledgers) and the journal is virtual in any case. We do enter the 
transaction (and then post it) but in effect enter it on already posted 
form in the ledger an the computer can figure out what would have been 
the journal entry that resulted in this. The developers COULD have 
chosen to have us enter transactions into a journal and have the 
computer auto post those to the ledger, but most of us would have found 
that less direct in terms of looking at stuff.


BUT (and this is an important but) perhaps many who are asking for 
"multiple people simultaneously accessing gnucash books" are doing so 
because "too much work for one person" don't know the history, how this 
WAS handled with subsidiary books and gnucash could easily handle it 
that way. With the added benefits that the "local bookkeepers" (the 
clerks in the stores, etc.) can enter the transactions without having 
access to the main books and that main books can avoid the clutter of 
unnecessary details.


Michael D Novack

Michael D Novack


___
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: Scheduled Vendor Bills vs Schedule Transactions

[Fran_3 via gnucash-user]

 The Vendor Report works great so long as we manually post each vendor bill and 
then use the Business Features to Process Payment.

 I was looking for a way to automate some of that using Scheculed 
Transactions... ditto for Invoices to our Customers who are invoiced on the 
first of every month for the same amount each month.
But automatic transactions will not associate a customer or a vendor with the 
transaction... just the appropriate accounts in the chart of accounts
 like for a vendor...
Credit AP, Debit ExpensesDebit AP, Credit Checking
or for a customer...
Debit AP, Credit SalesCredit AP, Debit Checking
No worries, We can use the "duplicate" bill or invoice feature to do that and 
maybe use the Scheduled Transactions only as a reminder.
Thanks,
Fran3





On Sunday, February 25, 2018, 2:18:28 AM EST, Adrien Monteleone 
 wrote:  
 
 Does the Vendor Report not give you the info you’re looking for without 
involving scheduled transactions? That report shows a full history of bills and 
payments for a particular vendor over whatever time period you run the report 
for. (that is, bills and payments run through the business features or properly 
imported)

Regards,
Adrien

> On Feb 24, 2018, at 4:40 PM, Fran_3 via gnucash-user 
>  wrote:
> 
> It seems when you do a "scheduled transaction" there is no way to relate it 
> to a vendor... right?
> Asking because we like to be able to track how much we paid to Vendor A, 
> Vendor B, etc.
> Electric Bill for example... With a "Scheduled Transaction" you could 
> schedule...
> 1 - Credit AP and Debit Utilities Electric
> then maybe the next day
> 2 - Debit AP and Credit Checking
> But there seems no way to affiliate it to the Electric Company as would 
> happen if you Created and Posted a Vendor Bill then "Paid" the Bill.
> Right? or did I miss something?
> Thanks for the help.
> Fran
> 
> 
> ___
> 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: Strange cookie appears when accessing this site...

[Derek Atkins]

Hi,

There is no Gnucash Forum Site.

Anything you may be using is operated by a third party, not by the Gnucash 
project.


Based on the tags in your email you appear to be using nabble.  Nabble is 
its own thing, not at all affiliated with Gnucash. If you have an issue 
with them you should contact them.  We cannot do anything for you.


Sorry.

-derek
Sent using my mobile device. Please excuse any typos.



On February 25, 2018 10:14:20 AM Steve  wrote:


I've been meaning to ask this for well over a year (if not longer), keep
forgetting about it; I did a search just now, but didn't get any hits...

Every single time I start the GnuCash User forum site (using Windows 10 Pro,
btw, Google Chrome), and this *only occurs* when I access the GnuCash User
forum site, I've noticed that a new *cookie* appears (if I delete it, it
reappears the next time I access the GnuCash User forum site)...

*http://www.super-resume.com/*

Any explanation??






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

Strange cookie appears when accessing this site...

[Steve]

I've been meaning to ask this for well over a year (if not longer), keep
forgetting about it; I did a search just now, but didn't get any hits...

Every single time I start the GnuCash User forum site (using Windows 10 Pro,
btw, Google Chrome), and this *only occurs* when I access the GnuCash User
forum site, I've noticed that a new *cookie* appears (if I delete it, it
reappears the next time I access the GnuCash User forum site)...

*http://www.super-resume.com/*

Any explanation??

 




--
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: Confused by "Reverse"

[Christopher Lam]

Hi Stan,

You are right, reports are not always consistent in offering consistent 
nor flexible options. They have been growing organically for nearly 2 
decades now, with no overriding benevolent dictator, and many cooks had 
had a hand in developing them.


The most flexible by far will always be the Transaction Report, and I'd 
think it could be bent to provide most transactional reports. But 
summary reports like the Balance Sheet haven't been modified (because 
there wasn't much demand I think).


If there is a particular case that you'd suggest an amendment, please 
file an enhancement in bugzilla!


C


On 25/02/18 01:36, Stan Brown wrote:

Using 2.6.18.

I want credit balances to be positive in liabilities, equities, and
income, and debit balances to be positive in assets and expenses. I'd
think this was standard, but I can't find any way to have it in both the
Assets & Liabilities » Balance Sheet report and the Assets & Liabilities
» General Ledger report. (The latter appears on a tab called Transaction
Report.)

In Edit » Preferences » Accounts, I set "Reverse Balanced Accounts" to
None, but then all my credit accounts we backwards in the Balance Sheet.
(Exception: Retained Earnings is not backwards.) There's no "Reverse"
option in Edit » Report Options, so I figure I must be misunderstanding
the setting in Edit » Preferences » Accounts, and change it to Credit
Accounts. That fixes the Balance Sheet, but now the amounts are
backwards in credit accounts in the General Ledger report (though the
totals of credit accounts in that report are not backwards). There's no
reversing option for that report either.

What am I doing wrong?



___
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: Confused by "Reverse"

[Stan Brown]

Adrien, thanks for replying, but I'm talking about a problem in a
report.  Please see below.

-- 
Regards,
Stan Brown
Tompkins County, New York, USA
http://BrownMath.com
http://OakRoadSystems.com


On 2018-02-25 02:43, Adrien Monteleone wrote:
> 
> 
>> On Feb 24, 2018, at 6:51 PM, Stan Brown  wrote:
>>
>> On 2018-02-24 14:09, Adrien Monteleone wrote:
>>> Set that preference for Reverse Balanced Accounts to ‘credit’.
>>
>> Yes, that's what I did. As I said, it fixed the Balance Sheet, but it
>> broke the General Ledger.
> 
> If you mean the General Ledger register under Tools menu, mine looks just 
> fine - everything is positive as I expect it to be.

No, I don't mean that.  I know there are multiple things with similar
names, so I wrote:

"but I can't find any way to have it in both the Assets & Liabilities »
Balance Sheet report and the Assets & Liabilities » General Ledger report."

Everything is fine in the General Ledger _tool_ (at least with respect
to this issue). It's one of those two _reports_ that has the problem.

> If you mean the General Ledger Report under the Assets & Liabilities reports 
> menu, there’s a report specific option to reverse the sign for Credit 
> Accounts (as well as Income/Expense) just for that report, but that only 
> seems to work for the final total for each account, not the running balances.
> 
>> BTW, why should we have to set "Reverse Credit Accounts" to get a report
>> such as Balance Sheet NOT to reverse them? It seems something is
>> backward there.
> 
> You don’t. The ‘normal balance’ of Credit Accounts is negative. (Liabilities, 
> Equity & Revenue) If you don’t set that option, they show up as negative 
> (individually) on the Balance Sheet. If you want to Reverse Balance those 
> accounts, then set the option, and they’ll show up as positive. (the 
> opposite, or reverse of their ‘normal’ balance)

Okay, I understand now, but I definitely did not get that from the
documentation. In fact, if I'm not mistaken, the documentation goes the
other way, saying that a credit to a liability account increases the
account balance and a debit reduces the balance. That matches how I
learned it when I worked for an accounting firm.

If it's a programming convenience to have all liability, equity, and
income accounts negative, I guess I can sort of see that. And I can
reverse that in Edit » Preferences, so it's a one-time adjustment. But
then a problem arises when the reports don't follow that.

Something you said earlier made me think you were thinking about
removing the General Ledger report. please don't -- I find it useful and
the General Journal report not so useful, not at this time anyway. I'd
just like to see the General Ledger Report follow the Edit » Preferences
setting for reversing signs of accounts.

>>> That’s the way I have mine set and every account with a ‘normal’ balance is 
>>> positive. Only contra-balanced accounts show negative.
>>
>> Not in General Ledger.  (I looked at General Journal, but I really
>> loathe the format, and since it doesn't have most options I can't fix it.)
> 
> As noted above, for that report, the total should have the correct sign, 
> though the running balance amounts will always be negative. (not sure why 
> that is) So with the setting set to ‘none’ you’d have a negative credit 
> account balance under a normal circumstance. (that is, Liabilities, Equity & 
> Revenue) But if you choose to reverse that balance, those will all show as 
> positive.


 On Feb 24, 2018, at 11:36 AM, Stan Brown  
 wrote:

 Using 2.6.18.

 I want credit balances to be positive in liabilities, equities, and
 income, and debit balances to be positive in assets and expenses. I'd
 think this was standard, but I can't find any way to have it in both the
 Assets & Liabilities » Balance Sheet report and the Assets & Liabilities
 » General Ledger report. (The latter appears on a tab called Transaction
 Report.)

 In Edit » Preferences » Accounts, I set "Reverse Balanced Accounts" to
 None, but then all my credit accounts we backwards in the Balance Sheet.
 (Exception: Retained Earnings is not backwards.) There's no "Reverse"
 option in Edit » Report Options, so I figure I must be misunderstanding
 the setting in Edit » Preferences » Accounts, and change it to Credit
 Accounts. That fixes the Balance Sheet, but now the amounts are
 backwards in credit accounts in the General Ledger report (though the
 totals of credit accounts in that report are not backwards). There's no
 reversing option for that report either.

___
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 

Re: Reports balance sheet - with explicit dual currency for "$"

[Wm via gnucash-user]

On 24/02/2018 18:05, Vin Ordinaire wrote:


Dollars are great - pick one of many flavours
USD,CAN,AUD,HKG,Bermuda,Singapore and about 10 others.

The problem is reporting a balance sheet multiple currency assets.  I
located in the Windows version Options>Commodities>Show Foreign Currencies
that does indeed show the "other" value in whatever currency I post the
asset in.

However, when pairing USD,CAN,AUD,HKG,Bermuda,Singapore and about 10 others,
the "$" is highly ambiguous and confusing. I pair AUD, USD and HKG and have
assets in all three currencies.   Is there a way (or in the future) for
Reports to have a check box "Explicitly show  iso-4217 currency designation"
to show side by side in the reports like this under assets:

Widgit $HKG 8000   $USD 12000
Bluto  $AUD 1000   $USD 770

Overall a great alternative to Quicken and its bloatware and its behind the
scenes business deals with banks to restrict access to data for users (and
why most US banks do not widely use OFX and have plenty of data as opposed
to say 90 days) - I suppose license fees, subscription and captivity play a
huge role in this.

Ideas and apologies in advance if this is a newbie RTFM type question,
though I see Frédéric Perrin and Derek Atkins and others having a dialogue.



If I understand your query correctly you can edit the symbols via
Tools / Security editor (make sure you have "Show national currencies" 
ticked / Currencies


you can change them to anything you want.  I think most people use the 3 
letter symbols rather relying on the $


--
Wm
time passes while mods ponder

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