> For the complete documentation index, see [llms.txt](https://docs.greytrix.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.greytrix.com/gumu-tm-for-sage-intacct-integration/ftp-sftp/process.md).

# 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="/files/dnfHgJtLCZpYPtd8jmLw" alt=""><figcaption></figcaption></figure>

<div align="center"><img src="/files/-MLX8-B4AziFOaRNGua-" 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.

![](/files/-MLXAdT8zJ-dAAeN8I1P)

| **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;