Re: Confused by "Reverse"

[Adrien Monteleone]

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

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)

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

Also, don’t forget to copy the list on all replies.

Regards,
Adrien

> 
>>> 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.
> 
> -- 
> Regards,
> Stan Brown
> Tompkins County, New York, USA
> http://BrownMath.com
> http://OakRoadSystems.com



Regards,
Adrien

___
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: Reports balance sheet - with explicit dual currency for "$"

[Adrien Monteleone]

Not sure why you aren’t seeing it properly with that setting.

I have some dollars from both Canada and the Bahamas and both accounts show the 
foreign and US currency amounts.

Canada shows up as C$, and Bahamas as B$ and U.S. as just “$”.

All of the foreign currencies are in the left column and US$ in the right 
column so I don’t see what the confusion would be.

Perhaps I’m not understanding what you mean by ‘pair’ with respect to 
currencies.

Regards,
Adrien

> On Feb 24, 2018, at 12:05 PM, 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.  
> 
> 
> 
> 
> 
> 
> --
> 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: Scheduled Vendor Bills vs Schedule Transactions

[Adrien Monteleone]

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.

Re: Testing my installation

[John Ralls]

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.

Testing my installation

[Curtis Frizzell]

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.

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

[Vin Ordinaire]

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.  






--
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: Date changes

[parakrama]

Hi Brown

It seems to be working.

Thank you for supporting. 


Parakrama Weerasinghe

-Original Message-
From: Stan Brown [mailto:the_stan_br...@fastmail.fm] 
Sent: Wednesday, February 21, 2018 6:39 AM
To: parakr...@theacetechnologies.com
Cc: GnuCash User List 
Subject: Re: Date changes


On 2018-02-19 09:22, parakr...@theacetechnologies.com wrote:

> I downloaded Gnucash on 17th and tried to record transactions from 
> last year. However I found that the system does not show any date 
> before YESTERDAY, 17TH February 2018.
> 
> My requirement is to record transaction from July 2017 and update upto 
> now
> 
> Can someone tell me how to record backdated transactions and use it?
Hi. New user here, but I'll jump in.

I'm not sure what you mean by "does not show any date before". When you enter 
transactions, you ENTER a date. Sure, it shows you a date by default, but don't 
have to use that. Just highlight the date shown, and enter 2017-07-15 or 
whatever (in your date format).

There's a nice shortcut. In Edit » Preferences, on the Date/Tie tab, select the 
last radio button, "in a sliding 12-month window" and select
8 for "this many months before the current month." Then you can enter a date as 
7-15 (for example, but use your format) and it will supply 2017 because the 
"window" runs from 8 months before now to 4 months after now.

--
Regards,
Stan Brown
Tompkins County, New York, USA
http://BrownMath.com
http://OakRoadSystems.com>
>  
> 
>  
> 
> Parakrama Weerasinghe
> 
> ___
> 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

[Derek Atkins]

Sorry, no way to schedule an invoice or vendor bill.. Or a payment thereof.

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



On February 24, 2018 5:41:18 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.

Re: General Ledger

[Dave H]

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.

On 24 February 2018 at 19:58, Geert Janssens 
wrote:

