I've set up a Knack object to record financial transactions - basically a very, very simple book keeping / accounting database.
I have fields for Income type (e.g. donation) and amount, and expenditure type (e.g. utility bills) and amount. I have a report set up which totals all the income and all the expenditure.
What I'd like to be able to do is set up a report that combines both those things - so one that calculates the current balances from the totals of the income and expenditure columns.
Is that possible?
Has anyone else used Knack as a very simple accounting package?