Re: [GNC] Wrong starting balance
On Sat, 21 Nov 2020 23:51:01 -0600 David Carlson wrote: > Liz > > I would suggest copying that entire message into a bug report. > Especially be sure to include that you had said "Do not tell me again > this session that I am changing a > reconciled transaction" as that may be the key to the puzzle. The > developers can figure out which details don't matter and which are > important. If they cannot reproduce the issue they will ask for more > information, so it speeds things up to be very detailed the first > time. Also include that the transactions were spawned from scheduled > transactions, in case that makes a difference, even though they were > not reconciled until some time later. If you remember which account > register you were working in (X, Y, Z, Tax or perhaps General > Journal) when you made the changes, that may also help. > > After You have filed the bug report, if you think others may wish to > follow the progress, you can report the bug number in this list. I > suspect that you already know the drill! > https://bugs.gnucash.org/show_bug.cgi?id=798017 so long since I reported a bug I had to reregister ;) 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Wrong starting balance
Liz I would suggest copying that entire message into a bug report. Especially be sure to include that you had said "Do not tell me again this session that I am changing a reconciled transaction" as that may be the key to the puzzle. The developers can figure out which details don't matter and which are important. If they cannot reproduce the issue they will ask for more information, so it speeds things up to be very detailed the first time. Also include that the transactions were spawned from scheduled transactions, in case that makes a difference, even though they were not reconciled until some time later. If you remember which account register you were working in (X, Y, Z, Tax or perhaps General Journal) when you made the changes, that may also help. After You have filed the bug report, if you think others may wish to follow the progress, you can report the bug number in this list. I suspect that you already know the drill! On Sat, Nov 21, 2020 at 11:16 PM Liz wrote: > On Sat, 21 Nov 2020 17:30:08 -0600 > David Carlson wrote: > > > Liz: > > > > If I understand correctly, at some point intentionally or > > unintentionally you were able to move a previously reconciled > > transaction from one account to a different account without changing > > the reconciliation status. I just tried that in release 3.8 and I > > received a warning that the reconciliation will be cancelled. > > > > Do you remember which release of GnuCash you were using at that time? > > I cannot test release 4.2 so I cannot check whether a new bug report > > needs to be filed. > > > > I believe that user action is equivalent to my previous description of > > changing the account GUID of a given split line which has a > > reconciliation status of 'Y'. If not, someone please enlighten me. > > > Version: 4.2 > Build ID: 4.2+(2020-09-26) > Finance::Quote: 1.47 > > On Debian > > I was dealing with an intermediate account I made to help me follow a > credit I have with the tax people. > > So I was moving payments made to the tax authority into an intermediate > account, type Liability. They were moved from an Asset account, type > Bank. > They had been reconciled. > > So Tax has to be paid, counted in account X > The liability to pay the tax is counted in account Y > The payments are still made to the tax people from account Z > > Previously the system counted the tax in X and paid it from Y > so instead of X <> Z > the books now go X <> Y and Y <> Z > > To get the accounting correct I have had to move reconciled > transactions from Z to Y (they were scheduled transactions). > The change was made from X, a non-reconciled account > I said "Do not tell me again this session that I am changing a > reconciled transaction" > > When the transactions were reviewed in Y they remained reconciled, and > the amounts were reconciled in Y, which was inappropriate. > > How much of this needs to go in the bug report? > > 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help on daily cash income and bank statements
Alison Rather than entering all the data for bank statements by hand, if you are in luck you bank will provide you with facilities where you can download a file containing the transactions to a specific account which can then be imported by GnuCash. This is covered in the GnuCash Help manual https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#:~:text=Navigate%20to%20the%20MT940%2C%20MT942,the%20transactions%20in%20the%20file including the various formats which can be used. OFX/QFX is one format which is often provided which is usually fairly easy to import. You may also be able to use direct Connect facilities in AQbanking to automatically download transactions from your bank as the bank records them. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help on daily cash income and bank statements
On Sat, 21 Nov 2020 19:07:14 + (UTC) alison Stoner via gnucash-user wrote: > Hi there > I started using gnucash. Now accountant would also like bank > statement typed in. I have only been typing in all my invoices.Where > do I type the monthly statements in/to?Also where do I type in daily > cash intake. Like I said I am only doing all my expensesLook forward > to your reply RegardsAlison Welcome Alison Yes, if you can do this extra data entry you will help your accountant and hopefully have to pay less to them! There is LOTS to learn, so we recommend making a practice set of accounts to learn on, and reading the user guide. The main user guide is https://code.gnucash.org/docs/C/gnucash-guide.pdf and the quick version is here https://wiki.gnucash.org/wiki/GnuCash_Quick_Start_Guide_For_Business_Users Play around and come back here with your questions. "gnucash-user@gnucash.org" If you subscribe to the list you won't have to wait for the Moderator to let your emails through. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Wrong starting balance
On Sat, 21 Nov 2020 17:30:08 -0600 David Carlson wrote: > Liz: > > If I understand correctly, at some point intentionally or > unintentionally you were able to move a previously reconciled > transaction from one account to a different account without changing > the reconciliation status. I just tried that in release 3.8 and I > received a warning that the reconciliation will be cancelled. > > Do you remember which release of GnuCash you were using at that time? > I cannot test release 4.2 so I cannot check whether a new bug report > needs to be filed. > > I believe that user action is equivalent to my previous description of > changing the account GUID of a given split line which has a > reconciliation status of 'Y'. If not, someone please enlighten me. Version: 4.2 Build ID: 4.2+(2020-09-26) Finance::Quote: 1.47 On Debian I was dealing with an intermediate account I made to help me follow a credit I have with the tax people. So I was moving payments made to the tax authority into an intermediate account, type Liability. They were moved from an Asset account, type Bank. They had been reconciled. So Tax has to be paid, counted in account X The liability to pay the tax is counted in account Y The payments are still made to the tax people from account Z Previously the system counted the tax in X and paid it from Y so instead of X <> Z the books now go X <> Y and Y <> Z To get the accounting correct I have had to move reconciled transactions from Z to Y (they were scheduled transactions). The change was made from X, a non-reconciled account I said "Do not tell me again this session that I am changing a reconciled transaction" When the transactions were reviewed in Y they remained reconciled, and the amounts were reconciled in Y, which was inappropriate. How much of this needs to go in the bug report? 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Help on daily cash income and bank statements
Hi there I started using gnucash. Now accountant would also like bank statement typed in. I have only been typing in all my invoices.Where do I type the monthly statements in/to?Also where do I type in daily cash intake. Like I said I am only doing all my expensesLook forward to your reply RegardsAlison Sent from Yahoo Mail on Android ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to Manually Match transactions
Have some good news and an even better solution that can be added to the FAQ or How-to. 2 Options that work for associating/matching a transaction that does not import match: 1 - Import from Account A and assign to Account B at import or before importing Account B. Then when importing Account B, the two transactions will be matched to each other. This is the proactive correct solution. So obvious. 2 - In the case import QFX from Account A and match is not made before hand, then importing Account B won't find a match. Fix is to assign either Account A or Account B transaction to the other account respectively. Then delete the duplicate transaction, lets say, account B has two entries because Account A was assigned to Account B as the destination. Now, re-import Account B and the import matcher will now match those two entries, success. Again, option 1 is what you want and option 2 is a good recovery to fix the issue. On 11/19/2020 9:58 PM, Griff wrote: Thanks for the great suggestions everyone. I tried the idea of changing from A to C during import and then looking for a match but no matches were present to select from in the matcher dialog. I even manually changed the date of the transaction in account A to match the date of account B before importing, then did the import and the matcher still did not find anything to offer up. Too bad GnuCash does not allow selecting the match from the full list of transactions or matching at other times besides import. Hopefully this was a special case match issue and the norm will be to find a match for the transfers like your example of PayPal and the multi-day float. Otherwise, I can manually fix the issue or use Frank's short-term float account "money in transfer" to match the transactions. I have the default import setting of bayesian and 1, 3, 6 for thresholds, I tried changing the match display threshold to 0 but no impact. As a side note, I tested the QIF file for the same transactions instead to see if that worked better and had the strange issue of GnuCash hanging. Tried it several times with the same issue. David places like PayPal/Venmo still enjoy the float on their end and offer a rapid no-float option for a fee, win-win for them. On Thu, Nov 19, 2020 at 5:54 PM David Carlson <[1]david.carlson@gmail.com> wrote: In the olden days some people would even try to take advantage of having a lot of funds in "float" between various bank accounts. 來 On Thu, Nov 19, 2020, 6:12 PM Adrien Monteleone < [2]adrien.montele...@lusfiber.net> wrote: > Griff, > > Sorry, I misunderstood the original post. I thought it was a single > import, not two separate ones. > > David's suggestions should be the way to go in your case. > > As for retaining the second date, (presumably from the Credit Card > account) see my reply to Frank. > > Regards, > Adrien > > On 11/19/20 3:18 PM, Griff wrote: > > Thanks Adrien and Stephen. > > > > Both your solutions are good work arounds, sounds like the short answer > is > > it can't be done the nice way preserving data. The result will be to > > manually delete one of the import transactions and the new duplicate > > created won't have the date that matches one of the 2 banks for > correctness > > purposes. > > > > To your suggestion of importing it all at once, that is not possible as > one > > QFX file is from the credit card company download and the other QFX is > from > > the different bank company's download. They will be two files. > > > > This is unfortunate as the matcher is only run on QIF import and not > > OFX/QFX import. > > Should I be getting the data from the banks in QIF instead, does that > work > > better then OFX/QFX for GnuCash import? > > > ___ > gnucash-user mailing list > [3]gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > [4]https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > [5]https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list [6]gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: [7]https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see [8]https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember
Re: [GNC] How to Manually Match transactions
Option A is extensively documented, if you understand that once the first import is successfully completed with full assignment of destination accounts, then the second import is simply that: another import. Presumably, if you assign destination accounts upon import, then you can avoid most duplication. The Guide at 3.1.2 and Help at 6.16 cover these issues in some detail. David T. Original Message From: Griff Sent: Sat Nov 21 13:17:37 EST 2020 To: David Carlson Cc: GnuCash List , Adrien Monteleone Subject: Re: [GNC] How to Manually Match transactions Have some good news and an even better solution that can be added to the FAQ or How-to. 2 Options that work for associating/matching a transaction that does not import match: 1 - Import from Account A and assign to Account B at import or before importing Account B. Then when importing Account B, the two transactions will be matched to each other. This is the proactive correct solution. So obvious. 2 - In the case import QFX from Account A and match is not made before hand, then importing Account B won't find a match. Fix is to assign either Account A or Account B transaction to the other account respectively. Then delete the duplicate transaction, lets say, account B has two entries because Account A was assigned to Account B as the destination. Now, re-import Account B and the import matcher will now match those two transactions, success. For both options, use U+C. The match happened with a C but using U+C will fix the transaction where the 2 dates don't match. Again, option 1 is what you want and option 2 is a good recovery to fix the issue. Thanks again to everyone for your help. On 11/19/2020 9:58 PM, Griff wrote: Thanks for the great suggestions everyone. I tried the idea of changing from A to C during import and then looking for a match but no matches were present to select from in the matcher dialog. I even manually changed the date of the transaction in account A to match the date of account B before importing, then did the import and the matcher still did not find anything to offer up. Too bad GnuCash does not allow selecting the match from the full list of transactions or matching at other times besides import. Hopefully this was a special case match issue and the norm will be to find a match for the transfers like your example of PayPal and the multi-day float. Otherwise, I can manually fix the issue or use Frank's short-term float account "money in transfer" to match the transactions. I have the default import setting of bayesian and 1, 3, 6 for thresholds, I tried changing the match display threshold to 0 but no impact. As a side note, I tested the QIF file for the same transactions instead to see if that worked better and had the strange issue of GnuCash hanging. Tried it several times with the same issue. David places like PayPal/Venmo still enjoy the float on their end and offer a rapid no-float option for a fee, win-win for them. On Thu, Nov 19, 2020 at 5:54 PM David Carlson wrote: > In the olden days some people would even try to take advantage of having a > lot of funds in "float" between various bank accounts. 來 > > On Thu, Nov 19, 2020, 6:12 PM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > Griff, > > > > Sorry, I misunderstood the original post. I thought it was a single > > import, not two separate ones. > > > > David's suggestions should be the way to go in your case. > > > > As for retaining the second date, (presumably from the Credit Card > > account) see my reply to Frank. > > > > Regards, > > Adrien > > > > On 11/19/20 3:18 PM, Griff wrote: > > > Thanks Adrien and Stephen. > > > > > > Both your solutions are good work arounds, sounds like the short answer > > is > > > it can't be done the nice way preserving data. The result will be to > > > manually delete one of the import transactions and the new duplicate > > > created won't have the date that matches one of the 2 banks for > > correctness > > > purposes. > > > > > > To your suggestion of importing it all at once, that is not possible as > > one > > > QFX file is from the credit card company download and the other QFX is > > from > > > the different bank company's download. They will be two files. > > > > > > This is unfortunate as the matcher is only run on QIF import and not > > > OFX/QFX import. > > > Should I be getting the data from the banks in QIF instead, does that > > work > > > better then OFX/QFX for GnuCash import? > > > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Wrong starting balance
Liz: If I understand correctly, at some point intentionally or unintentionally you were able to move a previously reconciled transaction from one account to a different account without changing the reconciliation status. I just tried that in release 3.8 and I received a warning that the reconciliation will be cancelled. Do you remember which release of GnuCash you were using at that time? I cannot test release 4.2 so I cannot check whether a new bug report needs to be filed. I believe that user action is equivalent to my previous description of changing the account GUID of a given split line which has a reconciliation status of 'Y'. If not, someone please enlighten me. On Sat, Nov 21, 2020 at 2:40 PM David Carlson wrote: > Thanks! > > On Sat, Nov 21, 2020, 12:08 PM Derek Atkins wrote: > >> GUID >> >> -derek >> Sent using my mobile device. Please excuse any typos. >> >> >> >> On November 21, 2020 1:02:40 PM David Carlson < >> david.carlson@gmail.com> >> wrote: >> >> > I know that GnuCash uses an internal thing that you must be calling >> > *identity* rather the text string that appears in the display, but I >> > couldn't remember what GnuCash called it. >> > >> > >> > >> > On Sat, Nov 21, 2020 at 11:42 AM Fred Bone >> wrote: >> > >> >> On 20 November 2020 at 22:09, David Carlson said: >> >> >> >> > As I started to suggest in my previous email, if a given split line >> >> > contains a 'Y' reconcile status, that implies that the transaction >> split >> >> > line passed a reconciliation process for that account on a certain >> date >> >> > recorded within the data file, but not visible to users. If the >> account >> >> > name or it's representation in the data file changes in that split >> line, >> >> > or if the transaction date changes as associated with that split >> line, >> >> > then the 'Y' status should be revoked. >> >> >> >> It's not the account *name* that matters, but the account *identity*. >> The >> >> split only references the name indirectly. >> >> >> >> If my credit card provider renames itself and I rename the relevant >> >> account to match, that should not be a reason for un-reconciling >> >> anything. >> >> >> >> ___ >> >> gnucash-user mailing list >> >> gnucash-user@gnucash.org >> >> To update your subscription preferences or to unsubscribe: >> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> >> If you are using Nabble or Gmane, please see >> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> >> - >> >> Please remember to CC this list on all your replies. >> >> You can do this by using Reply-To-List or Reply-All. >> >> >> > >> > >> > -- >> > 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 >> > If you are using Nabble or Gmane, please see >> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> > - >> > Please remember to CC this list on all your replies. >> > You can do this by using Reply-To-List or Reply-All. >> >> >> -- 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Wrong starting balance
Thanks! On Sat, Nov 21, 2020, 12:08 PM Derek Atkins wrote: > GUID > > -derek > Sent using my mobile device. Please excuse any typos. > > > > On November 21, 2020 1:02:40 PM David Carlson > > wrote: > > > I know that GnuCash uses an internal thing that you must be calling > > *identity* rather the text string that appears in the display, but I > > couldn't remember what GnuCash called it. > > > > > > > > On Sat, Nov 21, 2020 at 11:42 AM Fred Bone > wrote: > > > >> On 20 November 2020 at 22:09, David Carlson said: > >> > >> > As I started to suggest in my previous email, if a given split line > >> > contains a 'Y' reconcile status, that implies that the transaction > split > >> > line passed a reconciliation process for that account on a certain > date > >> > recorded within the data file, but not visible to users. If the > account > >> > name or it's representation in the data file changes in that split > line, > >> > or if the transaction date changes as associated with that split line, > >> > then the 'Y' status should be revoked. > >> > >> It's not the account *name* that matters, but the account *identity*. > The > >> split only references the name indirectly. > >> > >> If my credit card provider renames itself and I rename the relevant > >> account to match, that should not be a reason for un-reconciling > >> anything. > >> > >> ___ > >> gnucash-user mailing list > >> gnucash-user@gnucash.org > >> To update your subscription preferences or to unsubscribe: > >> https://lists.gnucash.org/mailman/listinfo/gnucash-user > >> If you are using Nabble or Gmane, please see > >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > >> - > >> Please remember to CC this list on all your replies. > >> You can do this by using Reply-To-List or Reply-All. > >> > > > > > > -- > > 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 > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to Manually Match transactions
Have some good news and an even better solution that can be added to the FAQ or How-to. 2 Options that work for associating/matching a transaction that does not import match: 1 - Import from Account A and assign to Account B at import or before importing Account B. Then when importing Account B, the two transactions will be matched to each other. This is the proactive correct solution. So obvious. 2 - In the case import QFX from Account A and match is not made before hand, then importing Account B won't find a match. Fix is to assign either Account A or Account B transaction to the other account respectively. Then delete the duplicate transaction, lets say, account B has two entries because Account A was assigned to Account B as the destination. Now, re-import Account B and the import matcher will now match those two transactions, success. For both options, use U+C. The match happened with a C but using U+C will fix the transaction where the 2 dates don't match. Again, option 1 is what you want and option 2 is a good recovery to fix the issue. Thanks again to everyone for your help. On 11/19/2020 9:58 PM, Griff wrote: Thanks for the great suggestions everyone. I tried the idea of changing from A to C during import and then looking for a match but no matches were present to select from in the matcher dialog. I even manually changed the date of the transaction in account A to match the date of account B before importing, then did the import and the matcher still did not find anything to offer up. Too bad GnuCash does not allow selecting the match from the full list of transactions or matching at other times besides import. Hopefully this was a special case match issue and the norm will be to find a match for the transfers like your example of PayPal and the multi-day float. Otherwise, I can manually fix the issue or use Frank's short-term float account "money in transfer" to match the transactions. I have the default import setting of bayesian and 1, 3, 6 for thresholds, I tried changing the match display threshold to 0 but no impact. As a side note, I tested the QIF file for the same transactions instead to see if that worked better and had the strange issue of GnuCash hanging. Tried it several times with the same issue. David places like PayPal/Venmo still enjoy the float on their end and offer a rapid no-float option for a fee, win-win for them. On Thu, Nov 19, 2020 at 5:54 PM David Carlson wrote: > In the olden days some people would even try to take advantage of having a > lot of funds in "float" between various bank accounts. 來 > > On Thu, Nov 19, 2020, 6:12 PM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > Griff, > > > > Sorry, I misunderstood the original post. I thought it was a single > > import, not two separate ones. > > > > David's suggestions should be the way to go in your case. > > > > As for retaining the second date, (presumably from the Credit Card > > account) see my reply to Frank. > > > > Regards, > > Adrien > > > > On 11/19/20 3:18 PM, Griff wrote: > > > Thanks Adrien and Stephen. > > > > > > Both your solutions are good work arounds, sounds like the short answer > > is > > > it can't be done the nice way preserving data. The result will be to > > > manually delete one of the import transactions and the new duplicate > > > created won't have the date that matches one of the 2 banks for > > correctness > > > purposes. > > > > > > To your suggestion of importing it all at once, that is not possible as > > one > > > QFX file is from the credit card company download and the other QFX is > > from > > > the different bank company's download. They will be two files. > > > > > > This is unfortunate as the matcher is only run on QIF import and not > > > OFX/QFX import. > > > Should I be getting the data from the banks in QIF instead, does that > > work > > > better then OFX/QFX for GnuCash import? > > > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription
Re: [GNC] Wrong starting balance
I know that GnuCash uses an internal thing that you must be calling *identity* rather the text string that appears in the display, but I couldn't remember what GnuCash called it. On Sat, Nov 21, 2020 at 11:42 AM Fred Bone wrote: > On 20 November 2020 at 22:09, David Carlson said: > > > As I started to suggest in my previous email, if a given split line > > contains a 'Y' reconcile status, that implies that the transaction split > > line passed a reconciliation process for that account on a certain date > > recorded within the data file, but not visible to users. If the account > > name or it's representation in the data file changes in that split line, > > or if the transaction date changes as associated with that split line, > > then the 'Y' status should be revoked. > > It's not the account *name* that matters, but the account *identity*. The > split only references the name indirectly. > > If my credit card provider renames itself and I rename the relevant > account to match, that should not be a reason for un-reconciling > anything. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Wrong starting balance
On 20 November 2020 at 22:09, David Carlson said: > As I started to suggest in my previous email, if a given split line > contains a 'Y' reconcile status, that implies that the transaction split > line passed a reconciliation process for that account on a certain date > recorded within the data file, but not visible to users. If the account > name or it's representation in the data file changes in that split line, > or if the transaction date changes as associated with that split line, > then the 'Y' status should be revoked. It's not the account *name* that matters, but the account *identity*. The split only references the name indirectly. If my credit card provider renames itself and I rename the relevant account to match, that should not be a reason for un-reconciling anything. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Wrong starting balance
On 11/20/20 6:23 PM, Liz wrote: On Fri, 20 Nov 2020 17:58:38 -0800 "Stephen M. Butler" wrote: Try to reconcile another account that has never been reconciled. If that comes up with a non-zero number then create a new account and attempt to reconcile with no entries. If that comes up with a non-zero amount then you have found a bug. What I'm wondering is if there are no entries to add up the module might not be handling the results correctly. I tested that possibility, and it was negative. Fortunately I found where the problem was, and it is related to the user. I did not expect when I moved transactions from the bank account to a holding account that the reconcile flag for the bank account would remain. It may be a bug. Liz At least the bug I was envisioning isn't there! Yes, I would call that behavior a bug. More urgent than an enhancement request. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.