Re: [GNC] General Ledger

[Adrian Yong]

I can't change the file type...

Neither can I access Excel by choosing Open With...

Finally got to add file type extension .csv to filename. That worked... I
think gnucash should either addd anothe filetype dialog box or advise users
to add filetype extension to the filename.

Thanks

On Sun, Mar 29, 2020 at 10:58 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> I could be mistaken, but when you save, you should be able to specify a
> file extension. If not, simply change it after the fact to “.csv” and see
> if Excel is offered as a default app to open it.
>
> Otherwise, you can still open it with Excel via the right-click menu using
> a ‘open with’ option, or, start Excel first, then try to File > Open, or
> Insert > Sheet from File operation.
>
> Regards,
> Adrien
>
> > On Mar 28, 2020 w13d88, at 9:40 PM, Adrian Yong <
> adrianyong.88p...@gmail.com> wrote:
> >
> > Hi Adrien,
> >
> > Below is the screenshot... I get a file type FILE.
> >
> > 
> >
> > When I double click on the file to open it, Excel is not on the list:
> >
> > 
> >
> > Wish is not surprising because the file is a .csv file...
> >
> > Regards,
> > Adrian
> >
>
>
> ___
> 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] General Ledger

[Adrien Monteleone]

I could be mistaken, but when you save, you should be able to specify a file 
extension. If not, simply change it after the fact to “.csv” and see if Excel 
is offered as a default app to open it.

Otherwise, you can still open it with Excel via the right-click menu using a 
‘open with’ option, or, start Excel first, then try to File > Open, or Insert > 
Sheet from File operation.

Regards,
Adrien

> On Mar 28, 2020 w13d88, at 9:40 PM, Adrian Yong  
> wrote:
> 
> Hi Adrien,
> 
> Below is the screenshot... I get a file type FILE.
> 
> 
> 
> When I double click on the file to open it, Excel is not on the list:
> 
> 
> 
> Wish is not surprising because the file is a .csv file...
> 
> Regards,
> Adrian
> 


___
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] General Ledger

[Adrien Monteleone]

CSV files can be opened in Excel or just about any spreadsheet app. There are 
also options to ‘Export Transactions’ and ‘Export Active Register”. The Account 
Tree is just a shell of a list of accounts with no transactions. I’m not 
familiar with how that is different from ‘Export Accounts’. Perhaps someone 
more knowledgeable can shed light. Honestly, an export isn’t probably all that 
useful. Reports are more likely what they are looking for.

Acrobat is for PDF files only as far as I am aware.

What *exactly* are you being asked to provide by the auditors?

What do you mean by ‘cannot be opened in MSExcel’? Are you getting a specific 
error? What is the text of the error?

Regards,
Adrien



> On Mar 28, 2020 w13d88, at 9:09 PM, Adrian Yong  
> wrote:
> 
> Hi Adrien,
> 
> I tried exporting the "Export Account Tree to csv" and "Export Accounts" 
> options.
> 
> However the exported files cannot be opened in MSExcel nor Acrobat Reader 
> DC...
> 
> Regards,
> Adrian


___
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] General Ledger

[Adrian Yong]

Hi Adrien,

I tried exporting the "Export Account Tree to csv" and "Export Accounts"
options.

However the exported files cannot be opened in MSExcel nor Acrobat Reader
DC...

Regards,
Adrian

On Thu, Mar 19, 2020 at 8:30 AM Adrian Yong 
wrote:

> Thanks Adrien..
>
> On Thu, 19 Mar. 2020, 08:29 Adrien Monteleone, <
> adrien.montele...@lusfiber.net> wrote:
>
>> If they find info is missing or they don’t care for the formats, report
>> back here and we’ll try to help you refine them.
>>
>> Regards,
>> Adrien
>>
>> > On Mar 18, 2020 w12d78, at 6:01 PM, Adrian Yong <
>> adrianyong.88p...@gmail.com> wrote:
>> >
>> > Thank you very much, Adrien, Michael and Stephen for helping me
>> understand
>> > Gnucash...
>> >
>> > I will submit the documents as suggested by Stephen and see what the
>> > auditors say... They are CPAs...
>>
>> ___
>> 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] looking for quicken alternative

[Adrien Monteleone]

The GnuCash interface is more like a traditional pen and paper check register.

As for connecting to banks and brokerages, mileage varies by institution.

It does not, as far as I’m aware, allow one to create a transaction offline and 
then sync it to your bank. But downloading bank transactions is certainly 
possible.

You can enter just about anything you want manually otherwise.

Regards,
Adrien


> On Mar 27, 2020 w13d87, at 4:11 PM, Ken Cohen via gnucash-user 
>  wrote:
> 
> thanks for your response. sounds like it is more spreadsheet type oriented, 
> correct? Also, does this app connect to my bank and brokerage acct to 
> download transactions? One of my brokerage accts trades frequently and 
> entering all that by hand would be a big chore? Quicken seems to do this much 
> more efficiently.
> Ken
> 


___
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] Contingency Funds was: Re: How to record Personal income tax ?

[Michael or Penny Novack]

On 3/27/2020 9:11 PM, Long wrote:

Hello David Cousens,

