Importing bank transactions, gnuCash 2.6

David T. sunfish62 at yahoo.com
Thu Apr 20 06:37:50 EDT 2017


Dave, 
Gnucash supports numerous import formats--QIF, OFX, csv, and others. If you use a search engine like Google and enter a search term like "gnucash import", you will find many leads. 
That said, your data source will not allow very helpful importing, since it lacks any information that could be used for the second side of every transaction. 
The only way around this is for you to provide that information. You can do it before, during, or after the import itself. 
Before, you would go through your source file (whichever format you choose), and add the second account. Adding them this way would allow you to use text editor tools. 
During, you would open each transaction in the list before you finish the import and assign the second account. Slower, but more reliable. 
After, you would open the IMBALANCE-USD  account and add the second account there until all the transactions disappear from the register. 
HTH, David 

 
 
  On Thu, Apr 20, 2017 at 14:24, dave boland<dboland9 at fastmail.fm> wrote:   I need a plan to import about a year's worth of bank transactions into
gnuCash.  The user's bank can do many different file formats, so the
first question is which one is best?  Keep in mind that the data is
simply:

Transaction  Transaction  Check  
Date        Type*        No.    Description**  Credit  Debit  Balance
-----------  -----------  ------ -------------  -----  ------- -------

* Deposit, Withdrawal, Check, Purchase, Fee
** Only for purchases using the bank card, or ATM address

There is no receiving account (Expenses:Grocery for example).

What is the procedure to import the transactions?  I get that
File/Import is used, but I'm more interested in how the transactions are
matched to the receiving account.  Will this also 'R' the transaction?

I went through Help, but found nothing (Hint Hint).  Googling didn't get
me the help I want either.

Thanks,
Dave
-- 
  dave boland
  dboland9 at fastmail.fm

-- 
http://www.fastmail.com - Or how I learned to stop worrying and
                          love email again

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


More information about the gnucash-user mailing list