tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/137-first-reconcile-after-importing-quicken-dataInfinite Kind: Discussion 2021-10-18T14:20:37Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/2077122009-06-21T01:06:24Z2009-06-21T01:06:24Zfirst reconcile after importing quicken data<div><p>You can adjust the beginning balance via the "account menu"
-> edit account -> beginning balance.</p>
<p>Sincerely,</p>
<p>Brian Adler</p></div>Brian Adlertag:infinitekind.tenderapp.com,2009-01-14:Comment/2077122009-06-21T01:07:18Z2009-06-21T01:07:18Zfirst reconcile after importing quicken data<div><p>Hi</p>
<p>Click on an account to bring up the transaction register for
that account. Select Edit from the Account menu. From the resulting
window you can set the "initial Balance" for the account.</p>
<p>Sincerely</p>
<p>Ben Spencer</p></div>Ben Spencertag:infinitekind.tenderapp.com,2009-01-14:Comment/2077122009-06-21T01:07:36Z2009-06-21T01:07:36Zfirst reconcile after importing quicken data<div><p>"beginning balance" should actually be "initial balance"</p></div>Brian Adlertag:infinitekind.tenderapp.com,2009-01-14:Comment/2077122009-08-22T04:03:24Z2021-10-18T14:20:37Zfirst reconcile after importing quicken data<div><p>I imported my transactions from Mac Quicken 2007 beginning with 1/1/08. In the "Account Info: Wachovia" window I have the start date as 12/30/2007, Initial Balance as 2703.51 which was the balance I had on that date in Quicken.</p>
<p>After confirming two months worth of transactions I went to reconcile for the first time.<br>
The first time I tried to balance my checkbook I had a beginning of $-50,422.85. Where did that number come from? I have tried adjusting the balance in various ways but it messes up the register balance. Why can't I change it the beginning statement balance in the Reconcile Account box?</p>
<p>What do I do now? I have purchased MD and spent a considerable amount of time correcting entries that didn't import correctly.</p></div>Paul S.tag:infinitekind.tenderapp.com,2009-01-14:Comment/2077122009-08-22T16:32:28Z2021-10-18T14:20:37Zfirst reconcile after importing quicken data<div><p>Don't know why it posted 3x. Only clicked "Comment" button once.</p>
<p>I got it fixed after finally entering transactions that didn't make it from Quicken export and reconciling the entire account.</p>
<p>All is well! Or at least with that account!</p></div>Paul S.tag:infinitekind.tenderapp.com,2009-01-14:Comment/2077122009-08-23T14:53:02Z2009-08-23T14:53:02Zfirst reconcile after importing quicken data<div><p>Hi Paul</p>
<p>I am sorry for the inconvenience that you have experienced.</p>
<p>For reference the "beginning statement balance" when reconciling
is the sum of all of the transactions that are marked as cleared
plus the initial debt/balance. Such that if you want the "beginning
statement balance" when reconciling to be equal to your start debt
you should ensure that you do not have any transactions marked as
cleared on the account. You can do this by selcting all the
transactions with ctrl-A right click and select "Mark as
Uncleared"</p>
<p>Did the missing transactions have anything in common that might
have been the cause of them not being exported form quicken? I ask
such that I might be better able to assist users who experience a
similar problem.</p>
<p>Sincerely</p>
<p>Ben Spencer</p></div>Ben Spencertag:infinitekind.tenderapp.com,2009-01-14:Comment/2077122009-08-24T15:28:19Z2021-10-18T14:20:37Zfirst reconcile after importing quicken data<div><p>Ben,</p>
<p>I figured out the "beginning statement balance" problem after I<br>
entered all the missing transactions from checking.</p>
<p>Mac Quicken 2007 import:<br>
YES! There was a pattern to the missing transactions! Because I do<br>
online banking for all my bills 90% of my handwritten checks are to my<br>
church. In Quicken I had a category named "SJN" with the payee also as<br>
"SJN". When I set up MD I had the default category for assigning<br>
transactions to "SJN". NONE of my imported transactions with the<br>
category "SJN" came into MD. I tried importing account names only then<br>
the transactions but that didn't work either. Also, it seems as though<br>
many transactions that had a memo also got dropped in the import.<br>
Specifically a category called "Medical" with a sub-category called<br>
"Doctor". I had memos for each one of those which also didn't come in.<br>
That happened for other transactions that had a memo as well. All of<br>
the online banking transactions came in correctly with the proper<br>
category assigned and marked as cleared. The online banking<br>
transactions were the only ones that imported as cleared.</p>
<p>Other Macintosh notes:</p>
<p>The security price history could work better. I could enter historical<br>
prices for a particular security but I had to enter the current price<br>
manually to update my portfolio. It seems like MD should automatically<br>
use the last price historical price as the current price. Entering the<br>
current price for each security could be burdensome.</p>
<p>Related to investments. I also had entered a historical price for a<br>
security, entered that same price in the current price but when I went<br>
back to the home screen it showed a price from the previous month. I<br>
couldn't get it to update by reentering. It was only after quitting MD<br>
and reopening that the price was updated.</p>
<p>Attaching securities to investment accounts is awkward. If I have an<br>
IRA or any other investment account I shouldn't have to attach a<br>
security to the account before I make a transaction. I should be able<br>
to select from the security list while entering the transaction.</p>
<p>Thanks again for your assistance with the Wachovia problem. I'll see<br>
if I can play with MD a bit more as I found another bug where only the<br>
MD pulldown menu was visible. I had to close the account window by<br>
clicking the yellow button, clicking to the Finder then reopening the<br>
window to get the rest of the pulldown menus working.</p>
<p>Paul Scibona</p></div>Paul S.tag:infinitekind.tenderapp.com,2009-01-14:Comment/2077122009-08-24T16:00:45Z2009-08-24T16:00:45Zfirst reconcile after importing quicken data<div><p>Hi Paul</p>
<p>Thanks for the feedback. I am sorry Moneydance didn't meet your
needs.</p>
<p>Sincerely</p>
<p>Ben Spencer</p></div>Ben Spencertag:infinitekind.tenderapp.com,2009-01-14:Comment/2077122009-10-11T22:43:10Z2009-10-11T22:43:12Zfirst reconcile after importing quicken data<div><p>I imported an 11 MB file from Mac Quicken 2007 with transactions
dating back to 1993 into MD and experienced the same problem with
my first attempt to reconcile a checking account. The Beginning
Statement Balance came up as -$46665.26, despite the fact that the
register matched the Quicken register entries. After reading the
comments in this discussion, I double-checked that all the
appropriate transactions had a green checkmark. In desperation, I
did a cmd-A to select all transactions in the account,
right-clicked and selected "Mark as Uncleared". I then selected
all, right-clicked and selected "Mark as Cleared". I then selected
the small number of transactions that were uncleared in the
transfer from Quicken and marked them uncleared. Cmd-B then gave
the correct Beginning Statement Balance for reconciling.</p></div>wgbreil_sandia