Sage Intacct: Accounts Payable Automation

Keywords: Expenses, Vendor, Account Payable, Sage

Credit: Sage Photo By: FP

Struggling to Keep Your Books in Order? ๐Ÿ“Š๐Ÿ“…

Let us handle the numbers while you focus on growing your business! Get expert bookkeeping support tailored to your needs.

๐Ÿ‘‰ Click Here for a Free Consultation!

To get started using Accounts Payable, you are required to subscribe and configure the module for your company. This involves selecting the features you want to appear in the AP menus and pages, as well as assigning permissions to those who need to access those features. For step-by-step instructions on how to configure AP for your company, go to Configuring Accounts Payable.

With Accounts Payable, you can;

  • Set up Accounts Payable to emulate your payment process.
    Optional payment and bill approval cycles include different levels of authorization for approvers. For example, checks less than $500 may not need approval, but ones over $5,000 may need additional approval by staff authorized for that amount. You can require two check signatures that can be signed or digital, where the second is required at a preset amount. You can add digital files or attachments to transactions, providing permanent and secure access to underlying documentation.
  • Pay vendors in numerous ways.
    Payment types include full or partial payments against bills, recurring and future payments, and advances. Payment methods include printed checks, online check delivery, cash, credit cards, manual payments, and funds transfer (EFT). You can apply over payments and other amounts that vendors owe you to the next bill you pay.
  • Categorize vendors into different types. This helps you run reports and other processes on an entire class of vendors.
  • Create custom terms.
    In addition to the default Accounts Payable terms and aging periods, you can create custom terms as you need them.
  • Close Accounts Payable periods

Close periods while keeping the General Ledger open; Financial data is retained indefinitely.

  • Easily adjust accounts with debit or credit memos.
  • Create and print reports.
    To aid in cash management, the application generates a wide variety of easily customizable aging and payables reports and graphs.

The Accounts Payable application is fully integrated with other Sage Intacct accounting applications for real-time posting. And, you can seamlessly integrate your external applications with our XML gateway.

The Purchasing application synchronizes with Accounts Payable to provide purchasing staff with procurement tools such as RFQs, and POs, with PO application transactions posting automatically to both Accounts Payable and the General Ledger.

The Accounts Payable application comes with many standard reports that you can run immediately.

AP Automation In Sage Intacct

AP Automation streamlines bill entry by automatically creating draft bills from bill documents that you email or upload. Sage Intacct automatically identifies the vendor and fills in the bill details for you, attaching the source bill document for reference.

How AP Automation works

The automated billing process is triggered by the following events:

  • You upload bills within Intacct, using the Upload button on the Bills list.
  • You forward bills to the email address provided.
    Intacct assigns a unique email address to use for bill automation to each entity in your company and the top level.

For each bill document you submit, the system creates a corresponding Sage Intacct bill in draft state and attaches the original bill document.

Using artificial intelligence and machine learning (AI/ML), Intacct fills in bill details, automatically matching vendor information and including:

  • Data captured from the uploaded or emailed bill, such as the bill number, date, line items, and amounts
  • Details from the vendor record
  • GL account and dimension coding, based on your previous coding patterns
  • Additional machine learning insights learned from your corrections

When the analysis is complete, AP Automation saves the bill as a draft, ready for you to review and then submit or post.

Reviewing and posting incoming bills

Draft bills created using AP Automation appear in the Bills list. When you first load the Bills page, it shows new incoming automated bills. At any time after loading the page, you can select Refresh to see newly arrived bills and updated bill states.

To make reviewing and posting of automated bills easier, use the Draft bills standard view. This view shows all bills with a state of Draft or Analyzing.

As you review the drafts, you might find bills that need more information before you can submit or post them. This is especially true when you first begin processing automated bills, when AI/ML does not yet know your preferences. When you post a bill after a field that AI/ML populated based on a prediction, that information is fed back to the AI/ML system and is used to improve future predictions.

Handling import issues

From the Bills list, you can see whether any of the automated draft bills triggered import exceptions. Standard views such as All and Draft bills include columns with information specific to AP automation.

  • Source: Shows the service used to receive the bill, either Bill upload or Email
  • Import exceptions: Alerts you to issues that need your attention

