Other Setup Topics
Account Categories (Video)
Account Categories is a feature within Martus that allows you to group accounts for reporting purposes. With account categories, you can consolidate information on your Income Statement and other financial reports into a concise format that groups related GL accounts together.
Setting Up Account Categories
- Go to Setup > Account Categories, and click Add Category to create categories.
- To create child categories, select a Parent category. You can nest as many parent/children as needed.
- Drag and drop your categories to order them as needed.
- Once all your account categories are created, go to Setup > Accounts and change the Category of your accounts.
Changing the Order of Account Categories
- Create at least two account categories.
- Click on the gripper (it looks like an 8 domino) to the left of an account category and drag it to the appropriate place.
- Changes are automatically saved.
Note: In order to move an account category under a new parent (a category without any children), first edit one of the children and set the parent to the new parent. Then you can drag and drop under that parent category.
Using Account Categories
Account categories are used to group accounts for reporting purposes. You can select them as Rows, and also specify a specific category to view on most reports under Account Category. Additionally, use Account Categories in Load Second Dimension when Rows are set to a dimension. Account categories can also be used in Report Builder.
Account categories can also be used in Report Builder.
The video below walks you through setting up account categories.
NOTE: This video does not yet demonstrate the more recent release of the ability to drag and drop categories.
Setup > Calendar - Managing the Last Closed Month
The Last Closed Month is the only data within Martus that should be updated each month.
The Last Closed Month in Martus determines the default Ending Date on your financial reports and in the ReportBuilder. It defines the month through which actuals are shown in the reference data on budget worksheets. It also defines which month actuals are loaded into a budget when creating a budget.
Note: Martus’ Last Closed Month is completely independent of your accounting system. The Last Closed Month has no impact on the nightly sync of GL activity from your accounting system into your Martus financials.
You should update the Last Closed Month regularly to maximize the usefulness of Martus. The best practice is to do this each time you close a month in your accounting system. Many Martus clients like to set the Last Closed Month to the current month so that viewers of the financial reports will automatically see the most recently synced actuals.
When you set the Last Closed Month, you can also choose to send an email to all your Martus users. That email contains a link so that your users can go straight into Martus! This email can be customized. Click here for more information.
The Setup > Calendar page also displays and can assign the Dashboard budget. The Dashboard budget is the budget that will be available to non-admin users on the Dashboard > Financial reports. It is also the budget that will be defaulted for Admins. This should be set for the fiscal year the month is closed in.
Close a Month - Step by Step:
- Go to Setup > Calendar.
- Select the appropriate month.
- Click Notify Users to send an email to your users, if desired.
- Click Close Month.
Set a Dashboard Default - Step by Step
- Go to Setup > Calendar
- Click Set Defaults
- Choose the appropriate budget
- Select Lock Worksheets to ensure the budget can not be unintentionally changed
- Click Save
Martus Status Summary
Use the Martus Status Summary to review your Martus Status Score
A perfect "100" indicates that you are using Martus well, are ensuring that your users have easy access to updated actuals, and that you have key budget components locked down.
To Access your Martus Status Summary
Admin Reports > Martus Status Summary
Explanation of the Martus Status Score
This score reflects your Martus configuration and usage. Points are deducted as follows:
- -10 if the Last Closed Month is more than three months in the past
- -10 if any worksheets in the Dashboard budget are not locked
- -30 if there is no default Dashboard for the current fiscal year
- -30 if there are no recent logins (within the last 30 days)
Example of a Perfect 100 Martus Status Score
Example of a 90 Martus Status Score
- The Dashboard budget (which is usually your approved and final budget!) has some unlocked worksheets subtracting 10 from their score for a total of 90 points
Example of a 60 Martus Status Score
- The Last Closed Month is several months in the past. Update this to the current month so that users will automatically see current actuals when they log into Martus. (A setting in the past like this means that users must take an extra step to choose a more current date when they review their reports.)
- There is no default Dashboard budget set. This means that users either have to select the budget to be used for comparison on their reports, or that there is no budget available for them to see at all!
User Login Summary Widget
This widget shows important information about your Martus users, including:
- Total Active users and total user licenses
- Number of users who have logged in within the past 30 days, 60 days, last year, and never.
- There’s a link to the User List so that you can quickly update users, for example, inactivating users who have never logged in.
- If no users have logged in the past 30 days, 10 points are deducted from your Martus Status Score. (In practice, this score deduction is only be made when this score is viewed by Martus Support, since you have to actually log in to see this screen!)
Activity Log
The Activity Log is a feature of the Plus and Premium subscriptions. The log captures the date and time of the activity, the user who performed the action, the action, the entity (the object of the action), and provides additional details as well.
The Activity Log is accessed from Admin Reports in the menu, so it is available only to Admin users. There are no additional permissions that apply to viewing the Activity Log.
NOTE: The Activity Log can also be accessed from a Planner worksheet. It contains activity specific to the open worksheet.
The Activity Log captures these and many more actions:
Setup > Branding
The Branding page allows you to control the look and feel of certain aspects of Martus. This page includes three tabs:
- Logo - Add a logo file of either .jpg or .png that can be utilized in ReportBuilder
- Close Month Email - Allows customization of the Last Closed Month email
- Invitation Email - Allows customization of the New User Email
Adding a Logo for ReportBuilder
- Go to Setup > Branding
- Navigate to the Logo tab
- Click Choose File to find the appropriate file, which must be a .png or .jpeg file
- Click Upload Client Logo
- The file types that are supported to be uploaded within branding are .jpg and .png
For more information on ReportBuilder formatting, click here.
Customizing the Close Month Email
- Go to Setup > Branding
- Navigate to the Close Month Email tab
- Fill out the form as desired
- The email above will appear as follows when delivered:
For more information on the Last Closed Month, click here.
Customizing the Invitation Email
- Go to Setup > Branding
- Navigate to the Invitation Email tab
- Fill out the form as desired
- The email above will appear as follows when delivered:
For more information on adding Users, click here.
Dimension FAQ
What are dimensions?
- Dimensions can be thought of as tags on GL activity that allow your GL activity to be filtered and summarized in many different ways.
- Defining dimensions in Martus is a crucial configuration that affects the structure of budget worksheets, user restrictions, and reporting filters.
How can I see my dimensions?
- You can see the dimensions that are configured in your Martus instance by going to Setup > Dimensions
What is a line dimension vs a sheet dimension
- Line dimensions are tags inside a budget worksheet on the budget line.
- Sheet dimensions determine how budget worksheets are defined. A separate budget worksheet is created for each unique combination of sheet dimensions.
- Examples of line vs sheet dimensions can be found here
I need additional dimensions to be added to Martus, how can I get those added?
- Please create a ticket through the Knowledge Base if you are a direct Martus customer or contact your Martus reseller if you are supported through one of our Martus partners.
I want my dimensional setup to be different than how I have my instance set currently, how can I do that?
- Please create a ticket through the Knowledge Base if you are a direct Martus customer or contact your Martus reseller if you are supported through one of our Martus partners.
API Based Clients
If I rename my dimensions in my accounting software will the rename flow down to Martus?
- Yes, the name change will flow down to Martus in our nightly sync.
File Based Clients
I renamed my dimension in my accounting software, what do I need to do now?
- Please create a ticket through the Knowledge Base if you are a direct Martus customer or contact your Martus reseller if you are supported through one of our Martus partners.
What will happen if I do not advise Martus of the name change?
- When you attempt to upload your monthly transactions It will cause your upload to error
Changing Your Accounting System
Martus integrates with more than 20 accounting and ERP systems. Each integration is slightly different and requires that Martus be configured in specific ways.
If you are planning on changing your accounting system, we'll need to create and configure a new instance of Martus. There is a reimplementation fee associated with switching accounting systems.
We can help make your transition as smooth as possible! Please create a ticket through the Knowledge Base if you are a direct Martus customer, or contact your Martus reseller if you are supported through one of our Martus partners.
Review the questions below and provide the requested information in your support ticket or to your partner. That will help us or your partner to work with you to develop a transition plan.
Information to Provide in the Ticket to Support or your Partner
What is your current accounting system? And your new system?
- Current system:
- New system:
When do you plan to go live on the new system?
Are you keeping the same fiscal year?
- Yes
- If no, what is your new fiscal year?
Would you like to upgrade to a different subscription during the transition?
- Yes / No
Dashboard Updater
Martus' budgeting and reporting features rely on the ability to view what has been spent verses what is budgeted. The budget to actual reporting and the ability to see actuals while budgeting are key aspects of Martus. For our customers using one of our integrated accounting systems, the flow of actuals into Martus happens automatically every weeknight via the auto-update process, also called the nightly sync.
Martus automatically syncs via our API with the following integrated accounting systems. (For other accounting systems, Martus provides a file-based approach where actuals can be loaded manually or through the Martus EZ connector.)
- Sage Intacct
- QuickBooks (QBO and Desktop)
- Financial Edge NXT
- Microsoft Dynamics
The Martus Sync
Martus' auto-update runs every weeknight. It automatically syncs:
- The current and previous two months of actuals
- Scenario one: Current date of 1/1/2024 - Martus will sync Jan 2024, December 2023, November 2023
- Scenario two: Current date of 6/30/2024 - Martus will sync June 2024, May 2024, April 2024
- The Chart of Accounts
- All dimensions
Manually Syncing Actuals
Whether there are transactions in the accounting system added today that need to be visible in Martus to run a report, or there have been older transactions added to the accounting system that were not synced via the nightly routine, the following steps will refresh all actuals in Martus for the months chosen.
- Go to Dashboard > Updater.
- Choose the appropriate months.
- Click Sync Monthly Actuals.
Manually Syncing Dimensions
There are times when it is necessary to add data such as accounts or dimension values to your accounting system and have that data immediately available in Martus rather than waiting for the nightly sync.
- Go to Dashboard > Updater.
- Click the appropriate Chart of Accounts or Dimension Sync - your Martus instance may have different dimension options.
The Updater Task Queue
The Updater Task Queue is a list of all jobs, both automated such as the nightly sync (or auto-update), and manual such as a budget copy. The task queue is monitored by Martus Support staff who may reach out to you if there are issues. The task queue will show all successful and errored jobs. If you receive an error, please create a ticket through the Knowledge Base if you are a direct Martus customer, or contact your Martus reseller if you are supported through one of our Martus partners.
Martus Sync Limitations:
- The Dashboard > Updater screen only PULLS information from the accounting system. It does NOT push data from Martus out to the accounting system.
- It is possible for Martus support staff to PULL budgets from the accounting system if needed.
- Intacct Customers ONLY - can PUSH their budget directly to Sage Intacct via the Planner > Intacct screen.