[GNC] First request to kindly help

2024-07-04 Thread Norbert Klein via gnucash-user

My name is Norbert Klein, German, since 1990 in Cambodia, 90 years old,
but still alive and interested.

After this self-introduction, I would like to ask for your help. I read
since some days the GnuCash user mailing list, and I see the many
detailed qestion raised and responded. Several years ago, I had been
using GnuCash, but because of changed working responsibilities this had
been given up – and I do not have any copies. But the new task is
similar: to set up a general income-and-expenses system, with the two
currencies US$ and Cambodian/Khmer Riel – with the widely used fixed
rate of US$1.00 to Riel 4,000.

Then I tried to clean my Windows 10 notebook from any remaining old
“*gnu*” file which might have reamined from before.

I downloaded gnucash-5.7.setup.exe and started the installation, and the
installation happened in

C:\System\ProgramFiles(x86)\gnucash

I was happy to see that also a GnuCash icon had been created on the
desktop, and I hoped I could now start to set up the GnuCash program –
but here my frustration started.

I tried for several hours to solve it – in vain. I describe here what I
got, and I ask for your advice.

After clicking on the GnuCash icon, I get – only very short – a kind of
general GnuCash display picture, and then a GnuCash Tip-of-the-Day.
These disappear quickly, and a full screen field shows up:

Unsaved Book - GnuCash

File     Edit     View     Actions Business   Reports     Tools
Windows   Help (9 items)

Save Close
(with a grayed out Down Arrow)   (with a crossed out x-sign)

When click I see:  When click I see:
Save the current file.            Close the current active page.

But I cannot use these activations – but I can close the whole screen.

I had also tried the 9 items above – but I did not find out where these
contacts would lead me.

So I am totally frustrated, and I started to write to the help list.

Please help.

Norbert




--
This email has been checked for viruses by Avast antivirus software.
www.avast.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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] First request to kindly help

2024-07-04 Thread David Cousens
Hi Norbert,

When you run GnuCash for the first time there is no existing file. If
you go to the menu File->Save As you will get a dialogue allowing you
to select a location on your hard disk in which to save the file and
give it a name.  It is generally recommended that you create a
directory in which to sabve the file for each set of books you create.
The dialogue will allow you to create a new directory and name it as
well as give a name to the GnuCash data file.  Once you have saved the
file to the desired location you can then start setting up the Chart of
Accounts. The window will have opened with an accounts tab open. If you
then click on the Actions->New Account Heirarchy you can select from
some of the presetup account heirarchies and add and remove accounts as
you need.

David Cousens

On Thu, 2024-07-04 at 14:30 +0700, Norbert Klein via gnucash-user
wrote:
> My name is Norbert Klein, German, since 1990 in Cambodia, 90 years
> old,
> but still alive and interested.
> 
> After this self-introduction, I would like to ask for your help. I
> read
> since some days the GnuCash user mailing list, and I see the many
> detailed qestion raised and responded. Several years ago, I had been
> using GnuCash, but because of changed working responsibilities this
> had
> been given up – and I do not have any copies. But the new task is
> similar: to set up a general income-and-expenses system, with the two
> currencies US$ and Cambodian/Khmer Riel – with the widely used fixed
> rate of US$1.00 to Riel 4,000.
> 
> Then I tried to clean my Windows 10 notebook from any remaining old
> “*gnu*” file which might have reamined from before.
> 
> I downloaded gnucash-5.7.setup.exe and started the installation, and
> the
> installation happened in
> 
> C:\System\ProgramFiles(x86)\gnucash
> 
> I was happy to see that also a GnuCash icon had been created on the
> desktop, and I hoped I could now start to set up the GnuCash program
> –
> but here my frustration started.
> 
> I tried for several hours to solve it – in vain. I describe here what
> I
> got, and I ask for your advice.
> 
> After clicking on the GnuCash icon, I get – only very short – a kind
> of
> general GnuCash display picture, and then a GnuCash Tip-of-the-Day.
> These disappear quickly, and a full screen field shows up:
> 
> Unsaved Book - GnuCash
> 
> File     Edit     View     Actions Business   Reports     Tools
> Windows   Help (9 items)
> 
> Save Close
> (with a grayed out Down Arrow)   (with a crossed out x-sign)
> 
> When click I see:  When click I see:
> Save the current file.            Close the current active page.
> 
> But I cannot use these activations – but I can close the whole
> screen.
> 
> I had also tried the 9 items above – but I did not find out where
> these
> contacts would lead me.
> 
> So I am totally frustrated, and I started to write to the help list.
> 
> Please help.
> 
> Norbert
> 
> 
> 
> 
> --
> This email has been checked for viruses by Avast antivirus software.
> www.avast.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
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] GC crashing after upgrade

2024-07-04 Thread Geert Janssens
Op woensdag 3 juli 2024 22:32:48 CEST schreef John Ralls:
> No need for a VM on macOS, app bundles are completely self-contained except
> for Finance::Quote. You can have as many different versions of GnuCash
> installed as you like as long as they have different names or you put them
> in different folders.
> 
Out of curiosity, how does MacOS handle file associations in this case ?

Ignoring for a moment that on MacOS you can't tell gnucash to open a datafile 
that 
way, gnucash is still launched when you double-click a datafile. If you have 
multiple 
versions of gnucash installed, which version will be launched ?

Regards,

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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Credit card reconciliation - starting balance

2024-07-04 Thread Trevor Richards via gnucash-user
Thanks for the suggestions but don't think they help.I've tried reconciliation 
stepping back to months previous to when I 1st opened these accounts.It always 
opens with the same starting balance... 4,448.06Ending balances are zero (not 
surprising... no transactions)

I do get a successful reconciliation on the corresponding bank account that is 
connected to the credit card

On Tuesday, 2 July 2024 at 06:26:06 GMT+12, Tommy Trussell 
 wrote:  
 
 In addition to the comments below, you will need to make sure you entered the 
transactions in the correct columns. 
Make sure the account was correctly set up as a liability account (so its 
ending balance will decrease your overall net assets balance). When you enter 
credit card transactions into the account, its running balance should go up, 
and when you enter payments (last month's card payment in this case) its 
balance should go down. The debit (left) column will contain the payments to 
the credit card bank, and the credit (right) column will contain the individual 
credit card transactions. 
If it has been awhile since you have looked at the documentation, it's a good 
time to review the chapter on Credit Cards
https://lists.gnucash.org/docs/C/gnucash-guide/chapter_cc.html


On Mon, Jul 1, 2024 at 12:45 PM Phyllis Bruce  wrote:

Trevor, did you enter the unreconciled transactions from the previous
month?  Those would have to be included for your first reconciliation.

Phyllis B

On Mon, Jul 1, 2024 at 12:24 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Have you ever reconciled this account? If not, the starting balance
> should have been zero.
>
> Regards,
> Adrien
>
> On 7/1/24 4:34 AM, Trevor Richards via gnucash-user wrote:
> > I am failing to reconcile a CC account. The ledger appears to replicate
> my statement in the 1st month of transactions. The 1st transaction I
> entered was the starting balance from the previous month's CC stmt (105.00)
> and all transactions appear correct in the months that follow. When I try
> to reconcile this CC account, it tells me my starting balance is 4,448.06.
> Where did that come from?
> >
> > I've searched my GNUcash file and that number does not come up.
> > Trevor (stumped)
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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
To update your subscription preferences or to unsubscribe:
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
To update your subscription preferences or to unsubscribe:
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.


[GNC] Editing the Quicken/Quickbooks check layout

2024-07-04 Thread Gerard Dupczak
Is there a way to edit the Quicken/Quickbooks 3-part check layout? My 
checks mostly align but the written check amount and the items below 
that are off by about 1/2 a line.


I haven't been able to locate the file that has that layout.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Credit card reconciliation - starting balance

2024-07-04 Thread Liz
On Thu, 4 Jul 2024 09:53:06 + (UTC)
Trevor Richards via gnucash-user  wrote:

> Thanks for the suggestions but don't think they help.I've tried
> reconciliation stepping back to months previous to when I 1st opened
> these accounts.It always opens with the same starting balance...
> 4,448.06Ending balances are zero (not surprising... no transactions)
> 
> I do get a successful reconciliation on the corresponding bank
> account that is connected to the credit card


At this point I'm getting confused.
Do the bank account and credit card have separate statements?
What is the connection between them?
I'm sure things are different in various parts of the world, however my
debit card is connected to a bank deposit account and shares the same
statement, whereas my credit cards have always had complete separation
from any deposit account.

Can you tell us about the system, because it may have a bearing on why
you have funny results on reconciliation.

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] GC crashing after upgrade

