Error in Balances

[Eddietheone]

Can you point me towards where I can find the Status Option as I cannot see it.

Click on the Status column header to sort by that column (note the arrow which shows whether the sort is ascending/descending).

Sort.png

This will group all the transactions of each Status together and allow you to scroll to find any that aren't Reconciled.
Don't forget to return to sort by Date afterwards.


Alternatively, you can choose to display only the non-Reconciled transactions by filtering:

Filter.png

Thanks Martin found now. I had that column set too narrow so the word was not visible. So no wonder I couldn't see it. I do in fact scroll to check that the "R" is there when checking my reconciled status etc. Cheers Edward

[Eddietheone]

OK now to clarify hopefully I do not use any filters at all. View all transactions is selected always. I am not sorting the entries in any order at all ever.

I just enter the items as required and reconcile them when they are recorded by my bank etc. It has worked fine like that up to this year. Suddenly I was looking for odd amounts because they did not balance.

So I have now edited all the accounts so the balances of the reconciled amounts now agree with the various financial institutions and will keep a close eye on this going forward. The strange balances back in various accounts will stay as they are for now. If there is a problem it will arise again as I am not changing the way I am using the program.

Just for everyones information the account that changed the balance by 1000.00 is now right. I deleted it and re-entered it and it changed the balance by 100.00 this time. I deleted it and entered it again and it changed it by 10.00 and a final delete and re-entry changed it to what it should have been (-1.00 ) finally.

I do transfer payments from accounts to other accounts and I do wonder if that is where the issue is.

If anyone knows of anything I could be doing wrong I would appreciate any help as I do like this prog and would be dissapointed to have to bin it but it is going to be under careful scrutiny now as I feel it is suspect and I will post back here with updates. Thank you everyone for your help I am very grateful for your assistance. Cheers Edward

[MartinArmstrong]

I am not sorting the entries in any order at all ever.

The transaction list is always sorted. You click on the column header to change what it is sorted by.

As you have been advised when you had this problem before, and again this time, you need to ensure the transactions are sorted by Date.

See the arrow next to the Date in the column header and the informative text just above.

Sort.png (69.21 KiB) Viewed 43800 times

It has worked fine like that up to this year. Suddenly I was looking for odd amounts because they did not balance.

You will have accidentally clicked on a different column heading so that the transactions were sorted by something other than Date. It's exactly as happened when you reported this problem previously in June 2020. As you can see below, that time you had accidentally sorted by the Number column (see the arrow).

Edward sort.png (102.45 KiB) Viewed 43800 times

I .. will keep a close eye on this going forward.

Great. Just make sure your transactions are sorted by Date.

I am not changing the way I am using the program.

There's no need to. Just keep the transactions sorted by Date.

I do transfer payments from accounts to other accounts and I do wonder if that is where the issue is.

No. It's not that.

If anyone knows of anything I could be doing wrong I would appreciate any help

You are accidentally clicking on the header and sorting by another column and not noticing.
Keep the transactions sorted by Date.

as I do like this prog and would be disappointed to have to bin it but it is going to be under careful scrutiny now as I feel it is suspect

Honestly, MMEX is working correctly. Just make sure the transactions are sorted by Date.

I hope that's clear now.

[Eddietheone]

My first update on this saga since really really keeping an eye on things as promised.

I have archived off some old records to thin the database a bit just in case they were causing some of the errors.

All of the accounts now seem to be working as they should be (02/07/23) except for one. This account has a reconciled balance of 3339.06 at the top and an account balance of 195.60 which is not correct. The difference is shown as 3534.66 which is correct relating to the first two numbers.
The balance in the Balance column is correct at 220.17 matching my bank statement.

I have been back over the previous entries in this account and there are no typos or wrong entries that could account for this so it remains a mystery.

I am tempted to delete this account completely and then recover the entries from the deleted folder to see if it then displays correctly or not. Not sure if it is a good idea but if I do then results in the next update.

The reconciled balances etc are matching the balance columns in the other accounts as they should where entries are reconciled.
OK thats it for the moment. Cheers Edward

[MartinArmstrong]

All of the accounts now seem to be working as they should be (02/07/23) except for one. This account has a reconciled balance of 3339.06 at the top and an account balance of 195.60 which is not correct. The difference is shown as 3534.66 which is correct relating to the first two numbers.
The balance in the Balance column is correct at 220.17 matching my bank statement.

Could you please post a screenshot of the incorrect account showing the balances at the top plus a couple of transactions.

[Renato]

From my point of view, an alternative would be to rename the file mmexini.db3 to mmexini.db3x
start MMEX, select the xxx.mmb and then set up the master data again.

[MartinArmstrong]

From my point of view, an alternative would be to rename the file mmexini.db3 to mmexini.db3x
start MMEX, select the xxx.mmb and then set up the master data again.

Yes, that's a possible course of action. However, it doesn't help us get to the root of the problem, if that is within MMEX itself.

Even if @Eddietheone decides to do that, I'd appreciate first seeing a screenshot of the incorrect account showing the balances at the top plus a couple of transactions.

[Renato]

It would be even easier if we were provided with the .mmb and the .db3 file. This would surely allow us to find the error.
You can send me such files to the address mmex-reg@bluewin.ch, of course I guarantee the necessary confidentiality.

[Renato]

Question: is there a loan account, could that be the difference?

[Eddietheone]

Update no 2

Well all is now well it seems with the program. In preparation for deleting the account I mentioned in the first update I checked the deleted section and decided to clear that completely before I proceded.

I did that and returned to the account I was going to clear and lo and behold all the figures were now correct. All the odd subtractions that were wrong were gone as well. So clearly something in the deleted column was causing some effect(s) in the other columns, I wish I had scrolled through the entire deleted column before I deleted it as it might have given me a chance to see what the issue was.

So from that I conclude that there must be something in the program that allows something to happen that shouldn't happen at least in the deleted column. From memory that deleted column could not have been very long as the only things I would have deleted would have been things that didn't happen ie purchases that did not arrive for example and there were few of them. So annoyed that I did not just scroll through that list.

But on the bright side it is all now working fine. I will be watching it like a hawk from now on though and any further weird things happening I will pick them up straight away I hope. As I said before I quite like the prog and don't really want to move but I do not at this moment trust it as I should and I hope that time will repair that trust with no more weird entries and I will post back here if that happens.

Many thanks again to everyone for their imput. It is nice to know others are there to try and help with issues. Cheers Edward