 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
Yourwebness |
 |
Yourwebness |
 |
SherryShopperFL |
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
The Expense Log is probably the simplest of all the worksheets. This worksheet is designed for you to enter all your business expenses. Because there are business expense that are in addition to required purchase on shop assignments, I was not able to design this to be automated in the way the other worksheets are. So as a result, I have attempted to keep this in a very simple format. The following fields are contained within the Expenses worksheet: |
||
Date |
||
Company Paid (who you gave the money to) |
||
Company For Reference (Company the expense was related to, designed for purchase for shops, faxing, long distance calls, etc.) |
||
Amount (the amount of the expense) |
||
Category (create a category for each type of expense, such as Purchase, tolls, postage, office supplies, Fax, etc...) |
||
Explanation (any notes you want to include that explain what the purpose of the expense is. I find I use many of these explanations for multiple expenses) |
||
Expense Month (automated field) The Shop Month, Shop Week, and the Shop Year columns are automatically populated when you enter a Shop Date for an assignment. A a shop date is entered ONLY once the assignment has been completed. |
||
Expense Week (automated field) The Shop Month, Shop Week, and the Shop Year columns are automatically populated when you enter a Shop Date for an assignment. A a shop date is entered ONLY once the assignment has been completed. |
||
Expense Year (automated field) The Shop Month, Shop Week, and the Shop Year columns are automatically populated when you enter a Shop Date for an assignment. A a shop date is entered ONLY once the assignment has been completed. |
||
This is a full screen shot of the left side of the Expenses worksheet. As you can see, this worksheet is very basic. Again like most of the other worksheets, you have the ability to sort by any of the various column headers. |
This is a full screen shot of the right side of the Expenses worksheet. As you can see, this worksheet is very basic. Again like most of the other worksheets, you have the ability to sort by any of the various column headers. The shop week, shop month and shop year are listed (and are all automated fields) to allow you to analyze expenses easily.
|
This screen shot shows the macro button for the Expenses worksheet. This works just like the macro button on the Assignments page. Due to the formulas and special formatting within each cell, you cannot just insert lines like in a normal spreadsheet. When you run out of rows to enter your new assignments, you simply click this button, and 5 brand new rows will appear below your existing rows. These rows will all contain the proper formulas and formatting.
|
These are just a small number of the available options for using these sorting features that I have incorporated into this spreadsheet. Please also remember, you can select more than one column. So you can view your data any way you want to see if. The possibilities are endless. Seeing your information the way you want to, that is how you can customize this to your needs and make it your system too. Remember, to return to the original options, select ALL rather than a specified criteria on all columns you sorted (shown with a small blue arrow), and all of your data will be visible again. |
||
© 2000 - 2007 Yourwebness' Cyber Corner |
||
