|
Step 1
Imagine a blank piece of paper. Draw a line down the middle.
On the left of the line list the catagory of your expenses and on the right list your type of income. We
will call and list all your expenses using an 800 number and income using a 900 number. Following is a table which
gives a list of expenses and a number assigned to the expense.
The above is only intended as an example. It is recommended to group similiar expenses. Example: Freight
might be 805 and Postage 806. Car & Travel could be grouped in the 820's, Example: Car Repairs 821,
Car Insurance 822, etc. When you receive a bill or invoice it is suggested that you write the expense code (an 800 number)
on the bill and circle the name, date, and amount. Likewise when receiving money ( an 900 number).
For our example lets assume you have a box of receipts and each receipt has the 800 number on it. There are also
deposit tickets for 900 numbers. You are ready for the next step.
Step 2
For our example we are going to use Microsoft Excell, which is a lot of rows and columns forming a lot of boxes.
This is a spreadsheet. Example: You go down 3 rows and over 7 columns you arrive at a box. We are going
to put the data from the receipts and income received into boxes in the spreadsheet.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Web Link Internet Company
|
|
|
|
|
2
|
15
|
901
|
Johnny's Dog House
|
-
|
-
|
$31.80
|
The first row is for an item you paid for on February 5th for office supplies to Joe's Office Supply with check
number 783 for $56.00. On February 9th you received $31.80 from Johnny's Dog House. You enter every receipt using
the format (number of columns)you deceide upon. There is no need to worry about the dates being in correct order since
at any time you may sort any or all of your entries.
Step 3
|
