Re: [GNC] Reconciliation discrepancies

[David Carlson]

A possibility that has not been mentioned yet is if there are transactions
in more than one currency or involving securities.  If so, there are many
possible additional sources of discrepancy.  Also, if the discrepancies
suddenly appeared, say, after updating GnuCash to release 4.10, for
example, that release is very new and may have 'bugs', known or unknown.

David Carlson

On Mon, Apr 11, 2022 at 11:30 PM  wrote:

> Rich
>
> Have been using GnuCash for a similar period of time and have not noticed
> any
> reconciliation problems (other than those reported as bugs on the list -
> any
> that are are generally fixed pretty quickly) up to v4.9, particulaarly in
> recent
> versions.  Haven't yet done a reconciliation with 4.10.
>
> Anytime I have had a problem it has usually been a transposition, date
> errors
> and or missing transaction from the reconciliation period and different
> ordering
> in GnuCash and in the banks record leading to me missing a transaction.
> Scheduled transactions if you have them might have different values from
> the
> bank's as might interest calculations if you calculate them yourself. I
> have had
> problems where the bank has a completely different order from my own
> entries and
> even the imported OFX entries because of clearance requirements for entry
> into
> the statement at the bank end.
>
> Have you tried checking the bank's balance by importing their opening and
> closing balances and transactions into a spread sheet and summing them?
> Unfortunately most pdfs will not import tables cleanly into most
> spreadsheets
> but I have resorted to entering the numbers by hand (individually cut and
> paste)
> to check. Only once have I discovered a bank error and they were most
> apologetic.
>
> David Cousens
>
> On Mon, 2022-04-11 at 16:09 -0700, Rich Shepard wrote:
> > On Mon, 11 Apr 2022, Gyle McCollam wrote:
> >
> > > These may not apply, but check that your reconciliation date is the
> same
> > > as the bank's. Also, check the dates of the transactions as GC shows
> > > transaction past the reconciliation date, that you don't want to
> > > reconcile. The ending balance that GC shows for the reconciliation can
> be
> > > changed, so put in the bank's balance and see if you get a zero
> > > difference.
> >
> > Gyle,
> >
> > I check both the reconciliation date and that date's balance. There are
> > discrepancies between the purchase date entered in GnuCash and when the
> > transaction cleared the bank but those are immaterial.
> >
> > As an aside, I've used GnuCash for more than two decades, starting in
> 1997.
> > These large, sporatic discrepancies appeared only a few years ago, long
> > after I moved my business and personal accounts to my current bank. I did
> > catch the bank several years ago for charging me twice for the same
> Amazon
> > purchase and my banker had that quickly fixed. That was the only obvious
> > error I've seen.
> >
> > Thanks,
> >
> > Rich
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> ___
> 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.
>


-- 
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
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] Reconciliation discrepancies

[davidcousens49]

Rich

Have been using GnuCash for a similar period of time and have not noticed any
reconciliation problems (other than those reported as bugs on the list - any
that are are generally fixed pretty quickly) up to v4.9, particulaarly in recent
versions.  Haven't yet done a reconciliation with 4.10.  

Anytime I have had a problem it has usually been a transposition, date errors
and or missing transaction from the reconciliation period and different ordering
in GnuCash and in the banks record leading to me missing a transaction.
Scheduled transactions if you have them might have different values from the
bank's as might interest calculations if you calculate them yourself. I have had
problems where the bank has a completely different order from my own entries and
even the imported OFX entries because of clearance requirements for entry into
the statement at the bank end.

Have you tried checking the bank's balance by importing their opening and
closing balances and transactions into a spread sheet and summing them?
Unfortunately most pdfs will not import tables cleanly into most spreadsheets
but I have resorted to entering the numbers by hand (individually cut and paste)
to check. Only once have I discovered a bank error and they were most
apologetic.

David Cousens

On Mon, 2022-04-11 at 16:09 -0700, Rich Shepard wrote:
> On Mon, 11 Apr 2022, Gyle McCollam wrote:
> 
> > These may not apply, but check that your reconciliation date is the same
> > as the bank's. Also, check the dates of the transactions as GC shows
> > transaction past the reconciliation date, that you don't want to
> > reconcile. The ending balance that GC shows for the reconciliation can be
> > changed, so put in the bank's balance and see if you get a zero
> > difference.
> 
> Gyle,
> 
> I check both the reconciliation date and that date's balance. There are
> discrepancies between the purchase date entered in GnuCash and when the
> transaction cleared the bank but those are immaterial.
> 
> As an aside, I've used GnuCash for more than two decades, starting in 1997.
> These large, sporatic discrepancies appeared only a few years ago, long
> after I moved my business and personal accounts to my current bank. I did
> catch the bank several years ago for charging me twice for the same Amazon
> purchase and my banker had that quickly fixed. That was the only obvious
> error I've seen.
> 
> Thanks,
> 
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
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] Transaction Imports

