Re: [GNC] Reconciliation Roll Back

2024-05-30 Thread R Losey
I'll add a "me, too" - I had no idea that this was available until I saw it here. Very nice! On Wed, May 29, 2024 at 8:15 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > And I learn something new everyday. Thanks David! > > Regards, > Adrien > > On 5/28/24 9:17 AM, David Carlson

Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)

2024-05-30 Thread Liz
On Thu, 30 May 2024 12:14:08 +0300 sunfish62--- via gnucash-user wrote: > With all due respect, most of the issues raised by Peter are covered > in some way in section 2.9.4 of the Guide, especially in the notes > and warnings embedded there. > > A deeper exploration of the different methods a

Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)

2024-05-30 Thread sunfish62--- via gnucash-user
With all due respect, most of the issues raised by Peter are covered in some way in section 2.9.4 of the Guide, especially in the notes and warnings embedded there. A deeper exploration of the different methods a user can implement to recover from some of these more challenging situations

Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)

2024-05-30 Thread G R Hewitt
lace the rest of the reconciliation > was correct to the penny. > > Thanks for all the help. > > Best wishes > > Pete > > -- Original Message -- > From: hell...@gmail.com > To: p.f.cuthb...@btinternet.com Cc: gnucash-user@gnucash.org; > blake.hannaf...@

Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)

2024-05-29 Thread Liz
On Wed, 29 May 2024 22:54:26 -0400 NoobAlice wrote: > On 2024-05-29 04:39 PM, Peter Cuthbert via gnucash-user wrote: > > > The dates associated with the reconciled/not reconciled flag struck > > me as an easy way to do a roll back without using the backups. > > Something along the lines of if

Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)

2024-05-29 Thread NoobAlice
On 2024-05-29 04:39 PM, Peter Cuthbert via gnucash-user wrote: The dates associated with the reconciled/not reconciled flag struck me as an easy way to do a roll back without using the backups.  Something along the lines of if date = [specified reconciliation date] then flag = n (I have no

Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)

2024-05-29 Thread Adrien Monteleone
You don't need to roll back a reconciliation that is now out of whack. If need be, un-reconcile that transaction split, then re-reconcile. Regards, Adrien On 5/29/24 8:33 AM, Peter Cuthbert via gnucash-user wrote: So final thought for the GNUCash programmers.  Please consider a 'roll back'

Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)

2024-05-29 Thread Adrien Monteleone
GnuCash is supposed to warn you when editing a reconciled transaction that would change the flag. If not, perhaps you turned that message off. Check Actions > Reset Warnings and look for something like "change contents of reconciled split". If it is there, select it and Apply to reset the

Re: [GNC] Reconciliation Roll Back

2024-05-29 Thread Adrien Monteleone
And I learn something new everyday. Thanks David! Regards, Adrien On 5/28/24 9:17 AM, David Carlson wrote: A tidbit of information that you may find helpful: If you hover the mouse over the "y" character in the reconcile box in an account split line, the date of the reconciliation for that

Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)

2024-05-29 Thread Peter Cuthbert via gnucash-user
  -- Original Message -- From: hell...@gmail.com To: p.f.cuthb...@btinternet.com Cc: gnucash-user@gnucash.org; blake.hannaf...@gmail.com Sent: Wednesday, May 29th 2024, 21:01 Subject: Re: [GNC] Reconciliation Roll Back (Peter Cuthbert) Peter, The roll back facility is already there and has been

Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)

2024-05-29 Thread Michael or Penny Novack
Useful hint (when making backups, any, not just gnucash) My suggestion would be to take a copy of your actual data file and put it somewhere safe before you do anything further Remove any uncertainty about what back-up is which. Include the Julian date in the name of the file. Thus if I were

Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)

2024-05-29 Thread David H
e one has entered is not what the system > holds. If that happened one would not go ahead with the reconciliation, > but go back and look for obvious mistakes. > > Best wishes > > Pete > > -- Original Message -- > From: gnucash-user@gnucash.org > To: blake.hann

