Re: [GNC] Redo account reconciliations

[David Carlson]

Updating the program should not, by itself, change any current account
balances in particular, nor, I would expect, any reconciled account
balances or reconcile dates of transactions.  Are you sure that the errors
that seem to have appeared are actually a result of the update?

If there is a new bug in the reconciliation process please try to describe
it in detail here.

Import formats are not being discussed in this thread.

On Sun, Sep 5, 2021 at 12:08 AM Jeff  wrote:

> On 9/4/21 1:16 PM, Derek Atkins wrote:
> > Exactly. But he had already reconciled to Aug 31, so need to use that
> > date.
> >
> > -derek
> > Sent using my mobile device. Please excuse any typos.
> > On September 4, 2021 11:09:12 AM john  wrote:
> >
> >> Oops, that'w wrong: You can't use the February statement's balance,
> >> you have to use the July statement balance (assuming that you haven't
> >> yet reconciled August) because the reconcile window doesn't know how
> >> to use xaccAccountGetReconciledBalanceAsOfDate.
> >>
> >> Regards,
> >> John Ralls
> >>
> >>> On Sep 4, 2021, at 7:59 AM, john  wrote:
> >>>
> >>> He said the February reconcile.
> >>>
> >>> So tell the reconcile info dialog 28 Feb and type in the balance
> >>> from the February statement as usual. Click OK. As long as you
> >>> haven't messed up anything else you'll be able to check the one
> >>> unreconciled split from February and the finish button and you're done.
> >>>
> >>> Regards,
> >>> John Ralls
> >>>
> >>>
>  On Sep 4, 2021, at 7:18 AM, Derek Atkins  wrote:
> 
>  Ah... But that's NOT how you are supposed to recover from that.
>  If you reconciled up for 31 Aug 2021, and you un-reconcile a
>  transaction,
>  it doesn't matter what date the transaction has -- you should
>  re-reconcile
>  31 August!  You just need to re-check the February transaction.
> 
>  -derek
> 
>  On Sat, September 4, 2021 9:10 am, Christopher Lam wrote:
> > Derek,
> > Consider a well-used bank account. You reconcile every end of the
> > month
> > successfully up to 31 Aug 2021.
> > Accidentally you unreconcile a Feb 2021 split.
> > You retrieve your 28 Feb 2021 bank statement, try to re-reconcile
> > and fail
> > because the reconciliation end balance also tallies splits from
> > March 2021
> > onwards.
> > C
> >
> > On Sat, 4 Sept 2021 at 13:01, Derek Atkins  wrote:
> >
> >> Chris,
> >>
> >> On Sat, September 4, 2021 8:36 am, Christopher Lam wrote:
> >>> I agree that if an account reconciliation is done periodically
> >> correctly
> >>> every time, then it works well. If an old reconciled split is
> >> unreconciled
> >>> and we need to re-reconcile a previous reconciliation date, then
> >>> the
> >> code
> >>> falls apart.
> >>
> >> I'm curious why you say it falls apart?
> >>
> >>> It may be an idea to allow batch unreconciliation of all splits
> >>> whose
> >>> reconcile date is after the reconciliation date in the
> >>> Reconciliation
> >>> dialog, thereby allowing the user to re-do reconciles.
> >>
> >> That could be a good idea.
> >>
> >> -derek
> >>
> >>> On Sat, 4 Sept 2021 at 06:34, Borden via gnucash-user <
> >>> gnucash-user@gnucash.org> wrote:
> >>>
> 
> 
> > The starting balance is computed from all the reconciled
> >> transactions
>  "to
> > date".  It *can* be safe to ignore the starting balance if, for
>  example,
>  a
> > transaction became unreconciled.  For example, let's say you
> >> reconcile
> > from some starting balance X to a final balance of $1000.
> > Then you
> > accidentally unreconcile a $100 transactions.  If you try to
>  re-reconcile
> > that same statement/date/ending-balance of $1000, it won't show X
> >> as
>  the
> > starting balance, but something else (PROBABLY $900, but I'm not
> >> 100%
> > sure).  But that's okay -- just ensure the ending balance is
> >> correct
>  and
> > all the transactions that SHOULD be reconciled ARE reconciled.
> >
> > There is no way to get a transaction to reconciled status (y)
> >> manually
>  --
> > the only way is through a reconcile process.  So if you have
>  reconciled
> > transactions, that must've happened through a reconcile.
> >
> > I would recommend you just go ahead with March, ignore the
> > starting
> > balance, enter the correct March ending balance, and see if the
> > reconciliation works (ensure you re-reconcile anything from
> > earlier
>  that
> > might have become unreconciled).
> >
>  So I just want to build a bit on this answer. GNUCash doesn't have
> >> QBs
>  reconciliation system - so 

Re: [GNC] Redo account reconciliations

[Jeff]

On 9/4/21 1:16 PM, Derek Atkins wrote:
Exactly. But he had already reconciled to Aug 31, so need to use that 
date.


-derek
Sent using my mobile device. Please excuse any typos.
On September 4, 2021 11:09:12 AM john  wrote:

Oops, that'w wrong: You can't use the February statement's balance, 
you have to use the July statement balance (assuming that you haven't 
yet reconciled August) because the reconcile window doesn't know how 
to use xaccAccountGetReconciledBalanceAsOfDate.


Regards,
John Ralls


On Sep 4, 2021, at 7:59 AM, john  wrote:

He said the February reconcile.

So tell the reconcile info dialog 28 Feb and type in the balance 
from the February statement as usual. Click OK. As long as you 
haven't messed up anything else you'll be able to check the one 
unreconciled split from February and the finish button and you're done.


Regards,
John Ralls



On Sep 4, 2021, at 7:18 AM, Derek Atkins  wrote:

Ah... But that's NOT how you are supposed to recover from that.
If you reconciled up for 31 Aug 2021, and you un-reconcile a 
transaction,
it doesn't matter what date the transaction has -- you should 
re-reconcile

31 August!  You just need to re-check the February transaction.

-derek

On Sat, September 4, 2021 9:10 am, Christopher Lam wrote:

Derek,
Consider a well-used bank account. You reconcile every end of the 
month

successfully up to 31 Aug 2021.
Accidentally you unreconcile a Feb 2021 split.
You retrieve your 28 Feb 2021 bank statement, try to re-reconcile 
and fail
because the reconciliation end balance also tallies splits from 
March 2021

onwards.
C

On Sat, 4 Sept 2021 at 13:01, Derek Atkins  wrote:


Chris,

On Sat, September 4, 2021 8:36 am, Christopher Lam wrote:

I agree that if an account reconciliation is done periodically

correctly

every time, then it works well. If an old reconciled split is

unreconciled
and we need to re-reconcile a previous reconciliation date, then 
the

code

falls apart.


I'm curious why you say it falls apart?

It may be an idea to allow batch unreconciliation of all splits 
whose
reconcile date is after the reconciliation date in the 
Reconciliation

dialog, thereby allowing the user to re-do reconciles.


That could be a good idea.

-derek


On Sat, 4 Sept 2021 at 06:34, Borden via gnucash-user <
gnucash-user@gnucash.org> wrote:





The starting balance is computed from all the reconciled

transactions

"to

date".  It *can* be safe to ignore the starting balance if, for

example,
a

transaction became unreconciled.  For example, let's say you

reconcile
from some starting balance X to a final balance of $1000.  
Then you

accidentally unreconcile a $100 transactions.  If you try to

re-reconcile

that same statement/date/ending-balance of $1000, it won't show X

as

the

starting balance, but something else (PROBABLY $900, but I'm not

100%

sure).  But that's okay -- just ensure the ending balance is

correct

and

all the transactions that SHOULD be reconciled ARE reconciled.

There is no way to get a transaction to reconciled status (y)

manually

--

the only way is through a reconcile process.  So if you have

reconciled

transactions, that must've happened through a reconcile.

I would recommend you just go ahead with March, ignore the 
starting

balance, enter the correct March ending balance, and see if the
reconciliation works (ensure you re-reconcile anything from 
earlier

that

might have become unreconciled).


So I just want to build a bit on this answer. GNUCash doesn't have

QBs
reconciliation system - so don't equate the two. As an 
accountant who

doesn't need to be handheld or leashed, I  find GNUCash's system

