Re: [GNC] csv File downloads

2020-02-03 Thread Jane Knichel-Aldea
Thank you for the clarification. I have successfully imported a csv file! I will make note of your comment regarding the date format so it works next time as well. Thank you again. Regards, Jane Knichel-Aldea 201-725-3507 On Thu, Jan 30, 2020, 5:16 AM David Carlson wrote: > Jane, > > The CSV

Re: [GNC] Why doesn't Posted Bill show up in AP? Only after Paid

2020-02-03 Thread Adrien Monteleone
Your T-accounts are correct. If that isn’t happening, then something is being entered incorrectly. When you create a Bill, the individual line items should be assigned to relevant expense accounts. There are no register transactions created at this point. When you post the bill, you post it

[GNC] Gnucash 3.8 Flatpak Not Connecting to MySQL

2020-02-03 Thread Alan Whiteman
Hello, Recently I moved to KDE Neon as my preferred distro, I had manually installed Gnucash 2.6 which connected to MySQL perfectly fine. A recent system update forced the removal of Gnucash in order to update some libraries. When I tried to re-install from the Discover Software Center, the

[GNC] Why doesn't Posted Bill show up in AP? Only after Paid

2020-02-03 Thread Fran_3 via gnucash-user
When you post a bill I would expect it to be charged to the appropriate expense account and to AP But I have to pay it before it appears in AP Clearly I'm no accountant but that is my understanding of how "Double Entry" bookkeeping works Maybe someone can educate me :-) Thanks.

Re: [GNC] Automatic Retrieval of Quotes not working for Exchange Traded Funds (ETFs)

2020-02-03 Thread Peter Marshall via gnucash-user
Woohoo! That is what I needed. Thanks so much for your help. Somehow I missed that in the documentation for setting up the Finance::Quote. It’s interesting that it worked without that API key for non-ETF securities. > On Feb 2, 2020, at 9:10 AM, John Ralls wrote: > > > >> On Feb 2,

Re: [GNC] What "Transfer" acct when paying vendor out of Checking?

2020-02-03 Thread David Cousens
If you haven't raised a bill then the Liabilities:Accounts Payable is not applicable. The transfer account will be the relevant expense account unless the item is a capital expense in which case it will be an asset account not under current assets. David - David Cousens -- Sent from:

Re: [GNC] What "Transfer" acct when paying vendor out of Checking?

2020-02-03 Thread Adrien Monteleone
You select the expense account. There should be no manual transactions between AP/AR if you are using the Business Features. You can though have manual transactions between ‘Other AP/Other AR’ accounts and checking/cash etc. Since you didn’t initially create a transaction (a Bill) between the

Re: [GNC] Apple Card csv

2020-02-03 Thread David Cousens
Keith, Haven't any experience with Apple Card but I import my Paypal transactions via CSV. In that case I have to preedit the files in Libre Office because Paypal gives me far more information than I generally need to record.The Importer in the V3 series makes this a little easier as you can

[GNC] What "Transfer" acct when paying vendor out of Checking?

2020-02-03 Thread Fran_3 via gnucash-user
Its been quite awhile since I've used gnuCash & I'm trying to catch. When I pay a vendor directly from checking... not paying a bill,  just writing a check & recording it in the check register... For "Transfer"do I select "Libalities: Accounts Payable"orUse the dropdown to select the percise

[GNC] Call of Import Map Editor leads to crash of gnucash

2020-02-03 Thread Peter Zimmerer
Hi all, inspired by a thread at the German gnucash mailing list I tried to use the Import Map Editor. Unfortunately, this led to a crash of gnucash. Standard output has shown the following error message: terminate called after throwing an instance of 'std::out_of_range' what():

Re: [GNC] Apple Card csv

2020-02-03 Thread Stephen M. Butler
On 2/3/20 8:44 AM, Keith Bellairs wrote: > I have been using GNC for a long, long time. So I have an account for each > of my credit cards. I can update the accounts with ofx/qfx downloads. I see > that Apple only allows csv downloads from that card. I have never used the > csv upload to GNC. Does

Re: [GNC] Importing bank transactions B4 posting bills & Invoices - question

2020-02-03 Thread Fran_3 via gnucash-user
Ignore my "tried to test this" post. I think I have it figured out.. I'll repost question otherwise. Thanks for the help. On Monday, February 3, 2020, 12:32:27 PM EST, Fran_3 via gnucash-user wrote: Well I tried to test this via...- Creating an Exp Account named Unassigned Expenses-

Re: [GNC] Apple Card csv

2020-02-03 Thread Alton Brantley
I successfully download the Applecard CSV through the iPhone, transfer it over to my mac with AirDrop, and import it into my account on Mac Catalina with Gnucash 3.8. Getting CSV import set up can take a bit of fiddling, but once you get it all configured so it goes through, and you save the

Re: [GNC] Importing bank transactions B4 posting bills & Invoices - question

2020-02-03 Thread Fran_3 via gnucash-user
Well I tried to test this via...- Creating an Exp Account named Unassigned Expenses- Then entered a test $99 transaction in the check register and assigned it to Unassigned Expenses.- I tried right clicking the $99 checking transaction but no option to Apply As Payment. - I tried right

[GNC] Apple Card csv

2020-02-03 Thread Keith Bellairs
I have been using GNC for a long, long time. So I have an account for each of my credit cards. I can update the accounts with ofx/qfx downloads. I see that Apple only allows csv downloads from that card. I have never used the csv upload to GNC. Does anyone have experience with Apple's csv files?

Re: [GNC] Importing bank transactions B4 posting bills & Invoices - question

2020-02-03 Thread Adrien Monteleone
If those previously imported transactions are payments, then yes you can. Simply right-click the imported transaction and choose ‘Apply as payment’. You’ll then get the Process Payment window where you can choose which bill/invoice to apply to. Just make sure your dates in the registers and on

Re: [GNC] Account Currency Screwed Up Again!

2020-02-03 Thread Adrien Monteleone
Would creating a new duplicate account with the proper assigned currency, then deleting the old account and choosing to transfer all transactions to the new currency work? That would be significantly easier than manual editing. I’m not sure how the use of Trading Accounts affects this, or if

[GNC] Importing bank transactions B4 posting bills & Invoices - question

2020-02-03 Thread Fran_3 via gnucash-user
Can I 1 - import banking transactions Then2 - Post Bills from vendors & Invoices to clients Then 3 - Apply the previously imported bank transaction to the appropriate bill or invoice? Thanks for any help. ___ gnucash-user mailing list

Re: [GNC] Account Currency Screwed Up Again!

2020-02-03 Thread David Cousens
Have you checked the default currency used Edit->Preferences, Accounts tab, Default Currency. It is normally set to locale. I guess you are in Australia so it should be AUD. If not, diid you possibly create the book originally while overseas or the locale on your computer was not set to Australia.

Re: [GNC] Account Currency Screwed Up Again!

2020-02-03 Thread rsbrux via gnucash-user
I haven't see an answer to this on the distribution list, nor on Nabble . Can I fix this by editing the XML file? I am using GC v2.6.19 under Ubuntu Studio 18.04.  Is there a function to change the