Re: [GNC] Reconciliation Roll Back

2024-05-29 Thread Adam Funk
On 2024-05-28, David Carlson wrote: > A tidbit of information that you may find helpful: If you hover the mouse > over the "y" character in the reconcile box in an account split line, the > date of the reconciliation for that account split in that transaction > appears in a flyover. It may take

Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)

2024-05-29 Thread Derek Atkins
istakes. >   > Best wishes >   > Pete >   > -- Original Message -- > From: gnucash-user@gnucash.org > To: blake.hannaf...@gmail.com Cc: gnucash-user@gnucash.org > Sent: Tuesday, May 28th 2024, 21:40 > Subject: Re: [GNC] Reconciliation Roll Back (Peter Cuthbert) &

Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)

2024-05-29 Thread Peter Cuthbert via gnucash-user
-- From: gnucash-user@gnucash.org To: blake.hannaf...@gmail.com Cc: gnucash-user@gnucash.org Sent: Tuesday, May 28th 2024, 21:40 Subject: Re: [GNC] Reconciliation Roll Back (Peter Cuthbert) Generally, I find that transactions ONLY get dereconciled due to an action I have taken-- like changing some

Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)

2024-05-28 Thread sunfish62--- via gnucash-user
Generally, I find that transactions ONLY get dereconciled due to an action I have taken-- like changing some element of said transaction. They don't just "get unreconciled"-- at least, not for me. There was a short period of time where the app was very strict about when a transaction was

Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)

2024-05-28 Thread Blake Hannaford
I find this has been a longstanding problem. Every once in a while, old transactions get unreconciled. I always open GC the same way so I'm sure I'm not opening backups. Blake Hannaford -- ___ gnucash-user mailing list gnucash-user@gnucash.org To

Re: [GNC] Reconciliation Roll Back

2024-05-28 Thread David Carlson
A tidbit of information that you may find helpful: If you hover the mouse over the "y" character in the reconcile box in an account split line, the date of the reconciliation for that account split in that transaction appears in a flyover. It may take a couple of seconds to appear. Another

Re: [GNC] Reconciliation Roll Back

2024-05-28 Thread Maf. King
On Tuesday, 28 May 2024 09:49:05 BST Peter Cuthbert via gnucash-user wrote: > The reason I suspect > is that the opening balance that it picked up seemed way too high but I > know of no way to make sure that the opening balance is the correct one. Only by visual inspection - if you completed

Re: [GNC] Reconciliation Roll Back

2024-05-28 Thread Liz
On Tue, 28 May 2024 09:49:05 +0100 (BST) Peter Cuthbert via gnucash-user wrote: > Dear GNU Cash Users >   > A year ago I re-started an account from 6th April in GNU Cash as my > previous imports from Quicken were not working as I would have > wished. It was a lot of work to re enter 3 months of

Re: [GNC] Reconciliation with a strange opening balance

2023-11-16 Thread Mahon Finbar via gnucash-user
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

Re: [GNC] Reconciliation with a strange opening balance

2023-11-15 Thread Liz
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

Re: [GNC] Reconciliation with a strange opening balance

2023-11-15 Thread David Carlson
 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

Re: [GNC] Reconciliation with a strange opening balance

2023-11-15 Thread Adrien Monteleone
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

Re: [GNC] Reconciliation with a strange opening balance

2023-11-15 Thread David Carlson
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 <

Re: [GNC] Reconciliation with a strange opening balance

2023-11-15 Thread Adrien Monteleone
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

Re: [GNC] Reconciliation with a strange opening balance

2023-11-15 Thread David Carlson
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

Re: [GNC] Reconciliation with a strange opening balance

2023-11-15 Thread R Losey
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

Re: [GNC] Reconciliation with a strange opening balance

2023-11-15 Thread Mahon Finbar via gnucash-user
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

Re: [GNC] Reconciliation with a strange opening balance