2024-07-04 Thread Flyeta via gnucash-user
For me, MacOS (I’m on Sonoma 14.5) opens the file with the most recent version 
of Gnucash. I’ve suffixed all my  Gnucash versions with the version number 
(Gnucash-5.6, etc.). 

There is a user setting available by choosing “Get Info” on any data file that 
allows one to “Open with:” and choose the desired application to open that file 
when the data file is double-clicked. One can then click a “Change All..” 
button to “Use this application to open all documents like this one,” 
presumably with the same filename suffix. This all worked as expected for me 
when I tested making Gnucash-5.1 the default application. 

I don’t know how all that works "under the hood”.

Andrew

> On Jul 4, 2024, at 4:21 AM, Geert Janssens  wrote:
> 
> Op woensdag 3 juli 2024 22:32:48 CEST schreef John Ralls:
>> No need for a VM on macOS, app bundles are completely self-contained except
>> for Finance::Quote. You can have as many different versions of GnuCash
>> installed as you like as long as they have different names or you put them
>> in different folders.
>> 
> Out of curiosity, how does MacOS handle file associations in this case ?
> 
> Ignoring for a moment that on MacOS you can't tell gnucash to open a datafile 
> that 
> way, gnucash is still launched when you double-click a datafile. If you have 
> multiple 
> versions of gnucash installed, which version will be launched ?
> 
> Regards,
> 
> 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
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Credit card reconciliation - starting balance

2024-07-04 Thread Derek Atkins
Have you ever reconciled this account before?

You cannot reconcile "back in time".  I.e. once you reconcile to time T,
you have effectively reconciled from the beginning of time to time T. 
What this means is that you cannot go back and later reconcile to a time
BEFORE T.  Part of the reason is that the starting balance is the sum of
all reconciled transactions in the account.

As a practical example, let's say you start and put an opening balance of
$1000 on June 1, 2024 and then reconcile your transactions as of June 30,
2024.  After this, you cannot go back and re-fill January thru May,
because the "opening" balance will include all your (june) reconciled
transactions.

If you started with an opening balance, reconciled, and then go back and
filled in transactions prior to the opening balance, the only thing you
can do is re-reconcile to the SAME place (e.g. re-reconcile June 30,
2024); ignore the opening balance, make sure the ending balance is
correct, and check-off all the prior transactions from the beginning of
time to your reconcile date.

Hope this helps!

-derek

On Thu, July 4, 2024 5:53 am, Trevor Richards via gnucash-user wrote:
> Thanks for the suggestions but don't think they help.I've tried
> reconciliation stepping back to months previous to when I 1st opened these
> accounts.It always opens with the same starting balance... 4,448.06Ending
> balances are zero (not surprising... no transactions)
>
> I do get a successful reconciliation on the corresponding bank account
> that is connected to the credit card
>
> On Tuesday, 2 July 2024 at 06:26:06 GMT+12, Tommy Trussell
>  wrote:
>
>  In addition to the comments below, you will need to make sure you entered
> the transactions in the correct columns. 
> Make sure the account was correctly set up as a liability account (so its
> ending balance will decrease your overall net assets balance). When you
> enter credit card transactions into the account, its running balance
> should go up, and when you enter payments (last month's card payment in
> this case) its balance should go down. The debit (left) column will
> contain the payments to the credit card bank, and the credit (right)
> column will contain the individual credit card transactions. 
> If it has been awhile since you have looked at the documentation, it's a
> good time to review the chapter on Credit Cards
> https://lists.gnucash.org/docs/C/gnucash-guide/chapter_cc.html
>
>
> On Mon, Jul 1, 2024 at 12:45 PM Phyllis Bruce  wrote:
>
> Trevor, did you enter the unreconciled transactions from the previous
> month?  Those would have to be included for your first reconciliation.
>
> Phyllis B
>
> On Mon, Jul 1, 2024 at 12:24 PM Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
>
>> Have you ever reconciled this account? If not, the starting balance
>> should have been zero.
>>
>> Regards,
>> Adrien
>>
>> On 7/1/24 4:34 AM, Trevor Richards via gnucash-user wrote:
>> > I am failing to reconcile a CC account. The ledger appears to
>> replicate
>> my statement in the 1st month of transactions. The 1st transaction I
>> entered was the starting balance from the previous month's CC stmt
>> (105.00)
>> and all transactions appear correct in the months that follow. When I
>> try
>> to reconcile this CC account, it tells me my starting balance is
>> 4,448.06.
>> Where did that come from?
>> >
>> > I've searched my GNUcash file and that number does not come up.
>> > Trevor (stumped)
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> 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
> To update your subscription preferences or to unsubscribe:
> 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
> To update your subscription preferences or to unsubscribe:
> 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.
>


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

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Credit card reconciliation - starting balance

2024-07-04 Thread Trevor Richards via gnucash-user
Hi Derek,I set up this account based on a credit card statement as an arbitrary 
starting point Aug last year.The stmt showed 105.00 as balance BF so I created 
that as my opening balance (owed). It balances with an account called opening 
balances (I think as instructed by GNU)all the following monthly transactions 
match the CC stmts (purchases & monthly payments from my savings acc)The 
savings acc reconciles OKThe CC account always shows starting balance of 
4,448.06 when I try to reconcile any month 
The ledger matches the stmts. 
your comments make no sense to me. I can press the reconcile button forcing any 
dates I like. I do realize that it is pointless reconciling prior to start 
dates but I'm just pointing out that 4,448.06 is always the starting balance... 
I know not from where


   On Thursday, 4 July 2024 at 23:52:09 GMT+12, Derek Atkins  
wrote:  
 
 Have you ever reconciled this account before?

You cannot reconcile "back in time".  I.e. once you reconcile to time T,
you have effectively reconciled from the beginning of time to time T. 
What this means is that you cannot go back and later reconcile to a time
BEFORE T.  Part of the reason is that the starting balance is the sum of
all reconciled transactions in the account.

As a practical example, let's say you start and put an opening balance of
$1000 on June 1, 2024 and then reconcile your transactions as of June 30,
2024.  After this, you cannot go back and re-fill January thru May,
because the "opening" balance will include all your (june) reconciled
transactions.

If you started with an opening balance, reconciled, and then go back and
filled in transactions prior to the opening balance, the only thing you
can do is re-reconcile to the SAME place (e.g. re-reconcile June 30,
2024); ignore the opening balance, make sure the ending balance is
correct, and check-off all the prior transactions from the beginning of
time to your reconcile date.

Hope this helps!

-derek

On Thu, July 4, 2024 5:53 am, Trevor Richards via gnucash-user wrote:
> Thanks for the suggestions but don't think they help.I've tried
> reconciliation stepping back to months previous to when I 1st opened these
> accounts.It always opens with the same starting balance... 4,448.06Ending
> balances are zero (not surprising... no transactions)
>
> I do get a successful reconciliation on the corresponding bank account
> that is connected to the credit card
>
>    On Tuesday, 2 July 2024 at 06:26:06 GMT+12, Tommy Trussell
>  wrote:
>
>  In addition to the comments below, you will need to make sure you entered
> the transactions in the correct columns. 
> Make sure the account was correctly set up as a liability account (so its
> ending balance will decrease your overall net assets balance). When you
> enter credit card transactions into the account, its running balance
> should go up, and when you enter payments (last month's card payment in
> this case) its balance should go down. The debit (left) column will
> contain the payments to the credit card bank, and the credit (right)
> column will contain the individual credit card transactions. 
> If it has been awhile since you have looked at the documentation, it's a
> good time to review the chapter on Credit Cards
> https://lists.gnucash.org/docs/C/gnucash-guide/chapter_cc.html
>
>
> On Mon, Jul 1, 2024 at 12:45 PM Phyllis Bruce  wrote:
>
> Trevor, did you enter the unreconciled transactions from the previous
> month?  Those would have to be included for your first reconciliation.
>
> Phyllis B
>
> On Mon, Jul 1, 2024 at 12:24 PM Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
>
>> Have you ever reconciled this account? If not, the starting balance
>> should have been zero.
>>
>> Regards,
>> Adrien
>>
>> On 7/1/24 4:34 AM, Trevor Richards via gnucash-user wrote:
>> > I am failing to reconcile a CC account. The ledger appears to
>> replicate
>> my statement in the 1st month of transactions. The 1st transaction I
>> entered was the starting balance from the previous month's CC stmt
>> (105.00)
>> and all transactions appear correct in the months that follow. When I
>> try
>> to reconcile this CC account, it tells me my starting balance is
>> 4,448.06.
>> Where did that come from?
>> >
>> > I've searched my GNUcash file and that number does not come up.
>> > Trevor (stumped)
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> 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
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can 

