Skip to main content
W
woocoop
August 3, 2023
Question

Rental income and agents fees

  • August 3, 2023
  • 1 reply
  • 0 views

Hi

The bank account receives a net figure which is; GROSS RENTAL less AGENTS FEE less REPAIRS

For example income to bank is £850 comprising: £1250 less £125 less £375

Obviously there are both debit and credit entries here

Can this be auto posted?

Thanks

Ian 

    1 reply

    K
    Kurt_M
    August 3, 2023

    We're pleased to have you here today, @woocoop.

     

    Know that bank transactions are automatically posted. However, if you mean to post them inside QuickBooks Online (QBO) so they'll show in your bank register for recording purposes, know that you'll need to Categorise and Add them so they'll appear to specific accounts inside your Chart of Accounts. Since it shows debit and credit with different amounts, you'll want to Split so you can track them accurately inside the program. We'll gladly write down the steps to get you going:

     

    1. Access your QuickBooks Online company.
    2. On the left navigational bar, go to the Banking tab.
    3. Choose the bank, and then go to the For Review section.
    4. Locate and click the transaction, and then tick the Radio button for Categorize.
    5. Enter the necessary details.
    6. Click Split.

     

    For further guidelines, you can visit this article: Categorise and match online bank transactions in QuickBooks Online.

     

    Additionally, we've got these articles to help you reconcile an account and ensure your data stays accurate inside the program:

     

     

    @woocoop, we'll be happy to help you again if you have any additional QuickBooks-related concerns. Please don't hesitate to reach out. We've got you covered. Stay safe, and have a great day! 

    W
    woocoopAuthor
    August 3, 2023

    Hi

     

    That is not what I mean

     

    I want to post automatically but in three separate parts not as one transaction

    G
    GeorgiaC
    August 3, 2023

    Hi woocoop

     

    As you're receiving the net amount, you would need to create the deposit manually and then match the downloaded bank transaction to this if you wish to account for the individual parts.

     

    To record the manual bank deposit:

     

    1. Select + New > Bank deposit 

    2. Choose the bank account that the money was received to and enter the date

    3. Scroll to 'Add funds to this deposit' and select the appropriate VAT option on the 'Amounts are' drop-down

    4. On the first line, complete the Received from and Account fields, and enter the gross amount in the amount column

    5. On the second line, enter the agent fee account under Account, and enter the fee amount as a negative figure (-)

    6. On the following line, enter the repair fee account under Account, and again enter the fee amount as a negative

     

    The total of the bank deposit will now equal the net amount received. Save & close and match this in your banking. 

     

    If you're using QuickBooks Online Plus or Advanced and need to record this transaction on a regular basis, consider setting up a recurring transaction for the bank deposit. If you set the recurring transaction template to be Unscheduled, these won't be created automatically and you can instead use the transaction as an when needed (by selecting 'Use in the action column of the recurring template list). You'll also be able to edit this to change the amounts and other details if needed. 

    Terms & ConditionsAccessibility statement