2023-11-15 Thread Christopher Lam
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.

Re: [GNC] Reconciliation with a strange opening balance

2023-11-14 Thread Kalpesh Patel
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 gnucas

Re: [GNC] Reconciliation with a strange opening balance

2023-11-13 Thread David Carlson
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

Re: [GNC] Reconciliation with a strange opening balance

2023-11-13 Thread john
> 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

Re: [GNC] Reconciliation with a strange opening balance

2023-11-13 Thread David Carlson
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

Re: [GNC] Reconciliation with a strange opening balance

2023-11-13 Thread Maf. King
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

Re: [GNC] Reconciliation of accounts is not permanent

2023-09-28 Thread Adrien Monteleone
Mark, I posted my comment about suggested date too soon. I forgot it is a preference. Regards, Adrien On 9/28/23 9:46 AM, Mark Truelove wrote: Hi, I just wanted to say wow, Gnucash has never suggested today as the reconciliation date for me. It is typically 30 days/a month after the last

Re: [GNC] Reconciliation of accounts is not permanent

2023-09-28 Thread Mark Truelove
Hi, I just wanted to say wow, Gnucash has never suggested today as the reconciliation date for me. It is typically 30 days/a month after the last reconciled date, which I then need to adjust to the statement date about half the time (if it's a day or two off). I can't remember it ever not being

Re: [GNC] Reconciliation of accounts is not permanent

2023-09-28 Thread Peter Lamb via gnucash-user
OK, that explains the difference in behaviour that I'm seeing to what you're seeing. I have Preferences > Register > Reconciling > 'Always reconcile to today' unchecked. Peter On 28/9/2023 11:04, Adrien Monteleone wrote: It seems I forgot that is influenced by: Preferences > Register >

Re: [GNC] Reconciliation of accounts is not permanent

2023-09-28 Thread Peter Lamb via gnucash-user
On 28/9/2023 10:22, Adrien Monteleone wrote: On the contrary, GnuCash has *always* as far as I can recall after over a decade, suggested today's date for the closing date. I don't ever remember it suggesting a date in the past. When I do reconciliations, the default statement date is one

Re: [GNC] Reconciliation of accounts is not permanent

2023-09-27 Thread Adrien Monteleone
It seems I forgot that is influenced by: Preferences > Register > Reconciling > 'Always reconcile to today'. Apologies. Regards, Adrien On 9/27/23 7:22 PM, Adrien Monteleone wrote: On the contrary, GnuCash has *always* as far as I can recall after over a decade, suggested today's date for

Re: [GNC] Reconciliation of accounts is not permanent

2023-09-27 Thread Adrien Monteleone
On 9/27/23 10:47 AM, Mark Truelove wrote: Hi again. Besides my tendency to be details-specific (given my professional background), I also had some college level accounting and understand double-entry, reconciliation, and the basics. No, I am not an accountant, but I have been using GnuCash

Re: [GNC] Reconciliation of accounts is not permanent

2023-09-27 Thread Adrien Monteleone
Good catch. But that would imply some serious mass editing on the part of the OP to clear the reconcile flag. (and most likely dimissing the warning during those edits) Neither is out of the question, but either or both would be rare for the OP to not remember doing so. Regards, Adrien On

Re: [GNC] Reconciliation of accounts is not permanent

2023-09-27 Thread Mark Truelove
Hi David, long in the past I probably reconciled multiple accounts in one session without thinking about it, but after the first incident I started saving after I reconcile each statement. This is the third time this has occurred over about 5 years, prompting me to reach out about it instead of

Re: [GNC] Reconciliation of accounts is not permanent

2023-09-27 Thread John Layman via gnucash-user
of the previous reconciliation. -Original Message- From: gnucash-user On Behalf Of Mark Truelove Sent: Wednesday, September 27, 2023 11:48 AM To: stepbystepf...@comcast.net Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Reconciliation of accounts is not permanent Hi again. Besides my

Re: [GNC] Reconciliation of accounts is not permanent

2023-09-27 Thread David Cousens
Mark, The reconciliation has been working well in GnuCash for 10-12 years that I have been using GnuCash, currently 5.4 on Linux and bugs in it are usually picked up pretty quickly as nearly everyone will be using it. I have just entered six months of OFX files and reconciled them to the EOFY

Re: [GNC] Reconciliation of accounts is not permanent

2023-09-27 Thread David Carlson
Mark, From this side of the Internet it almost appears that you are forgetting to save the data file after reconciling, but always remembering to save other times, which is not very likely. Have you tried breaking down your procedure and inserting cross-checks? ie, just before starting a

Re: [GNC] Reconciliation of accounts is not permanent

2023-09-27 Thread Mark Truelove
Hi again. Besides my tendency to be details-specific (given my professional background), I also had some college level accounting and understand double-entry, reconciliation, and the basics. No, I am not an accountant, but I have been using GnuCash mostly successfully for more than twelve years

Re: [GNC] Reconciliation of accounts is not permanent

2023-09-27 Thread Michael or Penny Novack
The purpose of reconciliation is to verify that from the last closing date to the new closing date, the listed transactions cleared the account and thus explain the change from the opening balance (last closing balance) to the new closing balance listed on the statement. The actual

Re: [GNC] Reconciliation of accounts is not permanent

2023-09-26 Thread Adrien Monteleone
Unless you never enter a transaction after a reconciliation that is dated before that last closing date, *and* you never have any transactions that aren't reconciled at each and every reconciliation (that is, some that haven't cleared the institution yet, but are in your books) then you will

