Re: bank entries

[Maf. King]

On Monday, 27 November 2017 02:33:50 GMT Christine via gnucash-user wrote:
> Reading the literature I just get
> confused as I am used to DR and CR.
> 
> Christine
> 

Hi Christine,

if you are used to the terminology of DR and CR to describe the sides of a 
transaction, then perhaps you would be helped by enabling "use formal 
accounting labels" in the preferences of GC.  This will put Debit & Credit as 
the column headings in the account registers, rather than the more descriptive 
(but variable) headings such as "withdrawal" etc.

Edit Menu -> Preferences -> Accounts Tab.

HTH,
Maf.



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

recover GNUcash data after windows crash

[Ian McAllister]

Hi, I think I sent my earlier message to the wrong address.

My motherboard crashed and I needed a new one and re-installed Windows. 
Fortunately I had a backup of my main folders.


I copied the GNUcash folder across from the backup then re-installed 
over the top of it, in the hope that I would then have all my data files 
included, but it didn't work that way.


So I found \Users\myusernam\.gnucash\books which contained my old files
AccountsBusiness.gnucash.gcm
Personal.gnucash.gcm
I copied these and ran the program, which identified the two files. I 
highlighted and clicked each in turn, and was told both times
No suitable backend was found for 
file://C:\Users\###\.gnucash\books\AccountsBusiness.gnucash.gcm.


How can I get back my books?

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

Re: recover GNUcash data after windows crash

[David T. via gnucash-user]

Ian,

Gcm files are not your data files. They are metadata files. Similarly, the 
“.gnucash” folder is the system folder that holds this metadata. Your data 
files (AccontsBusiness.gnucash and Personal.gnucash) are somewhere else on your 
backup. Put those on your new machine (not in the “.gnucash foldr”, BTW), and 
you’ll have your data.

HTH,
David

> On Nov 27, 2017, at 7:24 PM, Ian McAllister  wrote:
> 
> Hi, I think I sent my earlier message to the wrong address.
> 
> My motherboard crashed and I needed a new one and re-installed Windows. 
> Fortunately I had a backup of my main folders.
> 
> I copied the GNUcash folder across from the backup then re-installed over the 
> top of it, in the hope that I would then have all my data files included, but 
> it didn't work that way.
> 
> So I found \Users\myusernam\.gnucash\books which contained my old files
> AccountsBusiness.gnucash.gcm
> Personal.gnucash.gcm
> I copied these and ran the program, which identified the two files. I 
> highlighted and clicked each in turn, and was told both times
> No suitable backend was found for 
> file://C:\Users\###\.gnucash\books\AccountsBusiness.gnucash.gcm.
> 
> How can I get back my books?
> 
> Ian McAllister
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: Finance-quote

[Derek Atkins]

Snow Leopard  writes:

> It works but only without adding "gnc-fq-dump alphavantage CSCO ».
> I don’t understand the sentence "you must set it as a shell
> environment variable when using gnc-fq-helper or gnc-fq-dump. ».
> maybe I am over asking ?
> Thanks anyway for the help

If you are going to run gnc-fq-dump (or -helper) from the shell, you
need to pass the API Key in an "environment variable".  How you set this
variable depends on the type of shell you use.  One sure-fire way to get
it to work on Linux and Mac (sorry, Windows users), is to use the 'env'
command:

$ env ALPHAVANTAGE_API_KEY=xx  gnc-fq-dump alphavantage CSCO

In order to permanently set this will depend on which shell you use.

> Xavier

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: bank entries

[Derek Atkins]

Christine,

Christine  via gnucash-user  writes:

> Hi Dave
> My accounts are Cash, Bank, Income, various expenses, and 2 people who I pay
> money too and who pay to the bank. 
> IF I balance one of the accounts another goes wrong. All I want to do is add
> my bank and my cash and let gnucash do the rest (ie an income and
> expenditure report) but it is not working. Reading the literature I just get
> confused as I am used to DR and CR.
> Thanks anyway maybe I should look for an easier program if anyone knows of
> one

