Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
 
Old 07-01-2004, 01:23 PM
Andy Nestor
Guest
 
Posts: n/a
Default Re: Starting balance discrepancy?

When you balance (I'll use reconcile from now on for clarity) your account, the starting balance should be either:
- the closing balance of the last statement
- if you've never reconciled before then it would equal the starting balance you specified when you created the account in Money. In this case the starting balance you enter in the "Balance (reconcile) this account" wizard may be different from what the bank reports on the statement.

The opening and closing dates should be the same as those shown on the statement. The closing date is NOT today!

As is true with manually reconciling your account in a check register, the current balance in the register will (usually) not agree with the balance that the bank has. This is because you bank is not aware of any checks, debits or even deposits that haven't cleared the bank yet.

I'm not sure if this helps but I thought I would mention it.

Andy Nestor

"Charles Blaquière" <blaq[at]blaqzone.com> wrote in message news:u3snuxvXEHA.1144[at]TK2MSFTNGP10.phx.gbl...
- quote -

> Disclaimers: I'm brand new at using MSM. I've searched throughout help
> files, the Web and newsgroups with no success.
> __________
> PROBLEM
> When I use the "Balance this account" wizard and enter the information from
> a paper bank statement, I get the dreaded "Starting balance discrepancy"
> error, even though all transactions seem to be entered and all balances
> reported by Money match those from my bank.
> __________
> BACKGROUND
> In various batches (i.e. not in order), I've downloaded transactions for my
> checking account, from Feb. 16 to today. (The paper statement from which
> I've decided to start managing, at first, covers Feb. 13 - Mar. 12.) The
> statement includes the following info:
> Starting balance on Feb. 13 ($2,980.23) --This matches the first
> transaction in Money (before txn amount was deducted).
> Ending balance on Mar. 10 (3,424.20) --This matches the balance on
> the last transaction's entry in Money.
> I've made sure that all transactions from Feb. 12 to today are in Money,
> marked accepted and reconciled. There are no extra transactions, either
> inside Money or on my paper statements -- everything matches one-to-one.
> Using the "View: all transactions", I made sure no transaction was entered
> twice. In the Checking account register screen, I see:
> (left margin)
> Downloaded:
> 6/30/2004 at 12:00 AM
> Balance: ($1,816.62) --This is the correct balance, as reported on my
> bank Web site (I did a fresh download)
> (bottom of account register)
> Today's Balance: ($1,792.22) Ending Balance: ($1,792.22)
> --These match the bank balance; I just spent $24.40 in groceries (debit
> card), which the bank includes in its displayed (and downloaded) balance,
> but the transaction is not included in the latest download file.
> BALANCE THIS ACCOUNT
> In the "Balance this account" wizard, I enter the following:
> Statement date: 3/12/2004
> Starting balance: ($2,980.23)
> Ending balance: ($3,424.20)
> No service charge or interest earned (these are included in the
> downloaded transactions)
> Clicking Next gives me the "Starting balance discrepancy" error. Clicking
> Next displays, in the left margin:
> The difference between your statement and register is: 443.97
> __________
> I don't understand why Money refuses to balance the account, if the
> displayed balances match those from the bank. Thanks for your help.

  #-1  
Old 06-30-2004, 11:49 PM
Charles Blaquière
Guest
 
Posts: n/a
Default Starting balance discrepancy?

Disclaimers: I'm brand new at using MSM. I've searched throughout help
files, the Web and newsgroups with no success.
__________

PROBLEM

When I use the "Balance this account" wizard and enter the information from
a paper bank statement, I get the dreaded "Starting balance discrepancy"
error, even though all transactions seem to be entered and all balances
reported by Money match those from my bank.
__________

BACKGROUND

In various batches (i.e. not in order), I've downloaded transactions for my
checking account, from Feb. 16 to today. (The paper statement from which
I've decided to start managing, at first, covers Feb. 13 - Mar. 12.) The
statement includes the following info:

Starting balance on Feb. 13 ($2,980.23) --This matches the first
transaction in Money (before txn amount was deducted).
Ending balance on Mar. 10 (3,424.20) --This matches the balance on
the last transaction's entry in Money.

I've made sure that all transactions from Feb. 12 to today are in Money,
marked accepted and reconciled. There are no extra transactions, either
inside Money or on my paper statements -- everything matches one-to-one.
Using the "View: all transactions", I made sure no transaction was entered
twice. In the Checking account register screen, I see:

(left margin)
Downloaded:
6/30/2004 at 12:00 AM
Balance: ($1,816.62) --This is the correct balance, as reported on my
bank Web site (I did a fresh download)

(bottom of account register)
Today's Balance: ($1,792.22) Ending Balance: ($1,792.22)
--These match the bank balance; I just spent $24.40 in groceries (debit
card), which the bank includes in its displayed (and downloaded) balance,
but the transaction is not included in the latest download file.

BALANCE THIS ACCOUNT

In the "Balance this account" wizard, I enter the following:

Statement date: 3/12/2004
Starting balance: ($2,980.23)
Ending balance: ($3,424.20)
No service charge or interest earned (these are included in the
downloaded transactions)

Clicking Next gives me the "Starting balance discrepancy" error. Clicking
Next displays, in the left margin:

The difference between your statement and register is: 443.97
__________

I don't understand why Money refuses to balance the account, if the
displayed balances match those from the bank. Thanks for your help.


 

Tags
balance, discrepancy, starting
Similar Threads
Thread Forum Replies Last Post
Bank Reconciling Starting Balance Discrepancy
Elva: Ok, here's the problem...I got a new computer and started using Money on it last month. I reconciled the bank statement and everything was fine. ...
Microsoft Money 1 01-13-2004 01:10 AM
discrepancy in opening balance
Ricardo M. Costa: I have Money 99 on XP. Just a few days ago I had everything entered and balanced without a hitch, but then a mistake was made, and I re-entered...
Microsoft Money 4 01-09-2004 02:42 PM
"The Starting balance entered ... does not match the starting balance calculated
Alex Sidline: Searched faqs and recent posting without success. I am trying to balance a new checking account with Microsoft Money 2004, windows XP. My...
Microsoft Money 7 10-18-2003 03:32 PM
Help! -discrepancy in starting balance
John: Can someone pls. help me here? I have been working to try and resolve this starting balance issue with no luck. I have been able to reconcile the...
Microsoft Money 2 10-04-2003 06:17 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 05:44 AM.