Op zondag 4 februari 2018 20:38:47 CET schreef Fran_3: > Setup: > a - Imported CSV bank transactions > b - CSV format = date,deposits,witdrawls,num,description > > Discovered: > 1 - Withdrawals must be positive number in CSV file (else show up as > deposits in check register)
That is correct. The "withdrawal" column type is meant for csv files in which you have a separate debit (deposit) and credit (withdrawal) column. Generally when there are two columns they are both represented as positive numbers. The fact that it's positive or negative is already represented by the column in which the amount is recorded. I concede the names chosen for this can be a bit confusing. > 2 - Must assign withdrawals to pay bills to > Liabilities -> Accounts Payable during the import process > Then I can right click them in Check Register view and Assign Payment As > will let me choose a vendor. > (1 above is true even if you label the columns deposits and > withdrawals during the import process) > Questions: > I - Is the process described above correct? Better alternative? Yes, that process is correct for gnucash 2.6. Gnucash 3.0 will make it easier on you. Regardless of the state of the transaction you will always be able to choose vendor, customer or employee in the payment window. > 2 - How would you properly assign a withdrawal for a loan to an employee > or shareholder or other entity? There is no way in gnucash 2.6, but there will be in gnucash 3.0. > 3 - How would you properly assign a withdrawal that was a dismemberment > to a shareholder? I don't know what that is, so I can't advise authoritatively. However you could either define shareholders as vendors and treat a dismemberment as a payment to that vendor (if that makes any sense) or you record it as a normal transaction, unrelated to the business features. Is there a document to go with this, something like a bill ? Do you need to keep track of both that document and the payment and how they relate ? Is it tax related ? Then you could model it via a vendor and payment, otherwise you could just make it a normal transaction during import. > 4 - How would you properly assign a capitol deposit to shareholder equity? I suppose this would have a similar answer as number 3. > Thanks again for the help. You're welcome. Geert _______________________________________________ gnucash-user mailing list firstname.lastname@example.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.