Martus' budgeting and reporting features rely on the ability to view what has been spent versus 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.
The Dashboard Updater screen is important as it allows a user to do the following:
- Manually pull into Martus any changes to Actuals on demand.
- Manually pull into Martus any changes to Accounts on demand.
- Manually pull into Martus any changes to Dimensions on demand.
- Display all nightly syncs and other Martus tasks and their status.
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
The nightly process runs the updater to sync the current month and two prior months. If you have made changes in months outside that range, those changes would not be picked up. You will have to manually sync the actuals to ensure Martus picks up those changes. Or if there are transactions in the accounting system added today that need to be visible in Martus to run a report, 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.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article