Re: [GNC] How to handle Asset equity etc in begining?

[Adrien Monteleone]

You should speak to a local accountant about how to book asset values for your 
jurisdiction. But assuming the land’s book value is indeed what you indicated, 
simply create a transaction like so:

Dr. Assets:Fixed Assets:Land
Cr. Equity:Opening Balances

Is the advance unearned revenue/income? If so, you’d book it something like 
this:

Dr. Assets:Current Assets:Cash
Cr. Liabilities:Unearned Revenue/Income

When you ‘earn’ the advance by performing work, delivering goods/services, then 
you’d enter something like this:

Dr. Liabilities:Unearned Revenue/Income
Cr. Revenue/Income

You can accomplish those two transactions either directly, or using the 
Business Features. (You’d make a pre-payment debited to Cash and posted to the 
Unearned account, then later create an invoice with the line-item posting to 
the Revenue/Income account and the invoice itself posting to the Unearned 
account)

Regards,
Adrien

> On Sep 10, 2018, at 10:57 AM, RoyUB  wrote:
> 
> Hi, 
> I am a new user. I an just starting to use Gnu cash.
> I have a land worth Rs. 600/
> Somebody given me an advance of 100/
> I know land is a asset, advance should come to cash account.. etc
> But how the equity and all come into this? 
> How to arrange opening balance in this case?
> Thank you.
> 
> 
> 
> --
> 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.

[GNC] GnuCash Friendly Accountant in Chicago

[kvn]

Hi

Hope this is the right way to post.

Iam in Chicago and am looking for an accountant that is familiar 
withGnuCash andable to take care of my tax accounting and filing  The 
accountants I have been working with are all Quicken based and are not 
that eager to investigate other platforms.


Please let me know if you can direct me to a source for this information.


Thanks


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

[GNC] How to handle Asset equity etc in begining?

[RoyUB]

Hi, 
I am a new user. I an just starting to use Gnu cash.
I have a land worth Rs. 600/
Somebody given me an advance of 100/
I know land is a asset, advance should come to cash account.. etc
But how the equity and all come into this? 
How to arrange opening balance in this case?
Thank you.



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

Re: [GNC] Importing csv transactions

[David Carlson]

Paul,

Actually, during the CSV format you can scroll down the data that you are
about to import to see if there are any lines that will prevent the
import.  Just scroll down the date column to see if there are any dates
that do not match your selected date format.  From experience I can tell
you that it is very easy to make a mistake in this column, as, at least in
the release 2.6.xx family of GnuCash releases, the default did not match
common usage in the US.

David C

On Mon, Sep 10, 2018 at 5:32 PM GTI .H  wrote:

> Probably some date (maybe three) in your CSV file is in the wrong format.
> Open your CSV file in an editor and check the format of the dates.
>
> Regards
> GTI
>
> Em seg, 10 de set de 2018 às 18:19, Paul Konnersman 
> escreveu:
>
> > I'm new to Gnucash and trying to get set up. I successfully imported a
> > couple of years worth of transactions into one account a few months ago
> > when I was evaluating Gnucash. Now I'm trying to import more transactions
> > into that same account without success.
> >
> > My process:
> > 1) Menu Bar> File> Input> Import Transactions from CSV
> > 2) Navigate to CSV file to be imported
> > 3) Set Date format to y-m-d
> > 4) Set currency format to "period"
> > 5) Map columns in imported file to columns in Gnucash
> >
> >1. Date -> Date
> >2. Num -> Num
> >3. Description -> Action
> >4. Account -> Transfer
> >5. Notes -> C
> >6. Deposit -> Debit Amount
> >7. None -> Credit Amount
> >8. None -> Balance
> >
> > 6) I get a notice repeated three times that reads, "Date Column could not
> > be understood."
> >
> > Any suggestions will be appreciated.
> >
> > Paul
> >
> > --
> > *Paul M. Konnersman*
> > *konners...@gmail.com *
> > *781-639-0616*
> > ___
> > 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.
> >
>
>
> --
> Regards
> GTI
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] One account off by significant amount. Can't figure out why.

