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
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.






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.