Excel Connector Recepción de Pagos (Payment´s receipt) Complement
This connector is an Excel file where you must specify the payment information you need to upload to the system. It is divided into 6 Excel sheets in which the data for each payment is separated.
Download here
Connector´s use
See lesson ID-107.4 -- Create a CFDI with payment complement using an Excel connector, to see how to upload the connector to the system.
Sheets: (avoid renaming sheets)
This sheet should contain general data for the receipt, such as the recipient of the payment, notes, different payments to the same recipient, etc.
(R)equired or (C)onditional data:
| R | RFC Receptor | Business name of the receiver. Example: PÚBLICO EN GENERAL |
| R | Nombre Receptor | Receiver RFC. Example: XAXX010101000 |
| C | Num. Operacion | Check number, authorization number, reference number, tracking number in the case of SPEI, capture line or some similar reference number that identifies the operation that covers the payment made. Required when payment is made by SPEI. |
| R | Fecha Pago | Date and time when the beneficiary receives the payment. It is expressed in the form dd-MM-yyyyThh:mm:ss |
| R | Forma Pago | Method of payment (Cash, Check, etc.). This field consists of multiple selection where you can select the payment method according to those defined in the "Catalogs" sheet. |
| R | Moneda | Key of the currency used to make the payment. This field consists of multiple selection where you can select the payment method according to those defined in the sheet "Catalogs". |
| C | Tipo Cambio | Currency exchange rate on the date the payment was made. The value must reflect the number of Mexican pesos equivalent to one unit of the currency indicated in the Moneda attribute. It is required when the Currency attribute is different from MXN.. |
| R | Monto | Payment amount. |
This sheet must contain the payment details if the payment was made by bank transfer, filling it out with information from the recipient's and the sender's banks.
(R)equired or (C)onditional Data:
| C | Num. Operación | Check number, authorization number, reference number, tracking code in the case of SPEI, capture line or some similar reference number that identifies the operation that covers the payment made. Required when payment is made by SPEI. |
| C | Nombre banco cuenta ordenante | State the name of the ordering bank, which is required if it is a foreign bank. |
This sheet should contain general data on related documents (those that are paid for the amounts recorded in this payment voucher), such as folio and series, currency data for each related document, etc.
(R)equired or (C)onditional Data:
| C | Num. Operación | This value may be repeated. Check number, authorization number, reference number, tracking code in the case of SPEI, capture line or some similar reference number that identifies the operation that covers the payment made. Required when payment is made by SPEI. |
| R | Moneda | The currency key used in the amounts of the related document, when the related document does not specify the currency, is recorded as MXN. The amounts recorded in the attributes “Saldo anterior”, “Importe Pagado” and “Saldo insoluto” must correspond to this currency. According to the c_Moneda catalog. |
| C | Tipo de cambio | Exchange rate in accordance with the currency recorded in the related document. It is required when the currency of the related document is different from the payment currency. The number of units of the currency indicated in the related document that are equivalent to one unit of the payment currency must be recorded. |
| R | Metodo de pago |
|
| C | Num parcialidad | Partial number corresponding to the payment. Required id "Metodo de pago"= "PPD". |
| C | Saldo anterior | Amount of the previous balance of the related document or the amount of the outstanding balance of the previous installment. Required when "Metodo de pago" = "PPD". If it is the first installment, this field must contain the total amount of the related document. |
| C | Importe Pagado | Amount paid for the related document. Required when there is more than one related document or when there is a related document and the Exchange Rate has a value.. |
| C | Saldo insoluto | The difference between the previous balance amount and the payment amount. Required when"Metodo de pago"= "PPD". |
On this sheet you must record the payment details if it was made through SPEI.
(R)equired or (C)onditional Data:
| C | Num. Operación | Check number, authorization number, reference number, tracking code in the case of SPEI, capture line or some similar reference number that identifies the operation that covers the payment made. Required when payment is made by SPEI. |
| C | Tipo cadena pago | Name the type of payment chain. Required with SPEI. |
This sheet must be used to record data when you wish to replace a previous payment voucher.
(R)equired or (C)onditional Data:
| C | Folio | Folio of the payment receipt to be replaced. Required when replacing a payment voucher is required. |
| C | Serie | Series of the payment voucher to be replaced. Required when replacing a payment voucher is required. |
In this sheet you will find the catalogs for "FormaPago", "Moneda", etc. that will help you quickly fill in the required fields of the connector. You can fill each column according to your preferences.
Please note that each value you add must be the same as the one specified in the SAT catalogs.
Example
Download an example of the connector here.
External links
- Catalogs: Catalogs
- Direct link to SAT documentation: SAT´s documentation
