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