PRODUCT FEATURES

FINANCIAL MANAGEMENT AT YOUR FINGERTIPS
DOCUMENTATIONCOMPARE US

Learn more about the functions built into our financial product, with each toggle representing its own tab in Excel. For more detailed instructions on how to use each tab, please check out our Documentation.

ACCOUNTING

h

FINANCIAL STATEMENTS

FORECASTING

LOOKUP MANAGEMENT

DATA MIGRATION

SETUP & SUPPORT

Learn more about the functions built into our financial product, with each toggle representing its own tab in Excel. For more detailed instructions on how to use each tab, please check out our Documentation.

ACCOUNTING

Accounting modules to record actual transactions. Included in the financial statements after a full template refresh. Accrual accounting is enabled but optional.

Bank

Accounting module to record cash inflows and outflows for payables and receivables, tax reimbursements and cash gifts.

Sales

Accounting module to record revenue sales. Revenue accounts include inventory sales, contract revenue, fee, revenue, membership revenue, service revenue, subscriptions, fundraising, cash gifts, in-kind contributions, grants, and more.

Expenses

Accounting module to record cash inflows and outflows for payables and receivables, tax reimbursements and cash gifts. Expense accounts are connected to specific payable accounts for easier tracking of obligations.

Payroll & Wages

Accounting module to record payroll expenses, bonus pay and withholdings.

Inventory & Assets

Accounting module to record inventory and asset purchases, inventory development, depreciation and amortization, sales or disposal of assets, and inventory gifts and donations.

Loans

Accounting module to record short-term and long-term loans, as well as principle and interest payments.

Equity (Stock)

Accounting module to record stock equity.

Equity (Non-Stock)

Accounting module to record non-stock (owner and sweat) equity.

h

FINANCIAL STATEMENTS

Dynamic, formatted financial statements and forecast reports designed with the computing power of Power Query and Power Pivot.

General Journal

View information about all actual transactions, sorted by date.

Income Statement

View profit and loss financial statement for actual revenue, direct costs and operating expenses.

Actuals vs Budget

View profit and loss for actuals compared to budget.

Actuals vs Forecast

View profit and loss for actuals compared to forecast.

Forecast Only

View profit and loss for forecast only.

Budget Only

View profit and loss for budget only.

Expected Actuals

View profit and loss for a combination of actuals and forecast within a one year timeframe, based on the selected month for actuals through that month.

Balance Sheet

View balance sheet financial statement.

Statement of Cash Flows

View statement of cash flows financial statement.

Trial Balance

View trial balance of all accounts. If balanced correctly, debits should equal credits.

General Ledger

View running balance by account.

FORECASTING

Multiple forecasting modules provide flexibility for projecting business expenses and revenues for a variety of activity streams. Mark by scenario to test subtotals without deleting assumptions, and choose which final revenue and expense scenarios to upload to the financial statements.

By Operating Expenses

Forecasting module that includes all indirect operating expenses including labor and non-labor.

By Operating Labor

Forecasting module that focuses on indirect operating long-term / recurring labor including payroll employees.

By Amount

Forecasting module that allows direct amount inputs by month, divided into a section for revenue (upper table) and a section for direct costs (lower table).

By Unit Economics

Forecasting module that focuses on product-based forecasting by converting marketing expenses to sales quantity for a particular product, then breaking down the associated revenue per sale and associated cost of sales for that quantity of sales to determine unit revenue, unit cost of sales, and unit gross profit.

By Project

Forecasting module that focuses on project-based forecasting, pulling in project ceiling and actual-to-date information from the Project Lookup.

By Subscription

Forecasting module that focuses on subscription-based product or service forecasting by converting marketing expenses to prospective customers, then splitting existing customers into renewals or churn. Subscriptions have a set price (billed monthly or upfront) and specified durations (usually 12 months or less), while new customers can also have special promotions applied for the first X months of a subscription.

By Proposal Bid

Forecasting module that focuses on future project/proposal bids by size, probability and spread of revenue, cost and gross profit across the lifespan of the project (up to 60 months).

LOOKUP MANAGEMENT

Document and track various data fields for management.

Departments

Setup table for departments.

Employees & Consultants

Setup table for employee and consultant customer types.

Vendors

Setup table for vendor customer type.

Customers

Setup table for sales customer type.

Projects

Setup table for projects on hand.

Products & Inventory

Setup table for products (including services) and inventory.

DATA MIGRATION

Tables to assist with migrating historical or external data or locking in budget scenarios.

Transactions

View all actual transactions data that has been refreshed into the financial statements. Can be copied and pasted to Imported Transactions.

Forecast

View all forecast data that has been refreshed into the financial statements. Can be copied and pasted to Imported Forecast.

Budget

Paste any manual forecast data to be archived as budget. Is designated as budget data in the financial statements, when viewing the income statements.

SETUP & SUPPORT

Guidance on template-wide parameters for preparing your financial management tool.

Parameters

Input the name of the business for viewing on the financial statements. Designate the start date of forecast data. Assign the spread of revenue and cost by month across the lifespan of a potential project/proposal and allocate the direct costs across designated cost accounts and percentages.

Chart of Accounts

View a list of account numbers and names for all accounts. Add 10 pre-allocated custom accounts within the direct cost and operating expense account categories.

Account Scenarios

View available user actions within each accounting module, the column input requirement instructions, and associated double entry accounting rules.