Sage Intacct Predefined Import Templates

This topic provides the list of templates that are imported when performing a data migration to Sage Intacct.

Available Sources

Sage 50 Canada Sage 200 UK Sage 300

Sage 500 Sage 1000 UK

Destination Modules in Sage Intacct

Module	Entity	Field Validation
Accounts Receivable	Customers	Customer ID, Customer Name, Contact Name, Print As
	AR Open Documents	Customer ID, Created Date, Due Date, Amount Total, Forex Date, Line Number, Account Number, Amount, REVREC Template, REVREC Journal, REVREC Schedule Line No, REVREC Revenue Account, REVREC Posting Date, REVREC Amount
	AR Adjustment	Customer ID, Created Date, Forex Rate Date, Line No, Account No, Amount
Accounts Payable	Vendors	Vendor ID, Vendor Name, Billing Type, Contact Name, Print As
	AP Open Bills	Vendor ID, Created Date, Due Date, Forex Rate Date, Amount
	AP Adjustment	Vendor ID, Created Date, Forex Rate Date, Line No, Account Number, Amount
General Ledger	Chart of Accounts	Account Number, Account Name, Account Type, Normal Balance, Close Into Account, Closing Type
	Departments	Department ID, Department Name
	Location	Location ID, Location Name, Contact Name, Print As
	GL Entries	Journal, Account Number, Line Number, Date, Description, Debit, Credit, Exchange Rate Date
Inventory Control	Product Lines	Product Line ID
	Inventory Items	Item ID, Item Name, Item Type, Cost Method, Term Period, Default Number of Periods, Vendor Line Number, Vendor ID, Warehouse Line Number, Warehouse ID, Warehouse Reorder Method, Kit Components Line Number, Kit Components No of Units
	Units of Measure	UOM Name, UOM Unit
	Warehouse	Warehouse ID, Warehouse Name, Contact Name, Print As
	Inventory Transactions	Transaction Type, Transaction Date, Document Number, Transaction Status, Line ID, Item ID, Warehouse ID, Quantity, Unit of Price, Subtotal Line Number, Link to existing transactions to adjust