[David T. via gnucash-user]

Further to this: you care about how much money something cost (the amount you 
have spent), and how much you got for it (the amount of shares you purchased). 
The first affects how much money you have in your bank account, the second 
affects how many shares show in your mutual fund.

On April 11, 2022 8:16:06 PM EDT, Stu Perlman  wrote:
>Thank for the heads up.
>
>On Mon, Apr 11, 2022 at 3:03 PM D  wrote:
>
>> Not going to go into great detail here, but you definitely DON'T want to
>> have gnucash calculate shares. Have it calculate price.
>> On Apr 11, 2022, at 11:21, Stu Perlman  wrote:
>>>
>>> Hello Everyone,
>>>
>>> I am looking for some guidance on how to import a few hundred transactions
>>> from my 401(k) account.
>>> Unfortunately, the plan administrator does not offer a good option for
>>> exporting the transaction data but I am able to get what I need with some
>>> basic web scraping.
>>>
>>> I have been experimenting with creating a multi-split CSV import from the
>>> data that I have captured.
>>> What I wanted to do was a file layout such as:
>>>
>>> *Date,Description,Account,Deposit,SharesAsMemo,Price*
>>> 01/04/2021,Contribution,Cash,-299.26
>>> ,,Vanguard Institutional Index Institutional Fund,299.26,0.916289038,326.6
>>> 01/19/2021,Contribution,Cash,-299.26
>>> ,,Vanguard Institutional Index Institutional Fund,299.26,0.892008703,335.49
>>>
>>>
>>> My wishful thinking was that I could put the number of shares into the memo
>>> column for reference (but that the system would auto-calculate that number
>>> using the provided Price and transaction amount ("Deposit")).
>>> I hit a blocker on the second to last step of the import wizard with the
>>> message: "*The account 'Vanguard Institutional Index Fund' has a different
>>> commodity to the one required, 'US Dollar'. Please choose a different
>>> account.*"
>>>
>>> So I'm wondering if there are other ways I can go about what I'm trying to
>>> accomplish?  I started with the CSV importer because I figured it would be
>>> the easiest record layout to create but I'm not against using a different
>>> format if what I want to accomplish can be done.
>>>
>>> I have a backup plan which is that I will NOT do the multi-split import and
>>> will just select the Cash account for all rows in the Import Preview
>>> screen. I could pack the memo field with the ticker symbol, price,
>>> quantity, and total debit and let it all dump into the Imbalance-USD
>>> account. I would then have to either manually fix them one by one or
>>> possibly script it out.  I have done this with success in the past but
>>> would rather just get it right at the data import step if that's in any
>>> way possible.
>>>
>>> My thanks in advance for any advice offered.
>>>
>>> - Stu
>>> --
>>>
>>> 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] Transaction Imports

[Stu Perlman]

Thank for the heads up.

On Mon, Apr 11, 2022 at 3:03 PM D  wrote:

> Not going to go into great detail here, but you definitely DON'T want to
> have gnucash calculate shares. Have it calculate price.
> On Apr 11, 2022, at 11:21, Stu Perlman  wrote:
>>
>> Hello Everyone,
>>
>> I am looking for some guidance on how to import a few hundred transactions
>> from my 401(k) account.
>> Unfortunately, the plan administrator does not offer a good option for
>> exporting the transaction data but I am able to get what I need with some
>> basic web scraping.
>>
>> I have been experimenting with creating a multi-split CSV import from the
>> data that I have captured.
>> What I wanted to do was a file layout such as:
>>
>> *Date,Description,Account,Deposit,SharesAsMemo,Price*
>> 01/04/2021,Contribution,Cash,-299.26
>> ,,Vanguard Institutional Index Institutional Fund,299.26,0.916289038,326.6
>> 01/19/2021,Contribution,Cash,-299.26
>> ,,Vanguard Institutional Index Institutional Fund,299.26,0.892008703,335.49
>>
>>
>> My wishful thinking was that I could put the number of shares into the memo
>> column for reference (but that the system would auto-calculate that number
>> using the provided Price and transaction amount ("Deposit")).
>> I hit a blocker on the second to last step of the import wizard with the
>> message: "*The account 'Vanguard Institutional Index Fund' has a different
>> commodity to the one required, 'US Dollar'. Please choose a different
>> account.*"
>>
>> So I'm wondering if there are other ways I can go about what I'm trying to
>> accomplish?  I started with the CSV importer because I figured it would be
>> the easiest record layout to create but I'm not against using a different
>> format if what I want to accomplish can be done.
>>
>> I have a backup plan which is that I will NOT do the multi-split import and
>> will just select the Cash account for all rows in the Import Preview
>> screen. I could pack the memo field with the ticker symbol, price,
>> quantity, and total debit and let it all dump into the Imbalance-USD
>> account. I would then have to either manually fix them one by one or
>> possibly script it out.  I have done this with success in the past but
>> would rather just get it right at the data import step if that's in any
>> way possible.
>>
>> My thanks in advance for any advice offered.
>>
>> - Stu
>> --
>>
>> 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] Reconciliation discrepancies

