FAQ & Checklists for Getting Started with Martus
FAQs and More
FAQs - Answers to Frequently-Asked Questions
Click the link below for a document with answers to common questions!
- What browsers are supported?
- Why can't a budget owner access a specific budget worksheet?
- What if a user forgets his password?
- What steps do you need to take each month?
- There's a discrepancy between Martus and my accounting system
- There's a discrepancy between the total on a report and the transaction detail that I see upon drilldown!
- Adding new dimension values
- How do a get a new account in my Chart of Accounts to show up in Martus?
- How do I add a new budget worksheet?
- What if I want to pre-set some budget amounts that budget managers can see but cannot change?
- How do I print the reports that I can see in Martus?
- A user gets the message "Invalid Credentials" when he tries to log in.
- How to remove a user from Martus
Multi-Currency Support (with Sage Intacct)
In our integration with Sage Intacct, Martus includes support for multiple currencies for both actuals and budgets. Martus also allows you to view actuals and budget in local currency or consolidated into a single currency.
The amounts within Martus are nominal (not formatted for any specific currency). Each location or entity can view their actuals and do their budgeting in their local currency. When uploaded to Sage Intacct, this budget should be loaded to the Intacct budget that is also in local currencies.
To view consolidated actuals, a second instance of Martus is required. This instance is configured so that it is connected to the consolidated books within Intacct. Both instances share the same chart of accounts and dimensions. Users can be authorized in one or both instances. (Any users who are set up to access both instances can toggle between those instances without logging out.)
If a consolidated budget is also required, a feature within Martus allows you to provide currency conversion factors to convert the local-currency budget to a consolidated currency budget. You can then import this budget into your second (consolidated) instance of Martus. This budget can also be uploaded to Intacct, if desired.
Within Martus, currencies and the currency conversion rate are defined at the level of the location dimension.
The second instance of Martus uses the Alternate Transaction BookId setting to specify the consolidated books as show in the example below. This is configured by Martus Support as part of implementation of the Multi-Currency feature.
Use the chart below to work through these questions.
Checklist for Getting Started with Martus
After training, review and complete the steps in the document below. Then you'll be ready to start using Martus!
Sheet Dimension vs Line Dimension
Sheet Dimensions and Line Dimensions
Defining dimensions in Martus is a crucial configuration that affects the structure of budget worksheets, user restrictions, and reporting filters. When defining dimensions we need to understand two terms: Sheet dimensions and Line dimensions. Martus supports up to eight dimensions (five sheet dimensions and three line dimensions).
Sheet Dimensions
Sheet dimensions determine how budget worksheets are defined. A separate budget worksheet is created for each unique combination of sheet dimensions. Users will then use these worksheets to create a budget for that specific area of the budget..
For example, if Location and Department are both sheet dimensions, worksheets will be created for each combination like this:
|
Notes about Sheet Dimensions:
- Used in combination to define budget worksheets.
- Do not need to be set as required since Martus Admin users have discretion and control over the dimensions used to define worksheets.
- Within Martus you can have up to 5 sheet dimensions
Line Dimensions
Line dimensions are tags inside a budget worksheet on the budget line.
For example, if Project is a line dimension there could be multiple budget lines for the same GL account inside of that worksheet:
|
Notes about Line Dimensions:
- Used inside a budget worksheet and SPW (Special Purpose Worksheet) lines to provide additional granular budgeting
- Can be set as "required", meaning a line dimension value is necessary on every budget line on worksheets and SPWs.
- Within Martus, you can have up to 3 line dimensions
- Line dimensions can also be set to "non-budgetable" - which means you won't be able to budget to that dimension but that dimension will be accessible as a filter to see activity on financial reports
Changes to Your Dimension Settings and Dimension Structure
If you want to discuss making a change to your dimension configuration or dimension settings, 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. Note that some kinds of changes will require a reimplementation of Martus.
Please see our Dimension FAQ document for more information!