Process

Process

Synchronoss Files Import/Export file format.

Why this is needed? Data transfer between Sage Intacct and Synchronoss is achieved using csv file. The file format is fixed for the integration.

What are the file formats? Sage Intacct Account Payable Invoice/Adjustment import file format • Import file specification as supplied by Synchronoss/CallOne. • File will include both bills and adjustments. In addition, will create bills and adjustments in Sage Intacct Incoming file must be in CSV format. • File name must include text “bills”. For e.g. CObills10232020.csv is a valid file name. • Execute process/job manually instead of scheduling for testing purposes. Upload import files on ftp; directory – FTP Directory parameter as specified on SFTP/FTP connector. Execute the following process from GUMU™

Import File Format

Field	Description
Date Loaded	Format MM/DD/YYYY. Required for Paid Invoices.
Vendor Name	Enter Vendor name
Account Number	Enter Vendor Id from Sage Intacct
Invoice Number	Enter Invoice number
AP Posting Date	Format MM/DD/YYYY. Required for Paid Invoices.
Invoice Due Date	Format MM/DD/YYYY. Required for Paid Invoices.
GL Account	Account Label
Description	Enter Description
Amount	Enter amount
Account	Enter AP offset account from Intacct.

Sage Intacct Accounts Payable payment export files format • Export file in a format as supplied by Synchronoss/CallOne. • File will be CSV format. • Exported file name would be CLOAPFMMDDYYYY.csv • Execute process/job manually instead of scheduling for testing purposes. Upon execution export file will be uploaded to directory – FTP Export Folder parameter specified on Integration configuration. • To Check Exported file Go to SFTP Server > Open Export Data Folder > Select file by checking current Date and Time.

Field	Description
File Exported Date	Format MM/DD/YYYY. (10/28/2020)
Record ID ‘H’	Header Record
File Name	FILE NAME OF EXPORT FILE (CLOAPFMMDDYYYY.csv)
File Type	APF
File Version	1
AP Interface	M (Miscellaneous)
Record ID ‘C’	Detail Records
Vendor Number	Vendor ID
Invoice Number	Record ID
Receipt date	Format MM/DD/YYYY.
BANK	Account Number
Amount	Invoice Payment Amount
Check Amount	Check Amount
Date	Check Date
Feedback Status	P = Paid R = Rejected V = Void (for already-paid checks), W = Pending Payment
Feedback Description	Description field
Accounting Month	Format YYYYMM (EX: 201104 represents April, 2011)
Record ID ‘T’	Trailer Record .Total number of record sent in the file (including header and trailer records)
Total Number of Invoices	Detail Records ‘C’ (EX : 26 Detail record count from exported file)
Total Paid Amount	Total of Invoice Payment Amount fields for records with Record ID = C and Status = P minus amounts for Status = V