Re: [GNC] Reconciliation with a strange opening balance
Another good idea. I went back to the start and sorted by Description, but nothing out of the ordinary. As we might expect the majority of entries are withdrawals, so the deposits are easier to see. Also, sorted by description sorts out if you put down the credit card payments or the pub expenditures in the wrong place!! Ho hum. Thanks for the suggestion. Barry On 15/11/2023 23:37, Liz wrote: On Wed, 15 Nov 2023 15:39:19 +0100 Mahon Finbar via gnucash-user wrote: Aha, as usual you are correct Maff. I'll just have to soldier on. I already found two deposits entered as withdrawals. Barry At this stage, consider how you could use the search feature to find these sort of errors. If the deposits have a unique description, search for that description in the account and then check that all the entries are in the appropriate column. Sadly the autocomplete features autocomplete errors equally as well as good work, so think about how you can get the accounts sorted out other than through the reconcile feature. liz ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciliation with a strange opening balance
On Wed, 15 Nov 2023 15:39:19 +0100 Mahon Finbar via gnucash-user wrote: > Aha, as usual you are correct Maff. I'll just have to soldier on. I > already found two deposits entered as withdrawals. > > Barry At this stage, consider how you could use the search feature to find these sort of errors. If the deposits have a unique description, search for that description in the account and then check that all the entries are in the appropriate column. Sadly the autocomplete features autocomplete errors equally as well as good work, so think about how you can get the accounts sorted out other than through the reconcile feature. liz ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciliation with a strange opening balance
On Wed, Nov 15, 2023, 3:55 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Sorry David, I messed up the quotation when trimming. That was Chris' > explanation of how GnuCash stores reconciliation info. > > Regards, > Adrien > > On 11/15/23 3:50 PM, David Carlson wrote: > > I agree that the reconciliation date is assigned to each transaction > split > > as it is reconciled. > > > > In Gmail I am unable to see where you found that conflicting information > in > > this thread, as I am sure that I made no suggestion otherwise. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciliation with a strange opening balance
Sorry David, I messed up the quotation when trimming. That was Chris' explanation of how GnuCash stores reconciliation info. Regards, Adrien On 11/15/23 3:50 PM, David Carlson wrote: I agree that the reconciliation date is assigned to each transaction split as it is reconciled. In Gmail I am unable to see where you found that conflicting information in this thread, as I am sure that I made no suggestion otherwise. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciliation with a strange opening balance
Adrien, I agree that the reconciliation date is assigned to each transaction split as it is reconciled. In Gmail I am unable to see where you found that conflicting information in this thread, as I am sure that I made no suggestion otherwise. On Wed, Nov 15, 2023, 2:55 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > On 11/15/23 10:07 AM, David Carlson wrote: > >>> - each split's reconciliation date (which is the same as the last > >>> Reconciliation date). > > I could be reading your comment oddly, but I'm pretty sure that this > date sticks. That is, it doesn't change for *every* already reconciled > split in the account each reconciliation. Otherwise the Reconciliation > Report would show all the same date, (making that column useless) and it > does not. > > But if you re-reconcile a split, then that date will change to whatever > new date you reconciled to, but just for those re-reconciled splits. > > Regards, > Adrien > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciliation with a strange opening balance
On 11/15/23 10:07 AM, David Carlson wrote: - each split's reconciliation date (which is the same as the last Reconciliation date). I could be reading your comment oddly, but I'm pretty sure that this date sticks. That is, it doesn't change for *every* already reconciled split in the account each reconciliation. Otherwise the Reconciliation Report would show all the same date, (making that column useless) and it does not. But if you re-reconcile a split, then that date will change to whatever new date you reconciled to, but just for those re-reconciled splits. Regards, Adrien ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciliation with a strange opening balance
My bank just this morning went through another iteration of fine tuning their procedures, which I have yet to process. However, I hope they still have monthly statements, whether mailed or only online to reconcile against. They may be identified only by account number and month, but so far they have been sufficiently immutable to be positively identified years later with an identifiable date interval for reconciliation .. On Wed, Nov 15, 2023 at 9:41 AM R Losey wrote: > I don't get statements with numbers to use - my checkbooks are reconciled > monthly to whatever the current online balance is, so what GnuCash does now > is just what I need. > > On Wed, Nov 15, 2023 at 8:27 AM Christopher Lam > > wrote: > > > A bit tangential to the issue of reconciliation is that fundamentally IMV > > reconciliation means to marry up (aka reconcile) the physical periodic > > (monthly/quarterly/annually) bank statements *against* your own books > which > > carry the canonical data which hopefully supports your financial > activity. > > > > Gnucash reconciliation only stores, for each reconciliation: > > > >- an account's last Reconciliation date > >- each split's reconciliation status n/c/y, > >- each split's reconciliation date (which is the same as the last > >Reconciliation date). > > > > It doesn't store other info such as: starting balance, statement number; > > and doesn't store the reconciled starting and ending balances. > > > > It *could* be transformed to store all these additional data: > > > >- statement ID number > >- statement's start and ending date > >- statement's start and ending balance > >- list of splits identified within the statement > > > > And would be somewhat more robust (ie you could ask gnucash to display > the > > contents of the feb2014 statement), and we would potentially be able to > > re-reconcile a previous statement (e.g. I deleted an old reconciled split > > in error and wish to re-reconcile its statement) but this would require a > > complete backward-incompatible upgrade in the internal data schema, there > > doesn't seem to be a demand of it, nor manpower to implement it, and I > > think it's simply overkill. > > > > Thus the reconciliation is currently limited to the state that exists > > currently. > > > > E > > > > On Mon, 13 Nov 2023, 11:21 pm Mahon Finbar via gnucash-user, < > > gnucash-user@gnucash.org> wrote: > > > > > Hello, > > > > > > The recent discussion on reconciliation was helpful in trying to sort > > > out some anomalies I have. > > > > > > When I do the latest reconciliation of one of my accounts the opening > > > balance is 10,448.43 and gives me an amount of inbalance which is way > > off. > > > > > > Following the advice in the recent posts I tried working backwards to > > > see if I could find any errors. > > > > > > I got close to 0.00 from time to time and was satisfied enough to > > > consider a balancing entry, but was intrigued on where the 'error' > might > > > have been. > > > > > > I set off to see where, but, in the course of my search, I tried to > find > > > the number 10,443.43 in the account, as a baseline, but didn't find > one. > > > > > > If I understand the process of reconciliation the number should be > > > somewhere in the account, should it not?? > > > > > > Just tell me I am barking up the wrong tree, if I am making an error. > > > > > > Finbar > > > > > > ___ > > > gnucash-user mailing list > > > gnucash-user@gnucash.org > > > To update your subscription preferences or to unsubscribe: > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > - > > > Please remember to CC this list on all your replies. > > > You can do this by using Reply-To-List or Reply-All. > > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > > > -- > _ > Richard Losey > rlo...@gmail.com > Micah 6:8 > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciliation with a strange opening balance
I don't get statements with numbers to use - my checkbooks are reconciled monthly to whatever the current online balance is, so what GnuCash does now is just what I need. On Wed, Nov 15, 2023 at 8:27 AM Christopher Lam wrote: > A bit tangential to the issue of reconciliation is that fundamentally IMV > reconciliation means to marry up (aka reconcile) the physical periodic > (monthly/quarterly/annually) bank statements *against* your own books which > carry the canonical data which hopefully supports your financial activity. > > Gnucash reconciliation only stores, for each reconciliation: > >- an account's last Reconciliation date >- each split's reconciliation status n/c/y, >- each split's reconciliation date (which is the same as the last >Reconciliation date). > > It doesn't store other info such as: starting balance, statement number; > and doesn't store the reconciled starting and ending balances. > > It *could* be transformed to store all these additional data: > >- statement ID number >- statement's start and ending date >- statement's start and ending balance >- list of splits identified within the statement > > And would be somewhat more robust (ie you could ask gnucash to display the > contents of the feb2014 statement), and we would potentially be able to > re-reconcile a previous statement (e.g. I deleted an old reconciled split > in error and wish to re-reconcile its statement) but this would require a > complete backward-incompatible upgrade in the internal data schema, there > doesn't seem to be a demand of it, nor manpower to implement it, and I > think it's simply overkill. > > Thus the reconciliation is currently limited to the state that exists > currently. > > E > > On Mon, 13 Nov 2023, 11:21 pm Mahon Finbar via gnucash-user, < > gnucash-user@gnucash.org> wrote: > > > Hello, > > > > The recent discussion on reconciliation was helpful in trying to sort > > out some anomalies I have. > > > > When I do the latest reconciliation of one of my accounts the opening > > balance is 10,448.43 and gives me an amount of inbalance which is way > off. > > > > Following the advice in the recent posts I tried working backwards to > > see if I could find any errors. > > > > I got close to 0.00 from time to time and was satisfied enough to > > consider a balancing entry, but was intrigued on where the 'error' might > > have been. > > > > I set off to see where, but, in the course of my search, I tried to find > > the number 10,443.43 in the account, as a baseline, but didn't find one. > > > > If I understand the process of reconciliation the number should be > > somewhere in the account, should it not?? > > > > Just tell me I am barking up the wrong tree, if I am making an error. > > > > Finbar > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciliation with a strange opening balance
Aha, as usual you are correct Maff. I'll just have to soldier on. I already found two deposits entered as withdrawals. Barry On 13/11/2023 16:40, Maf. King wrote: On Monday, 13 November 2023 15:20:28 GMT Mahon Finbar via gnucash-user wrote: I set off to see where, but, in the course of my search, I tried to find the number 10,443.43 in the account, as a baseline, but didn't find one. If I understand the process of reconciliation the number should be somewhere in the account, should it not?? or possibly ~5221.70 as a CR when it should be a DR (etc). or several smaller errors which total the ~10k discrepancy you are seeing Maf. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciliation with a strange opening balance
A bit tangential to the issue of reconciliation is that fundamentally IMV reconciliation means to marry up (aka reconcile) the physical periodic (monthly/quarterly/annually) bank statements *against* your own books which carry the canonical data which hopefully supports your financial activity. Gnucash reconciliation only stores, for each reconciliation: - an account's last Reconciliation date - each split's reconciliation status n/c/y, - each split's reconciliation date (which is the same as the last Reconciliation date). It doesn't store other info such as: starting balance, statement number; and doesn't store the reconciled starting and ending balances. It *could* be transformed to store all these additional data: - statement ID number - statement's start and ending date - statement's start and ending balance - list of splits identified within the statement And would be somewhat more robust (ie you could ask gnucash to display the contents of the feb2014 statement), and we would potentially be able to re-reconcile a previous statement (e.g. I deleted an old reconciled split in error and wish to re-reconcile its statement) but this would require a complete backward-incompatible upgrade in the internal data schema, there doesn't seem to be a demand of it, nor manpower to implement it, and I think it's simply overkill. Thus the reconciliation is currently limited to the state that exists currently. E On Mon, 13 Nov 2023, 11:21 pm Mahon Finbar via gnucash-user, < gnucash-user@gnucash.org> wrote: > Hello, > > The recent discussion on reconciliation was helpful in trying to sort > out some anomalies I have. > > When I do the latest reconciliation of one of my accounts the opening > balance is 10,448.43 and gives me an amount of inbalance which is way off. > > Following the advice in the recent posts I tried working backwards to > see if I could find any errors. > > I got close to 0.00 from time to time and was satisfied enough to > consider a balancing entry, but was intrigued on where the 'error' might > have been. > > I set off to see where, but, in the course of my search, I tried to find > the number 10,443.43 in the account, as a baseline, but didn't find one. > > If I understand the process of reconciliation the number should be > somewhere in the account, should it not?? > > Just tell me I am barking up the wrong tree, if I am making an error. > > Finbar > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciliation with a strange opening balance
While "Finding reconciliation discrepancies from previous statements can be
extremely tedious and GnuCash doesn't have any tools to help. There's not
even a way to display historical reconciled balances." is correct, the Banks
(and by their proxy their Information Systems) have stepped up and have
gotten to the point where their online portals (that is if you have signed
up for it) have very good filtering capabilities when it comes to displaying
transactions by date range. In the US the Banks are required to keep 7 years
of statement available, and most banks now do very good job to getting them
to you at a moment's notice.
Here is what I do that has worked well for me:
If there were any unintended entries gotten added after reconcile ('y' or
'c') then they normally appear as unreconciled ('n') which you can filter by
that status in the register (assuming that you normally reconcile accounts
like Bank, Credit Card and/or Investment accounts). This is likely to be
able to flag it down very quickly. If your last reconciled register suddenly
appears out-of-sync with respect to bank statement then review previous
statement(s). Check the beginning and ending balance of previous statements
and if they do not match then go back one more statement and compare. Rinse
and repeat until you get to the statement that actually matches. Your
culprit is likely to be somewhere in the statement following the one that
matches. Use the previous step of transaction status to locate the errant
entry and then correct as necessary.
-Original Message-
From: john
Sent: Monday, November 13, 2023 3:55 PM
To: Mahon Finbar
Cc: Gnucash Users
Subject: Re: [GNC] Reconciliation with a strange opening balance
> On Nov 13, 2023, at 07:20, Mahon Finbar via gnucash-user
wrote:
>
> Hello,
>
> The recent discussion on reconciliation was helpful in trying to sort out
some anomalies I have.
>
> When I do the latest reconciliation of one of my accounts the opening
balance is 10,448.43 and gives me an amount of inbalance which is way off.
>
> Following the advice in the recent posts I tried working backwards to see
if I could find any errors.
>
> I got close to 0.00 from time to time and was satisfied enough to consider
a balancing entry, but was intrigued on where the 'error' might have been.
>
> I set off to see where, but, in the course of my search, I tried to find
the number 10,443.43 in the account, as a baseline, but didn't find one.
>
> If I understand the process of reconciliation the number should be
somewhere in the account, should it not??
>
> Just tell me I am barking up the wrong tree, if I am making an error.
The reconcile info dialog that comes up when you click the reconcile button
has two balances: Starting balance and Ending balance. The first is the
reconciled balance for the account, that is the sum of all of the splits in
the account marked as reconciled. That's different from the opening balance,
which is the amount in the account when you created it in GnuCash. The
starting balance should match the starting balance on your statement. If it
doesn't then there's a mistake in reconciling a previous statement and you
need to either make a correcting entry in your account to get it to match or
dig through previous statements to try to find the discrepancy. The Ending
balance is what you should enter from your account statement or your bank's
website. It defaults to the balance of the last transaction on the date you
entered in the Reconciliation date entry.
When you finish that dialog the reconcile window opens and in the lower left
it shows the balances from the info window followed by Reconciled balance
and Difference, which update as you tick off transactions in the two panes
of the window; you should tick off the transactions that match your
statement, paying close attention to the amounts: Reconciliation is all
about making sure that there aren't any differences. Fix any differences in
the register and press enter to commit the change and it will be immediately
reflected in the reconcile window. Once you have marked all of the
transactions the Ending and Reconciled balances should match, Difference
should be 0, and the Finish button in the toolbar should be enabled.
You might not have a transaction balance matching the reconciled balance if
you have unbalanced transactions previous to the last reconciled one. The
"R" column between Transfer Account and Debit/Deposit shows each
transaction's reconciled status: y for reconciled, n for unreconciled, c for
cleared, and v for voided. You can use the the Status page of View>Filter
By... to hide transactions by status.
Finding reconciliation discrepancies from previous statements can be
extremely tedious and GnuCash doesn't have any tools to help. There's not
even a way to display historical reconciled balances.
When it comes to fixing discrepancies remember that bank
Re: [GNC] Reconciliation with a strange opening balance
If you remember that the reconciliation endting balance was correct in GnuCash fairly recently a process that will actually work would be to unreconcile all transaction splits after a given date, then re-reconciling each month after that date with your bank statements handy. To go back more than a few months would be incredibly tedious. If you try this it would be wise to make a working copy of your data file rather than use your real data file. Remember that it is possible that one or more transaction splits having any date may have been deleted, changed or re-assigned to a different account, and those may be rather hard to find. Another possibility would be if there are months when the running balance matches the bank statement exactly... On Mon, Nov 13, 2023 at 2:56 PM john wrote: > > > > On Nov 13, 2023, at 07:20, Mahon Finbar via gnucash-user < > gnucash-user@gnucash.org> wrote: > > > > Hello, > > > > The recent discussion on reconciliation was helpful in trying to sort > out some anomalies I have. > > > > When I do the latest reconciliation of one of my accounts the opening > balance is 10,448.43 and gives me an amount of inbalance which is way off. > > > > Following the advice in the recent posts I tried working backwards to > see if I could find any errors. > > > > I got close to 0.00 from time to time and was satisfied enough to > consider a balancing entry, but was intrigued on where the 'error' might > have been. > > > > I set off to see where, but, in the course of my search, I tried to find > the number 10,443.43 in the account, as a baseline, but didn't find one. > > > > If I understand the process of reconciliation the number should be > somewhere in the account, should it not?? > > > > Just tell me I am barking up the wrong tree, if I am making an error. > > The reconcile info dialog that comes up when you click the reconcile > button has two balances: Starting balance and Ending balance. The first is > the reconciled balance for the account, that is the sum of all of the > splits in the account marked as reconciled. That's different from the > opening balance, which is the amount in the account when you created it in > GnuCash. The starting balance should match the starting balance on your > statement. If it doesn't then there's a mistake in reconciling a previous > statement and you need to either make a correcting entry in your account to > get it to match or dig through previous statements to try to find the > discrepancy. The Ending balance is what you should enter from your account > statement or your bank's website. It defaults to the balance of the last > transaction on the date you entered in the Reconciliation date entry. > > When you finish that dialog the reconcile window opens and in the lower > left it shows the balances from the info window followed by Reconciled > balance and Difference, which update as you tick off transactions in the > two panes of the window; you should tick off the transactions that match > your statement, paying close attention to the amounts: Reconciliation is > all about making sure that there aren't any differences. Fix any > differences in the register and press enter to commit the change and it > will be immediately reflected in the reconcile window. Once you have > marked all of the transactions the Ending and Reconciled balances should > match, Difference should be 0, and the Finish button in the toolbar should > be enabled. > > You might not have a transaction balance matching the reconciled balance > if you have unbalanced transactions previous to the last reconciled one. > The "R" column between Transfer Account and Debit/Deposit shows each > transaction's reconciled status: y for reconciled, n for unreconciled, c > for cleared, and v for voided. You can use the the Status page of > View>Filter By... to hide transactions by status. > > Finding reconciliation discrepancies from previous statements can be > extremely tedious and GnuCash doesn't have any tools to help. There's not > even a way to display historical reconciled balances. > > When it comes to fixing discrepancies remember that banks can make errors > too, but you need documentation and time to get the bank to make > corrections. It's up to you to decide whether to pursue getting the bank to > fix their mistake or to take the hit and adjust your accounts to match the > bank's. > > Regards, > John Ralls > > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:
Re: [GNC] Reconciliation with a strange opening balance
> On Nov 13, 2023, at 07:20, Mahon Finbar via gnucash-user > wrote: > > Hello, > > The recent discussion on reconciliation was helpful in trying to sort out > some anomalies I have. > > When I do the latest reconciliation of one of my accounts the opening balance > is 10,448.43 and gives me an amount of inbalance which is way off. > > Following the advice in the recent posts I tried working backwards to see if > I could find any errors. > > I got close to 0.00 from time to time and was satisfied enough to consider a > balancing entry, but was intrigued on where the 'error' might have been. > > I set off to see where, but, in the course of my search, I tried to find the > number 10,443.43 in the account, as a baseline, but didn't find one. > > If I understand the process of reconciliation the number should be somewhere > in the account, should it not?? > > Just tell me I am barking up the wrong tree, if I am making an error. The reconcile info dialog that comes up when you click the reconcile button has two balances: Starting balance and Ending balance. The first is the reconciled balance for the account, that is the sum of all of the splits in the account marked as reconciled. That's different from the opening balance, which is the amount in the account when you created it in GnuCash. The starting balance should match the starting balance on your statement. If it doesn't then there's a mistake in reconciling a previous statement and you need to either make a correcting entry in your account to get it to match or dig through previous statements to try to find the discrepancy. The Ending balance is what you should enter from your account statement or your bank's website. It defaults to the balance of the last transaction on the date you entered in the Reconciliation date entry. When you finish that dialog the reconcile window opens and in the lower left it shows the balances from the info window followed by Reconciled balance and Difference, which update as you tick off transactions in the two panes of the window; you should tick off the transactions that match your statement, paying close attention to the amounts: Reconciliation is all about making sure that there aren't any differences. Fix any differences in the register and press enter to commit the change and it will be immediately reflected in the reconcile window. Once you have marked all of the transactions the Ending and Reconciled balances should match, Difference should be 0, and the Finish button in the toolbar should be enabled. You might not have a transaction balance matching the reconciled balance if you have unbalanced transactions previous to the last reconciled one. The "R" column between Transfer Account and Debit/Deposit shows each transaction's reconciled status: y for reconciled, n for unreconciled, c for cleared, and v for voided. You can use the the Status page of View>Filter By... to hide transactions by status. Finding reconciliation discrepancies from previous statements can be extremely tedious and GnuCash doesn't have any tools to help. There's not even a way to display historical reconciled balances. When it comes to fixing discrepancies remember that banks can make errors too, but you need documentation and time to get the bank to make corrections. It's up to you to decide whether to pursue getting the bank to fix their mistake or to take the hit and adjust your accounts to match the bank's. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciliation with a strange opening balance
One of several complications that you can run into when searching for a reconciliation error by using the reconciliation tool is that GnuCash leaves all previously reconciled split lines assigned to the target account reconciled. Thus if there are reconciled split lines dated after the reconciliation date, they remain reconciled during your search and will be included in the beginning balance calculation. Recent releases of GnuCash do include a reconciliation report, but I have never used it, so I cannot say how useful it might be in a search for errors. On Mon, Nov 13, 2023 at 9:41 AM Maf. King wrote: > On Monday, 13 November 2023 15:20:28 GMT Mahon Finbar via gnucash-user > wrote: > > > > > I set off to see where, but, in the course of my search, I tried to find > > the number 10,443.43 in the account, as a baseline, but didn't find one. > > > > If I understand the process of reconciliation the number should be > > somewhere in the account, should it not?? > > > > or possibly ~5221.70 as a CR when it should be a DR (etc). or several > smaller > errors which total the ~10k discrepancy you are seeing > > Maf. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciliation with a strange opening balance
On Monday, 13 November 2023 15:20:28 GMT Mahon Finbar via gnucash-user wrote: > > I set off to see where, but, in the course of my search, I tried to find > the number 10,443.43 in the account, as a baseline, but didn't find one. > > If I understand the process of reconciliation the number should be > somewhere in the account, should it not?? > or possibly ~5221.70 as a CR when it should be a DR (etc). or several smaller errors which total the ~10k discrepancy you are seeing Maf. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Reconciliation with a strange opening balance
Hello, The recent discussion on reconciliation was helpful in trying to sort out some anomalies I have. When I do the latest reconciliation of one of my accounts the opening balance is 10,448.43 and gives me an amount of inbalance which is way off. Following the advice in the recent posts I tried working backwards to see if I could find any errors. I got close to 0.00 from time to time and was satisfied enough to consider a balancing entry, but was intrigued on where the 'error' might have been. I set off to see where, but, in the course of my search, I tried to find the number 10,443.43 in the account, as a baseline, but didn't find one. If I understand the process of reconciliation the number should be somewhere in the account, should it not?? Just tell me I am barking up the wrong tree, if I am making an error. Finbar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
