Income Statement Form

[askajan]

I have run into a wall building my database and am seeking the help of the experts in this forum. I want the user to be able to enter the following based on the client's financial statements:

RevenueItem1
RevenueItem2
RevenueItem3
RevenueItem4
RevenueItem5
NetRevenue
ExpenseItem1
ExpenseItem2
ExpenseItem3
ExpenseItem4
ExpenseItem5
TotalExpenses
NetIncome

The issue I am running into is that I need the user to be able to define the name of each revenue and expense item (e.g., professional fees, supplies, etc.) and then take it one step further and classify each expense based on industry benchmark data. For example

Client's Statements
Supplies Expense $10,500

Form
ExpenseItem1=Supplies Expense
ExpenseItem1=$10,500
ExpenseItem1=Administrative Supplies (Per Benchmark Data)

Anyone have any idea the best way to accomplish this?

 

[askajan]

Anyone out there?

 

[joemach]

I think you need to define things a little better so that we can help you. Based on what you have posted, I am questioning the table design of your database.