Intacct

Projector is capable of sending accounting data to Intacct. This data is broken up into three categories - AR, AP, and GL. When these transactions are sent, they only contain high level information such as Invoice Amount, Payment Voucher Amount, and General Ledger amounts. The details of those transactions are stored in Projector which operates as your accounting subledger.

The pre-built connector allows you to:

  • Send accounting transactions to Intacct electronically exactly once, avoiding the drudgery and potential errors of rekeying
  • Create summary invoices and bills in Intacct so you can continue to manage aging, cash application, and cash disbursement there
  • Extend the functionality of Intacct by managing the complexities of multi-currency accounting, intercompany transactions, and project-level details in Projector
  • Integrate Projector into your month-end closing processes by providing users with full control over accounting periods in Projector
  • Reconcile the two applications quickly using Projector's pre-built reports and cross-reference numbers
  • Distribute job-related responsibilities to project managers and other staff without having to grant them access to Intacct

The Intacct integration screen is reached by going to Integration tab | Intacct subsection | Synchronize Accounting blue dot.

Permissions and Settings

To use the Intacct syncronization you will need to have:

Configure Your Projector Installation

Before you try and send accounting data over to Intacct, you'll need to map all the accounting fields in Projector to your accounting fields in Intacct. This process requires knowledge of Projector, Intacct, and accounting. Because it is rare to have someone who is an expert in all three, Projector recommends using one of our accounting consultants to implement and train you on the configuration. It has long been our experience that a well implemented accounting integration with proper training up front is one of the most efficient long-term decisions you can make.

For a high level introduction to all the places in Projector where accounting fields are mapped, see the Account Mappings help page. That page links to other help pages which provide targeted help on specific accounting areas. For example, where do I go in Projector to map my expense types?

Configure Intacct

Your Intacct configuration is outside the scope of this help document. You can work with one of our billable consultants to get Intacct configured to work with Projector.

Create Transactions

Projector supports three types of transactions that we send to Intacct. Accounts Receivable (AR) transactions, Accounts Payable (AP) transactions, and General Ledger (GL) transactions. 

  • AR - Issue or void an invoice to create an AR transaction
  • AP - Approve or unapprove a Payment Voucher to create an AP transaction
  • GL - many actions can trigger GL transactions. Time approval, expense approval, invoice issue, etc. Once there are any qualifying actions, you must create a GL batch to send over to Intacct. 

Review your pending, sent, and failed transactions by going to your Integration tab | Accounting System Integration subtab.


Synchronize to Intacct

Once you have generated some transactions in Projector, you'll manually sync them over to Intacct. To see the transactions that will be sent over, visit the AR Transactions, AP Transactions, and GL Transactions area of Projector. Query for Pending transactions. These are what will be sent to Intacct.

Credentials

Start by setting your Intacct credentials. You may want to create a Web Services user in Intacct for this purpose. In this way you can differentiate data that was pushed in from Projector verse data that was pushed in by a typical user.

FieldDescription
UsernameYour Intacct username
PasswordYour Intacct password
Company ID

Your Intacct company id. To find your company id:

  1. Hover over Company and then click Company Info 
  2. The Company ID will be found in the ID field
Location ID

Optional. Used with multi-entity instances of Intacct.

Use the locationid when logging into a shared child company. Leave Client ID blank.

Client ID

Optional. Used with multi-entity instances of Intacct.

Use the clientid when logging into a distributed child company. Leave Location ID blank.


Synchronize Settings

With these three fields you determine what set of information you would like Projector to send to Intacct.

FieldDescription
Send Projector transactions to Intacct through the following accounting period:All transactions in Pending status up to and including this accounting period are sent to Intacct.
Send transactions only for the following company:Send transactions for a single company at a time.
Choose which transactions to send:You can send all pending GL, AP, and AR transactions or any combo of the three.


Log File

Occasionally Projector will request your Intacct log file. It contains detailed information about the data sent to Intacct and the response from Intacct. It is useful for troubleshooting sync issues. This file is unique to the computer which syncs to Intacct. If you are asked to send the file to support, please send it from the computer experiencing issues.

FieldDescription
BrowseSet new location to save log file
View LogOpen the log in default text editor
Send to SupportUpload the log to Projector's server for analysis. Let the support team you sent the log file in.