Re: [GNC] GC crashing after upgrade

2024-07-04 Thread Geert Janssens
Good to know, thanks!

Geert

Op donderdag 4 juli 2024 13:16:12 CEST schreef Andrew Tomlinson:
> For me, MacOS (I’m on Sonoma 14.5) opens the file with the most recent
> version of Gnucash. I’ve suffixed all my  Gnucash versions with the version
> number (Gnucash-5.6, etc.).
> 
> There is a user setting available by choosing “Get Info” on any data file
> that allows one to “Open with:” and choose the desired application to open
> that file when the data file is double-clicked. One can then click a
> “Change All..” button to “Use this application to open all documents like
> this one,” presumably with the same filename suffix. This all worked as
> expected for me when I tested making Gnucash-5.1 the default application.
> 
> I don’t know how all that works "under the hood”.
> 
> Andrew
> 
> > On Jul 4, 2024, at 4:21 AM, Geert Janssens 
> > wrote:> 
> > Op woensdag 3 juli 2024 22:32:48 CEST schreef John Ralls:
> >> No need for a VM on macOS, app bundles are completely self-contained
> >> except
> >> for Finance::Quote. You can have as many different versions of GnuCash
> >> installed as you like as long as they have different names or you put
> >> them
> >> in different folders.
> > 
> > Out of curiosity, how does MacOS handle file associations in this case ?
> > 
> > Ignoring for a moment that on MacOS you can't tell gnucash to open a
> > datafile that way, gnucash is still launched when you double-click a
> > datafile. If you have multiple versions of gnucash installed, which
> > version will be launched ?
> > 
> > Regards,
> > 
> > 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
> > -
> > 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] How to handle recurring transactions with currency conversion

2024-07-04 Thread Michael or Penny Novack

On 7/3/2024 5:14 PM, R Losey wrote:

Just to keep them separate, I would use usd_amount and chf_amount for the
variables.

I kind of ignore the currency exchange rate... I enter everything as USD
because I live in America, and my bank accounts and credit cards are in
USD.  So, if I have a euro transaction, I may enter it with a guess,  but
usually I look up how much it turns into in USD and use that number for the
price of the transaction.

This of course would not work out if I had some bank accounts in USD and
another in CHF.


This is a perfect example of when to use THIS solution to the multiple 
currency issue. It is the "business analysis" that should take place 
BEFORE choosing how to handle (using gnucash).   An opposite example " I 
live part of the year in A, part of the year in B, different currencies, 
bank accounts in each, only a few transactions a year sending money 
between, but taxes needed to be figured for both". THAT would seem to 
make the "separate books" solution more practical, perhaps using reports 
out if both to get the data to construct reports (outside gnucash )   
for total net worth, what is needed for tax filings, etc. << probably 
just once a year?".


Notice this is not JUST when multiple currencies involved. But I haven't 
yet seen asked on this list "the only currency is EUR, but part year one 
country, part in another, have to be able to do tax filings for both"


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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Credit card reconciliation - starting balance

2024-07-04 Thread Derek Atkins
Hi,

Have you ever reconciled this account before?  Even as a test?

On Thu, July 4, 2024 8:25 am, Trevor Richards wrote:
> Hi Derek,I set up this account based on a credit card statement as an
> arbitrary starting point Aug last year.The stmt showed 105.00 as balance
> BF so I created that as my opening balance (owed). It balances with an
> account called opening balances (I think as instructed by GNU)all the
> following monthly transactions match the CC stmts (purchases & monthly
> payments from my savings acc)The savings acc reconciles OK

Different accounts.  Most likely your Savings/Checking account only has
transactions to pay the credit card, so I wouldn't expect much there.

> The CC account
> always shows starting balance of 4,448.06 when I try to reconcile any
> month
> The ledger matches the stmts.

This is good...

> your comments make no sense to me. I can press the reconcile button
> forcing any dates I like. I do realize that it is pointless reconciling
> prior to start dates but I'm just pointing out that 4,448.06 is always the
> starting balance... I know not from where

Which part makes no sense?   My point is that reconciliation is not
month-to-month, it is always from the beginning of time to the end of the
statement.

The 4,448.06 is coming from previously reconciled transactions, or from a
marking in the account that it was previously reconciled to 4,446.08.

Are you willing to share your data file?  Or maybe attach some screen
shots of your register(s)?  (NB: Please attach, not "include")

-derek

>
>
>On Thursday, 4 July 2024 at 23:52:09 GMT+12, Derek Atkins
>  wrote:
>
>  Have you ever reconciled this account before?
>
> You cannot reconcile "back in time".  I.e. once you reconcile to time T,
> you have effectively reconciled from the beginning of time to time T.
> What this means is that you cannot go back and later reconcile to a time
> BEFORE T.  Part of the reason is that the starting balance is the sum of
> all reconciled transactions in the account.
>
> As a practical example, let's say you start and put an opening balance of
> $1000 on June 1, 2024 and then reconcile your transactions as of June 30,
> 2024.  After this, you cannot go back and re-fill January thru May,
> because the "opening" balance will include all your (june) reconciled
> transactions.
>
> If you started with an opening balance, reconciled, and then go back and
> filled in transactions prior to the opening balance, the only thing you
> can do is re-reconcile to the SAME place (e.g. re-reconcile June 30,
> 2024); ignore the opening balance, make sure the ending balance is
> correct, and check-off all the prior transactions from the beginning of
> time to your reconcile date.
>
> Hope this helps!
>
> -derek
>
> On Thu, July 4, 2024 5:53 am, Trevor Richards via gnucash-user wrote:
>> Thanks for the suggestions but don't think they help.I've tried
>> reconciliation stepping back to months previous to when I 1st opened
>> these
>> accounts.It always opens with the same starting balance...
>> 4,448.06Ending
>> balances are zero (not surprising... no transactions)
>>
>> I do get a successful reconciliation on the corresponding bank account
>> that is connected to the credit card
>>
>>    On Tuesday, 2 July 2024 at 06:26:06 GMT+12, Tommy Trussell
>>  wrote:
>>
>>  In addition to the comments below, you will need to make sure you
>> entered
>> the transactions in the correct columns. 
>> Make sure the account was correctly set up as a liability account (so
>> its
>> ending balance will decrease your overall net assets balance). When you
>> enter credit card transactions into the account, its running balance
>> should go up, and when you enter payments (last month's card payment in
>> this case) its balance should go down. The debit (left) column will
>> contain the payments to the credit card bank, and the credit (right)
>> column will contain the individual credit card transactions. 
>> If it has been awhile since you have looked at the documentation, it's a
>> good time to review the chapter on Credit Cards
>> https://lists.gnucash.org/docs/C/gnucash-guide/chapter_cc.html
>>
>>
>> On Mon, Jul 1, 2024 at 12:45 PM Phyllis Bruce 
>> wrote:
>>
>> Trevor, did you enter the unreconciled transactions from the previous
>> month?  Those would have to be included for your first reconciliation.
>>
>> Phyllis B
>>
>> On Mon, Jul 1, 2024 at 12:24 PM Adrien Monteleone <
>> adrien.montele...@lusfiber.net> wrote:
>>
>>> Have you ever reconciled this account? If not, the starting balance
>>> should have been zero.
>>>
>>> Regards,
>>> Adrien
>>>
>>> On 7/1/24 4:34 AM, Trevor Richards via gnucash-user wrote:
>>> > I am failing to reconcile a CC account. The ledger appears to
>>> replicate
>>> my statement in the 1st month of transactions. The 1st transaction I
>>> entered was the starting balance from the previous month's CC stmt
>>> (105.00)
>>> and all transactions appear correct in the months that follow. When I
>>> try

