transactions report on splits

rrcrum1's Avatar

rrcrum1

01 Jun, 2011 03:28 PM

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.

  1. 1 Posted by -Kevin N. on 01 Jun, 2011 03:50 PM

    -Kevin N.'s Avatar

    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. 2 Posted by rrcrum1 on 01 Jun, 2011 04:19 PM

    rrcrum1's Avatar

    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. 3 Posted by -Kevin N. on 01 Jun, 2011 05:16 PM

    -Kevin N.'s Avatar

    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. 4 Posted by rrcrum1 on 01 Jun, 2011 05:27 PM

    rrcrum1's Avatar

    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. 5 Posted by -Kevin N. on 01 Jun, 2011 05:41 PM

    -Kevin N.'s Avatar

    Hi Russ,

    Incidentally, what is the "Amount 2" column for...

    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. 6 Posted by linus.drouhard on 06 Jun, 2011 02:28 AM

    linus.drouhard's Avatar

    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. 7 Posted by paleolith on 06 Jun, 2011 05:06 AM

    paleolith's Avatar

    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. 8 Posted by -Kevin N. on 06 Jun, 2011 12:07 PM

    -Kevin N.'s Avatar

    Hi linus.drouhard

    I cannot get the Find and Replace extension to hide the splits...

    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. 9 Posted by rrcrum1 on 06 Jun, 2011 06:25 PM

    rrcrum1's Avatar

    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

  10. System closed this discussion on 31 Mar, 2015 03:33 PM.

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

Recent Discussions

29 May, 2024 07:01 AM
29 May, 2024 06:26 AM
29 May, 2024 02:38 AM
29 May, 2024 12:43 AM
28 May, 2024 11:59 PM