Re: [GNC] undo needed, was Re: Reconciliation is not adding up correctly

[David Cousens]

Elmar,

Perhaps a strategy to try when you find a transaction in an account you are
reconciling which does not belong in that account is to change the split to
the account you are reconciling to the Imbalance account rather than
deleting the transaction. This allows you to complete the reconciliation and
the presence of the transaction to the Imbalance account flags that it needs
some examination to determine which account the split should have been
assigned to. If you then find that it is a duplicate or mistake it can then
be deleted. I retain any transactions like this in the Imbalance until my
bank accounts, credit card and paypal account have all been reconciled for
the same period then only delete them when I am sure it is an error.

An undo facility is more than likely a no-no from an accounting perspective.
If an accountant finds a mistake usually he will apply an adjusting
transaction duly annotated to correct the mistake, particularly where the
mistake might be in a previous period as this provides an audit trail and
auditors won't like transactions which have been changed without good reason
if they detect them. This isn't important for personal finances obviously.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] undo needed, was Re: Reconciliation is not adding up correctly

[David Carlson]

Elmar,

True, but if you have been keeping backups you can open a backup file
simultaneously with your data file, find the eroneously deleted
transaction, copy it [Transaction > Copy], return to the main file and
paste it back in [Transaction > Paste Transaction].

I do this a few times each year when I screw up.

Warning!  when you do this, close the backup file before closing the main
file, to avoid corrupting certain settings or accidentally switching to the
backup the next time you open GnuCash.

On Wed, Jan 30, 2019 at 12:32 PM Elmar  wrote:

> I bet the ability to  have a few levels of "undo" is on the desired
> enhancements list, no?  I certainly have cursed a few times when I hit
> delete by mistake.
>
> - Elmar
>
> On 1/30/19 12:00 PM, gnucash-user-requ...@gnucash.org wrote:
> > Message: 9 Date: Wed, 30 Jan 2019 12:17:20 + From: Colin Law  > <
> clan...@gmail.com> ... Once you have deleted a transaction then it
>  > is gone, so you won't be able to find it in by filtering.
> ___
> 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] undo needed, was Re: Reconciliation is not adding up correctly

[Elmar]

I bet the ability to  have a few levels of "undo" is on the desired 
enhancements list, no?  I certainly have cursed a few times when I hit 
delete by mistake.


- Elmar

On 1/30/19 12:00 PM, gnucash-user-requ...@gnucash.org wrote:
Message: 9 Date: Wed, 30 Jan 2019 12:17:20 + From: Colin Law  >  ... Once you have deleted a transaction then it 

> is gone, so you won't be able to find it in by filtering.
___
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] Reconciliation is not adding up correctly - what t

[Colin Law]

For the future, if you attempt to amend or delete a reconciled
transaction then you should get a warning and confirmation request. So
you should not be able to do it accidentally.  This can be disabled
however.  To make sure you have not disabled it then you can use
Actions > Reset Warnings to re-enable them.

Once you have deleted a transaction then it is gone, so you won't be
able to find it in by filtering.
It may be worth going back and looking at your backups from earlier if
you think you may have deleted some transactions before the date you
mentioned.

Colin

Colin