better
than QBs - albeit there is room for improvement. However, I 
wouldn't

recommend GNUCash to someone less comfortable with bare-ledger
accounting -
controls exist for a reason.

I don't know how the backend works, but my experience is that the
"Opening
balance" is basically a running total of all the transactions 
marked

"Reconciled" in that account. Whereas QB will _prevent_ you from
attempting
to reconcile August if July's reconciled balance differs from 
what it

previously reconciled, GNUCash doesn't care - it just says "The
transactions marked 'Reconciled' for this account total to $X." 
And

that's
good for when you have to go back and fix things... and know what

you're

doing.

When you reconcile a transaction, again based on  my experience,

GNUCash

toggles the "Reconciled" flag on the account _and_ inserts the
reconciliation date. I personally like this because I can, say,

start a
fresh reconciliation for March having reconciled through 
August  to

pick

up
the transactions that _should_ have been in the March 
reconciliation

but

weren't because I readded them (or whatever). However, I need  my
calculator with me because I need to adjust the "closing 
balance" to
reflect not the statement balance but what GNUCash's "running 
total"

balance should be. Contrast this to having to undo every rec in 

Re: [GNC] Redo account reconciliations

[David H]

Christopher,  I wasn't even aware this was visible by hovering over the
recon flag and I've been using Gnucash since early 2010 for my personal
finances and rental property :-)  I generally just rely on the recon date
column in the accounts register to see when I last reconciled an account.
I've picked up the odd unreconciled txn as part of doing the latest
reconciliation and realised I must have changed an old txn and it just got
swept into the latest bunch to be reconciled but the closing statement
balance agreed so all was well in the world.  Never had a use for the
reconciliation report either.  Can't see any real use for when individual
txns were reconciled - I think most of us wouldn't care too much about when
a particular txn was reconciled, we care more about when the account was
reconciled.

Cheers David H.




On Sun, 5 Sept 2021 at 01:29, Christopher Lam 
wrote:

>  > I guess it depends on how fussy you are about details. Since there is no
> way to see the reconciliation date there is little reason to insist on that
> date being correctly recorded (...)
>
> Yes, some users may be fussy. After all the reconcile_date *is* visible in
> the UI -- you need to hover on the 'y' reconcile status. It's also visible
> in the 'Reconciliation Report' and is used as the date filter.
>
> Adding UI to reset the reconciliation status will allow fastidious users to
> 'redo' reconciliation piecemeal and record statement dates accurately.
> Otherwise they'll need to reset reconcile status one by one by clicking on
> 'y'. I've done this a couple of times while searching for errors.
>
> On Sat, 4 Sept 2021 at 15:01, David Carlson 
> wrote:
>
> > I guess it depends on how fussy you are about details.  Since there is no
> > way to see the reconciliation date there is little reason to insist on
> that
> > date being correctly recorded. The GnuCash code displays an incorrect
> > starting balance in the Reconciliation window.  When you follow Derek's
> > suggestion and just ignore the starting balance error in the current
> > month's reconciliation, the old transaction is recorded as being
> reconciled
> > in the current month.
> >
> > If you really do want to record the correct reconciliation month for
> every
> > transaction, you need to unreconcile all transactions after the date of
> the
> > statement* before* the month that is not correct before starting the
> > rereconciliation.
> >
> > On Sat, Sep 4, 2021 at 9:19 AM Derek Atkins  wrote:
> >
> >> Ah... But that's NOT how you are supposed to recover from that.
> >> If you reconciled up for 31 Aug 2021, and you un-reconcile a
> transaction,
> >> it doesn't matter what date the transaction has -- you should
> re-reconcile
> >> 31 August!  You just need to re-check the February transaction.
> >>
> >> -derek
> >>
> >> On Sat, September 4, 2021 9:10 am, Christopher Lam wrote:
> >> > Derek,
> >> > Consider a well-used bank account. You reconcile every end of the
> month
> >> > successfully up to 31 Aug 2021.
> >> > Accidentally you unreconcile a Feb 2021 split.
> >> > You retrieve your 28 Feb 2021 bank statement, try to re-reconcile and
> >> fail
> >> > because the reconciliation end balance also tallies splits from March
> >> 2021
> >> > onwards.
> >> > C
> >> >
> >> > On Sat, 4 Sept 2021 at 13:01, Derek Atkins  wrote:
> >> >
> >> >> Chris,
> >> >>
> >> >> On Sat, September 4, 2021 8:36 am, Christopher Lam wrote:
> >> >> > I agree that if an account reconciliation is done periodically
> >> >> correctly
> >> >> > every time, then it works well. If an old reconciled split is
> >> >> unreconciled
> >> >> > and we need to re-reconcile a previous reconciliation date, then
> the
> >> >> code
> >> >> > falls apart.
> >> >>
> >> >> I'm curious why you say it falls apart?
> >> >>
> >> >> > It may be an idea to allow batch unreconciliation of all splits
> whose
> >> >> > reconcile date is after the reconciliation date in the
> Reconciliation
> >> >> > dialog, thereby allowing the user to re-do reconciles.
> >> >>
> >> >> That could be a good idea.
> >> >>
> >> >> -derek
> >> >>
> >> >> > On Sat, 4 Sept 2021 at 06:34, Borden via gnucash-user <
> >> >> > gnucash-user@gnucash.org> wrote:
> >> >> >
> >> >> >>
> >> >> >>
> >> >> >> > The starting balance is computed from all the reconciled
> >> >> transactions
> >> >> >> "to
> >> >> >> > date".  It *can* be safe to ignore the starting balance if, for
> >> >> >> example,
> >> >> >> a
> >> >> >> > transaction became unreconciled.  For example, let's say you
> >> >> reconcile
> >> >> >> > from some starting balance X to a final balance of $1000.  Then
> >> you
> >> >> >> > accidentally unreconcile a $100 transactions.  If you try to
> >> >> >> re-reconcile
> >> >> >> > that same statement/date/ending-balance of $1000, it won't show
> X
> >> >> as
> >> >> >> the
> >> >> >> > starting balance, but something else (PROBABLY $900, but I'm not
> >> >> 100%
> >> >> >> > sure).  But that's okay -- just ensure the ending balance is
> >> >> 

Re: [GNC] Redo account reconciliations

[David H]

I'm with Derek and Fred on this one, I'd be re-reconciling the latest
statement.  If I inadvertently un-reconcile a transaction I'm probably not
likely to pick it up until I reconcile in September and see it in the list
of txns to be reconciled even if I do notice it then as sometimes there are
quite a few and I'm only interested in the statement end balance anyway:-)

Cheers David H.

On Sun, 5 Sept 2021 at 01:26, Fred Bone  wrote:

> On 04 September 2021 at 13:10, Christopher Lam said:
>
> > Derek,
> > Consider a well-used bank account. You reconcile every end of the month
> > successfully up to 31 Aug 2021. Accidentally you unreconcile a Feb 2021
> > split. You retrieve your 28 Feb 2021 bank statement, try to re-reconcile
> > and fail because the reconciliation end balance also tallies splits from
> > March 2021 onwards. C
>
> Well, yes. You should be re-reconciling to the August statement date &
> balance.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Moving Sub-Accounts???

[Nora]

Hi Derek

Yes, it is a Happy Saturday.
It worked perfectly, and it wasn't too tedius
Thanks again.

Nora



-Original Message-
From: Derek Atkins [mailto:de...@ihtfp.com] 
Sent: September 4, 2021 3:04 PM
To: Nora
Cc: 'john'; 'GnuCash users group'; 'Borden'
Subject: RE: Moving Sub-Accounts???

Hi NOra,

Happy Saturday!

On Sat, September 4, 2021 2:57 pm, Nora wrote:
> Hello All
>
> Is it possible to move income sub accounts to other "place holder" income
> accounts.

Absolutely!  You are, however, limited to the account type in the
hierarchy, but you can absolutely move one Income account under another.

> I want to change the hierarchy and regroup AFTER I've set it all up.

Unfortunately it can be a bit tedious.  To re-parent an account you go to
the Chart of Accounts page, select the account you want to move, click on
"Edit Account" (either via the menu, toolbar, or right-click context
menu).  That will open the "Edit Account" window.

>From there, at the bottom-right, is the "Parent Account", which should
have the current parent selected.  Go select a different parent, and then
click "OK" and it will move in the tree.