Let's take a simple example of a grocery expense; you go to Kroger and
spend $25 from Cash.  To enter this in GnuCash you would open your Cash
account register, put in the date, Kroger in the description, then
Expenses:Groceries in the transfer column, and $25 in the Credit (or
Spend, or Withdrawal) column.

Most likely your problem is that you are opening up the Cash account and
then putting the Cash account into the transfer account as well.

I hope this helps?

> Christine 

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

RE: bank entries

[Christine via gnucash-user]

Hello
Thank you to Derek for getting me the formal accounts. I have set up my cash
account but now I realise that I need an opening balance and it seems I
cannot address this at this late stage. I managed to complete it for the
bank. I have a cash equity account but I would like the cash to go to the
opening balance instead. Can anyone guide me pls?

Christine 

-Original Message-
From: Derek Atkins [mailto:warl...@mit.edu] 
Sent: 27 November 2017 19:51
To: Christine via gnucash-user
Cc: 'DaveC49'; Christine
Subject: Re: bank entries

Christine,

Christine  via gnucash-user  writes:

> Hi Dave
> My accounts are Cash, Bank, Income, various expenses, and 2 people who 
> I pay money too and who pay to the bank.
> IF I balance one of the accounts another goes wrong. All I want to do 
> is add my bank and my cash and let gnucash do the rest (ie an income 
> and expenditure report) but it is not working. Reading the literature 
> I just get confused as I am used to DR and CR.
> Thanks anyway maybe I should look for an easier program if anyone 
> knows of one

Let's take a simple example of a grocery expense; you go to Kroger and spend
$25 from Cash.  To enter this in GnuCash you would open your Cash account
register, put in the date, Kroger in the description, then
Expenses:Groceries in the transfer column, and $25 in the Credit (or Spend,
or Withdrawal) column.

Most likely your problem is that you are opening up the Cash account and
then putting the Cash account into the transfer account as well.

I hope this helps?

> Christine

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

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

RE: bank entries

[Derek Atkins]

HI,

On Mon, November 27, 2017 3:51 pm, Christine wrote:
> Hello
> Thank you to Derek for getting me the formal accounts. I have set up my
> cash
> account but now I realise that I need an opening balance and it seems I
> cannot address this at this late stage. I managed to complete it for the
> bank. I have a cash equity account but I would like the cash to go to the
> opening balance instead. Can anyone guide me pls?

An O-B for an account is just a regular transaction between the account
and Equity:Opening Balances dated before anything else.  You can just
create that transaction by hand in the same way as you'd create your
grocery transaction.

>
> Christine

-derek

> -Original Message-
> From: Derek Atkins [mailto:warl...@mit.edu]
> Sent: 27 November 2017 19:51
> To: Christine via gnucash-user
> Cc: 'DaveC49'; Christine
> Subject: Re: bank entries
>
> Christine,
>
> Christine  via gnucash-user  writes:
>
>> Hi Dave
>> My accounts are Cash, Bank, Income, various expenses, and 2 people who
>> I pay money too and who pay to the bank.
>> IF I balance one of the accounts another goes wrong. All I want to do
>> is add my bank and my cash and let gnucash do the rest (ie an income
>> and expenditure report) but it is not working. Reading the literature
>> I just get confused as I am used to DR and CR.
>> Thanks anyway maybe I should look for an easier program if anyone
>> knows of one
>
> Let's take a simple example of a grocery expense; you go to Kroger and
> spend
> $25 from Cash.  To enter this in GnuCash you would open your Cash account
> register, put in the date, Kroger in the description, then
> Expenses:Groceries in the transfer column, and $25 in the Credit (or
> Spend,
> or Withdrawal) column.
>
> Most likely your problem is that you are opening up the Cash account and
> then putting the Cash account into the transfer account as well.
>
> I hope this helps?
>
>> Christine
>
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>Member, MIT Student Information Processing Board  (SIPB)
>URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>warl...@mit.eduPGP key available
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

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

