Re: [GNC] importing account info
Alan, I think there have been some problems around the AQbanking direct importation of OFX data in 3.8 and changes in the associated library that have been reported in the user mailng list. The banks in my country (australia) are still a millenium or two out of date and don't provide direct connection OFX data except through very selected commercial accounting products they have partner relationships with so I have had no experience with this. They claim this is for security reasons but unfortunately we consumers have little control over their choices. i have voiced my objections but have been ignored. I have not yet noticed any problems in 3.8 importing the downloaded files from the bank but if the change back to 3.7 fixed yours then that is great. 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.
[GNC] Credit Card bill autopay
I have one credit card which has billing cycle of 12th of every month. Payment is to be done on 1st of every month or 2nd if that is holiday. Payment is automatically deducted on 1st or 2nd (if 1st is holiday) Can I schedule transaction of CC bill Payment every month. Like it picks up last balance of 12th of every month and Automatically schedules it for payment from savings account on next 1st of every month. My Chart of accounts is: ASSETS --Current Assests Savings account Expenses ---x ---y ---z Liabilities ---Accounts Payable ---Credit Card Thank You, -- 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.
[GNC] Default Fraction for currencies
Hello guys, I'm vietnamese and want to control my finances with GnuCash. I'm using VND as my default currency and GnuCash fraction (decimal) default for VND is 0,00. But for a long time go, VietNam is no longer use it anymore. For main page account, i knew that GnuCash had setting called "smallest fraction" for account i have created, But i have created for about 30 accounts and change fraction for each account is nightmare. So, can i remove (or set it to default) fraction (decimal) for my currency ? For main page account and Report. Sorry for my bad english. -- 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] importing account info
David, thanks for all the analysis; I'm working through the information. I solved the problem by uninstalling 3.8 and installing 3.7; the info I needed flowed right in. It's most likely my machine, but I wonder if there's a bug. On 2/9/2020 2:32 PM, David Cousens wrote: Alan, As the message says, the imported record is in a currency/security that does not match the that of the account that GnuCash has assigned to it. This could mean either the commodity data in the input record is incorrect or the matcher already has stored map information which is assigning it an account which is in the wrong currency. It is unlikely the data from your broker may be incorrect unless the name of the security registeredon the exchange has been changed. Just to be sure I would check at least for the first record that the input OFX file has the commodity that is assigned to the account you expect the transactions's second split to be assigned to. "Invesco Preferred ETF" is not the name of an account but should be the name of the commodity/security specified in the input data. The GnuCash assigned account has a commodity name "iShares Russell 2000" which is the same as the account name, also wierd. I would think that the "iShares Russell 2000" account would likely have a USD ( or whatever is appropriate to your locale) currency. If it is not a n account of type stock that may be causing the confusion Did you manually choose the account "iShares Russel 2000" or did GnuCash supply that as a match? If it was the latter then somehow the account matching data may have been screwed up. I had some wierd account assignments when I first transition to V3 but haven't had that on the later v3 minor version transitions. If you choose Yes in the popup, you should get the account assignment dialog where you can assign the correct account then at least that record is correct. I would check the commodity of the account you wish to assign and make sure it matches the commodity identified in the qfx input data file first (in the Accounts tab, highlight the account, right click and select Edit Account from the pop up menu. The security/currency box should match the code in the input data). If assigning the correct transfer accounts allows that record to be imported and then repeats the same error on the next record, my guess is that the matcher data is screwed up. There are two approaches from here. Either manually correct each record by pressing Yes and assigning the correct account. A pain if you have a lot of records but if you complete the import process, the new data will be imported into the matching data for an account. The second approach is to use the Tools->Import Map Editor to edit the information that the account assignment is based on. This post http://gnucash.1415818.n4.nabble.com/GNC-import-map-editor-td4699101.html may contain some useful information. Section 6.15.8 in the help manual has a little information. It is pretty generic (I wrote it) as my understanding of this part of the code is still very limited. The matcher works by tokenizing information in the descrition field (not sure about the memo fields) and matching that to a list of tokens associated with transactions which have been imported in the past and matched to a specific account. Gnucash calculates a score for the number of matching tokens in the description and each account to which assignments of transaction splits weighted by the count of the frequency of each tokens appearance in transactions which have been assigned in past imports and assigns the highest scoring account. This is my current understanding of the account matching operation and it is only from a fairly cursory exploration of the code at this stage and a little but not much experimentation. I have intended to get back and explore it in more detail but life catches up with me sometimes. if you examine the token strings for the account Gnucash is incorrectly assigning and the tokens associated withthe account you want to be assigned along with the input record description you may be able to identify why the wrong account is being assigned and delete the appropriate tokens from the account. This has a high risk of stuffing up future account assignments. I would play with it on a copy of your data file and a small import data subset until you can get it to work if you take this route. The account matching data is stored in the XML data file so any work done on the copy will not automatically transfer back to your main datafile. If the datafile contains a lot of incorrect matching information as it is a Bayesian system continuing to fix the assigned accounts and completing the import will eventually fix things as it will change the weightings on tokens in the files. Maybe importing in smaller batches, fixing each batch up as you go may be the safest way to approach this. I would like to see a feature which would allow the existing transactions in selected accounts to be used in
[GNC] Importing Vendor Bills: Field Definitions Questions
Referring to the field definitions in 18.1. Importing Bills and Invoices I tried to line those up with the three dialog boxes that come up as you create and post a new bill. New Bill DialogEdit Bill DialogPost Bill Dialog (aka Question) I think I have most of them properly associated but need help on a few... - owner_id - Customer or vendor number. Mandatory in the first data row of an invoice. If not provided, all rows of the same invoice will be ignored. I don't see "Owner ID" in any of those three screens... but I do see a field for the Vendors name in the "New Bill" Dialog. However I do see it in the "Vendor Overview" list of vendorsI guess that means one would have to lookup the Vendor Number for each vendor's bill they are about to import. (This is the case of having a clerk enter the bills into a spreadsheet so that a the GC admin could import them later... as when you don't want the data entry clerk to see all your financial data :-) Now that I think about it that makes sense as the data entry clerk could misspell the vendors name or enter it differently than it is in the system... so maybe I just answered that one for myself. Next I see these fields... again I couldn't find them in any of the three dialog boxes that appear when you are creating/entering a new bill... or did I miss them somewhere. Maybe somebody can point the discount fields out to me wherever they are. - disc_type - Type of discount. Optional. Only relevant for invoices, not for bills. Use “%” or blank for percentage value, anything else for monetary value. - disc_how - Discount how. Optional. Only relevant for invoices, not for bills. Use “>” for discount applied after tax, “=” for discount and tax applied before tax, and “<”, blank or anything else for discount applied before tax. - discount - Amount or percentage of discount. Optional. Only relevant for invoices, not for bills Another question... and maybe I missed it... but is there anyway to import bills from a CSV file but not have it automatically Posted? Finally, for anyone interested... These import fields match the "New Bill" Dialog fields...(except Billingid... which on the dialog is the Vendor Name field) Id Date_opened owner_id Billingid Notes These import fields match the Edit Bill Dialog fields(except I can find the 3 Discount Type fields.) Date Desc Action Account Quantity Price Disc_type Disc_how Discount Taxable Taxincluded Tax_table And finally these import fields match the Post Bill Dialog fields Date_posted Due_date account_posted Memo_posted Accu_splits ___ 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] Where to charge? Ins pays us, we pay vendor. Resolved
Thanks Christopher, that is exactly what we did except in this case the insured was covered 100% so your $150 partial payment received would have been $200 full payment received. Thanks again everyone for the help. On Thursday, February 13, 2020, 5:23:29 PM EST, Christopher Lam wrote: This is what I would do: (I assume you're the patient attending the clinic). Say the clinic bills $200 and Medicare pays/prepays $150 ($50 co-pay). I believe the Expenses:Medical:Rebates is an expense contra-account? The GnuCash account type would still be EXPENSE, but would become more negative with time. On Thu, 13 Feb 2020 at 16:34, Fran_3 wrote: Here is the original scenario:1 - Doctor billed patient2 - Insurance paid patient3 - Patient paid doctor 1. Clinic bills patient Create bill, include services rendered, post to AP Expenses:Medical $200 A/Payable: -$200 2. Insurance pays patient Expenses:Medical:Rebates -$150 Bank +$150 3. Patient pays clinic A/Payable: +$200 Bank: -$200 ___ 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] Gnu Cash Reports
On Friday, 14 February 2020 16:14:43 GMT FRANK WILSON via gnucash-user wrote: > Good afternoon > Are there any reports, or can reports be created, that will list; > i) All disbursements from start of financial year to end of financial year? > ii) All receipts from start of financial year to end of financial year? > iii) All vendor bills from start of financial year to end of financial year? > iv) All customer invoices from start of financial year to end of financial > year? Thanks in advance for any assistance/advice. > Kind regardsFrancis Wilson Hi Francis the transaction report should quite happily manage i) and ii) and I can think of a couple of options for iii) and iv) too, depending on what exactly you want to see. HTH, Maf. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user 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] Multiple copies of gnucash-user messages from the list
You will learn a huge amount if you keep getting all mail, skim them, and delete ones that are not of relevant to you. In no time you will find yourself helping others and putting a bit back into the community. If you only ask questions and take the answers then you are not putting anything back to help others. Colin On Sat, 15 Feb 2020 at 11:42, Ron wrote: > > I think I have my communication problem resolved. As I understand it, I email > questions to gnucash-user, and I see all gnucash-user messages in my email: I > am receiving individual messages which is my choice. > If I wanted to see a collection of messages, then I would look at archives. > I have set my preferences in settings. > Can I restrict messages received to only my questions? Did not see that > option. > I am not getting duplicate messages. > Thank you! > > Ron > > -Original Message- > From: gnucash-user On > Behalf Of Liz > Sent: Saturday, February 15, 2020 2:33 AM > To: gnucash-user@gnucash.org > Subject: Re: [GNC] Multiple copies of gnucash-user messages from the list > > On Wed, 12 Feb 2020 16:47:20 -0600 > Adrien Monteleone wrote: > > > What do you mean by ‘archive messages’? > > > > Are you set to receive in digest form, or individually? > > > > Otherwise, there are 3 preferences I can see that would possibly > > result in ‘duplicates’. > > > > 1 - Avoid duplicate copies of messages? (you’d want to set this to > > ‘yes’ to *avoid* duplicates. That is, if you are in the To: or CC: > > fields, the list will try not to send one to you in addition.) > > > > 2 - Receive your own posts to the list? (you’d want to set this to > > ’no’ to not have the list send you a copy of what you just posted. > > You can use your Sent box/folder or thread it appropriately according > > to however your mail client works) This would only apply to your own > > posts, not those of others. > > > > 3 - Receive acknowledgement mail when you send mail to the list? > > (again, you’d want to set this to ’no’ to not receive a ‘hey, you just > > sent this to the list’ message) Again, this only applies to your own > > posts, not those of others. > > > > Otherwise, I can’t see any reason why you’re getting more than 1 or > > even 2 or more copies of every post. And it seems the problem is on > > your end, because you’re the only one (so far) saying it is happening. > > > > (note, I can imagine such a mess if you had the above three > > preferences set wrong, were not using digest mode, and sent messages > > to the list by hitting ‘reply-all’ and you were also in the To: or > > CC: fields, which might generate as many as 4 copies of your own > > messages to the list.) > > > > If the list were spamming members with duplicates, triplicates, and > > worse, it would be noticed and addressed. > > I did check Alan's message settings from gnucash-user. At the time that I > checked he was set the receive mails individually, and have no duplicates. > > Liz > Moderator > ___ > 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: [GNC] Multiple copies of gnucash-user messages from the list
Sorry, no, that isn’t a feature. Such would be interesting. You might file an enhancement request with Mailman. (I suspect it would work something like Bugzilla or Github’s watch/subscribed/cc feature) Just delete threads you aren’t interested in as they come through. Digest mode gives you fewer messages to deal with, but then you have to scan the digest topic list each time to see if one of the messages is relevant to you and then scroll through the (sometimes long) digest message to get to it. Getting individual messages is probably the easier route. Regards, Adrien > On Feb 15, 2020 w7d46, at 5:39 AM, Ron wrote: > > I think I have my communication problem resolved. As I understand it, I email > questions to gnucash-user, and I see all gnucash-user messages in my email: I > am receiving individual messages which is my choice. > If I wanted to see a collection of messages, then I would look at archives. > I have set my preferences in settings. > Can I restrict messages received to only my questions? Did not see that > option. > I am not getting duplicate messages. > Thank you! > > Ron ___ 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] Gnu Cash Reports
> On Feb 14, 2020 w7d45, at 10:14 AM, FRANK WILSON via gnucash-user > wrote: > > Good afternoon > Are there any reports, or can reports be created, that will list; > i) All disbursements from start of financial year to end of financial year? > ii) All receipts from start of financial year to end of financial year? You might be able to massage the (misnamed) Cash Flow report to get something useful. You might also just run Account Reports on the relevant asset accounts accordingly. If you need to show multiple accounts on the same report, you can do a Find operation and then run an Account report, or you can use the Transaction report and only include the needed accounts. However in any case, I can’t seem to find a way to only show debits *or* credits, but not both. You’d have to move the resulting report to a spreadsheet for further refinement. > iii) All vendor bills from start of financial year to end of financial year? > iv) All customer invoices from start of financial year to end of financial > year? Doing a Find operation and then an Account Report on the AR and AP registers respectively you can get something useful. The Find criteria would be to search for all transactions where ‘Action’ equals ‘Bill’ or ‘Invoice’ respectively. Unfortunately, the resulting Account Report will only show you the result with each split visible, not a single line per bill/invoice. Again, you’d have to move this to a spreadsheet for something a bit simpler. If you ‘consolidate splits’ when posting, the end result might be manageable, but if you don’t consolidate, the report will be a bit long in the tooth. - As to the question of ‘can these reports be created?’ the answer is ‘yes’ but report writing at this time isn’t simple or even easy. If you don’t want to delve into Scheme code, you could use one of the database backends and then proceed from there with queries. Look into something called PieCash which has tried to make this process a bit easier. If the existing reports allowed for filtering based on Action or better yet Type as used in the AR and AP registers, the last two reports would be trivially easy to generate. Alternatively if the Find Bill/Invoice window allowed you to print the result or copy/paste it somewhere else, then you could do a find on “is posted?”. I suppose if the resulting list isn’t too long, and you just need a visible but not editable result, you could take a screenshot of the find results. If report options allowed to ‘show only debits’ or ‘only credits’ then the first two would also be very easy. Regards, Adrien ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user 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] Multiple copies of gnucash-user messages from the list
I think I have my communication problem resolved. As I understand it, I email questions to gnucash-user, and I see all gnucash-user messages in my email: I am receiving individual messages which is my choice. If I wanted to see a collection of messages, then I would look at archives. I have set my preferences in settings. Can I restrict messages received to only my questions? Did not see that option. I am not getting duplicate messages. Thank you! Ron -Original Message- From: gnucash-user On Behalf Of Liz Sent: Saturday, February 15, 2020 2:33 AM To: gnucash-user@gnucash.org Subject: Re: [GNC] Multiple copies of gnucash-user messages from the list On Wed, 12 Feb 2020 16:47:20 -0600 Adrien Monteleone wrote: > What do you mean by ‘archive messages’? > > Are you set to receive in digest form, or individually? > > Otherwise, there are 3 preferences I can see that would possibly > result in ‘duplicates’. > > 1 - Avoid duplicate copies of messages? (you’d want to set this to > ‘yes’ to *avoid* duplicates. That is, if you are in the To: or CC: > fields, the list will try not to send one to you in addition.) > > 2 - Receive your own posts to the list? (you’d want to set this to > ’no’ to not have the list send you a copy of what you just posted. > You can use your Sent box/folder or thread it appropriately according > to however your mail client works) This would only apply to your own > posts, not those of others. > > 3 - Receive acknowledgement mail when you send mail to the list? > (again, you’d want to set this to ’no’ to not receive a ‘hey, you just > sent this to the list’ message) Again, this only applies to your own > posts, not those of others. > > Otherwise, I can’t see any reason why you’re getting more than 1 or > even 2 or more copies of every post. And it seems the problem is on > your end, because you’re the only one (so far) saying it is happening. > > (note, I can imagine such a mess if you had the above three > preferences set wrong, were not using digest mode, and sent messages > to the list by hitting ‘reply-all’ and you were also in the To: or > CC: fields, which might generate as many as 4 copies of your own > messages to the list.) > > If the list were spamming members with duplicates, triplicates, and > worse, it would be noticed and addressed. I did check Alan's message settings from gnucash-user. At the time that I checked he was set the receive mails individually, and have no duplicates. Liz Moderator ___ 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.