Re: [GNC] Importing Liability Transactions to AP/Bills
David, That worked great. thanks! Next question... anyway to import payments? And, actually, instead of Assets: Checking making the payments...I want the payments to come from...Liabilities: Reimbursements To/From Entity B Because Entity B paid a bunch of Bills for Entity A...So Entity A wants to show the Bills Paid and record a debt to Entity B for those payments. Note: Such transactions occur on occasion between both Entities thus the name...Reimbursements To/From Entity B Thanks again for the help. On Monday, September 14, 2020, 5:17:20 PM EDT, david whiting wrote: Hi Fran, I import lots of bills and use File -> Import -> Import bills and Invoices (not transactions). See this help page for details: https://code.gnucash.org/docs/C/gnucash-guide/import-invoices.html For my purposes I found it useful to create a spreadsheet for entering details that has a structure that makes sense and then a second sheet that I named "Export to csv" that has formula that take the values from the structured form and formats it in the format needed for the csv import. I then save the invoice in the spreadsheet and do Save As on the second tab to create the csv file import. David On Mon, 14 Sep 2020 at 19:11, Fran_3 via gnucash-user wrote: > > Note: When I say "Bill" here I mean a Bill from a Vendor to us. > I'm trying to import a CSV file to AP and also have it create the > corresponding Bill.I have 100+ of these to import else a lot of labor to do > it by hand... > > So... to experiment I exported the Entities AP register as a CSV file.Then > deleted all transactions except one... just to keep it simple.So now I have 3 > comma separated lines...- Column Title line- Transaction 1 line 1- > Transaction 1 line 2 > Now with the AP register still open I click...File > Import > Transactions > from a CSV fileI then...- select the file to import- tell the importer to > ignore line 1... the Column Title line- tell the importer the date format to > use > Next I start telling the importer the titles of the columns...I leave some > column titles set to "none" like...Transaction-ID, Number, > Commodity/Currency, Void Reason, to name a fewI do choose titles for these > columns to import...Date, Description, Notes, Action, Memo, > > Now I'm stuck...The "Exported" sample shows the next four columns titled > as...- Full Account Name- Account Name- Amount with Symbol- and Amount Num > BUT... the importer doesn't offer these column name options... > My Question: Which Column Name do I choose from the Importer for the above 4 > lines? > I don't know, for instance, if the Amount with Symbol and the Amount Num > should have their columns named Withdrawal or Deposit... as those titles seem > to go with a checking account. > I also don't know how to make the importer identify the double entry accounts > for each imported transaction... like...- Accounts Payable and Utilities... > or...- Accounts Payable and Office Supplies... etc > Thanks for any help. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -- David Whiting ___ 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 Liability Transactions to AP/Bills
Hi Fran, I import lots of bills and use File -> Import -> Import bills and Invoices (not transactions). See this help page for details: https://code.gnucash.org/docs/C/gnucash-guide/import-invoices.html For my purposes I found it useful to create a spreadsheet for entering details that has a structure that makes sense and then a second sheet that I named "Export to csv" that has formula that take the values from the structured form and formats it in the format needed for the csv import. I then save the invoice in the spreadsheet and do Save As on the second tab to create the csv file import. David On Mon, 14 Sep 2020 at 19:11, Fran_3 via gnucash-user wrote: > > Note: When I say "Bill" here I mean a Bill from a Vendor to us. > I'm trying to import a CSV file to AP and also have it create the > corresponding Bill.I have 100+ of these to import else a lot of labor to do > it by hand... > > So... to experiment I exported the Entities AP register as a CSV file.Then > deleted all transactions except one... just to keep it simple.So now I have 3 > comma separated lines...- Column Title line- Transaction 1 line 1- > Transaction 1 line 2 > Now with the AP register still open I click...File > Import > Transactions > from a CSV fileI then...- select the file to import- tell the importer to > ignore line 1... the Column Title line- tell the importer the date format to > use > Next I start telling the importer the titles of the columns...I leave some > column titles set to "none" like...Transaction-ID, Number, > Commodity/Currency, Void Reason, to name a fewI do choose titles for these > columns to import...Date, Description, Notes, Action, Memo, > > Now I'm stuck...The "Exported" sample shows the next four columns titled > as...- Full Account Name- Account Name- Amount with Symbol- and Amount Num > BUT... the importer doesn't offer these column name options... > My Question: Which Column Name do I choose from the Importer for the above 4 > lines? > I don't know, for instance, if the Amount with Symbol and the Amount Num > should have their columns named Withdrawal or Deposit... as those titles seem > to go with a checking account. > I also don't know how to make the importer identify the double entry accounts > for each imported transaction... like...- Accounts Payable and Utilities... > or...- Accounts Payable and Office Supplies... etc > Thanks for any help. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -- David Whiting ___ 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] Subject Correction: How to import CSV into AP Register?
Note: When I say "Bill" here I mean a Bill from a Vendor to us. I'm trying to import a CSV file to AP and also have it create the corresponding Bill.I have 100+ of these to import else a lot of labor to do it by hand... So... to experiment I exported the Entities AP register as a CSV file.Then deleted all transactions except one... just to keep it simple.So now I have 3 comma separated lines...- Column Title line- Transaction 1 line 1- Transaction 1 line 2 Now with the AP register still open I click...File > Import > Transactions from a CSV fileI then...- select the file to import- tell the importer to ignore line 1... the Column Title line- tell the importer the date format to use Next I start telling the importer the titles of the columns...I leave some column titles set to "none" like...Transaction-ID, Number, Commodity/Currency, Void Reason, to name a fewI do choose titles for these columns to import...Date, Description, Notes, Action, Memo, Now I'm stuck...The "Exported" sample shows the next four columns titled as...- Full Account Name- Account Name- Amount with Symbol- and Amount Num BUT... the importer doesn't offer these column name options... My Question: Which Column Name do I choose from the Importer for the above 4 lines? I don't know, for instance, if the Amount with Symbol and the Amount Num should have their columns named Withdrawal or Deposit... as those titles seem to go with a checking account. I also don't know how to make the importer identify the double entry accounts for each imported transaction... like...- Accounts Payable and Utilities... or...- Accounts Payable and Office Supplies... etc Thanks for any help. ___ 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.
[GNC] Importing Liability Transactions to AP/Bills
Note: When I say "Bill" here I mean a Bill from a Vendor to us. I'm trying to import a CSV file to AP and also have it create the corresponding Bill.I have 100+ of these to import else a lot of labor to do it by hand... So... to experiment I exported the Entities AP register as a CSV file.Then deleted all transactions except one... just to keep it simple.So now I have 3 comma separated lines...- Column Title line- Transaction 1 line 1- Transaction 1 line 2 Now with the AP register still open I click...File > Import > Transactions from a CSV fileI then...- select the file to import- tell the importer to ignore line 1... the Column Title line- tell the importer the date format to use Next I start telling the importer the titles of the columns...I leave some column titles set to "none" like...Transaction-ID, Number, Commodity/Currency, Void Reason, to name a fewI do choose titles for these columns to import...Date, Description, Notes, Action, Memo, Now I'm stuck...The "Exported" sample shows the next four columns titled as...- Full Account Name- Account Name- Amount with Symbol- and Amount Num BUT... the importer doesn't offer these column name options... My Question: Which Column Name do I choose from the Importer for the above 4 lines? I don't know, for instance, if the Amount with Symbol and the Amount Num should have their columns named Withdrawal or Deposit... as those titles seem to go with a checking account. I also don't know how to make the importer identify the double entry accounts for each imported transaction... like...- Accounts Payable and Utilities... or...- Accounts Payable and Office Supplies... etc Thanks for any help. ___ 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] Ubuntu distribution version
Derek, I run PCLinuxOS, & it is Gnucash ver 4.1. I have been a happy PCLinuxOS user for about 15 years. I love PCL because it just works. Try it off a USB drive, or SD card. (I run Ubuntu on my Energy server, & must say I prefer PCL! Emoncms (that I use) is set up for Ubuntu, so too hard to change for me...) regards, Doug On Sat, 22 Aug 2020 15:20:49 -0400 Derek Zehr wrote: > Hello Fellow GnuCashers, > > I installed GnuCash from Ubuntu software (Ubuntu 18.04), and it is > version 2.6.19. But I see the latest release on gnucash.org is 4.1. Why > is mine so far behind, and when can I expect the upgrades to come > through Ubuntu's distribution? > > Thanks, > > Derek Zehr > > ___ > 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. -- Doug ___ 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] Negative attitudes [was: Re: Negative numbers]
On 2020-09-13 03:31, Liz wrote: On Sat, 12 Sep 2020 22:37:02 -0700 ToddAndMargo via gnucash-user wrote: Folks do not understand that Open Source is not free. We have a way of describing this to deal with the various meanings of "free" in English. You are describing "free as in beer". Others are describing some of the further meanings of "free" that FSF refers to Freedom to use for any purpose; freedom to examine the code; freedom to share; freedom to improve (and share those improvements). You can read more about the matters here https://www.gnu.org/philosophy/free-sw.en.html Liz Hi Liz, That is only half the story. A nice half though! Here is the rest of the story: Open-source economics https://en.wikipedia.org/wiki/Open-source_economics Open-source for-profit businesses: Numerous companies have created businesses around open-source software. They do this by publishing all of their code open-source, then charging for training, certifications, add-ons, and other services. One example is Red Hat, which produces operating systems. Red Hat sells services such as 24/7 support, integration into company's products, and training. Red Hat was the pioneer for the open source business model, and was valued at approximately $16 billion as of April 2017. Other examples include Google, which created Android, an open-source mobile operating system based on Linux. -T ___ 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] Negative numbers
On 2020-09-13 00:39, Chris Green wrote: On Sat, Sep 12, 2020 at 02:40:51PM -0700, ToddAndMargo via gnucash-user wrote: You ever get a letter from Red hat or Wine or Libre Office explaining that you need to "hire" them to get your bugs fixed? This is the open source model. Open source is not a free lunch. It varies. I guess it depends on how many people there are at the 'core' of developing/maintaining something and how most of them spend their time and earn their living. Some really do write software for fun and really don't want to earn any money as a consequence. Quite a few are professional software people with a paid day job who work on open source in their spare time, or (as I have quite a few times over many years of working as a software engineer) provide fixes and debug things which are being used in their 'professional' work. There are also quite a few quite big projects which have paid for and open source versions running in parallel. LibreOffice has a program where companies can get their developers "certified" as Libre Office developers and contribute directly to the project. Works nicely for well funded companies. And it is a really good idea. Software for love usually is a much smaller project and large projects require and army at times to develop. And then funding does becomes an issue. Users are expected to pay for the support they get. That tends to leave underfunded entities, especially individuals out in the cold. (Libre Office still can't print an envelope for its life!) That being said, in my experience, paid software tends to be of poorer quality that does Open Source, with notable exceptions of course. Gnu Cash is a wonderful project with a lot of wonderful people supporting it. There are a lot of very patient mensches on this list. ___ 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.