[Rich Shepard]

On Mon, 11 Apr 2022, Gyle McCollam wrote:


These may not apply, but check that your reconciliation date is the same
as the bank's. Also, check the dates of the transactions as GC shows
transaction past the reconciliation date, that you don't want to
reconcile. The ending balance that GC shows for the reconciliation can be
changed, so put in the bank's balance and see if you get a zero
difference.


Gyle,

I check both the reconciliation date and that date's balance. There are
discrepancies between the purchase date entered in GnuCash and when the
transaction cleared the bank but those are immaterial.

As an aside, I've used GnuCash for more than two decades, starting in 1997.
These large, sporatic discrepancies appeared only a few years ago, long
after I moved my business and personal accounts to my current bank. I did
catch the bank several years ago for charging me twice for the same Amazon
purchase and my banker had that quickly fixed. That was the only obvious
error I've seen.

Thanks,

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

Re: [GNC] Reconciliation discrepancies

[Rich Shepard]

On Mon, 11 Apr 2022, Dan Black wrote:


It is possible that you transposed two digits that you may not notice.


Dan,

I compare each transaction and haven't yet seen one with transposed digits.

Thanks for the suggestion,

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

Re: [GNC] Reconciliation discrepancies

[Gyle McCollam]

These may not apply, but check that your reconciliation date is the same as the 
bank's.  Also, check the dates of the transactions as GC shows transaction past 
the reconciliation date, that you don't want to reconcile.  The ending balance 
that GC shows for the reconciliation can be changed, so put in the bank's 
balance and see if you get a zero difference.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Rich Shepard 
Sent: Monday, April 11, 2022 6:32 PM
To: gnucash-user@gnucash.org 
Subject: Re: [GNC] Reconciliation discrepancies

On Mon, 11 Apr 2022, Ed Reeder wrote:

> When that happens to me I will discover that I entered a transaction
> incorrectly. I would check each GC transaction against the banks.

Ed,

That's what I do. As I wrote, they all match.

Thanks,

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

[Dan Black]

It is possible that you transposed two digits that you may not notice.

Try downloading an ofx or csv file and try importing it. Let the computer 
do the comparing for you.




On April 11, 2022 6:33:15 PM Rich Shepard  wrote:


On Mon, 11 Apr 2022, Ed Reeder wrote:


When that happens to me I will discover that I entered a transaction
incorrectly. I would check each GC transaction against the banks.


Ed,

That's what I do. As I wrote, they all match.

Thanks,

Rich
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

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


___
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] Reconciliation discrepancies

[Rich Shepard]

On Mon, 11 Apr 2022, Ed Reeder wrote:


When that happens to me I will discover that I entered a transaction
incorrectly. I would check each GC transaction against the banks.


Ed,

That's what I do. As I wrote, they all match.

Thanks,

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

Re: [GNC] Reconciliation discrepancies

[Ed Reeder]

When that happens to me I will discover that I entered a transaction 
incorrectly. I would check each GC transaction against the banks. 

On Mon, Apr 11, 2022, at 2:36 PM, Rich Shepard wrote:
> Every now and then one of my bank accounts doesn't reconcile because what
> the bank shows differs from what GnuCash shows. The amounts are significant.
> What puzzles me is that the previous month's balances (bank and GC) match
> and so do all the transactions. But, the end of month balances don't match.
>
> Many decades ago a penny or two difference when reconciling a bank account
> was common; I assume due to rounding errors. But why it is now more common
> (but sporatic) puzzles both me and my banker. We've gone over the
> transactions shown by the bank and by GC and neither of us can explain the
> discrepancies.
>
> Has anyone an idea of why this happens?
>
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Reconciliation discrepancies

[Rich Shepard]

Every now and then one of my bank accounts doesn't reconcile because what
the bank shows differs from what GnuCash shows. The amounts are significant.
What puzzles me is that the previous month's balances (bank and GC) match
and so do all the transactions. But, the end of month balances don't match.

Many decades ago a penny or two difference when reconciling a bank account
was common; I assume due to rounding errors. But why it is now more common
(but sporatic) puzzles both me and my banker. We've gone over the
transactions shown by the bank and by GC and neither of us can explain the
discrepancies.

Has anyone an idea of why this happens?

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

Re: [GNC] Transaction Imports

[D via gnucash-user]