RE: bank entries

[Christine via gnucash-user]

Thank you

-Original Message-
From: Derek Atkins [mailto:de...@ihtfp.com] 
Sent: 27 November 2017 21:08
To: Christine
Cc: 'Christine via gnucash-user'; 'DaveC49'
Subject: RE: bank entries

HI,

On Mon, November 27, 2017 3:51 pm, Christine wrote:
> Hello
> Thank you to Derek for getting me the formal accounts. I have set up 
> my cash account but now I realise that I need an opening balance and 
> it seems I cannot address this at this late stage. I managed to 
> complete it for the bank. I have a cash equity account but I would 
> like the cash to go to the opening balance instead. Can anyone guide 
> me pls?

An O-B for an account is just a regular transaction between the account and 
Equity:Opening Balances dated before anything else.  You can just create that 
transaction by hand in the same way as you'd create your grocery transaction.

>
> Christine

-derek

> -Original Message-
> From: Derek Atkins [mailto:warl...@mit.edu]
> Sent: 27 November 2017 19:51
> To: Christine via gnucash-user
> Cc: 'DaveC49'; Christine
> Subject: Re: bank entries
>
> Christine,
>
> Christine  via gnucash-user  writes:
>
>> Hi Dave
>> My accounts are Cash, Bank, Income, various expenses, and 2 people 
>> who I pay money too and who pay to the bank.
>> IF I balance one of the accounts another goes wrong. All I want to do 
>> is add my bank and my cash and let gnucash do the rest (ie an income 
>> and expenditure report) but it is not working. Reading the literature 
>> I just get confused as I am used to DR and CR.
>> Thanks anyway maybe I should look for an easier program if anyone 
>> knows of one
>
> Let's take a simple example of a grocery expense; you go to Kroger and 
> spend
> $25 from Cash.  To enter this in GnuCash you would open your Cash 
> account register, put in the date, Kroger in the description, then 
> Expenses:Groceries in the transfer column, and $25 in the Credit (or 
> Spend, or Withdrawal) column.
>
> Most likely your problem is that you are opening up the Cash account 
> and then putting the Cash account into the transfer account as well.
>
> I hope this helps?
>
>> Christine
>
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>Member, MIT Student Information Processing Board  (SIPB)
>URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>warl...@mit.eduPGP key available
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

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

Re: gnucash-user Digest, Vol 176, Issue 55

[Ian McAllister]

Thanks David,

I searched my backup disk, and found 473 instances of .gnucash but no 
files with the right name, but without the .gcm at the end.


I suppose I'll just have to start with a new installation, and put in 
data from my bank for five months.


Ian McAllister


On 28/11/2017 01:00 AM, gnucash-user-requ...@gnucash.org wrote:

Send gnucash-user mailing list submissions to
gnucash-user@gnucash.org

To subscribe or unsubscribe via the World Wide Web, visit
https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
gnucash-user-requ...@gnucash.org

You can reach the person managing the list at
gnucash-user-ow...@gnucash.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of gnucash-user digest..."


Today's Topics:

1. GnuCash 2.7.2 released (John Ralls)
2. Re: bank entries (Christine )
3. Re: bank entries (Colin Law)
4. RE: bank entries (Ken Pyzik)
5. Re: bank entries (DaveC49)
6. RE: bank entries (Christine )
7. Re: bank entries (David Carlson)
8. Re: bank entries (Maf. King)
9. recover GNUcash data after windows crash (Ian McAllister)
   10. Re: recover GNUcash data after windows crash (David T.)


--

Message: 1
Date: Sun, 26 Nov 2017 10:34:38 -0800
From: John Ralls 
To: Gnucash Users 
Subject: GnuCash 2.7.2 released
Message-ID: 
Content-Type: text/plain;   charset=utf-8

The Gnucash Development Team is pleased to release Gnucash 2.7.2, the third 
release of an unstable series leading to Gnucash 2.8.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.

Bugs fixed in this release

