Results 1 to 3 of 3

Spreadsheet to manage rent payments

This is a discussion on Spreadsheet to manage rent payments within the Excel Questions forums, part of the Question Forums category; Hey this probly may be easy for guys who know formulas and functions but I'm out of depth. I work ...

  1. #1
    New Member
    Join Date
    May 2004
    Location
    South Australia
    Posts
    1

    Default Spreadsheet to manage rent payments

    Hey this probly may be easy for guys who know formulas and functions but I'm out of depth.

    I work for a not-for-profit supported accommodation programme. I am constructing an excel spreadsheet to show balance either owing or in advance.

    Payments may be received from different sources and not necessarily at predictable date intervals.

    The amount owing consists of 3 components: Rent and Lodgings costs both must accrue weekly in separate columns and there may be occasional One-off costs to be added in from a third column. These three are totalled in a separate column.

    I have columns showing commencement date, weekly rent rate, weekly lodgings rate. I have other columns to record amounts paid and the date paid.
    I need the spreadsheet to show
    Balance (at today's date), and
    Date paid up to
    but the row of data should remain blank until a payment amount is recorded in that row.

    So somehow I need Payments Received processed to show what date the client is paid up to;
    then I need the costs accrued as of Today to be adjusted by Payments received to show current balance.

    Any ideas how I can construct formulae/function to achieve these?

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    61,985

    Default Re: Spreadsheet to manage rent payments

    A small sample showing your layout would be most helpful.

  3. #3
    Board Regular golf4's Avatar
    Join Date
    Jul 2002
    Location
    Salem, OR
    Posts
    452

    Default Re: Spreadsheet to manage rent payments

    Hi -

    You may want to check out this link:

    http://office.microsoft.com/search/r...EC010331121033

    HTH,

    Golf

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com