# 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™
| **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 (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 = 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 |
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.greytrix.com/gumu-sage-intacct-ftp-sftp-integration/process.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.