> Thanks again!
> Nora
> Ps
> I tried a transfer of 'income'  monies to the "new  income sub-account"
> but
> it didn't let me.

How did you attempt to do this?

> THX.
> Nora

Good Luck!

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Moving Sub-Accounts???

[Derek Atkins]

Hi NOra,

Happy Saturday!

On Sat, September 4, 2021 2:57 pm, Nora wrote:
> Hello All
>
> Is it possible to move income sub accounts to other "place holder" income
> accounts.

Absolutely!  You are, however, limited to the account type in the
hierarchy, but you can absolutely move one Income account under another.

> I want to change the hierarchy and regroup AFTER I've set it all up.

Unfortunately it can be a bit tedious.  To re-parent an account you go to
the Chart of Accounts page, select the account you want to move, click on
"Edit Account" (either via the menu, toolbar, or right-click context
menu).  That will open the "Edit Account" window.

>From there, at the bottom-right, is the "Parent Account", which should
have the current parent selected.  Go select a different parent, and then
click "OK" and it will move in the tree.

> Thanks again!
> Nora
> Ps
> I tried a transfer of 'income'  monies to the "new  income sub-account"
> but
> it didn't let me.

How did you attempt to do this?

> THX.
> Nora

Good Luck!

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Moving Sub-Accounts???

[Nora]

Hello All

Is it possible to move income sub accounts to other "place holder" income
accounts.
I want to change the hierarchy and regroup AFTER I've set it all up. 
Thanks again!
Nora
Ps
I tried a transfer of 'income'  monies to the "new  income sub-account" but
it didn't let me. 
THX.
Nora

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Redo account reconciliations

[Derek Atkins]

Exactly.  But he had already reconciled to Aug 31, so need to use that date.

-derek
Sent using my mobile device. Please excuse any typos.
On September 4, 2021 11:09:12 AM john  wrote:

Oops, that'w wrong: You can't use the February statement's balance, you 
have to use the July statement balance (assuming that you haven't yet 
reconciled August) because the reconcile window doesn't know how to use 
xaccAccountGetReconciledBalanceAsOfDate.


Regards,
John Ralls


On Sep 4, 2021, at 7:59 AM, john  wrote:

He said the February reconcile.

So tell the reconcile info dialog 28 Feb and type in the balance from the 
February statement as usual. Click OK. As long as you haven't messed up 
anything else you'll be able to check the one unreconciled split from 
February and the finish button and you're done.


Regards,
John Ralls



On Sep 4, 2021, at 7:18 AM, Derek Atkins  wrote:

Ah... But that's NOT how you are supposed to recover from that.
If you reconciled up for 31 Aug 2021, and you un-reconcile a transaction,
it doesn't matter what date the transaction has -- you should re-reconcile
31 August!  You just need to re-check the February transaction.

-derek

On Sat, September 4, 2021 9:10 am, Christopher Lam wrote:

Derek,
Consider a well-used bank account. You reconcile every end of the month
successfully up to 31 Aug 2021.
Accidentally you unreconcile a Feb 2021 split.
You retrieve your 28 Feb 2021 bank statement, try to re-reconcile and fail
because the reconciliation end balance also tallies splits from March 2021
onwards.
C

On Sat, 4 Sept 2021 at 13:01, Derek Atkins  wrote:


Chris,

On Sat, September 4, 2021 8:36 am, Christopher Lam wrote:

I agree that if an account reconciliation is done periodically

correctly

every time, then it works well. If an old reconciled split is

unreconciled

and we need to re-reconcile a previous reconciliation date, then the

code

falls apart.


I'm curious why you say it falls apart?


It may be an idea to allow batch unreconciliation of all splits whose
reconcile date is after the reconciliation date in the Reconciliation
dialog, thereby allowing the user to re-do reconciles.


That could be a good idea.

-derek


On Sat, 4 Sept 2021 at 06:34, Borden via gnucash-user <
gnucash-user@gnucash.org> wrote:





The starting balance is computed from all the reconciled

transactions

"to

date".  It *can* be safe to ignore the starting balance if, for

example,
a

transaction became unreconciled.  For example, let's say you

reconcile

from some starting balance X to a final balance of $1000.  Then you
accidentally unreconcile a $100 transactions.  If you try to

re-reconcile

that same statement/date/ending-balance of $1000, it won't show X

as

the

starting balance, but something else (PROBABLY $900, but I'm not

100%

sure).  But that's okay -- just ensure the ending balance is

correct

and

all the transactions that SHOULD be reconciled ARE reconciled.

There is no way to get a transaction to reconciled status (y)

manually

--

the only way is through a reconcile process.  So if you have

reconciled

transactions, that must've happened through a reconcile.

I would recommend you just go ahead with March, ignore the starting
balance, enter the correct March ending balance, and see if the
reconciliation works (ensure you re-reconcile anything from earlier

that

might have become unreconciled).


So I just want to build a bit on this answer. GNUCash doesn't have

QBs

reconciliation system - so don't equate the two. As an accountant who
doesn't need to be handheld or leashed, I  find GNUCash's system

better

than QBs - albeit there is room for improvement. However, I wouldn't
recommend GNUCash to someone less comfortable with bare-ledger
accounting -
controls exist for a reason.

I don't know how the backend works, but my experience is that the
"Opening
balance" is basically a running total of all the transactions marked
"Reconciled" in that account. Whereas QB will _prevent_ you from
attempting
to reconcile August if July's reconciled balance differs from what it
previously reconciled, GNUCash doesn't care - it just says "The
transactions marked 'Reconciled' for this account total to $X." And
that's
good for when you have to go back and fix things... and know what

you're

doing.

When you reconcile a transaction, again based on  my experience,

GNUCash

toggles the "Reconciled" flag on the account _and_ inserts the
reconciliation date. I personally like this because  I can, say,

start a

fresh reconciliation for March having reconciled through August  to

pick

up
the transactions that _should_ have been in the March reconciliation

but

weren't because I readded them (or whatever). However, I need  my
calculator with me because I need to adjust the "closing balance" to
reflect not the statement balance but what GNUCash's "running total"
balance should be. Contrast this to having to undo every rec in QB

back

to
March and redo every rec again.

Still, as I said, 

Re: [GNC] How To Create Online Backup Of Data

[Michael or Penny Novack]

On 9/3/2021 9:22 AM, muhammad Noman wrote:

Dear Sir,

  I want to know how can i create backup of my data while using
gnucash software version 2.6.18

Regards,

Muhammad Nouman


The same way you create a  backup of all your other data. Your gnucash 
data is a file, just like all of your other files.


