Writing a script to import bank's csv file

Brendan S disposableemail at apps.opensourcelaw.biz
Mon Feb 10 18:14:56 EST 2014


Thank you for your help, some comments below. 

On 02/11/2014 09:57 AM, Tommy Trussell wrote:> On Mon, Feb 10, 2014 at 4:39
PM, Tommy Trussell <tommy.trussell at gmail.com>wrote:
>> On Mon, Feb 10, 2014 at 3:37 PM, Brendan S <
>> disposableemail at apps.opensourcelaw.biz> wrote:
>>
>>> On 02/11/2014 12:35 AM, Mike or Penny Novack wrote:
>>>> Brendan S wrote:
[]
>> As a rule of thumb, if you have a single transaction (such as you use a
>> debit card -- AKA EFTPOS -- and some of the money comes to you as cash
>> and
>> some of it is spent on one or more different things) then you will need a
>> split transaction.
>>
>> In the case of a debit card and getting cash in addition to a purchase,
>> it
>> might look like this in your books (you'll have to imagine the debit and
>> credit columns as I'm not going to try to align them):
>>
>> Looking in BigBank's account:
>>
>> 2/10/2014    Grocery Store
>>   memo line, if any, shows here
>>   ...............Expenses:Groceries      $50.00  [left/debit column]
>>   ...............Assets:Current Assets:Cash in Wallet:  $100.00
>> [left/debit]
>>   ...............Assets:Current Assets:BigBank  $150.00 [right/credit]

I will try this. 

[]
>> If you write a check or create a single debit transaction for a single
>> purpose, then when you key it in you don't need to worry about splits.
>> Internally, however there is ALWAYS a split because the money in a
>> transaction has to come from somewhere and go somewhere else.

No problem.  Just means I need to work out how to write a split in a qif
file.  

[]

> I just realized when you wrote EFTPOS you meant what I call a "credit"
> card, which carries a liability (from my perspective; it's an asset to the
> bank). In other words, you buy stuff which increases the amount you owe to
> the bank, which you pay down monthly.

No, you were right originally.  It's a debit card.  Money goes from my
checking account to the merchant.  If there is no money in the checking
account, the transaction fails. 

I was also asking a separate question about how to record payments from my
checking/debit card account to my credit card account. 

> SO pay attention to the columns, though by default GnuCash "helps" you by
> swapping them for you so they look the same:
> 
>   ........Liabilities:Credit Cards:BigBank $150.00 [right/credit]
> 
> The transactions "SHOULD" be swapped on the other sides, and you can tell
> GnuCash in its preferences, that you want to see the columns the "correct"
> way.  :-)

Ok, now you've confused me!

This is all sort of making sense. 

Brendan
 




--
View this message in context: http://gnucash.1415818.n4.nabble.com/Writing-a-script-to-import-bank-s-csv-file-tp4668150p4668173.html
Sent from the GnuCash - User mailing list archive at Nabble.com.


More information about the gnucash-user mailing list