# 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?**\
\&#xNAN;***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™

<figure><img src="https://794987320-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MCRVg-TYx3gVa2Tqtf_%2Fuploads%2FoMLfP0ZcH7Ifd3YDWpLN%2Fimage.png?alt=media&#x26;token=8d838728-30a4-4e01-9950-f461955291b7" alt=""><figcaption></figcaption></figure>

<div align="center"><img src="https://794987320-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MCRVg-TYx3gVa2Tqtf_%2F-MLQo0eYaf97DZThRjmz%2F-MLX8-B4AziFOaRNGua-%2Fimage.png?alt=media&#x26;token=5470c32b-a0c5-478d-8852-7ab576e4ed23" alt="Import File Format"></div>

| **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.\
&#x20; 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.

![](https://794987320-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MCRVg-TYx3gVa2Tqtf_%2F-MLQo0eYaf97DZThRjmz%2F-MLXAdT8zJ-dAAeN8I1P%2Fimage.png?alt=media\&token=0c1ccc5f-8998-471d-b8ac-ccba06438b1a)

| **Field**                    | **Description**                                                                                                   |
| ---------------------------- | ----------------------------------------------------------------------------------------------------------------- |
| **File Exported Date**       | Format MM/DD/YYYY.  (10/28/2020)                                                                                  |
| **Record ID ‘H’**            | Header Record                                                                                                     |
| **File Name**                | FILE NAME OF EXPORT FILE (CLOAPF**MMDDYYYY**.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>P = Paid</p><p>R = Rejected</p><p>V = Void (for already-paid checks), W = Pending Payment</p>                  |
| **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 |

&#x20;