Assigning and Sorting Payments

[Geert Janssens]

On Saturday 13 September 2014 14:23:19 Arnd Vehling wrote:
> 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.
> 
I'm not sure I completely understand what you are trying to achieve. Do you want the payment 
split to become part of the invoice transaction ?

> 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
> 
The AR register sorts splits on transaction date, not on invoice. In that respect it is very much 
like any other register. For more information you can consult the reports.

Unfortunately even the reports can't currently achieve exactly what you are describing above 
as far as I know.

The payment system originally was written around the concept that you assign payments to 
customers instead of to individual invoices. And the reports reflect this. The only reports that 
show payments associated with an invoice are the individual invoice reports.

> 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?
> 
If you only want to know how much anybody is owing you (and not which invoice hasn't been 
paid yet), you can either look at the "Customer Overview" tab which displays the present 
running balance for each of your customers.

If you want to see this on a different date, you can use the "Receivable Aging" report, which will 
show you the same information but allows you to specify another date.

Regards,

Geert