Linking receivables

Koncili needs to know which accounts receivable entry, in the ERP, corresponds to each order — today this link is not discovered automatically. You must import this relationship manually whenever there are new orders without a link.

1. Export the accounts receivable in Tiny

Before importing into Koncili, export the accounts receivable spreadsheet straight from Tiny.

In Tiny, go to Finance > Accounts Receivable and filter the open entries (you can filter by payment method, period and others).

Tiny Finance > Accounts receivable, open tab — Tiny > Finance > Accounts Receivable — filter the open entries.

Click more actions, in the top-right corner, and choose export entries to spreadsheet.

Tiny more actions menu with the export entries to spreadsheet option — "more actions" → "export entries to spreadsheet".

On the export screen, select Export in text format (.csv) and click Download to get the file.

Accounts Receivable export screen with the .csv format selected and Download buttons — Select "Export in text format (.csv)" and click Download.

500-entry files: Tiny splits the export into files of up to 500 records each. If there are more than that, download all the generated files.

2. Open the Import area

In Koncili's side menu, go to Tools > Import.

Side menu → Tools → Import

Illustration of the Koncili menu — the "Importação" item under the Ferramentas section.

3. Choose Accounts receivable

On the import screen, select the Accounts receivable card. This is the flow used to link an order and an ERP receivable.

Import screen with the Additional data and Accounts receivable cards — Import screen — use the "Accounts receivable" card.

4. Start a new import

In the Accounts receivable list, click New import.

If needed, use the screen filters (ID, ERP, status and period) to check previous imports.

Contas a receber

Nova importação

Ex: 123

ERP

Ex: Tiny

Status

Selecione

Período de criação

dd/mm/aaaa

✓ Aplicar⌛ Limpar filtros

Hm... não encontrei nenhum registro.

Illustration of the Accounts receivable import list.

5. Select the ERP and upload the file

In New import, select the Tiny ERP, upload the .csv file with the order↔receivable link and click Start import.

The limit per file is 15MB.

ERP

Tiny ▾

☁
Arraste e solte o(s) arquivo(s) aqui ou selecione.
São permitidos os formatos: .csv. O tamanho máximo permitido é de 15MB por arquivo.

Iniciar importação

Illustration of the New Import form — Tiny ERP + CSV upload.

Only what's new: import only orders that don't have a link yet. Existing links remain valid in the following write-offs.