Can we key a payment transaction in a cash account along with a loan account with bill/invoice in 1 journal?
For example, payment 500 USD bill for a supplier, 100 USD from a cash account, and 400 USD from a loan vendor account
Currently, in ACU, we have to record the payment 500 USD bill for the supplier with a cash account. Then revert back of 400 USD cash account to loan vendor account.
I want to make sure I understand your question. Please confirm, you are recording three transactions:
Payment to a Vendor $500
Cash Received $100
Payment received on a loan from a vendor $400
Are all of these transactions from the same vendor? Or different vendors?
What is the gross amount of the AP bill? Is the bill paid in full by the receipts, or is the bill $1000 and a payment for $500 is going out? What is the net effect on cash of the above payments?
In GL, we can record multiple transactions “in one journal” but none will update vendor history in AP and none will generate a payment that can be sent out.
In Banking, we can record only one entry type in each batch, representing the Net Effect of the above transactions, disbursement or receipt, but not both. I checked and we can enter positive and negative lines in Banking transactions. This example will correctly reduce a receivable from your vendor and record payment to your vendor. Cash and GL will be correct but there will be no transaction visible on Vendor History screens and reports in the AP module (we can’t identify VENDOR in a Cash entry):
If all transactions are for the same vendor then you can enter positive & negative lines in a bill, or you can enter Debit Adjustments representing the Load Payment and Cash Payment.
I don’t recommend this solution because it doesn’t clearly record the vendor receivable, which belongs in the Receivables module. I recommend separation of the Payable and Receivable transactions. Did you already extend the vendor to a customer and record the amount owed to you?
Thanks @laura01 for your kind support! please see my answer for your question as below:
Please confirm, you are recording three transactions:
Payment to a Vendor $500
Cash Received $100
Payment received on a loan from a vendor $400
=> yes, we record Debit for Vendor - $500 and Credit for Loan Account - $400 & Cash Account - $100
Are all of these transactions from the same vendor? Or different vendors? - in this case we have only one vendor, but there are some case we will pay for different vendors.
Your original question: “Can we key a payment transaction in a cash account along with a loan account with bill/invoice in 1 journal?”
When there are two vendors in the same transaction (one for Loan and one for Payment) then you will need 2 documents/two transactions. (We can’t pay two vendors with one document or transaction.)
When there is one vendor, then you can produce one payment of $500. ( => bill $1000 and we only pay $500)
Example: Bill for $500 contains two lines:
Line 1 for $1000 to the Expense Account for the purchase.
Line 2 for -$500 to the Loan Account (debit).
When the bill is paid, debit to Accounts Payable and credit to Cash for $500; vendor is paid $500.
Our case is total bill $1000, we pay only $500 included $100 from cash account and $400 from loan account.
we will key debit vendor account ($500) , credit cash account ($100) and credit loan account ($400)
in this case, how can we record all these transactions on acumatica and is this possible to record on 1 journal?
I see you mention the below content so it maybe the answer?
In Banking, we can record only one entry type in each batch, representing the Net Effect of the above transactions, disbursement or receipt, but not both. I checked and we can enter positive and negative lines in Banking transactions. This example will correctly reduce a receivable from your vendor and record payment to your vendor. Cash and GL will be correct but there will be no transaction visible on Vendor History screens and reports in the AP module (we can’t identify VENDOR in a Cash entry):
If all transactions are for the same vendor then you can enter positive & negative lines in a bill, or you can enter Debit Adjustments representing the Load Payment and Cash Payment.
+18