Import exceptions can be as follows:

  • Resolve: You need to take action to complete the bill. For example, if Intacct cannot match the vendor with enough confidence, you need to select the correct vendor. If a problem with the bill document prevents data extraction, you need to edit the bill details or resubmit the bill.
  • Duplicate: Intacct detected that this bill is already in the system. To avoid double billing, the system alerts you to the duplicate.

To get details about an exception, hover over the exception in the Import exceptions column. Or, you can view or edit the bill to see details.

For drafts flagged as duplicates, you can view the original bill when you view or edit the duplicate, as long as you did not delete the original. Incoming bills are compared to bills that you previously submitted using AP Automation.

After you edit a bill and either save it as a draft, submit it, or post it, Intacct removes the exception flag.

Tax handling in AP Automation

For companies that use the Tax application, AI/ML populates tax information on a draft bill when the predicted location has an assigned Tax solution. For these bills, the system automatically selects Transaction has tax implications and populates the remaining tax fields as described here.

Inclusive taxes

Inclusive taxes are set based on the previous bill for this vendor. If the last bill used inclusive taxes, this field is selected. Otherwise, it is left unselected.

Entries

AI/ML populates tax information based on your settings for how AP Automation should generate the bill.

For bills generated with all line items and associated amounts, Transaction tax is not populated for any of the lines in the following circumstances:

  • A non-standard tax rate is used
    For example, custom tax rates and negative tax rates are non-standard.
  • Multiple tax rates are applied in the same bill
    For example, the vendor document shows different tax rates applied to lines, or it shows multiple tax rates applied to a single line.
  • Tax rates are not applied uniformly to all lines
    For example, a single tax rate of 20% is used, but it is only applied to some of the line items.

Reviewing tax information before posting. Edit the draft before posting to add Tax detail, which is not predicted, and make any necessary corrections.

Submit bills by email using AP Automation

AP Automation creates draft bills from vendor documents that you email to your Sage-provisioned email address.

You can forward bills in any of the following ways:

  • Forward vendor emails that include bills as attachments.
  • Send a single email with multiple bills attached.

Each email attachment generates a draft bill. If you are forwarding a vendor email that includes supporting attachments, such as receipts, remove the attachments first. Otherwise, Intacct generates a draft bill for each receipt. Also, if the vendor includes additional information in the body of the email message, make a note of this, as it is not included in the draft bill.

Find your Sage-provisioned email address

When AP Automation is enabled, Sage email addresses are set up for you to use when submitting bills by email. You are assigned a unique email address for the top level, plus one for each entity. These addresses are not editable.

Requirements

  • Go to Accounts Payable > Setup > Configuration.
    If you have a multi-entity company, view Configuration from the top level to see Bill automation settings.
  • Under Bill automation settings, click Configure next to Email services.
    The Configure Email Services pop-up window opens, showing the list of entities, their default locations, and their provisioned mailboxes. Copy the email address from the Mailbox column for the entity you want to use.

Email a bill for automatic draft creation

Permissions and other requirements

  • Forward vendor emails containing bill attachments to the Sage-provisioned email address for the appropriate entity.
    You can forward bills one by one, or forward a single email with multiple bills attached.
    When addressing the email, include a single email address in the To: field and leave the CC: field empty. If you include more than one email address, Sage Intacct will not process the bill.
  • Valid email attachments
  • Intacct accepts documents that are:
  • PDF, JPG, JPEG, TIFF, or PNG files

AP Automation email addresses use the following format: When determining your email address, do not include spaces or underscores, even if they are present in your company ID.

Intacct might provision a different email address in one of the following circumstances;

If your company ID + entity ID matches an email address already in use

If you delete an entity and then recreate it using the same entity ID

In these cases, Intacct appends an underscore and an incremental number (beginning with 2) at the end of the username.

To view drafts created from the emailed bills, go to Accounts Payable > All > Bills in the entity where you emailed the bills.

If you already have the Bills list open, select Refresh to update the list. To filter the Bills list for drafts, select the Draft bills standard view.