> Op zaterdag 24 februari 2018 00:46:07 CET schreef David Carlson:
> > This thread seems like deja vu to me.  I thought this was discussed
> before
> > and the result was that GnuCash changed the name of one or the other in
> > release 2.6.18 or thereabouts.
> >
> > Am I dreaming?
> >
> > David C
> >
>
> You're not dreaming. This has been discussed before and there was even a
> bugreport for it:
> https://bugzilla.gnome.org/show_bug.cgi?id=122895
>
> I have personally applied all the required changes to use "General Journal"
> consistently in GnuCash. This fix was applied in February 2015. However as
> this affected many translatable strings, I decided back then to fix this
> only
> on master (to become 3.0 soon). So gnucash 2.6 will still use the term
> "General Ledger".
>
> And looking further I have found I then mixed things up in October 2015:
> after
> some discussion I have started changing the term in the stable
> documentation
> as well (2.6.x). So we're now in the unfortunate situation the application
> still uses the term General Ledger and the associated documentation uses
> the
> term General Journal.
>
> I have reverted these unintended corrections on the 2.6 documentation so
> the
> last 2.6.x release will still consistently use the old "General Ledger"
> term
> and 3.0 will consistently switch to "General Journal".
>
> Sorry for the confusion this created.
>
> Regards,
>
> Geert
>
> > On Fri, Feb 23, 2018 at 3:52 PM, Buddha Buck 
> wrote:
> > > I suspect that GnuCash terminology regarding journals and ledgers is
> > > somewhat confused and non-standard.
> > >
> > > My basic understanding of classical accounting is that transactions
> were
> > > first entered into journals, and then posted into ledgers, one per
> > > account.
> > > The collection of ledger books was the "general ledger", while the
> nominal
> > > time-ordered collection of journal entries was the "general journal"
> (or
> > > the "general journal" was the journal in which transactions which
> didn't
> > > belong in the sales journal, purchase journal, etc were recorded).
> > >
> > > In GnuCash terms, a classical account ledger would correspond to a
> GnuCash
> > > account register. And the classic general journal would correspond to
> > > GnuCash's general ledger. The classic general ledger might even be a
> > > GnuCash book as a whole. I don't know what GnuCash is calling a general
> > > journal.
> > >
> > >
> > >
> > >
> > > On Fri, Feb 23, 2018 at 1:43 PM Adrien Monteleone <
> > >
> > > adrien.montele...@gmail.com> wrote:
> > > > Stan,
> > > >
> > > > No I knew you were referring to the Ledger and I think David did also
> > > > though he linked to the help on the Journal.
> > > >
> > > > Unfortunately, it seems the Help file needs a tweak. (or the
> software)
> > >
> > > The
> > >
> > > > link he gives describes in fact, the General Ledger. The terminology
> on
> > >
> > > the
> > >
> > > > title and within the help article are inconsistent with the naming in
> > > > the
> > > > software. (though Journal is probably the more historically correct
> > > > term,
> > > > the two might be interchangeable)
> > > >
> > > > In the software, the General Journal is a report you can run that
> shows
> > > > ALL transactions. (under the Assets & Liabilities sub-menu) You can’t
> > >
> > > enter
> > >
> > > > anything into it. There is no date selector in the options, and the
> > >
> > > Filter
> > >
> > > > By… in View is not available.
> > > >
> > > > Since I don’t close books I see everything when I look at either.
> > > > Perhaps
> > > > someone who uses that procedure might see only the current accounting
> > > > period - I’m not sure.
> > > >
> > > > To add to the confusion, there is also a General Ledger report
> located
> > > > in
> > > > that same menu. However, it seems to be the same as the Transaction
> > >
> > > Report
> > >
> > > > and is much more versatile than the General Journal report.
> > > >
> > > > For the record, I don’t see any separate ‘tool’ or ‘register’ called
> > > > General Journal at least not in my copy of 2.6.19.
> > > >
> > > > Regards,
> > > > Adrien
> > > >
> > > > > On Feb 23, 2018, at 9:42 AM, Stan Brown <
> the_stan_br...@fastmail.fm>
> > > >
> > > > wrote:
> > > > > Thanks, Adrien.
> > > > >
> > > > > Please note that I asked about the general ledger, not the general
> > > >
> > > > journal, but I see that the filter works the same way (now that I
> know
> > > > to
> > > > try it).
> > > >
> > > > > As the documentation mentions only the general journal, maybe "and
> > > >
> > > > general ledger" should be 

Re: Confused by "Reverse"

[Adrien Monteleone]

