I need to have an input form for expenses and income, my idea was to have the expenses automatically converted to a negative amount when they are input'ed on the form. I have a drop down list of expense types, my expense types are "Income", "Expense", "Capital Expense". Income is invoices paid, expense is lunch or travel, Capital expense is new Laptop.
So when I write a report I can get a very easy income and expense.
Any help would be great.