Cuéntamo manualFreelancers › Record books

Record books

The mandatory ledgers for your activity — income, expenses, capital assets and provisions — with their tax amount, their classification and their link to real movements

What they're for

If you're a self-employed worker under the Estimación Directa Simplificada regime, the law requires you to maintain four tax books. Until now you were probably doing it in a spreadsheet, a notebook, or separate accounting software. The idea behind Cuéntamo is that these books fill themselves automatically from the movements you're already recording: when you confirm a freelance income or expense as real, Cuéntamo automatically creates the entry in the corresponding book.

The four books are:

  • Income Book — The invoices you issue to your clients. With taxable base, output VAT and PIT withheld if applicable.
  • Expense Book — The invoices you receive from suppliers. With the same breakdown. Does not include items that go to other books (amortisations, provisions).
  • Capital Goods Book — Assets you've purchased for your business that are amortised over several years: computer, camera, furniture, vehicle.
  • Provisions Book — Payments made on behalf of third parties that you later pass on to the client in your invoice.

The three dates that matter

Each invoice record can have three different dates. They're not redundant: each one means something different.

  • Payment date — When the money entered or left your account. This is the date of the bank movement.
  • Invoice date — The one shown on the supplier's document or on your invoice. For income, this determines which quarter it belongs to.
  • Registration date — When you enter that invoice in your book. Only matters for expenses, and only when it differs from the invoice date. Typical example: an invoice dated 28 December that the supplier sends you on 5 January. Payment in January, invoice in December, registration in January. The registration date determines the fiscal quarter for the expense.

If you don't fill in the invoice date, Cuéntamo uses the payment date. If an expense has no registration date, it uses the invoice date. Most of the time, just entering the invoice date is enough.

Accessing the books

In the sidebar, under the freelance section, you'll find Tax books. It opens a screen with four tabs — one per book — with a fiscal year selector at the top.

Each row is an invoice. The numbering is calculated automatically: sorted by effective date and numbered sequentially, just as the Tax Agency (Agencia Tributaria) requires.

Search and filter

Above the table you have several tools to narrow down what you see (they all combine):

  • Search — by concept, invoice number, third party name or tax ID.
  • Quarter — the whole year or a specific quarter.
  • PIT box — a specific box or the "Unclassified" option, perfect for finding invoices you still need to assign (the same ones grouped in the Annual PIT summary).
  • Third party — to see all the invoices of the same client or supplier at once.

Tune the columns to your liking. Drag the line between two headers to change the width. With each column's icon you choose whether its text shows on a single line (clipped with "…"; hover to see it in full) or wraps onto several lines. The header stays frozen as you scroll the list. Each book remembers its setup in this browser; there's a link to reset it.

Classifying into PIT boxes

Each document can be assigned to a tax-return box (direct estimation). That classification is what feeds the Annual PIT summary, where you'll see the bases grouped by box ready for your draft return.

