This will show the lines faintly to make it easier to work on. In Page Layout, tick View and Print in Gridlines.Go back to Income page or Expenditure tab, whichever one you want to start with.Put the ref number on the Expenses Claim form and the date it was paid. Suggestions for Expenses: Date, Paid to, Ref No and Amount. You can then use breakdown columns such as Grants, Donations, Event 1, Event 2 (you would use a better description of the event than that). Suggestions for Income are: Date, Source (who the cheque came from), Description and Amount. Write on invoice the date paid and the cheque number. You enter the amount of the payment into the Amount column and the relevant breakdown column. Suggestions are: Room hire, catering, Expenses and any others you wish to list. You can then use more columns to break down how much you have spent under each heading. Suggestions for Expenditure are: Date, Payee, Cheque No, Invoice No, Description, Amount. Type in your column headings across this row. Go up to the blank row beneath the row with the letters A, B, C, etc. Click on the tab for whichever sheet you want to begin with, either Income, Expenditure or Expenses.Note: You don’t have to use those titles you can call it whatever you want. Then double click Sheet 2 and type Expenditure, then Sheet 3 and type Expenses. Double click on Sheet 1. When it is highlighted type Income. Sheet 1 will change to Income.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |