transactions report on splits
I just tried the transactions report for the first time after upgrading to MD 2011. Its handling of splits is a disaster! This is a bank account with quite a number of deposits that used splits. The transactions report shows each account in a split deposit as if it were a separate deposit! It doesn't seem to matter whether I select "show splits" or not. The report comes out the same. In MD 2010, a transaction like that would show as a deposit of $XXX total.
This needs to be fixed soon.
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 -Kevin N. on 01 Jun, 2011 03:50 PM
Hi Russ,
As a workaround, give 'Advanced Search' a try. (Edit > Advanced Search) I don't know why but it seems to handle Splits differently than the Transactions Report.
HTH -Kevin N.
Edit: I just noticed that if you click on 'Generate Report' it creates a Transactions Report with the Splits separated. No joy
2 Posted by rrcrum1 on 01 Jun, 2011 04:19 PM
Thanks.
I tried that and it displays the transactions just the way I would like. However, the bugaboo is when I click on "Generate Report", I end up with the same display that I have if I select Transactions. (i.e. the splits are all broken out)
My problem is that I am the treasurer for my church and at the end of each month, my vouchers, check register and a printout of the month's transactions are turned in for audit. The transactions printout that MD 2011 is producing makes it very difficult for the audit person to compare with the bank statement.
Another work around I did which gets me by this month is to print the account register using the 30 day listing. Not the best but better than the split display issue. If there were an option to select the date range instead of being locked into fixed time intervals, that would be another way around the problem. Not as nice but useable.
Russ
3 Posted by -Kevin N. on 01 Jun, 2011 05:16 PM
Hi Russ,
Have you looked at the Find and Replace Extension? It offers a user defined Date range and an option to consolidate splits. It doesn't generate an actual report but you can COPY the results. You could then PASTE the results to a spreadsheet to print the report.
HTH -Kevin N.
4 Posted by rrcrum1 on 01 Jun, 2011 05:27 PM
Kevin,
Great! I just tried that and it worked great! Thank you!
Incidentally, what is the "Amount 2" column for that is in the pasted listing? That doesn't show up in the MD view.
Russ
5 Posted by -Kevin N. on 01 Jun, 2011 05:41 PM
Hi Russ,
I don't know. It maybe has something to do with the consolidated splits.
I'm glad to hear that this worked out for you.
-Kevin N.
6 Posted by linus.drouhard on 06 Jun, 2011 02:28 AM
Hi, Unlike Kevin, I cannot get the Find and Replace extension to hide the splits. This is really annoying and makes the reports extremely difficult to use. When will you provide a custom report generator?
7 Posted by paleolith on 06 Jun, 2011 05:06 AM
linus.drouhard: have you ticked the checkbox labeled "consolidate splits"?
Amount 2: it appears that when not consolidating splits, it is always the same as Amount. When consolidating splits, it's one of three things. 1) If there's no split and the other side is an account, it's the negative of Amount. 2) If there's no split and the other side is a category, then it's the same as Amount. 3) If there's a split, then it's the amount of the last split (or negated, as in 1 or 2). I can't see any value to it, and I wonder if an internal value related to Find and Replace accidentally got exposed.
Edward
8 Posted by -Kevin N. on 06 Jun, 2011 12:07 PM
Hi linus.drouhard
The latest version of the Find and Replace extension is Version 1.51 v.73 (Requires Jaava 6)
You can check your version from the Extension menu. (MD2010) Extensions > Get Info for. (MD2011) Extensions > Manage Extensions
To check the version of Java installed on your machine, open the Console Window listed under Moneydance's Help menu. The version of Java should be the 4th line of text from the top. It is my understanding that the second digit represents the version number. In my Console Window it is listed as Java: 1.6.0_25 (Sun Microsystems Inc.)
Finally, as Edward posted, make sure to tick the 'consolidate splits' option.
HTH -Kevin N.
9 Posted by rrcrum1 on 06 Jun, 2011 06:25 PM
I have just spent considerable time untangling some transactions in our church's accounts that occurred over the past several months. As you pointed out in this note, you have to be very careful when comparing the values from the find and replace extension with "normal" transactions. I found the best thing was to simply copy the find and replace results to a spreadsheet and go through correcting the positive and negative figures.
Russ
System closed this discussion on 31 Mar, 2015 03:33 PM.