? Bug 734865 - Assign as Payment... can silently 'unpay' a payed invoice
? if the selected transaction is already linked to an existing 
payment, the payment dialog will present this payment again (same partner, 
post-to account, same selected document(s), same amount, memo, and transfer 
account).
? if the selected transaction is not linked to an existing 
business transaction the logic will make a best guess as to whether the payment 
should be for a customer or vendor.
? in both situations if the existing transaction has multiple 
splits that can be considered as transfer (or 'payment') splits the payment 
dialog can't work with it (it can only deal with one transfer split). In this 
case the user will be informed that only one valid transfer split will be 
retained and the others ignored.
? the other thing the payment dialog can't handle are APAR type 
splits that are not associated to a lot at all. In case of transactions not 
part of a business transaction they will be silently ignored on the assumptions 
these were manually entered transactions with the intention to be linked to 
business transactions. On the other hand if such a split is part of a 
transaction that is also linked to a business payment already, a warning will 
be issued these splits will be removed from the new payment.
? Bug 778692 - Assign as payment should work for employee expense 
vouchers
? if gnucash can deduce a partner from the transaction that 
partner will be proposed this works for all transactions that are part of a 
business transaction already and will correctly detect pre-existing customer, 
vendor and employee payments
? if no partner can be deduced gnucash will assume the 
transaction to be a vendor or customer payment based on the sign
? in all cases the user can change the partner type in the 
payment window that's presented to any of customer, vendor or employee to 
correct gnucash' suggestion.
? Bug 784623 - GNUCash does not work with sql backend.
Wherin the problem is that MySQL's TIMESTAMP has a date range of 1970-01-01 
00:00:01 to 2038-01-19 03:14:07 and is unable to handle time_t of 0. MySQL's 
TIMESTAMP also assumes that input is in the server's timezone and adjusts it to 
UTC. GnuCash has already done that conversion.

? Bug 789608 - Compilation problems when linking libraries.
? Bug 789928 - FTBFS with libdbi 0.9.0-5 on Debian.
? Bug 790550 - FTBFS: missing __init__.py
Some other fixes not associated with reported bugs:

? SQL parameter quoting is corrected in the backend so that only string 
parameters are quoted. This caused trouble when trying to store SQL NULL; the 
string 'NULL' is different from the value NULL.
? SQL table versions weren't set consistently and a bogus version test 
could cause some tables to be not loaded.
? Better, more targ

GnuCash release numbering

[Eric Siegerman]

On Tue, Nov 21, 2017 at 02:14:31PM -0500, davel...@mac.com wrote:
> Yes, 2.6.18 is newer. Each number between the periods is a
> separate number and 18 is greater than 3. 

To expand on that:  software version numbers don't work like
decimal fractions, even though they use "." as a separator.
Think of "2.6.18" as a series of (multi-digit) integers, and
compare each integer in turn until you find one that differs:
 2 = 2
 6 = 6
18 > 3<--- Bingo!

To put it another way: unlike in mathematics, "2.6.3" and
"2.6.30" are *not* equal.  (GnuCash 2.6.30 doesn't exist -- nor,
I imagine, will it ever exist, because the whole 2.6.x series
will reach end-of-life long before it gets twelve more releases.)

It gets weirder; I oversimplified, above.  The individual
components of a version number are not always integers.  There
can be other characters as well, usually letters.  Worse, what
those letters mean depends on the project.

In some projects, "3a" comes before "3".  To invent an example,
"4.7.3a1" might be the first "alpha testing" pre-release.  Then
"beta" releases like 4.7.3b1; then "release candidates" like
4.7.3rc1; and finally the *real* release, 4.7.3 itself.

In other projects, it's the other way around -- something like
"3a" comes *after* "3".

GnuCash works the second way.  It had 2.6.17a and 2.6.17b as
*very* minor post-release corrections to 2.6.17.  Typically
one tries to avoid needing these post-release fixups, and in
fact GnuCash 2.6.18 hasn't needed any ... but sometimes stuff
happens...

