DESKTOP EDITION CLOUD EDITION SERVER EDITION GUIDES FORUM

Split Transactions - Multiple "Paid From" & "Received From" Entries


#1

When entering transactions (Spend Money or Receive Money and also Transfer Money Transactions) in a bank or cash account, currently there is only one option to enter one “Paid From” or “Received From” or “Received In” account. In the situation where you purchase an item and you use multiple forms of payment with that retailer (Credit card plus cash or store credit/gift voucher etc). Is it possible to add/place the “Paid From” or “Received From” or “Received In” account field to before the “Account” field on the same line as the transaction? This way it would be then possible to add multiple forms of payment to the one transaction entry, and still having the “Add line” button to add multiple transactions.

Senario:

Purchased an item that is $250.00 but used credit card for $200 and paid cash or store credit/gift voucher for the remainder - $50.00.

• Enter a credit card transaction (Bank Accounts > Credit Card Account > Spend Money)
• Enter purchase info and enter multiple lines: i.e. $200 Credit Card payment and $50 as cash/store credit/gift voucher etc

If this is a all technically possible, I would envisage that by adding the “Paid From” or Received From" or “Received In” drop down list would work well if on the same line as the applicable transaction.

Example: COMBINED CREDIT CARD & STORE CREDIT/GIFT VOUCHER PURCHASE

:: LINE 1 - Paid From [Drop Down List]: Credit Card Account > Account [Drop Down List]: Business Expense: Computer Software > Description: Computer Software > Amount: 200.00 > Tax [Drop Down List] - GST 10%) > Tracking Code [Drop Down List: FY 2014-2015 X
:: LINE 2 - Paid From [Drop Down Field]: Cash On Hand ~ Store Credit/Gift Vouchers > Account [Drop Down List]: Business Expense: Computer Software > Description: Computer Software > Amount: 50.00 > Tax [Drop Down List] - GST 10%) > Tracking Code [Drop Down List: FY 2014-2015 X

NOTES:

  • The money value for the credit charge is taken out of the credit card account
  • The money value cash/store credit credit/gift voucher is taken out of the respective account that holds that amount (i.e. wallet, store credit, gift vouchers, petty cash account etc
  • This would work either way - if you are entering the transactions in the credit card account, the line for the “cash amount” would be taken out of the cash account … and vice versa - if entering the transactions in the Cash Account, the credit card value would be taken out of the credit card account.
  • This would work for different types of transaction i.e. “Spend Money” and “Receive Money” - and may also be beneficial when doing a a “Transfer Money” transaction also.

I hope all this makes sense.
Let me know if you have any questions.


#2

If you are paying combination bank/cash, then why not enter this as two separate “Spend money” transactions under each bank/cash account?

Also, if you have store credit, you should probably have asset account created under “Chart of Accounts” for this. Then entering transaction that will use store credit within bank transaction would be like this:

See how purchase is $250 but only $200 is going to be taken out of bank account because $50 is store credit.


#3

Thanks for your solution Lubos and I am sure this will work but wouldn’t the total value/amount entered be deducted from the “Paid from” account that is selected in the drop down list (i.e. “Paid from” = Credit Card) that is below the transaction details line [Account-Description-Amount-Tax-Tracking Code]?

If each transaction line had it’s own “Paid from” [Spend Money Trans] or “Received In” [Receive Money/Transfer Money Trans], the funds would be dispersed according to whether it’s Cash at bank or Cash on hand or a combination of both.

Maybe I have this totally wrong but this is how I see it - apologies if I am doing your head in with all this :slight_smile:

Sean