Re: [GNC] Reconciliation of accounts is not permanent

2023-09-26 Thread R Losey
On Tue, Sep 26, 2023 at 11:06 AM Mark Truelove wrote: > Hi all, I just joined the list. I thought I'd give this a try before moving > to a bug report, because I can't believe this happens to me and no one else > has experienced it. > > Today (and on previous occasions), I started my periodic

Re: [GNC] Reconciliation of accounts is not permanent

2023-09-26 Thread Mark Truelove
Hi, thanks, I'm certain I didn't add anything after the fact. On Tue, Sep 26, 2023 at 12:40 PM Jediator wrote: > Did you perhaps modified/added/deleted transactions after > reconciliation? Any changes could easily break your reconciled > balance. This is typical in a double-entry system: you

Re: [GNC] Reconciliation of accounts is not permanent

2023-09-26 Thread Mark Truelove
Hi, sorry, this is running on Windows 10 22H2. On Tue, Sep 26, 2023 at 12:16 PM Derek Atkins wrote: > HI, > > One piece of data you don't provide: what OS/Distro are you using? > > For example, if you are on a Mac, there is a known behavior that GnuCash > on Mac ALWAYS opens the last-used

Re: [GNC] Reconciliation of accounts is not permanent

2023-09-26 Thread Jediator
Did you perhaps modified/added/deleted transactions after reconciliation?  Any changes could easily break your reconciled balance.  This is typical in a double-entry system: you changed one account and didn't realized it affected the balance of another.  I guess the only way to make the

Re: [GNC] Reconciliation of accounts is not permanent

2023-09-26 Thread Derek Atkins
HI, One piece of data you don't provide: what OS/Distro are you using? For example, if you are on a Mac, there is a known behavior that GnuCash on Mac ALWAYS opens the last-used gnucash file, regardless of how you open it. Even if you double-click on a GnuCash data file, GnuCash on Mac will

Re: [GNC] Reconciliation Dates

2023-07-20 Thread Gyle McCollam
sh.org Subject: Re: [GNC] Reconciliation Dates > On Jul 20, 2023, at 08:03, Gyle McCollam wrote: > > Is there a way to delete the reconciliation date from accounts you no longer > wish to reconcile? > Not in the UI or even the API. Why would you care that there's a

