Re: [GNC] Bank reconciliation after messy migration

2023-01-06 Thread David H
This, with one minor change - If you're happy that everything is 100% just
reconcile up to your latest statement closing balance and date.  Ignore the
Gnucash generated starting balance because when all said and done it's all
about the final closing balance.

Cheers David H.


On Sat, 7 Jan 2023 at 04:59, Fred Tydeman  wrote:

> Here is a fast way to Reconcile everything (not what you asked for, but it
> might help)
>
> Reconcile
>  "t" in Statement date == Today
>  Left click OK
>  Ctrl-A == Select All items in Funds In column
>  Space == Mark as Reconciled
>  Tab == Move to Funds Out column
>  Ctrl-A == Select All items in Funds Out column
>  Space == Mark as Reconciled
>  Left click Finish
>
> On Fri, Jan 6, 2023 at 10:08 AM Eric Hammond  wrote:
>
> >
> > I have finally completed replacing Quicken with GnuCash.
> > One of the casualties is my ability to reconcile my bank account.
> > The account covers from 2014 to present, and matches all bank statements
> > and balances properly.
> > The reconciliation function opens but starts at some random date and
> > incorrect beginning balance.
> > Is there a way to reset the reconciliation to all unreconciled  and start
> > fresh?
> >
> > Alternatively, can I repair this using NotePad++?  Which entries need to
> > be changed, and which ones should not be messed with?
> > (I am fine with a bit of slow tedious work)
> >
> > Thanks for all help,
> > Eric H.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Bank reconciliation after messy migration

2023-01-06 Thread David Carlson
There isn't an easy way to unreconcile many transactions,   but because
reconciliation dates aren't very easy to see or care about once they get
old, many users will ignore starting dates and balances if they know that
there is a reason that they don't match the bank statement this month.

One point to keep in mind is that reconciliations are only concerning the
split lines involving that account,  so, if for example there are
transactions that involve both a bank account and a credit card account,
ignore the 'other' side during the reconciliation.  Those transactions may
have dates that don't match both sides.

On Fri, Jan 6, 2023, 12:08 PM Eric Hammond  wrote:

>
> I have finally completed replacing Quicken with GnuCash.
> One of the casualties is my ability to reconcile my bank account.
> The account covers from 2014 to present, and matches all bank statements
> and balances properly.
> The reconciliation function opens but starts at some random date and
> incorrect beginning balance.
> Is there a way to reset the reconciliation to all unreconciled  and start
> fresh?
>
> Alternatively, can I repair this using NotePad++?  Which entries need to
> be changed, and which ones should not be messed with?
> (I am fine with a bit of slow tedious work)
>
> Thanks for all help,
> Eric H.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Bank reconciliation after messy migration

2023-01-06 Thread Fred Tydeman
Here is a fast way to Reconcile everything (not what you asked for, but it
might help)

Reconcile
 "t" in Statement date == Today
 Left click OK
 Ctrl-A == Select All items in Funds In column
 Space == Mark as Reconciled
 Tab == Move to Funds Out column
 Ctrl-A == Select All items in Funds Out column
 Space == Mark as Reconciled
 Left click Finish

On Fri, Jan 6, 2023 at 10:08 AM Eric Hammond  wrote:

>
> I have finally completed replacing Quicken with GnuCash.
> One of the casualties is my ability to reconcile my bank account.
> The account covers from 2014 to present, and matches all bank statements
> and balances properly.
> The reconciliation function opens but starts at some random date and
> incorrect beginning balance.
> Is there a way to reset the reconciliation to all unreconciled  and start
> fresh?
>
> Alternatively, can I repair this using NotePad++?  Which entries need to
> be changed, and which ones should not be messed with?
> (I am fine with a bit of slow tedious work)
>
> Thanks for all help,
> Eric H.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Bank reconciliation after messy migration

2023-01-06 Thread Eric Hammond

I have finally completed replacing Quicken with GnuCash.
One of the casualties is my ability to reconcile my bank account.
The account covers from 2014 to present, and matches all bank statements and 
balances properly.
The reconciliation function opens but starts at some random date and incorrect 
beginning balance.
Is there a way to reset the reconciliation to all unreconciled  and start fresh?

Alternatively, can I repair this using NotePad++?  Which entries need to be 
changed, and which ones should not be messed with?
(I am fine with a bit of slow tedious work)

Thanks for all help,
Eric H.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.