Factoring system: handle quedanes and invoices without spreadsheets

It receives quedanes (payment promise notes) and DTE electronic tax documents, calculates how much to advance, controls exposure per client and per payer, records disbursements and collections in its own ledger and settles each transaction. Built for El Salvador, with DTE data reading.

What it is

It is a web-based system for running a factoring company. It receives quedanes and electronic invoices, calculates how much to advance, controls exposure per client and per payer, records disbursements and collections in its own ledger and settles each transaction without spreadsheets.

It is designed for a factoring company that operates with its own funds and works on a with-recourse basis: if the payer does not pay, the assignor is liable.

Product status. The system is finished and tested, with more than 1,300 automated tests passing, but it is not yet in production with a client. We say it plainly: whoever takes it first comes in as the first implementation, with the hands-on support that implies and with real influence over what gets adjusted.

Who uses it

Three parties, each with different screens:

  • The factoring company. It buys the documents and puts up the money. Its analysts review and approve, treasury disburses, and collections collects and settles.
  • The assignor, the company that sells its accounts receivable. It logs in to its own portal, where it sees its credit line, uploads quedanes and invoices, simulates how much it will receive and tracks the status of each request.
  • The payer, the company that must pay the quedan. It does not need a user account: it receives a link by email and confirms that it acknowledges the document and the assignment.

The process, end to end

Before any transaction, the assignor and its payers are registered with their NIT, NRC, legal representative and bank account. The account is only used after an analyst has verified it. A credit line is assigned to the assignor and another to each payer, and the terms are recorded: advance rate, annual discount rate, late interest rate, fee, VAT, 360- or 365-day basis and grace days. Each change to the terms creates a new version and the previous one is kept.

After that, each transaction goes through seven steps:

  • Request. The assignor uploads the quedan as a PDF or photo and one or more DTE in JSON. The system reads from the file the generation code, the control number, the date, the issuer, the recipient, the amount and the reception stamp of the Ministry of Finance (Ministerio de Hacienda).
  • Automatic checks. It rejects the DTE if it was not issued by that assignor, if the payer is not a registered customer of the assignor, or if the document is already in another active transaction.
  • Simulation. The assignor chooses how much to request, which can be less than the maximum, and sees the estimated net amount before submitting.
  • Payer notification. When the request is submitted, the payer receives a link valid for seven days and confirms that it acknowledges the quedan, giving name and job title, or rejects it with a reason.
  • Evaluation and approval. The analyst reviews the DTE, the payer's confirmation, the available limit of both parties before and after the transaction, and concentration. On approval, the terms are frozen.
  • Disbursement. It is recorded by a different user from the one who approved. The final amounts are calculated with the actual date and remain fixed. The settlement statement is generated as a PDF.
  • Collection and settlement. The payment is recorded, the system calculates late interest if any, deducts it from the reserve and returns the remainder to the assignor.

How it is calculated

The formulas are implemented exactly as shown and the calculations use exact decimal arithmetic, with no floating-point rounding:

  • Maximum advance = quedan value × advance rate
  • Discount = requested amount × annual rate × days ÷ day basis
  • Fee = quedan value × fee percentage + fixed fee
  • VAT on the fee = fee × 13%
  • Net amount the assignor receives = requested − discount − fee − VAT
  • Reserve = quedan value − requested, which is returned upon collection less late interest, if any

An example with illustrative parameters, not actual rates: on a quedan of US$ 10,000.00 with a 90% advance rate, the advance is US$ 9,000.00 and the reserve withheld is US$ 1,000.00. With an 18% annual discount over 60 days on a 360-day basis, US$ 270.00 is deducted; a 1% fee deducts US$ 100.00 and its VAT US$ 13.00. The assignor receives US$ 8,617.00 at disbursement and, if the payer pays without late interest, the US$ 1,000.00 reserve is returned to it.

The six controls that set it apart

📊

Exposure per payer

One credit line for the assignor and another for each payer. If the transaction exceeds either one, it cannot be approved.

🚫

No double financing

The same DTE cannot be in two active transactions. This is prevented by a constraint declared in the database, not just by on-screen validation.

✅

Payer confirmation

Without the payer's acknowledgment, the transaction is not approved. It is stored with name, job title, date and IP address.

📅

Daily portfolio status

Every night it classifies each transaction as current, past due within grace or in arrears, and saves a snapshot of the day.

📖

Accounting with no edits

A double-entry ledger where the application does not allow entries to be edited or deleted. Corrections are recorded as reversals.

👁

Four eyes

Whoever approves a transaction cannot disburse it. They are two different users, by system rule.

What it does not do

So that nobody is surprised during implementation, this is what the current version does not cover:

  • It does not validate DTE against the Ministry of Finance automatically: the analyst looks them up and records the result.
  • It does not issue the DTE for the fee or calculate VAT or income tax withholdings.
  • It has no connected electronic signature and does not integrate with banks: disbursements and collections are recorded with their reference.
  • It does not query credit bureaus. The payer's rating is assigned by a person.
  • It does not handle non-recourse factoring or funding from third-party investors.
  • It does not export to external accounting systems, does not send WhatsApp messages and handles US dollars only.
  • The formats are Salvadoran: DTE, NIT, DUI and NRC. Other countries are not covered.

On the legal side

The system records the notification and acceptance of the assignment by the payer, with the date, name and job title of the person confirming. The legal form of the assignment and of the contracts is defined by each factoring company's legal counsel.

Technology

A web application built in Laravel 12 on PHP, with PostgreSQL, Livewire, Alpine.js and Tailwind CSS. It runs in desktop and mobile browsers. It can be installed on the factoring company's own server or in the cloud.

The core comes from Solventa, a collections system that Soluciones Aplicativas built and that is in use: security, auditing, the importer, reports and messaging were reused from it.

Frequently asked questions

Does it work for quedanes or only for electronic invoices?

Both. The assignor uploads the quedan as a PDF or photo together with the DTE that back it; the system reads the DTE automatically and extracts the generation code, the control number, the date, the issuer, the recipient, the amount and the Ministry of Finance reception stamp.

Does it validate invoices against the Ministry of Finance?

It reads the DTE reception stamp and will not allow a transaction to be approved without it. The lookup with the Ministry of Finance (Ministerio de Hacienda) is done by the analyst through a direct link to the public query site; automatic validation is not included in the current version.

Can I set my own rates, advance rate and fees per client?

Yes. Each assignor has its own terms: advance rate, discount rate, late interest rate, percentage and fixed fees, a 360- or 365-day basis and grace days. Each change creates a new version and does not affect transactions already approved, because the terms are frozen on approval.

Does it keep the accounting for each transaction?

It records every disbursement, collection, interest accrual, late interest charge and refund in its own double-entry ledger. It does not replace the company's accounting system or export to it in the current version.

Does it work for non-recourse factoring?

The database provides for both modes, but the current version operates with recourse: if the payer does not pay, the assignor is liable. Operating without recourse requires development adjustments.

Can I bring in investors to fund the transactions?

Not in the current version. It is designed for a factoring company that operates with its own funds. The investor module exists in the structure but is switched off and has no functionality.

Where is it installed?

On a company server or in the cloud. It is a web application: it is used from the browser, on a computer or a phone, with nothing to install on each machine.

Each control, in detail

Each control in the system has its own page, detailing what problem it solves and how:

Tell us about your operation

A free 60-minute discovery session to review how you operate today: which documents you discount, how you set advance rates and discount rates, how you control limits per client and per payer, and how you settle. From there we prepare a scope proposal.

Request the session   WhatsApp