One wants the world of computers to be as logical as Mr. Spock,
but alas, we humans seem able to make a confusing mess out of
anything :-/

> In general, do not download the 2.7.x versions as those are
> beta releases for the next version unless you are testing those
> with other data (i.e., don't run a 2.7 with the only copy of
> your actual data file).

The way GnuCash distinguishes testing prereleases is with odd vs.
even numbers for the second component.  The 2.6.x series are
"stable", i.e. intended for production use.  There are already
several 2.7.x releases, but those are "unstable"; they're only
for testing, *not* production use.  Once the 2.7.x series
stabilizes, they'll release 2.8.0, which will be the first stable
release of the new series.  So:

2.6.3 <--- Several years old now
...
2.6.16
2.6.17
2.6.17a
2.6.17b
2.6.18<--- The current stable release.  INSTALL THIS ONE.

2.7.0 \These already exist ...
2.7.1 |... but they're for testing only.
2.7.2 /DO NOT USE them for real work!

  <--- (2017-11-27.  Below here is in the future.)

2.6.19<--- The next stable release in the 2.6.x series
2.7.3 <--- The next testing release
2.6.x <--- Repeat as necessary ...
2.7.y <--- ... until ...

2.8.0 <--- The first stable release of the new series
2.8.1 <--- And so on
...
2.9.0 <--- First of the testing prereleases leading up to
   2.10.0


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

Multi-user suggestion: an edit token

[Eric Siegerman]

On Tue, Nov 21, 2017 at 10:21:55PM -0600, Jeff Hobson wrote:
> [...] a true conflict would arise if both platforms were
> modifying the data at the same time. That caveat, understood is
> the real barrier to mutual and simultaneous access. 

Indeed!

If there will be multiple people involved, one way to keep these
collisions from happening by accident is to have a physical token
of some sort.  It can be anything -- a dollar-store trinket, a
lovingly carved wooden figurine, an oddly shaped rock from the
garden, whatever :-)  As long as it's distinctive.

The rule is that only the person with the token on their desk is
allowed to touch the file.  So:
  - If you want to do some GnuCash work, grab the token first

  - When you're done, return the token to some agreed neutral
location where it lives while not in use

  - If you go to grab it and it's on someone else's desk, *check
with them* before you take it

No cheating on this one!  Maybe they left for the day and
forgot to return it ... but maybe they're just taking a quick
break in the middle of something long and intricate.  If Mary
has the token, Mary *owns* that file until she says
otherwise!

In theory this shouldn't be needed.  GnuCash is supposed to sort
all that out for you -- that's what the foo.gnucash.LCK file is
for.  But over some networks, that kind of locking can be iffy.
So if in practice you get these "John and Mary both changed it"
situations, the above physical-token scheme can be used as a
fallback.

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

RE: bank entries

[DaveC49]

Christine,

I don't think the program itself is your problem. You will require some
fundamental knowledge of accounting procedures and theory no matter which
program you use. It is also a process of learning the jargonused in a
particular program's interface. I know of no accounting program which is not
a double entry under the hood although some do simplify procedures by only
allowing you to perform certain actions from the  appropriate accounts.
Gnucash is generally far more flexible that most accounting packages - but
it's default ways of doing things are designed to make it easier

Using the Dr and Cr terminology is good. It is the default for accountants.
Gnucash provides an alternative for people who are not comfortable with it.
That may be setup as the default if you are not getting Debit and Credit
column headings at the right when you display an account. Is so, to set up
Gnucash to use Dr/Cr go to Menu->Edit->Preferences then select the Accounts
tab at the left hand side in the popup dialog which comes up. About half way
down you will see a check box Labels - Use formal accounting labels. make
sure it is selected. You will then get Dr (Debit) and Cr (Credit) columns
when you display an account from the main Accounts window in a tab.

