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
<mahon.fin...@neuf.fr> 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
<mahon.fin...@neuf.fr> <mailto:mahon.fin...@neuf.fr> 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
<mahon.fin...@neuf.fr <mailto:mahon.fin...@neuf.fr>> wrote:
No, as I said in the original post, I started on 1.1.2018
with GNU, so the first entry in this a/c should be the
opening balance for the a/c from the bank statement,
€3986.22. The ending balance is correct.
Actually you still haven't stated it clearly. The question
is what does the Opening Balance show when you reconcile? If
this is the first time you have reconciled it then it should
show zero (unless the opening balance has been already
reconciled). If it is not zero then that means some
transactions have already been reconciled (possibly
accidentally). If you go to the account and then View >
Filter By > Status > Reconciled then it should show you just
the reconciled transactions. Clear the reconcile state on
all these and you should be good to start the reconcile with
a starting balance of zero. Then the Opening Balance in the
account should match the Starting Balance on your bank
statement so you can reconcile that one.
Colin
Finbar
On 26/01/2019 18:12, Colin Law wrote:
Do the starting and ending balances shown there match
the ones on the bank statement you are reconciling against?
Colin
On Sat, 26 Jan 2019 at 11:51, Finbar Mahon
<mahon.fin...@neuf.fr <mailto:mahon.fin...@neuf.fr>> wrote:
I don't understand where you are seeing the figures you
describe. Can
you post a screenshot showing it?
This what I get at the bottom right hand side.
_______________________________________________
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.
