Database Design for Income and Expenditure

[reddevil1]

Hi,

I would be very grateful if anyone could advise the best way to design an Access database to record Income and Expenditure???

Is it best to have 2 separate Tables to record the INCOME and the EXPENDITURE???


1. My thoughts are that I need 2 different Tables:-
Income Table
Expenditure Table

2. Therefore, I will need 2 different Forms:-
Income Form (to record money coming in such as rental income, annual management fee, commission, advance payment for repairs etc)
Expenditure Form (to record money paid out such as payment for repairs, taxes, association dues etc)

3. Therefore, to produce a Report of all the INCOME and EXPENDITURE (to see the overall Profit/Loss), I will need to merge these 2 tables together before I produce the Report?

I was wondering if this is the best way, or if I am missing something a lot more easier?

Thanks in advance.

 

[Rabbie]

I use one table for Income and a different table for Expenditure. For reports that need both sets of data I use a Union Query to combine the relevant data.

 

[reddevil1]

Thanks for your suggestion, Rabbie.

Do you encounter any problems with joining so many different field names?

Example:

My Income section will have
Date Money Received
Received by

My Expenditure section will have
Date Money Paid Out
Paid Out by

and many more examples?

 

[Rabbie]

I do try to use names like dteDate for the date field in each table which makes life a little easier. Also I never use spaces in these data names as it just causes problems. I put extra info in the comment field in Design view so I know whats what