Skip to main content
May 17, 2020
Question

how do i split a receipt that has an income for rental and also an expense on same receipt for management fee

  • May 17, 2020
  • 1 reply
  • 0 views

I have receipts with income for property rental and it also includes the management fee which is vatable and deducted from the rent receipt how do i enter or split the receipt, please see attachment

1 reply

May 17, 2020

Hello, David. 

 

Thanks for the screenshot. Looking at it, we can follow this method to record the payment with the fees included. 

 

We can do this by creating a payment for the invoice and putting the amount to the Undeposited Funds. Then, we will want to create a bank deposit to account for the fee and calculate the lump sum amount. 

 

First, create an invoice for the customer's rent (if you haven't done it already). Simply click the + New button, then select Invoice. Enter the details of the invoice, then click Save and close. You can skip this if you already created an invoice for the customer. 

 

Next, let's create a payment for the invoice. Simply open it, then click on Receive payment. Ensure that you've selected the Undeposited Funds account under the Deposit to drop-down menu. 

 

Finally, create a bank deposit then account for the management fee. Here's how we can do this: 

 

  1. Click the + New button, then select Bank deposit
  2. Check the customer's rental payment under Select the payments included in this deposit
  3. Under the Add funds to this deposit section, add the supplier (the one that handles the fee collection) on the RECEIVED FROM column. 
  4. Choose an expense account (where you track your fees) under the ACCOUNT column. 
  5. Enter a negative amount (-59.50 in your case), then select the VAT code. 
  6. Add memo, description or other important details if needed.
  7. Once done, click Save and close

We can also choose not to include a supplier profile and just leave the RECEIVED FROM column blank.

 

The lump sum amount will be deposited to your bank account. The fee will be recorded to the expense account (therefore increases it). The VAT amount (£11.90) will appear on your VAT liability reports. 

 

When the bank statement comes in from the Online Bank Feeds, QuickBooks will automatically match it with the deposit records. Simply select the transaction, then click on Match. You can check this article for more details on matching and categorising your transactions: Categorise and match online bank transactions in QuickBooks Online.

 

 

After matching and categorising them, you can start reconciling your bank if needed

 

You can do this for your other future payments with fees. I'd be happy to lend a hand if you'd like to work together to address other concerns.