Re: [GNC] First request to kindly help

2024-07-04 Thread david amaral via gnucash-user
 To set up a "NEW" gnucash file, make sure that your windows documents 
directory has no gnucash directory in iteither delete all the files in it or 
rename the gnucash directory "OLD_gnucash" to save any older files you may have.
On Thursday, July 4, 2024 at 12:32:26 AM MST, Norbert Klein via 
gnucash-user  wrote:  
 
 My name is Norbert Klein, German, since 1990 in Cambodia, 90 years old,
but still alive and interested.

After this self-introduction, I would like to ask for your help. I read
since some days the GnuCash user mailing list, and I see the many
detailed qestion raised and responded. Several years ago, I had been
using GnuCash, but because of changed working responsibilities this had
been given up – and I do not have any copies. But the new task is
similar: to set up a general income-and-expenses system, with the two
currencies US$ and Cambodian/Khmer Riel – with the widely used fixed
rate of US$1.00 to Riel 4,000.

Then I tried to clean my Windows 10 notebook from any remaining old
“*gnu*” file which might have reamined from before.

I downloaded gnucash-5.7.setup.exe and started the installation, and the
installation happened in

C:\System\ProgramFiles(x86)\gnucash

I was happy to see that also a GnuCash icon had been created on the
desktop, and I hoped I could now start to set up the GnuCash program –
but here my frustration started.

I tried for several hours to solve it – in vain. I describe here what I
got, and I ask for your advice.

After clicking on the GnuCash icon, I get – only very short – a kind of
general GnuCash display picture, and then a GnuCash Tip-of-the-Day.
These disappear quickly, and a full screen field shows up:

Unsaved Book - GnuCash

File     Edit     View     Actions Business   Reports     Tools
Windows   Help (9 items)

Save Close
(with a grayed out Down Arrow)   (with a crossed out x-sign)

When click I see:  When click I see:
Save the current file.            Close the current active page.

But I cannot use these activations – but I can close the whole screen.

I had also tried the 9 items above – but I did not find out where these
contacts would lead me.

So I am totally frustrated, and I started to write to the help list.

Please help.

Norbert




--
This email has been checked for viruses by Avast antivirus software.
www.avast.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
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Can I have two GnuCash releases installed in Windows 11

2024-07-04 Thread Lipp F.
I am a bit behind and I would like to test a newer release before
upgrading. Can I do it on Windows 11?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] First request to kindly help - first response

2024-07-04 Thread Norbert Klein via gnucash-user

Thanks, David,

for your advice what to do. I will write between the lines of your text
saying what I did, and what were the results. I mark the lines from me
with N:, and from you with D:

N: As I have on C: only 19.3 GB free, but on D: 677 GB free, I want to
install GnuCash on D: (I did not check space before where I had tried an
insatllation on c: C – now I uninstalled GnuCash to make a new start).-
I run gnucash.5.7.setup.exe and when the program asked for the location
for the installation, I said D:\ProgramFiles(x86)\gnucash - and the
Installation continued until Finish. D: When you run GnuCash for the
first time there is no existing file. If you go to the menu File->Save.
As you will get a dialogue allowing you to select a location on your
hard disk in which to save the file and give it a name. N: From the
GnuCash icon on the desktop, I got

Unsaved Book – Gnucash - and, like before:

File    Edit   View   Actions  Business  Reports   Tools  Windows  Help
Save Close (with a grayed out Down
Arrow)   (with a crossed out x-sign) With File, I get now a list to
choose from: New File Open Import Save Save As... Revert Print Page
Setup Export Properties 1 pfarm.gnucash Close Quit D: It is generally
recommended that you create a directory in which to save the file for
each set of books you create. The dialogue will allow you to create a
new directory and name it as well as give a name to the GnuCash data
file. Once you have saved the file to the desired location you can then
start setting up the Chart of Accounts. N: I should create a Directory
“in which to save the file for each set of books I create”. But I give
up for now and ask for further advice: 1) how to create a Directory
here, and how to name it, and 2) how to create a File and how to name
it, and put it into this Directory At the installation, I made the
installation into “pfarm” – and this created obviously the entry “1
pfarm.gnucash” – but I rather stop here and ask for advice for the next
steps. I used “pfarm” as the program is to help to manage a “Pepper
Farm” – and I would like to use this term also for the Directories and
Files to create next – but please advise also on this.

Thank you very much – and please help me further.

Norbert = = = D: The window will have opened with an accounts tab open.
If you then click on the Actions->New Account Hierarchy you can select
from some of the presetup account hierarchies and add and remove
accounts as you need.

David Cousens

On Thu, 2024-07-04 at 14:30 +0700, Norbert Klein via gnucash-user wrote:

My name is Norbert Klein, German, since 1990 in Cambodia, 90 years old,
but still alive and interested. After this self-introduction, I would
like to ask for your help. I read since some days the GnuCash user
mailing list, and I see the many detailed questions raised and
responded. Several years ago, I had been using GnuCash, but because of
changed working responsibilities this had been given up – and I do not
have any copies. But the new task is similar: to set up a general
income-and-expenses system, with the two currencies US$ and
Cambodian/Khmer Riel – with the widely used fixed rate of US$1.00 to
Riel 4,000. Then I tried to clean my Windows 10 notebook from any
remaining old “*gnu*” file which might have remained from before. I
downloaded gnucash-5.7.setup.exe and started the installation, and the
installation happened in C:\System\ProgramFiles(x86)\gnucash I was happy
to see that also a GnuCash icon had been created on the desktop, and I
hoped I could now start to set up the GnuCash program

but here my frustration started.

I tried for several hours to solve it – in vain. I describe here what I
got, and I ask for your advice. After clicking on the GnuCash icon, I
get – only very short – a kind of general GnuCash display picture, and
then a GnuCash Tip-of-the-Day. These disappear quickly, and a full
screen field shows up: Unsaved Book - GnuCash File Edit View Actions
Business  Reports  Tools Windows  Help (9 items)
Save Close (with a
grayed out Down Arrow)   (with a crossed out x-sign) When I click I
see:When I click I see: Save the current file.       
    Close the current active page. But I cannot use these activations –
but I can close the whole screen. I had also tried the 9 items above –
but I did not find out where these contacts would lead me. So I am
totally frustrated, and I started to write to the help list. Please
help. Norbert -- This email has been checked for viruses by Avast
antivirus software. www.avast.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
- Please remember to CC this list on all your replies.

You can do this by using Reply-To-List or Reply-All.


--
This email has been checked for viruses by Avast an

Re: [GNC] Can I have two GnuCash releases installed in Windows 11

2024-07-04 Thread David Carlson
I run multiple versions of GnuCash by putting them on different computers.
This can be done either by using separate machines or by setting up one or
more virtual machines in a program similar to Oracle Virtualbox.



On Thu, Jul 4, 2024 at 9:33 AM Lipp F.  wrote:

> I am a bit behind and I would like to test a newer release before
> upgrading. Can I do it on Windows 11?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.


[GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Paul Kroitor
I'm sure this has been asked in a dozen different variations over the years
but I'm now faced with the issue myself since I now need to use CSV for
downloading (I hate TD Bank, who have removed the OFX download option). I
can't immediately find any old messages describing this particular issue, so
I thought I'd just ask.

 

Simplified, TD Bank CSV downloads only basically have four fields:

*   Date
*   Description
*   "Debit" or "Credit"
*   Amount (always positive)

 

Import works fine, except that I can't see any way (short of pre-editing the
file) to get the CSV importer to understand that the amount field goes in a
different column (D or C) depending on a different field's value. This must
be fairly common - am I just blind? 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Deva via gnucash-user
Paul,

I don’t use the importer, but from reading the list responses, I seem to recall 
that if you are using a single column for the amount, then deposits and 
withdrawals should be of opposite sign. So for a bank import, if you choose 
debits to be positive, then credits must be negative. 