Describe how you NOW backup all your data (all your documents, pictures, 
etc. Where your data is (in what directories, aka, file folders) depends 
on what operating system you use, not the same for Windows N as opposed 
to linux or a Mac OS. But you didn't tell us that.


For example, I am using Windows 10 and use FireFox and Thunderbird. Data 
might also have changed since last backup in the documents directory 
(gnucash data here), downloads directory, and perhaps picture directory. 
So once a month (my backup frequency) I connect an external drive, 
create a directory Backupsmmdd and into it copy the directories I 
listed (my T'Bird data and FF data would be in their respective profile 
directiories.


Then I can take that drive out to the fire safe in another building  << 
if that last seems paranoid, we once had  a house fire and smoke/water 
messed some drives up so badly not even the data recovery lab could get 
all of it back >>


Michael D Novack


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Redo account reconciliations

[Christopher Lam]

 > I guess it depends on how fussy you are about details. Since there is no
way to see the reconciliation date there is little reason to insist on that
date being correctly recorded (...)

Yes, some users may be fussy. After all the reconcile_date *is* visible in
the UI -- you need to hover on the 'y' reconcile status. It's also visible
in the 'Reconciliation Report' and is used as the date filter.

Adding UI to reset the reconciliation status will allow fastidious users to
'redo' reconciliation piecemeal and record statement dates accurately.
Otherwise they'll need to reset reconcile status one by one by clicking on
'y'. I've done this a couple of times while searching for errors.

On Sat, 4 Sept 2021 at 15:01, David Carlson 
wrote:

> I guess it depends on how fussy you are about details.  Since there is no
> way to see the reconciliation date there is little reason to insist on that
> date being correctly recorded. The GnuCash code displays an incorrect
> starting balance in the Reconciliation window.  When you follow Derek's
> suggestion and just ignore the starting balance error in the current
> month's reconciliation, the old transaction is recorded as being reconciled
> in the current month.
>
> If you really do want to record the correct reconciliation month for every
> transaction, you need to unreconcile all transactions after the date of the
> statement* before* the month that is not correct before starting the
> rereconciliation.
>
> On Sat, Sep 4, 2021 at 9:19 AM Derek Atkins  wrote:
>
>> Ah... But that's NOT how you are supposed to recover from that.
>> If you reconciled up for 31 Aug 2021, and you un-reconcile a transaction,
>> it doesn't matter what date the transaction has -- you should re-reconcile
>> 31 August!  You just need to re-check the February transaction.
>>
>> -derek
>>
>> On Sat, September 4, 2021 9:10 am, Christopher Lam wrote:
>> > Derek,
>> > Consider a well-used bank account. You reconcile every end of the month
>> > successfully up to 31 Aug 2021.
>> > Accidentally you unreconcile a Feb 2021 split.
>> > You retrieve your 28 Feb 2021 bank statement, try to re-reconcile and
>> fail
>> > because the reconciliation end balance also tallies splits from March
>> 2021
>> > onwards.
>> > C
>> >
>> > On Sat, 4 Sept 2021 at 13:01, Derek Atkins  wrote:
>> >
>> >> Chris,
>> >>
>> >> On Sat, September 4, 2021 8:36 am, Christopher Lam wrote:
>> >> > I agree that if an account reconciliation is done periodically
>> >> correctly
>> >> > every time, then it works well. If an old reconciled split is
>> >> unreconciled
>> >> > and we need to re-reconcile a previous reconciliation date, then the
>> >> code
>> >> > falls apart.
>> >>
>> >> I'm curious why you say it falls apart?
>> >>
>> >> > It may be an idea to allow batch unreconciliation of all splits whose
>> >> > reconcile date is after the reconciliation date in the Reconciliation
>> >> > dialog, thereby allowing the user to re-do reconciles.
>> >>
>> >> That could be a good idea.
>> >>
>> >> -derek
>> >>
>> >> > On Sat, 4 Sept 2021 at 06:34, Borden via gnucash-user <
>> >> > gnucash-user@gnucash.org> wrote:
>> >> >
>> >> >>
>> >> >>
>> >> >> > The starting balance is computed from all the reconciled
>> >> transactions
>> >> >> "to
>> >> >> > date".  It *can* be safe to ignore the starting balance if, for
>> >> >> example,
>> >> >> a
>> >> >> > transaction became unreconciled.  For example, let's say you
>> >> reconcile
>> >> >> > from some starting balance X to a final balance of $1000.  Then
>> you
>> >> >> > accidentally unreconcile a $100 transactions.  If you try to
>> >> >> re-reconcile
>> >> >> > that same statement/date/ending-balance of $1000, it won't show X
>> >> as
>> >> >> the
>> >> >> > starting balance, but something else (PROBABLY $900, but I'm not
>> >> 100%
>> >> >> > sure).  But that's okay -- just ensure the ending balance is
>> >> correct
>> >> >> and
>> >> >> > all the transactions that SHOULD be reconciled ARE reconciled.
>> >> >> >
>> >> >> > There is no way to get a transaction to reconciled status (y)
>> >> manually
>> >> >> --
>> >> >> > the only way is through a reconcile process.  So if you have
>> >> >> reconciled
>> >> >> > transactions, that must've happened through a reconcile.
>> >> >> >
>> >> >> > I would recommend you just go ahead with March, ignore the
>> starting
>> >> >> > balance, enter the correct March ending balance, and see if the
>> >> >> > reconciliation works (ensure you re-reconcile anything from
>> earlier
>> >> >> that
>> >> >> > might have become unreconciled).
>> >> >> >
>> >> >> So I just want to build a bit on this answer. GNUCash doesn't have
>> >> QBs
>> >> >> reconciliation system - so don't equate the two. As an accountant
>> who
>> >> >> doesn't need to be handheld or leashed, I  find GNUCash's system
>> >> better
>> >> >> than QBs - albeit there is room for improvement. However, I wouldn't
>> >> >> recommend GNUCash to someone less comfortable with bare-ledger
>> >> >> 

Re: [GNC] Redo account reconciliations

[Fred Bone]

On 04 September 2021 at 13:10, Christopher Lam said:

> Derek,
> Consider a well-used bank account. You reconcile every end of the month
> successfully up to 31 Aug 2021. Accidentally you unreconcile a Feb 2021
> split. You retrieve your 28 Feb 2021 bank statement, try to re-reconcile
> and fail because the reconciliation end balance also tallies splits from
> March 2021 onwards. C

Well, yes. You should be re-reconciling to the August statement date & 
balance.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Redo account reconciliations

[john]

Oops, that'w wrong: You can't use the February statement's balance, you have to 
use the July statement balance (assuming that you haven't yet reconciled 
August) because the reconcile window doesn't know how to use 
xaccAccountGetReconciledBalanceAsOfDate.

Regards,
John Ralls

> On Sep 4, 2021, at 7:59 AM, john  wrote:
> 
> He said the February reconcile.
> 
> So tell the reconcile info dialog 28 Feb and type in the balance from the 
> February statement as usual. Click OK. As long as you haven't messed up 
> anything else you'll be able to check the one unreconciled split from 
> February and the finish button and you're done.
> 
> Regards,
> John Ralls
> 
> 
>> On Sep 4, 2021, at 7:18 AM, Derek Atkins  wrote:
>> 
>> Ah... But that's NOT how you are supposed to recover from that.
>> If you reconciled up for 31 Aug 2021, and you un-reconcile a transaction,
>> it doesn't matter what date the transaction has -- you should re-reconcile
>> 31 August!  You just need to re-check the February transaction.
>> 
>> -derek
>> 
>> On Sat, September 4, 2021 9:10 am, Christopher Lam wrote:
>>> Derek,
>>> Consider a well-used bank account. You reconcile every end of the month
>>> successfully up to 31 Aug 2021.
>>> Accidentally you unreconcile a Feb 2021 split.
>>> You retrieve your 28 Feb 2021 bank statement, try to re-reconcile and fail
>>> because the reconciliation end balance also tallies splits from March 2021
>>> onwards.
>>> C
>>> 
>>> On Sat, 4 Sept 2021 at 13:01, Derek Atkins  wrote:
>>> 
 Chris,
 
 On Sat, September 4, 2021 8:36 am, Christopher Lam wrote:
> I agree that if an account reconciliation is done periodically
 correctly
> every time, then it works well. If an old reconciled split is
 unreconciled
> and we need to re-reconcile a previous reconciliation date, then the
 code
> falls apart.
 
 I'm curious why you say it falls apart?
 
> It may be an idea to allow batch unreconciliation of all splits whose
> reconcile date is after the reconciliation date in the Reconciliation
> dialog, thereby allowing the user to re-do reconciles.
 
 That could be a good idea.
 
 -derek
 
> On Sat, 4 Sept 2021 at 06:34, Borden via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> 
>> 
>> 
>>> The starting balance is computed from all the reconciled
 transactions
>> "to
>>> date".  It *can* be safe to ignore the starting balance if, for
>> example,
>> a
>>> transaction became unreconciled.  For example, let's say you
 reconcile
>>> from some starting balance X to a final balance of $1000.  Then you
>>> accidentally unreconcile a $100 transactions.  If you try to
>> re-reconcile
>>> that same statement/date/ending-balance of $1000, it won't show X
 as
>> the
>>> starting balance, but something else (PROBABLY $900, but I'm not
 100%
>>> sure).  But that's okay -- just ensure the ending balance is
 correct
>> and
>>> all the transactions that SHOULD be reconciled ARE reconciled.
>>> 
>>> There is no way to get a transaction to reconciled status (y)
 manually
>> --
>>> the only way is through a reconcile process.  So if you have
>> reconciled
>>> transactions, that must've happened through a reconcile.
>>> 
>>> I would recommend you just go ahead with March, ignore the starting
>>> balance, enter the correct March ending balance, and see if the
>>> reconciliation works (ensure you re-reconcile anything from earlier
>> that
>>> might have become unreconciled).
>>> 
>> So I just want to build a bit on this answer. GNUCash doesn't have
 QBs
>> reconciliation system - so don't equate the two. As an accountant who
>> doesn't need to be handheld or leashed, I  find GNUCash's system
 better
>> than QBs - albeit there is room for improvement. However, I wouldn't
>> recommend GNUCash to someone less comfortable with bare-ledger
>> accounting -
>> controls exist for a reason.
>> 
>> I don't know how the backend works, but my experience is that the
>> "Opening
>> balance" is basically a running total of all the transactions marked
>> "Reconciled" in that account. Whereas QB will _prevent_ you from
>> attempting
>> to reconcile August if July's reconciled balance differs from what it
>> previously reconciled, GNUCash doesn't care - it just says "The
>> transactions marked 'Reconciled' for this account total to $X." And
>> that's
>> good for when you have to go back and fix things... and know what
 you're
>> doing.
>> 
>> When you reconcile a transaction, again based on  my experience,
 GNUCash
>> toggles the "Reconciled" flag on the account _and_ inserts the
>> reconciliation date. I personally like this because  I can, say,
 start a
>> fresh reconciliation for March having 

Re: [GNC] Redo account reconciliations

[David Carlson]

I guess it depends on how fussy you are about details.  Since there is no
way to see the reconciliation date there is little reason to insist on that
date being correctly recorded. The GnuCash code displays an incorrect
starting balance in the Reconciliation window.  When you follow Derek's
suggestion and just ignore the starting balance error in the current
month's reconciliation, the old transaction is recorded as being reconciled
in the current month.

If you really do want to record the correct reconciliation month for every
transaction, you need to unreconcile all transactions after the date of the
statement* before* the month that is not correct before starting the
rereconciliation.

On Sat, Sep 4, 2021 at 9:19 AM Derek Atkins  wrote:

> Ah... But that's NOT how you are supposed to recover from that.
> If you reconciled up for 31 Aug 2021, and you un-reconcile a transaction,
> it doesn't matter what date the transaction has -- you should re-reconcile
> 31 August!  You just need to re-check the February transaction.
>
> -derek
>
> On Sat, September 4, 2021 9:10 am, Christopher Lam wrote:
> > Derek,
> > Consider a well-used bank account. You reconcile every end of the month
> > successfully up to 31 Aug 2021.
> > Accidentally you unreconcile a Feb 2021 split.
> > You retrieve your 28 Feb 2021 bank statement, try to re-reconcile and
> fail
> > because the reconciliation end balance also tallies splits from March
> 2021
> > onwards.
> > C
> >
> > On Sat, 4 Sept 2021 at 13:01, Derek Atkins  wrote:
> >
> >> Chris,
> >>
> >> On Sat, September 4, 2021 8:36 am, Christopher Lam wrote:
> >> > I agree that if an account reconciliation is done periodically
> >> correctly
> >> > every time, then it works well. If an old reconciled split is
> >> unreconciled
> >> > and we need to re-reconcile a previous reconciliation date, then the
> >> code
> >> > falls apart.
> >>
> >> I'm curious why you say it falls apart?
> >>
> >> > It may be an idea to allow batch unreconciliation of all splits whose
> >> > reconcile date is after the reconciliation date in the Reconciliation
> >> > dialog, thereby allowing the user to re-do reconciles.
> >>
> >> That could be a good idea.
> >>
> >> -derek
> >>
> >> > On Sat, 4 Sept 2021 at 06:34, Borden via gnucash-user <
> >> > gnucash-user@gnucash.org> wrote:
> >> >
> >> >>
> >> >>
> >> >> > The starting balance is computed from all the reconciled
> >> transactions
> >> >> "to
> >> >> > date".  It *can* be safe to ignore the starting balance if, for
> >> >> example,
> >> >> a
> >> >> > transaction became unreconciled.  For example, let's say you
> >> reconcile
> >> >> > from some starting balance X to a final balance of $1000.  Then you
> >> >> > accidentally unreconcile a $100 transactions.  If you try to
> >> >> re-reconcile
> >> >> > that same statement/date/ending-balance of $1000, it won't show X
> >> as
> >> >> the
> >> >> > starting balance, but something else (PROBABLY $900, but I'm not
> >> 100%
> >> >> > sure).  But that's okay -- just ensure the ending balance is
> >> correct
> >> >> and
> >> >> > all the transactions that SHOULD be reconciled ARE reconciled.
> >> >> >
> >> >> > There is no way to get a transaction to reconciled status (y)
> >> manually
> >> >> --
> >> >> > the only way is through a reconcile process.  So if you have
> >> >> reconciled
> >> >> > transactions, that must've happened through a reconcile.
> >> >> >
> >> >> > I would recommend you just go ahead with March, ignore the starting
> >> >> > balance, enter the correct March ending balance, and see if the
> >> >> > reconciliation works (ensure you re-reconcile anything from earlier
> >> >> that
> >> >> > might have become unreconciled).
> >> >> >
> >> >> So I just want to build a bit on this answer. GNUCash doesn't have
> >> QBs
> >> >> reconciliation system - so don't equate the two. As an accountant who
> >> >> doesn't need to be handheld or leashed, I  find GNUCash's system
> >> better
> >> >> than QBs - albeit there is room for improvement. However, I wouldn't
> >> >> recommend GNUCash to someone less comfortable with bare-ledger
> >> >> accounting -
> >> >> controls exist for a reason.
> >> >>
> >> >> I don't know how the backend works, but my experience is that the
> >> >> "Opening
> >> >> balance" is basically a running total of all the transactions marked
> >> >> "Reconciled" in that account. Whereas QB will _prevent_ you from
> >> >> attempting
> >> >> to reconcile August if July's reconciled balance differs from what it
> >> >> previously reconciled, GNUCash doesn't care - it just says "The
> >> >> transactions marked 'Reconciled' for this account total to $X." And
> >> >> that's
> >> >> good for when you have to go back and fix things... and know what
> >> you're
> >> >> doing.
> >> >>
> >> >> When you reconcile a transaction, again based on  my experience,
> >> GNUCash
> >> >> toggles the "Reconciled" flag on the account _and_ inserts the
> >> >> reconciliation date. I personally like this 

Re: [GNC] Redo account reconciliations

[john]

He said the February reconcile.

So tell the reconcile info dialog 28 Feb and type in the balance from the 
February statement as usual. Click OK. As long as you haven't messed up 
anything else you'll be able to check the one unreconciled split from February 
and the finish button and you're done.

Regards,
John Ralls


> On Sep 4, 2021, at 7:18 AM, Derek Atkins  wrote:
> 
> Ah... But that's NOT how you are supposed to recover from that.
> If you reconciled up for 31 Aug 2021, and you un-reconcile a transaction,
> it doesn't matter what date the transaction has -- you should re-reconcile
> 31 August!  You just need to re-check the February transaction.
> 
> -derek
> 
> On Sat, September 4, 2021 9:10 am, Christopher Lam wrote:
>> Derek,
>> Consider a well-used bank account. You reconcile every end of the month
>> successfully up to 31 Aug 2021.
>> Accidentally you unreconcile a Feb 2021 split.
>> You retrieve your 28 Feb 2021 bank statement, try to re-reconcile and fail
>> because the reconciliation end balance also tallies splits from March 2021
>> onwards.
>> C
>> 
>> On Sat, 4 Sept 2021 at 13:01, Derek Atkins  wrote:
>> 
>>> Chris,
>>> 
>>> On Sat, September 4, 2021 8:36 am, Christopher Lam wrote:
 I agree that if an account reconciliation is done periodically
>>> correctly
 every time, then it works well. If an old reconciled split is
>>> unreconciled
 and we need to re-reconcile a previous reconciliation date, then the
>>> code
 falls apart.
>>> 
>>> I'm curious why you say it falls apart?
>>> 
 It may be an idea to allow batch unreconciliation of all splits whose
 reconcile date is after the reconciliation date in the Reconciliation
 dialog, thereby allowing the user to re-do reconciles.
>>> 
>>> That could be a good idea.
>>> 
>>> -derek
>>> 
 On Sat, 4 Sept 2021 at 06:34, Borden via gnucash-user <
 gnucash-user@gnucash.org> wrote:
 
> 
> 
>> The starting balance is computed from all the reconciled
>>> transactions
> "to
>> date".  It *can* be safe to ignore the starting balance if, for
> example,
> a
>> transaction became unreconciled.  For example, let's say you
>>> reconcile
>> from some starting balance X to a final balance of $1000.  Then you
>> accidentally unreconcile a $100 transactions.  If you try to
> re-reconcile
>> that same statement/date/ending-balance of $1000, it won't show X
>>> as
> the
>> starting balance, but something else (PROBABLY $900, but I'm not
>>> 100%
>> sure).  But that's okay -- just ensure the ending balance is
>>> correct
> and
>> all the transactions that SHOULD be reconciled ARE reconciled.
>> 
>> There is no way to get a transaction to reconciled status (y)
>>> manually
> --
>> the only way is through a reconcile process.  So if you have
> reconciled
>> transactions, that must've happened through a reconcile.
>> 
>> I would recommend you just go ahead with March, ignore the starting
>> balance, enter the correct March ending balance, and see if the
>> reconciliation works (ensure you re-reconcile anything from earlier
> that
>> might have become unreconciled).
>> 
> So I just want to build a bit on this answer. GNUCash doesn't have
>>> QBs
> reconciliation system - so don't equate the two. As an accountant who
> doesn't need to be handheld or leashed, I  find GNUCash's system
>>> better
> than QBs - albeit there is room for improvement. However, I wouldn't
> recommend GNUCash to someone less comfortable with bare-ledger
> accounting -
> controls exist for a reason.
> 
> I don't know how the backend works, but my experience is that the
> "Opening
> balance" is basically a running total of all the transactions marked
> "Reconciled" in that account. Whereas QB will _prevent_ you from
> attempting
> to reconcile August if July's reconciled balance differs from what it
> previously reconciled, GNUCash doesn't care - it just says "The
> transactions marked 'Reconciled' for this account total to $X." And
> that's
> good for when you have to go back and fix things... and know what
>>> you're
> doing.
> 
> When you reconcile a transaction, again based on  my experience,
>>> GNUCash
> toggles the "Reconciled" flag on the account _and_ inserts the
> reconciliation date. I personally like this because  I can, say,
>>> start a
> fresh reconciliation for March having reconciled through August  to
>>> pick
> up
> the transactions that _should_ have been in the March reconciliation
>>> but
> weren't because I readded them (or whatever). However, I need  my
> calculator with me because I need to adjust the "closing balance" to
> reflect not the statement balance but what GNUCash's "running total"
> balance should be. Contrast this to having to undo every rec in QB
>>> back
> to
> March and redo 

Re: [GNC] Redo account reconciliations

[Derek Atkins]

Ah... But that's NOT how you are supposed to recover from that.
If you reconciled up for 31 Aug 2021, and you un-reconcile a transaction,
it doesn't matter what date the transaction has -- you should re-reconcile
31 August!  You just need to re-check the February transaction.

-derek

On Sat, September 4, 2021 9:10 am, Christopher Lam wrote:
> Derek,
> Consider a well-used bank account. You reconcile every end of the month
> successfully up to 31 Aug 2021.
> Accidentally you unreconcile a Feb 2021 split.
> You retrieve your 28 Feb 2021 bank statement, try to re-reconcile and fail
> because the reconciliation end balance also tallies splits from March 2021
> onwards.
> C
>
> On Sat, 4 Sept 2021 at 13:01, Derek Atkins  wrote:
>
>> Chris,
>>
>> On Sat, September 4, 2021 8:36 am, Christopher Lam wrote:
>> > I agree that if an account reconciliation is done periodically
>> correctly
>> > every time, then it works well. If an old reconciled split is
>> unreconciled
>> > and we need to re-reconcile a previous reconciliation date, then the
>> code
>> > falls apart.
>>
>> I'm curious why you say it falls apart?
>>
>> > It may be an idea to allow batch unreconciliation of all splits whose
>> > reconcile date is after the reconciliation date in the Reconciliation
>> > dialog, thereby allowing the user to re-do reconciles.
>>
>> That could be a good idea.
>>
>> -derek
>>
>> > On Sat, 4 Sept 2021 at 06:34, Borden via gnucash-user <
>> > gnucash-user@gnucash.org> wrote:
>> >
>> >>
>> >>
>> >> > The starting balance is computed from all the reconciled
>> transactions
>> >> "to
>> >> > date".  It *can* be safe to ignore the starting balance if, for
>> >> example,
>> >> a
>> >> > transaction became unreconciled.  For example, let's say you
>> reconcile
>> >> > from some starting balance X to a final balance of $1000.  Then you
>> >> > accidentally unreconcile a $100 transactions.  If you try to
>> >> re-reconcile
>> >> > that same statement/date/ending-balance of $1000, it won't show X
>> as
>> >> the
>> >> > starting balance, but something else (PROBABLY $900, but I'm not
>> 100%
>> >> > sure).  But that's okay -- just ensure the ending balance is
>> correct
>> >> and
>> >> > all the transactions that SHOULD be reconciled ARE reconciled.
>> >> >
>> >> > There is no way to get a transaction to reconciled status (y)
>> manually
>> >> --
>> >> > the only way is through a reconcile process.  So if you have
>> >> reconciled
>> >> > transactions, that must've happened through a reconcile.
>> >> >
>> >> > I would recommend you just go ahead with March, ignore the starting
>> >> > balance, enter the correct March ending balance, and see if the
>> >> > reconciliation works (ensure you re-reconcile anything from earlier
>> >> that
>> >> > might have become unreconciled).
>> >> >
>> >> So I just want to build a bit on this answer. GNUCash doesn't have
>> QBs
>> >> reconciliation system - so don't equate the two. As an accountant who
>> >> doesn't need to be handheld or leashed, I  find GNUCash's system
>> better
>> >> than QBs - albeit there is room for improvement. However, I wouldn't
>> >> recommend GNUCash to someone less comfortable with bare-ledger
>> >> accounting -
>> >> controls exist for a reason.
>> >>
>> >> I don't know how the backend works, but my experience is that the
>> >> "Opening
>> >> balance" is basically a running total of all the transactions marked
>> >> "Reconciled" in that account. Whereas QB will _prevent_ you from
>> >> attempting
>> >> to reconcile August if July's reconciled balance differs from what it
>> >> previously reconciled, GNUCash doesn't care - it just says "The
>> >> transactions marked 'Reconciled' for this account total to $X." And
>> >> that's
>> >> good for when you have to go back and fix things... and know what
>> you're
>> >> doing.
>> >>
>> >> When you reconcile a transaction, again based on  my experience,
>> GNUCash
>> >> toggles the "Reconciled" flag on the account _and_ inserts the
>> >> reconciliation date. I personally like this because  I can, say,
>> start a
>> >> fresh reconciliation for March having reconciled through August  to
>> pick
>> >> up
>> >> the transactions that _should_ have been in the March reconciliation
>> but
>> >> weren't because I readded them (or whatever). However, I need  my
>> >> calculator with me because I need to adjust the "closing balance" to
>> >> reflect not the statement balance but what GNUCash's "running total"
>> >> balance should be. Contrast this to having to undo every rec in QB
>> back
>> >> to
>> >> March and redo every rec again.
>> >>
>> >> Still, as I said, there's room for improvement in GNUCash:1) Since
>> the
>> >> rec
>> >> date gets stored with the Rec flag, GNUCash can  have a function that
>> >> unreconciles every transaction before a given rec date. This would be
>> >> analogous to QB's batch rec undo.
>> >> 2) One should be able to rec from the ledger  as QB lets you do - and
>> >> prompt for a rec date. Yes it's dangerous, 

Re: [GNC] How To Create Online Backup Of Data

[Glenn Fowler]

Hi,

There is also good info in the faq:

https://wiki.gnucash.org/wiki/FAQ#Questions_about_Backups

And the wiki:

https://wiki.gnucash.org/wiki/Backup


On Sat, Sep 4, 2021, 9:03 AM Derek Atkins  wrote:

> Hi,
>
> On Fri, September 3, 2021 9:22 am, muhammad Noman wrote:
> > Dear Sir,
> >
> >  I want to know how can i create backup of my data while
> using
> > gnucash software version 2.6.18
>
> You back it up just like you'd backup a Word document or Excel spreadsheet
> -- by backing up your disk.
>
> Note that GnuCash DOES make backup copies of your data file every time you
> save (if you use the XML backend), which is why you see a bunch of
> .MMDDHHMMSS.gnucash files next to your .gnucash
> file.  But other than that, it is up to you to back up your disk using
> whatever backup software you prefer.
>
> > Regards,
> >
> > Muhammad Nouman
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Redo account reconciliations

[Christopher Lam]

Derek,
Consider a well-used bank account. You reconcile every end of the month
successfully up to 31 Aug 2021.
Accidentally you unreconcile a Feb 2021 split.
You retrieve your 28 Feb 2021 bank statement, try to re-reconcile and fail
because the reconciliation end balance also tallies splits from March 2021
onwards.
C

On Sat, 4 Sept 2021 at 13:01, Derek Atkins  wrote:

> Chris,
>
> On Sat, September 4, 2021 8:36 am, Christopher Lam wrote:
> > I agree that if an account reconciliation is done periodically correctly
> > every time, then it works well. If an old reconciled split is
> unreconciled
> > and we need to re-reconcile a previous reconciliation date, then the code
> > falls apart.
>
> I'm curious why you say it falls apart?
>
> > It may be an idea to allow batch unreconciliation of all splits whose
> > reconcile date is after the reconciliation date in the Reconciliation
> > dialog, thereby allowing the user to re-do reconciles.
>
> That could be a good idea.
>
> -derek
>
> > On Sat, 4 Sept 2021 at 06:34, Borden via gnucash-user <
> > gnucash-user@gnucash.org> wrote:
> >
> >>
> >>
> >> > The starting balance is computed from all the reconciled transactions
> >> "to
> >> > date".  It *can* be safe to ignore the starting balance if, for
> >> example,
> >> a
> >> > transaction became unreconciled.  For example, let's say you reconcile
> >> > from some starting balance X to a final balance of $1000.  Then you
> >> > accidentally unreconcile a $100 transactions.  If you try to
> >> re-reconcile
> >> > that same statement/date/ending-balance of $1000, it won't show X as
> >> the
> >> > starting balance, but something else (PROBABLY $900, but I'm not 100%
> >> > sure).  But that's okay -- just ensure the ending balance is correct
> >> and
> >> > all the transactions that SHOULD be reconciled ARE reconciled.
> >> >
> >> > There is no way to get a transaction to reconciled status (y) manually
> >> --
> >> > the only way is through a reconcile process.  So if you have
> >> reconciled
> >> > transactions, that must've happened through a reconcile.
> >> >
> >> > I would recommend you just go ahead with March, ignore the starting
> >> > balance, enter the correct March ending balance, and see if the
> >> > reconciliation works (ensure you re-reconcile anything from earlier
> >> that
> >> > might have become unreconciled).
> >> >
> >> So I just want to build a bit on this answer. GNUCash doesn't have QBs
> >> reconciliation system - so don't equate the two. As an accountant who
> >> doesn't need to be handheld or leashed, I  find GNUCash's system better
> >> than QBs - albeit there is room for improvement. However, I wouldn't
> >> recommend GNUCash to someone less comfortable with bare-ledger
> >> accounting -
> >> controls exist for a reason.
> >>
> >> I don't know how the backend works, but my experience is that the
> >> "Opening
> >> balance" is basically a running total of all the transactions marked
> >> "Reconciled" in that account. Whereas QB will _prevent_ you from
> >> attempting
> >> to reconcile August if July's reconciled balance differs from what it
> >> previously reconciled, GNUCash doesn't care - it just says "The
> >> transactions marked 'Reconciled' for this account total to $X." And
> >> that's
> >> good for when you have to go back and fix things... and know what you're
> >> doing.
> >>
> >> When you reconcile a transaction, again based on  my experience, GNUCash
> >> toggles the "Reconciled" flag on the account _and_ inserts the
> >> reconciliation date. I personally like this because  I can, say, start a
> >> fresh reconciliation for March having reconciled through August  to pick
> >> up
> >> the transactions that _should_ have been in the March reconciliation but
> >> weren't because I readded them (or whatever). However, I need  my
> >> calculator with me because I need to adjust the "closing balance" to
> >> reflect not the statement balance but what GNUCash's "running total"
> >> balance should be. Contrast this to having to undo every rec in QB back
> >> to
> >> March and redo every rec again.
> >>
> >> Still, as I said, there's room for improvement in GNUCash:1) Since the
> >> rec
> >> date gets stored with the Rec flag, GNUCash can  have a function that
> >> unreconciles every transaction before a given rec date. This would be
> >> analogous to QB's batch rec undo.
> >> 2) One should be able to rec from the ledger  as QB lets you do - and
> >> prompt for a rec date. Yes it's dangerous, poor practice, etc., but the
> >> GNU
> >> philosophy is not to leash the user. If a user wants to sudo rm -rf /
> >> their
> >> installation, GNU warns them first, but ultimately lets them. User knows
> >> best. If you want your computer to dictate what you're allowed to do
> >> with
> >> it, that's what Apple's for.
> >>
> >> I hope that helps a bit
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription 

