Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
fixing a reconcile offset
37 views
Skip to first unread message
Bernie Cosell
Dec 24, 2021, 10:52:21 AM12/24/21
to
I reconciled my checking account and the register balances perfectly BUT my
balance in the register is off by a few thousands dollars. In the
reconcile window I see a bunch of [very old!!] transactions that exactly
make up the "missing" money. They are all "not cleared" and I am prepared
to declare them null and void [I'm about to close that checking account!]
what's the cleanest/easiest way to get my register's "final" total to agree
with the actual balance in my account [so that when I close it with a
cashier's check, its balance will be zero].
/Bernie\
--
Bernie Cosell Fantasy Farm Fibers
ber...@fantasyfarm.com Pearisburg, VA
--> Too many people, too few sheep <--
balance in the register is off by a few thousands dollars. In the
reconcile window I see a bunch of [very old!!] transactions that exactly
make up the "missing" money. They are all "not cleared" and I am prepared
to declare them null and void [I'm about to close that checking account!]
what's the cleanest/easiest way to get my register's "final" total to agree
with the actual balance in my account [so that when I close it with a
cashier's check, its balance will be zero].
/Bernie\
--
Bernie Cosell Fantasy Farm Fibers
ber...@fantasyfarm.com Pearisburg, VA
--> Too many people, too few sheep <--
Andrew
Dec 24, 2021, 1:08:18 PM12/24/21
to
On 12/24/21 10:52 AM, Bernie Cosell wrote:
> I reconciled my checking account and the register balances perfectly BUT my
> balance in the register is off by a few thousands dollars. In the
> reconcile window I see a bunch of [very old!!] transactions that exactly
> make up the "missing" money. They are all "not cleared" and I am prepared
> to declare them null and void [I'm about to close that checking account!]
>
> what's the cleanest/easiest way to get my register's "final" total to agree
> with the actual balance in my account [so that when I close it with a
> cashier's check, its balance will be zero].
>
> /Bernie\
If you're really closing the account soon, why worry about it?
> I reconciled my checking account and the register balances perfectly BUT my
> balance in the register is off by a few thousands dollars. In the
> reconcile window I see a bunch of [very old!!] transactions that exactly
> make up the "missing" money. They are all "not cleared" and I am prepared
> to declare them null and void [I'm about to close that checking account!]
>
> what's the cleanest/easiest way to get my register's "final" total to agree
> with the actual balance in my account [so that when I close it with a
> cashier's check, its balance will be zero].
>
> /Bernie\
If not, and if I understand all these transactions were originally
reconciled in the account, why not simply mark them as CLEARED if you
are in the reconcile window, or manually mark the with a 'R' in your're
in the register.
As long as the balances really don't change (or better yet,align with
current reality), that's what I would do. Again, especially since
account is going to be closed shortly.--
-----------------------------------------------------------
Regards -
- Andrew
Marc Auslander
Dec 24, 2021, 4:08:04 PM12/24/21
to
To belabor the obvious - make a copy of your qdf file first
before you experiment.
before you experiment.
Taxed and Spent
Dec 25, 2021, 6:35:07 AM12/25/21
to
On 12/24/2021 7:52 AM, Bernie Cosell wrote:
> I reconciled my checking account and the register balances perfectly BUT my
> balance in the register is off by a few thousands dollars. In the
> reconcile window I see a bunch of [very old!!] transactions that exactly
> make up the "missing" money. They are all "not cleared" and I am prepared
> to declare them null and void [I'm about to close that checking account!]
>
> what's the cleanest/easiest way to get my register's "final" total to agree
> with the actual balance in my account [so that when I close it with a
> cashier's check, its balance will be zero].
>
> /Bernie\
Have these old transactions cleared in reality, or did the payees never
> I reconciled my checking account and the register balances perfectly BUT my
> balance in the register is off by a few thousands dollars. In the
> reconcile window I see a bunch of [very old!!] transactions that exactly
> make up the "missing" money. They are all "not cleared" and I am prepared
> to declare them null and void [I'm about to close that checking account!]
>
> what's the cleanest/easiest way to get my register's "final" total to agree
> with the actual balance in my account [so that when I close it with a
> cashier's check, its balance will be zero].
>
> /Bernie\
deposit their checks, etc.?
Bernie Cosell
Dec 27, 2021, 7:20:51 PM12/27/21
to
Taxed and Spent <nospam...@nonospam.com> wrote:
} On 12/24/2021 7:52 AM, Bernie Cosell wrote:
} > I reconciled my checking account and the register balances perfectly BUT my
} > balance in the register is off by a few thousands dollars. In the
} > reconcile window I see a bunch of [very old!!] transactions that exactly
} > make up the "missing" money. They are all "not cleared" and I am prepared
} > to declare them null and void [I'm about to close that checking account!]
}
} On 12/24/2021 7:52 AM, Bernie Cosell wrote:
} > I reconciled my checking account and the register balances perfectly BUT my
} > balance in the register is off by a few thousands dollars. In the
} > reconcile window I see a bunch of [very old!!] transactions that exactly
} > make up the "missing" money. They are all "not cleared" and I am prepared
} > to declare them null and void [I'm about to close that checking account!]
}
} Have these old transactions cleared in reality, or did the payees never
} deposit their checks, etc.?
The checks have never been deposited -- I can double check but I'm pretty
} deposit their checks, etc.?
sure they're not duplicate register entries for already-cashed checks.
Quicken is still deducting their amount from my final balance. I'm
wondering if it is as easy as changing their amount to "zero" to make the
Quicken balance agree with the bank's balance...
Taxed and Spent
Dec 28, 2021, 4:11:00 PM12/28/21
to
On 12/27/2021 4:20 PM, Bernie Cosell wrote:
> Taxed and Spent <nospam...@nonospam.com> wrote:
>
> } On 12/24/2021 7:52 AM, Bernie Cosell wrote:
> } > I reconciled my checking account and the register balances perfectly BUT my
> } > balance in the register is off by a few thousands dollars. In the
> } > reconcile window I see a bunch of [very old!!] transactions that exactly
> } > make up the "missing" money. They are all "not cleared" and I am prepared
> } > to declare them null and void [I'm about to close that checking account!]
> }
> } Have these old transactions cleared in reality, or did the payees never
> } deposit their checks, etc.?
>
> The checks have never been deposited -- I can double check but I'm pretty
> sure they're not duplicate register entries for already-cashed checks.
> Quicken is still deducting their amount from my final balance. I'm
> wondering if it is as easy as changing their amount to "zero" to make the
> Quicken balance agree with the bank's balance...
>
> /Bernie\
I would not change their values to zero. I would make an offsetting
> Taxed and Spent <nospam...@nonospam.com> wrote:
>
> } On 12/24/2021 7:52 AM, Bernie Cosell wrote:
> } > I reconciled my checking account and the register balances perfectly BUT my
> } > balance in the register is off by a few thousands dollars. In the
> } > reconcile window I see a bunch of [very old!!] transactions that exactly
> } > make up the "missing" money. They are all "not cleared" and I am prepared
> } > to declare them null and void [I'm about to close that checking account!]
> }
> } Have these old transactions cleared in reality, or did the payees never
> } deposit their checks, etc.?
>
> The checks have never been deposited -- I can double check but I'm pretty
> sure they're not duplicate register entries for already-cashed checks.
> Quicken is still deducting their amount from my final balance. I'm
> wondering if it is as easy as changing their amount to "zero" to make the
> Quicken balance agree with the bank's balance...
>
> /Bernie\
transaction for each, probably with today's date, and clearly
referencing the original transaction. Then, reconcile and mark the
original and the offsetting transactions are cleared.
And, most important of all, since the checks never were deposited, the
money is still in your bank account, right?
Arthur Conan Doyle
Dec 29, 2021, 9:50:57 AM12/29/21
to
months old. Whether someone actually looks at the check to validate that at the
depositing bank or paying bank is an open question, but I have seen checks
returned for that reason.
How they get accounted for in Quicken is flexible. In addition to the suggestion
above, you could set the amount to zero, then add a note indicating the original
amount, not paid and mark the transaction as cleared.
--
Usenet: The world's first (and best) social network.
G. Salisbury
Dec 29, 2021, 10:11:36 AM12/29/21
to
John Pollard
Dec 29, 2021, 11:35:33 AM12/29/21
to
On Wednesday, December 29, 2021 at 9:11:36 AM UTC-6, G. Salisbury wrote:
> Can also just right-click and select void.
True.
> Can also just right-click and select void.
But Quicken's void process does not save the original amount anywhere; and that amount can be useful, if ever researching why a transaction was voided. Personally, I like to see Quicken improved its void process to retain more of the original transaction.
To deal with the Quicken void limitation, the previous suggestion to "... add a note indicating the original amount ...." was good advice I think.
And I believe that creating a permanent backup before making any of the changes contemplated for the original problem, would also be a good idea.
Taxed and Spent
Dec 29, 2021, 1:58:00 PM12/29/21
to
purposes, an offsetting entry would be the better way to go.
0 new messages