You can also preprocess the csv file to separate the debits and credits into 2 
separate columns, wherein both amounts can remain positive. 

This is just from memory. I’m sure folks who use the importer will provide 
better responses. 

Cheers. 


--

From: "Paul Kroitor" 
To: 
Subject: [GNC] CSV Importer - Debit vs Credit
Message-ID: <02c201dace27$1a8f5b60$4fae1220$@kroitor.ca>
Content-Type: text/plain;   charset="us-ascii"

I'm sure this has been asked in a dozen different variations over the years
but I'm now faced with the issue myself since I now need to use CSV for
downloading (I hate TD Bank, who have removed the OFX download option). I
can't immediately find any old messages describing this particular issue, so
I thought I'd just ask.

 

Simplified, TD Bank CSV downloads only basically have four fields:

*   Date
*   Description
*   "Debit" or "Credit"
*   Amount (always positive)

 

Import works fine, except that I can't see any way (short of pre-editing the
file) to get the CSV importer to understand that the amount field goes in a
different column (D or C) depending on a different field's value. This must
be fairly common - am I just blind? 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Editing the Quicken/Quickbooks check layout

2024-07-04 Thread fromvendor
Hi Gerard, 

A quick google brought me this link:  
https://quickbooks.intuit.com/learn-support/en-us/other-questions/paycheck-alignment-for-qb-desktop/00/755600

I had done this years ago when I had my business up and running (since retired 
and abandoned QB) and it worked for me.

Hope this helps,
-greg



-Original Message-
From: gnucash-user 
[mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of 
Gerard Dupczak
Sent: Wednesday, July 03, 2024 8:52 AM
To: gnucash-user@gnucash.org
Subject: [GNC] Editing the Quicken/Quickbooks check layout

Is there a way to edit the Quicken/Quickbooks 3-part check layout? My 
checks mostly align but the written check amount and the items below 
that are off by about 1/2 a line.

I haven't been able to locate the file that has that layout.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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
To update your subscription preferences or to unsubscribe:
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: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Paul Kroitor
Thanks for your quick reply. I did understand those options, and I blame TD for 
their stupid CSV format, but I'd rather avoid writing a trivial preprocess 
applet. For the record, if I did so the first approach I would try is simply 
adding a negative sign to all the debit amounts.

It must be a fairly common request though -- maybe the importer could be 
enhanced to deal with this situation.


-Original Message-
From: gnucash-user  On Behalf 
Of Deva via gnucash-user
Sent: Thursday, July 4, 2024 12:15 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] CSV Importer - Debit vs Credit

Paul,

I don’t use the importer, but from reading the list responses, I seem to recall 
that if you are using a single column for the amount, then deposits and 
withdrawals should be of opposite sign. So for a bank import, if you choose 
debits to be positive, then credits must be negative. 

You can also preprocess the csv file to separate the debits and credits into 2 
separate columns, wherein both amounts can remain positive. 

This is just from memory. I’m sure folks who use the importer will provide 
better responses. 

Cheers. 


--

From: "Paul Kroitor" 
To: 
Subject: [GNC] CSV Importer - Debit vs Credit
Message-ID: <02c201dace27$1a8f5b60$4fae1220$@kroitor.ca>
Content-Type: text/plain;   charset="us-ascii"

I'm sure this has been asked in a dozen different variations over the years but 
I'm now faced with the issue myself since I now need to use CSV for downloading 
(I hate TD Bank, who have removed the OFX download option). I can't immediately 
find any old messages describing this particular issue, so I thought I'd just 
ask.

 

Simplified, TD Bank CSV downloads only basically have four fields:

*   Date
*   Description
*   "Debit" or "Credit"
*   Amount (always positive)

 

Import works fine, except that I can't see any way (short of pre-editing the
file) to get the CSV importer to understand that the amount field goes in a 
different column (D or C) depending on a different field's value. This must be 
fairly common - am I just blind? 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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
To update your subscription preferences or to unsubscribe:
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: [GNC] Can I have two GnuCash releases installed in Windows 11

2024-07-04 Thread Kalpesh Patel
I don't think two different version of GNUCash can exist on Windows machine 
(install of new version will uninstall the previously installed one). However, 
there is nothing that precludes you from going back one minor version if you 
needed to. In that case, you just simply uninstall the latest version and then 
install the previous version.

If you want to go with David C's route, you can employ VirtualBox to run 
another instance of the OS and test it out there before upgrading on the main 
system. 

-Original Message-
From: David Carlson  
Sent: Thursday, July 04, 2024 11:15 AM
To: Lipp F. 
Cc: GnuCash users group 
Subject: Re: [GNC] Can I have two GnuCash releases installed in Windows 11

I run multiple versions of GnuCash by putting them on different computers.
This can be done either by using separate machines or by setting up one or more 
virtual machines in a program similar to Oracle Virtualbox.



On Thu, Jul 4, 2024 at 9:33 AM Lipp F.  wrote:

> I am a bit behind and I would like to test a newer release before 
> upgrading. Can I do it on Windows 11?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


--
David Carlson


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Kalpesh Patel
Sadly, you will have to do some pre-processing before import. Put minus sign
in front of debits or credits, depending upon how the book is setup. GNUCash
does not have a conditional way of importing data in CSV by looking at a
column. CSV files can be edited in any text editor.

-Original Message-
From: Paul Kroitor  
Sent: Thursday, July 04, 2024 11:30 AM
To: gnucash-user@gnucash.org
Subject: [GNC] CSV Importer - Debit vs Credit

I'm sure this has been asked in a dozen different variations over the years
but I'm now faced with the issue myself since I now need to use CSV for
downloading (I hate TD Bank, who have removed the OFX download option). I
can't immediately find any old messages describing this particular issue, so
I thought I'd just ask.

 

Simplified, TD Bank CSV downloads only basically have four fields:

*   Date
*   Description
*   "Debit" or "Credit"
*   Amount (always positive)

 

Import works fine, except that I can't see any way (short of pre-editing the
file) to get the CSV importer to understand that the amount field goes in a
different column (D or C) depending on a different field's value. This must
be fairly common - am I just blind? 



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread wheelercsg-lists--- via gnucash-user

Hi, Paul,

I have a TD Bank account, so I looked at the available options. If you 
choose "Microsoft Money", that appears to result in an OFX download. I 
usually choose "Intuit Quicken", because that results in a QFX download, 
which GnuCash can import.


On 2024-07-04 12:00 p.m., gnucash-user-requ...@gnucash.org wrote:

Date: Thu, 4 Jul 2024 11:30:29 -0400
From: "Paul Kroitor"
To:
Subject: [GNC] CSV Importer - Debit vs Credit
Message-ID:<02c201dace27$1a8f5b60$4fae1220$@kroitor.ca>
Content-Type: text/plain;   charset="us-ascii"

I'm sure this has been asked in a dozen different variations over the years
but I'm now faced with the issue myself since I now need to use CSV for
downloading (I hate TD Bank, who have removed the OFX download option). I
can't immediately find any old messages describing this particular issue, so
I thought I'd just ask.

  


Simplified, TD Bank CSV downloads only basically have four fields:

*   Date
*   Description
*   "Debit" or "Credit"
*   Amount (always positive)

  


Import works fine, except that I can't see any way (short of pre-editing the
file) to get the CSV importer to understand that the amount field goes in a
different column (D or C) depending on a different field's value. This must
be fairly common - am I just blind?



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Paul Kroitor
I'm afraid "Microsoft Money" format -- which I've been a satisfied user of
for over a decade -- isn't an option anymore in their new website design.

They warned me last month I'd be changed to the new web layout. It's one
step forward, three back! Perhaps they're rolling it out slowly across their
user base: I'm in Montreal -- are you in Canada or the US? I probably have
the option somewhere to use the old site, but I thought I would get out
ahead of this.

-Original Message-
From: gnucash-user  On
Behalf Of wheelercsg-lists--- via gnucash-user
Sent: Thursday, July 4, 2024 1:00 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] CSV Importer - Debit vs Credit

Hi, Paul,

I have a TD Bank account, so I looked at the available options. If you
choose "Microsoft Money", that appears to result in an OFX download. I
usually choose "Intuit Quicken", because that results in a QFX download,
which GnuCash can import.