Concerning the General Ledger report, I never run it so I don’t have an answer. 
Perhaps it has not been updated to account for the preference. (the Budget 
Report also doesn’t honor the setting)

Did you try the General Journal report? Perhaps it works correctly? (the two 
are nearly identical save for the extra options in the Ledger version)

Regards,
Adrien

> 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.
> 
> What am I doing wrong?
> 
> -- 
> Regards,
> Stan Brown
> Tompkins County, New York, USA
> http://BrownMath.com
> http://OakRoadSystems.com
> 
> ___
> 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]

Set that preference for Reverse Balanced Accounts to ‘credit’.

That’s the way I have mine set and every account with a ‘normal’ balance is 
positive. Only contra-balanced accounts show negative.

Note, you can play with this setting and the CoA should update in real time 
without having to exit the Preferences window.

Regards,
Adrien

> 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.
> 
> What am I doing wrong?
> 
> -- 
> Regards,
> Stan Brown
> Tompkins County, New York, USA
> http://BrownMath.com
> http://OakRoadSystems.com
> 
> ___
> 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: Using Online Banking features

[David Reiser]

> On Feb 23, 2018, at 5:32 PM, Ron Schnatzmeyer  wrote:
> 
> I've just set up GnuCash (Linux). I have all my accounts set up (a lot of 
> work). I have moved over all the data from Quicken (a lot more work) and 
> everything balances. I have gone through the online banking setup and can 
> connect to my bank just fine. The setup recognized the three accounts I have 
> this bank and I associated them to the corresponding GnuCash accounts. But 
> I'm excited and confused. It seems there is quite a bit of information about 
> setting up online banking but hardly anything on how to actually use it. When 
> I read GnuCash has online banking my expectation is that it would work 
> similar to Quicken?
> 
> So here I am just starting to use GnuCash:
> 
> 1) Now I want to send several bill payments to the bank. With Q, I setup the 
> online payees first and then just put 'send' in the check number to make a 
> payment. What do I do in GnuCash? How do I make payments?

The only banks from which you can make payments from within GnuCash are German 
banks. Quicken has no interest in working with open source developers to enable 
open source utilities to work with Quicken servers. While some small commercial 
‘competitors’ to Quicken have enabled online payments, the fees to Quicken and 
liability risks to developers from customer complaints are prohibitive.

> 
> 2) I have three separate accounts at the same bank. With Q, I just just click 
> on "Ron's Bank". It then downloads all the transactions and sends all the 
> payments for all three accounts at one time. How do I do that with GnuCash?

I don’t think you can do this in Gnucash because the link between aqbanking and 
gnucash is bound to one account at a time. I’m pretty sure you’ll have to visit 
each gnucash account in turn and download transactions from the bank 
repetitively. Either aqbanking only asks for transactions for one account at a 
time, or it is capable of sorting out the data from the download stream for the 
currently visible gnucash account register. It works for me with multiple Chase 
credit cards managed under a single online login.

> 
> 3) I have several scheduled online payments set up in Q. I set it up once and 
> then every month it automatically pays the same amount on the scheduled date. 
> I don't have to do anything else. How do I do that with GnuCash?

You can schedule transactions within Gnucash to record the data related to all 
these transactions, but you’ll have to set up the actual transactions with your 
financial institution or creditor for them to automatically trigger them. See 
the answer to #1.

> 
> I'd appreciate some help on how to use these online features.
> 
> Thanks.
> 
> 

--
Dave Reiser
dbrei...@icloud.com




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

Confused by "Reverse"

[Stan Brown]

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?

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

___
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: variable scheduled date

[Ronal B Morse]

Jean-David:  Does Red Hat have a virtual machine manager available for 
RHEL 6? I had a similar problem some years ago when I was tied to Debian 
Stable. My solution was to create a virtual machine running Debian 
Testing which supported newer versions of the applications I wanted to 
use.  Took care of dependencies without disturbing the integrity of the 
host machine.


RBM


