Re: [GNC] Importing Liability Transactions to AP/Bills
FYI, this has been solved. Thanks. On Monday, September 14, 2020, 7:20:55 PM EDT, Fran_3 via gnucash-user wrote: 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. ___ 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
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] 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.