Financial Statements (Excel 2002 )

Topic

New Reply

Hello Everyone:

Can anyone give me any advice on setting up for a Financial statements. Are there any easy ways to setup a financial statement in Excel?

If someone could post a sample this would be greatly appreciated.
======================================================================================
Expense File:

Not too long ago I saved a file for a client, but when he opened the file; Excel indicated that it was a “read only,” can anyone advise me on what I did wrong. The CD was a blank RW.

Regards,

Dillon65

Reply | Quote

Replies

Let the client copy the file to hard disk (or to a network drive), then right-click it in Windows Explorer, and clear the Read Only check box. Files copied from a CD are Read Only by default.

Reply | Quote

Let the client copy the file to hard disk (or to a network drive), then right-click it in Windows Explorer, and clear the Read Only check box. Files copied from a CD are Read Only by default.

Reply | Quote

As far as the file being read only…

Have the user open the file from the source (i.e. CD), then click File|Save As…
The Save As dialog box will probably open the the My Documents folder and a ” suggested filename ” will be offered. You can click OK or change the name to something more meaningful. Your newly saved file should be open for editing.

A Financial Statement template may be available on the Microsoft Excel website. If I come across anything, I’ll post a link. The reality is that there are many formats for a FS and finding one that exactly meets your needs will be tough to do. Still, you can change things around to suit you.

Reply | Quote

As far as the file being read only…

Have the user open the file from the source (i.e. CD), then click File|Save As…
The Save As dialog box will probably open the the My Documents folder and a ” suggested filename ” will be offered. You can click OK or change the name to something more meaningful. Your newly saved file should be open for editing.

A Financial Statement template may be available on the Microsoft Excel website. If I come across anything, I’ll post a link. The reality is that there are many formats for a FS and finding one that exactly meets your needs will be tough to do. Still, you can change things around to suit you.

Reply | Quote

Financial Statement Templates?

Check this out…

Reply | Quote

Hello HansV, Ricky:

Gentlemen, thank you so much for the instructions to for resolving the “Read only file,” Ricky thank you for the template information, I greatly appreciate you directing me to the financial template area.

I will go ahead and download the template, and create a different file name and then save it as a template on my hard drive. Would this procedure corrupt the file?

Best regards,

dillon

Reply | Quote

You seem very concerned about corrupting a file. May I suggest that while you are making changes (or editing) a file, that you save it each day with a different filename. In fact, when you first open a “good” file, go ahead and click Save As… immediately and give it a different name. This way, your original is still intact and all the changes are being made to your new file. Example:

2004 04 02 Fin Stmt.xls
2004 04 03 Fin Stmt.xls
2004 04 04 Fin Stmt.xls

You will build up a set of files that will easily allow you to revert back to a working copy when you encounter problems (corruption). You can begin to delete the older files once you’re satisfied everythings okay.

The template you download from Microsoft can be stored on your harddrive in it’s original condition for archival or backup purposes. Just label it as such.

Reply | Quote

A problem (to me, anyway) with ‘preserving’ a known good copy of a file by saving as filename2 is that if it has any macros in it referring to the original file, the code doesn’t automatically reflect the changed filename, so they don’t work.
My practice, for what it’s worth, is to copy the original into a zip, then do whatever ambitious and foolhardy changes on the original. Then, if it works, replace the original in the zip: else, extract the original from the zip and try again.

Concerning files copied from a cd as acquiring ‘read only’ attribute, is there a simple way of changing this attribute to ‘archive’ on a whole bunch at once? One by one is very tedious…

Reply | Quote

Hello Ricky, jrose:

Ricky, your observation is correct, I don’t want to have this particular file get corrupted, and thanks to your brilliant response, I am hoping that I can avoid such a problem, thank for your suggestion.

Jrose, I don’t have a zip reader, unless you are referring to Winzip; if your are referring to the latter, then I will give it a try if, I happen to run into trouble.

cheers mate!

Reply | Quote

Hello Ricky, jrose:

Ricky, your observation is correct, I don’t want to have this particular file get corrupted, and thanks to your brilliant response, I am hoping that I can avoid such a problem, thank for your suggestion.

Jrose, I don’t have a zip reader, unless you are referring to Winzip; if your are referring to the latter, then I will give it a try if, I happen to run into trouble.

cheers mate!

Reply | Quote

[indent]

---

Concerning files copied from a cd as acquiring ‘read only’ attribute, is there a simple way of changing this attribute to ‘archive’ on a whole bunch at once?

---