Re: [GNC] How To Create Online Backup Of Data

[Derek Atkins]

Hi,

On Fri, September 3, 2021 9:22 am, muhammad Noman wrote:
> Dear Sir,
>
>  I want to know how can i create backup of my data while using
> gnucash software version 2.6.18

You back it up just like you'd backup a Word document or Excel spreadsheet
-- by backing up your disk.

Note that GnuCash DOES make backup copies of your data file every time you
save (if you use the XML backend), which is why you see a bunch of
.MMDDHHMMSS.gnucash files next to your .gnucash
file.  But other than that, it is up to you to back up your disk using
whatever backup software you prefer.

> Regards,
>
> Muhammad Nouman

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Redo account reconciliations

[Derek Atkins]

Chris,

On Sat, September 4, 2021 8:36 am, Christopher Lam wrote:
> I agree that if an account reconciliation is done periodically correctly
> every time, then it works well. If an old reconciled split is unreconciled
> and we need to re-reconcile a previous reconciliation date, then the code
> falls apart.

I'm curious why you say it falls apart?

> It may be an idea to allow batch unreconciliation of all splits whose
> reconcile date is after the reconciliation date in the Reconciliation
> dialog, thereby allowing the user to re-do reconciles.

That could be a good idea.

-derek

> On Sat, 4 Sept 2021 at 06:34, Borden via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
>>
>>
>> > The starting balance is computed from all the reconciled transactions
>> "to
>> > date".  It *can* be safe to ignore the starting balance if, for
>> example,
>> a
>> > transaction became unreconciled.  For example, let's say you reconcile
>> > from some starting balance X to a final balance of $1000.  Then you
>> > accidentally unreconcile a $100 transactions.  If you try to
>> re-reconcile
>> > that same statement/date/ending-balance of $1000, it won't show X as
>> the
>> > starting balance, but something else (PROBABLY $900, but I'm not 100%
>> > sure).  But that's okay -- just ensure the ending balance is correct
>> and
>> > all the transactions that SHOULD be reconciled ARE reconciled.
>> >
>> > There is no way to get a transaction to reconciled status (y) manually
>> --
>> > the only way is through a reconcile process.  So if you have
>> reconciled
>> > transactions, that must've happened through a reconcile.
>> >
>> > I would recommend you just go ahead with March, ignore the starting
>> > balance, enter the correct March ending balance, and see if the
>> > reconciliation works (ensure you re-reconcile anything from earlier
>> that
>> > might have become unreconciled).
>> >
>> So I just want to build a bit on this answer. GNUCash doesn't have QBs
>> reconciliation system - so don't equate the two. As an accountant who
>> doesn't need to be handheld or leashed, I  find GNUCash's system better
>> than QBs - albeit there is room for improvement. However, I wouldn't
>> recommend GNUCash to someone less comfortable with bare-ledger
>> accounting -
>> controls exist for a reason.
>>
>> I don't know how the backend works, but my experience is that the
>> "Opening
>> balance" is basically a running total of all the transactions marked
>> "Reconciled" in that account. Whereas QB will _prevent_ you from
>> attempting
>> to reconcile August if July's reconciled balance differs from what it
>> previously reconciled, GNUCash doesn't care - it just says "The
>> transactions marked 'Reconciled' for this account total to $X." And
>> that's
>> good for when you have to go back and fix things... and know what you're
>> doing.
>>
>> When you reconcile a transaction, again based on  my experience, GNUCash
>> toggles the "Reconciled" flag on the account _and_ inserts the
>> reconciliation date. I personally like this because  I can, say, start a
>> fresh reconciliation for March having reconciled through August  to pick
>> up
>> the transactions that _should_ have been in the March reconciliation but
>> weren't because I readded them (or whatever). However, I need  my
>> calculator with me because I need to adjust the "closing balance" to
>> reflect not the statement balance but what GNUCash's "running total"
>> balance should be. Contrast this to having to undo every rec in QB back
>> to
>> March and redo every rec again.
>>
>> Still, as I said, there's room for improvement in GNUCash:1) Since the
>> rec
>> date gets stored with the Rec flag, GNUCash can  have a function that
>> unreconciles every transaction before a given rec date. This would be
>> analogous to QB's batch rec undo.
>> 2) One should be able to rec from the ledger  as QB lets you do - and
>> prompt for a rec date. Yes it's dangerous, poor practice, etc., but the
>> GNU
>> philosophy is not to leash the user. If a user wants to sudo rm -rf /
>> their
>> installation, GNU warns them first, but ultimately lets them. User knows
>> best. If you want your computer to dictate what you're allowed to do
>> with
>> it, that's what Apple's for.
>>
>> I hope that helps a bit
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> 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
> If you are using Nabble 

