Here is the spreadsheet that my accountant accepts to file taxes for my art business. Expense categories are on separate sheets. The income sheet is to enter in all sales. A separate sales tax sheet is for any sales that are taxable to figure out how much sales tax is owed, add rows and change sum function as necessary. A calculations sheet is to have a single sheet for all the totals.
Date: Thu, 05/28/2009 - 22:17 Application type: Calc Language: en
Here is the spreadsheet that my accountant accepts to file taxes for my art business. Expense categories are on separate sheets. The income sheet is to enter in all sales. A separate sales tax sheet is for any sales that are taxable to figure out how much sales tax is owed, add rows and change sum function as necessary. A calculations sheet is to have a single sheet for all the totals.
Date: Thu, 05/28/2009 - 04:19 Application type: Calc Language: en
Financial transaction data input with a one-page income-expense cumulative monthly report.
Uses SumProduct formula to calculate monthly totals as well as year to date totals for each account number.
Report page is easily modified - just type in your own account numbers and names. Add or delete lines as desired.
Income and Expense data entries require only one line of entry.
Transfers between accounts (folios) need a two line data entry.
Not very elegant, but it works. Suggestions and improvements welcome.
Date: Sun, 04/12/2009 - 11:40 Application type: Calc Language: en
