Re: Headers for importing accounts from CSV
FYI: Commodityn=commodity namespace=CURRENCY for currencies or NASDAQ for commodities on NASDAQ (see https://www.gnucash.org/docs/v2.6/C/gnucash-help/tool-security-edit.html) Commoditym=commodity mnemonic=USD for us dollar or AAPL for Apple stock=the symbol in the page referenced hereabove On Feb 15, 2018 23:46, "Adrien Monteleone" wrote: > Holly, > > I’m relying on what I see from an export, but here’s something that might > help: > > ‘full_name' is the entire tree path, so 'Assets:Current Assets:Cash In > Wallet' > > where ‘name’ is just ‘Cash In Wallet’ > > All of my ‘commoditym’ fields contain ‘USD’ and all of my ‘commodityn’ > fields contain ‘CURRENCY’ if that helps. > > I see the export doesn’t include trading accounts so I can’t help with > what the other options are for ‘commodityn’. My suspicion would be it is > used for stocks or mutual funds. (STOCK and FUND respectively would be the > likely data) > > I tried looking for an explanation of the fields online, but haven’t > managed to find them yet. > > > Regards, > Adrien > > > On Feb 15, 2018, at 1:28 PM, Holly Ochidi wrote: > > > > [image: Inline image 1] > > > > Kindly, please describe the column headers and where the data points to: > > > > name vs. full_name > > commoditym > > commodityn > > > > I have attempted to use the following entries for "commoditym" and > > "commodityn" without success: > > USD > > US Dollar > > > > Also, I assume the columns "hidden" and "place_holder" should hold a TRUE > > or FALSE? or should it be a "0" or "1"? > > > > Also, what values can I put under the "tax" column to automatically > create > > accounts with the correct Income Tax account designations? > > > > I believe I understand the remaining columns. > > > > Much appreciation! > > > > Regards, > > > > Holly Ochidi > > ___ > > 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 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: QFX Import and Reconciled Transactions
No problem David. I was interested because I was importing OFX data at the time I saw the post and I have often been confused about exactly what happens, even though most of the time it works without any problem. It appears that that when R is checked in the import window, it sets the A column in the account register (not R as I previously claimed - I just noticed this) to "c", but not to "y" , which is set when it is reconciled by the reconciliation process. I agree it would be nice to have some improvement on the documentation around importing. Even nicer might be some tooltips on the column headers in the various windows. Cheers David - 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: QFX Import and Reconciled Transactions
DaveC49, If it appeared that I was talking to you I apologize. I was using a cellphone and couldn't see what I was doing. I was trying to emphasize to Ramble that importing should not be confused with reconciling. The documentation has been very sparse and vague so it does not help to clear up confusion. I believe that some work is being done to improve the process in the 3.0 release, but I have not had time to research what is going on. David C On Thu, Feb 15, 2018 at 9:57 PM, DaveC49 wrote: > Hi David, > > Agreed that the process of importing of transactions to an account is a > separate and distinct process from that of reconciliation with an external > statement. > > Given that however, the import process, if it matches an existing > transaction in your accounts will classify a transaction as "Reconcile > (auto) match" and the R column is checked. What I am unsure of is whether > this will set the "reconciled" flag on the transaction. > > I just tried reimporting an OFX file which I imported earlier today and it > correctly matched all transactions as currently existing ( these had not > been reconciled against a statement and the reconcile flag was not set in > the account register). I was reluctant to hit OK to see whether it sets the > reconcile flag on the transaction records, but I took the risk of having to > unset a month's records, and it *does not *set the reconcile flag on > re-importing and justs skips importing the records which is the desirable > behaviour (from my point of view). It is the use of reconcile in the > context > of importing that is confusing. I would prefer to see a more explanatory > message like "Auto match to existing record - skipping import" in that > comment field, i.e. not use reconcile in this context because of the > confusing the process with reconciliation. > > The original question I answered was referring, I think, specifically to > the > import process matching imported transactions to already reconciled > transactions, i.e. those with the reconcile flag already set in the account > register and not just the R column set in the import process (and the > "Reconcile (auto) match" in the comment field of the transaction). > > I have not specifically tested whether Gnucash actually does that yet but I > will give it a go with a test set of books later today and see what > actually > does happen. I remember finding documentation of the Bayesian matching and > what the flags (A, U+R, R ) mean being veryhard to come by a year or two > ago > and John Ralls spelled it out for me in a reply to a question at that time, > however I can't find that in the archives but this one does have it > http://gnucash.1415818.n4.nabble.com/How-does-AqBanking- > work-A-U-R-and-R-td4661099.html > or > http://gnucash.1415818.n4.nabble.com/When-importing-QFX- > what-does-U-R-actually-do-td4689755.html. > > > > - > 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. > ___ 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: QFX Import and Reconciled Transactions
Hi David, Agreed that the process of importing of transactions to an account is a separate and distinct process from that of reconciliation with an external statement. Given that however, the import process, if it matches an existing transaction in your accounts will classify a transaction as "Reconcile (auto) match" and the R column is checked. What I am unsure of is whether this will set the "reconciled" flag on the transaction. I just tried reimporting an OFX file which I imported earlier today and it correctly matched all transactions as currently existing ( these had not been reconciled against a statement and the reconcile flag was not set in the account register). I was reluctant to hit OK to see whether it sets the reconcile flag on the transaction records, but I took the risk of having to unset a month's records, and it *does not *set the reconcile flag on re-importing and justs skips importing the records which is the desirable behaviour (from my point of view). It is the use of reconcile in the context of importing that is confusing. I would prefer to see a more explanatory message like "Auto match to existing record - skipping import" in that comment field, i.e. not use reconcile in this context because of the confusing the process with reconciliation. The original question I answered was referring, I think, specifically to the import process matching imported transactions to already reconciled transactions, i.e. those with the reconcile flag already set in the account register and not just the R column set in the import process (and the "Reconcile (auto) match" in the comment field of the transaction). I have not specifically tested whether Gnucash actually does that yet but I will give it a go with a test set of books later today and see what actually does happen. I remember finding documentation of the Bayesian matching and what the flags (A, U+R, R ) mean being veryhard to come by a year or two ago and John Ralls spelled it out for me in a reply to a question at that time, however I can't find that in the archives but this one does have it http://gnucash.1415818.n4.nabble.com/How-does-AqBanking-work-A-U-R-and-R-td4661099.html or http://gnucash.1415818.n4.nabble.com/When-importing-QFX-what-does-U-R-actually-do-td4689755.html. - 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: QFX Import and Reconciled Transactions
Please do not confuse importing transactions with reconciliation. While you must develop a procedure that is efficient, the OFX import is very error prone and needs to be checked against another reference. David C On Feb 15, 2018 6:16 PM, "DaveC49" wrote: > Any matching procedure on an import is not going to be perfect. Make the > criteria too tight and almost nothing is matched. Too loose and everything > is matched, so it is always a compromise. > > I have found the order in which I process the OFX imports from my various > accounts can have some impact on matching or at least the number of > transactions to an account which will be matched. I have one bank general > purpose account from which transfers to other accounts (credit card, > account > connected to Paypal, savings accounts) are more common so I usually import > it first as there are then a smaller number of transactions in the other > accounts which are automatically matched so they are easier to check. If I > import the other accounts first then the odds of a mismatch are increased > and there are many more matches to existing transactions. > > Perhaps one of the developers may be able to comment on how the matching > occurs, but I would imagine it is first a match on the amount and then on > proximity of the dates. The README on the Github gives some idea of how the > importer works although not detail of its opearation. > > At best matching on the importer can only be a guide and its results always > need to be checked. I usually find any errors I haven't picked up at import > when I do a reconciliation against the issued statements but my bank now > only issues statements six monthly on some accounts and quarterly on others > and only my credit card has a monthly statement (one example of the many > improvements to customer service) so it takes longer to find errors now. > > There are also a number of previous discussions of matching in the > archives. > I odn't hthink the code has changed a lot recently. > > David > > > > - > 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. > ___ 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: trial balance - how to find mismatch question
How timely. Any way to solve this or do I just chalk it up? Regards, Adrien > On Feb 15, 2018, at 8:00 PM, David Carlson > wrote: > > If you have multiple currencies or if you buy and sell commodities or > securities there is another level of opportunities for issues. > > David C > > On Feb 15, 2018 5:55 PM, "Adrien Monteleone" > wrote: > I just noticed the subject was wrong due to a user-digest error, re-applying > the original. > > ——— > > I’m having a bit of issue understanding the point of the trial-balance report > in modern times. (I generally don’t use it as I mentioned) > > If each transaction self-balances, that is, debits = credits, how is it > possible to add up the debits individually and the credits individually and > not get a result that still balances? You can’t add up 1+2+3 = 5 and 1+2+3 = > 6. It’s a mathematical impossibility. > > In addition, if you enter a transaction that doesn’t balance, Gnucash forces > it to balance by using either the imbalance or orphan accounts. So at least > you’re alerted to amounts you need to fix, but technically, debits still > equal credits. > > Let’s assume I entered a transaction backwards and debited my cash account > instead of crediting it, and credited an expense account instead of debiting > it. This should not affect the trial-balance. Sure, the amounts are wrong for > each account, but they still balance. Debits still equal credits. > > If I transpose two digits (the divisible by ‘9’ trick) then as long as my > individual transaction I did this in balances, it still shouldn’t show up as > an imbalance on the trial-balance report. The other side would ALSO have to > be transposed or incorrect to match it. Gnucash won’t save the transaction > unless it’s balanced. > > I can’t see what possible error could produce individually balanced > transactions (required by Gnucash) and yet still have a trial-balance where > the debits do not equal credits AND both the imbalance account and orphan > accounts are empty. > > (note, I understand why this report is run with paper records because you’re > copying stuff all over the place and might do so incorrectly. But this isn’t > the case with Gnucash) > > Regards, > Adrien > > > On Feb 15, 2018, at 5:06 PM, Adrien Monteleone > > wrote: > > > > The 1899 date seems to make me think that has something to do with a > > setting in your OS concerning how to interpret 2-year dates. (I don’t think > > Gnucash has this option, it might be hard coded) > > > > Try running the report again and make sure to enter the full 4-digit date > > and not just ’16’. Also, test with 12/30/2016 and 01/01/2017 and see if it > > does the same thing or only on exactly 12/31/2016. You might have some > > corrupt data. That might even be the source date of the imbalance. > > > > I just entered those two dates in the same report and it worked fine, so > > this wouldn’t be a generic bug to the app, though it might be a bug for a > > certain platform. (I’m on macOS 10.13 at the moment) > > > > Since you’ve narrowed down to a few weeks, I’d just take a look at the > > General Ledger which contains all transactions from all accounts. Click on > > View > Filter By… and set your date range. (maybe even a day before and > > after just to be thorough) Also be sure to check all boxes on the Status > > tab in the Filter options. You want to see all transactions for that date > > range. Then just look over them and see if anything looks out of place. In > > particular, look for either the amount you are out of balance by or half > > that amount if the variance is an even number. (meaning you have an entry > > that is entered in reverse debit/credit, or entirely duplicated) > > > > For myself, I think I want to tackle one other area first. I recall doing > > some re-organization and I went through a series of unposting paid invoices > > and reposting them, causing my lot assignments to get out of whack. I know > > I have some open lots that shouldn’t be there and many that are applied to > > the wrong documents. I’ll clean that up first, then re-run the trial > > balance and see if that does the trick. I’m not sure where the > > Trial-Balance report is pulling its numbers from, but it won’t hurt to > > perform that cleanup anyway. > > > > Regards, > > Adrien > > > >> On Feb 15, 2018, at 2:35 PM, Elmar wrote: > >> > >> > >> > >> On 02/15/2018 02:28 PM, gnucash-user-requ...@gnucash.org wrote: > >>> -- > >>> > >>> Message: 1 > >>> Date: Thu, 15 Feb 2018 13:27:17 -0600 > >>> From: Adrien Monteleone > >>> To: "gnucash-user@gnucash.org" > >>> Subject: Re: trial balance - how to find mismatch question > >>> Message-ID: <823da1a8-b449-470f-ab10-e66505686...@gmail.com> > >>> Content-Type: text/plain; charset=utf-8 > >>> ... > >>> > >>> Elmar, > >>> > >>> Reduce your ending date so the range is half of what it was. Re-run th
Re: trial balance - how to find mismatch question
It seems at least in my case, the imbalance really appears to be Gnucash’s fault. I narrowed down the date to my opening date. This should be easy right? Not so fast. Of course, everything is in balance as I expected it to be. So I decided to compare the report totals for each account to the individual amounts in the accounts themselves. Bingo. The Trial Balance report shows the wrong total for one account, by the amount of the discrepancy listed on the report. The account in question is an asset account for silver bullion held in ounces of XAG. (not entirely appropriate I’m sure, but since I can’t create my own currency, this is the best I could muster and the price is reasonably close for my purposes) I was retrieving prices automatically, but can’t seem to get finance quote to consistently work, so I just enter the numbers by hand each month. (I’m not an active trader, this is on-hand stuff) The very first price, I set the same as my opening book date and it is manually entered. It seems Gnucash is shortcutting on this report and causing a rounding error. The commodity itself is held accurate to 6 decimal places, but the USD conversion rounds off to whole ¢. I don’t want to add decimals for all of my accounts just to satisfy that report. (which I never use anyway) There are several opening balance lines in this account for each type of bullion I had on that date. The trial balance report is taking the total ounces, converting to dollars and using that figure. It is not using the individual USD figures it calculated in order to balance against the equity account. Therefore, this report will always be off and will always tell me I’m out of balance, even when I’m not. (it incidentally reports unrealized losses, presumably based on that account, but since it’s only for one day, I can’t fathom how such a calculation is possible) Regards, Adrien > On Feb 15, 2018, at 5:52 PM, Adrien Monteleone > wrote: > > I just noticed the subject was wrong due to a user-digest error, re-applying > the original. > > ——— > > I’m having a bit of issue understanding the point of the trial-balance report > in modern times. (I generally don’t use it as I mentioned) > > If each transaction self-balances, that is, debits = credits, how is it > possible to add up the debits individually and the credits individually and > not get a result that still balances? You can’t add up 1+2+3 = 5 and 1+2+3 = > 6. It’s a mathematical impossibility. > > In addition, if you enter a transaction that doesn’t balance, Gnucash forces > it to balance by using either the imbalance or orphan accounts. So at least > you’re alerted to amounts you need to fix, but technically, debits still > equal credits. > > Let’s assume I entered a transaction backwards and debited my cash account > instead of crediting it, and credited an expense account instead of debiting > it. This should not affect the trial-balance. Sure, the amounts are wrong for > each account, but they still balance. Debits still equal credits. > > If I transpose two digits (the divisible by ‘9’ trick) then as long as my > individual transaction I did this in balances, it still shouldn’t show up as > an imbalance on the trial-balance report. The other side would ALSO have to > be transposed or incorrect to match it. Gnucash won’t save the transaction > unless it’s balanced. > > I can’t see what possible error could produce individually balanced > transactions (required by Gnucash) and yet still have a trial-balance where > the debits do not equal credits AND both the imbalance account and orphan > accounts are empty. > > (note, I understand why this report is run with paper records because you’re > copying stuff all over the place and might do so incorrectly. But this isn’t > the case with Gnucash) > > Regards, > Adrien > >> On Feb 15, 2018, at 5:06 PM, Adrien Monteleone >> wrote: >> >> The 1899 date seems to make me think that has something to do with a setting >> in your OS concerning how to interpret 2-year dates. (I don’t think Gnucash >> has this option, it might be hard coded) >> >> Try running the report again and make sure to enter the full 4-digit date >> and not just ’16’. Also, test with 12/30/2016 and 01/01/2017 and see if it >> does the same thing or only on exactly 12/31/2016. You might have some >> corrupt data. That might even be the source date of the imbalance. >> >> I just entered those two dates in the same report and it worked fine, so >> this wouldn’t be a generic bug to the app, though it might be a bug for a >> certain platform. (I’m on macOS 10.13 at the moment) >> >> Since you’ve narrowed down to a few weeks, I’d just take a look at the >> General Ledger which contains all transactions from all accounts. Click on >> View > Filter By… and set your date range. (maybe even a day before and >> after just to be thorough) Also be sure to check all boxes on the Status tab >> in the Filter optio
Re: trial balance - how to find mismatch question
If you have multiple currencies or if you buy and sell commodities or securities there is another level of opportunities for issues. David C On Feb 15, 2018 5:55 PM, "Adrien Monteleone" wrote: > I just noticed the subject was wrong due to a user-digest error, > re-applying the original. > > ——— > > I’m having a bit of issue understanding the point of the trial-balance > report in modern times. (I generally don’t use it as I mentioned) > > If each transaction self-balances, that is, debits = credits, how is it > possible to add up the debits individually and the credits individually and > not get a result that still balances? You can’t add up 1+2+3 = 5 and 1+2+3 > = 6. It’s a mathematical impossibility. > > In addition, if you enter a transaction that doesn’t balance, Gnucash > forces it to balance by using either the imbalance or orphan accounts. So > at least you’re alerted to amounts you need to fix, but technically, debits > still equal credits. > > Let’s assume I entered a transaction backwards and debited my cash account > instead of crediting it, and credited an expense account instead of > debiting it. This should not affect the trial-balance. Sure, the amounts > are wrong for each account, but they still balance. Debits still equal > credits. > > If I transpose two digits (the divisible by ‘9’ trick) then as long as my > individual transaction I did this in balances, it still shouldn’t show up > as an imbalance on the trial-balance report. The other side would ALSO have > to be transposed or incorrect to match it. Gnucash won’t save the > transaction unless it’s balanced. > > I can’t see what possible error could produce individually balanced > transactions (required by Gnucash) and yet still have a trial-balance where > the debits do not equal credits AND both the imbalance account and orphan > accounts are empty. > > (note, I understand why this report is run with paper records because > you’re copying stuff all over the place and might do so incorrectly. But > this isn’t the case with Gnucash) > > Regards, > Adrien > > > On Feb 15, 2018, at 5:06 PM, Adrien Monteleone < > adrien.montele...@gmail.com> wrote: > > > > The 1899 date seems to make me think that has something to do with a > setting in your OS concerning how to interpret 2-year dates. (I don’t think > Gnucash has this option, it might be hard coded) > > > > Try running the report again and make sure to enter the full 4-digit > date and not just ’16’. Also, test with 12/30/2016 and 01/01/2017 and see > if it does the same thing or only on exactly 12/31/2016. You might have > some corrupt data. That might even be the source date of the imbalance. > > > > I just entered those two dates in the same report and it worked fine, so > this wouldn’t be a generic bug to the app, though it might be a bug for a > certain platform. (I’m on macOS 10.13 at the moment) > > > > Since you’ve narrowed down to a few weeks, I’d just take a look at the > General Ledger which contains all transactions from all accounts. Click on > View > Filter By… and set your date range. (maybe even a day before and > after just to be thorough) Also be sure to check all boxes on the Status > tab in the Filter options. You want to see all transactions for that date > range. Then just look over them and see if anything looks out of place. In > particular, look for either the amount you are out of balance by or half > that amount if the variance is an even number. (meaning you have an entry > that is entered in reverse debit/credit, or entirely duplicated) > > > > For myself, I think I want to tackle one other area first. I recall > doing some re-organization and I went through a series of unposting paid > invoices and reposting them, causing my lot assignments to get out of > whack. I know I have some open lots that shouldn’t be there and many that > are applied to the wrong documents. I’ll clean that up first, then re-run > the trial balance and see if that does the trick. I’m not sure where the > Trial-Balance report is pulling its numbers from, but it won’t hurt to > perform that cleanup anyway. > > > > Regards, > > Adrien > > > >> On Feb 15, 2018, at 2:35 PM, Elmar wrote: > >> > >> > >> > >> On 02/15/2018 02:28 PM, gnucash-user-requ...@gnucash.org wrote: > >>> -- > >>> > >>> Message: 1 > >>> Date: Thu, 15 Feb 2018 13:27:17 -0600 > >>> From: Adrien Monteleone > >>> To: "gnucash-user@gnucash.org" > >>> Subject: Re: trial balance - how to find mismatch question > >>> Message-ID: <823da1a8-b449-470f-ab10-e66505686...@gmail.com> > >>> Content-Type: text/plain; charset=utf-8 > >>> ... > >>> > >>> Elmar, > >>> > >>> Reduce your ending date so the range is half of what it was. Re-run > the report. Is it s[t]ill out of balance? Keep doing this till you get a > balance, then set that ending date to a new start date, and start working > forwards till you get out of balance again. This will help you narrow
Re: QFX Import and Reconciled Transactions
Any matching procedure on an import is not going to be perfect. Make the criteria too tight and almost nothing is matched. Too loose and everything is matched, so it is always a compromise. I have found the order in which I process the OFX imports from my various accounts can have some impact on matching or at least the number of transactions to an account which will be matched. I have one bank general purpose account from which transfers to other accounts (credit card, account connected to Paypal, savings accounts) are more common so I usually import it first as there are then a smaller number of transactions in the other accounts which are automatically matched so they are easier to check. If I import the other accounts first then the odds of a mismatch are increased and there are many more matches to existing transactions. Perhaps one of the developers may be able to comment on how the matching occurs, but I would imagine it is first a match on the amount and then on proximity of the dates. The README on the Github gives some idea of how the importer works although not detail of its opearation. At best matching on the importer can only be a guide and its results always need to be checked. I usually find any errors I haven't picked up at import when I do a reconciliation against the issued statements but my bank now only issues statements six monthly on some accounts and quarterly on others and only my credit card has a monthly statement (one example of the many improvements to customer service) so it takes longer to find errors now. There are also a number of previous discussions of matching in the archives. I odn't hthink the code has changed a lot recently. David - 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: Headers for importing accounts from CSV
Sorry, I don’t use that feature at all, so I’ll have to defer. Try a google search on the list with “site:lists.gnucash.org” (without the quotes) followed by your search terms. You’ll get hits only from the list archives. There are many threads on OFX and AqWizard and I doubt you’re the first to stumble on this so someone may have a solution buried in past threads. Also, please be sure to copy the list on all replies for non-personal messages as others may benefit from the discussion. Regards, Adrien > On Feb 15, 2018, at 5:30 PM, Holly Ochidi wrote: > > Adrien, > > Any advice on setting up OFX import via AqWizard for a bank that is not > listed? > > > Regards, > > Holly Ochidi > > On Thu, Feb 15, 2018 at 5:24 PM, Holly Ochidi wrote: > Sweet! What a simple solution... Can't believe I didn't think of trying to > make an account then export it. Setting up all the accounts I need one by one > is painful. Thanks for the info! > > > Regards, > > Holly Ochidi > > On Thu, Feb 15, 2018 at 4:49 PM, Adrien Monteleone > wrote: > Sorry, I forgot to mention that in the hidden and place_holder columns, the > export shows ‘F’ and ‘T’ so those should work, but if not, using or 0 or 1 > should suffice. > > The tax column also appears to be binary. I think the setting is just a check > box for each account that asks “Tax Related?” so that makes sense. But I know > the tax report setup is more complicated and likely that data lies somewhere > else. Even after the import, you’ll likely have to set that up separately. > > > Regards, > Adrien > > > On Feb 15, 2018, at 4:45 PM, Adrien Monteleone > > wrote: > > > > Holly, > > > > I’m relying on what I see from an export, but here’s something that might > > help: > > > > ‘full_name' is the entire tree path, so 'Assets:Current Assets:Cash In > > Wallet' > > > > where ‘name’ is just ‘Cash In Wallet’ > > > > All of my ‘commoditym’ fields contain ‘USD’ and all of my ‘commodityn’ > > fields contain ‘CURRENCY’ if that helps. > > > > I see the export doesn’t include trading accounts so I can’t help with what > > the other options are for ‘commodityn’. My suspicion would be it is used > > for stocks or mutual funds. (STOCK and FUND respectively would be the > > likely data) > > > > I tried looking for an explanation of the fields online, but haven’t > > managed to find them yet. > > > > > > Regards, > > Adrien > > > >> On Feb 15, 2018, at 1:28 PM, Holly Ochidi wrote: > >> > >> [image: Inline image 1] > >> > >> Kindly, please describe the column headers and where the data points to: > >> > >> name vs. full_name > >> commoditym > >> commodityn > >> > >> I have attempted to use the following entries for "commoditym" and > >> "commodityn" without success: > >> USD > >> US Dollar > >> > >> Also, I assume the columns "hidden" and "place_holder" should hold a TRUE > >> or FALSE? or should it be a "0" or "1"? > >> > >> Also, what values can I put under the "tax" column to automatically create > >> accounts with the correct Income Tax account designations? > >> > >> I believe I understand the remaining columns. > >> > >> Much appreciation! > >> > >> Regards, > >> > >> Holly Ochidi > >> ___ > >> 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 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: trial balance - how to find mismatch question
I just noticed the subject was wrong due to a user-digest error, re-applying the original. ——— I’m having a bit of issue understanding the point of the trial-balance report in modern times. (I generally don’t use it as I mentioned) If each transaction self-balances, that is, debits = credits, how is it possible to add up the debits individually and the credits individually and not get a result that still balances? You can’t add up 1+2+3 = 5 and 1+2+3 = 6. It’s a mathematical impossibility. In addition, if you enter a transaction that doesn’t balance, Gnucash forces it to balance by using either the imbalance or orphan accounts. So at least you’re alerted to amounts you need to fix, but technically, debits still equal credits. Let’s assume I entered a transaction backwards and debited my cash account instead of crediting it, and credited an expense account instead of debiting it. This should not affect the trial-balance. Sure, the amounts are wrong for each account, but they still balance. Debits still equal credits. If I transpose two digits (the divisible by ‘9’ trick) then as long as my individual transaction I did this in balances, it still shouldn’t show up as an imbalance on the trial-balance report. The other side would ALSO have to be transposed or incorrect to match it. Gnucash won’t save the transaction unless it’s balanced. I can’t see what possible error could produce individually balanced transactions (required by Gnucash) and yet still have a trial-balance where the debits do not equal credits AND both the imbalance account and orphan accounts are empty. (note, I understand why this report is run with paper records because you’re copying stuff all over the place and might do so incorrectly. But this isn’t the case with Gnucash) Regards, Adrien > On Feb 15, 2018, at 5:06 PM, Adrien Monteleone > wrote: > > The 1899 date seems to make me think that has something to do with a setting > in your OS concerning how to interpret 2-year dates. (I don’t think Gnucash > has this option, it might be hard coded) > > Try running the report again and make sure to enter the full 4-digit date and > not just ’16’. Also, test with 12/30/2016 and 01/01/2017 and see if it does > the same thing or only on exactly 12/31/2016. You might have some corrupt > data. That might even be the source date of the imbalance. > > I just entered those two dates in the same report and it worked fine, so this > wouldn’t be a generic bug to the app, though it might be a bug for a certain > platform. (I’m on macOS 10.13 at the moment) > > Since you’ve narrowed down to a few weeks, I’d just take a look at the > General Ledger which contains all transactions from all accounts. Click on > View > Filter By… and set your date range. (maybe even a day before and after > just to be thorough) Also be sure to check all boxes on the Status tab in the > Filter options. You want to see all transactions for that date range. Then > just look over them and see if anything looks out of place. In particular, > look for either the amount you are out of balance by or half that amount if > the variance is an even number. (meaning you have an entry that is entered in > reverse debit/credit, or entirely duplicated) > > For myself, I think I want to tackle one other area first. I recall doing > some re-organization and I went through a series of unposting paid invoices > and reposting them, causing my lot assignments to get out of whack. I know I > have some open lots that shouldn’t be there and many that are applied to the > wrong documents. I’ll clean that up first, then re-run the trial balance and > see if that does the trick. I’m not sure where the Trial-Balance report is > pulling its numbers from, but it won’t hurt to perform that cleanup anyway. > > Regards, > Adrien > >> On Feb 15, 2018, at 2:35 PM, Elmar wrote: >> >> >> >> On 02/15/2018 02:28 PM, gnucash-user-requ...@gnucash.org wrote: >>> -- >>> >>> Message: 1 >>> Date: Thu, 15 Feb 2018 13:27:17 -0600 >>> From: Adrien Monteleone >>> To: "gnucash-user@gnucash.org" >>> Subject: Re: trial balance - how to find mismatch question >>> Message-ID: <823da1a8-b449-470f-ab10-e66505686...@gmail.com> >>> Content-Type: text/plain; charset=utf-8 >>> ... >>> >>> Elmar, >>> >>> Reduce your ending date so the range is half of what it was. Re-run the >>> report. Is it s[t]ill out of balance? Keep doing this till you get a >>> balance, then set that ending date to a new start date, and start working >>> forwards till you get out of balance again. This will help you narrow down >>> where on the calendar the error occurred. >>> >>> Regards, >>> Adrien >> OK - did that and ran into something VERY strange. Everything stayed in >> balance up to 07/12/2016. Setting that as the start date and 12/31/2016 as >> the end date, as soon as I hit "apply", QC overwrites the end date wi
Re: Headers for importing accounts from CSV
Sweet! What a simple solution... Can't believe I didn't think of trying to make an account then export it. Setting up all the accounts I need one by one is painful. Thanks for the info! Regards, Holly Ochidi On Thu, Feb 15, 2018 at 4:49 PM, Adrien Monteleone < adrien.montele...@gmail.com> wrote: > Sorry, I forgot to mention that in the hidden and place_holder columns, > the export shows ‘F’ and ‘T’ so those should work, but if not, using or 0 > or 1 should suffice. > > The tax column also appears to be binary. I think the setting is just a > check box for each account that asks “Tax Related?” so that makes sense. > But I know the tax report setup is more complicated and likely that data > lies somewhere else. Even after the import, you’ll likely have to set that > up separately. > > > Regards, > Adrien > > > On Feb 15, 2018, at 4:45 PM, Adrien Monteleone < > adrien.montele...@gmail.com> wrote: > > > > Holly, > > > > I’m relying on what I see from an export, but here’s something that > might help: > > > > ‘full_name' is the entire tree path, so 'Assets:Current Assets:Cash In > Wallet' > > > > where ‘name’ is just ‘Cash In Wallet’ > > > > All of my ‘commoditym’ fields contain ‘USD’ and all of my ‘commodityn’ > fields contain ‘CURRENCY’ if that helps. > > > > I see the export doesn’t include trading accounts so I can’t help with > what the other options are for ‘commodityn’. My suspicion would be it is > used for stocks or mutual funds. (STOCK and FUND respectively would be the > likely data) > > > > I tried looking for an explanation of the fields online, but haven’t > managed to find them yet. > > > > > > Regards, > > Adrien > > > >> On Feb 15, 2018, at 1:28 PM, Holly Ochidi wrote: > >> > >> [image: Inline image 1] > >> > >> Kindly, please describe the column headers and where the data points to: > >> > >> name vs. full_name > >> commoditym > >> commodityn > >> > >> I have attempted to use the following entries for "commoditym" and > >> "commodityn" without success: > >> USD > >> US Dollar > >> > >> Also, I assume the columns "hidden" and "place_holder" should hold a > TRUE > >> or FALSE? or should it be a "0" or "1"? > >> > >> Also, what values can I put under the "tax" column to automatically > create > >> accounts with the correct Income Tax account designations? > >> > >> I believe I understand the remaining columns. > >> > >> Much appreciation! > >> > >> Regards, > >> > >> Holly Ochidi > >> ___ > >> 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 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: Creating Account for each Vendor to avoid Creating and Paying each Bill?
Nice trick, thanks Chris! Regards, Adrien > On Feb 15, 2018, at 2:47 PM, Chris Good wrote: > > Hi Fran3 & Adrien, > > Currently (2.6.19 or under development in 2.7/3.0), there is no menu option > for exporting customers or vendors. You can do so by using either the > Payables Aging or Receivable Aging reports. Use the report options to choose > the columns that the imports require, then run the report, and copy > everything and paste into a spreadsheet. > > Regards, Chris Good > >> Message: 1 >> Date: Thu, 15 Feb 2018 13:08:25 -0600 >> From: Adrien Monteleone >> To: "gnucash-user@gnucash.org" >> Subject: Re: Creating Account for each Vendor to avoid Creating and >> Paying each Bill? >> Message-ID: <2039cce9-0711-4685-9d6f-712d95d86...@gmail.com> >> Content-Type: text/plain;charset=utf-8 >> >> 2.6.1 is rather old, by a few years. 2.6.19 is the most current version. As >> far as I know, even in the most current version, there is no way to export >> customers and vendors. (might be possible with the upcoming 3.0, but I?m not >> certain on that) The link I provided was on the assumption you needed to >> still put them in. If you have them in and are still wanting to use a >> separate file for each year working backwards in time, that approach isn?t >> needed. >> >> Certainly, working forward in time with new books is trivial, but backwards >> is a bit messy. Others might have better ideas, but the best I can think of >> is to save the file with a 2017 name. Open that instead, delete all >> transactions (which were really 2018) and then import your 2017 data. Your >> customers and vendors will still be there. However, so will your 2018 >> invoices and bills, which you can?t delete, but you could mark ?inactive?. >> Since the year is young, there won?t be too many of them. You could likely >> just edit them with 2017 info. >> >> Certainly, use the tool and process you are most familiar with to meet your >> deadline. Then come back to Gnucash. >> >> When you do, I?d really, really, recommend starting where you want, then >> work forwards in time - all in one book. You?ll find having everything >> together much more flexible reporting wise. If you want or need some sort of >> archive each year, that is easy enough to do: >> >> Create annual reports, saved to PDF. >> Write the reports and the Gnucash file to a read-only medium such as >> CD-ROM/DVD. (not an ?RW? disk though) >> >> This allows you to still easily see and report on prior activity with >> comparison reports, and have a static copy to allay any fears of editing >> prior data, either intentional or accidental. You can also always load that >> static copy for additional reporting if needed. >> >> Regards, >> Adrien >> >>> On Feb 15, 2018, at 8:04 AM, Fran_3 wrote: >>> >>> I see where gnuCash 2.6.1 on Win10 can import customers and vendors... but >>> I can not see how to export them... >>> >>> The File > Export menu offers... >>> >>> 1 - Export Account Tree to CSV >>> 2 - Export Transactions to CSV >>> 3 - Export Accounts >>> >>> BTW, difference between 1 and 3 above ? Maybe 3 just exports the top level >>> of the chart of accounts and 1 exports all including sub accounts... or >>> what? >>> >>> Regarding fast import and assignment of 2017 I think the deadline for the >>> report due will force us to use a spreadsheet as we are very familiar with >>> that and can process quickly... while we are still learning gnuCash. >>> >>> Thanks for the help. >>> >>> Fran3 >>> >>> >>> >>> On Wednesday, February 14, 2018, 8:23:06 PM EST, Adrien Monteleone >>> wrote: >>> >>> >>> There should be no need to create expense sub-accounts for vendors if all >>> you want is a way to see how much you spent with them. (or still owe them >>> at any point) That would also get quite messy if a vendor might sell items >>> that fit in more than one expense account. >>> >>> Create your vendors, create and post your bills, then pay the bills using >>> the Process Payment feature. >>> >>> You can then run a Vendor Report for each vendor for any date range and see >>> total spent and paid to each with full transaction history and clickable >>> links to either the transaction itself or the particular bill. >>> >>> You can also run Payable Aging report to show you any amounts in arrears >>> with links to find the particular bills. >>> >>> Since you have lots of historical data you want to import, and it seems >>> you?ll be importing the vendor payments as part of your checking account >>> import, I?d suggest the following workflow: >>> >>> Create a CSV file with all of your bill data. (you?ll need to create or >>> import your vendors first) >>> Import this CSV to bring your bills in properly. >>> Do a Find on a few bills and run a Vendor Report or two to make sure >>> everything imported okay. >>> Once your checking account transactions are imported (if not already there) >>> you?ll need to click each pa
Re: gnucash-user Digest, Vol 179, Issue 59
The 1899 date seems to make me think that has something to do with a setting in your OS concerning how to interpret 2-year dates. (I don’t think Gnucash has this option, it might be hard coded) Try running the report again and make sure to enter the full 4-digit date and not just ’16’. Also, test with 12/30/2016 and 01/01/2017 and see if it does the same thing or only on exactly 12/31/2016. You might have some corrupt data. That might even be the source date of the imbalance. I just entered those two dates in the same report and it worked fine, so this wouldn’t be a generic bug to the app, though it might be a bug for a certain platform. (I’m on macOS 10.13 at the moment) Since you’ve narrowed down to a few weeks, I’d just take a look at the General Ledger which contains all transactions from all accounts. Click on View > Filter By… and set your date range. (maybe even a day before and after just to be thorough) Also be sure to check all boxes on the Status tab in the Filter options. You want to see all transactions for that date range. Then just look over them and see if anything looks out of place. In particular, look for either the amount you are out of balance by or half that amount if the variance is an even number. (meaning you have an entry that is entered in reverse debit/credit, or entirely duplicated) For myself, I think I want to tackle one other area first. I recall doing some re-organization and I went through a series of unposting paid invoices and reposting them, causing my lot assignments to get out of whack. I know I have some open lots that shouldn’t be there and many that are applied to the wrong documents. I’ll clean that up first, then re-run the trial balance and see if that does the trick. I’m not sure where the Trial-Balance report is pulling its numbers from, but it won’t hurt to perform that cleanup anyway. Regards, Adrien > On Feb 15, 2018, at 2:35 PM, Elmar wrote: > > > > On 02/15/2018 02:28 PM, gnucash-user-requ...@gnucash.org wrote: >> -- >> >> Message: 1 >> Date: Thu, 15 Feb 2018 13:27:17 -0600 >> From: Adrien Monteleone >> To: "gnucash-user@gnucash.org" >> Subject: Re: trial balance - how to find mismatch question >> Message-ID: <823da1a8-b449-470f-ab10-e66505686...@gmail.com> >> Content-Type: text/plain;charset=utf-8 >> ... >> >> Elmar, >> >> Reduce your ending date so the range is half of what it was. Re-run the >> report. Is it s[t]ill out of balance? Keep doing this till you get a >> balance, then set that ending date to a new start date, and start working >> forwards till you get out of balance again. This will help you narrow down >> where on the calendar the error occurred. >> >> Regards, >> Adrien > OK - did that and ran into something VERY strange. Everything stayed in > balance up to 07/12/2016. Setting that as the start date and 12/31/2016 as > the end date, as soon as I hit "apply", QC overwrites the end date with - get > this - 02/27/1899 !!! This of course produces nonsense. One day later > (01/01/2017) works fine and shows the imbalance. So, have I 1) found a bug, > and 2) given I have narrowed the date range to a few weeks, what report > should I run to find the weirdness? - Elmar > ___ > 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: gnucash-user Digest, Vol 179, Issue 59
Elmar, If you have narrowed the date range in which the error has occurred then it is down to old fashioned accounting practices for finding errors. Some of these articles may help: http://www.reallifeaccounting.com/pubs/Article_Theme_Detecting_Accounting_Errors.pdf https://ww2.odu.edu/~lhenry/accterrors.doc https://learn.canvas.net/courses/37/pages/study-identifying-accounting-errors https://talloncpa.sharepoint.com/Pages/FindingBalancingErrors.aspx https://sciencing.com/catch-accounting-bookkeeping-errors-2324699.html David - 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: Headers for importing accounts from CSV
Sorry, I forgot to mention that in the hidden and place_holder columns, the export shows ‘F’ and ‘T’ so those should work, but if not, using or 0 or 1 should suffice. The tax column also appears to be binary. I think the setting is just a check box for each account that asks “Tax Related?” so that makes sense. But I know the tax report setup is more complicated and likely that data lies somewhere else. Even after the import, you’ll likely have to set that up separately. Regards, Adrien > On Feb 15, 2018, at 4:45 PM, Adrien Monteleone > wrote: > > Holly, > > I’m relying on what I see from an export, but here’s something that might > help: > > ‘full_name' is the entire tree path, so 'Assets:Current Assets:Cash In Wallet' > > where ‘name’ is just ‘Cash In Wallet’ > > All of my ‘commoditym’ fields contain ‘USD’ and all of my ‘commodityn’ fields > contain ‘CURRENCY’ if that helps. > > I see the export doesn’t include trading accounts so I can’t help with what > the other options are for ‘commodityn’. My suspicion would be it is used for > stocks or mutual funds. (STOCK and FUND respectively would be the likely data) > > I tried looking for an explanation of the fields online, but haven’t managed > to find them yet. > > > Regards, > Adrien > >> On Feb 15, 2018, at 1:28 PM, Holly Ochidi wrote: >> >> [image: Inline image 1] >> >> Kindly, please describe the column headers and where the data points to: >> >> name vs. full_name >> commoditym >> commodityn >> >> I have attempted to use the following entries for "commoditym" and >> "commodityn" without success: >> USD >> US Dollar >> >> Also, I assume the columns "hidden" and "place_holder" should hold a TRUE >> or FALSE? or should it be a "0" or "1"? >> >> Also, what values can I put under the "tax" column to automatically create >> accounts with the correct Income Tax account designations? >> >> I believe I understand the remaining columns. >> >> Much appreciation! >> >> Regards, >> >> Holly Ochidi >> ___ >> 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: Headers for importing accounts from CSV
Holly, I’m relying on what I see from an export, but here’s something that might help: ‘full_name' is the entire tree path, so 'Assets:Current Assets:Cash In Wallet' where ‘name’ is just ‘Cash In Wallet’ All of my ‘commoditym’ fields contain ‘USD’ and all of my ‘commodityn’ fields contain ‘CURRENCY’ if that helps. I see the export doesn’t include trading accounts so I can’t help with what the other options are for ‘commodityn’. My suspicion would be it is used for stocks or mutual funds. (STOCK and FUND respectively would be the likely data) I tried looking for an explanation of the fields online, but haven’t managed to find them yet. Regards, Adrien > On Feb 15, 2018, at 1:28 PM, Holly Ochidi wrote: > > [image: Inline image 1] > > Kindly, please describe the column headers and where the data points to: > > name vs. full_name > commoditym > commodityn > > I have attempted to use the following entries for "commoditym" and > "commodityn" without success: > USD > US Dollar > > Also, I assume the columns "hidden" and "place_holder" should hold a TRUE > or FALSE? or should it be a "0" or "1"? > > Also, what values can I put under the "tax" column to automatically create > accounts with the correct Income Tax account designations? > > I believe I understand the remaining columns. > > Much appreciation! > > Regards, > > Holly Ochidi > ___ > 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.
[no subject]
Hi Fran3 & Adrien, Currently (2.6.19 or under development in 2.7/3.0), there is no menu option for exporting customers or vendors. You can do so by using either the Payables Aging or Receivable Aging reports. Use the report options to choose the columns that the imports require, then run the report, and copy everything and paste into a spreadsheet. Regards, Chris Good > Message: 1 > Date: Thu, 15 Feb 2018 13:08:25 -0600 > From: Adrien Monteleone > To: "gnucash-user@gnucash.org" > Subject: Re: Creating Account for each Vendor to avoid Creating and >Paying each Bill? > Message-ID: <2039cce9-0711-4685-9d6f-712d95d86...@gmail.com> > Content-Type: text/plain;charset=utf-8 > > 2.6.1 is rather old, by a few years. 2.6.19 is the most current version. As > far as I know, even in the most current version, there is no way to export > customers and vendors. (might be possible with the upcoming 3.0, but I?m not > certain on that) The link I provided was on the assumption you needed to > still put them in. If you have them in and are still wanting to use a > separate file for each year working backwards in time, that approach isn?t > needed. > > Certainly, working forward in time with new books is trivial, but backwards > is a bit messy. Others might have better ideas, but the best I can think of > is to save the file with a 2017 name. Open that instead, delete all > transactions (which were really 2018) and then import your 2017 data. Your > customers and vendors will still be there. However, so will your 2018 > invoices and bills, which you can?t delete, but you could mark ?inactive?. > Since the year is young, there won?t be too many of them. You could likely > just edit them with 2017 info. > > Certainly, use the tool and process you are most familiar with to meet your > deadline. Then come back to Gnucash. > > When you do, I?d really, really, recommend starting where you want, then work > forwards in time - all in one book. You?ll find having everything together > much more flexible reporting wise. If you want or need some sort of archive > each year, that is easy enough to do: > > Create annual reports, saved to PDF. > Write the reports and the Gnucash file to a read-only medium such as > CD-ROM/DVD. (not an ?RW? disk though) > > This allows you to still easily see and report on prior activity with > comparison reports, and have a static copy to allay any fears of editing > prior data, either intentional or accidental. You can also always load that > static copy for additional reporting if needed. > > Regards, > Adrien > >> On Feb 15, 2018, at 8:04 AM, Fran_3 wrote: >> >> I see where gnuCash 2.6.1 on Win10 can import customers and vendors... but I >> can not see how to export them... >> >> The File > Export menu offers... >> >> 1 - Export Account Tree to CSV >> 2 - Export Transactions to CSV >> 3 - Export Accounts >> >> BTW, difference between 1 and 3 above ? Maybe 3 just exports the top level >> of the chart of accounts and 1 exports all including sub accounts... or what? >> >> Regarding fast import and assignment of 2017 I think the deadline for the >> report due will force us to use a spreadsheet as we are very familiar with >> that and can process quickly... while we are still learning gnuCash. >> >> Thanks for the help. >> >> Fran3 >> >> >> >> On Wednesday, February 14, 2018, 8:23:06 PM EST, Adrien Monteleone >> wrote: >> >> >> There should be no need to create expense sub-accounts for vendors if all >> you want is a way to see how much you spent with them. (or still owe them at >> any point) That would also get quite messy if a vendor might sell items that >> fit in more than one expense account. >> >> Create your vendors, create and post your bills, then pay the bills using >> the Process Payment feature. >> >> You can then run a Vendor Report for each vendor for any date range and see >> total spent and paid to each with full transaction history and clickable >> links to either the transaction itself or the particular bill. >> >> You can also run Payable Aging report to show you any amounts in arrears >> with links to find the particular bills. >> >> Since you have lots of historical data you want to import, and it seems >> you?ll be importing the vendor payments as part of your checking account >> import, I?d suggest the following workflow: >> >> Create a CSV file with all of your bill data. (you?ll need to create or >> import your vendors first) >> Import this CSV to bring your bills in properly. >> Do a Find on a few bills and run a Vendor Report or two to make sure >> everything imported okay. >> Once your checking account transactions are imported (if not already there) >> you?ll need to click each payment to a vendor and use the ?assign as >> payment? option. This will then give you the ?process payment? window where >> you can search for a vendor, see all of their unpaid bills, then assign the >> transaction as a
Re: 1. How do I update the AqWizard version within GnuCash v. 2.6.19 on Windows
> On Feb 15, 2018, at 11:22 AM, Holly Ochidi wrote: > > So for setting up a new user, the AqBanking version that is installed with > GnuCash 2.6.19 is not updated. I do not have the option of entering the > Bank Code while creating a new user (see attachment AqBankingUsers.jpg). > Also, the choices of connection type are limited in my current version (see > attachment AqBankingNewUser.jpg). > > Is it possible to update the version of AqBanking used within this build? > Do I have to download the GnuCash 2.7 (unstable) version? > No, you have to get Martin Preuss to do a new *stable* release with the features you want. When he does that it will get bundled into the next GnuCash release. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user 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: gnucash-user Digest, Vol 179, Issue 59
On 02/15/2018 02:28 PM, gnucash-user-requ...@gnucash.org wrote: -- Message: 1 Date: Thu, 15 Feb 2018 13:27:17 -0600 From: Adrien Monteleone To: "gnucash-user@gnucash.org" Subject: Re: trial balance - how to find mismatch question Message-ID: <823da1a8-b449-470f-ab10-e66505686...@gmail.com> Content-Type: text/plain; charset=utf-8 ... Elmar, Reduce your ending date so the range is half of what it was. Re-run the report. Is it s[t]ill out of balance? Keep doing this till you get a balance, then set that ending date to a new start date, and start working forwards till you get out of balance again. This will help you narrow down where on the calendar the error occurred. Regards, Adrien OK - did that and ran into something VERY strange. Everything stayed in balance up to 07/12/2016. Setting that as the start date and 12/31/2016 as the end date, as soon as I hit "apply", QC overwrites the end date with - get this - 02/27/1899 !!! This of course produces nonsense. One day later (01/01/2017) works fine and shows the imbalance. So, have I 1) found a bug, and 2) given I have narrowed the date range to a few weeks, what report should I run to find the weirdness? - Elmar ___ 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: Creating Account for each Vendor to avoid Creating and Paying each Bill?
Thanks Adrien, Actually we are using 2.6.19. Looks like I didn't type the number "9" at the end of my last post. Roger on deleting all 2018 transactions but not being able to delete invoices and bills. What we do when we want to 'delete' an invoice or bill is... 1 - create vendor and customers named Parked.2 - open the invoice or bill we want to delete and zero it out and change the customer or vendor to 'Parked'3 - Then later we can use them by change the vendor or customer name, etc. Seems to work... so far in our new adventure with gnuCash :-) Thanks again for your help. Fran3 On Thursday, February 15, 2018, 2:09:04 PM EST, Adrien Monteleone wrote: 2.6.1 is rather old, by a few years. 2.6.19 is the most current version. As far as I know, even in the most current version, there is no way to export customers and vendors. (might be possible with the upcoming 3.0, but I’m not certain on that) The link I provided was on the assumption you needed to still put them in. If you have them in and are still wanting to use a separate file for each year working backwards in time, that approach isn’t needed. Certainly, working forward in time with new books is trivial, but backwards is a bit messy. Others might have better ideas, but the best I can think of is to save the file with a 2017 name. Open that instead, delete all transactions (which were really 2018) and then import your 2017 data. Your customers and vendors will still be there. However, so will your 2018 invoices and bills, which you can’t delete, but you could mark ‘inactive’. Since the year is young, there won’t be too many of them. You could likely just edit them with 2017 info. Certainly, use the tool and process you are most familiar with to meet your deadline. Then come back to Gnucash. When you do, I’d really, really, recommend starting where you want, then work forwards in time - all in one book. You’ll find having everything together much more flexible reporting wise. If you want or need some sort of archive each year, that is easy enough to do: Create annual reports, saved to PDF. Write the reports and the Gnucash file to a read-only medium such as CD-ROM/DVD. (not an ‘RW’ disk though) This allows you to still easily see and report on prior activity with comparison reports, and have a static copy to allay any fears of editing prior data, either intentional or accidental. You can also always load that static copy for additional reporting if needed. Regards, Adrien > On Feb 15, 2018, at 8:04 AM, Fran_3 wrote: > > I see where gnuCash 2.6.1 on Win10 can import customers and vendors... but I > can not see how to export them... > > The File > Export menu offers... > > 1 - Export Account Tree to CSV > 2 - Export Transactions to CSV > 3 - Export Accounts > > BTW, difference between 1 and 3 above ? Maybe 3 just exports the top level of > the chart of accounts and 1 exports all including sub accounts... or what? > > Regarding fast import and assignment of 2017 I think the deadline for the > report due will force us to use a spreadsheet as we are very familiar with > that and can process quickly... while we are still learning gnuCash. > > Thanks for the help. > > Fran3 > > > > On Wednesday, February 14, 2018, 8:23:06 PM EST, Adrien Monteleone > wrote: > > > There should be no need to create expense sub-accounts for vendors if all you > want is a way to see how much you spent with them. (or still owe them at any > point) That would also get quite messy if a vendor might sell items that fit > in more than one expense account. > > Create your vendors, create and post your bills, then pay the bills using the > Process Payment feature. > > You can then run a Vendor Report for each vendor for any date range and see > total spent and paid to each with full transaction history and clickable > links to either the transaction itself or the particular bill. > > You can also run Payable Aging report to show you any amounts in arrears with > links to find the particular bills. > > Since you have lots of historical data you want to import, and it seems > you’ll be importing the vendor payments as part of your checking account > import, I’d suggest the following workflow: > > Create a CSV file with all of your bill data. (you’ll need to create or > import your vendors first) > Import this CSV to bring your bills in properly. > Do a Find on a few bills and run a Vendor Report or two to make sure > everything imported okay. > Once your checking account transactions are imported (if not already there) > you’ll need to click each payment to a vendor and use the ‘assign as payment’ > option. This will then give you the ‘process payment’ window where you can > search for a vendor, see all of their unpaid bills, then assign the > transaction as a payment. (be mindful the dates, amounts, and check# are > correct and that it is taking the payment from the proper account) > > Now, everything is im
Re: trial balance - how to find mismatch question
I don’t perform a close-books operation so I never bothered with this report. On a whim I ran it to see what would happen. I’m pretty careful about all of my transactions. Each of them self-balances and my imbalance and orphan accounts are empty. Yet, sure enough, the Trial Balance has $111.59 too much in debits. An even amount might clue me into a duplicate somewhere, but an odd amount has me stumped. (even with a duplicate, wouldn’t the credits also be duplicated?) Time to play the narrow down the date range game I suppose. Elmar, Reduce your ending date so the range is half of what it was. Re-run the report. Is it sill out of balance? Keep doing this till you get a balance, then set that ending date to a new start date, and start working forwards till you get out of balance again. This will help you narrow down where on the calendar the error occurred. Regards, Adrien > On Feb 15, 2018, at 9:13 AM, Elmar wrote: > > The recent threads on trial balances has me wondering why mine seems to be > ~$1600 out of balance, despite having everything else in the account balance > and reconcile correctly, i.e. nothing in the imbalance account, and setting > the dates to the earliest date in the file and today. Either I am not using > it correctly or I do not understand how to 1) use it and 2) find out what to > do when it doesn't balance. Is there a tutorial? The webpage documents > (section 10.3.4.11. Trial Balance) doesn't give much help. - Elmar > > ___ > 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: Creating Account for each Vendor to avoid Creating and Paying each Bill?
2.6.1 is rather old, by a few years. 2.6.19 is the most current version. As far as I know, even in the most current version, there is no way to export customers and vendors. (might be possible with the upcoming 3.0, but I’m not certain on that) The link I provided was on the assumption you needed to still put them in. If you have them in and are still wanting to use a separate file for each year working backwards in time, that approach isn’t needed. Certainly, working forward in time with new books is trivial, but backwards is a bit messy. Others might have better ideas, but the best I can think of is to save the file with a 2017 name. Open that instead, delete all transactions (which were really 2018) and then import your 2017 data. Your customers and vendors will still be there. However, so will your 2018 invoices and bills, which you can’t delete, but you could mark ‘inactive’. Since the year is young, there won’t be too many of them. You could likely just edit them with 2017 info. Certainly, use the tool and process you are most familiar with to meet your deadline. Then come back to Gnucash. When you do, I’d really, really, recommend starting where you want, then work forwards in time - all in one book. You’ll find having everything together much more flexible reporting wise. If you want or need some sort of archive each year, that is easy enough to do: Create annual reports, saved to PDF. Write the reports and the Gnucash file to a read-only medium such as CD-ROM/DVD. (not an ‘RW’ disk though) This allows you to still easily see and report on prior activity with comparison reports, and have a static copy to allay any fears of editing prior data, either intentional or accidental. You can also always load that static copy for additional reporting if needed. Regards, Adrien > On Feb 15, 2018, at 8:04 AM, Fran_3 wrote: > > I see where gnuCash 2.6.1 on Win10 can import customers and vendors... but I > can not see how to export them... > > The File > Export menu offers... > > 1 - Export Account Tree to CSV > 2 - Export Transactions to CSV > 3 - Export Accounts > > BTW, difference between 1 and 3 above ? Maybe 3 just exports the top level of > the chart of accounts and 1 exports all including sub accounts... or what? > > Regarding fast import and assignment of 2017 I think the deadline for the > report due will force us to use a spreadsheet as we are very familiar with > that and can process quickly... while we are still learning gnuCash. > > Thanks for the help. > > Fran3 > > > > On Wednesday, February 14, 2018, 8:23:06 PM EST, Adrien Monteleone > wrote: > > > There should be no need to create expense sub-accounts for vendors if all you > want is a way to see how much you spent with them. (or still owe them at any > point) That would also get quite messy if a vendor might sell items that fit > in more than one expense account. > > Create your vendors, create and post your bills, then pay the bills using the > Process Payment feature. > > You can then run a Vendor Report for each vendor for any date range and see > total spent and paid to each with full transaction history and clickable > links to either the transaction itself or the particular bill. > > You can also run Payable Aging report to show you any amounts in arrears with > links to find the particular bills. > > Since you have lots of historical data you want to import, and it seems > you’ll be importing the vendor payments as part of your checking account > import, I’d suggest the following workflow: > > Create a CSV file with all of your bill data. (you’ll need to create or > import your vendors first) > Import this CSV to bring your bills in properly. > Do a Find on a few bills and run a Vendor Report or two to make sure > everything imported okay. > Once your checking account transactions are imported (if not already there) > you’ll need to click each payment to a vendor and use the ‘assign as payment’ > option. This will then give you the ‘process payment’ window where you can > search for a vendor, see all of their unpaid bills, then assign the > transaction as a payment. (be mindful the dates, amounts, and check# are > correct and that it is taking the payment from the proper account) > > Now, everything is imported and properly assigned just as if you had entered > it in real time originally from scratch. > > As an added tip, when assigning payment to a transaction, I’d recommend > tagging that transaction with the bill number from the Vendor. (or something > to ID the payment for if the vendor doesn’t use invoice #s) Gnucash doesn’t > make it easy by default to see what bills a payment applies to. (possible, > just not easy) You’ll probably want to know that info from time to time when > looking at a register. You have two main options here. Either turn on View > > Double-line mode and use the Notes line for this info, or place it in the > Memo of the split for e
trial balance - how to find mismatch question
The recent threads on trial balances has me wondering why mine seems to be ~$1600 out of balance, despite having everything else in the account balance and reconcile correctly, i.e. nothing in the imbalance account, and setting the dates to the earliest date in the file and today. Either I am not using it correctly or I do not understand how to 1) use it and 2) find out what to do when it doesn't balance. Is there a tutorial? The webpage documents (section 10.3.4.11. Trial Balance) doesn't give much help. - Elmar ___ 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: Creating Account for each Vendor to avoid Creating and Paying each Bill?
I see where gnuCash 2.6.1 on Win10 can import customers and vendors... but I can not see how to export them... The File > Export menu offers... 1 - Export Account Tree to CSV2 - Export Transactions to CSV3 - Export Accounts BTW, difference between 1 and 3 above ? Maybe 3 just exports the top level of the chart of accounts and 1 exports all including sub accounts... or what? Regarding fast import and assignment of 2017 I think the deadline for the report due will force us to use a spreadsheet as we are very familiar with that and can process quickly... while we are still learning gnuCash. Thanks for the help. Fran3 On Wednesday, February 14, 2018, 8:23:06 PM EST, Adrien Monteleone wrote: There should be no need to create expense sub-accounts for vendors if all you want is a way to see how much you spent with them. (or still owe them at any point) That would also get quite messy if a vendor might sell items that fit in more than one expense account. Create your vendors, create and post your bills, then pay the bills using the Process Payment feature. You can then run a Vendor Report for each vendor for any date range and see total spent and paid to each with full transaction history and clickable links to either the transaction itself or the particular bill. You can also run Payable Aging report to show you any amounts in arrears with links to find the particular bills. Since you have lots of historical data you want to import, and it seems you’ll be importing the vendor payments as part of your checking account import, I’d suggest the following workflow: Create a CSV file with all of your bill data. (you’ll need to create or import your vendors first) Import this CSV to bring your bills in properly. Do a Find on a few bills and run a Vendor Report or two to make sure everything imported okay. Once your checking account transactions are imported (if not already there) you’ll need to click each payment to a vendor and use the ‘assign as payment’ option. This will then give you the ‘process payment’ window where you can search for a vendor, see all of their unpaid bills, then assign the transaction as a payment. (be mindful the dates, amounts, and check# are correct and that it is taking the payment from the proper account) Now, everything is imported and properly assigned just as if you had entered it in real time originally from scratch. As an added tip, when assigning payment to a transaction, I’d recommend tagging that transaction with the bill number from the Vendor. (or something to ID the payment for if the vendor doesn’t use invoice #s) Gnucash doesn’t make it easy by default to see what bills a payment applies to. (possible, just not easy) You’ll probably want to know that info from time to time when looking at a register. You have two main options here. Either turn on View > Double-line mode and use the Notes line for this info, or place it in the Memo of the split for either the checking account credit or the AP debit, whichever makes the most sense to you. (putting it in notes, also puts it in the memo for the AP debit split) Now, when you run a vendor report, you’ll see that bill# note in the Description column for easy reference. Here’s a link to documentation on the CSV for importing bills/invoices: https://lists.gnucash.org/docs/C/gnucash-guide/import-invoices.html Here’s the link for customers/vendors (note the caveat about billing info): https://lists.gnucash.org/docs/C/gnucash-guide/import-customers-vendors.html If you’re coming from some other software, you might even be able to get that data exported as a CSV and then do some minor surgery on the column order for Gnucash to be happy rather than typing it all from scratch. Regards, Adrien > On Feb 14, 2018, at 5:59 PM, Fran_3 via gnucash-user > wrote: > > OK, as I understand it after we import checking transactions for a small > business... > For each Vendor Payment we must first create a Bill and then Pay that bill so > that it remains associated with the vendor. That's a lot of clicking and > typing. > So would this work? > In the chart of accounts under say... Expenses > Office Supplies > we create sub accounts for each Office supply vendor... > Than from the check register just assign that payment to that account... > Now we are tracking total office supply expenses and how much we spent with > each vendor. > We are considering this for 2017 transactions as we are under a very short > deadline to come up with some numbers and every step we save helps. > What do you think? > Thanks, > Fran3 > ___ > 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 o
Re: 2.6.19: Accounts reconciled; trial balance has imbalance
On Wed, 14 Feb 2018, John Ralls wrote: Is the trial balance report in balance on 1 Jan 2017? John, Yes. Thank you for asking. Because I rarely look at the Accounts tab I was unaware that the Imbalance account was directly accessible until Mike pointed me to it Working from the Imbalance account allowed me to quickly put those amounts back in the proper account, which is what I thought I had done at the time. Somehow, I missed the proper slot and the amount fell in the crack. Now the book is balanced and every account reconciled. When I spoke Tuesday with my accountant (who, like me, is a sole practitioner of professional services) I recommended she check out GnuCash for her business and personal clients. She said she would look at the web site, but this is tax season and she's working 7 days a week starting at 6:30 am, so I don't expect her to have time. I've used digital bookkeeping software since the mid-1980s (first on DOS, then on linux) and had used GnuCash with Red Hat 4.0-7.0. Slackware back then was very difficult to load all the gnome libraries in the proper sequence and I gave up in frustration. It was only a couple of years ago that the folks at SlackBuilds.org made GnuCash installation and upgrades as easy as all other packages. GnuCash is the easiest, most useful bookkeeping tool I've used. It supports my consulting practice as well as my personal bookkeeping and, while it takes a bit to get used to exactly how to run it, it Just Works. Knowing now about the Imbalance account will allow me to quickly correct any other mistakes. This past Tuesday it took me only about 5 minutes to prepare the balance sheet, income statement (P&L), and trial balance for both business and personal finances and send them (with digital copies of each month's bank statements) to her. Wow! Quick and painless. You may quote me on this and add my appreciation for all the work you devs do. Best regards, Rich ___ 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.
QFX Import and Reconciled Transactions
I recently started using GNUCash at the end of 2017. I'm very thankful I found this app. I'm using version 2.6.19. For managing my checking account, my main strategy is to simply download QFX files from my bank and import. Using this approach, I've found that pre-entering transactions usually backfires on me since the import fails to match more often than not. Not a problem, I've stopped entering transactions manually, and simply allow the import to handle and for the most part, the import process works beautifully. I also reconcile the account, probably twice a week based on the current balance in my account. My question/issue is this. The import process continues to see older transactions (which have been reconciled), and prompts me to either "Update and reconcile (auto) match", or "Reconcile (auto) match". When I allow those transactions to remain checked and continue the import, the application has done strange things, such as change amounts, and/or update the transfer account, which causes issues in future reconciliation attempts. This is managed easily enough by unchecking these transactions and continuing with the import. But, as I mentioned, I started using this application in late 2017, and I'm concerned that I'm going to be carrying this burden of unchecking these transactions (and accumulate more), into the future. Why would GNU Cash match and attempt to update in any way a transaction that has already been reconciled? How can I stop this behavior? Thank you for your help. R Winstead ___ 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: Controlling Gnucash from 2 computers
Resilio Sync is an effective and relatively quick way to do this between two computers, and does not leave anything in the cloud, if that matters. --Chris ___ 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.