Re: [GNC] Redo account reconciliations

[Christopher Lam]

I agree that if an account reconciliation is done periodically correctly
every time, then it works well. If an old reconciled split is unreconciled
and we need to re-reconcile a previous reconciliation date, then the code
falls apart.

It may be an idea to allow batch unreconciliation of all splits whose
reconcile date is after the reconciliation date in the Reconciliation
dialog, thereby allowing the user to re-do reconciles.

On Sat, 4 Sept 2021 at 06:34, Borden via gnucash-user <
gnucash-user@gnucash.org> wrote:

>
>
> > The starting balance is computed from all the reconciled transactions "to
> > date".  It *can* be safe to ignore the starting balance if, for example,
> a
> > transaction became unreconciled.  For example, let's say you reconcile
> > from some starting balance X to a final balance of $1000.  Then you
> > accidentally unreconcile a $100 transactions.  If you try to re-reconcile
> > that same statement/date/ending-balance of $1000, it won't show X as the
> > starting balance, but something else (PROBABLY $900, but I'm not 100%
> > sure).  But that's okay -- just ensure the ending balance is correct and
> > all the transactions that SHOULD be reconciled ARE reconciled.
> >
> > There is no way to get a transaction to reconciled status (y) manually --
> > the only way is through a reconcile process.  So if you have reconciled
> > transactions, that must've happened through a reconcile.
> >
> > I would recommend you just go ahead with March, ignore the starting
> > balance, enter the correct March ending balance, and see if the
> > reconciliation works (ensure you re-reconcile anything from earlier that
> > might have become unreconciled).
> >
> So I just want to build a bit on this answer. GNUCash doesn't have QBs
> reconciliation system - so don't equate the two. As an accountant who
> doesn't need to be handheld or leashed, I  find GNUCash's system better
> than QBs - albeit there is room for improvement. However, I wouldn't
> recommend GNUCash to someone less comfortable with bare-ledger accounting -
> controls exist for a reason.
>
> I don't know how the backend works, but my experience is that the "Opening
> balance" is basically a running total of all the transactions marked
> "Reconciled" in that account. Whereas QB will _prevent_ you from attempting
> to reconcile August if July's reconciled balance differs from what it
> previously reconciled, GNUCash doesn't care - it just says "The
> transactions marked 'Reconciled' for this account total to $X." And that's
> good for when you have to go back and fix things... and know what you're
> doing.
>
> When you reconcile a transaction, again based on  my experience, GNUCash
> toggles the "Reconciled" flag on the account _and_ inserts the
> reconciliation date. I personally like this because  I can, say, start a
> fresh reconciliation for March having reconciled through August  to pick up
> the transactions that _should_ have been in the March reconciliation but
> weren't because I readded them (or whatever). However, I need  my
> calculator with me because I need to adjust the "closing balance" to
> reflect not the statement balance but what GNUCash's "running total"
> balance should be. Contrast this to having to undo every rec in QB back to
> March and redo every rec again.
>
> Still, as I said, there's room for improvement in GNUCash:1) Since the rec
> date gets stored with the Rec flag, GNUCash can  have a function that
> unreconciles every transaction before a given rec date. This would be
> analogous to QB's batch rec undo.
> 2) One should be able to rec from the ledger  as QB lets you do - and
> prompt for a rec date. Yes it's dangerous, poor practice, etc., but the GNU
> philosophy is not to leash the user. If a user wants to sudo rm -rf / their
> installation, GNU warns them first, but ultimately lets them. User knows
> best. If you want your computer to dictate what you're allowed to do with
> it, that's what Apple's for.
>
> I hope that helps a bit
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How To Create Online Backup Of Data

