Getting Started
- Import trial balance, months P&L, months balance sheet
- Key in a financial statement and in minutes 90% complete.
- Key in data or import from Quick Books, Peachtree, GreatPlains, Excel or any accounting software.
- Calculate annual sales by month plus collections
- 3 methods of calculating sales collections:
- Percentage of sales
- Developed pattern (so much collected in following month etc.)
- Collections computed based on days sales in accounts receivable.
- Sales by product, customer any unit of production desired. Collections can be different assumptions for each unit.
- Revenue using percentage of completion method of accounting.
- Credit availability analysis
- Payroll spreadsheet
- Comparative P&L (actual vs forecast)
- Comparative cash flow (actual vs forecast)
- Comparative Balance Sheets and financial ratios
- Monthly ratios with exceptions
- Integrated actual with your budget/forecast
- Sales by product Analysis
- Break-even analysis
- Ratio analysis
- Job cost analysis
- Sales by product vs. actual products sold
- Plus 14 additional reports:
- P&L: monthly, quarterly, year to date
- Cash flow: monthly, quarterly, year to date, indirect and direct methods
- Term loans report
- Notes receivable report
- Notes and assumptions automatic
- Graphics
- By product, customer, employee etc.
- Develop cost using 33 cost items
- Up to 250 expenses
- 9 expense departments
- 11 methods to calculate an expense:
- Percent of sales
- Fixed expense
- Percent of another expense
- As you wish
- When you know the expected amount
- Adjust prior years expenses +/-
- Drill it down into unlimited items
- Linear regression
- Product by units x cost per unit
- 52 weekly amounts
- Relate and compute expense based on product, customers revenue
- Amortization of prepaid expenses
- Edit the payment assumption to be applied to an expense
- Multiple year forecasting up to 5 years or more
- Have up to 99 forecasts online
- Sales tax payment and collection
- Interest on cash balances
- Dividends: charge equity or show as an expense
- Loans to/from affiliates and much more!
- Forecast payroll by employee
- Consolidate multiple entities
- Roll the forecast forward for 1,2 or 3 months
- 1 to 13 week cash flow forecast
- Customer deposits on A/R
- Convert reports to non-profit status
- Service contracts, amortization with related deferred income
- Expense computed on net income
- Drill Down and roll up an expense
- Payroll by employee if desired
- 12 business tools including business valuation
- Currency Converter
- Discounted cash flow
- Capitalization of excess earnings
- Our answer to the spreadsheet - very powerful!