Intacct Enthusiasts

Order Entry Advanced Tax: Part 4

Taxable Ship To Contact As explained in Order Entry Basic Tax:  Part 2 in order for taxes to calculate in Order Entry the Ship To contact record must be set up as taxable.  This is separate from and in addition to the Customer Record being set as taxable. Without the Ship To contact being set as t

Order Entry Advanced Tax: Part 3

Contact Tax Groups As shown on the diagram presented in Order Entry Advanced Tax:  Part 1, Customers and Contacts are required to be grouped together in Contact Tax Groups.  If you have already setup advanced taxes in Accounts Receivable, this may already be set up for you.  If not, you will need

Order Entry Advanced Tax: Part 2

Enable Expanded Tax Detail & Set GL Offset Account During the basic tax setup Enable Subtotals was turned on in each of the transaction definitions for which you wish use taxes.  Now that we are configuring advanced taxes we will need to return to each transaction definition that contain tax am

Order Entry Advanced Tax: Part 1

Intacct’s built-in tax calculation functionality is not only a great time saving tool but it is also helpful in reducing input errors on transactions.  Understanding the mapping of various settings is an important step to setting up advanced taxes which the following overview should hopefully hel

Order Entry Basic Tax: Part 3

Sales Order Invoice Entry Now that you have the above three settings correctly configured it’s time to enter the Sales Order Invoice with tax lines.  In our instance Sales Order Invoices are entered in Order Entry > Activities > Transactions > Sales Invoice but the title for your sales i

Order Entry Basic Tax: Part 2

In order to have tax calculate on a Sales Order Invoice you will need to ensure the Invoice has the following three things: Taxable Customer Taxable Ship To Contact Taxable Inventory Item Taxable Customer If you haven’t already set the customer in question up as being taxable, you will need to do

Order Entry Basic Tax: Part 1

Enable Subtotals The first step to enabling basic tax in Order Entry is to turn on Enable Subtotals on each of the transaction definitions for which you wish use taxes.  This is done by selecting the appropriate transaction definition in the Order Entry > Setup > Transaction Definitions list

Sales Tax Reporting

The Sales Tax Report can be found in Accounts Receivable > Reports > Sales Tax Report.  This report is perfect for seeing how much you have collected in taxes over a customizable time period and for which tax authority they were collected.  There are multiple reporting period options availab

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