[muhammad Noman]

Dear Sir,

 I want to know how can i create backup of my data while using
gnucash software version 2.6.18


Regards,

Muhammad Nouman


Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Redo account reconciliations

[Borden via gnucash-user]

> The starting balance is computed from all the reconciled transactions "to
> date".  It *can* be safe to ignore the starting balance if, for example, a
> transaction became unreconciled.  For example, let's say you reconcile
> from some starting balance X to a final balance of $1000.  Then you
> accidentally unreconcile a $100 transactions.  If you try to re-reconcile
> that same statement/date/ending-balance of $1000, it won't show X as the
> starting balance, but something else (PROBABLY $900, but I'm not 100%
> sure).  But that's okay -- just ensure the ending balance is correct and
> all the transactions that SHOULD be reconciled ARE reconciled.
>
> There is no way to get a transaction to reconciled status (y) manually --
> the only way is through a reconcile process.  So if you have reconciled
> transactions, that must've happened through a reconcile.
>
> I would recommend you just go ahead with March, ignore the starting
> balance, enter the correct March ending balance, and see if the
> reconciliation works (ensure you re-reconcile anything from earlier that
> might have become unreconciled).
>
So I just want to build a bit on this answer. GNUCash doesn't have QBs 
reconciliation system - so don't equate the two. As an accountant who doesn't 
need to be handheld or leashed, I  find GNUCash's system better than QBs - 
albeit there is room for improvement. However, I wouldn't recommend GNUCash to 
someone less comfortable with bare-ledger accounting - controls exist for a 
reason.

