[GNC] CSV Import Problem

[cavery at bigpond.net.au]

Hello David,

 

Thank you for responding and I appreciate your assistance.

 

I took your advice and reduce the CSV file down from 304 transactions and a large number of accounts to just one account and 21 transaction.  I have attached this CSV file to this email.  Below you will see the import mapping in GNUcash.

 

The account number 2000 is a current asset bank account in GNUcash and after the CSV import the balance should be zero dollars.  I have attached a print of account 2000 transaction file and you will see the transaction total is $176,836.38 and the account total is $177,661.76 and should be zero. 

 

 

Screen shots of the mapping for the CSV file import:

 



 



 



 

Kind regards

Charles Avery

 

Mob: 0404 242 278

 

From: David Carlson <david.carlson.417 at gmail.com> 
Sent: Wednesday, 14 September 2022 10:56 PM
To: cavery at bigpond.net.au
Cc: mailman-request at gnucash.org; gnucash-user at gnucash.org
Subject: Re: [GNC] CSV Import Problem

 

There is a huge amount of flexibility in the CSV importer, and it has been working well for a long time.

 

It is far more likely that there is an error in your configuration or the source file.  Did you start with a small test file with just enough transactions to verify that your configuration is doing what you expect?  I am not familiar with Moneyspire so I don't know if you have many accounts, perhaps a mix of assets and liabilities that could provide further complication.

 

We would need more specific details to help you further.

 

On Wed, Sep 14, 2022 at 6:05 AM <cavery at bigpond.net.au <mailto:cavery at bigpond.net.au> > wrote:

Hi,



I am running GNUcash version 4.11 on Windows 11.



I have created a CSV file from Moneyspire and I want to import this into
GNUcash however many of the credits to the bank accounts are treated as
debits and debits treated as credits but not always.  I have inspected the
CSV file with Excel and also Wordpad and it looks fine.  It would appear
GNUcash has a problem with CSV files.



Regards

Charles Avery

_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org <mailto:gnucash-user at 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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 327506 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220915/72a5428d/attachment-0003.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.jpg
Type: image/jpeg
Size: 347685 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220915/72a5428d/attachment-0004.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image009.jpg
Type: image/jpeg
Size: 233498 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220915/72a5428d/attachment-0005.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 2000 Export 22-09-15.csv
Type: application/vnd.ms-excel
Size: 2212 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220915/72a5428d/attachment-0001.xlb>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: GNUCash 2000 Transaction file.pdf
Type: application/pdf
Size: 309611 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220915/72a5428d/attachment-0001.pdf>