On 02/24/2018 09:48 AM, Adrien Monteleone wrote:

True, the version in EPEL7 is 2.6.18, one version back, soon to be two versions 
back.

I too was wondering the issue, now I see that essentially, nothing ever gets 
back-ported for RHEL, so newer RPMs can’t pull in dependencies because they 
don’t exist in the older repositories. They can provide 10 years of support, 
because it’s essentially frozen.

Your experience and explanation makes me glad I never tried RHEL.

Regards,
Adrien


On Feb 24, 2018, at 7:45 AM, Jean-David Beyer  wrote:

On 02/23/2018 06:40 PM, David Carlson wrote:

I am lost in this thread.  I thought that the point of Linux was to use
RPMs to do the dirty work of installing the software.  In fedora that would
be "yum install gnucash".  Are you saying that does not work?

David C


Yes, it would not work because the server that would respond to yum is
the one Red Hat maintains to support (in my case) RHEL6. Were I running
RHEL7, it would get things from that. But in either case, Red Hat do not
support Gnucash (and do not support VLC), so I would need to download
the rpms from elsewhere. And it is not that easy because the rpm's will
not install unless all the dependencies are already there. And to get
them is almost impossible for most things.

When I downloaded VLC, for example, I needed a few libraries. I found
and downloaded some of those. They wanted more. Some of them needed
other libraries and they did not exist. So I had to get rid of some and
get other versions of those, and so on. It took over a week to get VLC
to work. And I was trying to install VLC because some other video player
(and mp3 player) stopped working.

The only way I got GnuCash to work is that it is not quite as
complicated as VLC, and the EPEL project has Gnucash in it. They do not
upgrade it though. They have a version that works, and that is that. The
EPEL for Gnucash in RHEL7 will not install in RHEL6, and I am not
prepared to upgrade my RHEL6 system just to get the latest Gnucash.
(Even were I to do that, there is no reason to believe that that version
of Gnucash would be the latest, though I suspect it would be more up to
date than what I now have.)



--
  .~.  Jean-David Beyer  Registered Linux User 85642.
  /V\  PGP-Key:166D840A 0C610C8B Registered Machine  1935521.
/( )\ Shrewsbury, New Jerseyhttp://linuxcounter.net
^^-^^ 08:35:01 up 29 days, 21:32, 2 users, load average: 4.64, 4.60, 4.37
___
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: variable scheduled date

[Adrien Monteleone]

True, the version in EPEL7 is 2.6.18, one version back, soon to be two versions 
back.

I too was wondering the issue, now I see that essentially, nothing ever gets 
back-ported for RHEL, so newer RPMs can’t pull in dependencies because they 
don’t exist in the older repositories. They can provide 10 years of support, 
because it’s essentially frozen.

Your experience and explanation makes me glad I never tried RHEL.

Regards,
Adrien

> On Feb 24, 2018, at 7:45 AM, Jean-David Beyer  wrote:
> 
> On 02/23/2018 06:40 PM, David Carlson wrote:
>> I am lost in this thread.  I thought that the point of Linux was to use
>> RPMs to do the dirty work of installing the software.  In fedora that would
>> be "yum install gnucash".  Are you saying that does not work?
>> 
>> David C
>> 
> 
> Yes, it would not work because the server that would respond to yum is
> the one Red Hat maintains to support (in my case) RHEL6. Were I running
> RHEL7, it would get things from that. But in either case, Red Hat do not
> support Gnucash (and do not support VLC), so I would need to download
> the rpms from elsewhere. And it is not that easy because the rpm's will
> not install unless all the dependencies are already there. And to get
> them is almost impossible for most things.
> 
> When I downloaded VLC, for example, I needed a few libraries. I found
> and downloaded some of those. They wanted more. Some of them needed
> other libraries and they did not exist. So I had to get rid of some and
> get other versions of those, and so on. It took over a week to get VLC
> to work. And I was trying to install VLC because some other video player
> (and mp3 player) stopped working.
> 
> The only way I got GnuCash to work is that it is not quite as
> complicated as VLC, and the EPEL project has Gnucash in it. They do not
> upgrade it though. They have a version that works, and that is that. The
> EPEL for Gnucash in RHEL7 will not install in RHEL6, and I am not
> prepared to upgrade my RHEL6 system just to get the latest Gnucash.
> (Even were I to do that, there is no reason to believe that that version
> of Gnucash would be the latest, though I suspect it would be more up to
> date than what I now have.)
> 
> 
> 
> -- 
>  .~.  Jean-David Beyer  Registered Linux User 85642.
>  /V\  PGP-Key:166D840A 0C610C8B Registered Machine  1935521.
> /( )\ Shrewsbury, New Jerseyhttp://linuxcounter.net
> ^^-^^ 08:35:01 up 29 days, 21:32, 2 users, load average: 4.64, 4.60, 4.37
> ___
> 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: variable scheduled date

