Investment Portfolio Accounting
Posted on February 21, 2019Developed in Microsoft SQL Server and Microsoft Access (with interfaces to Quickbooks and Yardi), generates accounting transactions and reporting for investments in multiple portfolios and held by multiple institutions.
Documentation
Screenshots
- Investments entry form with subforms
- Investments entry form
Sample Reports
- Investment Transaction Posting Journal
- Investment Transaction Summary by Category Report
- Investment Type Detail Report
Investment Portfolio Accounting has been in production since 2012. It has managed portfolios of up to $500MM.
Budgeting Tool
Posted on February 21, 2019Developed in Microsoft Excel, the Budgeting Tool generates projected financial statements.
Multiple Gross Profit Scenarios
- Revenues
- Cost of Goods
- Variable Costs
- Fixed Costs
Combine Gross Profit Scenarios per Month
- By percent of capacity
- By number of days
- By any other unit of measure
Project Financial Statements
Interactive drill-down to audit projected financial statements
- Double-click any value to see where it originates.
- Quickly isolate sources for busy accounts, like Cash.
Cascading Defaults
- Minimizes inputs
- Overriding defaults per month provides unlimited control when required.
- Killer combination provides power and ease-of-use.
Developed on a tight deadline to replace the less-useful budgeting features in Quickbooks, the Budgeting Tool successfully produced projected financial statements within two weeks of the start of development.