Create your first Velixo report for Sage Intacct
Created by Damien Zwillinger, Modified on Mon, 8 Apr at 6:35 PM by Harry Lewis
Applies to:
- Velixo NX
- Sage Intacct
Pre-requisites:
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:
Add a connection
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. |
Your first formula
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.
|
Get the balance of an account
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. |
Ranges and wildcards - Combine multiple accounts and locations
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:
|
Filter balances by dimensions
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.
This is essentially the output of the SI.DIMENSIONS function, which is the preferred method for filtering by dimensions, and you may also want to directly reference cells of your workbook. The formula would then look like this:
|
A complete example
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:
Download this sample file
💡 Having trouble downloading the file?
Simply right-click the link and select Save link as
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article