[Jean-David Beyer]

On 02/23/2018 06:40 PM, David Carlson wrote:
> I am lost in this thread.  I thought that the point of Linux was to use
> RPMs to do the dirty work of installing the software.  In fedora that would
> be "yum install gnucash".  Are you saying that does not work?
> 
> David C
> 

Yes, it would not work because the server that would respond to yum is
the one Red Hat maintains to support (in my case) RHEL6. Were I running
RHEL7, it would get things from that. But in either case, Red Hat do not
support Gnucash (and do not support VLC), so I would need to download
the rpms from elsewhere. And it is not that easy because the rpm's will
not install unless all the dependencies are already there. And to get
them is almost impossible for most things.

When I downloaded VLC, for example, I needed a few libraries. I found
and downloaded some of those. They wanted more. Some of them needed
other libraries and they did not exist. So I had to get rid of some and
get other versions of those, and so on. It took over a week to get VLC
to work. And I was trying to install VLC because some other video player
(and mp3 player) stopped working.

The only way I got GnuCash to work is that it is not quite as
complicated as VLC, and the EPEL project has Gnucash in it. They do not
upgrade it though. They have a version that works, and that is that. The
EPEL for Gnucash in RHEL7 will not install in RHEL6, and I am not
prepared to upgrade my RHEL6 system just to get the latest Gnucash.
(Even were I to do that, there is no reason to believe that that version
of Gnucash would be the latest, though I suspect it would be more up to
date than what I now have.)



-- 
  .~.  Jean-David Beyer  Registered Linux User 85642.
  /V\  PGP-Key:166D840A 0C610C8B Registered Machine  1935521.
 /( )\ Shrewsbury, New Jerseyhttp://linuxcounter.net
 ^^-^^ 08:35:01 up 29 days, 21:32, 2 users, load average: 4.64, 4.60, 4.37
___
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

[Geert Janssens]

Op zaterdag 24 februari 2018 00:46:07 CET schreef David Carlson:
> This thread seems like deja vu to me.  I thought this was discussed before
> and the result was that GnuCash changed the name of one or the other in
> release 2.6.18 or thereabouts.
> 
> Am I dreaming?
> 
> David C
> 

You're not dreaming. This has been discussed before and there was even a 
bugreport for it:
https://bugzilla.gnome.org/show_bug.cgi?id=122895

I have personally applied all the required changes to use "General Journal" 
consistently in GnuCash. This fix was applied in February 2015. However as 
this affected many translatable strings, I decided back then to fix this only 
on master (to become 3.0 soon). So gnucash 2.6 will still use the term 
"General Ledger".

And looking further I have found I then mixed things up in October 2015: after 
some discussion I have started changing the term in the stable documentation 
as well (2.6.x). So we're now in the unfortunate situation the application 
still uses the term General Ledger and the associated documentation uses the 
term General Journal.