There's a box column in the table, and you can assign it in three ways:

  • Document by document, from the invoice's side panel.
  • With the assistant: if you don't know which box applies, a question-based assistant ("what is the expense related to?") guides you to the right one. Each option has an : hover over it to see examples of what does and doesn't belong in that box. One of the branches is Insurance (business policies —civil liability, premises, vehicle—, your private health insurance with its €500/person limit, and your employees').
  • In bulk: select several rows and assign them the same box at once (also with the assistant).

Completing the tax data of an invoice

When you confirm a freelance movement as real, Cuéntamo automatically creates an empty tax record. To complete it, click on the row in the book table or on the document icon that appears next to the "Freelance" label in the movements list. A side panel opens where you fill in:

  • Third party (client or supplier): a single field that lets you search your directory or type a free-form name. When you pick one from the list, the tax ID (NIF) fills in automatically.
  • Tax ID (NIF): manually editable; leave it empty for non-EU third parties (no European tax ID).
  • Invoice number: the number from the supporting document.
  • Invoice date and registration date (expenses only, if different): on the same line. If the date belongs to a previous fiscal year, you'll see a warning reminding you of the possible need for an amended return.
  • Tax amount (EUR): the invoice total. The Tax Agency books must always be in euros, even if the invoice was issued in another currency (use the exchange rate on the date of issue). Below it, a taxable-base viewer breaks that total down live: base excluding VAT, VAT amount and withheld income tax based on the rates you enter, so you can check at a glance that it matches the paper invoice.
  • % VAT and % PIT withheld: the tax data lives in the document, not in the movement. This allows an operation collected via subsidy or with a gross amount different from the bank amount to correctly record its output VAT. If you edit these fields from the movement, Cuéntamo automatically propagates them to the linked document.
  • Amortisable asset + annual amortisation %: if it's a purchase that gets amortised, tick the checkbox and Cuéntamo moves it to the Capital Goods Book with its quarterly instalment.
  • Provision: toggle to mark it as a provision and move it to the corresponding book.
  • PIT box: the tax-return box this income or expense belongs to. If you're unsure, tap the help button and a question-based assistant guides you to the right one. It feeds the Annual PIT summary.
  • Notes: collapsed by default, for any traceability notes.

Below the tax data, the Linked movements section lists the associated bank movements and their payment status. An invoice can have several linked movements (deferred payments), even in a different order from the one you entered them.

At the top of the screen you'll see the coverage indicator: "X of Y with complete data". It tells you how many records you still need to fill in. A record is considered complete when it has at least the third party's name.

Expense deductibility

Not every expense is 100% deductible. In the document editor there's a collapsible "Deductibility" block with a situation selector to state how much of this particular expense you deduct:

  • 100% deductible — the usual: the whole expense and all its VAT.
  • Vehicle (50/50) — 50% business use and 50% VAT, the typical mixed-use car (article 95 of the VAT Act).
  • No deductible VAT — the expense is deductible for income tax, but its VAT can't be reclaimed (VAT-exempt activity, client entertainment…). That VAT becomes a larger expense instead.
  • Partial use — you enter both percentages by hand: business use (income tax) and deductible VAT.
  • Inherit from profile — uses the deductibility profile of the expense's tag or category (the tag wins over the category), defined in Settings → Freelance.

The rule is simple: whatever you set on the document wins over the tag or category profile, and that profile wins over the default 100% (priority: document → tag → category → 100%). So you set up the "Car" profile at 50/50 once and only touch the document when a specific invoice is an exception.

These percentages flow into your settlements: the non-business share doesn't reduce your income-tax form 130, and non-deductible VAT isn't offset on form 303.

How numbering is calculated

The Tax Agency requires sequential numbering per book and per fiscal year. Cuéntamo calculates it on the fly, sorting by effective date, every time it displays the table or exports. It's not stored in the database. This is important: if you import movements with past dates or correct dates, the numbering is recalculated. This is perfectly legal: what's required is that it be sequential at the time of filing, not that it stays the same forever.

Export to Excel

The Export button generates an .xlsx file in a format that your accountant (or you yourself) can use directly. It includes:

  • Header with the book name, fiscal year, generation date and account book name.
  • Exact columns depending on the book (income, expenses, capital goods, provisions).
  • Totals row at the end with the sum of taxable bases, VAT amounts, PIT withheld and totals.
  • Rows with incomplete data highlighted in yellow so you can review them before filing.

The export includes all records for the book and year, including those without an associated bank movement (imported or created by hand), so the book is complete.

Columns in each book

Income Book: entry # · invoice date · concept / invoice # · client · client tax ID · taxable base · % VAT · VAT amount · % PIT withheld · PIT amount · invoice total. The taxable base is calculated as total / (1 + VAT/100).

Expense Book: identical but with "Supplier" instead of "Client". An additional registration date column appears when any expense has a registration date different from the invoice date. Amortisations and provisions are excluded (they go to their own books).

Capital Goods Book: asset # · description · acquisition date · amount · annual amortisation % · annual instalment · accumulated amortisation · net book value. Amounts are in net values (excluding VAT): the depreciable base is the acquisition price without VAT, because input VAT is deducted separately at 100% in form 303 for the quarter of purchase. Depreciation (instalment, accumulated and net value) is calculated on that base, from the year of acquisition to the fiscal year you're viewing, without exceeding the original amount.

Previous fiscal year warning

If you enter an invoice date that belongs to a different fiscal year from the one you're viewing (for example, a 2025 invoice while viewing 2026), an informational warning appears:

"This invoice date corresponds to a previous fiscal year. If that year has already been filed, you may need an amended return to include it. Consult your tax advisor before recording it."

The warning doesn't block saving: it only alerts you. Cuéntamo doesn't know whether you've already filed the previous year or not.

Legal reference

The obligation for self-employed workers under the Estimación Directa Simplificada regime to maintain tax books is regulated by:

  • Real Decreto 439/2007, articles 65-68 — Minimum content of PIT tax books for business activities under Estimación Directa Simplificada.
  • Resolución de la Agencia Tributaria de 4 de abril de 1995 — Format and structure of tax books.
  • Ley 37/1992 (LIVA), article 62 — VAT tax books (issued and received invoices).
  • Real Decreto 1619/2012 — Invoicing regulation: expense receipt requirements.

Cuéntamo helps you comply, but does not replace professional tax advice. The calculations and formats are for guidance only. Before filing returns based on this data, validate with your tax advisor.

The Record books screen is the documentary heart of the self-employed module. This is where the invoices and other tax documents of your activity live, organised into the mandatory ledgers your regime requires. Each document holds its own fiscal amount (base, indirect tax, withholding…), its classification and its link to the real movements that pay or collect it. With that, Cuéntamo computes your tax returns and summaries accurately.

It is important to grasp the difference with the Movements screen: a movement is money going in or out of an account; a tax document is the invoice that backs that operation. They don't always match one to one: an invoice can be paid in several instalments, and its fiscal amount may differ from the amount that actually moved the account (fees, rounding, exchange differences). The record books keep the accounting of the invoices; the movements, that of the money.

Cuéntamo automatically creates a tax document whenever you record a self-employed movement. So in day-to-day use many ledgers fill themselves and here you just complete the tax data that is missing. You can also create «orphan» documents (with no movement) or import your ledgers from a spreadsheet.

The four books

At the top there is a row of tabs, one per book. The names and the number of books depend on your tax regime (Cuéntamo's engine is configurable by country and regime), but the usual structure is four:

  • Income: the invoices you issue to your clients. The third-party column is titled «Client».
  • Expenses: the invoices you receive from your suppliers. The third-party column is titled «Supplier», and this book adds a registration date column.
  • Capital assets: the assets you depreciate over several years (equipment, furniture, vehicles…). Here the value is recorded net (without the indirect tax, which is already deducted in the expense book) and depreciation columns appear: asset type, yearly rate and a progress bar.
  • Provisions: provisions of funds and disbursements.

Switching tabs resets the search and quarter filters. The year is chosen with the arrows next to the title; the whole screen (records, coverage and summary) refers to that year.

Creating and importing documents

At the top right you have the main actions (on mobile they collapse into a three-dot menu):

  • New record : creates an empty tax document of the active book's type (income or expense) and opens the editor for you to fill in. It's the way to register an invoice that has no associated movement yet.
  • Find matches: appears in the income and expense books when there are documents with no linked movement. It opens a window that proposes, for each orphan document, the real movements in your bookkeeping that fit by amount and date, so you link them in one click. Detailed below.
  • Import : upload your ledgers from a file (CSV/XLS/XLSX/ODS) with a detection, preview and column-mapping wizard. Useful if you come from another tool or from an export by your accountant.
  • Export : download the active book of the current year as an Excel (XLSX) file, including orphan documents with no movement.

Next to these buttons is the coverage indicator («X of Y complete»): how many of the year's documents already have all their tax data versus the total. It's your «what's left to fill in» thermometer.

Search and filter

Below the tabs there is a filter bar that acts on the active book and year:

  • Search: a free-text box that matches concept, third-party name and tax ID, invoice number, amount and dates.
  • Quarter: «Whole year» or a specific quarter (Q1–Q4). Filters by the document's effective accrual date.
  • Income-tax box: filters by the assigned income-tax box. It includes a «Unclassified» option to find documents you haven't boxed yet. The list of boxes adapts to the book's type (income or expenses).
  • Third party: appears when the book has third parties; filters by a specific client or supplier name.

When there are visible rows, a summary appears just below with the total base, the breakdown of the indirect tax per rate (for example «VAT 21%», «VAT 10%») and the total, plus the number of records. The summary lives inside the sticky header, so it stays visible as you scroll the table. The capital-assets and provisions books don't show this tax summary.

The table (desktop)

On wide screens the documents are listed in a powerful table designed for reviewing many records:

  • Frozen header: the column titles stay fixed as you scroll, so you don't lose the reference.
  • Resizable columns: drag a header's edge to adjust its width. Each book remembers its widths in your browser; an «↔ Reset columns» link returns them to the default.
  • Per-column wrap: you can make a specific column show its text across several lines instead of clipping it. The rest is clipped with an ellipsis and, on hover, shows the full text.
  • Sorting: click a sortable header (dates, concept, invoice number, third party, tax ID, amount) to sort; click again to reverse. Ties break by invoice date and number.

Each row shows its sequence number, the dates, the concept, the invoice number, the third party with its tax ID, the income-tax box (as a small badge with the code) and the amounts (base, tax quota, withholding and total, depending on the book). The capital-assets book replaces those columns with the asset type, the yearly rate and a depreciation progress bar with its tooltip (base, rate, accumulated depreciation, net value and years).

Some per-row indicators:

  • If the fiscal amount differs from what was actually paid or collected, a «Diff:» note with the difference appears under the total.
  • On invoices with several tax rates, the tax column shows the list of rates («21% · 10%»).
  • A «!» warning marks documents with no linked movement (orphans), with a button to delete them .
  • A symbol flags incomplete documents (missing some tax data).
  • A icon indicates the document comes from a recurring template.

Clicking a row opens the document editor in a side panel.

Cards (mobile)

On narrow screens the table turns into cards. Each card summarises the concept (or the third party), the date and invoice number, the amount and some badges with the tax rate, the income-tax box, and warnings for «no linked movement», «incomplete» or «written off». Tapping the card opens the same editor. The checkbox lets you select several documents for batch assignment.

Batch classification and assistant

Each document is assigned to an income-tax box (the tax classification that feeds the annual income-tax summary). You can do it in three ways: in each document's editor, in bulk, or with a question-based assistant.

For batch assignment, check several rows (or «select all» in the header). A bar appears with the number selected, a box dropdown and a button to apply the box to all at once (or to clear it). From that same bar you can open the assistant.

The classification assistant is a questionnaire that leads you to the right box through questions. Each option carries examples and counter-examples on hover (or by clicking the «i»), has a «back» button to redo the path, and when it reaches a leaf it shows you the box code and assigns it. The question tree adapts to your jurisdiction and to the type (income or expense).

Forecast entries

Documents tied to a forecast movement (not yet real) and with no invoice date don't mix with the book: they are listed apart, at the bottom, under the heading «Forecast entries», in a faint style with a dashed border. They are invoices that will arrive but haven't accrued or been paid/collected yet; the income-tax summary doesn't count them until their date arrives. You can click them to edit them just like the rest.

The document editor: the summary card

Opening a document brings up a side panel. At the top, a visual summary card shows the essentials at a glance: an Income/Expense label, the third-party name, the tax ID · invoice number · date line, and the amounts block (base → tax → total, or just the total when there is no tax). Below, some status badges: the payment/collection status, whether the operation is exempt or not subject, the assigned income-tax box and, on expenses with non-standard deductibility, the affectation percentage.

Under the card, the rest of the editor is organised into collapsible zones (accordion): only one is open at a time, and each header shows a hint with its current content. The zones are: Identification, Amount and taxes, Deductibility, Depreciation, Linked movements and Notes. When done, the Save button at the footer confirms the changes.

Zone: Identification

The data that identifies the invoice:

  • Third party: a field with autocomplete against your third-party directory. Picking an existing one fills its name and tax ID; if you type a new one, it will be created on save.
  • The third party's tax ID (the label adapts to your regime) and the invoice number, on the same line.
  • No invoice number: a checkbox for legitimate records without numbering (receipts, some expenses). When ticked, the number field is disabled and the document does not count as incomplete for that reason.
  • Invoice date and, depending on the type, registration date (expenses) or due date (income). If the invoice date is from a year earlier than the book's, a warning is shown.

Zone: Amount and taxes

The document's fiscal core:

  • Fiscal amount: the invoice total (with the indirect tax included). It's the document's own amount and may differ from the movement that pays it. If it differs, the difference is flagged. Below, Cuéntamo computes and shows the taxable base and the tax quota, and marks with a badge if the asset is of low value.
  • Indirect tax (VAT or its equivalent depending on your regime): a dropdown with the available rates plus the Exempt and Not subject options. An «✨ assistant» button opens an interactive question that decides between exempt and not subject depending on whether it is income or expense; picking one of those options shows contextual help.
  • Withholding (income tax): the withholding rate, on expenses only.
  • Tax classification: the income-tax box dropdown, with the same question assistant described above («Not sure which? Let me help →») and the help text of the chosen box.
  • Intra-community operation: when the third party is linked, a selector (services / goods / mixed) for EU operations. In the regimes that apply it, it warns about the tax reverse charge.
  • Provision of funds: a checkbox on expenses to mark the document as a provision/disbursement.
  • Operation date: an advanced, optional sub-block to set the accrual date when it differs from the invoice date; it determines which period it is imputed to.

Breakdown by tax rate (lines)

One invoice can mix several tax rates (for example, part at 21% and part at 10%). For that, in the Amount and taxes zone there is a «Break down by VAT rate» toggle. When you turn it on, instead of a single amount and rate, you edit a table of lines, each with:

  • Concept, base and tax rate; the line's quota is computed automatically.
  • On expenses, a deductible tax per line selector (inherit from the document, 100%, 50%, 0% or another percentage).
  • An income-tax box per line (if you leave it on «inherit», it uses the document's).

You can add and remove lines; the base, tax and total are totalled at the bottom. With lines active, the document's amount becomes the sum of the lines and the single rate is cleared; the summary card shows the list of applied rates. It's the model compliant with invoicing rules (a multi-rate invoice is a single entry with a breakdown). Without lines, the document works exactly as before, with its single amount and rate.

When a document has lines, its tax data is edited here, in the document, not in the movement: the movement editors show a read-only notice that links to the document.

Zone: Deductibility (expenses)

On expenses, this zone controls to what extent the document is deductible, with a situation selector:

  • Inherit (if there is a profile by category or tag): uses the percentages you defined in Settings. It shows where it inherits from.
  • Fully deductible: affectation and deductible tax at 100%.
  • Vehicle (50/50): 50% affectation and 50% deductible tax, the typical mixed-use vehicle case.
  • No deductible tax: 100% affectation but 0% deductible tax (meals, for example).
  • Partial use: two fields to set by hand the affectation % (income tax) and the deductible tax %.

This document's percentages are an override on the inherited profile. The effective-deductibility rule and its effect on the computations are explained in detail in Deductibility. In short: the non-deductible tax becomes part of the deductible cost for income tax, and depreciable assets depreciate on that cost.

Zone: Depreciation (expenses)

If the expense is a capital asset that depreciates over several years, tick «depreciable». A small depreciation assistant unfolds:

  • You choose the asset type (equipment, furniture, vehicles…) from your regime's official tables.
  • Cuéntamo proposes the default yearly rate (the table maximum) and you can adjust it with min/max shortcuts. If the regime allows it and you are a small-sized company, it offers accelerated depreciation (by a factor). It warns if the percentage falls outside the table range and estimates in how many years the asset will depreciate.
  • For low-value assets under the yearly cap, it automatically proposes free depreciation (deducting 100% at once). It also offers free depreciation in the cases the regime contemplates (R&D, for example), with its warning.

On save, the asset moves to the capital-assets book, where you'll see its schedule and depreciation progress.

Zone: Linked movements (payments)

An invoice can be paid or collected in several movements (deferred or partial payments). This zone shows a progress bar (paid over the fiscal total) and the list of linked payments, each with its concept, date and amount, and buttons to edit the movement or unlink it. Payments that are still forecast are marked as such.

To add a payment, the «Link existing movement» button opens a candidate finder: you filter by real/forecast, text, date range and amount, and Cuéntamo prioritises the ones that fit (marking exact or approximate matches). If the movement was already linked to another document, it asks to confirm the reassignment; if it's a personal movement, it warns before linking it. When the invoice and its payments don't reconcile due to an exchange difference, it offers to create an automatic adjustment.

Below, a payment status selector lets you leave it on automatic (computed from the payments) or force it to unpaid, partial, paid or written off (with a reason). And a deferred payments sub-block configures the number of instalments and their frequency; it can even generate a recurring template that creates the future instalments. All of this is explained in depth in Deferred payments.

Zone: Notes

A free-text field for any note about the document (internal references, clarifications, etc.). When you mark a document as written off, the reason is also stored here.

Find matches: linking orphan documents

When you import invoices or create documents with no movement, they remain orphans (marked with «!»). The «Find matches» button opens a window that, for each orphan income or expense document, proposes the real movements in your bookkeeping that fit by amount and date. Each candidate shows its concept, amount and date, and warns if it's a forecast or a personal movement (in which case it asks for confirmation). Clicking «Link» marries the document and the movement and removes them from the pending list.

You can also delete an orphan document directly from its row if it doesn't correspond to any movement.

Import and export Excel

The export downloads the active book of the year as an XLSX file with all its columns, including orphan documents. It's what you can hand to your accountant or keep as a copy.

The import (income and expense books) uploads a CSV/XLS/XLSX/ODS file and processes it with a step wizard: format detection, preview of how the rows were interpreted, column mapping (invoice date, amount, concept, number, third party, tax ID, tax rate, withholding…) and apply. During the preview, Cuéntamo detects rows that already exist or that can be paired with movements and lets you decide what to create, link or skip. It's different from the bank statement import: here you import invoices, not account movements.

A configurable module

Everything that depends on the country and tax regime —the number and names of the books, the indirect tax (VAT or another), whether there are withholdings, the available rates, the income-tax boxes, the depreciation tables, the tax-ID label— comes from your active regime, it isn't hard-coded. The record books and their editor adapt to whatever applies to your activity.

The record books are part of the self-employed module. Its activation, the regime and the module's overview are explained in Self-employed; the computations fed by these books (quarterly returns and income-tax summary), in Tax forecast.

Ready to try it?

Set up your balance forecast in a few minutes. Free.

Create a free account