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:
- The Intacct module enabled
- The global permission Accounting System Interface set to Update
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.
| Field | Description |
|---|---|
| Username | Your Intacct username |
| Password | Your Intacct password |
| Company ID | Your Intacct company id. To find your company id:
|
| 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.
| Field | Description |
|---|---|
| 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.
| Field | Description |
|---|---|
| Browse | Set new location to save log file |
| View Log | Open the log in default text editor |
| Send to Support | Upload the log to Projector's server for analysis. Let the support team you sent the log file in. |