Unlike uploaded bills, which appear in the list while Intacct is analyzing the content, emailed bills show up after analysis is complete. If you do not see your bills, you might need to allow a little time for Intacct to finish processing.

About columns in the Bills list that are specific to AP automation

In standard views, the following columns provide more information about automatically generated bills:

Source: Shows whether the bill was created from an upload (through the Bills list) or email. If this field is empty, the bill was either entered directly into Intacct, imported using CSV, or imported using an API.

Import exceptions: Alerts you to any issues with the draft. Hover over this field for more information.

Recipient email: Shows the Sage-provisioned email address where the bill was sent.

Sender email: Shows the email address of the sender.

Configure how much detail to include in emailed bills

By default, Intacct summarizes the bill total on a single line when creating draft bills from emailed transactions. You can change the default if you want Sage Intacct to create bills with multiple line items that match the original vendor document.

Requirements

Go to Accounts Payable > Setup > Configuration.
If you have a multi-entity company, view Configuration from the top level to see Bill automation settings.

  • Under Bill automation settings, click Configure next to email services.
    The Configure email services pop-up window opens, showing the mailbox configuration and the rules you want Intacct to use when creating draft bills from emailed transactions.
  • For Generate each bill with, select the method you want Intacct to use.

A single line that summarizes the total: If the bill document contains multiple line items, Intacct creates a single line item in the draft bill. This line item contains the total of all line items in the bill document. This is the default setting.

All line items and associated amounts: Intacct creates a line item in the draft bill to match each line item present in the bill document.

  • Select Save in the Configure email services pop-up window.
  • Select Save in Configure Accounts Payable.

Upload bills for automated processing

From the Bills list, you can upload scanned bills and vendor-provided bill documents to have AP Automation create draft bills for you. Upload bills in batches to save time.

Permissions and other requirements

  • In the entity where you want the bills to be created, go to Accounts Payable > All > Bills.
    You can upload bills at the entity level or the top level.
  • Select Upload.
    The Upload bills pop-up window opens.
  • Select the default Location to use if AI/ML cannot predict the location for a bill in this batch.
    Typically, AI/ML predicts the location for you. However, if you upload bills from a new vendor with no history, AI/ML uses the location you select here. After AI/ML learns your patterns, it predicts the location and ignores the Location selected during upload.
    Location is optional for single-entity companies.
  • Choose how you want line items generated for the bills.
    To create detailed bills, select All line items and associated amounts. To create summarized bills, select A Single line item that summarizes the total.
  • Drag and drop files on to the pop-up window to upload them or select Browse files to select them.
    You can save time by uploading up to 30 bills at once.
  • Intacct accepts documents that are:
  • PDF, JPG, JPEG, TIFF, or PNG files
  • Unencrypted
  • Up to 20 MB in size
  • Fewer than 200 pages in length
  • Intacct cannot process password-protected files.
  • Select Create bills when you are done adding files.
  • Select Refresh on the Bills list to show the status of the uploaded bills.
    Intacct creates a bill for each file upload, with the uploaded file attached.
  • How intacct shows bill states for uploaded and emailed bills
  • Analyzing: Intacct is still processing the document. You can view the attached bill document, but the bill details are not yet populated.
  • Draft: Processing is complete. You can view and edit the bill details. When ready, submit or post the bill.
  • The Analyzing state appears for uploaded bills that are being processed. Bills submitted by email appear in the Bills list when the draft is complete.
    To recheck the status of bills that were being analyzed, select Refresh again.
    If you do not see your bills, you might need to allow a little time for Intacct to finish processing. For bills that appear in the list but do not leave the Analyzing state for more than 2 hours, learn how to cancel processing.
  • About columns in the Bills list that are specific to AP automation
  • In standard views, the following columns provide more information about automatically generated bills:
  • Source: Shows whether the bill was created from an upload (through the Bills list) or email. If this field is empty, the bill was either entered directly into Intacct, imported using CSV, or imported using an API.
  • Import exceptions: Alerts you to any issues with the draft. Hover over this field for more information.
  • Recipient email: Shows the Sage-provisioned email address where the bill was sent.
  • Sender email: Shows the email address of the sender.

Review and post incoming bills from AP Automation

