[GNC] FW: CSV Import Problem

Thu Sep 15 04:31:56 EDT 2022

Hi David,

I may have discovered the problem.  The CSV file created by MoneySpire has withdrawal and deposit columns.  The withdrawal column shows a negative number i.e. there is a negative sign in front of the numbers.  I did a trial with the number as a positive number and I believe this may resolve the problem.

Kind regards

Charles Avery

Mob: 0404 242 278

From: cavery at bigpond.net.au <cavery at bigpond.net.au> 
Sent: Thursday, 15 September 2022 4:12 PM
To: 'David Carlson' <david.carlson.417 at gmail.com>
Cc: 'mailman-request at gnucash.org' <mailman-request at gnucash.org>; 'gnucash-user at gnucash.org' <gnucash-user at gnucash.org>
Subject: RE: [GNC] CSV Import Problem

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 <mailto:david.carlson.417 at gmail.com> > 
Sent: Wednesday, 14 September 2022 10:56 PM
To: cavery at bigpond.net.au <mailto:cavery at bigpond.net.au> 
Cc: mailman-request at gnucash.org <mailto:mailman-request at gnucash.org> ; gnucash-user at gnucash.org <mailto: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: image001.jpg
Type: image/jpeg
Size: 319758 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220915/da7a9215/attachment-0003.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 332033 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220915/da7a9215/attachment-0004.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.jpg
Type: image/jpeg
Size: 227401 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220915/da7a9215/attachment-0005.jpg>