Financial Information Package
Posted on February 22, 2019Developed entirely in Microsoft Excel, the Financial Information Package (FIP) extracts transaction data and monthly totals from Yardi Enterprise‘s Microsoft SQL Server database for comprehensive data analysis.
FIP was designed to streamline monthly financial reporting. It overcomes the limitations of Yardi Enterprise to offer the ability to construct dashboards and generate interactive, collapsable financial statements and worksheets for reporting any level of detail.
Computes balances and net changes for any general ledger account or group of accounts, for any period or range of periods, and for any property or property list using easy Excel functions.
YardiBeginBalance(Property, AccountCode, Period)YardiNetChange(Property, AccountCode, BeginPeriod, EndPeriod)YardiBudgetBeginBalance(Property, AccountCode, Period)YardiBudgetNetChange(Property, AccountCode, BeginPeriod, EndPeriod)
Provides a consistent style to all financial reporting. Rid yourself of the “ransom note” style that occurs naturally when compiling multiple spreadsheets developed independently. Colors, margins, fonts, and scaling are consistent across all worksheets.
FIP is entirely maintenance-free, and has been in production since 2010 with enhancements utilitizing the included features being the only changes. When introduced, production time for monthly financial reporting went from two weeks to one hour, and appearances improved significantly.
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.