Re: [GNC] Reconciliation Dates

2023-07-20 Thread john
> On Jul 20, 2023, at 08:03, Gyle McCollam wrote: > > Is there a way to delete the reconciliation date from accounts you no longer > wish to reconcile? > Not in the UI or even the API. Why would you care that there's a reconciliation date on the account? Regards, John Ralls

Re: [GNC] Reconciliation error - how should I correct?

2023-02-02 Thread R Losey
Yep; when I worked in a bank, we were always having to call people around the beginning of the year to check with them. I remember that we once did find a very old check; if memory serves (it was a LONG time ago), they were on checks in the 1300s, and the old check was from the 100s... and it was

Re: [GNC] Reconciliation error - how should I correct?

2023-02-02 Thread R Losey
Yes; she doesn't want to bother to look; she's not sure if she destroyed it or not. If she would just say one way or the other, it would help. On Tue, Jan 31, 2023 at 12:29 PM Phyllis Bruce wrote: > Wouldn't it just be simpler to ask your sister in law to destroy the check > if she finds it?

Re: [GNC] Reconciliation - Again

2023-02-01 Thread Eric Coates via gnucash-user
Phyllis, Simon Thanks, that's as I hoped. The heads up on the (potential) problem if the account on the other side of the transaction has also been reconciled has been noted. Thanks again Eric ___ gnucash-user mailing list

Re: [GNC] Reconciliation error - how should I correct?

2023-01-31 Thread edodd
On Tue, 31 Jan 2023 12:13:52 -0600 R Losey wrote: > Thanks; I used to work in a bank, and I thought there was a policy > such as you described... however, I did check with the bank, and they > indicated that they would honor the check regardless of how old it > was. They seem to be angling for

Re: [GNC] Reconciliation error - how should I correct?

2023-01-31 Thread Phyllis Bruce
Welcome to the world of tracking your dollars! On Tue, Jan 31, 2023 at 1:50 PM Dr. David Kirkby < drkir...@kirkbymicrowave.co.uk> wrote: > On Mon, 30 Jan 2023 at 16:41, Phyllis Bruce wrote: > >> Dr. Kirby, >> >> I'm praying your problem is getting away from paper reconciliation. >> Remember how

Re: [GNC] Reconciliation error - how should I correct?

2023-01-31 Thread Phyllis Bruce
Wouldn't it just be simpler to ask your sister in law to destroy the check if she finds it? Then write it off/delete it. On Tue, Jan 31, 2023 at 12:14 PM R Losey wrote: > Thanks; I used to work in a bank, and I thought there was a policy such as > you described... however, I did check with the

Re: [GNC] Reconciliation error - how should I correct?

