MoneyManagerEX_SVN-3085 - Major mistake in Un-Reconciled

45 posts
Re: MoneyManagerEX_SVN-3085 - Major mistake in Un-Reconciled

jamie
New MMEX User

Posts: 16
Joined: Sun Feb 19, 2012 7:06 am
stef145g wrote:What is the verdict?


My preference is for the balance column to be recalculated in the filter views. The benefit is that the filtered balance more accurately forecasts the actual balance in the account (i.e. the bank's balance) without having to change the transaction dates of cleared transactions to match the bank's cleared date. I can keep the transaction dates as the bill due dates.

My standard way of working is to show unreconciled transactions only, to keep the transaction dates as the actual due dates, and to reconcile frequently. Under this scenario, recalculating the transaction balance is very beneficial and is my choice for the way to go.
Re: MoneyManagerEX_SVN-3085 - Major mistake in Un-Reconciled
User avatar
stef145g
MMEX Developer

Posts: 278
Joined: Fri Aug 13, 2010 9:40 pm
Location: Canberra, Australia
jamie wrote:My preference is for the balance column to be recalculated in the filter views.
Which filter?

Note: The changes that I made are this:
    Using the Transacton Filter
    No recalculation of balances.
    Using the View Reconciled/Unreconciled/All except Reconciled.
    Balances are recalculated to new screen.
Regards: Stefano
Re: MoneyManagerEX_SVN-3085 - Major mistake in Un-Reconciled

jamie
New MMEX User

Posts: 16
Joined: Sun Feb 19, 2012 7:06 am
stef145g wrote:
jamie wrote:My preference is for the balance column to be recalculated in the filter views.
Which filter?

Note: The changes that I made are this:
    Using the Transacton Filter
    No recalculation of balances.
    Using the View Reconciled/Unreconciled/All except Reconciled.
    Balances are recalculated to new screen.


Exactly how you summarized it.
Re: MoneyManagerEX_SVN-3085 - Major mistake in Un-Reconciled

GregChapman
Super MMEX User

Posts: 91
Joined: Fri Jun 29, 2012 6:24 am
Location: Norfolk Broads, UK
And that doesn't affect my way of working so I have no problems with it.
Greg Chapman
Re: MoneyManagerEX_SVN-3085 - Major mistake in Un-Reconciled
User avatar
stef145g
MMEX Developer

Posts: 278
Joined: Fri Aug 13, 2010 9:40 pm
Location: Canberra, Australia
I have been trying to get something clear in my own mind about the View Reconciled/Unreconciled views. To test the correctness of what I have done, I have created a spreadsheet and a database, then compared it with the results from mmex 0.9.8.0. With the un-reconciled view, I am getting different results.

Obviously not understanding the problem, can't explain why. I have also attached the files.
What am I doing wrong?
Attachments
Ledger_Test.zip
Contains Ledger_test.mmb and Ledger_test.odt (Spreadsheet)
(14.13 KiB) Downloaded 238 times
Regards: Stefano
Re: MoneyManagerEX_SVN-3085 - Major mistake in Un-Reconciled

jamie
New MMEX User

Posts: 16
Joined: Sun Feb 19, 2012 7:06 am
Your worksheet labeled "Unreconciled View Ledger" is missing a 50 in the withdraw column of row 4, the transaction that is dated 11/3/2012. If you add the 50, the "Unreconciled View Ledger" balance and the "Reconciled View Ledger" balance will equal the "General Ledger Example" balance.

-80 + 260 = 180

I'm not sure if this answers your question or not.

By the way, the "Displayed Bal" at the top of the account register is not needed when one is viewing all except reconciled. The Displayed balance will always equal the Diff.
Re: MoneyManagerEX_SVN-3085 - Major mistake in Un-Reconciled
User avatar
stef145g
MMEX Developer

Posts: 278
Joined: Fri Aug 13, 2010 9:40 pm
Location: Canberra, Australia
I did not spot this, but this is not the issue.
The Flagged transaction caused that mistake, as I did this at the last minute to test all-except reconciled.

Fixing this in the spreadsheet and removing the flagged transaction, when I compare the screens of 0.9.8.0 and 9.9.9.0_dev_3127 to view the View Un_reconciled, I have just now discovered that in 0.9.8.0, the balances have been increased by the value of the Reconciled Balance for View Unreconciled but not for All Except Reconciled.
Regards: Stefano
Re: MoneyManagerEX_SVN-3085 - Major mistake in Un-Reconciled

jamie
New MMEX User

Posts: 16
Joined: Sun Feb 19, 2012 7:06 am
I have been experimenting with the drop down list that includes View Last 30 days, View Last 90 days, and View Last 3 Months. All of these views exclude future transactions that are beyond the current month. If today is in month x and I have future transactions in the register that occur x+1, all of these views exclude the x+1 transactions. Thinking about it, it may be more appropriate to base the View Last 30 days or 90 days off of the date of the last transaction in the register rather than today's date. I'm not sure what to think about the View Last 3 Months, as that seems very similar in name to View Last 90 days. This view currently looks includes all transactions to the end of month x whereas View Last 90 days excludes all transactions beyond today. Maybe View Last 3 Months could be x-3, x-2, and x-1 transactions.
Re: MoneyManagerEX_SVN-3085 - Major mistake in Un-Reconciled

Nikolay
MMEX Developer

Posts: 2284
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
there is a parameter "ignore future transactions". It may be used for that filter. Now it does not used.
Re: MoneyManagerEX_SVN-3085 - Major mistake in Un-Reconciled
User avatar
stef145g
MMEX Developer

Posts: 278
Joined: Fri Aug 13, 2010 9:40 pm
Location: Canberra, Australia
jamie wrote: I'm not sure what to think about the View Last 3 Months, as that seems very similar in name to View Last 90 days.
To answer the question:

    View Last 3 Months: Displays the dates within the last 3 months, based today's date month.
    If today's date is the 11th November, the start date is: 1st September
    View Last 90 Days: Displays the dates within the last 90 Days, based today's date day.
    If today's date is the 11th November: start date is: 13th August
The reference point for these views is today, as the title suggests.

Current Month, Last Month and Last 30 Days - A similar thing aplies.

Ignore Future Transaction status, refers to calculations, therefore Future transactions are not displayed in these views.
Regards: Stefano
Who is online

Users browsing this forum: No registered users and 2 guests

cron