I have reverted these unintended corrections on the 2.6 documentation so the 
last 2.6.x release will still consistently use the old "General Ledger" term 
and 3.0 will consistently switch to "General Journal".

Sorry for the confusion this created.

Regards,

Geert

> On Fri, Feb 23, 2018 at 3:52 PM, Buddha Buck  wrote:
> > I suspect that GnuCash terminology regarding journals and ledgers is
> > somewhat confused and non-standard.
> > 
> > My basic understanding of classical accounting is that transactions were
> > first entered into journals, and then posted into ledgers, one per
> > account.
> > The collection of ledger books was the "general ledger", while the nominal
> > time-ordered collection of journal entries was the "general journal" (or
> > the "general journal" was the journal in which transactions which didn't
> > belong in the sales journal, purchase journal, etc were recorded).
> > 
> > In GnuCash terms, a classical account ledger would correspond to a GnuCash
> > account register. And the classic general journal would correspond to
> > GnuCash's general ledger. The classic general ledger might even be a
> > GnuCash book as a whole. I don't know what GnuCash is calling a general
> > journal.
> > 
> > 
> > 
> > 
> > On Fri, Feb 23, 2018 at 1:43 PM Adrien Monteleone <
> > 
> > adrien.montele...@gmail.com> wrote:
> > > Stan,
> > > 
> > > No I knew you were referring to the Ledger and I think David did also
> > > though he linked to the help on the Journal.
> > > 
> > > Unfortunately, it seems the Help file needs a tweak. (or the software)
> > 
> > The
> > 
> > > link he gives describes in fact, the General Ledger. The terminology on
> > 
> > the
> > 
> > > title and within the help article are inconsistent with the naming in
> > > the
> > > software. (though Journal is probably the more historically correct
> > > term,
> > > the two might be interchangeable)
> > > 
> > > In the software, the General Journal is a report you can run that shows
> > > ALL transactions. (under the Assets & Liabilities sub-menu) You can’t
> > 
> > enter
> > 
> > > anything into it. There is no date selector in the options, and the
> > 
> > Filter
> > 
> > > By… in View is not available.
> > > 
> > > Since I don’t close books I see everything when I look at either.
> > > Perhaps
> > > someone who uses that procedure might see only the current accounting
> > > period - I’m not sure.
> > > 
> > > To add to the confusion, there is also a General Ledger report located
> > > in
> > > that same menu. However, it seems to be the same as the Transaction
> > 
> > Report
> > 
> > > and is much more versatile than the General Journal report.
> > > 
> > > For the record, I don’t see any separate ‘tool’ or ‘register’ called
> > > General Journal at least not in my copy of 2.6.19.
> > > 
> > > Regards,
> > > Adrien
> > > 
> > > > On Feb 23, 2018, at 9:42 AM, Stan Brown 
> > > 
> > > wrote:
> > > > Thanks, Adrien.
> > > > 
> > > > Please note that I asked about the general ledger, not the general
> > > 
> > > journal, but I see that the filter works the same way (now that I know
> > > to
> > > try it).
> > > 
> > > > As the documentation mentions only the general journal, maybe "and
> > > 
> > > general ledger" should be added, for the benefit of folks who are
> > 
> > searching
> > 
> > > for it?
> > > 
> > > > --
> > > > Stan Brown
> > > > the_stan_br...@fastmail.fm
> > > > http://BrownMath.com
> > > > http://OakRoadSystems.com/
> > > > 
> > > > On Fri, Feb 23, 2018, at 7:52 AM, Adrien Monteleone wrote:
> > > >> And unfortunately, this filter change is not sticky. You’ll have to
> > > >> reset it each time you load the GL. This is already a filed bug.
> > > >> 
> > > >>> On Feb 23, 2018, at 5:47 AM, David T. via gnucash-user <
> > > 
> > > gnucash-user@gnucash.org> wrote:
> > > >>> "The General Journal defaults