Journal Writeback (Sage Intacct)

Created by Harry Lewis, Modified on Mon, 20 Nov 2023 at 04:46 PM by Harry Lewis

Applies to:

  • Velixo NX
  • Sage Intacct


Use the Journal Writeback feature to create allocations, accruals, and many other types of GL entries such as:

  • Month-end allocations of revenue and expenses

  • Accrual transactions

  • Release of restricted funds

  • Fringe calculations

  • Inter-entity and multi-currency transactions

  • Calculations, or GL entries that depend on data that is not available in your ERP

Create a Journal Transaction Worksheet

On the Velixo NX ribbon, click the New Sheet button and select Journal Transaction:


The Velixo NX side panel will be displayed to ask you to confirm the connection to use.  Select the connection to which you wish to send data and then click Insert:

Then, a Journal Tranaction Writeback worksheet will be created:

Note: Certain fields will be pre-filled with default values.  These can be changed, and you will need to fill in any other desired fields.

For each row in the table, enter data that is necessary for your journal entry: 


Perform Writeback

To send your transaction data to your ERP, click on Perform Writeback on the Velixo NX ribbon:

Then select one of the two options, based on your specific worksheet:

  • Current Worksheet: run all Writeback functions on the current worksheet,
  • Selected Cells: only run the Writeback function in the selected cell.

Applies to:

  • Velixo Classic
  • Velixo NX
  • Sage Intacct
  • ERP: Acumatica, CEGID, Haufe x360, JAMIS Prime, MYOB Advanced

The {FUNCTIONNAME} returns ......


Important: ...



{FUNCTIONNAME}(Connection, ...)


The {FUNCTIONNAME}  function uses the following parameters:






The name of the connection as configured in the Connection Manager


* see Filtering Techniques for Velixo Functions


Example 1

{FUNCTIONNAME(Connection, ...)


Returns .....




(cell references have been used for some parameters in this example)

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article