2023-01-31 Thread R Losey
I agree that the statement is misleading... all it is trying to say is that if you reconcile a balance to $1000 and then add a transaction before the reconciliation date, the balance will change... (that is, if you add a $50 check, the balance will be $950 now instead of the $1000 you used. For

Re: [GNC] Reconciliation error - how should I correct?

2023-01-31 Thread Dr. David Kirkby
On Mon, 30 Jan 2023 at 16:41, Phyllis Bruce wrote: > Dr. Kirby, > > I'm praying your problem is getting away from paper reconciliation. > Remember how we used to turn the page over and list the items NOT on the > bank statements? No, because I have never before attempted reconciling a bank

Re: [GNC] Reconciliation error - how should I correct?

2023-01-31 Thread R Losey
Thanks; I used to work in a bank, and I thought there was a policy such as you described... however, I did check with the bank, and they indicated that they would honor the check regardless of how old it was. They seem to be angling for me to pay them $$$ to stop payment on the check, which I'm

Re: [GNC] Reconciliation - Again

2023-01-31 Thread Simon Roberts
I'm confident that informational stuff, and the date, are irrelevant to reconciliation. And many times, the transfer field won't matter. BUT, if the transfer field is another account subject to reconciliation, and that transaction has been reconciled in the other account (e.g. you made a literal

Re: [GNC] Reconciliation - Again

2023-01-31 Thread Phyllis Bruce
I've not had a problem when changing any of those fields. You are really only reconciling the one account. On Tue, Jan 31, 2023 at 10:21 AM Eric Coates via gnucash-user < gnucash-user@gnucash.org> wrote: > Good Afternoon > > I fully understand that changing the Payment/Charge (on a credit card

Re: [GNC] Reconciliation error - how should I correct?

2023-01-31 Thread Dr. David Kirkby
On Mon, 30 Jan 2023 at 19:46, R Losey wrote: > Normally, people 'reconcile' their records to the financial institution, > marking the ones on which they agree as 'reconciled'. > > If everything went right, the accounts should balance, leaving the > transactions that the bank doesn't know

Re: [GNC] Reconciliation error - how should I correct?

2023-01-30 Thread Adrien Monteleone
Reconciliation verifies that: Opening Balance + *listed* transactions = Ending Balance That is all. Sometimes, banks don't clear transactions in the same period they were submitted. It appears in this case, it cleared an entire period late. You were able to reconcile June & July because the

Re: [GNC] Reconciliation error - how should I correct?

2023-01-30 Thread Michael or Penny Novack
... regardless of date. I sent a check to a sister-in-law that she probably won't cash, but she cannot remember what she did with it... so, years later, it is still an Uh no, not outstanding indefinitely. This of course is not really a gnucash question but since this question affects

Re: [GNC] Reconciliation error - how should I correct?

2023-01-30 Thread R Losey
Normally, people 'reconcile' their records to the financial institution, marking the ones on which they agree as 'reconciled'. If everything went right, the accounts should balance, leaving the transactions that the bank doesn't know about... regardless of date. I sent a check to a sister-in-law

Re: [GNC] Reconciliation error - how should I correct?

2023-01-30 Thread Phyllis Bruce
Dr. Kirby, I'm praying your problem is getting away from paper reconciliation. Remember how we used to turn the page over and list the items NOT on the bank statements? Gnu does that automatically. You reconcile to your bank statement so that the difference on your reconciliation screen shows a

Re: [GNC] Reconciliation error - how should I correct?

2023-01-30 Thread Stephen
Presumably you are on a cash basis. If not then stop reading here. If on a cash basis then you (your bank) paid the bill in August, regardless of when you received the bill. Why do you say the transaction occurred in June? Maybe the work was done/goods were delivered, etc. but the bill was

Re: [GNC] Reconciliation error - how should I correct?

2023-01-30 Thread Dr. David Kirkby
On Mon, 30 Jan 2023 at 03:49, Jim DeLaHunt wrote: > On 2023-01-29 17:34, Dr. David Kirkby wrote: > > > I've reconciled my bank account until the end of July 2022, but then > found > > a bill from a vendor which was paid from the bank account in August, but > > the transaction occurred in June.

Re: [GNC] Reconciliation error - how should I correct?

2023-01-29 Thread Jim DeLaHunt
On 2023-01-29 17:34, Dr. David Kirkby wrote: I've reconciled my bank account until the end of July 2022, but then found a bill from a vendor which was paid from the bank account in August, but the transaction occurred in June. So really I want to create a bill in June. In what sense is this a

Re: [GNC] Reconciliation Report

2022-10-05 Thread David Carlson
Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. On Wed, Oct 5, 2022, 9:53 AM Nathan Rosenthal wrote: > The first sentence in your reply explains why going back further than the > previous month did not produce any results. > > I will

Re: [GNC] Reconciliation Report

2022-10-04 Thread David Carlson
Nathan, Are there actually no transactions in the share account for that period? I am surprised that the reconciliation dialog doesn't pop up anyway to set the start and end balances. On Tue, Oct 4, 2022 at 4:21 PM Nathan Rosenthal wrote: > I maintain 2 accounts for an organization I belong

Re: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

2022-10-03 Thread Adrien Monteleone
If you are looking for 'aging', that is, how much of an amount owed is say 30days, 60days, or 90+days due, then that is at the bottom each Customer or Vendor report. (and also shows any unused pre-payments/deposits in the case you use that feature) It doesn't show any sort of average, but it

Re: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

2022-10-03 Thread Uttam Chakravorty
strike terror into my soul. With many thanks and best wishes, Uttam (and a beer or three (who's counting) if you are ever in my neighbourhood) From: Michael or Penny Novack To: Sent: 02/10/2022 3:46 PM Subject: Re: [GNC] Reconciliation Report -> Trade Debtors -> p

Re: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

2022-10-02 Thread Michael or Penny Novack
And in that case of 'breadcrumbs' the entirety of GnuCash is an audit trail, as that is how double-entry accounting works. If you are looking for some record of exactly who entered which transactions and the date/time stamps, no, that is not available. Technically I think the posting

Re: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

2022-10-01 Thread Adrien Monteleone
Glad to have pointed you in the right direction. And in that case of 'breadcrumbs' the entirety of GnuCash is an audit trail, as that is how double-entry accounting works. If you are looking for some record of exactly who entered which transactions and the date/time stamps, no, that is not

Re: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

2022-10-01 Thread Uttam Chakravorty
received I would like to ask the community another question.  I will raise it as a separate topic = 'Reconciling subaccounts'. Many thanks again, Uttam From: Adrien Monteleone To: Sent: 30/09/2022 7:23 PM Subject: Re: [GNC] Reconciliation Report -> Trade Debtors -> p

Re: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

2022-10-01 Thread Adrien Monteleone
The Business Features handle all of that with ease. There is no need for myriad accounts or convoluted account structure. "invoices as sub-categories for each business"? What is that about? The official process is fairly simple and straightforward. Set up Customers. Post Invoices linked to

Re: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

2022-09-30 Thread R Losey
Would it help to have each client as an account? (to easily see the balances) Alternatively, I assume you already ask them to put the invoice number of the receipts, but some do not do so... perhaps when you issue bills, it can have a matching part that they return... this would help you pair

Re: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

2022-09-30 Thread Adrien Monteleone
On 9/30/22 12:48 PM, Uttam Chakravorty wrote: Dear All, I am using the Reconciliation Report configured as: Accounts = Trade Debtors ->Currency / Display / Filter = defaults -> General - current period selected -> Sorting by Description then Date. Is there a way to use this pool of

Re: [GNC] Reconciliation discrepancies

2022-04-13 Thread Jean Laroche
To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Reconciliation discrepancies On Tue, 12 Apr 2022, Liz wrote: By looking at such a small number of transactions it is possible to find whatever the errors are. I too have been on Gnucash for a couple of decades, but still found 4 errors in one file

Re: [GNC] Reconciliation discrepancies

2022-04-13 Thread John Layman
, whenever you encounter something puzzling in GnuCash, the most likely cause is user error or a failure to RTFM. -Original Message- From: gnucash-user On Behalf Of Rich Shepard Sent: Tuesday, April 12, 2022 8:49 AM To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Reconciliation

Re: [GNC] Reconciliation discrepancies

2022-04-12 Thread davidcousens49
Rich, One possible cause for this is a transaction (or more) accidentally entered since the time you were last getting correct reconciliations at a date sometime in the past. This has occurred for me sometimes when I have mistyped a date entry, particularly the year, on entry. e.g date went in as

Re: [GNC] Reconciliation discrepancies

2022-04-12 Thread Derek Atkins
On Tue, April 12, 2022 12:58 pm, R. Victor Klassen wrote: >> On Apr 12, 2022, at 10:20 AM, David T. wrote: >> >> Reconciled entries *are* marked read only. If you aren't getting a >> notice on editing, it's because you told gnucash not to notify you any >> more. That can be reset somewhere in

Re: [GNC] Reconciliation discrepancies

2022-04-12 Thread R. Victor Klassen
Well that would implicate data corruption Sent from my iPhone > On Apr 12, 2022, at 10:20 AM, David T. wrote: > > Reconciled entries *are* marked read only. If you aren't getting a notice on > editing, it's because you told gnucash not to notify you any more. That can > be reset somewhere

Re: [GNC] Reconciliation discrepancies

2022-04-12 Thread Adrien Monteleone
Do you by chance have sub-accounts at play, and are you including them in the reconcile? Sub-accounts *shouldn't* matter because 'if done correctly' they shouldn't affect the parent balance, and serve just as a segregation/classification tool. But the caveat is that transactions there might be

Re: [GNC] Reconciliation discrepancies

2022-04-12 Thread David T. via gnucash-user
Reconciled entries *are* marked read only. If you aren't getting a notice on editing, it's because you told gnucash not to notify you any more. That can be reset somewhere in the preferences. David On April 12, 2022 5:25:51 AM PDT, "R. Victor Klassen" wrote: >I run into such issues once in

Re: [GNC] Reconciliation discrepancies

2022-04-12 Thread Rich Shepard
On Tue, 12 Apr 2022, Liz wrote: By looking at such a small number of transactions it is possible to find whatever the errors are. I too have been on Gnucash for a couple of decades, but still found 4 errors in one file this March, payments not entered as received, and digit transposition.

Re: [GNC] Reconciliation discrepancies

2022-04-12 Thread Rich Shepard
On Tue, 12 Apr 2022, Alan A Holmes wrote: I had a problem with reconciling just over a year ago. It happened on 2 separate occasions. My workflow to reconcile on both occasions was :- ... It only happened the twice. I still follow the workflow in steps 1-5 now, but don't have the problem

Re: [GNC] Reconciliation discrepancies

2022-04-12 Thread R. Victor Klassen
I run into such issues once in every one or two blue moons. The starting balance is off. I’ve reconciled successfully the previous month, but something somehow (dis)appeared in the meantime. I assume it disappeared, although the symptoms could be generated by something appearing. I hope it’s

Re: [GNC] Reconciliation discrepancies

2022-04-12 Thread Liz
On Mon, 11 Apr 2022 14:36:41 -0700 (PDT) Rich Shepard wrote: > Every now and then one of my bank accounts doesn't reconcile because > what the bank shows differs from what GnuCash shows. The amounts are > significant. What puzzles me is that the previous month's balances > (bank and GC) match

Re: [GNC] Reconciliation discrepancies

2022-04-12 Thread Alan A Holmes
Hi Rich, I had a problem with reconciling just over a year ago. It happened on 2 separate occasions. My workflow to reconcile on both occasions was :- 1. Open the bank statement, and copy the closing balance. 2. Open the appropriate account in GnuCash. 3. Click the reconcile icon. 4. Enter the

Re: [GNC] Reconciliation discrepancies

2022-04-11 Thread David Carlson
A possibility that has not been mentioned yet is if there are transactions in more than one currency or involving securities. If so, there are many possible additional sources of discrepancy. Also, if the discrepancies suddenly appeared, say, after updating GnuCash to release 4.10, for example,

Re: [GNC] Reconciliation discrepancies

2022-04-11 Thread davidcousens49
Rich Have been using GnuCash for a similar period of time and have not noticed any reconciliation problems (other than those reported as bugs on the list - any that are are generally fixed pretty quickly) up to v4.9, particulaarly in recent versions. Haven't yet done a reconciliation with 4.10.

Re: [GNC] Reconciliation discrepancies

2022-04-11 Thread Rich Shepard
On Mon, 11 Apr 2022, Gyle McCollam wrote: These may not apply, but check that your reconciliation date is the same as the bank's. Also, check the dates of the transactions as GC shows transaction past the reconciliation date, that you don't want to reconcile. The ending balance that GC shows

  1   2   3   >