Financial Planner provides a comprehensive overview of your organization's financial activities including invoice payments, purchase orders, maintenance expenses, and warehousing costs.
Read till the end to learn how to automate transaction assignments!
Transactions Tab
The "Transactions" tab displays a list of all financial activities within FMX, automatically generated from various modules.
Included Transaction Types
- General costs: Costs associated with work requests, work tasks, and equipment logs.
- Inventory added: Cost of adding new inventory.
- Inventory costs: Costs related to inventory usage in work requests, work tasks, and equipment logs.
- Inventory edited: Changes in inventory quantity or unit price.
- Inventory removed: Reduction of inventory quantities.
- Inventory transferred: Movement of inventory between locations.
- Invoice payment: Payments applied to invoices.
- Labor costs: Costs of worker hours in work requests or work tasks.
- Purchase: Costs of purchased purchase orders.
Note: The transaction list only includes data from when Financial Planner was enabled. For historical data, please contact our support team.
Transaction Details
Each transaction includes:
- Date
- Building (if applicable)
- Associated module
- Type (such as request type)
- Source link
- Transaction type
- Amount
- Credit account name & code
- Debit account name & code
- Last edited by user & timestamp
Creating New Transactions
In addition to automatically generated transactions, you can manually create transactions using the "New transaction" button. This allows you to track other expenses, revenues, and funding, or to correct previous transactions.
Transaction Management
- Filtering: You can filter transactions by any of their key details, including transactions with no assignments or editing users.
- Assignment: Each transaction can be assigned to a debit and/or credit account using the button on each row.
- Bulk Assignment: Transactions can be assigned to accounts in bulk, typically after applying filters by selecting multiple transactions from the grid and hitting the assign button at the top of the page.
- Exporting: The transaction list can be exported as a CSV or Excel file.
NOTE: Integrations for exporting data to ERP or accounting software are available upon request. Contact your Account Manager for details.
Accounts
The "Accounts" tab allows you to manage your active accounts. By adjusting the filters, you can view retired or deleted accounts.
Creating New Accounts
New accounts can be created by clicking "New account" in the top right corner.
For each account, you can first add a name, code, and parent account (if this is a subaccount)
Account Filtering & Automation
You can then filter if an account is used as a credit and/or debit account:
- First, toggle "Debit account" and "Credit account" to determine how it is used in FMX.
- Then, you may further filter by building, module, request type, and transaction type.
Only transactions that meet the specified criteria will be available for assignment to this account. These filters are NOT applied during bulk transaction assignments.
Important: If only one account is available as a credit or debit account for a transaction, it will be automatically assigned. This streamlines the assignment process for simple transactions.
Setting Up Financial Planner
Financial Planner is now included with Invoicing and Purchase Orders. If you would like to add any of these features to your FMX site, please let your Account Manager know!
User Type Permissions
Only selected user types can access Financial Planner. To edit a user type's access, navigate to Admin settings > User Types > > Edit > Financial Planner Access. From here, change the "Financial planner access" field from "No access" to "View only" or "Edit".