Skip to main content
September 28, 2019
Question

Split a transaction which is part income and part expense

  • September 28, 2019
  • 1 reply
  • 0 views

Help please! Not sure if anyone has a solution to my problem - I run a B&B on my  own and am both disorganised and short of time. I run my accounts mostly by whizzing through downloaded bank statements and sorting into different accounts from there. I don't do invoices as I just take payment as people leave, so I record payments as sales receipts as they appear in my bank statements. Great for saving time. However, I now use a small card machine - sumup - which transfers the funds after deducting the transaction fee. If I just record this as income it's not a true indication of what I earned, as it's without the bank fee. But I don't know how to most simply and efficiently manage the real income (eg £70 for a night stay) against the £68 that comes into my account, with the fee deducted - one being income, one being expense. I tried splitting the transaction to manually add the fee deducted, but I can't have both income and expense in a split in one transaction. It's complicated further if it's several people's payments bundled in together... I'm going in circles trying to avoid too complicated inputting and reconciling, as knowing how things get here it's likely things will fall through the cracks or not be reconcilable!  I thought about manually inputting expected income, but then I can't match it to the amounts that come in, which will be without the fee. Do I have to manually record the extra income for each transaction and go in and type the £2 extra that was deducted???? That seems so incredibly painful. Does anyone out there have a similar problem that they've found a neat solution to??? Because I'm a novice if I start experimenting I tie myself in knots and make an awful mess of my accounts. Many thanks, in hope.

1 reply

September 28, 2019

I'm happy that you reached out to us, Abbo.

 

Let me guide you through on how to handle and record split transactions in QuickBooks Online (QBO).

 

You can enter the £2 as bank fee together with the £70 sales receipt by creating a Bank Deposit. 

 

Here's how:

  1. Go to the Plus icon.
  2. Choose Bank Deposit.
  3. Check the box for the Sales Receipt.
  4. Under Add funds to this deposit, enter the £2 bank fee as negative.
  5. Click Save and close.

 

 

And you're all set. You can now match your Bank Deposit to your downloaded transactions.

 

You can always get back to me if you have other questions and I'll do my best to help you out.

AbboAuthor
September 29, 2019

Thank you so much!!!! I'm very grateful for the help. Will try this now and see what happens! Many many thanks