Processing Payment to Vendor from Imported Checking

Geert Janssens geert.gnucash at kobaltwit.be
Sun Feb 4 14:59:55 EST 2018


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




More information about the gnucash-user mailing list