Bob Warner
03-13-2003, 02:56 PM
After reading Jerry Fisk's book, I decided to try out his accounting method. I took all of my 2002 records and sat down at the keyboard. After several hours of typing, I came up with an Excel spreadsheet.
I entered all of my 2002 information into the spreadsheet and took the last worksheet of the spreadsheet to my CPA for my taxes, he loved it.
I file all of my recipts into a small (6" X 12") accordian file and at the end of the month I just plug the info into the spreadsheet. All sales and expenses go into it as well as the taxes I owe to the state.
The spreadsheet does all of the math (good for me) and totals everything on the last sheet. There are two lines per date to add stuff but more rows can be added as needed and the spreadsheet just incorporates the new rows into the calculations.
I am not an Excel expert by any means but this may help someone out. If you have the ability to improve on this, I would like to see your changes.
If you don't have Excel, this link will not do you any good. SORRY
www.warnerknives.com/CKD/Expense2003Blank.xls
I entered all of my 2002 information into the spreadsheet and took the last worksheet of the spreadsheet to my CPA for my taxes, he loved it.
I file all of my recipts into a small (6" X 12") accordian file and at the end of the month I just plug the info into the spreadsheet. All sales and expenses go into it as well as the taxes I owe to the state.
The spreadsheet does all of the math (good for me) and totals everything on the last sheet. There are two lines per date to add stuff but more rows can be added as needed and the spreadsheet just incorporates the new rows into the calculations.
I am not an Excel expert by any means but this may help someone out. If you have the ability to improve on this, I would like to see your changes.
If you don't have Excel, this link will not do you any good. SORRY
www.warnerknives.com/CKD/Expense2003Blank.xls