Use the Draft Bills standard view to review bills that Sage Intacct created from uploaded or emailed bills. From this view, you can:

  • See important exceptions that require your attention.
  • View the attached bill document directly from the list, using the
  • Attach
  • shortcut.
  • Select and view details for bills in draft state.
  • Enter tax details for transactions.

The Draft bills view also includes transactions with a state of Analyzing. These are uploaded bills that Intacct is processing. If you have a bill that has been stuck in the Analyzing state for over 2 hours you can use the Cancel link to stop analysis.

Permissions and other requirements

  • Go to Accounts Payable > All > Bills.
  • Select the down arrow beside the View menu, then select Draft Bills.
    The list updates to show all bills in a draft or analyzing state.
  • How Intacct shows bill states for uploaded and emailed bills
  • To update the list at any time, select Refresh. Bills that arrived after you opened the Bills list appear, and the state of bills that were previously Analyzing are updated.
  • Hover over any alerts that you see in the Import exceptions column to get more information.
    Import exceptions alerts you to issues found when the emailed or uploaded document was processed. For example, a duplicate bill or unreadable file.
    In cases where Intacct cannot capture some or all of the bill information, you can fill in the details yourself, using the attachment as a reference. If the attachment is unreadable, submit a new file or ask the vendor to resend the bill.
    The Import exceptions column appears in the Bills list for standard views. If you do not see the column, select the All or Draft Bills view. You can also add the column to a custom view.
    When you edit or view a draft that has an import exception, a more detailed exception message appears. The import exception clears once you save, post, or submit the transaction.
  • Types of import exceptions
  • To review and update a bill, select Edit on that row.
  • Review bill details and edit them as necessary.
  • For companies that use the Taxes application, review the tax information and add Tax details.
  • Review header-level tax information
  • Verify the following fields for header-level tax information:
  • Transaction has tax implications
  • Tax solution
  • Inclusive tax
  • Review line entry transaction tax and select tax details
  • Verify the Transaction tax amounts for each line.
  • Select the Tax details.
  • Select Post or Submit.
    The bill is updated and you are returned to the Bills list. Any corrections you made to AI populated fields are sent back to the machine learning system to improve future predictions.

View AP Automation transaction usage

View Subscription usage to see the last 3 months of automated transactions that are subject to billing.

From the Automated transactions tab on the Subscription usage page, you can do the following:

  • View the document that was used to create the automated transaction.
  • Drill down to view transaction details, provided you have the necessary permissions.

If a transaction was deleted after Sage Intacct created the draft, only the attachment is available to view.

View Subscription Usage

Requirements

  • Go to Company > Admin > Usage metrics > Subscription usage.
  • If you cannot see the Subscription usage option
  • Verify that you have Subscription usage: View permissions for Administration. If your company uses role-based permissions, this permission needs to be added to your assigned role.
    Only business users with admin privileges can view Subscription usage.
  • Select the Automated transactions tab, if it is not already selected.
    The Monthly summary shows the number of transactions that were processed each month, for the past 3 months. View a detailed list of these transactions in the Transaction history.
  • To filter the list based on the billing date, choose a starting and an ending date, then select Apply.
    As a filter shortcut, you can select a month name in the Monthly summary to view only transactions processed during that month.
  • Optionally, refine the data further at the column level.
  • To drill down to view the details of a transaction, select the Transaction number from the Transaction history.
    You need Bills: View permissions for Accounts Payable to view bill details.
  • To view information about a deleted bill:
  • Select the
  • Attach
  • Click the icon to open the Attachment popup.
  • Under Files in attachment, select the attachment link to open the file.
  • When done, close the file viewer and the Attachment popup.
  • If you want to export the current data selection for use in another application, select Export.
    Sage Intacct exports the data in CSV format.
  • Select Done.

Which AP Automation transactions are billable?

In general, all emailed or uploaded documents that result in AI/ML automation generating a draft transaction are subject to transaction usage fees. Exceptions are as follows.

  • Transactions that you cancel because they were stuck in the Analyzing state.
  • Transactions that generate an import exception of File cannot be read.

Field descriptions: Automated transaction subscription usage

Check out our Free Additional Articles