This process outlines how to import customer billing (Accounts Receivable invoices) from Usked into Sage Intacct using the standard import template.

Prerequisites & Important Notes

• Customers must already exist in Sage Intacct (Customer ID must match exactly)

• Required fields (e.g., Customer ID, invoice date, amount) must be completed

• File must be in CSV format

• Do not modify template column headers (Row 1)

• Clean and validate data before importing

• Use offline processing for large files to avoid timeouts

  ---

Step 1: Download the Invoice Import Template

1. Log into Sage Intacct:  https://www.intacct.com/ia/acct/login.phtml

2. Navigate to:
   Company → Setup → Import Data

3. Scroll to Accounts Receivable invoice

4. Click the Template link (blue text) to download

Step 2: Key Setup Requirements

Before importing, make sure:

• Customers already exist in Intacct (Customer ID must match exactly)

• Items (if using item-based invoices) are created

• GL accounts are valid and active

• Locations / Departments (if used) are set up

• Clean up your import sheet by deleting the not required columns (unless needed) 

Step 3: FAQs

File Format:

• Files must be in CSV (Comma Separated Value) format

Where to find the template?

• Accounts Receivable → All → AR Sales Invoices → Import

• OR Company → Setup → Configuration → Import Data → Accounts Receivable → Template link

Import Types:

• Historical: Does NOT impact the General Ledger (used for historical data migration)

• General Ledger: Posts transactions to the GL

Required Fields (typical):

• Customer ID

• Invoice Date

• Transaction Amount

• Item ID or GL Account

• Accounts Receivable Account

Large Imports Tip:

• Use the Process Offline option to allow background processing

• You will receive an email notification when complete

Step 4: Review Usked Customer Billing Data

1. Log into Usked

2. Navigate to:

• Billing → Reports → Customer Billing → QuickBooks Invoice Export

3. Use filters and date range to match your billing period

4. Click Search

5. Click Download CSV File

6. Open and review the file for accuracy

Step 5: Prepare the Import File

1. Copy and paste data from the Usked CSV into the Sage Intacct AR import template

2. Ensure all required fields are completed

3. Verify formatting (dates, amounts, IDs)

Step 6: Import Customer Invoices into Sage Intacct

1. Navigate to:

• Company → Setup → Configuration → Import Data

2. Scroll to Accounts Receivable

3. Click the Import link

4. Click Choose File and select your CSV file

5. Select the correct Date Format

6. Choose import type:

• General Ledger OR Historical

7. Enter email address for notification

8. Click the Import button

9. On the next screen, click Done

You will receive an email confirming the import status.

Step 7: Review Imported Invoices

1. Navigate to:

• Accounts Receivable → AR Sales Invoices

2. Locate imported invoices

3. Click Edit next to an invoice to review and edit the details

FAQS

1. What should I check before importing invoices?

Ensure all required fields are complete and accurate, including Customer ID, invoice date, and amounts. Validate formatting and confirm customers already exist in Intacct.

2. What file format is required for import?

All import files must be in CSV (Comma Separated Value) format.

3. What is the best practice for large imports?

Use Process Offline for large files to allow background processing and avoid system delays. You will receive an email notification once the import is comp