CSV from SNS Bank does not have headers. The format is like this:

02-03-2019,NL01SNSB0123456789,,,,,,EUR,123.45,EUR,-1.23,02-03-2019,02-03-2019,1234,BEA,12345678,'1abcde/123456','Description',4
02-03-2019,NL01SNSB0123456789,,,,,,EUR,123.45,EUR,1.23,02-03-2019,02-03-2019,1234,BEA,12345678,'1abcde/123456','Description',4

Missing Headers:

Currently bank codes are present in the json as bankName. Should transform to a list of options. Ranges should also be possible, since this is used in Belgian banks. See #51

Downloaded CSV file from ING savings account.
After dropping file

CSV file itself:

When opened in Excel no problem. All data is there.

CSV file for regular ING account worked just fine.

Example CSV export from ING:

"Datum","Naam / Omschrijving","Rekening","Tegenrekening","Code","Af Bij","Bedrag (EUR)","MutatieSoort","Mededelingen"
"20180503","Hr A.B. de Vries","NL01INGB0123456789","NL01RABO0123456789","GT","Bij","15,00","Online bankieren","Naam: Hr A.B. de Vries Omschrijving: Bier IBAN: NL01RABO0123456789"
"20180502","MHM HOTELS","NL01INGB0123456789","NL13ANBA0123456789","OV","Bij","15,00","Overschrijving","Naam: MHM HOTELS Omschrijving: Ontbijt IBAN: NL13ANBA0123456789"
"20180502","M.C. Schilder","NL01INGB0123456789","NL44BUNQ0123456789","GT","Af","35,00","Online bankieren","Naam: M.C. Schilder Omschrijving: Doe er iets leuks mee IBAN: NL44BUNQ0123456789"

Add confirmation dialog before syncing through the API, such that the user can cancel the sync in case of an error.

When i synced an export .csv and upload it, the data does not arrive after synchronisation. At least, not always. Very strange. On some accounts it works. I used four bankaccounts in YNAB and the issue is skipping trough the accounts. last week it was a different account that did not sync.

I expect all transactions to arrive in the selected budget + account.

• OS: MacOs 11.6.5
• Browser Firefox & Safari

I tried to change API key, but this did not help. I get the green light for sync complete. But it is just not there.

Is your feature request related to a problem? Please describe.

As a developer, I want to be able to fully automate my import pipeline, so that I don’t need to manually drag and drop too much.

Describe the solution you'd like

If the core conversion code were published as a standalone package, I would be able to easily use it directly in a custom workflow.

For instance, on my macOS machine I can attach a script to the Downloads folder that automatically invokes the conversion for csv files that match the expected filenames and do some further processing such as giving the files account names that correspond to the names I use in YNAB.

Additional context

Thanks for your work and releasing this! 🙏

Hi,

My transactions often include those from one of my bank accounts to another (checking to savings, for instance). The payee in all cases is the same, my name, but the IBAN is different. It would be useful if the tool put the name and the IBAN in the payee field so that YNAB can automatically recognize which bank account to which to set the transfer.

Thanks a bunch for creating this useful tool :)

Edit: I'm talking about Rabobank in this case, but I suspect it would be applicable to other banks as well.

Uploading a file seems to go fine, but the buttons that appear after don't function.

Tried both Chrome and Firefox with no extensions. I also tried a rather big file (16KB) and a smaller one (2KB), both with no success.

http://puu.sh/BahnU/080c9c780c.png

please add support for triodos
mutations20201230172942.zip

Current selection and issue
The selection pop-up currently shows all YNAB accounts, even if they are closed (archived), tracking or loan accounts.
They are shown in the order of JSON response, but otherwise not sorted based on any status or category. This means that the list is cluttered, especially if you have many closed YNAB accounts.

Describe the solution you'd like
While I believe all YNAB accounts should be visible, their status should be used to streamline the account selection. The JSON response for each account includes two variables that can help with this: "on_budget" and "closed"
Then using <optgroup>-tags, the <select>-element can be easily stylized.

