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
<d...@davidwhiting.me.uk> 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
<gnucash-user@gnucash.org> 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.
