Sage Intacct: Notes and best practices
| Object | Sage Intacct to J.P. Morgan Digital Banking Cashflow360 | J.P. Morgan Digital Banking Cashflow360 to Sage Intacct | Known Limitations | |
|---|---|---|---|---|
| General | Close Books Date | Yes | No | - When syncing with Sage Intacct at the top level (configuration C or D), best practice is to manually set the Books Closed Date, as only the most recent close date from any entity will sync to J.P. Morgan Digital Banking Cashflow360, possibly preventing transactions from another entity from syncing, even if the period isn't closed for that particular entity. |
| Chart of Accounts | Yes | Yes | - Account labels not supported - 1099 information/flags don't sync between J.P. Morgan Digital Banking Cashflow360 and Sage Intacct. We recommend managing 1099 information in Sage Intacct directly - In Sage Intacct, once account numbers are assigned to a chart of account, they can't be changed, so this field is locked on accounts that sync with Sage Intacct, once saved - DO NOT merge bank type accounts, this will potentially void and reissue payments when synced back to Sage Intacct |
|
| Departments | Yes | Yes | - J.P. Morgan Digital Banking Cashflow360 uses default Sage Intacct terminology, changes to Sage Intacct terms for Department don't sync over to J.P. Morgan Digital Banking Cashflow360 (e.g. we always display as "Department" in J.P. Morgan Digital Banking Cashflow360) - Department Groups don't sync |
|
| Locations | Yes | Yes | NA | |
| Classes | Yes | Yes | NA | |
| Employees | Yes | Yes | NA | |
| Projects / Jobs | Yes | No | - Projects / jobs can't be created in J.P. Morgan Digital Banking Cashflow360 - Jobs are read-only in J.P. Morgan Digital Banking Cashflow360 |
|
| Currency | Yes | Yes | - Multi-currency isn't supported. J.P. Morgan Digital Banking Cashflow360 supports only one currency. By default it's set to USD, but that can be changed in Sync Preferences - Note: If the Sage Intacct account is a multi-currency account with multiple base currencies enabled, the transaction currency needs to be set to USD in J.P. Morgan Digital Banking Cashflow360 |
|
| Bank Account Balance | Yes | No | NA | |
| Payment Terms | No | No | Payment terms don't sync to/from Sage Intacct | |
| Attachments | No | No | J.P. Morgan Digital Banking Cashflow360 doesn't sync attachments to/from Sage Intacct. Use J.P. Morgan Digital Banking Cashflow360 to directly upload attachments. If attachments are needed in Sage Intacct, upload in Sage Intacct after each transaction has synced | |
| Approvals | No | No | J.P. Morgan Digital Banking Cashflow360 doesn't sync approvals to/from Sage Intacct. However, the ability to have ONLY Approved bills sync to Sage Intacct is available. | |
| Payables | Vendors | Yes | Yes | - Tax1099 works differently in J.P. Morgan Digital Banking Cashflow360 than Sage Intacct. See best practices below to set up 1099 in J.P. Morgan Digital Banking Cashflow360 with Sage Intacct. - J.P. Morgan Digital Banking Cashflow360 uses the Vendor Name for matching, so Name should be unique within J.P. Morgan Digital Banking Cashflow360 to avoid duplicates - The sync supports Sage Intacct Inactivates. The sync will inactivate the Vendor in J.P. Morgan Digital Banking Cashflow360. - The sync doesn't support Sage Intacct deletions. The sync won't delete the Vendor in J.P. Morgan Digital Banking Cashflow360. - If the Vendor / Customer Sequence Id preference is set to "Enter ID Manually" in J.P. Morgan Digital Banking Cashflow360, vendors created in J.P. Morgan Digital Banking Cashflow360 must have a valid Vendor ID in order to sync with Intacct |
| AP Funds Tranfer | No | Yes | Only one location per J.P. Morgan Digital Banking Cashflow360 account is supported for funds transfer | |
| Bills | Yes, fully unpaid bills only | Yes | - Partially and fully paid bills won't sync from Sage Intacct to J.P. Morgan Digital Banking Cashflow360 - When a bill with a voided payment is deleted in J.P. Morgan Digital Banking Cashflow360, the deletion can't sync to Sage Intacct - it must be manually reversed in Sage Intacct - The ability to have ONLY Approved bills sync to Sage Intacct is available - $0 bills will sync from J.P. Morgan Digital Banking Cashflow360 to Sage Intacct in the state "No Value" - Bills entered in J.P. Morgan Digital Banking Cashflow360 over $10 million dollars will sync into Sage Intacct as $0 bills in the state "No value" |
|
| Bill Payments | No | Yes | - Payments made in Sage Intacct don't sync to J.P. Morgan Digital Banking Cashflow360 - Partial payments: Payments can't be applied to specific bill line items - Voided payments: To void a payment and use a specific date, perform the void in Sage Intacct first then in J.P. Morgan Digital Banking Cashflow360 - The memo field for Offline Payments in J.P. Morgan Digital Banking Cashflow360 doesn't sync to Sage Intacct |
|
| Vendor Credits | Yes, fully unapplied vendor credits only | Yes | - Sage Intacct doesn't allow us to specify which vendor credit was uage Intacct to J.P. Morgan Digital Banking Cashflow360 - The ability to have ONLY Approved Vendor credits sync to Sage Intacct is available |
|
| Purchase Order | Yes, once PO's are converted to unpaid bills | NA | - Purchase orders can't be viewed in J.P. Morgan Digital Banking Cashflow360 - Create POs and Receivers in Sage Intacct and convert them to Bills and Vendors. Once converted, the bill and vendor will sync into J.P. Morgan Digital Banking Cashflow360 - PO Bills can go through approval workflow and get paid via J.P. Morgan Digital Banking Cashflow360 - The PO# must be in the "Reference Number" field of the bill/vendor credit in Sage Intacct. The Purchase Order number will then appear on bills and vendor credits that originated from POs in Sage Intacct - Bills created from PO's (and synced from Sage Intacct) shouldn't be edited in J.P. Morgan Digital Banking Cashflow360 otherwise sync errors will occur - Bills created from PO's (and synced from Sage Intacct) will duplicate in J.P. Morgan Digital Banking Cashflow360 if edited in Sage Intacct. If an edit is required in Sage Intacct, the bill should be deleted from J.P. Morgan Digital Banking Cashflow360 first, then the edit performed in Sage Intacct. The bill will be resynced with the next sync. |
|
| Receivables | Customers | Yes | Yes | - If creating two customers with the same name in Sage Intacct, only the first one will sync to J.P. Morgan Digital Banking Cashflow360; the second one will result in a sync error - J.P. Morgan Digital Banking Cashflow360 uses the Customer Name for matching, so Name should be unique within J.P. Morgan Digital Banking Cashflow360 to avoid duplicates |
| Invoices | Yes, fully unpaid invoices only | Yes | J.P. Morgan Digital Banking Cashflow360 supports sales tax as an invoice line item, associated with a sales tax GL account | |
| Advanced Sales Tax | NA | NA | Invoices can't be created in J.P. Morgan Digital Banking Cashflow360 if using advance sales- tax in Sage Intacct. Create invoices in Sage Intacct and the sync will bring them to J.P. Morgan Digital Banking Cashflow360 for approval and payment - Sales tax will only populate as a total on the invoice in Bill.com. You can enable Sales Tax, and check mark each line item that needs to be taxed. |
|
| Items | Yes | Yes | - The sync can't bring the Chart of Account and Price fields of Items from Sage Intacct into J.P. Morgan Digital Banking Cashflow360 or J.P. Morgan Digital Banking Cashflow360 to Sage Intacct. These fields aren't exposed in the Sage Intacct API. - Items will only sync if the Order Entry module is enabled in Sage Intacct, the Items dimension is enabled in J.P. Morgan Digital Banking Cashflow360, and the XML_Bill.com user has full permissions enabled for Order Entry Module. |
|
| AR Payments | No | Yes | - Payments made in Sage Intacct don't sync to J.P. Morgan Digital Banking Cashflow360 - Payments can't be applied to a specific invoice line item - Voided payments: Payments that have synced and then voided, will generate a sync error instructing the user to manually void in Sage Intacct. The ability to sync the void of a previously-synced AR payment isn't available in the Sage Intacct API. |
|
| Credit Memos | No | No | Credit memos don't sync and need to be manually applied in both Sage Intacct and J.P. Morgan Digital Banking Cashflow360 | |
| AR Funds Transfers | No | Yes | NA | |
| AR Payment Convenience Fee | No | Yes | NA | |
| Sales Orders | Yes, after SO's are converted to unpaid invoices | NA | - Sales orders can't be viewed in J.P. Morgan Digital Banking Cashflow360 - Invoices created from SO's (and synced from Sage Intacct) should not be edited in J.P. Morgan Digital Banking Cashflow360 otherwise sync errors will occur - Invoices created from SO's (and synced from Sage Intacct) will duplicate in J.P. Morgan Digital Banking Cashflow360 if edited in Sage Intacct. If an edit is required in Sage Intacct, the invoice should be deleted from J.P. Morgan Digital Banking Cashflow360 first, then the edit performed in Sage Intacct. The invoice will be resynced with the next sync. |
ACCOUNT SETUP View all
QuickBooks Desktop View all
Import / Export View all