On 2024-07-04 12:00 p.m., gnucash-user-requ...@gnucash.org wrote:
> Date: Thu, 4 Jul 2024 11:30:29 -0400
> From: "Paul Kroitor"
> To:
> Subject: [GNC] CSV Importer - Debit vs Credit 
> Message-ID:<02c201dace27$1a8f5b60$4fae1220$@kroitor.ca>
> Content-Type: text/plain; charset="us-ascii"
>
> I'm sure this has been asked in a dozen different variations over the 
> years but I'm now faced with the issue myself since I now need to use 
> CSV for downloading (I hate TD Bank, who have removed the OFX download 
> option). I can't immediately find any old messages describing this 
> particular issue, so I thought I'd just ask.
>
>   
>
> Simplified, TD Bank CSV downloads only basically have four fields:
>
> * Date
> * Description
> * "Debit" or "Credit"
> * Amount (always positive)
>
>   
>
> Import works fine, except that I can't see any way (short of 
> pre-editing the
> file) to get the CSV importer to understand that the amount field goes 
> in a different column (D or C) depending on a different field's value. 
> This must be fairly common - am I just blind?
>

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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
To update your subscription preferences or to unsubscribe:
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: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Paul Kroitor
I can easily write a little Python thingie and put it in my right-click
menu, but it's just an added annoyance in this increasingly annoying world.

-Original Message-
From: Kalpesh Patel  
Sent: Thursday, July 4, 2024 12:59 PM
To: 'Paul Kroitor' ; gnucash-user@gnucash.org
Subject: RE: [GNC] CSV Importer - Debit vs Credit

Sadly, you will have to do some pre-processing before import. Put minus sign
in front of debits or credits, depending upon how the book is setup. GNUCash
does not have a conditional way of importing data in CSV by looking at a
column. CSV files can be edited in any text editor.

-Original Message-
From: Paul Kroitor 
Sent: Thursday, July 04, 2024 11:30 AM
To: gnucash-user@gnucash.org
Subject: [GNC] CSV Importer - Debit vs Credit

I'm sure this has been asked in a dozen different variations over the years
but I'm now faced with the issue myself since I now need to use CSV for
downloading (I hate TD Bank, who have removed the OFX download option). I
can't immediately find any old messages describing this particular issue, so
I thought I'd just ask.

 

Simplified, TD Bank CSV downloads only basically have four fields:

*   Date
*   Description
*   "Debit" or "Credit"
*   Amount (always positive)

 

Import works fine, except that I can't see any way (short of pre-editing the
file) to get the CSV importer to understand that the amount field goes in a
different column (D or C) depending on a different field's value. This must
be fairly common - am I just blind? 




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread CWheeler via gnucash-user
I'm in Ontario; maybe they haven't rolled that particular change out to 
me yet. I'm still seeing a mix of their old and new website formats, 
depending which page I view. Is the Quicken option also gone?


On 2024-07-04 01:13 p.m., Paul Kroitor wrote:

I'm afraid "Microsoft Money" format -- which I've been a satisfied user of
for over a decade -- isn't an option anymore in their new website design.

They warned me last month I'd be changed to the new web layout. It's one
step forward, three back! Perhaps they're rolling it out slowly across their
user base: I'm in Montreal -- are you in Canada or the US? I probably have
the option somewhere to use the old site, but I thought I would get out
ahead of this.

-Original Message-
From: gnucash-user  On
Behalf Of wheelercsg-lists--- via gnucash-user
Sent: Thursday, July 4, 2024 1:00 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] CSV Importer - Debit vs Credit

Hi, Paul,

I have a TD Bank account, so I looked at the available options. If you
choose "Microsoft Money", that appears to result in an OFX download. I
usually choose "Intuit Quicken", because that results in a QFX download,
which GnuCash can import.

On 2024-07-04 12:00 p.m., gnucash-user-requ...@gnucash.org wrote:

Date: Thu, 4 Jul 2024 11:30:29 -0400
From: "Paul Kroitor"
To:
Subject: [GNC] CSV Importer - Debit vs Credit
Message-ID:<02c201dace27$1a8f5b60$4fae1220$@kroitor.ca>
Content-Type: text/plain;   charset="us-ascii"

I'm sure this has been asked in a dozen different variations over the
years but I'm now faced with the issue myself since I now need to use
CSV for downloading (I hate TD Bank, who have removed the OFX download
option). I can't immediately find any old messages describing this
particular issue, so I thought I'd just ask.

   


Simplified, TD Bank CSV downloads only basically have four fields:

*   Date
*   Description
*   "Debit" or "Credit"
*   Amount (always positive)

   


Import works fine, except that I can't see any way (short of
pre-editing the
file) to get the CSV importer to understand that the amount field goes
in a different column (D or C) depending on a different field's value.
This must be fairly common - am I just blind?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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
To update your subscription preferences or to unsubscribe:
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: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Kalpesh Patel
As an after-thought, put minus sign in front of lines with credits and
payments to minimize number of edits, and then adjust your amount column as
withdrawal (or credit based upon your books settings). The minus sign will
move the amount over to "deposit" side. Once you are satisfied how it
imports, you can save that as a template to use it next time in the future
so you don't have to figure it out again.

-Original Message-
From: Kalpesh Patel  
Sent: Thursday, July 04, 2024 12:59 PM
To: 'Paul Kroitor' ; 'gnucash-user@gnucash.org'

Subject: RE: [GNC] CSV Importer - Debit vs Credit

Sadly, you will have to do some pre-processing before import. Put minus sign
in front of debits or credits, depending upon how the book is setup. GNUCash
does not have a conditional way of importing data in CSV by looking at a
column. CSV files can be edited in any text editor.

-Original Message-
From: Paul Kroitor  
Sent: Thursday, July 04, 2024 11:30 AM
To: gnucash-user@gnucash.org
Subject: [GNC] CSV Importer - Debit vs Credit

I'm sure this has been asked in a dozen different variations over the years
but I'm now faced with the issue myself since I now need to use CSV for
downloading (I hate TD Bank, who have removed the OFX download option). I
can't immediately find any old messages describing this particular issue, so
I thought I'd just ask.

 

Simplified, TD Bank CSV downloads only basically have four fields:

*   Date
*   Description
*   "Debit" or "Credit"
*   Amount (always positive)

 

Import works fine, except that I can't see any way (short of pre-editing the
file) to get the CSV importer to understand that the amount field goes in a
different column (D or C) depending on a different field's value. This must
be fairly common - am I just blind? 



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Can I have two GnuCash releases installed in Windows 11

2024-07-04 Thread Glenn Fowler
You can also do this by using a portable version:

https://portableapps.com/apps/office/gnucash_portable

From: gnucash-user  on 
behalf of David Carlson 
Sent: Thursday, July 4, 2024 11:14 AM
To: Lipp F. 
Cc: GnuCash users group 
Subject: Re: [GNC] Can I have two GnuCash releases installed in Windows 11

I run multiple versions of GnuCash by putting them on different computers.
This can be done either by using separate machines or by setting up one or
more virtual machines in a program similar to Oracle Virtualbox.



On Thu, Jul 4, 2024 at 9:33 AM Lipp F.  wrote:

> I am a bit behind and I would like to test a newer release before
> upgrading. Can I do it on Windows 11?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


--
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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
To update your subscription preferences or to unsubscribe:
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: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Paul Kroitor
Yes, sadly. Only CSV and XLS remain.

Sent from my iPad

