How to Prepare AR Invoices for Sage Intacct CSV Import
By The Rekeyless team · Updated June 2026
In short: To prepare AR invoices for a Sage Intacct CSV import, you map your source data to Intacct's AR invoice import template: match customer names to Intacct customer IDs, group source rows into invoices, format dates correctly, populate required dimensions, calculate line values and check for duplicates before importing.
Start from your source data
AR invoices usually begin as a sales export, billing spreadsheet or job/usage file. The first task is to understand which columns map to which Sage Intacct fields, and which values need translating (for example, a customer name into an Intacct customer ID).
Customer IDs
Sage Intacct expects the customer ID, not the display name. Maintain a mapping between the names in your source file and the IDs in Intacct, and flag any customer that has no match rather than guessing.
Invoice grouping
One invoice often spans several source rows. Decide the grouping rule — for example, one invoice per customer per period — and make it consistent every time.
Required fields, dates and dimensions
- Invoice date and due date in the format Intacct expects
- Location, department, project and any other required dimensions
- GL account or item references
- Line descriptions and amounts
Duplicate checking and validation
Before importing, check for duplicate invoice references, blank required fields and unmapped dimensions. Catching these first avoids a rejected import and a frustrating round of corrections.
Common reasons AR imports are rejected
- Missing or unmapped customer IDs
- Invalid or inconsistent date formats
- Dimensions that do not exist in your configuration
- Header and line grouping that does not match the template
- A template that has changed since it was last used
Worth knowing: Always test with representative sample data that includes exceptions — not just one or two perfect rows — before relying on a process for recurring use.
For official field definitions and template details, always refer to the current Sage Intacct documentation.
Prefer we handled this for you?
See our turn your sales data into sage intacct ar invoices service, or request a free process review.