Thank you for your help, I knew what i need to do if i choose "Accrual
Accounting".
What i'm asking you is : If the end of the year, I credit my Expense:Tax and
debit Liability:Tax 2000$, at this time, on DECEMBER in my "Income Statement
(multicolumn)" (It's a Report option to show you, What you have spent and
your revenue each month for the period time) it will show the negative
value.


I think there are two things you will need to do.

The first is to read some tutorial or text "introduction to double entry 
bookkeeping with emphasis on trying to understand what the differences 
between "cash" and "accrual" basis are and what they are not. Also with 
accrual accounting,  how adjustments are made then the actuals (when 
these become known) do not match what was originally entered.


The second is to try to understand time/date of financial statements. 
When I settle up with the government is it NEVER in the same year as the 
taxes were for. Thus I could never expect the "tax expense" on the end 
of year report to be anything other than an estimate of tax expense. I 
won't know the actual amount (may be either more or less) until I do my 
taxes and settle with the IRS.


So in your example, starting the NEXT year with -2000 in tax expense is 
correct because your P&L for the year just ended had been overestimated 
by 2000.  Maybe you would feel more comfortable entering the correction 
transaction as a so called "journal transaction. Accounts of type income 
and expense are actually temporary accounts of fundamental type equity. 
So when you settle with the government, instead of:


tax liability  debit 12,000    cash credit 10,000   tax expense credit 2,000

tax liability  debit 12,000    cash credit 10,000   equity credit 2,000

This is correct. Your previous year end report had you 2,000 poorer than 
you really were (because you didn't really owe the gov't as much as you 
thought you did. You are now correcting that by increasing your equity 
by that amount. On the other hand, you might prefer the -2000 in tax 
expense if you want to look at a series of YE reports for the 
information "what is my tax expense per year" << look ahead to the 
following years assuming the amounts continue the same >>


Michael D Novack

PS -- Gnucash doesn't substitute for learning basic accounting, you 
still  have to learn that, and we are here to help with HOW when using 
gnucash and not the WHAT of basic accounting.






___
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] looking for quicken alternative

[Michael or Penny Novack]

On 3/27/2020 5:11 PM, Ken Cohen via gnucash-user wrote:

  thanks for your response. sounds like it is more spreadsheet type oriented, 
correct? Also, does this app connect to my bank and brokerage acct to download 
transactions? One of my brokerage accts trades frequently and entering all that 
by hand would be a big chore? Quicken seems to do this much more efficiently.
Ken


I am not sure what you are saying. Gnucash is a (standard) double entry 
bookkeeping application.


Spreadsheet? Anybody who is experienced doing double entry bookkeeping 
the old fashioned way, pen and ink on paper, could certainly use a 
spreadsheet app, simply setting the columns the way they would be on 
journal and ledger pages. Gnucash is easier. Instead of entering in the 
journal and then posting into the ledger, enter directly into the ledger 
and the journal is virtual. Very much like "cashbook" accounting in the 
old days (where the most "popular" accounts were handled this way when 
the other side of the transaction "cash", only the rarer transactions 
first entered into the journal and then posted. The cashbook was instead 
posted only at the bottom of each page plus the end of the accounting 
period. Saved a lot of time and posting errors).  With gnucash, no 
posting/transcription or arithmetic  errors and immediate indication if 
out of balance.


As far as I know, Quicken doesn't do standard double entry bookkeeping.  
So in a way, apples and oranges


Michael D Novack


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

Re: [GNC] looking for quicken alternative

[Ken Cohen via gnucash-user]

 thanks for your response. sounds like it is more spreadsheet type oriented, 
correct? Also, does this app connect to my bank and brokerage acct to download 
transactions? One of my brokerage accts trades frequently and entering all that 
by hand would be a big chore? Quicken seems to do this much more efficiently.
Ken

On Friday, March 27, 2020, 11:33:18 AM MST, David Carlson 
 wrote:  
 
 Ken, 
One issue that may be of concern to you is the way Gnucash tracks capital 
gains.  It cannot follow tax law definitions exactly by default as that 
requires tracking expenses such as fees in a very complex way to apply partial 
fees to the cost basis when partial closing transactions occur. 
Many users track cost basis separately, especially if they have "lots" of 
transactions [pun intended].  See discussions about lot tracking for more 
details.
David Carlson 



On Fri, Mar 27, 2020, 11:09 AM Alton Brantley  wrote:

I was in the same boat, and made the conversion, and would never go back.

There are a few steps to take to accomplish the migration, and to understand 
the conceptual differences between the two programs.
However, it’s worth it once you get the process working for you.

If you have any questions, you can always contact this list or look up past 
responses to similar questions in the archives.

> Date: Fri, 27 Mar 2020 05:20:43 + (UTC)
> From: Ken Cohen mailto:kcoh...@yahoo.com>>
> To: "gnucash-user@gnucash.org " 
> mailto:gnucash-user@gnucash.org>>
> Subject: [GNC] looking for quicken alternative
> Message-ID: <57147887.1864901.1585286443...@mail.yahoo.com 
> >
> Content-Type: text/plain; charset=UTF-8
> 
> I have used Quicken for well over 15 years but continue to have problems with 
> the software. I am looking for a replacement that can download transactions 
> from my bank and Schwab brokerage and maintain detail security information 
> including lots purchased and cost basis. Is gnucash a program that can 
> accommodate that?thanks,Ken
___
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.