I don't know how the backend works, but my experience is that the "Opening 
balance" is basically a running total of all the transactions marked 
"Reconciled" in that account. Whereas QB will _prevent_ you from attempting to 
reconcile August if July's reconciled balance differs from what it previously 
reconciled, GNUCash doesn't care - it just says "The transactions marked 
'Reconciled' for this account total to $X." And that's good for when you have 
to go back and fix things... and know what you're doing.

When you reconcile a transaction, again based on  my experience, GNUCash 
toggles the "Reconciled" flag on the account _and_ inserts the reconciliation 
date. I personally like this because  I can, say, start a fresh reconciliation 
for March having reconciled through August  to pick up the transactions that 
_should_ have been in the March reconciliation but weren't because I readded 
them (or whatever). However, I need  my calculator with me because I need to 
adjust the "closing balance" to reflect not the statement balance but what 
GNUCash's "running total" balance should be. Contrast this to having to undo 
every rec in QB back to March and redo every rec again.

Still, as I said, there's room for improvement in GNUCash:1) Since the rec date 
gets stored with the Rec flag, GNUCash can  have a function that unreconciles 
every transaction before a given rec date. This would be analogous to QB's 
batch rec undo.
2) One should be able to rec from the ledger  as QB lets you do - and prompt 
for a rec date. Yes it's dangerous, poor practice, etc., but the GNU philosophy 
is not to leash the user. If a user wants to sudo rm -rf / their installation, 
GNU warns them first, but ultimately lets them. User knows best. If you want 
your computer to dictate what you're allowed to do with it, that's what Apple's 
for.

I hope that helps a bit
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.