How can I map my transactions to accounts in a QIF file?
Scenario
I have two accounts at a bank, and would like to import transactions into GnuCash. My bank only gives me CSV files, but it can at least put transactions for both accounts into a single CSV file.
These CSV files are, as is, un-parseable by GnuCash, so I decided I'd convert them to QIF files, as I can also add account information to each transaction — or so I've heard.
The trouble is, QIF is badly defined. I'm picking through various fragments of documentation, but I still can't figure out how to format my account information. Whatever I seem to do, GnuCash tells me that the file has account details for only one account, and pre-fills the account name with the name of the file.
What I've tried
Account with name for each transaction
!Account
NNameOfAccount
!Type:Bank
D01/01/16
T100.00
MSometext
PSomePayee
^
Account with name for each set of transactions in that account
!Account
NNameOfAccount
...transactions...
!Account
NNameOfOtherAccount
...transactions...
Account before each transaction
This one actually gets me through most of the import steps, and correctly maps both accounts. Trouble is, I'm then given a cryptic error message: 'A bug was detected while converting the QIF data.'
!Account
NNameOfAccount
^
!Type:Bank
D01/01/16
T100.00
MSometext
PSomePayee
^
!Account
NNameOfOtherAccount
^
!Type:Bank
D01/01/16
T100.00
MSometext
PSomePayee
^
Sources of interest
tl;dr
How should I format a QIF file so that I can specify the name of the account for each transaction?
I ran into the same issue. It was frustrating to find multiple explicit claims online that GnuCash supported multi-account QIF files with no explanation of what they should look like.
I ended up going through GnuCash source code and found that GnuCash has an internal switch to ignore account info in QIF files, and apparently that switch is on by default. Fortunately, it can be turned off with the !Clear:AutoSwitch directive. With that I was able to generate and import multi-account QIF files. Example:
!Clear:AutoSwitch
!Account
NAssets:Bank:Bank 1
^
!Type:Bank
D2016-12-10
T0.01
PPayday!
LIncome:Salary
^
D2016-11-10
T0.01
PPayday!
LIncome:Salary
^
!Account
NAssets:Bank:Bank 2
^
!Type:Bank
D2016-12-15
T-999.00
PRent
LExpenses:Rent
^
- Read columns of a csv file using shell or pipe inside R - Windows
- find unique entries in one field across two CSV files with shell and friends
- read nested json inside csv file using pandas?
- How to ignore the first line of data when processing CSV data?
- How can I read and parse CSV files in C++?
- :( scourgify.py cleans short CSV file || :| scourgify.py cleans long CSV file
- module 'pandas' has no attribute 'read_csv
- Error: Unsupported format, or corrupt file: Expected BOF record
- Parsing a CSV file using gawk
- Importing a csv into mysql via command line
- Pandas style.to_latex: how to add a \cmidrule in the header?
- Insert multiple rows into a database table from a CSV file using Codeigniter
- How to check whether csv.DictReader object is empty or not
- Trouble reading CSV file using pandas
- How to write to an Excel spreadsheet using Python?
- Pandas does not separate columns of imported csv file
- View tabular file such as CSV from command line
- Pandas: ValueError: cannot convert float NaN to integer
- Unicode in CSV file?
- Transform SQL insert script into CSV format
- how to skip/ignore malformed CSV when using CSV.foreach?
- Gdk4 Clipboard union provider does not appear to make data available as expected
- Split columns in Csv file
- How to dynamically create a CSV out of parsed JSON in a Logic App
- Convert JSON dictionary file to CSV
- Is there a way to include column index name with Pandas dataframe to CSV?
- Looking for a java CSV library that allows reading columns by name
- How to delimit text stored in variable to create a dataframe in python?
- Writing a csv file into SQL Server database using python
- condition based on the date contained in the file name