Skip to main content

Reconciling or unreconciling bank transactions with documents

Link your bank transactions with documents, payments and receipts in Holded

Written by Irene

Bank reconciliation allows you to link your bank transactions with documents in Holded, ensuring that your accounting always reflects the financial reality of your business. From Treasury > Reconciliation, in the left-hand side menu, you can reconcile:

  • Transactions with existing documents, such as sales or purchase invoices, remittances, payroll, and payments or collections already recorded.

  • Transactions with new records, generating invoices, tickets, payments or accounting entries on the fly.

Remember that when reconciling a transaction against a document generated in Holded, the accounting entry corresponding to the payment or collection is automatically created.

☝🏼 Make sure you have your bank connected to Holded or have imported your bank statement before you start reconciling.


1. Reconcile transactions with existing documents

If a document is already registered in Holded, you can link it with a bank transaction by following these steps:

  1. Go to Treasury > Reconciliation, in the left-hand side menu.

  2. In the Bank account filter, select the account where the transaction is located.

    ☝🏼The reconciliation will use the accounting account you have set up for that bank account. You can change it if you need to. Learn how here.

  3. On the left, in the list of transactions, check the box for the transaction you want to reconcile (use the Status and Date filters to facilitate the search).

  4. On the right, in the list of documents, check the box for the corresponding document (invoice, remittance, payroll, payment, etc.). To find it quickly, you can use the filters Document type and Date or the search engine.
    ​
    ☝🏼 Reconcile the transaction with the documents if they are in pending or expired status; Otherwise, reconcile them with the collection or payment generated on the platform.
    ​

  5. Click on Reconcile in the lower right corner.
    ​

Where are the conciliated transactions going? To view them, simply change the filter from “Pending” to “Reconciled” in the top left corner.

​


2. Reconcile transactions with new documents

If the document does not yet exist in Holded, you can create it when reconciling:

2.1. With a new document (invoice, purchase, etc.)

  1. Go to Treasury > Reconciliation and, in the Bank account filter, select the corresponding account.

  2. In the list of transactions, on the left, check the box of the transaction you want to reconcile (use the Status and Date filters to facilitate the search).​

  3. On the right, click on New document at the bottom of the list of documents.

  4. At the top, choose the type of document (purchase, purchase ticket).

  5. Fill in the fields and click on Create and reconcile.
    ​

When you reconcile a bank transaction this way, the new document is automatically created in Holded and linked to that transaction.

Case study

Imagine that your bank has charged a set-up fee, and you have not yet registered this expense in Holded. You can reconcile it by creating a purchase ticket on the spot:

  1. Go to Treasury > Reconciliation and, in the Bank account filter, select the corresponding account.

  2. Mark the transaction on the left side.

  3. Click on New document and select Purchase ticket.

  4. Enter the ticket number (if you have one).

  5. Choose the corresponding expense account, e.g. 62600000 Bank charges.

  6. Review the amount and add more lines if necessary.

  7. Click Create and reconcile.

The transaction will be linked to the document created and the corresponding accounting entry will be generated automatically.

2.2. Reconcile without document

If the transaction doesn't correspond to an invoice or any other document (for example, a bank fee, an advance payment or a transfer between accounts), you can reconcile it directly without creating one:

  1. Go to Treasury > Reconciliation and, in the Bank account filter, select the corresponding account.

  2. On the left, in the list of transactions, check the box for the transaction you want to reconcile (use the Status and Date filters to facilitate the search).

  3. On the right, in the document list, click Reconcile without document at the bottom.

  4. Under Record transaction using, choose an option:

    • An accounting account: the amount is recorded directly in the accounting account you select. For example, a bank fee in account 62600000 Bank charges.

    • A contact: the transaction is linked to a customer or supplier and recorded against their accounting account. Use it, for example, for a customer advance or a payment to a supplier whose invoice you don't have yet.

    • Another transaction: the transaction is linked to its matching transaction in another bank account or cash register. For example, a transfer from the bank to the cash box. This way it doesn't appear as income or expense, since it's only an internal transfer.

  5. To check how it will look in your accounting, expand View accounting entry.

  6. Click Reconcile.

💡 By default, the transaction's accounting date is used. If you'd rather use the value date, change it in Settings > Accounting > Preferences.

Date of the entry generated in the reconciliation

When a reconciled transaction is posted, the date of the generated entry will be, by default, the accounting date, that is, the date of the transaction recorded on the bank statement.

If you need to, you can change this criterion in Settings > Accounting > Preferences > Reconciliation, where you can choose between two options:

  • Accounting date: the date of the transaction recorded on the bank statement.

  • Value date: the date on which the bank applies the amount to the transaction.

This way, you can choose which date to use to generate the accounting entries when you reconcile.

With these steps, you can keep accurate control of your accounting and prepare your business to automate reconciliation in the future.


Unreconciling a bank transaction

If you have made a mistake when reconciling a transaction, you can undo it in a few steps.

  1. Go to Treasury > Reconciliation and, in the Bank account filter, select the corresponding account.

  2. In the list of transactions on the left, change the filter from “Pending” to “Reconciled” to see the transactions that are already linked to documents.

  3. Find the transaction that you want to unreconcile and click on it.

  4. In the panel that opens on the right, you can find the linked document.

  5. Click on the minus (-) icon to the document's right.
    ​

  6. Confirm the action to complete the unreconciling.

🚨 Note the following:

  • If the transaction was reconciled against an existing document (such as an invoice), the accounting entry of the payment or collection will be deleted.

  • If you reconciled it by creating a new document, the transaction will be de-reconciled but the accounting entry will still exist. Learn how to delete it here.

Did this answer your question?