Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Need Excel program for club treasury

09 Jan 2010   #1
fireberd

Windows 10 64 bit
 
 
Need Excel program for club treasury

I'm not very swift at Excel (and it's been years since I used Lotus 123) and I need a format to keep the treasury "book" for a club. I have Office 2003 and Open Office.

I checked the MS Office downloads, the Open Office downloads and a google search and didn't come up with anything useable.

Thanks in advance.


My System SpecsSystem Spec
.
09 Jan 2010   #2
ignatzatsonic

Microsoft Community Contributor Award Recipient

Windows 7 Home Premium SP1, 64-bit
 
 

Not sure what the question is.

You have Excel. What do you need that you don't have?

You say "format". What does that mean in this context?

Excel is generally completely customizable by the user through setting up columns, tabs, formulas, etc.

Maybe you need a separate bookkeeping type program. If so, I assume free ones are out there, but I am not familiar with them.

Edit:

Maybe you mean Excel template?

I just googled "Excel Bookkeeping Template" and got lots of hits. Here are a few of them.

http://www.bookkeeping-basics.net/ex...-template.html

http://www.topshareware.com/excel-bo...ownloads/1.htm

http://www.startups.co.uk/6678842908...-template.html

http://viselka.com/Microsoft_Excel_Bookkeeping.htm
My System SpecsSystem Spec
09 Jan 2010   #3
mckillwashere

Windows 7 x86/x64, Server 2008r2, Web Server 2008
 
 

You should be able to right click> "Open With" and tell it excel.
My System SpecsSystem Spec
.

09 Jan 2010   #4
smsff7

Windows 7 Pro X64
 
 

Quote   Quote: Originally Posted by ignatzatsonic View Post
Not sure what the question is.
l
He is looking for a format to save in that both MS office 2003 and open office can read
My System SpecsSystem Spec
09 Jan 2010   #5
fireberd

Windows 10 64 bit
 
 

I only need one template for either Excel 2003 or Open Office, but Open Office will work with Excel 2003 templates.

I looked at what I could find doing a google and didn't find anything that would work for a fairly simple application. I'm probably going to have to dig in and read the Help file and make one myself.
My System SpecsSystem Spec
09 Jan 2010   #6
Tepid

Win 7 Ultimate 32bit
 
 

Generally speaking, there may be a template out there that is close to what you wnat
Finding it won't be easy.... Generally you are better off starting from scratch.

Maybe this one will help? not sure.

or here is the Microsoft Excel Template site
My System SpecsSystem Spec
09 Jan 2010   #7
TimStitt

Windows 7 Ultimate 64 bit
 
 

Hi Firebird,

The hard thing here is to find out exactly what you need to record.
Off the top of my head, you may need to consider:
  • Financial Balance Sheet
  • Profit and loss (revenue and expenses)
  • Request for Finance list
  • Petty Cash usage
  • Membership paid / due / owe /type
  • Lost Members
  • Assets and depreciation
  • Bank and Trust account reconciliation
  • Seperate balance sheets for months and End of Financial Year
  • Sponsorships

I've attached a couple of sheets (apologies, as I've lost the original source of the files).
Let us know what information is required and I'm sure we'll see what we can dig up


Attached Files
File Type: zip Example Club Accounts - June 2009.zip (19.4 KB, 449 views)
My System SpecsSystem Spec
10 Jan 2010   #8
fireberd

Windows 10 64 bit
 
 

Thanks, those two may be able to work or make them work. I don't need much, "current funds on hand", "Funds received" and then then the total updated. Expenses and be able to list what the expense was and have that change the total. Very basic.

The club we have is a small unincorporated (no dues) Steel Guitar Club (musicians). I just need to be able to track and update funds from either a 50/50 or selling some club items and any expenditures. I've been doing it manually but it really needs to be on Excel.
My System SpecsSystem Spec
10 Jan 2010   #9
TimStitt

Windows 7 Ultimate 64 bit
 
 

Quote   Quote: Originally Posted by fireberd View Post
Thanks, those two may be able to work or make them work. I don't need much, "current funds on hand", "Funds received" and then then the total updated. Expenses and be able to list what the expense was and have that change the total. Very basic.

The club we have is a small unincorporated (no dues) Steel Guitar Club (musicians). I just need to be able to track and update funds from either a 50/50 or selling some club items and any expenditures. I've been doing it manually but it really needs to be on Excel.
Great! and if you get stuck on the excel stuff feel free to get in touch in me.
My System SpecsSystem Spec
Reply

 Need Excel program for club treasury




Thread Tools




Similar help and support threads
Thread Forum
Excel File and Program default association problem (registry looks ok)
Everything looks okay under the registry (I think) and assoc shows provides the correct output. When I try to manually edit this under the control panel, it will not let me choose "EXCEL" it will not let me choose that file. Does anything stand out as being out of help here? > assoc .xlsx...
Microsoft Office
Excel 2007 - There was a problem sending the command to the program
I am running Office Professional 2007 under W7 64 bit. I can open all programs from Explorer except Excel. This problem has surfaced recently but I don't know exactly the time and can't therefore go back to an earlier restore. I have looked on forums and see that one resolution is to untick...
Microsoft Office
Need help badly - command error when loading excel program
I am getting the command error when trying to load an excel program I have windows 7 home premium 64 bit system.. Please help on how to get this working D
Microsoft Office
Club or Hip hop
Hello every one! I know you may not all be into this kind of music but I need help, I always sit back and wonder where I can find this music I am kind of in to it but I can never find it myself, I have tried in google top 100 club songs or something relating it but I can never find a hit, ...
Chillout Room
Department of the Treasury Website Rigged to Exploit...
Read more - Department of the Treasury Website Rigged to Exploit Visitors - Part of a scareware distribution effort - Softpedia
Chillout Room


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 23:15.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App