Importing payments
You can upload payments from an online bookkeeping service or another program to your online bank account. You may need this when you create payments in your system and then process them through Bank 131's online bank.
Supported file formats: TXT (export from 1C:Enterprise), CSV, and DBF.
Note. Payments may have the date that is 10 days earlier than the actual date. Only new payments can be added. If the payment details fully match the details of a payment recorded in the online bank, this payment won't be added. Payments are added with the status Created and pending signing to be sent. You can find them in Transaction history (To sign tab).
How to import payments
Prepare transaction files, go to the Import payments in the left-hand menu, then drop the files into the upload area or browse them.
If everything is all right, you will see a successful import notification. Click To created payments to view what was imported.
You can find the imported payment in the To sign tab of transaction history.
Payments from 1C:Enterprise
You can export transactions from 1C and import the resulting file on this page.
Payments in DBF
You can upload a DBF file from your system and import it here.
Field descriptions
No. | Field name | Type | Length | Description |
---|---|---|---|---|
1 | NUMBER | Character | 8 | Payment No. |
2 | AMOUNT | Float | 19, 2 | Payment amount |
3 | ACCOUNT | Character | 20 | Payer's account |
4 | KPP | Character | 9 | Payer's Tax Registration Reason Code |
5 | CACCOUNT | Character | 20 | Recipient’s account |
6 | CINN | Character | 12 | Recipient’s Taxpayer Identification Number |
7 | CKPP | Character | 9 | Recipient’s Tax Registration Reason Code |
8 | CNAME | Character | 160 | Recipient's name |
9 | CBANKBIC | Character | 9 | Recipient’s Bank Identification Code |
10 | ORDERDATE | Date | Payment date | |
11 | PRIORITY | Character | 1 | Priority |
12 | PURPOSE | Character | 210 | Purpose |
13 | STATUS | Character | 2 | Document status |
14 | KBK | Character | 20 | BCC |
15 | OKATO | Character | 8.11 | OKTMO of the territory in which the funds from the payment of tax, fee, or another payment are mobilized |
16 | REASONCODE | Character | 2 | Reason for payment |
17 | PERIOD | Character | 10 | Tax period |
18 | DOCNUMBER | Character | 15 | Document No. |
19 | DOCDATE | Character | 10 | Document date |
20 | PAYMENTTYP | Character | 2 | Payment type |
21 | KOD | Character | 25 | Code |
22 | INCOMEKIND | Character | 1 | Income Type Code |
Only account number is passed, since other details are already uploaded to the online bank.
Payments in CSV
You can upload a CSV file from your system and import it here.
File sample
Download sample. In this file, you need to change all the details: dates, account numbers, payment number, etc.
File format
Character set: Cp1251. The file must contain the heading row. Fields may be in any order. Field separator — "," (comma). Fractional part separator — "." (period). Date format — MM.DD.YYYY.
Field descriptions
No. | Field name | Type | Length | Description |
---|---|---|---|---|
1 | number | Character | 8 | Payment No. |
2 | amount | Float | 19, 2 | Payment amount |
3 | payerAccount | Character | 20 | Payer's account * |
4 | payerKpp | Character | 9 | Payer's Tax Registration Reason Code |
5 | payeeAccount | Character | 20 | Recipient’s account |
6 | payeeBankBic | Character | 9 | Recipient’s Bank Identification Code |
7 | payeeInn | Character | 12 | Recipient’s Taxpayer Identification Number |
8 | payeeKpp | Character | 9 | Recipient’s Tax Registration Reason Code |
9 | payeeName | Character | 160 | Recipient's name |
10 | ORDERDATE | Date | Payment date | |
11 | priority | Character | 1 | Priority |
12 | purpose | Character | 210 | Purpose |
13 | INCOMEKIND | Character | 1 | Income Type Code |
14 | fkUid | Character | 25 | Code |
15 | taxStatus | Character | 2 | Document status |
16 | taxKbk | Character | 20 | BCC |
17 | taxOkato | Character | 11 | OKTMO |
18 | taxReasonCode | Character | 2 | Reason for payment |
19 | taxPeriod | Character | 10 | Tax period |
20 | taxDocumentNumber | Character | 15 | Document No. |
21 | taxDocumentDate | Character | 10 | Document date |
22 | taxPaymentType | Character | 2 | Payment type |