how to enter property manager income / expense report

SUGGESTED

I'm trying to figure out how I would enter in income / expense data from a property manager report, and allow it to match up with my banking deposit. 

Using quickbooks it allows me to place expenses into the sales receipt I'd create, and also apply escrow funds when needed. 

I'm struggling to figure out how to do this in sage accounting. I'm worried that if I can't figure this out, I may need to just go back to quickbooks. 

normally I would just throw all of this into a sales reciept and everything would be applied to the correct income and expense accounts. I'm just not sure how I would do it in sage accounting. 

an example of what I'd see:

bank deposit of: $3000

from my property manager:

rent unit A: $1500

rent unit B: $1500

rent unit C: $1500

management fee unit A: -$150

management fee unit B: -$150

management fee unit C: -$150

unit C maintenance: -$1200

Escrowed funds from unit C (held by property manager): $150

funds transfered to my business bank acct: $3000

  • 0
    SUGGESTED

    GL Acct                         Debit.   Credit

    Cash.                              3000
    Revenue.                                      4500
    Manager Expense.         450
    Maintenance.               1200
    Transfer from Escrow                   150
    Total.                              4650.      4650

    If you are keeping information in  A/R module, you do this entry for each Apt Acct with just its portion.

    I would also record a reduction in amounts held by the manager:

    Revenue from Escrow.                     150

    Deposits in Escrow.         150

    (Liability Acct)

    The key is making sure you having the right accounts in your Chart of Accounts. 

    I hope this helps.

  • 0

    Hi , if this suggested answer helped, please mark it as verified White check mark (by clicking the "Verify Answer" button next to Reply, on the response) for the benefit of others in this forum Slight smile. Thank you!