Nice trick, thanks Chris!
Regards, Adrien > On Feb 15, 2018, at 2:47 PM, Chris Good <goodchri...@gmail.com> 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 <adrien.montele...@gmail.com> >> To: "gnucash-user@gnucash.org" <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 <mailbox0...@yahoo.com> 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 >>> <adrien.montele...@gmail.com> 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 >>>> <gnucash-user@gnucash.org> 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 on all your replies. You can do this by using Reply-To-List or Reply-All.