> On Jul 4, 2024, at 1:19 PM, CWheeler  wrote:
> 
> I'm in Ontario; maybe they haven't rolled that particular change out to
> me yet. I'm still seeing a mix of their old and new website formats,
> depending which page I view. Is the Quicken option also gone?
> 
>> On 2024-07-04 01:13 p.m., Paul Kroitor wrote:
>> I'm afraid "Microsoft Money" format -- which I've been a satisfied user of
>> for over a decade -- isn't an option anymore in their new website design.
>> 
>> They warned me last month I'd be changed to the new web layout. It's one
>> step forward, three back! Perhaps they're rolling it out slowly across their
>> user base: I'm in Montreal -- are you in Canada or the US? I probably have
>> the option somewhere to use the old site, but I thought I would get out
>> ahead of this.
>> 
>> -Original Message-
>> From: gnucash-user  On
>> Behalf Of wheelercsg-lists--- via gnucash-user
>> Sent: Thursday, July 4, 2024 1:00 PM
>> To: gnucash-user@gnucash.org
>> Subject: Re: [GNC] CSV Importer - Debit vs Credit
>> 
>> Hi, Paul,
>> 
>> I have a TD Bank account, so I looked at the available options. If you
>> choose "Microsoft Money", that appears to result in an OFX download. I
>> usually choose "Intuit Quicken", because that results in a QFX download,
>> which GnuCash can import.
>> 
>>> On 2024-07-04 12:00 p.m., gnucash-user-requ...@gnucash.org wrote:
>>> Date: Thu, 4 Jul 2024 11:30:29 -0400
>>> From: "Paul Kroitor"
>>> To:
>>> Subject: [GNC] CSV Importer - Debit vs Credit
>>> Message-ID:<02c201dace27$1a8f5b60$4fae1220$@kroitor.ca>
>>> Content-Type: text/plain;charset="us-ascii"
>>> 
>>> I'm sure this has been asked in a dozen different variations over the
>>> years but I'm now faced with the issue myself since I now need to use
>>> CSV for downloading (I hate TD Bank, who have removed the OFX download
>>> option). I can't immediately find any old messages describing this
>>> particular issue, so I thought I'd just ask.
>>> 
>>> 
>>> 
>>> Simplified, TD Bank CSV downloads only basically have four fields:
>>> 
>>> *Date
>>> *Description
>>> *"Debit" or "Credit"
>>> *Amount (always positive)
>>> 
>>> 
>>> 
>>> Import works fine, except that I can't see any way (short of
>>> pre-editing the
>>> file) to get the CSV importer to understand that the amount field goes
>>> in a different column (D or C) depending on a different field's value.
>>> This must be fairly common - am I just blind?
>>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> 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
To update your subscription preferences or to unsubscribe:
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: [GNC] Can I have two GnuCash releases installed in Windows 11

2024-07-04 Thread Michael or Penny Novack
You also  didn't specify whether you meant two versions both usable OR 
simply leaving an old version available for a quick build back out.


The reason I hate answering questions like this is if you don't already 
know how you shouldn't try it. So I'll only give hints. The installer of 
the new version will only uninstall the old version if it finds a 
gnucash directory in the program directory. In other words, the 
installer will work if you never had gnucash installed before, just 
creates that directory. It finds the old directory because it knows its 
name. Ask yourself what it would do if it didn't find a directory WITH 
THAT NAME in the program directory and how you could make that happen.


When I am making major changes to software I am usually set to quickly 
back out the change with just a couple renames << and remember to clean 
up afterwards >> This of course not simply a Windows thing.


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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] {Spam} Editing the Quicken/Quickbooks check layout

2024-07-04 Thread Sherman Yoder
   Hello Gerard,

   Yes, you can edit the check layout. The location of the file to edit
   depends on the operating system you have. On my Windows installation it
   is at C:\Program Files (x86)\gnucash\share\gnucash\checks.

   You can find instructions how to edit the coordinates of the objects at
   [1]https://www.gnucash.org/docs.phtml. Click on The Tutorial and
   Concepts Guide, then Auxiliary File Formats in Appendix B. That
   describes the check format file setup, and how to modify them or create
   a new one.

   I recommend that you copy the Quicken/Quickbooks 3-part check file and
   save it with another name, so the original remains unchanged. Note that
   you will need to change the Guid in the file. I have not found it
   critical what that is--I have just changed a character or two of what
   is in the original.

   The check print fields can be shifted by changing the coordinates. The
   coordinate numbers represent points, 72 to an inch. It can be helpful
   to set Show_Grid to true to help in the field placement.

   I wish you success.

   Sherman

   On 7/3/2024 9:52 AM, Gerard Dupczak wrote:

 Is there a way to edit the Quicken/Quickbooks 3-part check layout?
 My checks mostly align but the written check amount and the items
 below that are off by about 1/2 a line.
 I haven't been able to locate the file that has that layout.
 ___
 gnucash-user mailing list
 [2]gnucash-user@gnucash.org
 To update your subscription preferences or to unsubscribe:
 [3]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.

References

   1. https://www.gnucash.org/docs.phtml
   2. mailto:gnucash-user@gnucash.org
   3. https://lists.gnucash.org/mailman/listinfo/gnucash-user
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Paul Kroitor
Yes, I see.

Interestingly, I realize I can use a simple search and replace for this.
Here are a couple of lines from the CSV file:

"","2024-06-26","Credit Memo","Credit","4.00",".xx"
"","2024-06-26","Service Charge","Debit","7.95",".xx"

(final field -- the new balance -- obscured for privacy)


All I need to do is replace 'Debit","' with 'Debit","-' everywhere and all
the debit amounts will have '-' prepended.

NB: since " is used in the actual data, I'm using ' above as a delimiter and
" as a character in the string.

-Original Message-
From: Kalpesh Patel  
Sent: Thursday, July 4, 2024 1:20 PM
To: 'Paul Kroitor' ; gnucash-user@gnucash.org
Subject: RE: [GNC] CSV Importer - Debit vs Credit

As an after-thought, put minus sign in front of lines with credits and
payments to minimize number of edits, and then adjust your amount column as
withdrawal (or credit based upon your books settings). The minus sign will
move the amount over to "deposit" side. Once you are satisfied how it
imports, you can save that as a template to use it next time in the future
so you don't have to figure it out again.

-Original Message-
From: Kalpesh Patel 
Sent: Thursday, July 04, 2024 12:59 PM
To: 'Paul Kroitor' ; 'gnucash-user@gnucash.org'

Subject: RE: [GNC] CSV Importer - Debit vs Credit

Sadly, you will have to do some pre-processing before import. Put minus sign
in front of debits or credits, depending upon how the book is setup. GNUCash
does not have a conditional way of importing data in CSV by looking at a
column. CSV files can be edited in any text editor.

-Original Message-
From: Paul Kroitor 
Sent: Thursday, July 04, 2024 11:30 AM
To: gnucash-user@gnucash.org
Subject: [GNC] CSV Importer - Debit vs Credit

I'm sure this has been asked in a dozen different variations over the years
but I'm now faced with the issue myself since I now need to use CSV for
downloading (I hate TD Bank, who have removed the OFX download option). I
can't immediately find any old messages describing this particular issue, so
I thought I'd just ask.

 

Simplified, TD Bank CSV downloads only basically have four fields:

*   Date
*   Description
*   "Debit" or "Credit"
*   Amount (always positive)

 

Import works fine, except that I can't see any way (short of pre-editing the
file) to get the CSV importer to understand that the amount field goes in a
different column (D or C) depending on a different field's value. This must
be fairly common - am I just blind? 




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.


[GNC] Startup Options OSX?

2024-07-04 Thread Jim Johnson
Hi!

I just started using GnuCash, and thanks to the new 5.71 version I was able to 
import 15 years of Quicken registers successfully, so I am good to go.

Before I did that import, about three weeks ago I started a new GnuCash 
register of just last year for my accountant’s use.

Now, going through all of my GnuCash documents I can’t find that one register 
anymore, just the import.

I have been using Time Machine to back up my MacBook

Is there a safe way to start GnuCash (like option-open or something?) and see 
if one of my old OSX Time Machine GnuCash backed-up documents has it?

I don’t want to lose my new massive import, but I’d like to find that older 
register.

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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Startup Options OSX?

2024-07-04 Thread Jim DeLaHunt

Jim:

On 2024-07-04 13:36, Jim Johnson wrote:

Hi!

I just started using GnuCash, and thanks to the new 5.71 version I was able to 
import 15 years of Quicken registers successfully, so I am good to go.

Welcome to GnuCash! I'm glad to hear that worked for you.

Before I did that import, about three weeks ago I started a new GnuCash 
register of just last year for my accountant’s use.

Now, going through all of my GnuCash documents I can’t find that one register 
anymore, just the import.

I have been using Time Machine to back up my MacBook

Is there a safe way to start GnuCash (like option-open or something?) and see 
if one of my old OSX Time Machine GnuCash backed-up documents has it?


