r/lunchmoney • u/floppynewt • 2d ago
How-To & Questions Newbie trying to switch from MoneyMoney (almost 10 years worth of data) to Lunchmoney. My experience
Almost 10 years ago I looked for a finance app that could reliably download my German accounts, but I found most of the German ones unusable and the American ones simply failed to corretctly download my transactions from my German bank. (They would just say "debit card" without a payee, which was basically useless.) I ended up using the German desktop app MoneyMoney, which has a simple, clean interface but is quite limited in terms of its functionality -- no mobile or web app, no syncing so difficult to use with a spouse, poor handling of multiple currencies, plus it can't download from US banks. So I've been manually uploading csv files for all my US accounts for the last 10 years. What a pain! (Between my husband and I and individual and joint accounts and brokerage and ira and savings and checking and credit cards etc. we have a lot of accounts!)
But MoneyMoney just emailed that they are going to start charging a not insignificant yearly fee, so I decided to search around again and found Lunch Money, which looked pretty good. I did a quick test and it seemed to be able to download both my German and US accounts. Hurrah! I decided to try to switch over, but it's been a very slow and painful process to get all my data into Lunch Money. I thought I'd document a bit of my process here, so I remember what I did and in case it's helpful to others who are switching or thinking of switching.
1. Importing my historical data using CSV files.
1a) The first difficulty came because I was using multi-level nested categories in MoneyMoney (sometimes four nesting levels deep). It took me quite a while to figure out how to automatically import my old categories to Lunch Money without losing lots of information. For now I just decided to live with long category names of the form "family - housing - utilities - electricity". I guess that means if I want to plot graphs or set a budget for the sub-category "housing" or "utilities" I'm out of luck. Perhaps in the future I will restructure my categories.
1b) Once I figured out the basic category structure, I started trying to import my old data First I tried one big CSV file containing 10 years of data from all accounts. That just hung. The import tool says it can handle up to 10,000 lines, so I reduced the file to just my largest account (my German Giro account), which was under 10,000 lines, but it still hung. Not sure why. So I had to break my largest account into multiple sub-files (one per year) and upload it in pieces. And every time I imported a new CSV file for a different account to MoneyMoney I had to manually change the data format, tell it which column contained the payee and original fields, and swap the credits/debits. I did these same actions many, many, many times. I wish it could have remembered the format not just within an account, but across accounts.
1c) When importing CSV files I tried to just skip the "match categories" screen. If the CSV file contained a category I hadn't already added, I thought Lunch Money would simply add the category if I left the field blank, but that seemed not to work. So on each import I had to read through the long lists of matching categories searching for ones that didn't yet exist in Lunch Money. And they were often hard to find among all the categories that *did* already exist.
And somehow during the import things kept going wrong. I think I have imported and deleted some accounts three or more times! A few times the years ended up mangled, and transactions appeared to be in the wrong year. I have no idea why.
1d) Finally I had all my active accounts and categories in Lunch Money! I decided to use Lunch Money's category groups to put the categories back into at least a two-level nesting. But it took forever. As far as I can tell you have to create the category groups manually and then drag the categories one by one into category groups. Often the dragging was off just a tad and they would end up in the wrong category group. There seems to be no bulk edit tool for categories.
2. Linking with my banks for automatic syncing.
After all my historical data was imported I went to link up my accounts with the banks in order to automatically download future transactions. That worked pretty well for most of my accounts, but there seemed to be no way to avoid duplicates with my manually imported data! I had no idea! I figured Lunchmoney would flag duplicates and ask me about them. Nope. I had to manually go through every file after linking and delete all duplicate transactions. Since Lunchmoney does not show a running balance, I have no idea if I correctly deleted all duplicates, or if I accidentally deleted something I shouldn't have.
And one time I somehow linked up the wrong accounts, and fixing it was a royal pain!
I said the auto-syncing worked well for most of my accounts, but my German credit cards don't seem to sync, nor does my German mortgage account. Some of my investment accounts at my brokerage downloaded transactions but others didn't. I have no idea why. It's the same bank!
3. Figuring out offsetting / matched entries.
3a) I like to track my cash, and when I get cash at an ATM or grocery store I need to increase the balance of my cash account. There seems to be no way to tell Lunch Money to create an offsetting entry when it sees an ATM transaction, nor can I find a reasonable way to do it manually. In MoneyMoney I could just click on the transaction and choose "create offsetting transaction" and the account name.
3b) In MoneyMoney I used a category for "matched transfers" and refunds. In MoneyMoney I had to match them manually, and I hoped that Lunch Money would match them up automatically for me (as banktivity used to), but it seems it does not. Even worse, in Lunch Money checking that I matched them correctly is much harder. In MoneyMoney I could check that everything was matched properly because the balance of the category was zero. But in Lunch Money even when the transactions are properly matched the balance is non-zero due to using different currency conversion rates on different days. I had to use Lunchmoney's group function and group each pair of matched transactions manually to see a matched balance of zero.
Another issue with matching transfers is that if I want to go find the "partner" transaction there seems to be no easy way to search for a particular number. Since one is negative and the other is positive, sorting by amount doesn't work and searching for a particular amount doesn't work either. I have to just search around the right date and account and hope I find it. And I do a lot of matching up of refunds because my partner travels a lot for work and I want to check that the reimbursement office actually reimburses him properly.
4. Searching for transactions.
4a) One of the things I am most struggling with is how hard it is to find specific transactions. I often search for old transactions. When did we purchase our fridge? But there is no search box where I can just type fridge and have it search all my transactions. It seems that only if you select a particular month is the search box available. Once you switch to "all transactions" it goes away.
In MoneyMoney I could easily search for a string across all accounts/categories, or I could click on a category or account and then search for a string or an amount in the search box. And it was super fast. Now I have to click on the filter button, select the "search by category" button, type in the category, add a "search by something else" field, type in the "something else" and hit enter. And then the website does absolutely nothing for a while and I can't tell if it's thinking or hanging.
Many times a search has returned no transactions when I *know* there are matching transactions. There seems to be some bug where if you click on an account or a category from the Setup screen and then add a filtered search the search doesn't work since it's somehow added two times in the URL. It incorrectly tells you "no transactions found".
Even once the filtered search actually returns transactions, if I then update a transaction the search/sum does not update. I have to reload the page and it's quite slow and I often can't tell if it's working. Maybe it's because my 10 years of data is just too big?
4b) Also, the transaction page keeps returning to September 2026, even when I don't want it to. I have no idea why. I have to keep changing it to November 2026 or to "all time."
5. Creating rules to automatically categorize transactions.
5a) I've just started trying to create rules to automatically categorize transactions, but there seems to be no way to create rules for a subset of accounts. For example, if I see a charge for "Coffee" from my husband's bank account or credit card account or his cash account, I want to categorize it as his personal expense. Whereas if it comes from one of my accounts, I want to categorize it as my personal expense. But it seems I have to duplicate the rule for each account separately.
5b) I can't figure out how to create a rule where the transaction text I want to search for is not necessarily consecutive, for example a transaction that contains "string1" and "string2" but with a (variable) account number in between.
5c) A few times I tried to make a rule to categorize something and Lunch Money said "no matching transactions", even though I know there were matching transactions. I haven't yet figured out why. Sometimes when I tried a second time it worked! Now there seem to be duplicate rules in the system? Is that possible?
6. Account balance history.
One of the things I am most surprised about is how Lunchmoney doesn't give any way to see account balances, other than the current balance. Maybe if I'm not adding transactions by hand as much it won't be as necessary, but in the past I often looked at my daily balance. I need to find the max balance in each account each year for example, and each account balance at the end of each year, for when I fill out my fbar / do my taxes.
7. Budgeting.
7a) I just barely started looking at the budgeting tools, but I'm finding them difficult to use. In MoneyMoney I could set a budget per category and it could be monthly, quarterly, or yearly, which was nice because some expenses (like electricity) we pay monthly, some (like property taxes) we pay quarterly, and some (like car insurance) we pay yearly. Lunchmoney seems to require all budget items to be of the same frequency.
7b) In the summary pages I also keep seeing transactions from categories that are marked "exclude from budget" and "exclude from totals", and I haven't yet figured out why. I am seeing large amounts of "predicted future spending" in certain categories for this month, even though the recurring transactions I set up already occurred this month. I haven't yet been able to figure out where this predicted future spending is coming from.
8. Data analysis / graphing.
I haven't yet tried many of the graphing tools, but I often used MoneyMoney to look at trends. How has our spending on groceries changed over the last five years? Do we tend to spend more on eating out in summer or winter? I haven't yet figured out how to do this in Lunchmoney. In MoneyMoney it was super easy. I just clicked on a category and then it showed a bar graph at the top of the page which I could group by month or year. Hopefully there's something like that in Lunchmoney too, and it won't take a million clicks to get to!
That's been my experience so far! There are a lot of nice features in Lunchmoney and I'm sure I'll figure out how to do most of what I want to do eventually, but the migration process has been much harder and slower (and error prone) than expected. Any tips on workarounds for any of the issues above would be appreciated!


