Aantar

Aantar Books

Condense Data

Make an old company file smaller by summarising closed history into one journal entry per month, after saving a read-only archive of everything first.

Where: Accountant ▸ Condense Data…

Condense Data shrinks a company file that has grown large by replacing old, closed transactions with a summary. The balances of every account stay exactly the same. Before it changes anything, it saves an archive copy of the whole company so the detail is never lost.

Before you start

Condense only works when all of these are true:

  • The Condense through date is before today.
  • A closing date is set, and it is on or after the date you choose. Closed history is what gets condensed.
  • The file is not read-only (an archive or a Period Copy cannot be condensed).
  • No Accountant's Copy is out.

If one of these fails, Aantar Books says which, and changes nothing.

Run it

  1. Open Accountant ▸ Condense Data….
  2. Enter Condense through (YYYY-MM-DD). If your company has a password, also enter This company's password, which the archive needs.
  3. Choose what to do:
    • Remove closed transactions and keep a summary of each month. This is the real condense.
    • Keep every transaction and remove only the audit trail. Nothing but the activity log and old journal history through the date is removed.
  4. Tick Make an archive copy first and then condense this company. This cannot be undone here. The Condense button stays off until you do.
  5. Click Condense.

What happens

  1. Archive. Aantar Books saves a file named like Company name (Archive 2026-09-30).sbo next to your company file. It opens like any company and holds every document, but it is read-only: it refuses every change and is only for looking things up. If a file with that name already exists, the run is refused.
  2. Closed documents are removed. Closed means a paid invoice, bill or expense through the date, with every ledger line and payment dated on or before it, and nothing reconciled or in a bank deposit.
  3. A summary is kept. Their ledger lines are added up by month, account, location, class, job and customer or vendor, and posted as one journal entry for each month (reference CONDENSE yyyy-mm, dated the last day of the month, and never later than the date you chose). Aging by customer or vendor still works for what the journals hold.
  4. Checked. The net balance of every account is compared before and after. If any differ, you are told, and the archive is named so you can go back.

Everything runs as one step: if anything is refused, the file is left as it was.

What is kept

The report after the run lists, under Kept, what was left alone and why:

  • Unpaid or partly paid invoices and bills.
  • Purchases whose items are still in stock, because they carry the cost history.
  • Documents that something you kept refers to, such as a return or credit.
  • Anything reconciled, in a bank deposit, in a foreign currency, in a payment run or a daily summary, or with an advance.
  • Journal entries tied to depreciation, tax filings, deposits or reversals, and any that are reconciled.

The report also shows Documents removed by type, Summary journals, Ledger lines summarised, and Documents before and after. The audit trail and journal history stay, except under the second option.

Good to know

  • Unused list entries (customers, items) are not removed.
  • The file keeps its size on disk until its next backup, which rewrites it compactly.
  • Condense cannot be undone here. To get the detail back, open the archive.

Related articles

Something unclear or out of date? Write to support@aantar.com and name this page.