User story
As a farmer I want to be able to generate an income statement so that I can understand if my farm has been profitable over a set timeframe
Why?
Farmers need to understand how profitable their operations are to run a successful business. Right now, farmers get a glance at this with the whole farm balance - but it’s a bit of a dead-end for them.
There’s no way for farmers to understand the detailed revenues and expenses without navigating to different pages. There’s no “holistic” view. By exporting an income statement (as an xlsx) we give them the details - a way to see all the categories that go into revenues and expenses, a way to manipulate them in a spreadsheet themselves, and a way to move that data into more powerful financial tools such as quickbooks.
Assumptions
Functional Requirements:
Must-have:
Define a date range over which the financial statement should be generated
Export should include at least 3 sections and all matching revenues and expenses for those sections:
Revenues
Including both crop types and non-crop revenues
Expenses
Each category as a line item
Gross profit / loss (Revenues - Expenses)
Must export as xlsx
Nice-to-have:
Header for report including things like Farm name, date report was run, and active filters
Be able to define criteria for which revenues and expenses are included or excluded
Categories of revenues / expenses
Be able to optionally define a tax rate or static tax amount to be deducted from Gross profit
Net profit section