Home → Problems →

"As of" field missing from reconciliation window

• Edit

NGA

05 Dec, 2009 04:43 AM

When I reconcile my accounts, there is usually an "as of" field next to where I enter the statement account balance. One of my accounts does not have this, and I believe it is preventing me from getting the "difference" value to zero. My beginning balance is correct, and all selected transactions are accounted for on the statement.

What would cause this and how do I correct?

Thanks

1. 1 Posted by Ben Spencer on 05 Dec, 2009 11:51 AM

   

   Hi NGA

   The "as of" field is set to the date of the last downloaded OFX transaction
   and the balance is set to the ending balance from the last OFX download. If you are not directly downloading transactions into an account then I do not belive you will be presented with an "as of" filed. Only a beginning balance and ending balance fields. The beginning balance will be the balance of all reconciled transactions and you should set the ending balance your self to the end balance of your statement.
   

   Sincerely

   Ben Spencer

   • Edit

2. 2 Posted by NGA on 05 Dec, 2009 04:01 PM

   

   Thanks for the timely reply Ben,

   Maybe I have something else going on then, because I have another account, also of type "Bank" from which I have never downloaded OFX transactions either, and it does offer the "as of" field during reconcile. [It's an old checking account with a different bank]

   Another noteworthy item is that recently, I had entered a Reminder transaction by mistake, and tried to use "Undo New Transaction" in the Edit menu to correct, but it didn't appear to have done anything. Could it have undone a transaction only in the "other side" register causing the Current Balance value in the reconciliation tool to be calculated incorrectly? Is there a way to view transactions with their matched "other side" transactions to confirm amounts, and that none are missing?

   • Edit

3. 3 Posted by Ben Spencer on 20 Jan, 2010 05:02 PM

   

   The as of field is also present if you have ever imported transaction into the accou t fomr a file and on the import window you specified that the file was "downloaded form a bank".

   On your second point it is not possible for only one side of a transaction to be deleted. And it is impossible for the two sides not to be in balance as the value on one side is calculated by looking at the other side. i.e. the value is only actually stored in one place.

   I am sorry I have not responded sooner, we have been quite a bit busier than usual and I am afraid some cases got burried at the bottom of the pile.

   Sincerely

   Ben Spencer
   

   • Edit

4. Angie Rauscher closed this discussion on 24 Jul, 2011 07:18 PM.