Creating Account for each Vendor to avoid Creating and Paying each Bill?

[Fran_3]

 Thanks Adrien,
Actually we are using 2.6.19. Looks like I didn't type the number "9" at the end of my last post.
Roger on deleting all 2018 transactions but not being able to delete invoices and bills. What we do when we want to 'delete' an invoice or bill is...
1 - create vendor and customers named Parked.2 - open the invoice or bill we want to delete and zero it out and change the customer or vendor to 'Parked'3 - Then later we can use them by change the vendor or customer name, etc.
Seems to work... so far in our new adventure with gnuCash :-)
Thanks again for your help.
Fran3

    On Thursday, February 15, 2018, 2:09:04 PM EST, Adrien Monteleone <adrien.monteleone at gmail.com> wrote:  
 
 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 <mailbox0600 at 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.monteleone at 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 at 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 at 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 at 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 at 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.