HTML example

<div id="selection-popup">
<p>Which account for NL99YNAB0001234567</p>
<select>
 <!—For YNAB accounts that have "on_budget": true, "closed": false,-->
<optgroup label="On Budget Accounts"> 
	<option value="0">Regular</option>
	<option value="1">Saving</option>
	<option value="2">Emergency Fund</option>
	<option value="3">Family Account</option>
</optgroup>
 <!—For YNAB accounts that have "on_budget": false, "closed": false,-->
<optgroup label="Tracking Accounts">
	<option value="4">Stocks</option>
	<option value="5">OV Chipcard</option>
</optgroup>
<!—For YNAB accounts that have "closed": true,-->
<optgroup label="Closed Accounts">
	<option value="6">Student Loan</option>
	<option value="7">DNB account</option>
</optgroup>
</select>
	<button class="button-border">cancel</button>
	<button class="button-border">accept</button>
</div>

With PIN transactions, SNS and ASN do not note the payee in the appropriate place (col 3). It does note it in the "memo" box (col 17). See issue #10

ING has a discrepancy between actual transaction dates and the date the transaction is processed. For example, if you paid for something on january 1st, it might not get processed till january 3rd due to business days. Card payments have a transaction date in "Mededelingen" under the subfield "Pasvolgnr". However, I can't quite seem to find an entrypoint to scoop out the transaction date from "Mededelingen". I've been trying something like this on line 260:

date: new INGTransactionDate(new Field(["Mededelingen"], ['Pasvolgnr'], ['Pasvolgnr'])) || new Field(["Datum"]),

And feed it to INGTransactionDate() to process it (I simply need to extract the date with some regexp magic and return it). But it doesn't return a string (variable "text" in the getLine method in Field) as one would expect. Got any clues how to proceed?

When trying to transform a RABO CSV file, it does not work.
YNAB going dutch does not give a change file.
Not with one account, or with multiple accounts.
Using Edge on Macbook. Both up to date.

There are many different kinds of subfields possible in ING's "Mededelingen" field which don't work with the current splitBefore/splitAfter technique. So I made a fork and improved it.

Make it possible to store the relation between an account ID and the YNAB account, such that it can sync without the dialogs.
Should probably still have a confirmation dialog.

Also needs a UI in which the relations can be deleted and/or disabled.

Exporting would also be great. Related to #47

Please state the bank name and the type of account you would like to be supported.
It is important to add an anonymized CSV file from the requested bank to your issue. You can add this file in a .zip.

Hi!

My Bunq is in English; so my exports are in English as well. The filled in JSON:

  "bunq-en": {
    "bankName": "BUNQ-EN",
    "header": [
      "Date",
      "Interest Date",
      "Amount",
      "Account",
      "Counterparty",
      "Name",
      "Description"
    ],
    "account": [
      "Account"
    ],
    "date": [
      "Date"
    ],
    "dateFormat": "DD/MM/YYYY",
    "payee": [
      "Name",
      "Counterparty"
    ],
    "category": [],
    "memo": [
      "Description"
    ],
    "outflow": [
      "Amount"
    ],
    "inflow": [
      "Amount"
    ],
    "positiveIndicator": null,
    "negativeIndicator": "-"
  },

Edited English export:
anon-bunq-export.zip

Because of the possibility of conflicts between Dutch and English bunq exports, I have not attempted at making a PR for this. You know best how possible conflicts could be handled.

Thanks!

Directly upload the transactions to ynab

Improve the communication of the software with the user. Should give the user more information about errors, especially the ones with the api connection. As of now, those are mainly shown in the console log.

It would be nice if compatibility for Rabo credit cards was added at some point in the future, currently the CSV files are not recognized.

Example CSV structure:

Creditcard Nummer,Munt,Productnaam,Creditcard Regel1,Creditcard Regel2,Transactie Referentie,Datum,Bedrag,Tegenrekening IBAN/BBAN,Omschrijving,Oorspr bedrag,Oorspr munt,Koers
1234,EUR,RaboCard,FIRST LAST,,2019-08-230000003,2019-08-23,-5.99,NL00RABO0123456789,amazon.nl LUX,,,
1234,EUR,RaboCard,FIRST LAST,,2019-08-230000002,2019-08-23,+20.00,NL00RABO0123456789,INCASSO - VORIG OVERZICHT,,,
1234,EUR,RaboCard,FIRST LAST,,2019-08-20SH00019,2019-08-20,-41.67,NL00RABO0123456789,PAYPAL *EXAMPLE LTD 35558566123 GBR,,,

Add support for CSV files which have a ; as separator and a , used in floating point numbers. Linked to issue #51

On windows, no response is given while uploading the files. On Mac OS it does work

Notie should be replaced by a custom notification, which:

• Stacks messages (for errors e.g.)
• Can dismiss messages
• Has colors and classes for message types (error, warning, success, info)

Create an option to export and import settings from the settings panel.

Include the api into the YNABConnection class, such that the api is not open for everyone to use.

Track the number of API calls. Can only make 100 per hour. Create a counter and display a message when the counter reached 100.

Add more settings like:

• Add transaction with or without additional text in memo (ATM this is YGD)
• Add transaction cleared or uncleared (ATM this is uncleared)
• Add transaction approved or not (ATM this is approved)

Give a new name to the repo which corresponds more with the functionality

Get rid of the ugly looking C and change it for something cool/fun

Please state the bank name and the type of account you would like to be supported.
--> Checkings account for KBC (Belgium)

It is important to add an anonymized CSV file from the requested bank to your issue. You can add this file in a .zip.

KBC_csv.zip

Utility is not working at the moment.
This is the console output in Chrome:

Failed to load resource: the server responded with a status of 404 ()

Also tried with Firefox, Edge and IE. No success.

Describe the bug
On all bunq statements, the date field is corrupted and unusable when imported to YNAB. I initially considered the issue to be with the "recent" CSV changes of bunq with their new interest payments — the issue also persists with CSV files from 2018, long before the introduction

To Reproduce
Steps to reproduce the behavior:

1. Import recent bunq statement
2. Download CSV
3. Open downloaded CSV
4. Starting after the definitions (line 1), all transactions have a non-standard date formatting.

Expected behavior
Output transaction date to YYYY-MM-DD, instead output date is grarbled:

"Date","Payee","Category","Memo","Outflow","Inflow"
"20-1--3-26","NYTimesNYTimes","","NYTimesNYTimes 800-698-4637, US","2.00","0"`

Input:

"Date","Interest Date","Amount","Account","Counterparty","Name","Description"
"2021-03-26","2021-04-01","-2,00","NL98BUNQ2206754703","","NYTimesNYTimes","NYTimesNYTimes 800-698-4637, US"

Console
If applicable, add the console log to help explain your problem.

Desktop (please complete the following information):

• OS: MacOS 11.3.1
• Browser: Safari
• Version: 14.1

Additional context
Issue not present with Rabobank statement.

Describe the bug
When trying to convert a downloaded csv file from ASB Bank Internet banking I get the error message 'Bank could not be recognised!'.

To Reproduce
Steps to reproduce the behavior:

1. Go to https://www.asnbank.nl
2. Login, click on bank account
3. Choose 'Transacties downloaden'
4. Select a time periode
5. Choose 'bestandsformaat' value 'CSV' or 'CSV2004'
6. Press the button 'Downloaden'
7. Clone this project and open Index.html in the browser
8. Drag the downloaded file into the box
9. Get the error message 'Bank could not be recognised!'

Expected behavior
I gather after dragging and dropping the csv file I would get a prompt for a download of a converted file that is able to be imported into YouNeedABudget.

Desktop (please complete the following information):

• OS: MacOSx BigSur 11.5.2
• Browser Brave, Safari
• Version Version 1.29.79 Chromium: 93.0.4577.63 (Official Build) (x86_64), Version 15.0 (16612.1.29.41.4, 16612)