Not going to go into great detail here, but you definitely DON'T want to have 
gnucash calculate shares. Have it calculate price. 

On Apr 11, 2022, 11:21, at 11:21, Stu Perlman  wrote:
>Hello Everyone,
>
>I am looking for some guidance on how to import a few hundred
>transactions
>from my 401(k) account.
>Unfortunately, the plan administrator does not offer a good option for
>exporting the transaction data but I am able to get what I need with
>some
>basic web scraping.
>
>I have been experimenting with creating a multi-split CSV import from
>the
>data that I have captured.
>What I wanted to do was a file layout such as:
>
>*Date,Description,Account,Deposit,SharesAsMemo,Price*
>01/04/2021,Contribution,Cash,-299.26
>,,Vanguard Institutional Index Institutional
>Fund,299.26,0.916289038,326.6
>01/19/2021,Contribution,Cash,-299.26
>,,Vanguard Institutional Index Institutional
>Fund,299.26,0.892008703,335.49
>
>
>My wishful thinking was that I could put the number of shares into the
>memo
>column for reference (but that the system would auto-calculate that
>number
>using the provided Price and transaction amount ("Deposit")).
>I hit a blocker on the second to last step of the import wizard with
>the
>message: "*The account 'Vanguard Institutional Index Fund' has a
>different
>commodity to the one required, 'US Dollar'. Please choose a different
>account.*"
>
>So I'm wondering if there are other ways I can go about what I'm trying
>to
>accomplish?  I started with the CSV importer because I figured it would
>be
>the easiest record layout to create but I'm not against using a
>different
>format if what I want to accomplish can be done.
>
>I have a backup plan which is that I will NOT do the multi-split import
>and
>will just select the Cash account for all rows in the Import Preview
>screen. I could pack the memo field with the ticker symbol, price,
>quantity, and total debit and let it all dump into the Imbalance-USD
>account. I would then have to either manually fix them one by one or
>possibly script it out.  I have done this with success in the past but
>would rather just get it right at the data import step if that's in any
>way possible.
>
>My thanks in advance for any advice offered.
>
>- Stu
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Transaction Imports

[Stu Perlman]

Hello Everyone,

I am looking for some guidance on how to import a few hundred transactions
from my 401(k) account.
Unfortunately, the plan administrator does not offer a good option for
exporting the transaction data but I am able to get what I need with some
basic web scraping.

I have been experimenting with creating a multi-split CSV import from the
data that I have captured.
What I wanted to do was a file layout such as:

*Date,Description,Account,Deposit,SharesAsMemo,Price*
01/04/2021,Contribution,Cash,-299.26
,,Vanguard Institutional Index Institutional Fund,299.26,0.916289038,326.6
01/19/2021,Contribution,Cash,-299.26
,,Vanguard Institutional Index Institutional Fund,299.26,0.892008703,335.49


My wishful thinking was that I could put the number of shares into the memo
column for reference (but that the system would auto-calculate that number
using the provided Price and transaction amount ("Deposit")).
I hit a blocker on the second to last step of the import wizard with the
message: "*The account 'Vanguard Institutional Index Fund' has a different
commodity to the one required, 'US Dollar'. Please choose a different
account.*"

So I'm wondering if there are other ways I can go about what I'm trying to
accomplish?  I started with the CSV importer because I figured it would be
the easiest record layout to create but I'm not against using a different
format if what I want to accomplish can be done.

I have a backup plan which is that I will NOT do the multi-split import and
will just select the Cash account for all rows in the Import Preview
screen. I could pack the memo field with the ticker symbol, price,
quantity, and total debit and let it all dump into the Imbalance-USD
account. I would then have to either manually fix them one by one or
possibly script it out.  I have done this with success in the past but
would rather just get it right at the data import step if that's in any
way possible.

My thanks in advance for any advice offered.

- Stu
___
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] Problem reinstalling

[Alan A Holmes]

Hi Shevach,

What OS and version of OS are you using (I suspect Windows as your using Mail 
for Windows) and what version of GnuCash were you using?

Did you have the GnuCash software installed on the memory card, or the data 
file, or both? The answer and advice may/will be different.


Alan A Holmes

-Original Message-
From: gnucash-user  
On Behalf Of Sh. Pepper
Sent: 10 April 2022 11:23
To: gnucash-user@gnucash.org
Subject: [GNC] Problem reinstalling

   Hello there,

   I have a problem that I had the gnucash installed on a memory card and
   the memory card was lost.

   I tried to reinstall it but I got the following message

   [cid:image001.png@01D84CDE.15C67D10]

   So now I’m stuck I don’t have the old copy and I can’t even start anew.

   Can someone please help me

   Thank you very very much

   Shevach


   Sent from [1]Mail for Windows

References

   1. https://go.microsoft.com/fwlink/?LinkId=550986

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