Intacct Enthusiasts

Advanced Tax Setup: Part 4

If you will recall, in the first three parts of the Advanced Sage Intacct AR Tax Configuration blog posts we completed all the necessary steps to have Intacct calculate tax automatically for us on our AR Invoices.  In Part 1 we created taxable account labels and grouped them together into AR Accoun

Advanced Tax Setup: Part 3

Make sure to check out the Advanced Intacct AR Tax Configuration Part 1 & Part 2 if you missed them over the last 2 weeks. Tax Details The Tax Details are where you will set up the tax percentage and link the tax detail to the Account Label you created previously.  In order to create a new Tax

Advanced Tax Setup: Part 2

Make sure to check out last week's post - which was part one of our 4 part series on Advanced AR Tax Configuration. Contact Tax Groups Just like how we created a group to link similar account labels together we must also create a group to link together similar Customers together based on their taxa

Advanced Tax Setup: Part 1

The Advanced Tax Configuration in Sage Intacct is built upon the settings configured in Basic Tax Setup.  Prior to proceeding please refer back to previous blog posts:  Account Receivable Labels and Basic Tax, Part 1 and Part 2. An important part of setting up advanced tax is understanding how the

Account Receivable Labels and Basic Tax, Part 2

Taxable Account Labels In order to charge tax on an account label you need walk through the Intacct Receivables Tax Configuration. The first step is to set an Account Label as taxable.  For example, if we are invoicing for Fed Ex charges and need to charge tax on those we will go into the account l

Account Receivable Labels and Basic Tax, Part 1

Last week we learned about Accounts Receivable account labels and how to turn them on.  Accounts Receivable account labels are similar to Accounts Payable account labels but they differ in the way that they relate to taxes.  In Accounts Receivables the account labels can be used for displaying tax

Accounts Receivable: Account Labels

Last week we discussed Accounts Payable account labels which are a way to assign meaningful names to GL accounts for the purpose of Accounts payable transactions.   There is also account label functionality in Accounts Receivable to support Efficient AR Data Entry, but it is completely separate fr

Accounts Payable Labels

Not only are account labels are a great way to give meaningful names to GL Accounts but they are also a great way to limit GL Account visibility.  With account labels you can map one label to a GL Account or multiple labels to the same GL Account and provide users with simplified data entry.  If y

Setting Intacct Schedules

The schedule information tab in your Intacct Solution can be found under Company > Company Information as shown below. The Schedules tab is used to define the work week and holiday schedules as it pertains to your business.  Without a subscription to Project Accounting, however, the schedules ar

Additional Security Measures to Keep Your Accounting Data Secure

In addition to the security measures outlined in the previous two posts, there are Additional Security Measures to Keep Your Accounting Data Secure that are worth looking at:  IP Address Filtering, Single Sign-On (SSO) and Two Step Verification.  These settings are all found under Company > Com

Intacct Security Settings: Passwords

Keeping Your Accounting Data Secure with password policies is an important piece in our high tech world. How often will you force your users to update their password?  How long will you require passwords to be?  How frequently will you allow users to re-use passwords?  With Intacct you can set

Sage Intacct Security Settings: Timout Options

Internet security is a hot topic in today’s world, and for good reason.  Keep Your Accounting Data Secure with Sage Intacct Timeout options and rest assured that your data will not be compromised.  The security settings for your Intacct Solution can be found under Company > Company Informatio

General Ledger Import Templates

On occasion it might become useful to import a series of Journal Entries from a spreadsheet.  In this case you would want to utilize the Journal Entry Import Template.  A journal entry import can be used to import data that already exists in spreadsheet form, perhaps an export from a separate soft

General Ledger Transaction Templates

General Ledger Transaction Templates are a great way to streamline data entry and reduce errors for frequently-used journal entries.  They provide a more simplified environment for non-accounting personnel to create journal entries with ease.  Users can enter transactions without having to underst

Automated GL Transactions with Recurring Journal Entries

Unlike Memorized Transactions, Recurring Journal Entries are set up to automatically post/reverse on a pre-set schedule.  Although amounts can be modified in Recurring Journal Entries they’re at their best when they’re used for amounts that don’t change very often. Recurring Journal Entries a