[/indent]
I’m thinking maybe… Seems like you could use the attrib command from the Dos prompt. Perhaps using wildcards ***, you would be able to set the attribs on multiple files at once. As I am uncertain of this, I’d suggest you wait for another lounger to make this more clear or suggest an alternative.

Reply | Quote

[indent]

---

Concerning files copied from a cd as acquiring ‘read only’ attribute, is there a simple way of changing this attribute to ‘archive’ on a whole bunch at once?

---

[/indent]
I’m thinking maybe… Seems like you could use the attrib command from the Dos prompt. Perhaps using wildcards ***, you would be able to set the attribs on multiple files at once. As I am uncertain of this, I’d suggest you wait for another lounger to make this more clear or suggest an alternative.

Reply | Quote

You can select a number of files in Windows Explorer, then select File | Properties, and clear the Read Only check box. In Windows XP, click Advanced to tick the Archive check box, not sure about other Windows versions.

Ricky is right, you can also use the DOS command attrib: in a command prompt window, type

attrib -r +a c:excel*.*

(where c:excel is the path) and press enter. You could also put this line in a batch file (i.e. a text file with extension .bat); a batch file can be executed by opening it from Windows Explorer.

Reply | Quote

You can select a number of files in Windows Explorer, then select File | Properties, and clear the Read Only check box. In Windows XP, click Advanced to tick the Archive check box, not sure about other Windows versions.

Ricky is right, you can also use the DOS command attrib: in a command prompt window, type

attrib -r +a c:excel*.*

(where c:excel is the path) and press enter. You could also put this line in a batch file (i.e. a text file with extension .bat); a batch file can be executed by opening it from Windows Explorer.

Reply | Quote

[indent]

---

A problem (to me, anyway) with ‘preserving’ a known good copy of a file by saving as filename2 is that if it has any macros in it referring to the original file, the code doesn’t automatically reflect the changed filename, so they don’t work.

---

[/indent]

It is best not to explicitly use workbook, worksheet names or ranges in code for this reason.

You can use:

ActiveWorkbook

to refer to the “activebook”. You can use:

ThisWorkbook

to refer specifically to the workbook which contains the code

Another way is to hold the object name (book, sheet, range) in a variable, and define it once in code. Then only refer to it via the variable. If you ever have to change the object you can use some technique at run time to “get it” (if posssible) or at worst, you have only 1 place to manually change the name.

Steve

Reply | Quote

[indent]

---

A problem (to me, anyway) with ‘preserving’ a known good copy of a file by saving as filename2 is that if it has any macros in it referring to the original file, the code doesn’t automatically reflect the changed filename, so they don’t work.

---

[/indent]

It is best not to explicitly use workbook, worksheet names or ranges in code for this reason.

You can use:

ActiveWorkbook

to refer to the “activebook”. You can use:

ThisWorkbook

to refer specifically to the workbook which contains the code

Another way is to hold the object name (book, sheet, range) in a variable, and define it once in code. Then only refer to it via the variable. If you ever have to change the object you can use some technique at run time to “get it” (if posssible) or at worst, you have only 1 place to manually change the name.

Steve

Reply | Quote

A problem (to me, anyway) with ‘preserving’ a known good copy of a file by saving as filename2 is that if it has any macros in it referring to the original file, the code doesn’t automatically reflect the changed filename, so they don’t work.
My practice, for what it’s worth, is to copy the original into a zip, then do whatever ambitious and foolhardy changes on the original. Then, if it works, replace the original in the zip: else, extract the original from the zip and try again.

Concerning files copied from a cd as acquiring ‘read only’ attribute, is there a simple way of changing this attribute to ‘archive’ on a whole bunch at once? One by one is very tedious…

Reply | Quote

You seem very concerned about corrupting a file. May I suggest that while you are making changes (or editing) a file, that you save it each day with a different filename. In fact, when you first open a “good” file, go ahead and click Save As… immediately and give it a different name. This way, your original is still intact and all the changes are being made to your new file. Example:

2004 04 02 Fin Stmt.xls
2004 04 03 Fin Stmt.xls
2004 04 04 Fin Stmt.xls

You will build up a set of files that will easily allow you to revert back to a working copy when you encounter problems (corruption). You can begin to delete the older files once you’re satisfied everythings okay.

The template you download from Microsoft can be stored on your harddrive in it’s original condition for archival or backup purposes. Just label it as such.

Reply | Quote

Hello HansV, Ricky:

Gentlemen, thank you so much for the instructions to for resolving the “Read only file,” Ricky thank you for the template information, I greatly appreciate you directing me to the financial template area.

I will go ahead and download the template, and create a different file name and then save it as a template on my hard drive. Would this procedure corrupt the file?

Best regards,

dillon

Reply | Quote