The GnuCash app for macOS has a File menu, with an Open… entry. This 
works exactly as does with most applications — it lets GnuCash open 
another book (document).


You can explore other documents by:

1. Using Finder, find the location in your mac's storage where the
   current file is stored. It will have a filename ending in '.gnucash'.
2. Note its size in bytes and its modification date and time. Make a
   copy of that file, and move the copy to a safe and known location.
3. Using Finder, find the location where the older files are stored.
1. Some backup files will be stored in the same directory as your
   current file. They will have file names ending in numeric
   date-time codes sandwiched between '.gnucash', e.g.
   …'.gnucash.20240703205228.gnucash'
2. Your GnuCash register from three weeks ago, for your
   accountant's use, might have a different file name which ends
   in '.gnucash', and might be in a different location.
4. Run the GnuCash app. Your currrent GnuCash book with the massive
   import opens.
5. Use the File… Open… menu entry. A standard File Open dialogue appears.
6. Navigate to the older files you found in steps 3.1 and 3.2. Open one
   of them. The old book version opens.
7. See if this is the content you want. If it is, take whatever steps
   you want to take. You did not specify that part. Maybe you want to
   export the old transactions, so that you can import them into your
   current book.
8. If you have not found the content you want, repeat steps 5. through
   8. until you find it.
9. Quit the GnuCash app.
10. Using Finder, return to the location in your mac's storage where the
   current file is stored.
11. If you are certain that the current file is unchanged what it was in
   step 2, then you can safely delete the copy you made. If it has been
   change, or if you are not certain, restore your original file as
   follows:
1. Rename your current file to change the ending '.gnucash' to
   something like '.before_restore.gnucash'.
2. Move the copy you made of your current file into the current
   directory, and be sure it has the same name as your current file
   had in step 2.
12. Run the GnuCash app. Whichever past GnuCash book you last examined
   opens.
13. Use the File… Open… menu entry. A standard File Open dialogue appears.
14. Navigate to your current file. Open it. Your current book opens.
15. You have now finished getting back to your current book (document)
   after exploring older documents.


I don’t want to lose my new massive import, but I’d like to find that older 
register.


GnuCash does not treat its book files exactly like a spreadsheet or word 
processing application treats their documents, but some of the same 
principles apply.  GnuCash can open and work with different documents in 
sequence (though not multiple at the same time). It benefits you to know 
where your data is stored. It benefits you to keep track of old 
documents which you might want to revisit sometime.


Does this help?

  —Jim DeLaHunt

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] First request to kindly help - first response

2024-07-04 Thread David Cousens
Norbert 

When you click on File->Save As you should get a dialogue box opening.
On the right hand side of the dialogue is a small icon which looks like
a hanger that you use in a filing cabinet with a plus sign. 

The directory/folder you are currently in is displayed at the top of
the main panel of the dialogue and the Left Hand Panel  should have
your disks and locations listed. 

Select the disk in that panel and then navigate to the location where
you want to create the new folder to containyour GnuCash data file.

Then click on the icon at the right hand side (filehanger) and you will
get a popup box in which you can enter the name of the folder/directory
you wish to create. Enter the name and click on the "Create " button.
This will then create the folder and change to it.

At the top you will see a box labelled "Name".  Enter the name you wish
to give the file in this box and click on the "Save As" button at the
bottom right hand side of the dialogue box and the file will be
created.

I am a Linux user so I am presuming that the Windows popup will look
the same as on Linux but it might be slightly different . I think
GnuCash uses the system file open/save  dialogues AFAIK.

David




On Thu, 2024-07-04 at 22:07 +0700, Norbert Klein wrote:
> Thanks, David, 
> for your advice what to do. I will write between the lines of your
> text saying what I did, and what were the results. I mark the lines
> from me with N:, and from you with D:
> 
> N: As I have on C: only 19.3 GB free, but on D: 677 GB free, I want
> to install GnuCash on D: (I did not check space before where I had
> tried an insatllation on c: C – now I uninstalled GnuCash to make a
> new start).- I run gnucash.5.7.setup.exe and when the program asked
> for the location for the installation, I said
> D:\ProgramFiles(x86)\gnucash - and the Installation continued until
> Finish.
> 
> D: When you run GnuCash for the first time there is no existing file.
> If you go to the menu File->Save. As you will get a dialogue allowing
> you to select a location on your hard disk in which to save the file
> and give it a name.
> 
> N: From the GnuCash icon on the desktop, I got
> 
> Unsaved Book – Gnucash - and, like before:
> 
> File
>    Edit   View   Actions  Business  Reports   Tools  Windows  Help
> 
> Save Close
> (with a grayed out Down Arrow)   (with a crossed out x-sign)
> 
> With File, I get now a list to choose from:
> 
> New File
> Open
> Import
> Save
> Save As...
> Revert
> Print
> Page Setup
> Export
> Properties
> 1 pfarm.gnucash
> Close
> Quit
> 
> 
> D: It is generally recommended that you create a directory in which
> to save the file for each set of books you create. The dialogue will
> allow you to create a new directory and name it as well as give a
> name to the GnuCash data file. Once you have saved the file to the
> desired location you can then start setting up the Chart of Accounts.
> 
> N: I should create a Directory “in which to save the file for each
> set of books I create”. But I give up for now and ask for further
> advice:
> 
> 1) how to create a Directory here, and how to name it, and
> 2) how to create a File and how to name it, and put it into this
> Directory
> 
> At the installation, I made the installation into “pfarm” – and this
> created obviously the entry “1 pfarm.gnucash” – but I rather stop
> here and ask for advice for the next steps.
> 
> I used “pfarm” as the program is to help to manage a “Pepper Farm” –
> and I would like to use this term also for the Directories and Files
> to create next – but please advise also on this.
> Thank you very much – and please help me further.
> 
> Norbert
> 
> = = =
> 
> D: The window will have opened with an accounts tab open. If you then
> click on the Actions->New Account Hierarchy you can select from
> some of the presetup account hierarchies and add and remove accounts
> as you need.
> David Cousens
> 
> 
> On Thu, 2024-07-04 at 14:30 +0700, Norbert Klein via gnucash-user
> wrote:
> My name is Norbert Klein, German, since 1990 in Cambodia, 90 years
> old, but still alive and interested.
> 
> After this self-introduction, I would like to ask for your help. I
> read
> since some days the GnuCash user mailing list, and I see the many
> detailed questions raised and responded. Several years ago, I had
> been
> using GnuCash, but because of changed working responsibilities this
> had been given up – and I do not have any copies. But the new task is
> similar: to set up a general income-and-expenses system, with the two
> currencies US$ and Cambodian/Khmer Riel – with the widely used fixed
> rate of US$1.00 to Riel 4,000.
> 
> Then I tried to clean my Windows 10 notebook from any remaining old
> “*gnu*” file which might have remained from before.
> 
> I downloaded gnucash-5.7.setup.exe and started the installation, and
> the installation happened in
> 
> C:\System\ProgramFiles(x86)\gnucash
> 
> I was happy to see that also a GnuCash icon had be

Re: [GNC] First request to kindly help

2024-07-04 Thread Norbert Klein via gnucash-user

Thanks, David, for th advice. I will follow it efore any new installation.

On 4 Jul 2024 21:16, david amaral wrote:

To set up a "NEW" gnucash file, make sure that your windows documents
directory has no gnucash directory in it
either delete all the files in it or rename the gnucash directory
"OLD_gnucash" to save any older files you may have.

On Thursday, July 4, 2024 at 12:32:26 AM MST, Norbert Klein via
gnucash-user  wrote:


My name is Norbert Klein, German, since 1990 in Cambodia, 90 years old,
but still alive and interested.,,,

...


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


--
This email has been checked for viruses by Avast antivirus software.
www.avast.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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] CSV Importer - Debit vs Credit

2024-07-04 Thread Patrick James
Paul,

It has been my personal experience that importing double quotes can be 
problematic for GNUCash, so I always remove all the double quotes during my 
pre-processing of the data.

The bug report is here:

https://bugs.gnucash.org/show_bug.cgi?id=798479



> On 07/04/2024 12:40 PM PDT Paul Kroitor  wrote:
> 
> 
> NB: since " is used in the actual data, I'm using ' above as a delimiter and
> " as a character in the string.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.