Sage Intacct Sync Guide: Create a Clearing Account in Intacct

If you've set debits and credits to your bank account to show as consolidated for each day, then to simplify reconciliation, Cashflow360 makes use of two clearing accounts, the Cashflow360 Money Out Clearing Account (Accounts Payable) and the Cashflow360 Money In Clearing Account (Accounts Receivable). To properly integrate with Sage Intacct and Cashflow360, these will need to be created as checking accounts in Sage Intacct and mapped to a corresponding GL account.

Cashflow360 Money Out Clearing account

If using Accounts Payable in Cashflow360, create the Cashflow360 Money Out Clearing Account as a checking account in Sage Intacct and associate it with a corresponding GL Account.

NOTE: If multiple Cashflow360 accounts will be syncing to the same Sage Intacct environment, a separate Cashflow360 Money Out Clearing Account will need to be created for each entity. Best practice is to include the Entity ID in the Bank name (e.g. Cashflow360 Money Out Clearing - US).

  1. At the Root/Top Level in Sage Intacct, navigate to Cash Management > Checking Accounts > Add
    AP - Add account
  2. Under Financial institution, enter the following field values:
    • Account ID: Cashflow360 Clearing
    • Bank name: Cashflow360 Money Out Clearing
      Ap - Checking Account info
  3. Under Accounting information, select the GL account drop-down menu and select Add
    AP - Add new GL
  4. Enter the following field value:
    • Primary/Sub Account Number: Use any available GL account number
    • Title: Cashflow360 Money Out Clearing
    • Account Type: Balance Sheet Account
    • Normal Balance: Debit
    • Period End Closing Type: Non-Closing Account
    • Dimension settings: Do not select any dimension settings
      AP - New GL Info
  5. Select Save
  6. If using a multi-entity Sage Intacct environment, select the Entity/Location ID that corresponds to this bank account
    • With single-entity Sage Intacct environments, inter-entity (company) transfers are not required. Check the Disable inter-entity transfers box.
      AP - Entity ID on Checking account
  7. Select Save

Cashflow360 Money In Clearing account

If using Accounts Receivable in Cashflow360, create the Cashflow360 Money In Clearing Account as a checking account in Sage Intacct and associate it with a corresponding GL Account.

NOTE: If multiple Cashflow360 accounts will be syncing to the same Sage Intacct environment, a separate Cashflow360 Money In Clearing Account will need to be created for each entity. Best practice is to include the Entity ID in the Bank name (e.g. Cashflow360 Money In Clearing - US).

  1. At the Root/Top Level in Sage Intacct, navigate to Cash Management > Checking Accounts > Add
    AR - Add account
  2. Under Financial institution, enter the following field values:
    • Account ID: Cashflow360 Clearing
    • Bank name: Cashflow360 Money In Clearing
      AR - Checking Account info
  3. Under Accounting information, select the GL account drop-down menu and select Add
    AR - Add new GL
  4. Enter the following field values:
    • Primary/Sub Account Number: Use any available GL account number
    • Title: Cashflow360 Money In Clearing
    • Account Type: Balance Sheet Account
    • Normal Balance: Debit
    • Period End Closing Type: Non-Closing Account
    • Dimension settings: Do not select any dimension settings
      New GL Info
  5. Select Save
  6. If using a multi-entity Sage Intacct environment, select the Entity/Location ID that corresponds to this bank account
    • With single-entity Sage Intacct environments, inter-entity (company) transfers are not required. Check the Disable inter-entity transfers box.
      AR - Entity ID on Checking account
  7. Select Save