Discrepancy in displayed balances

The Cappuccino Kid · Joined: 05 Jan 2008 Posts: 3

Hi,

I'm using the UK version of Money, version 14.0.120.1105.

For a couple of weeks the 'All Transactions' option has shown a
different ending balance from the 'Unreconciled Transactions'. The
first one is correct. The difference is £136.97.

I have traced this to two transactions which were scheduled to take
place, but didn't, on the 16th December. The only place I can see the
transactions is the QIF export file - I cannot see them on anything in
Money.

Can anyone advise how I can get rid?

Thanks,

Archived from group: microsoft>public>uk>money

Cal Learner · Joined: 02 Aug 2007 Posts: 534

In microsoft.public.uk.money, The Cappuccino Kid wrote:

>
>
>I'm using the UK version of Money, version 14.0.120.1105.
>
>For a couple of weeks the 'All Transactions' option has shown a
>different ending balance from the 'Unreconciled Transactions'. The
>first one is correct. The difference is £136.97.
>
>I have traced this to two transactions which were scheduled to take
>place, but didn't, on the 16th December. The only place I can see the
>transactions is the QIF export file - I cannot see them on anything in
>Money.
>
>Can anyone advise how I can get rid?

See http://support.microsoft.com/kb/838713

Since your register gives a different balance when
the view is changed to show only unreconciled transactions or
in some other way, then expect to make it to method 3.

You could shortcut step 3-5 by only deleting transactions in the
copy that post-date where you are sure you did not have the
problem.

Then in step 3-9, delete the entries that cover the dates that you
did not delete the transactions for.

I suspect the problem transactions involved scheduled transactions,
and maybe those were matched to downloaded transactions. Let us
know.

The Cappuccino Kid · Joined: 05 Jan 2008 Posts: 3

>
> Seehttp://support.microsoft.com/kb/838713
>
> Since your register gives a different balance when
> the view is changed to show only unreconciled transactions or
> in some other way, then expect to make it to method 3.
>
> You could shortcut step 3-5 by only deleting transactions in the
> copy that post-date where you are sure you did not have the
> problem.
>
> Then in step 3-9, delete the entries that cover the dates that you
> did not delete the transactions for.
>
> I suspect the problem transactions involved scheduled transactions,
> and maybe those were matched to downloaded transactions. Let us
> know.

I've tried this ...

Backed up and opened file.
Exported the account as Loose QIF.If I edit the file I can see the two
transactions that I want shot of - both dated 16th December.
Deleted all transactions from the Money file after 14th December. The
discrepancy still exists.

The only thing I can think of is to delete all transactions and import
the file but I am concerned that I would lose reconciliation data -
and there are several transfers between accounts. It would also take
some time as my data goes back to 2003.

Thoughts anyone?

Thanks

Cal Learner · Joined: 02 Aug 2007 Posts: 534

In microsoft.public.uk.money, The Cappuccino Kid wrote:

>>
>> Seehttp://support.microsoft.com/kb/838713
>>
>> Since your register gives a different balance when
>> the view is changed to show only unreconciled transactions or
>> in some other way, then expect to make it to method 3.
>>
>> You could shortcut step 3-5 by only deleting transactions in the
>> copy that post-date where you are sure you did not have the
>> problem.
>>
>> Then in step 3-9, delete the entries that cover the dates that you
>> did not delete the transactions for.
>>
>> I suspect the problem transactions involved scheduled transactions,
>> and maybe those were matched to downloaded transactions. Let us
>> know.
>
>I've tried this ...
>
>Backed up and opened file.
>Exported the account as Loose QIF.If I edit the file I can see the two
>transactions that I want shot of - both dated 16th December.
>Deleted all transactions from the Money file after 14th December. The
>discrepancy still exists.

Did you then edit a QIF file with those transactions, File->Import
as a statement and try to match to the hidden transactions?

>
>The only thing I can think of is to delete all transactions and import
>the file but I am concerned that I would lose reconciliation data -
>and there are several transfers between accounts. It would also take
>some time as my data goes back to 2003.

>
>Thoughts anyone?

Also, see if you can see the hidden transactions in a report and try
to make them visible by editing somehow.
>
>Thanks

teabag · Joined: 02 Aug 2007 Posts: 93

In what 'Year' (in the loose QIF file) are the two rogue transactions dated
16th December?
Money gets confused if you accidentally / unintentionally put in a year like
3007 for example.

teabag

"The Cappuccino Kid" wrote in message @f47g2000hsd.googlegroups.com...
> >
>> Seehttp://support.microsoft.com/kb/838713
>>
>> Since your register gives a different balance when
>> the view is changed to show only unreconciled transactions or
>> in some other way, then expect to make it to method 3.
>>
>> You could shortcut step 3-5 by only deleting transactions in the
>> copy that post-date where you are sure you did not have the
>> problem.
>>
>> Then in step 3-9, delete the entries that cover the dates that you
>> did not delete the transactions for.
>>
>> I suspect the problem transactions involved scheduled transactions,
>> and maybe those were matched to downloaded transactions. Let us
>> know.
>
> I've tried this ...
>
> Backed up and opened file.
> Exported the account as Loose QIF.If I edit the file I can see the two
> transactions that I want shot of - both dated 16th December.
> Deleted all transactions from the Money file after 14th December. The
> discrepancy still exists.
>
> The only thing I can think of is to delete all transactions and import
> the file but I am concerned that I would lose reconciliation data -
> and there are several transfers between accounts. It would also take
> some time as my data goes back to 2003.
>
> Thoughts anyone?
>
> Thanks
>

The Cappuccino Kid · Joined: 05 Jan 2008 Posts: 3

OK, I've cracked it.

I also use Money for Pocket PC on my iPaq. I trawled through the
transactions on there and found the two entires on the iPaq. I deleted
them and synced - all OK.

Thanks to everyone for their input.

mortgage repayment discrepancy?? How comes figures I have been quoted by a mortgage lender differs from the numbers money calculates. For example a 120,000 pound mortgage, over 25 years @ 4.09% works out at 638.78 pounds / month. When the same figures are entered into money, the monthly

Discrepancy when reconciling with statement I recently upgraded to MSMoney2004, and am encountering a problem whenever I try to reconcile my bank statements. The register of transactions seems to match my statements, but when I reconcile the starting balance that appears is £3.02 out. MSMoney's hel

discrepancy between report and account details if i look at my current account for the current month only, it implies a wrong opening balance, i.e. all the values in the balance column are wrong by a number i don't recognise. if i then look at 'all dates', the starting balance from last month is now c

Downloaded Statements aren't displayed Hi, I downloaded statements from both my bank (HSBC) and credit card (Alliance & Leicester) and neither seem to be imported properly. When I view my accounts, each account says 'Transactions to read 94' or whatever but when I click on the account nothing

Money Pocket PC - Accounts Displayed Hi, I have Money 2004 and have downloaded Money for Pocket PC 2004. Unfortunately a couple of my important accounts do not show up on the accounts register. The note on the Active Sync Money tab says that "only those account types that can also syncronize