On Wed, 30 Jan 2019 at 12:00, Finbar Mahon  wrote:
>
> Thanks for all that. There may have been some transactions before
> 28.12.2017 which 'snuck' in and were deleted, that is possible and might
> explain the non zero start point.
>
> I saw in another post a query on whether a filtered view could show
> deleted transaction, if there is a possibility I may be able to find the
> 'culprits'
>
> Apropos the centimes, I appreciate your point, but I can use the option
> to enter a reconciliation amendment to cover them
>
> As I said, I'll soldier on with the view option and hopefully find the
> errors. I have made a new years resolution to do reconciliations more
> often :-)
>
> Many, many thanks for the observations and advice.
>
> Finbar
>
> On 29/01/2019 12:59, David T. wrote:
> > Finbar,
> >
> > On Tue, Jan 29, 2019 at 16:54, Finbar Mahon
> >  wrote:
> >
> > 2. For this particular a/c the figure €3986.22 is the balance in
> > the a/c, taken from the bank statement on 28.12.2017, after the
> > last transaction on that date.
> >
> > That clarifies this issue.  You created a transaction in the
> > amount of 3986.22, presumably from Equity into Checking.
> >
> > Did you perform any reconciliation at this point?
> >
> > 3. I had a non-zero opening balance, in the sense that I created
> > (named) the a/c in Gnucash and then started with the figure above,
> > so that I could continue from the previous a/c into 2018. Should I
> > have ignored the opening balance, the amount in the bank on
> > 28.12.2017??
> >
> > No, entering an opening balance transaction is necessary for
> > practically everything.  It's what happens at reconciliation that
> > is messed up...
> >
> > 5. The numbers on the screen grab are exactly what my problem is.
> >
> > And I agree, but probably not for the same reason as you. My
> > problem is that your reconcile window shows a non zero starting
> > balance.  Gnucash calculates this amount from the transaction data
> > directly, counting up all the transactions that have been
> > reconciled before. So, the first time you reconcile an account, it
> > should be zero. (Indeed, the first reconciliation starting balance
> > merits a specific mention in the Guide)
> >
> > The fact that your window shows something else there means that
> > there is something else going on.
> >
> >  I appreciate that a 'perfect' reconciliation should have no
> > 'loose' centimes, but if the figures are within that sort of
> > limit, I don't worry, I am not auditing a multinational.
> >
> > Again, while it might not bother you, Gnucash will not allow you
> > to finish reconciliation until the numbers match exactly.
> >
> >
> > Thanks again for your patience.
> >
> > Finbar
> >
> >
> >
> > On 28/01/2019 13:12, David T. wrote:
> > There is a lot to unpack here.
> >
> > You say you started at the beginning of 2018 and entered "the
> > closing balance for 2017.
> >>
> >> Was that balance taken from a statement? Or just from the bank
> >> website as of that date?
> >>
> >> I can't see how any of the various numbers (the numbers on the
> >> screen grab or provided in your message) could be combined to
> >> balance out. And where does this 3986.22 figure come from?
> >>
> >> Next, if this truly is your first reconciliation, how is it that
> >> you have a non zero opening balance? Gnucash derives this number
> >> by taking all entries that were previously reconciled. So maybe
> >> you reconciled something already?
> >>
> >> Finally, you will not be able to reconcile your account if it's
> >> inaccurate by even "a few centimes." Gnucash insists on a full
> >> match in amount before it allows you to complete the process.
> >> So, you will need to address those as well.
> >>
> >> Figure out why Gnucash shows a non zero opening balance and clean
> >> up the erroneous transactions, and see where that puts you.
> >>
> >> David
> >>
> >> On Mon, Jan 28, 2019 at 15:53, Finbar Mahon
> >>   wrote:
> >>
> >> OK,
> >>
> >> As I said, I started on 1.1.2018 with 'nothing' I entered the
> >> closing balance for 2017 for the a/c and started entering
> >> transactions.
> >>
> >>

Re: [GNC] Reconciliation is not adding up correctly - what t

[Finbar Mahon]

Thanks for all that. There may have been some transactions before 
28.12.2017 which 'snuck' in and were deleted, that is possible and might 
explain the non zero start point.


I saw in another post a query on whether a filtered view could show 
deleted transaction, if there is a possibility I may be able to find the 
'culprits'


Apropos the centimes, I appreciate your point, but I can use the option 
to enter a reconciliation amendment to cover them


As I said, I'll soldier on with the view option and hopefully find the 
errors. I have made a new years resolution to do reconciliations more 
often :-)


Many, many thanks for the observations and advice.

Finbar

On 29/01/2019 12:59, David T. wrote:

Finbar,

On Tue, Jan 29, 2019 at 16:54, Finbar Mahon
 wrote:

2. For this particular a/c the figure €3986.22 is the balance in
the a/c, taken from the bank statement on 28.12.2017, after the
last transaction on that date.

