[GNC] Reconciliation oddity.

2024-04-28 Thread Tom Veik
I always reconcile my accounts to the penny and it has always worked well for me in the past except today.  In my credit card account.  I some how ended up with two extra charge transactions in my account that shouldn't have been there.  Both had amounts equal to two other valid charge

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

[GNC] Reconciliation with a strange opening balance

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

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

[GNC] Reconciliation of accounts is not permanent

2023-09-26 Thread Mark Truelove
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. I did try searching list history as suggested with google, but didn't find anything referring to this specifically. Also,

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

[GNC] Reconciliation Dates

2023-07-20 Thread Gyle McCollam
Is there a way to delete the reconciliation date from accounts you no longer wish to reconcile? Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com email ___ gnucash-user mailing list

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

[GNC] Reconciliation - Again

2023-01-31 Thread Eric Coates via gnucash-user
Good Afternoon I fully understand that changing the Payment/Charge (on a credit card account) or the Increase/Decrease  (on a bank account) will create difficulties with future reconciliations. However, is it possible to change the contents of other fields (Date, Description and,

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

[GNC] Reconciliation Report

2022-10-04 Thread Nathan Rosenthal
I maintain 2 accounts for an organization I belong to - a checking account at one bank and a share account at a credit union. Each of them has an account in gnucash. When I reconcile the accounts, the checking account reconciliation works properly but the share account reconciliation fails

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

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

2022-09-30 Thread flywire
This is similar to rental payments but my experience is with cash accounting. It is easy to skip an invoice and in my jurisdiction, this eventually means it isn't required to be paid. I'd suggest providing a statement instead of pairing payments and invoices so payments are applied to the oldest

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

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

2022-09-30 Thread Uttam Chakravorty
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 information and pair a receipt with an Invoice as per

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
still follow the workflow in steps 1-5 now, but don't have the problem is step 5. Any differences I've found was down to me. Alan A Holmes -Original Message- From: gnucash-user On Behalf Of Rich Shepard Sent: 11 April 2022 22:37 To: gnucash-user@gnucash.org Subject: [GNC] Reconciliation

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

Re: [GNC] Reconciliation discrepancies

2022-04-11 Thread Rich Shepard
On Mon, 11 Apr 2022, Dan Black wrote: It is possible that you transposed two digits that you may not notice. Dan, I compare each transaction and haven't yet seen one with transposed digits. Thanks for the suggestion, Rich ___ gnucash-user mailing

Re: [GNC] Reconciliation discrepancies

2022-04-11 Thread Gyle McCollam
hepard Sent: Monday, April 11, 2022 6:32 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] Reconciliation discrepancies On Mon, 11 Apr 2022, Ed Reeder wrote: > When that happens to me I will discover that I entered a transaction > incorrectly. I would check each GC transaction against th

Re: [GNC] Reconciliation discrepancies

2022-04-11 Thread Dan Black
It is possible that you transposed two digits that you may not notice. Try downloading an ofx or csv file and try importing it. Let the computer do the comparing for you. On April 11, 2022 6:33:15 PM Rich Shepard wrote: On Mon, 11 Apr 2022, Ed Reeder wrote: When that happens to me I

Re: [GNC] Reconciliation discrepancies

2022-04-11 Thread Rich Shepard
On Mon, 11 Apr 2022, Ed Reeder wrote: When that happens to me I will discover that I entered a transaction incorrectly. I would check each GC transaction against the banks. Ed, That's what I do. As I wrote, they all match. Thanks, Rich ___

Re: [GNC] Reconciliation discrepancies

2022-04-11 Thread Ed Reeder
When that happens to me I will discover that I entered a transaction incorrectly. I would check each GC transaction against the banks. On Mon, Apr 11, 2022, at 2:36 PM, Rich Shepard wrote: > Every now and then one of my bank accounts doesn't reconcile because what > the bank shows differs from

[GNC] Reconciliation discrepancies

2022-04-11 Thread Rich Shepard
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 and so do all the transactions. But, the end of month balances don't

[GNC] Reconciliation conflict while editing split in account/sub-account being reconciled.

2022-02-03 Thread Stephen M. Butler
I just filed bug 798444 describing a non-detected conflict between editing a split (setting the cleared flag) and reconciliation on that account (or it's parent) where the reconcile status was cleared after reconciliation finished. I didn't

Re: [GNC] Reconciliation mystery - unreconciled transactions in a period that was reconciled.

2021-12-21 Thread Rogier F. van Vlissingen
Thanks for the feedback. This is obviously concerning, but a solution may have been offered. I have been using an older version of gnucash (3.8) because it is what my update manager in mint provides. I am now going to switch to the latest version, and try to fix this. It was only two months ago,

Re: [GNC] Reconciliation mystery - unreconciled transactions in a period that was reconciled.

2021-12-19 Thread Richard Gaede via gnucash-user
Hi, Rogier and David, I have had a situation several times where I have completed reconciliations, and then months later in a new reconciliation transactions show up from several years before as unreconciled. I have no idea how this occurs. As my accounting has no business connotations, I

Re: [GNC] Reconciliation mystery - unreconciled transactions in a period that was reconciled.

2021-12-19 Thread davidcousens49
Rogier, It would appear on the surface that somehow you did not reconcile the two transactions which remained marked as "n" which means not cleared("c) or not reconciled("y"). How ? Unfortunately without knowing exactly what you did during the reconciliation process it will be hard for anyone to

[GNC] Reconciliation mystery - unreconciled transactions in a period that was reconciled.

2021-12-19 Thread Rogier F. van Vlissingen
A while ago, I set up a business in Gnucash after having some outrageous problems with QBO. Once I got going it all worked out OK, but it appears I may have made some mistakes in the end and I cannot comprehend how I might have done it or how to fix them. The primary tipoff was that I did all my

Re: [GNC] Reconciliation Changes

2021-10-15 Thread Chris Good
Friday, 15 October 2021 3:00 AM To: Derek Atkins mailto:de...@ihtfp.com> > Cc: D. mailto:sunfis...@yahoo.com> >; Steve Welch via gnucash-user mailto:gnucash-user@gnucash.org> >; Chris Good mailto:goodchri...@gmail.com> > Subject: Re: [GNC] Reconciliation Changes I

  1   2   3   >