+ Reply to Thread
Results 1 to 2 of 2

Simple Income & Expense Spreadsheet

  1. #1
    Registered User
    Join Date
    10-04-2016
    Location
    Miami, FL
    MS-Off Ver
    2007
    Posts
    11

    Simple Income & Expense Spreadsheet

    I'm working on creating a spreadsheet for my needs. I am in need of a simple spreadsheet that tracks my income and expenses and can do some simple calculations for me to analyze my business, and maybe add some complex calculations as I needs arise. Now one question I do have that is aside of the main reason for this post is, would it be better to create this in Access? I would not be too fond of Access at the moment, because that would require more learning to do what I have already created in Excel. Plus my comfort level rests more with Excel than Access at the moment and I need this income/spreadsheet now, and really can't add more time by having to learn Access.

    I have two sheets in my current income/expense spreadsheet. One is for income and the other for expenses, naturally. I have the following fields on one row:
    Date, Job Type, Amount, Address, Contact Name, Contact Phone, Contact Email, Approx. Time (hrs), Dump Fee, Referral Fee, Subcontract Fee, Notes

    So here are my needs.
    1) A form that enters data

    2) Form needs to create a new row at the top and enter the newest data above the topmost data.

    3) "Job Type" field needs a pull down list in the form to choose type of job.

    3) Row coloring needs to stay consistent as new data is entered. [every other row is shaded for easier viewing]

    4) Date data entered that starts the beginning of new month (i.e. Oct. 1) will also trigger a new row that will total and show the entire previous month income with a border across entire row to visually separate from the other months.

    5) "Amount" field in the form will calculate net income based dependent on fee amounts entered if any (dump, referral, subcontract) and input calculated amount.

    If anybody can help me create this form, I would be greatly appreciative. Thank you.

    Regards,
    BP

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Simple Income & Expense Spreadsheet

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Monthly Income and Expense worksheet
    By Oithematt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2016, 03:20 PM
  2. expense & income calendar
    By chantey88 in forum Excel General
    Replies: 5
    Last Post: 01-09-2014, 10:26 AM
  3. Replies: 2
    Last Post: 08-01-2013, 08:31 AM
  4. Linking Check Registry to Income and Expense
    By AllElements in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-05-2006, 11:21 PM
  5. Re: Income/Expense Spreadsheet
    By Home in forum Excel General
    Replies: 0
    Last Post: 06-14-2006, 05:00 PM
  6. What template is best to show an income and expense statement
    By Leinad Retep in forum Excel General
    Replies: 0
    Last Post: 03-13-2006, 12:00 AM
  7. How do I set up my expense/income statement in excel?
    By Jean in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 05-05-2005, 03:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1