That clarifies this issue.  You created a transaction in the
amount of 3986.22, presumably from Equity into Checking.

Did you perform any reconciliation at this point?

3. I had a non-zero opening balance, in the sense that I created
(named) the a/c in Gnucash and then started with the figure above,
so that I could continue from the previous a/c into 2018. Should I
have ignored the opening balance, the amount in the bank on
28.12.2017??

No, entering an opening balance transaction is necessary for
practically everything.  It's what happens at reconciliation that
is messed up...

5. The numbers on the screen grab are exactly what my problem is.

And I agree, but probably not for the same reason as you. My
problem is that your reconcile window shows a non zero starting
balance.  Gnucash calculates this amount from the transaction data
directly, counting up all the transactions that have been
reconciled before. So, the first time you reconcile an account, it
should be zero. (Indeed, the first reconciliation starting balance
merits a specific mention in the Guide)

The fact that your window shows something else there means that
there is something else going on.

 I appreciate that a 'perfect' reconciliation should have no
'loose' centimes, but if the figures are within that sort of
limit, I don't worry, I am not auditing a multinational.

Again, while it might not bother you, Gnucash will not allow you
to finish reconciliation until the numbers match exactly.


Thanks again for your patience.

Finbar



On 28/01/2019 13:12, David T. wrote:
There is a lot to unpack here.

You say you started at the beginning of 2018 and entered "the
closing balance for 2017.


Was that balance taken from a statement? Or just from the bank
website as of that date?

I can't see how any of the various numbers (the numbers on the
screen grab or provided in your message) could be combined to
balance out. And where does this 3986.22 figure come from?

Next, if this truly is your first reconciliation, how is it that
you have a non zero opening balance? Gnucash derives this number
by taking all entries that were previously reconciled. So maybe
you reconciled something already?

Finally, you will not be able to reconcile your account if it's
inaccurate by even "a few centimes." Gnucash insists on a full
match in amount before it allows you to complete the process. 
So, you will need to address those as well.

Figure out why Gnucash shows a non zero opening balance and clean
up the erroneous transactions, and see where that puts you.

David

On Mon, Jan 28, 2019 at 15:53, Finbar Mahon
  wrote:

OK,

As I said, I started on 1.1.2018 with 'nothing' I entered the
closing balance for 2017 for the a/c and started entering
transactions.

Unfortunately, coming from Quicken, I didn't do any
reconciliations until about December. But casually examining
the entries from time to time they seemed 'ok' just a few
centimes 'off' probably due to finger problems, as I had also
experienced with Quicken and sorted them at year end.

The Opening Balance in the latest iteration of reconcile was
what I showed in the screen grab a while back -

While the a/c entries starting entry shows the bank balance
figure €3986.22 and the €5.117.09 ending balance tallies with
the bank statement..

Aha, maybe there is another issue. When I do, as you
suggested,  View > Filter By > Status > Reconciled I get
nothing!! even when I just chose 'reconcile' or 'select all'

:-( thanks for the help :-)
:-)



On 27/01/2019 10:46, Colin Law wrote:
On Sun, 27 Jan 2019 at 09:36, Finbar Mahon
mailto:mahon.fin...@neuf.fr>> wrote:

 

Re: [GNC] Upgrade Path from version 2.6.16 on MacOS High Sierra (10.13.6) and beyond

[Michael Hendry]

> On 29 Jan 2019, at 18:50, John Ralls  wrote:
> 
> I just uploaded a new Gnucash-Intel-2.6.21-3.dmg to both SourceForge and 
> Github with a re-signed app. It validates successfully for me but I got a 
> different spctl error from Michael's.
> 
> I've also updated the SHA-256 (which changed anyway with the re-sign) and the 
> filename in both places.
> 
> Regards,
> John Ralls

Thanks, John.

I succeeded in downloading, installing and running 2.6.21-3 this morning.

When I ran it for the first time, I was warned (as expected) that it is a 
32-bit application.

Michael.
___
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.