For a start, I would create a dummy set of accounts ( I call mine Test - no
imagination) you can play with while getting used to the program (I am an
accountant and I still use this regularly after using Gnucash for more than
five years) separate from any sets of personal accounts for yourself or
business set 
 of accounts. I usually put each set of accounts in its own folder.  Section
2.5 of the guide explains creating files for each set of accounts.

I would read  through sections 2.1, 2.2 and 2.3 of the Tutorial guide before
attempting too much but have the program open, particularly for section 2.3
which deals with the interface - how you do things in Gnucash.  Section 3 on
Accounts next and then Section 4 on Transactions are good to read next.

>From your description, it would appear you are handling a simple business.
If you buy and sell only with cash, then you can ignore the business
features section for now as they are mainly for buying from suppliers on
credit (when you pay at the end of the month or quarter) and selling to
customers on credit ( where they pay you later on some agreed basis (again
ned of month/quarter etc). Even if you do need to use these, it is better to
get a good grasp on the cash processes first.

Debits and Credits as they appear in your own account will be reversed from
how they appear in a bank statement for your account from your bank. This is
because a bank views your account with it as a Liability (money they may
have to pay to you or to others on your behalf when you request it). In your
own accounts your bank account is an Asset (a resource you have available to
use at your discretion).

I am also not sure what you mean by "balance one of the accounts". The
column labelled Balance on the far right in a given account register gives
the balance of that account which for an Asset account, e.g. a bank account
is the sum of all the debits to that account minus the sum of all the
credits to that account. Gnucash maintains the balance for that account
automatically. There is no having to balance an account when you enter a
transaction. Another good rule of thumb is if you are buying or selling
something where the funds either come or go to your bank account, then start
the transaction in the account register for your bank account (double click
on the Asset:Bank account in your Accounts display tab and it will open the
register).  Changing the register defaults can also make things a lot
clearer.  Menu->Edit->Preferences and then select the Register Defaults tab.
If you set the Default Style to Autosplit Register (select the checkbox) and
the Other Defaults check the Double line mode checkbox. You will then have
to close any open account registers and reopen them for these options to
take effect. It will then appear as follows:

. 

The first two lines are an unopened transaction, the next 5 lines are the
currently open transaction and the final two are another unopened
transaction. The two yellow lines are a summary of the transaction as it
affects the account register in which it is displayed. The three lines in
brown are the components or splits of the transaction - the third line is a
blank. The screenshot is from the reister for one of my bank accounts
Assets:Current Assets:David:Streamline 2576 ( each of the : separated items
is a sub account of the previous level). Gnucash always presents the debit
entries of a transaction first followed by the credit entries when you open
a transaction in the register. The second brown line (Credit entry) records
money being taken from my account. The first brown line (Debit entry)
records that money being

Alphavantage not working in gnucash 2.6.17

[Patrick Alken]

Apologies if this has already been asked, but I couldn't find this exact
issue in the recent mailings.

I have:

gnucash: 2.6.17

F::Q: 1.47

My F::Q works from the command line:

--

$ gnc-fq-dump alphavantage CSCO
Finance::Quote fields Gnucash uses:
    symbol: CSCO <=== required
  date: 11/27/2017   <=== recommended
  currency: USD  <=== required
  last: 36.8700  <=\  
   nav:  <=== one of these
 price:  <=/   
  timezone:  <=== optional
--

However inside gnucash price editor I still get the "unknown error when
retrieving price quotes".

I have unchecked the "Get Online Quotes" flag from ALL of my stocks in
the security editor. However the price editor still gives me the same
error (unknown error).

gnucash --debug shows nothing related to quotes. I only get lines like this:



* 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/1
* 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/100
* 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/100
* 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/100



Can anyone advise how to diagnose the issue?

Thanks,

Patrick

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

Re: gnucash-user Digest, Vol 176, Issue 55

[Colin Law]

Look at the timestamps of the .gnucash files that have a name and lots
of digits (those are the backups of your data). Find the latest of
these.  The likely cause is that you have been using one of the
backups as your actual backups so you have backups of backups. Do not
give up, your file is almost certainly there.

Colin

On 28 November 2017 at 03:44, Ian McAllister  wrote:
> Thanks David,
>
> I searched my backup disk, and found 473 instances of .gnucash but no files
> with the right name, but without the .gcm at the end.
>
> I suppose I'll just have to start with a new installation, and put in data
> from my bank for five months.
>
> Ian McAllister
>
>
> On 28/11/2017 01:00 AM, gnucash-user-requ...@gnucash.org wrote:
>>
>> Send gnucash-user mailing list submissions to
>> gnucash-user@gnucash.org
>>
>> To subscribe or unsubscribe via the World Wide Web, visit
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> or, via email, send a message with subject or body 'help' to
>> gnucash-user-requ...@gnucash.org
>>
>> You can reach the person managing the list at
>> gnucash-user-ow...@gnucash.org
>>
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of gnucash-user digest..."
>>
>>
>> Today's Topics:
>>
>> 1. GnuCash 2.7.2 released (John Ralls)
>> 2. Re: bank entries (Christine )
>> 3. Re: bank entries (Colin Law)
>> 4. RE: bank entries (Ken Pyzik)
>> 5. Re: bank entries (DaveC49)
>> 6. RE: bank entries (Christine )
>> 7. Re: bank entries (David Carlson)
>> 8. Re: bank entries (Maf. King)
>> 9. recover GNUcash data after windows crash (Ian McAllister)
>>10. Re: recover GNUcash data after windows crash (David T.)
>>
>>
>> --
>>
>> Message: 1
>> Date: Sun, 26 Nov 2017 10:34:38 -0800
>> From: John Ralls 
>> To: Gnucash Users 
>> Subject: GnuCash 2.7.2 released
>> Message-ID: 
>> Content-Type: text/plain;   charset=utf-8
>>
>> The Gnucash Development Team is pleased to release Gnucash 2.7.2, the
>> third release of an unstable series leading to Gnucash 2.8.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.
>>
>> Bugs fixed in this release
>>
>> ? Bug 734865 - Assign as Payment... can silently 'unpay' a payed
>> invoice
>> ? if the selected transaction is already linked to an
>> existing payment, the payment dialog will present this payment again (same
>> partner, post-to account, same selected document(s), same amount, memo, and
>> transfer account).
>> ? if the selected transaction is not linked to an existing
>> business transaction the logic will make a best guess as to whether the
>> payment should be for a customer or vendor.
>> ? in both situations if the existing transaction has
>> multiple splits that can be considered as transfer (or 'payment') splits the
>> payment dialog can't work with it (it can only deal with one transfer
>> split). In this case the user will be informed that only one valid transfer
>> split will be retained and the others ignored.
>> ? the other thing the payment dialog can't handle are APAR
>> type splits that are not associated to a lot at all. In case of transactions
>> not part of a business transaction they will be silently ignored on the
>> assumptions these were manually entered transactions with the intention to
>> be linked to business transactions. On the other hand if such a split is
>> part of a transaction that is also linked to a business payment already, a
>> warning will be issued these splits will be removed from the new payment.
>> ? Bug 778692 - Assign as payment should work for employee expense
>> vouchers
>> ? if gnucash can deduce a partner from the transaction
>> that partner will be proposed this works for all transactions that are part
>> of a business transaction already and will correctly detect pre-existing
>> customer, vendor and employee payments
>> ? if no partner can be deduced gnucash will assume the
>> transaction to be a vendor or customer payment based on the sign
>> ? in all cases the user can change the partner type in the
>> payment window that's presented to any of customer, vendor or employee to
>> correct gnucash' suggestion.
>> ? Bug 784623 - GNUCash does not work with sql backend.
>> Wherin the problem is that MySQL's TIMESTAMP has a date range of
>> 1970-01-01 00:00:01 to 2038-01-19 03:14:07 and is unable to handle time_t of
>> 0. MySQL's TIMESTAMP also assumes that input is in the server's timezone and
>> adjusts it to UTC. GnuCash has