[Adrien Monteleone]

Also, check to see if Imbalance-xxx or Orphan-xxx (where xxx is your currency 
code) have balances. They should not. If they do, check them for errant 
transactions.

Regards,
Adrien

> On Sep 10, 2018, at 5:33 PM, annapolishome via gnucash-user 
>  wrote:
> 
> Have a problem with one of my accounts.  It is off by a considerable amount,
> but can't see why or where the problem is.  Something happened recently.
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 


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

Re: [GNC] One account off by significant amount. Can't figure out why.

[Rich Shepard]

On Mon, 10 Sep 2018, annapolishome via gnucash-user wrote:


Have a problem with one of my accounts. It is off by a considerable
amount, but can't see why or where the problem is. Something happened
recently.


  Have you looked at a trial balance? If one account is off it should have
an offsetting off somewhere else.

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

[GNC] One account off by significant amount. Can't figure out why.

[annapolishome via gnucash-user]

Have a problem with one of my accounts.  It is off by a considerable amount,
but can't see why or where the problem is.  Something happened recently.



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

Re: [GNC] Importing csv transactions

[GTI .H]

Probably some date (maybe three) in your CSV file is in the wrong format.
Open your CSV file in an editor and check the format of the dates.

Regards
GTI

Em seg, 10 de set de 2018 às 18:19, Paul Konnersman 
escreveu:

> I'm new to Gnucash and trying to get set up. I successfully imported a
> couple of years worth of transactions into one account a few months ago
> when I was evaluating Gnucash. Now I'm trying to import more transactions
> into that same account without success.
>
> My process:
> 1) Menu Bar> File> Input> Import Transactions from CSV
> 2) Navigate to CSV file to be imported
> 3) Set Date format to y-m-d
> 4) Set currency format to "period"
> 5) Map columns in imported file to columns in Gnucash
>
>1. Date -> Date
>2. Num -> Num
>3. Description -> Action
>4. Account -> Transfer
>5. Notes -> C
>6. Deposit -> Debit Amount
>7. None -> Credit Amount
>8. None -> Balance
>
> 6) I get a notice repeated three times that reads, "Date Column could not
> be understood."
>
> Any suggestions will be appreciated.
>
> Paul
>
> --
> *Paul M. Konnersman*
> *konners...@gmail.com *
> *781-639-0616*
> ___
> 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.
>


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

[GNC] Importing csv transactions

[Paul Konnersman]

I'm new to Gnucash and trying to get set up. I successfully imported a
couple of years worth of transactions into one account a few months ago
when I was evaluating Gnucash. Now I'm trying to import more transactions
into that same account without success.

My process:
1) Menu Bar> File> Input> Import Transactions from CSV
2) Navigate to CSV file to be imported
3) Set Date format to y-m-d
4) Set currency format to "period"
5) Map columns in imported file to columns in Gnucash

   1. Date -> Date
   2. Num -> Num
   3. Description -> Action
   4. Account -> Transfer
   5. Notes -> C
   6. Deposit -> Debit Amount
   7. None -> Credit Amount
   8. None -> Balance

6) I get a notice repeated three times that reads, "Date Column could not
be understood."

Any suggestions will be appreciated.

Paul

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

Re: [GNC] Date Picker Info

[Adrien Monteleone]

Chapter 4. Transactions - Using Entry Shortcuts

Regards,
Adrien

