Assigning and Sorting Payments

Arnd Vehling Arnd at Vehling.Com
Sat Sep 13 02:23:19 EDT 2014


Hello,

this is very probably a N00b Question but i did read the PDF book and 
also the online documentation and still continue banging my head against 
"the problem".

What i can do: Import/Create Invoices and Assign Payments
The Problem  : I cant group the transactions for one invoice together

Lets Say i have these Accounts

Account			Type
Assets
- Accounts-Receivable	A/R
- Bank			Bank
- Paypal		Bank
- Cash			Cash

Income
- Sales			Income

I import Invoices which creates the according transactions in
Assets:Accounts Receivable - and
Income:Sales

If i know have payments incoming in any of the 3 asset accounts 
(Bank,Paypal,Cash) i can process as payment (Edit->Assign as Payment) 
which will create an transaction in "Assets:Accounts-Receivable" (A/R) 
but NOT under the according invoice reference as a split.

Multiple split-payment for one invoice are not sorted but recorded 
seperatly in the A/R account. What i would like to have is that payments 
for one invoice are recorced as split transaction under der 
Invoice-ID/Reference like this (i did shorten the account fields):

-------------------------------------------------------------------------------
Date Date Due Ref Customer    Account       Tot-Inv Tot-Paym Tot-Balance
12.9    12.10 010 John Doe                  600              -600
                   Downpayment Paypal                 200     -400
                   Sec Paym    Cash                   100     -300
                   Final Paym  Bank                   300        0

14.9    15.10 010 Jane Dane                  400              -400
                   Downpayment Cash                   200     -400
                   Sec Paym    Cash                   100     -200
                   Final Paym  Bank                   200        0
-------------------------------------------------------------------------------
etc

Can one accomplish this with gnucash? If not, what is the closest i can 
get to be able to see who is owing how much on a given day?

thx,

   Arnd






More information about the gnucash-user mailing list