Create your first Velixo report for Sage Intacct

Applies to:

• Velixo NX
• Sage Intacct

Pre-requisites:

• Sage Intacct configuration prerequisites
• Installing Velixo NX
• Configuring Velixo NX for Sage Intacct
  
  

Table of contents:

• Overview
• Add a connection
• Your first formula
• Get the balance of an account
• Ranges and wildcards - Combine multiple accounts and locations
• Filter balances by dimensions
• A complete example

Overview

The first step after you open Excel is to connect your spreadsheet to your ERP. The add-in adds a new ribbon tab to Excel, titled Velixo NX:

Click the Connection Manager button on Velixo ribbon to open Connections tab in the task pane. Then click Add Connection. 

As you may have guessed by looking at the screen, it is possible to connect to multiple companies and multiple ERP websites from a single spreadsheet. That allows you to easily consolidate data coming from multiple sources. Learn more in Sage Intacct integration guide

To set up connection for Sage Intacct Report, select Sage Intacct from Type drop-down menu. Enter a unique Name for the connection, since you will use this name later as you build formulas. Company ID, User ID and Password are also required parameters.

Remember credentials: If you check this box to save your credentials for the connection, it's important to realize that it is not actually saved within the spreadsheet. Rather, it is saved to your Velixo user profile, which resides in your local Microsoft office installation and is encrypted at rest.

Let's begin with something very simple — retrieving the name of an account. In the A1 cell, we will put an account code, in this case 60100.

In the B1 cell, we will use the SI.ACCOUNTNAME function. As you start typing, notice that the add-in provides you with information about the function and its parameters:

The first parameter for the SI.ACCOUNTNAME function is the name of the connection as it was defined in the Connection Manager - "Demo”.

The second parameter that is required by this function is the account code. In our example, the account code is in cell A1. Click on the cell and Excel automatically adds a reference to that cell in the formula.

The complete formula should look like this: =SI.ACCOUNTNAME("Demo",A1)

Press the Enter key. 

Next, try to change the account code in the A1 cell, and then press enter to see an immediate update to the value of the account name cell.

All Velixo functions work in the same way.

Let’s continue to build our worksheet and do something more useful. We’re going to get the closing balance of the Cash account (account code 10100), using the SI.CLOSINGBALANCE function.

The SI.CLOSINGBALANCE function expects a few different parameters:

Press Enter to complete the formula. The closing balance will calculate automatically.

Since this the first time you’re calculating a value for this connection, reporting book and financial year, Velixo will connect to your ERP to retrieve the necessary data.

In the previous example, you saw how to get the balance of a single account. Now, what if you want to get the total for multiple accounts? Yes, you can use the + operator to add the values, but this could result in a messy formula and sluggish calculations. There's a better way — with ranges and wildcards.

Here are some examples of what’s possible:

For complex reports you might want to filter balances additionally. For doing that you can use either predefined or custom dimensions.

In our next example we are going to filter balances by predefined dimensions — Customer and Department. 

You can also specify dimensions as a cell reference:

By building on the formulas, tools, tips and tricks you've learned here, you should be able to build a full Trial Balance, balance sheet, or P&L using the Velixo add-in.

Example workbooks: allow us to suggest that you download and explore a sample workbook and connect it to your own ERP.

Here’s a view of the Profit and Loss example:

Download our Wiser Services Demo Sample.xlsx example file: