How can i batch change transaction errors from payment to charge?
I used to keep all my credit card, investment an banking info in a spreadsheet. With Moneydance, I would better be able to track expenditures so I'm trying to switch over. I successfully found and installed the Text File importer extension and saved the relevant worksheet as a UTF16 file (Csv didn't work properly). But when I tried to import the fields available were quite limited with one "amount' field.
I did manage to succeed with 2 issues:
a. all the charge transactions, which were in the single AMOUNT field showed up as payments, so I am having to manually move the amounts over to the other field. As there were about 1400 transactions (I'm trying to load the end of 2013 and all of 2014 for tax purposes), this is a long drawn out process and this is just one account.
b. not every spreadsheet row came over. I'm examining it now (manually) against what's in Moneydance and found that refunds and payments were not coming over at all. Since there is no indicator in Moneydance as to how many transactions are there I don't know how many others are missing.
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
1 Posted by music on Apr 02, 2015 @ 05:46 AM
Okay, I finally got the text file importer to work on occasion. As I said above, not every spreadsheet row (= transaction) worked. So I have to go through it line by line and manually enter the missing rows. Once I identified a bunch of the missing rows, I tried putting them into a separate spreadsheet (in UTF16 format) and using Text Import. No success at all. This is very frustrating as I have several years of data I wished to bring into the program (when I had problems I only tried to bring in from mid-2013 but even then it's a lot of rows). I also have other accounts (3 banks (only 1 is US$ and it's a credit union) with multiple accounts, investments, mortgages, other credit cards, Paypal, etc.). This is not turning out to be a pleasant experience and as I work on this I get new transactions so fall further behind.
2 Posted by Scott Meehan on Apr 02, 2015 @ 05:19 PM
Hi Music,
Unfortunately CSV files aren't easy to work with for importing data. Have you looked into CSV to QIF converters to see if that would be a route that you'd like to pursue?
Scott Meehan
Infinite Kind Support
3 Posted by -Kevin N. on Apr 02, 2015 @ 06:07 PM
Hi music,
You may be better served trying the CSV Importer rather than the Text File Importer.
The CSV Importer is more robust than the TFI and allows for separate Debit and Credit columns in the imported CSV.
If you are using MD 2015 then you can only download the CSV Importer from the developer's website.
https://github.com/stant/mdcsvimporter2015/releases
Download the mdcsvimporter.mxt file.
In Moneydance, go to Extensions > Manage Extensions.
Use the 'Add from file' option to navigate to the mdcsvimporter.mxt file.
You'll receive an ominous sounding warning - it's because the file isn't yet signed by Moneydance.
Once installed, the CSV Importer will appear in the Extensions menu as 'Import File'.
If you need help setting up the custom reader(s), let me know and I'll try to give you help with it.
If you'ld rather stay with the TFI, Your best option would be to first combine the Debit and Credit columns using a simple IF function formula. If you need help with that, let me know and I'll try to give you a hand with the formula.
HTH -Kevin N.
4 Posted by dwg on Apr 02, 2015 @ 08:33 PM
I have used spreadsheet tools to convert to QIF and provided the spreadsheet has a consistent format they work quite well.
Des
5 Posted by music on Apr 14, 2015 @ 06:13 AM
Thanks for the advice Kevin. Unfortunately the csv importer didn't work
(it starts off with a number of selections and the first one ("reader")
doesn't actually have any options so it's a non-starter).
Ted
6 Posted by music on Apr 14, 2015 @ 06:19 AM
Thanks. I actually did search for QIF converters but they all wanted $
which I am loath to part with for a one-time use. I've been using the
text converter and it does import every line (earlier on I was getting
sporadic losses but I've taken all the formulae out of my convert file.
The only issue I find now is that any number over $999.99 seems to have
too many digits and the right characters show up in my memo field so
although manual it's not too cumbersome. Part of my problem is that I
started doing all my budget in Excel after MS Money failed when I moved
to a Mac in 2009. So I can always cut back on the amount of data and
just put in the 2014-5 data.
Ted
dwg wrote:
7 Posted by dwg on Apr 19, 2015 @ 08:25 AM
There are free plugins for Excel and OpenOffice\LibreOffice that can be used:
http://xl2qif.chez-alice.fr/xl2qif_en.php
Open the csv file in the spreadsheet and go from there.
Des
8 Posted by -Kevin N. on Apr 19, 2015 @ 11:44 AM
Hi music,
If you don't have any luck with the xl2qif converter that Des linked to, post a small sample of your CSV file and I'll try to set up the CSV Importer for you.
I'll need to see at least one payment txn and at least one credit txn so as to see how they are formatted.
You can redact the descriptions if you wish.
Include the header and footer row(s) (if any).
-Kevin N.
System closed this discussion on Mar 19, 2016 @ 04:56 AM.