Re: [GNC] unable to import simple investment transaction from qif
If you are using a recent release of GnuCash, ie 4.something, the csv transaction import feature has been greatly improved and includes the ability to save and re-use settings . It definitely works to import investment transactions previously exported from GnuCash, so it should work with generic files as well, possibly with some massage. I don't know if the qif import process can handle investments even though Quicken can export them in that format it requires split transactions which qif importer seems to choke on. On Sun, Dec 11, 2022, 7:25 PM ar wrote: > Hi, > > I am trying to import avery simple transaction from qif: just 2 buy > transaction for the same account, containing mutual fund > > The 'Assets:Investments:X' is gnu cash account tracking shares of , > 'Asserts:Investments:' is a gnucash cash account. > > If I do not provide security symbol as below, the import fails when it > requires to enter the security. > > !Account > NAssets:Investments:X > TInvst > ^ > !Type:Invst > D07/16'2022 > NBuy > LAssets:Investments:Y > Q34.107 > T-77.58 > ^ > D07/15'2022 > NBuy > LAssets:Investments:Y > Q7.638 > T-37.7 > ^ > > I provide security as Y, the import creates account > Assets:Investments:X: that conflicts with > 'Assets:Investments:X' > > 1. Does this feature works? If Yes are there usage examples. > 2. I do not insist on using qif format, is it possible to use .csv for > import, are there examples? > 3. It seems that csv import requires a lot of manual selections to be made > for every imported file, am I getting it right? > > Thank you, > > Aleksey > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] unable to import simple investment transaction from qif
Hi, I am trying to import avery simple transaction from qif: just 2 buy transaction for the same account, containing mutual fund The 'Assets:Investments:X' is gnu cash account tracking shares of , 'Asserts:Investments:' is a gnucash cash account. If I do not provide security symbol as below, the import fails when it requires to enter the security. !Account NAssets:Investments:X TInvst ^ !Type:Invst D07/16'2022 NBuy LAssets:Investments:Y Q34.107 T-77.58 ^ D07/15'2022 NBuy LAssets:Investments:Y Q7.638 T-37.7 ^ I provide security as Y, the import creates account Assets:Investments:X: that conflicts with 'Assets:Investments:X' 1. Does this feature works? If Yes are there usage examples. 2. I do not insist on using qif format, is it possible to use .csv for import, are there examples? 3. It seems that csv import requires a lot of manual selections to be made for every imported file, am I getting it right? Thank you, Aleksey ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciling credit card
Mahon, If you want to use the formal accounting labels you can set it in the Preferences in the Accounts tab of the dialog. You can swap between the two preferences to get the specific meaning of the payment and charge headings for a specific account type. On Sun, 2022-12-11 at 12:03 +, Mahon Finbar wrote: > OK, I have columns marked payment; charge; and balance. > > I translated them as payment to the bank/credit card company; spend on > the credit card and the balance after entries in one or the other. > > Do I change the headings? or am I in the wrong sort of register or type > of a/c? or are the entries in the wrong place? > > Thanks > > On 09/12/2022 17:17, Fred Bone wrote: > > On 09 December 2022 at 15:58, Mahon Finbar said: > > > > > Hi, > > > I am sure this is explained somewhere, but I haven't been able to find a > > > simple explanation. > > > > > > I have a register of transactions in an a/c called credit card. > > > > > > I enter the data from the monthly statement, allocating them to various > > > expenses and enter the monthly payment from a bank account. > > > > > > [In my naivety]?? I assumed that when I enter the monthly payment the a/c > > > will reflect the 'net' situation, i.e. the balance of current transactions > > > less the latest payment. > > > > > > I seemed to be motoring along ok until a while ago when everything in the > > > balance column ended up -ve!! > > > > > > Typically a se of entries looked like this - > > > > > > but now it looks like this - > > > > > > Obviously I have been doing something wrong or have created an error. > > > > > > But what?? > > Probably entered either the payment or the purchases in the wrong column. > > > > Purchases should be in the Credit column and payments from the bank > > account should be in the Debit column. (That is, when you look at the > > credit card a/c. Obviously the payment will be in the Credit column in > > the bank a/c). > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciling credit card
Mahon, I'm guessing you haven't noticed your pics aren't coming through - you cannot paste them inline in a posting to this mailing list, you have to either add a pic at the very end of your post OR include as separate image files... Regards David H. On Mon, 12 Dec 2022 at 00:58, Mahon Finbar wrote: > That is what I do, so why am I getting an increased -ve balance in the > balance column, like this? > > or this? > > > the bank account entry looks like this, under the 'payments out and > payments in' columns > > ?? > > On 11/12/2022 12:19, Fred Bone wrote: > > On 11 December 2022 at 12:03, Mahon Finbar said: > > > >> OK, I have columns marked payment; charge; and balance. > > I find these non-formal labels confusing. > > > >> I translated them as payment to the bank/credit card company; spend on > the > >> credit card and the balance after entries in one or the other. > >> > >> Do I change the headings? or am I in the wrong sort of register or type > of > >> a/c? or are the entries in the wrong place? > > In the "credit card" account: > > When you buy something, the amount should be in the Credit column, the > > one headed "Charge". This will increase the "Balance". > > When you pay the provider from your bank account, the amount should be in > > the Debit column, the one headed "Payment". This will reduce the > > "Balance". > > > > In an Expense account, the amount (relating to the thing you bought) will > > be in the Debit column, which I see gets headed "Expense". This increases > > the "Balance". > > > > In a Bank account, the amount (relating to paying off your credit card) > > will be in the Credit column, informally headed "Withdrawal". This > > reduces the "Balance". > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciling credit card
Are you trying to put images inline? They are getting stripped out by Mailman. Just put them in 'as attachments'. (setting in your mail client) Credit accounts normally have a negative balance. If you want to see them as positive change the setting in Preferences > Accounts > Reversed balanced accounts to "Credit accounts". If that is already set, and you see a negative balance for *any* account, then that account currently has a 'contra-balance', that is, a balance opposite of its normal state. In this case, it would indicate an over-payment to the card company. Regards, Adrien On 12/11/22 8:58 AM, Mahon Finbar wrote: That is what I do, so why am I getting an increased -ve balance in the balance column, like this? or this? the bank account entry looks like this, under the 'payments out and payments in' columns ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Possible bug - Note added in Transfer window is ignored. Memo shown twice in Accounts
There's also nothing special about the Transfer function. You can just do it as a manual transaction between two (or more) accounts. Regards, Adrien On 12/11/22 6:26 AM, Dr. David Kirkby wrote: On Sun, 11 Dec 2022 at 11:19, Fred Bone wrote: Open any account and set View to Double-line and Transaction-journal and all will be revealed. A "Note" belongs to a transaction. A "Memo" belongs to a split. Thank you. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] URGENT: Fake gnucash website with fake download,
Firefox users can use: network.IDN_show_punycode -> true Use Punycode in Internationalized Domain Names to eliminate possible spoofing On Sun, Dec 11, 2022, 1:14 PM David G. Pickett via gnucash-user < gnucash-user@gnucash.org> wrote: > Even riskier is clicking a link with a Cyrillic a (thanks unicode utf8), > looks great and very wrong. Don't go by eye. Use a trusted bookmark? Use > gnucash.org? host names are case insensitive. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] questions.
Ornithology, sounds like you are starting fresh. If you’ve used Gnucash for years you probably forgot you have to create or choose a chart of accounts as a starting point. The help files are great for guiding you through the process. > On Dec 11, 2022, at 10:34 AM, Derek Atkins wrote: > > Did you copy your data file? > Did you File -> Open your data file? > > -derek > Sent using my mobile device. Please excuse any typos. >> On December 11, 2022 11:26:21 Orith wrote: >> >> 1. I got a New computer - Lenovo. no gnu-cash from previous computers, i >> cleaned it out to make sure the viruses did not come to the new laptop. >> Thus, I need to download the new version 4/11. When it is opened, no list >> of accounts are available, I need them. tried to delete and restore and >> tried again, still no accounts. >> >> 2. I have used Gnu for over 10 years. always happy. This time, when I >> tried to make my own accounts and save them, they were on the desktop. I >> tried to change the settings, and it gave me a new window, I'm just >> getting confused. >> >> thanks for your help in advance >> orith c. >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> 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 > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] URGENT: Fake gnucash website with fake download,
Even riskier is clicking a link with a Cyrillic a (thanks unicode utf8), looks great and very wrong. Don't go by eye. Use a trusted bookmark? Use gnucash.org? host names are case insensitive. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciling credit card
On 11 December 2022 at 14:58, Mahon Finbar said: > That is what I do, so why am I getting an increased -ve balance in the > balance column, like this? According to your accounts, you have overpaid the credit card by rather more than a thousand, so if you were to close the account you would be due a substantial refund. Making purchases decreases the amount the provider owes you, so the negative balance reduces. Making further payments to it increases that negative balance. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] questions.
Did you copy your data file? Did you File -> Open your data file? -derek Sent using my mobile device. Please excuse any typos. On December 11, 2022 11:26:21 Orith wrote: 1. I got a New computer - Lenovo. no gnu-cash from previous computers, i cleaned it out to make sure the viruses did not come to the new laptop. Thus, I need to download the new version 4/11. When it is opened, no list of accounts are available, I need them. tried to delete and restore and tried again, still no accounts. 2. I have used Gnu for over 10 years. always happy. This time, when I tried to make my own accounts and save them, they were on the desktop. I tried to change the settings, and it gave me a new window, I'm just getting confused. thanks for your help in advance orith c. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] questions.
1. I got a New computer - Lenovo. no gnu-cash from previous computers, i cleaned it out to make sure the viruses did not come to the new laptop. Thus, I need to download the new version 4/11. When it is opened, no list of accounts are available, I need them. tried to delete and restore and tried again, still no accounts. 2. I have used Gnu for over 10 years. always happy. This time, when I tried to make my own accounts and save them, they were on the desktop. I tried to change the settings, and it gave me a new window, I'm just getting confused. thanks for your help in advance orith c. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciling credit card
That is what I do, so why am I getting an increased -ve balance in the balance column, like this? or this? the bank account entry looks like this, under the 'payments out and payments in' columns ?? On 11/12/2022 12:19, Fred Bone wrote: On 11 December 2022 at 12:03, Mahon Finbar said: OK, I have columns marked payment; charge; and balance. I find these non-formal labels confusing. I translated them as payment to the bank/credit card company; spend on the credit card and the balance after entries in one or the other. Do I change the headings? or am I in the wrong sort of register or type of a/c? or are the entries in the wrong place? In the "credit card" account: When you buy something, the amount should be in the Credit column, the one headed "Charge". This will increase the "Balance". When you pay the provider from your bank account, the amount should be in the Debit column, the one headed "Payment". This will reduce the "Balance". In an Expense account, the amount (relating to the thing you bought) will be in the Debit column, which I see gets headed "Expense". This increases the "Balance". In a Bank account, the amount (relating to paying off your credit card) will be in the Credit column, informally headed "Withdrawal". This reduces the "Balance". ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Buying with PayPal - how do I split the transaction?
On Sun, 11 Dec 2022 at 01:28, David Cousens wrote: > > Dave, > > The different approaches with this mainly reflect different circumstances. Yes, I can see that. > > PayPal to some extent acts a bit like a bank so my first thought would be > to > treat them the same as you would treat a bank account, but the appropriate > way > to treat it depends on how you actually use your account with them. > > If you maintain a positive balance in the Paypal account from which > payments are > made to vendors then it is reasonable to treat a PayPal account as an asset > account of type bank as they are not extending credit to you. I do not have any credit facilities with PayPal. I have in the past withdrawn funds immediately. However, I am likely to stop this and maintain positive balances for USD and Euro because I make the occasional sales in USD and Euros, and frequently buy in those currencies. Keeping positive balances will reduce currency conversion fees. So I would definitely consider PayPal an asset, not a liability. If they extend credit to you, i.e. they pay the vendors immediately and > then you > pay out the balance owing to them at the end of the month, i.e. the account > balance is negative the majority of the time, then they are functioning > more as > a credit provider and a Liability account is a more appropriate way to > treat the > account. That’s not the case with me. You wouldn't necessarily need to raise an invoice to cover a payment to > PayPal > just as you wouldn't when you pay off your credit card with a bank. Okay, so if I think the following is a reasonable way to transfer money from the bank account to pay for goods with PayPal, with PayPal configured as an asset 1) Open bank account in GnuCash 2) Perform a transfer between the two assets Debit account: Assets -> PayPal > GBP Credit account: Assets -> Bank account > > The main purpose of Customers and Vendors and the business features around > them > is to avoid having to maintain individual accounts receivable and accounts > payable accounts for each customer or vendor you interact with and to > provide > the information to manage the credit that is extended to you by vendors > and the > credit you extend to your customers and the effect it has on cash flow. We are required here to keep records of “who you bought and sold to (unless you run a retail business)” https://www.gov.uk/running-a-limited-company/company-and-accounting-records I believe that my accountant told me that should be name and address. For me at least, having everyone as a vendor or customer makes some sense and consistently, but I think a transfer between the two assets makes more sense for transfers between PayPal and the bank account. Hope this clarifies things a bit. Yes, it is becoming clearer. > David Dave -- Dr. David Kirkby, Kirkby Microwave Ltd, drkir...@kirkbymicrowave.co.uk https://www.kirkbymicrowave.co.uk/ Telephone 01621-680100./ +44 1621 680100 Registered in England & Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Possible bug - Note added in Transfer window is ignored. Memo shown twice in Accounts
On Sun, 11 Dec 2022 at 11:19, Fred Bone wrote: > Open any account and set View to Double-line and Transaction-journal and > all will be revealed. > > A "Note" belongs to a transaction. A "Memo" belongs to a split. > Thank you. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciling credit card
On 11 December 2022 at 12:03, Mahon Finbar said: > OK, I have columns marked payment; charge; and balance. I find these non-formal labels confusing. > I translated them as payment to the bank/credit card company; spend on the > credit card and the balance after entries in one or the other. > > Do I change the headings? or am I in the wrong sort of register or type of > a/c? or are the entries in the wrong place? In the "credit card" account: When you buy something, the amount should be in the Credit column, the one headed "Charge". This will increase the "Balance". When you pay the provider from your bank account, the amount should be in the Debit column, the one headed "Payment". This will reduce the "Balance". In an Expense account, the amount (relating to the thing you bought) will be in the Debit column, which I see gets headed "Expense". This increases the "Balance". In a Bank account, the amount (relating to paying off your credit card) will be in the Credit column, informally headed "Withdrawal". This reduces the "Balance". ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciling credit card
OK, I have columns marked payment; charge; and balance. I translated them as payment to the bank/credit card company; spend on the credit card and the balance after entries in one or the other. Do I change the headings? or am I in the wrong sort of register or type of a/c? or are the entries in the wrong place? Thanks On 09/12/2022 17:17, Fred Bone wrote: On 09 December 2022 at 15:58, Mahon Finbar said: Hi, I am sure this is explained somewhere, but I haven't been able to find a simple explanation. I have a register of transactions in an a/c called credit card. I enter the data from the monthly statement, allocating them to various expenses and enter the monthly payment from a bank account. [In my naivety]?? I assumed that when I enter the monthly payment the a/c will reflect the 'net' situation, i.e. the balance of current transactions less the latest payment. I seemed to be motoring along ok until a while ago when everything in the balance column ended up -ve!! Typically a se of entries looked like this - but now it looks like this - Obviously I have been doing something wrong or have created an error. But what?? Probably entered either the payment or the purchases in the wrong column. Purchases should be in the Credit column and payments from the bank account should be in the Debit column. (That is, when you look at the credit card a/c. Obviously the payment will be in the Credit column in the bank a/c). ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Possible bug - Note added in Transfer window is ignored. Memo shown twice in Accounts
On 11 December 2022 at 11:04, Dr. David Kirkby said: > If I transfer funds between two accounts (in my case bank and PayPal), I > can leave both a note and a memo. I'm not sure of what's the difference > between these, but when I look at the accounts, I see the memo shown > twice, but the note is not shown. See the attached screenshots, before > making the transfer, then in the accounts. > > Are the notes available somewhere else? Open any account and set View to Double-line and Transaction-journal and all will be revealed. A "Note" belongs to a transaction. A "Memo" belongs to a split. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.