FileMaker tips, techniques, and news.

By Kiyan Allaei  Posted on  January 12th, 2021  in  FileMaker, Free Downloads

FileMaker Sage Intacct Integration

Sage's Intacct accounting software is a powerful tool that helps finance professionals increase efficiency and manage growth with roughly 5% of ERP market share. Intacct is often used to manage accounts payable, accounts receivable, general ledger, and much more. Many companies who find themselves with both Intacct and FileMaker end up having to do double data entry from one system to the next. We will demonstrate how you can eliminate the hassle of manually copying the information by integrating your FileMaker solution with Sage Intacct.

Getting Started with Sage Intacct

Since the Intacct API is a paid service for subscribers, you will need to have already signed up for Sage Intacct before moving forward. API trials are not granted for demo accounts. Once you have your account set up, reach out to your account manager to sign up for the XML SOAP API. You will then be provided with a senderID and sender password for your account. These credentials remain the same for both sandbox and production environments.

Making Requests and Parsing the Response

Once you have your API information, you can immediately begin building your integration. For any questions regarding how requests should be built, please reference the Intacct API Documentation. Sage also provides a Postman collection to download from their Tools and Libraries page

The Sage Intacct API uses a single endpoint URL:

Every Sage Intacct API request requires parameters to be passed in XML URL encoded format. For example, the Create Customer request in a POST request requires three parameters and supports many other optional data points. Since XML can be troublesome to format in FileMaker, we recommend copying the XML from a text editor into an "Insert Text" script step. This XML will be passed as a parameter using cURL in FileMaker's "Insert from URL" script step.

Once a request has been received, Intacct will return an XML encoded response. You will then need to parse the XML to determine if the request was successful. There are three levels of error trapping you need to set up for your requests; the sender status, authentication status, and body status. If any of these responses do not return "Success", then your request was not successful. In our demo file, we use a custom function to parse the XML response.

If you need to extract further data from the response, you will simply parse out the required data from the same XML response.

Authenticating with Sage Intacct

The Intacct API uses session-based authentication for all requests. This means you will need to make two API calls for every request; one to create the session and one to push/pull your data. It is possible to skip this and authenticate with each request; however, this is not recommended as it makes error trapping more difficult, forces more authentications from your admin user, and is only compatible with your top-level location.

To create a session, you will need to pass the following parameters: sender ID, sender password, Intacct admin user ID, Intacct admin user password, Intacct company ID, Intacct location ID, and a timestamp. The Intacct user must be a master admin account. If you'd prefer to have a dedicated API master account, contact your account manager. Every Intacct account is given one by default.

Once the session is created, Intacct will pass back your session ID, which you will then use to authenticate your next set of requests.

Sandbox Intacct Company

Once you signup for Intacct, you will be given a sandbox company for testing. This allows you to test your integration without fear of deleting or modifying anything in your live company. Keep in mind your sender ID and password will be the same for sandbox and production, but the Intacct Admin User will not.

Sage Intacct: Things to Keep In Mind

There are a couple of important items to remember when working with the Sage Intacct API. Here are a few points to look out for when integrating your FileMaker solution with Sage Intacct:

  • Although you can authenticate with each API call instead of creating a session, it is not recommended.
  • Make sure to download the Postman collection for reference.
  • Some API requests are labeled as legacy in the documentation; however, all are still supported.
  • Be mindful of password changes on the main account; too many failed API authentications will cause the account to be locked for security purposes.
  • If you'd like a dedicated API user, reach out to your Intacct account manager.


Double data entry can be a thing of the past by integrating Sage Intacct with your FileMaker solution! FileMaker can create, update, query, or delete just about any Intacct object you would like. Automate your accounting processes, eliminate double data entry, and avoid human blunders. Please contact us if you need further assistance or would like to discuss getting your Sage Intacct system integrated with FileMaker.

Did you know we are an authorized reseller for FileMaker Licensing?
Contact us to discuss upgrading your FileMaker software.

Download the FileMaker Intacct Integration File
Please complete the form below to download your FREE FileMaker file.
FileMaker Experience *
Terms of Use *
OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This file is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free file, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime.
Kiyan Allaei thumbnail
Kiyan Allaei

Kiyan is an outgoing and energetic certified FileMaker developer whose technical passion is the world of databases. His collaborative and positive attitude creates a natural draw for clients seeking solutions to meet their database needs.

FileMaker 18 Certified Developer
FileMaker 17 Certified Developer
FileMaker 16 Certified Developer
FileMaker 15 Certified Developer
FileMaker 14 Certified Developer
FileMaker 13 Certified Developer
FileMaker 12 Certified Developer
FileMaker 11 Certified Developer
"We were actually able to add more features than we thought would be possible within our budget. We always experienced a ‘can do’ attitude and DB Services was incredibly patient and easy to work with."
Courtney Hartman
Art Director
"The new FileMaker custom website interface is very user-friendly and easy to follow for our clients. In addition, it is much faster than the old Instant Web Publishing (IWP) interface. Thank you and all the others who have helped us out at DB Services. I am very grateful for the excellent service you provide us. Its nice to know we can call you for help if we have an issue."
Wayne Capek
"We needed a solution that would simplify the administration of our responsibilities under our contract with the State of Indiana. We have seen a dramatic increase across the state in the number of potential foster and adoptive parents that have begun the preparation and training process. This increase has resulted in a significant opportunity for children available for adoption. That’s a big win for everyone! And it’s all because we can refer potential parents to the proper state contacts efficiently and quickly."
Chris Morrison
Executive Director
"Thank you for all of your expertise and valuable help. I am so grateful to have found DB Services."
Linda Findlay
"Thank you for our new database system. We transitioned from a carbon copy paper based system to a digital database. The software has saved us time and money. We used to archive all our jobs in cabinets, now we can look up a job in seconds from anywhere. The software allows us to easily email estimates to our customers in pdf format. In a year there was a return on investment just from eliminating the purchasing of our carbon forms."
Todd Cartmel
"The new system allows us to create and track jobs for customers along with inventory, something we had been doing with separate word and spreadsheet files. Because it’s now so intuitive, new staff members are able to begin using the database immediately without our usual training session and ‘cheat sheets’ for getting around within the file."
Tom Andrews