Intacct Memorized GL Transactions

Provide your users with Quick General Ledger Data Entry with Memorized Journal Entries. Memorized Journal Entries are useful when similar journal entries need to be created on a regular basis.  Because memorized journal entries are posted manually they are useful when you might be required to chan

Dimension Group Filters: Combining the AND and OR Operator

The occasion might arise where simply using an AND operator or an OR operator separately won’t do!  Sometimes your grouping needs are so advanced that you need to use both AND & OR operators in your filter statement.  With Intacct, this is possible using Dimension Group Filtering for Advanc

Dimension Group Filters: Using the OR Operator

Imagine that you would like to have a Customer Group which includes those customers who are assigned with the ‘Financial’ Type ID and those assigned with the ‘Media’ Type ID.   With Dimension Group Filtering for Advanced Financial Analysis this is easily attainable. Just as we did last week

Dimension Group Filters: Using the And Operator

This week will will talk about Dimension Group Filtering for Advanced Analysis.There are two different operators you can use with creating your dimension group filters, the And Operator and the Or Operator.  This week we will talk about the And Operator.  The And operator is used in cases where yo

Dimension Group Filtering

As described last week, one way to create a Dimension Groups is adding specific members to a given group.  Another, more flexible way to create Dimension Groups is by filtering based on field values.  The benefit of filtering by field values is that you can create new items for the specific Dimens

Using Dimension Groups in Intacct

Any of the dimensions available in Intacct can be grouped into categories.  This week's blog post focuses on using Dimension Groups for Simplified Financial Reporting. In our example we will be using the Location Dimension but remember this can be done for other dimensions too.  The benefit to Dim

Setting up Dimension Relationships

The first step to setting up your Dimension Relationships is to enable them in Platform Services.  Using our example detailed last week, we will turn on the Dimension Relationships for location by going into Platform Services > Objects > List. We will now locate Location on this list and clic

Intacct Dimension Relationships

Note:  In order to use Dimension Relationships you will need to subscribe to Platform Services. In order to increase accuracy and speed up data entry you may wish to set up Dimension Relationships.  Dimension Relationships are used to filter a dimension dropdown list relative to what dimension was

Enabling Intacct Dimensions

Intacct comes with the following nine Standard dimensions: Location Department Customer Vendor Employee Class Project Item Warehouse You can chose to use any number of the above dimensions to suit your business needs. Dimensions must be enabled on the GL before they can be enabled in other modules.

An Introduction to Dimensions

Intacct Dimensions are said to be useful in simplifying your Chart of Accounts, but how exactly is that accomplished?  In the past, account numbers incorporated a hierarchical structure in order to allow financial reports to be prepared for specific portions of the organization.  Account numbers w

Setup Your Balance Sheet in Minutes

Once you have created your custom account groups it’s time the make a report using them.  The easiest way to make a custom report is to copy an existing report that is similar, and simply change it.  The first step is to figure out which report you want to duplicate, in our case we’ll duplicat

Using Account Groups on Reports

Account Groups are used to group similar accounts together for ease of reporting and analysis.  They can be used on reports to show both summarized and detailed account information.  Rather than building reports with pre-set GL Accounts you can use account groups as a container for your accounts.

Account Groups vs Account Categories

Although we’re primarily talking about Account Groups in this series we thought it might be good to touch on Account Categories as well.  You may have seen Account Categories around and wondered what they are and what the difference is between them and Account Groups.  The simple answer is that

Advanced Summarized Reporting with Groups of Account Groups

We touched briefly on Groups of Account Groups last week but would like to go into more detail about them.  The hierarchy of account groups can be multiple levels on top of one another.  Last week we used the example of grouping the two groups, Fixed Assets and Current Assets, together in a group

Simplify Reporting with Intacct Account Groups

Intacct Account Groups are a great way to group similar data together for summary or analysis.  Account Groups can be made up of a single or multiple GL accounts, either defined as a range or individually selected.  One example of a useful Account Group would be for Fixed Assets.  By making a Fix