Jorora home

Reconciliation · transfers

Which transfers already arrived? Put the receipt next to the order.

Upload Nequi, Bancolombia, Daviplata, and Bre-B receipts. Jorora fills date, customer, amount, and reference in your Excel. You mark the order those pesos belong to.

Try freeSee a match example

Jorora fills what the receipt shows. Your expected amount stays a column you map or complete. 1 credit = 1 batch.

See a match example

ReceiptDate, customer, amount, reference

Your columnThe order or expected amount you already track

2 creditsFree when you create an account

See credit packs →

From this

Orders here, receipts in the chat

You are matching two lists that were never in the same place.

To this

A row you can tick

The receipt fields are filled. The order column is yours.

What the customer sent

“Ya transferí” needs a row

Then you look at the order list you already have.

  • Pedido 1042

    Transferencia Bancolombia del saldo

  • Pedido 1048

    Nequi, te mandé el comprobante

  • Sin pedido en el mensaje

    Te consigné $90.000

Jorora writes the receipt. You write which order it was.

Your conciliación sheet

Received, ready to mark

  • Date26/09
    CustomerComercial Andina
    Reference0093817264
    Received$1.250.000
    Your order1042
  • Date26/09
    CustomerLaura Mejía
    Reference102938
    Received$45.000
    Your order1048
  • Date26/09
    CustomerPor completar
    Reference661902
    Received$90.000
    Your order—

Example of your sheet after export. Jorora fills the receipt columns. “Your order” is a column you map from the Excel you already use, or you type it while reviewing. The third payment had no order on the screenshot.

Keep using your Excel.

The conciliación template leaves expected amount and difference for you. Jorora does not invent what the customer owed.

How it works

Reconciliation starts when every transfer is a row.

Jorora does not sign in to the bank. It gets the receipt onto the sheet where you already compare.

  1. 01

    Upload the transfer receipts

    Screenshots and PDFs from the day, including the ones that arrived on WhatsApp.

  2. 02

    Read the fields you match on

    Reference, amount, date, and sender. If the order number is not on the receipt, that cell stays yours.

  3. 03

    Export into the conciliación sheet

    The template has columns for amount received, the amount you expected, and the difference. Jorora fills what the document shows. You complete what the customer owed.

What you upload

Screenshots, PDFs, and your Excel

Bring the receipts already sitting on your phone. Add your spreadsheet if you want the same columns back.

  • Transfer screenshots and PDFs
  • WhatsApp files of those receipts
  • The Excel where you list orders or expected payments

Why it fits a small business

You keep the sheet you already know

Jorora reads the receipt and fills the workbook. You still check the row before you trust the total.

  • Matching stays in your sheet, where the expected amount already lives.
  • A receipt with no order number is still a row you can search.
  • Nothing is marked “paid by the bank.” The source is the document.
  • You keep the workbook your bookkeeper already opens.

Under the hood

The result comes first. The technology second.

You do not need to learn an OCR product. This is what happens after you upload.

  • The extraction puts the reference where you can compare it.
  • Nequi and bank transfers can be reconciled in the same file.
  • You confirm the match. The row does not close an invoice by itself.

FAQ

Transfer payment reconciliation questions

Upload the receipts, export date, customer, amount, and reference into your Excel, and mark each row against the order or invoice you expected. The conciliación template includes columns for expected amount and difference for you to complete.

No. It reads the receipt you upload. It does not connect to Bancolombia, Nequi, or any bank.

Customer, amount, date, and reference still land on the row when they are visible. You type the order in your column while you review.

Yes. Import it and map the receipt fields onto your columns, including the expected-amount column if you have one.

Keep going

Pick the situation you are in

Same tool. Each page is a different job: Nequi, Bancolombia, a full WhatsApp chat, who paid, today’s cash close, or matching transfers to what you expected.

Put today’s transfers on the reconciliation sheet.

Two free credits when you create an account. Failed reads do not spend a credit.

Try free