All Collections
System Integrations
Sage 200 and Sage Intacct
Sage Intacct integration - Invoices and transactions
Sage Intacct integration - Invoices and transactions
R
Written by Raymond Carrel
Updated over a week ago

Invoices

Please note: your configuration may require that you raise a Purchase Order for any products that you wish to invoice. This will apply only to product items, not services. This will depend on your settings.

Invoices in The Layer can sync to Intacct, along with details of each item line - item name, price, tax rate, discount and nominal code.

An invoice will automatically sync to Intacct when it is finalised, as long as there are no issues preventing this (e.g. invalid item details).

The "Intacct" tab will show on the invoice manager when integration is present.

You can see details regarding the sync, if it has occurred. It's also possible to manually sync here by clicking "Sync Now".

The references for any linked purchase orders are also shown.

Invoices Log

Settings - Sage/Intacct - Invoices

This area of settings shows a sortable list of invoices that have been raised. The "Reconciled" column indicates whether or not the sync was successful. Failed syncs can be re-attempted here. If failure occurs, again, you will be advised to check the Error Log for more details.

From an invoice, we can perform the following actions:

  • Raise a Payment

  • Raise a Credit

Both payments and credits can sync to Intacct.

Payment Sync: The Layer -> Intacct

Payments can sync in both directions. Payments from The Layer to Intacct are allocated to the correct invoice in Intacct automatically. Synced payments will show against an invoice record in Intacct, as below.

Payment Types and Intacct Bank Accounts

Different payment types in The Layer can be matched with different bank account codes in Intacct. This is managed from the Settings area under "Payment Methods".

The "Acc - Code" field is where the account code for the desired bank account will be entered. This ensures that any payments of a specific type will be processed against that account after sync. "Payment Account Name" is for your information only and has no other function.

If you do not wish for some payment types to sync, then you can leave the code field empty.

Payments will show as normal in The Layer - e.g. the customer's finance tab. You can also see details on an individual invoice's payments by clicking the "Payments" button on that invoice. This will also show you the sync status of each.

Payment Terms

Invoice Payment Terms in The Layer must be matched to equivalent entries in Intacct. This can be configured from Settings - Payment Terms:

"Finance Term Id" must be populated with the code for the relevant payment term, as seen in Intacct.

Payment Sync: Intacct -> The Layer

Payments made against an invoice in Intacct will automatically sync to The Layer. Please note that this can take a minute or so, due to the way the integration functions.

This example shows a payment that has synced from Intacct.

Payments Log & Failed Payment Sync

Settings - Sage/Intacct - Payments

This area of Settings shows you a log of payments that have been attempted from The Layer.

The "Reconciled" column informs you as to whether or not the payment sync was successful. You can retry payments that have failed using the "Sync Now" button. If these fail again, you will be advised to check the Error Queue, which is also accessible from Sage Settings.

Settings - Sage/Intacct - Intacct Payment Errors

This will show you any payments that have been sent from Intacct but have failed to sync to the invoice in The Layer.

Credit Notes

Similar to payments, credit notes raised in The Layer will sync automatically to Intacct. They are synced as Credit transactions against the invoice, and automatically allocated.

Credit Note Log & Failed Credit Sync

Settings - Sage/Intacct - Payments - Credit Notes

This area of Settings shows you a log of credit notes that have been attempted from The Layer.

The "Reconciled" column informs you as to whether or not the credit note sync was successful. You can retry transactions that have failed using the "Sync Now" button. If these fail again, you will be advised to check the Error Queue, which is also accessible from Sage Settings.

Refunds

Refunds from The Layer are not synced to Intacct. Refundable balances are attributed to a Layer credit note when the credit note has been raised against a payment.

Refunds must be actioned separately in each system. In The Layer, this is done from the Credit Note view:

Did this answer your question?