Exporting transactions to Excel (YNAB4)
I'm still using YNAB 4 (nYNAB scares me!)
I'm trying to export transactions for a specific category, but can't seem to get it to work. When I look in YNAB4, the balance says one amount (say $380) but when I total the transactions I am able to export it's over $1,000.
What am I doing wrong? And how can I do it right!
Hi Buff Navy Blue Yearling !
Sorry for the delay here! The export should show what's in your budget automatically. Are you getting the same altered numbers every time you export? Would you be able to post a screenshot of what you're seeing?
Hey Navy Blue Yearling !
A couple more questions, in addition to Faness', if you don't mind!
1. Are you doing the export from the "Spending by Category" Report?
2. Are all the transactions the same, but maybe the -/+ for each transaction is wrong?
3. Double check your filter settings for export too, perhaps not all budget accounts are included? Or even the dates could be set incorrectly?
Let me know what you find!
Navy Blue Yearling
In YNAB 4, the way you export selected transactions is:
1. Search for the transactions you wish to export. In the case you mention, you'd do a search for your category of interest. If you only care about one account, you can search in that account; if you care about all accounts, you search in the All Accounts screen.
2. When you do the actual export, a dialog box pops up that lets you select CSV or QIF. There is also a check box, by default unchecked, labeled "Export current register view only." You want to check that box. If you don't, YNAB 4 will export everything in your budget.
If you select QIF, you'll get a file that can be imported to Quicken but doesn't make much sense in Excel. If you select CSV, you will get two files. One is labeled register, and will be just the transactions you selected if you checked the box. The other file is labeled budget, and will list the budget screen for every month in your budget. If all you want is transactions, ignore the budget file and work with the register file.
If the category of interest is embedded in some split transactions, the export will also give you the rest of the splits in any transactions that contain the category of interest as a split line item. If you're only interested in the part of the split that's the category of interest, you will need to edit the file in Excel to manually delete the other lines from the split transactions. Split transactions is my best guess why your category sums to $380 but the exported transactions sum to over $1000, but it's possible something else is going on that I haven't thought of.
OK - this is really confusing and frustrating as I'm an accountant and can't figure this out!
Shot 1 - when I search in YNAB under the category "Reimburse", I get a total of $695.01.
Shot 2 - the current month. You can see the Balance is $137.88.
I would have expected these two amounts to be the same. As Patzer said, it could be to do with split transactions.
When I export the transactions to CSV I get the $695.01 total again. Looking at the split transactions these look OK.
My problem is my wife purchases stuff for work, and takes a long time to claim the reimbursement, so it's hard to work out if there are things she has bought but not claimed back. Hence this process and now problem!