Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 3rd 10, 01:58 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 10
Default anyone have a simple income/expenditure sheet, excel

Hi,

I need to make a simple income and expenditure sheet for a new venture,
would like a 1 worksheet per month so this can be filled out on a daily
basis. Does anyone have one ready made before I start scratching my head
putting formulas in?

  #2   Report Post  
Old April 3rd 10, 02:09 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,441
Default anyone have a simple income/expenditure sheet, excel

Don't use formulas and don't use multiple sheets. Use a database with
columns for date, amount (positive for income, negative for expenditures),
and descriptors (as many as needed) and then use a pivot table on the
resulting database. Here is what I use for my columns:

Reference Number
Date Entered
Date Rec/Paid
Status
Action
Master Account
Sub-Account
Amount

There are plenty of sites and help files available concerning pivot tables -
formulas are completely unnecessary and are a source of error.

HTH,
Bernie
MS Excel MVP


"Lesley" wrote in message
...
Hi,

I need to make a simple income and expenditure sheet for a new venture,
would like a 1 worksheet per month so this can be filled out on a daily
basis. Does anyone have one ready made before I start scratching my head
putting formulas in?


  #3   Report Post  
Old April 3rd 10, 02:21 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 1,522
Default anyone have a simple income/expenditure sheet, excel

I also recommend only ONE sheet and you can use datafilterautofilterby
date

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Lesley" wrote in message
...
Hi,

I need to make a simple income and expenditure sheet for a new venture,
would like a 1 worksheet per month so this can be filled out on a daily
basis. Does anyone have one ready made before I start scratching my head
putting formulas in?


  #4   Report Post  
Old April 3rd 10, 03:11 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 11,501
Default anyone have a simple income/expenditure sheet, excel

Hi,

You should find something here

http://office.microsoft.com/en-us/te...595491033.aspx

With regard to:-

1 worksheet per month so this can be filled out on a daily basis


Don't do it!! This forum is full of posts along the lines of "I have a 12
worksheets and I want to make a summary sheet" which is another way of saying
'I started my project without thinking it out'. If all the data are on a
single sheet it's much easier to use filters to summarise data.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Lesley" wrote:

Hi,

I need to make a simple income and expenditure sheet for a new venture,
would like a 1 worksheet per month so this can be filled out on a daily
basis. Does anyone have one ready made before I start scratching my head
putting formulas in?

  #5   Report Post  
Old April 3rd 10, 08:01 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2010
Posts: 181
Default anyone have a simple income/expenditure sheet, excel

Hi Lesley

Seems like we are on similar levels.

I'd take Mike's advice and scan the available templates. See what you can
find and adapt to your requirements.

There is some really good advice from subscribers here but sometimes they
don't appreciate that not everyone is at their level.

--

Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Lesley" wrote:

Hi,

I need to make a simple income and expenditure sheet for a new venture,
would like a 1 worksheet per month so this can be filled out on a daily
basis. Does anyone have one ready made before I start scratching my head
putting formulas in?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating an Income & Expenditure Sheet Molly Excel Worksheet Functions 1 January 16th 10 04:06 PM
how do i set up an income and expenditure account in excel? Novice24 Excel Worksheet Functions 0 October 9th 07 10:33 PM
I'm looking for an income expenditure budget sheet in excel please danny Excel Discussion (Misc queries) 1 March 2nd 07 10:50 PM
personal income and expenditure chart mikeyboy87 New Users to Excel 1 December 14th 05 03:35 PM
is there a template for an income and expenditure statement in Ex. soak93 Excel Discussion (Misc queries) 1 February 27th 05 11:55 PM


All times are GMT +1. The time now is 03:42 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017