> On Sep 10, 2018, at 2:54 PM, D  wrote:
> 
> I forgot about those.
> 
> These are written in the code, so my guess is that they are hard. But I'm 
> hardly a programmer. Where in the Guide are these documented?
> 
> David
> 
> On September 10, 2018, at 3:50 PM, Adrien Monteleone 
>  wrote:
> 
> I just looked at the guide and some of those are there. The Shift and CTRL 
> versions of increment/decrement week/year aren’t listed.
> 
> Are those hard coded or are they alterable accelerators? If the latter, then 
> non-English users could customize them to suit.
> 
> Also, don’t forget these two which are in the Guide:
> 
>   • ] or } to increment the month and [ or { to decrement the month
> 
>   • T or t to enter today’s date
> 
> That last one is very useful if you’ve entered a different date and now want 
> to enter something for today. (as GnuCash retains the last date you used as 
> the default for the next transaction)
> 
> Regards,
> Adrien
> 
>> On Sep 10, 2018, at 2:07 PM, David T. via gnucash-user 
>>  wrote:
>> 
>> Hello,
>> 
>> In the course of looking at documentation improvements, I happened to look 
>> at the program code for the date cells in GnuCash, and I discovered that 
>> there are several quick keys for setting the date that I was unaware of, and 
>> I thought I’d share with the list.
>> 
>> Most of us know about using =/- to add or subtract a day to the date shown. 
>> 
>> Some of us know that Shift =/- (_/+) increments a week at a time. 
>> 
>> A few of us know that using CTRL =/- increments a year at a time.
>> 
>> But I wonder how many people know that m/M sets the date to the beginning of 
>> the month, and h/H set the date to the end of the month? Or that y/Y sets it 
>> to the beginning of the year, while r/R sets it to the end?
>> 
>> Interesting little UI factoids! Too bad for non-English speakers; as the 
>> mnemonics probably won’t make as much sense in French or German…
>> 
>> David
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


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

Re: [GNC] Date Picker Info

[Geert Janssens]

Op maandag 10 september 2018 21:54:41 CEST schreef D via gnucash-user:
> I forgot about those.
> 
> These are written in the code, so my guess is that they are hard. But I'm
> hardly a programmer. Where in the Guide are these documented?
> 
> David
> 

They are indeed all hardcoded.

Geert


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

Re: [GNC] Date Picker Info

[D via gnucash-user]

I forgot about those.

These are written in the code, so my guess is that they are hard. But I'm 
hardly a programmer. Where in the Guide are these documented?

David

On September 10, 2018, at 3:50 PM, Adrien Monteleone 
 wrote:

I just looked at the guide and some of those are there. The Shift and CTRL 
versions of increment/decrement week/year aren’t listed.

Are those hard coded or are they alterable accelerators? If the latter, then 
non-English users could customize them to suit.

Also, don’t forget these two which are in the Guide:

• ] or } to increment the month and [ or { to decrement the month

• T or t to enter today’s date

That last one is very useful if you’ve entered a different date and now want to 
enter something for today. (as GnuCash retains the last date you used as the 
default for the next transaction)

Regards,
Adrien

> On Sep 10, 2018, at 2:07 PM, David T. via gnucash-user 
>  wrote:
> 
> Hello,
> 
> In the course of looking at documentation improvements, I happened to look at 
> the program code for the date cells in GnuCash, and I discovered that there 
> are several quick keys for setting the date that I was unaware of, and I 
> thought I’d share with the list.
> 
> Most of us know about using =/- to add or subtract a day to the date shown. 
> 
> Some of us know that Shift =/- (_/+) increments a week at a time. 
> 
> A few of us know that using CTRL =/- increments a year at a time.
> 
> But I wonder how many people know that m/M sets the date to the beginning of 
> the month, and h/H set the date to the end of the month? Or that y/Y sets it 
> to the beginning of the year, while r/R sets it to the end?
> 
> Interesting little UI factoids! Too bad for non-English speakers; as the 
> mnemonics probably won’t make as much sense in French or German…
> 
> David
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


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

Re: [GNC] Date Picker Info

[Adrien Monteleone]

I just looked at the guide and some of those are there. The Shift and CTRL 
versions of increment/decrement week/year aren’t listed.

Are those hard coded or are they alterable accelerators? If the latter, then 
non-English users could customize them to suit.

Also, don’t forget these two which are in the Guide:

• ] or } to increment the month and [ or { to decrement the month

• T or t to enter today’s date

That last one is very useful if you’ve entered a different date and now want to 
enter something for today. (as GnuCash retains the last date you used as the 
default for the next transaction)

Regards,
Adrien

> On Sep 10, 2018, at 2:07 PM, David T. via gnucash-user 
>  wrote:
> 
> Hello,
> 
> In the course of looking at documentation improvements, I happened to look at 
> the program code for the date cells in GnuCash, and I discovered that there 
> are several quick keys for setting the date that I was unaware of, and I 
> thought I’d share with the list.
> 
> Most of us know about using =/- to add or subtract a day to the date shown. 
> 
> Some of us know that Shift =/- (_/+) increments a week at a time. 
> 
> A few of us know that using CTRL =/- increments a year at a time.
> 
> But I wonder how many people know that m/M sets the date to the beginning of 
> the month, and h/H set the date to the end of the month? Or that y/Y sets it 
> to the beginning of the year, while r/R sets it to the end?
> 
> Interesting little UI factoids! Too bad for non-English speakers; as the 
> mnemonics probably won’t make as much sense in French or German…
> 
> David
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


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

[GNC] Date Picker Info

[David T. via gnucash-user]

Hello,

In the course of looking at documentation improvements, I happened to look at 
the program code for the date cells in GnuCash, and I discovered that there are 
several quick keys for setting the date that I was unaware of, and I thought 
I’d share with the list.

Most of us know about using =/- to add or subtract a day to the date shown. 

Some of us know that Shift =/- (_/+) increments a week at a time. 

A few of us know that using CTRL =/- increments a year at a time.

But I wonder how many people know that m/M sets the date to the beginning of 
the month, and h/H set the date to the end of the month? Or that y/Y sets it to 
the beginning of the year, while r/R sets it to the end?

Interesting little UI factoids! Too bad for non-English speakers; as the 
mnemonics probably won’t make as much sense in French or German…

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

Re: [GNC] register columns

[David T. via gnucash-user]

Jim,

The short answer is “No, the columns are hard-coded.” If you wanted to change 
the order, you could, but you’d need to rewrite the code and compile from your 
modified source.  

David

> On Sep 10, 2018, at 11:24 AM, JIM <9031jbk...@att.net> wrote:
> 
> Is there some way I can change the column order in the register to match the 
> register in my checkbook?
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

[GNC] register columns

[JIM]

Is there some way I can change the column order in the register to match 
the register in my checkbook?


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

Re: [GNC] few questions on gnucash

[David Cousens]

Julie

How far you want to go back really depends on how much of your previous data
you will want to go back to in Gnucash. I guess that may depend upon how
long you will be able and need to be able to access the Quicken data. If
that is indefinitely by keeping a copy of the last Quicken version you used
then there is no great need. 

If you open the Equity:Opening Balances account register you will find the
transactions recording the opening balances for any accounts which had
existing balances. These will be usually only asset (bank accounts) and
liability accounts(credit cards loans etc). 

If you select the transaction and then click on the Split button in the
toolbar, it will open the transaction to display the two components (or
splits) of the transaction. Assuming your check book balance was in the
black when you opened the books the two splits should appear something like
this:
 Account Debit Credit
Equity:Opening Balances x
Asset:..: ChequeAccount  x 

You may have other similar transaction records for other bank accounts and
or liabilities like a credit card. For a credit card the debit and credit
will be reversed from what is shown above. 

 If there are no transactions there, then it is likely you did not assign an
opening balance or possibly assigned it to the wrong account. These should
have been created either when you created the original chart of accounts or
when you created an individual new account in the chart of accounts. 

In GnuCash you can look at a transaction from any of the account registers
for which the transaction has a split. 

So If you then open the Checking account register and go to the first
transaction, it should be the Opening Balance transaction and is usually
marked as such in the Description. Again click on it and then click on the
split button in the toolbar to open the splits.  It should be similar to the
above but the order of the rows will be reversed as the first row of the
splits in a register is usually to the account the register is for. Check
the account the second split goes to is the Equity :Opening Balances and the
amount matches. If it is going to the wrong account click on the Account
field for the second split and select the Equity:Opening Balances from the
drop down list. 

If you do have transactions in the Equity: Opening balances account then
check the amounts match and that the second split is assigned to the correct
account. If it is not click on the account column in the row of the second
split. You will get a down arrow at the right of the field and if you click
on that a drop down menu which will list accounts in the Chart of accounts.
Scroll through it to find the checking account in the list and then click on
it. 

 If there is no transaction at all in both the Asset:Checking account or the
Equity:Opening Balances then you can create one manually, Enter the date (
possibly the day before you commenced entering transactions in your GnuCash
books)  and a descrition opening balance. If you do this in the Checking
Account register the first split should open with the account filed set to
the Checking account. Enter the account balance in the debit column if the
account was in the black on that day (or the credit column if the account
had a negative balance - note the reversal of debit and credit from your
statement. For a bank your account is a liability and when you have funds in
it it will have a credit balance in their record).

Use the tab key to open the next row for the second split and tab to the
Account column. click and select the equity:Opening Balances from the drop
down list. Gnucash should automatically palce the amount you placed in the
debit column in the first split into the credit column of the second split.
If not, correct the amount. If the transaction were unbalanced i.e. the
debit and credit amounts were not the same, GnuCash will automatically
calculate the difference and apply it to the Imbalance account. 
Transactions generally have two splits, one debit and one credit but may
have any number of splits as long as the sum of the debits should equal the
sum of the credit associated with the transaction. 

The balance of the Imbalance account should always be 0. Any non zero amount
usually indicates a transaction has been entered without an account being
assigned to the second split and it needs to be corrected.

Hope that gets your accounts to display the expected balance.

David Cousens.



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

Re: [GNC] Stock & Mutual Fund Quotes Fail

[Megagrumpy]

Went ahead and edited the file as suggested and it works better for me now
than it ever has since we moved to Alphvantage. I only had one security out
of around 50 that did not work - before the recent problems I used to get
around 4 to 8 that failed to update. Thanks for a very simple and, so far,
effective solution.



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

Re: [GNC] few questions on gnucash

[Julie Julie]

Hello again.
Still learning GNU, but I wanted your advice. I had recorded my checking 
account info into QuickBooks and am now not able to open that program, which is 
why I’ve moved on to GNU. Should I copy all of my business checking 
transactions from previous years or should I start from this year only? Reason 
I ask is, even though I added the opening balance, it does not show it under 
the Assets/Checking Account. Maybe it is not supposed to, but I wanted my paper 
checkbook to match with the Checking Account screen. I hope that makes sense..

On Aug 6, 2018, at 1:51 AM, Christopher Lam 
mailto:christopher@gmail.com>> wrote:

Depending on how the sales taxes are recorded, the "Income & GST report" may be 
able to show sales/income and their taxes.

On Mon, 6 Aug 2018, 09:30 David Cousens 
mailto:davidcous...@bigpond.com>> wrote:
Julie

GnuCash is primarily a double entry accounting system. It is used world wide
so its functions are usually generic accounting rather than customized
solutions for a specific tax and legislative framework in a specific
jurisdiction

It can certainly record deposits and withdrawals from a check account. If
your bank supports certain banking and financial data protocols protocols
data can be downloaded directly from your bank to create entries in the
appropriate Asset, Income and Expense accounts. Usually OFX or CSV
downloaded files are supported by most banks but direct online access from
GnuCash to the bank is more variable. If you tells us where you are you may
be able to get more specific advice from users located near you.

GnuCash can handle some types of tax transactions but does require some user
intervention in defining appropriate tax tables and rules and appropriate
account structures. There is some guidance for setting up in specific
jurisdictions in the documentation and user forums. Most commonly VAT and
GST type taxes can be accounted for fairly easily.

GnuCash generally does not have a Sales Tax report as such. These are
generally very locality and tax authority dependant and variable in the
content required.  It does have a general transaction report that can be
restricted  to appropriate tax accounts and filtered to return transactions
which can then be exported and used in other programs or spreadsheet
software for further processing. Users can also generate and produce custom
reports but this requires some programming expertise.

You may get mor information aboput the suitability of GnuCash for your
purpose by reading the tutorial and Concepts Guide
https://www.gnucash.org/docs/v3/C/gnucash-guide/index.html.

David Cousens



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

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

Re: [GNC] Next release of F::Q

[Chris Good]

Erik Colson
 eco
at ecocode.net wrote on gnucash-user Thu Aug 16 05:20:42 EDT 2018

 

Hello all,

 

I'm on some extended vacation and will be back home next week.  My

intent is to release F::Q from master at the end of this month.

 

The alphavantage module has undergone some modifications which should

make it more reliable since we can now tell the module at which speed it

can question the alphavantage API.

 

Before releasing F::Q, I would like as many feedback as possible on the

best working arguments.  You can therefor play with the following

variables in the Alphavantage.pm file:

 

my $maxQueries = { quantity =>20 , seconds => 65}; # no more than x queries
per y seconds

 

Probably we should now set quantity to 5 and seconds to 61, but maybe

there are some better values?  The values above seem to work pretty well

on my automated home system.  Sometimes queries get rejected, but the

module is now smart enough to insert a delay if alphavantage API refuses

to answer queries.

 

The purpose of next release is to fix the problems with Alphavantage

speed control, so I won't add any other commits to other modules for

this release.  I've seen some messages on github concerning

Alphavantage.pm and will read those while enhancing the module.

 

best

--

erik colson

 

 

Hi Erik,

 

Thanks for working on this.

I have done some testing using the current github master Quote.pm &
AlphaVantage.pm.

 

Here are my results:

 

I have 16 stocks but only 1 currency.

 

Using the F::Q 1.47  code:

Only the first 5 stocks worked, the others failed.

 

Using your mods (& my variations in timing), there was never a failure to
return all the quotes requested. Yay!

 

Using your timing of no more than 20 queries per 65 seconds:

real3m0.735s

real2m20.476s

real2m19.217s

real2m17.692s

real2m19.923s

 

Using timing of no more than 5 queries per 60 seconds:

real3m2.503s

real3m2.320s

real2m9.449s

real2m32.282s

 

Using timing of no more than 5 queries per 59 seconds:

real2m59.858s

 

Using timing of no more than 20 queries per 50 seconds:

real3m1.121s

real2m38.678s

 

Looks like your 20 in 65 seconds is pretty good, which doesn't seem to agree
with

https://www.alphavantage.co/premium/ which says:

 

In certain high-frequency use cases that exceed our standard call-frequency
limit (5 requests per minute), we offer a dedicated, premium API key which
allows various tiers of API calls per minute.

 

Can you please release the new version asap?

 

Can you please also merge
https://github.com/finance-quote/finance-quote/pull/79 

  (yahooJSON.pm returns date 00/00/2000 in Windows)

as this also fixes perl warnings which can cause GnuCash to hang when
multiple quotes (>15) are requested.

 

Regards, Chris Good

 

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

Re: [GNC] Stock & Mutual Fund Quotes Fail

[Megagrumpy]

When I open the AlphaVantage.pm file in Notepad the lines do not neatly wrap
around as shown in your example so the are you show looks like - ; 
select(undef, undef, undef, .7) if ($quantity);   }   return wantarray() ?
%info : \%info;  }

I have had to take out some spaces to stop it wrapping in this box!  Can I
just add the Sleep statement in line or do I have to have a CR or some other
delimiter?




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