Skip to content

Invoice register and sales ledger

Export saved invoices and credit notes into a clean Excel workbook or CSV register.

Source and filters
Reading saved documents from this browser…
Document types

Register preview (0)

No saved invoices or credit notes are stored in this browser yet. Create documents in the Invoice generator, open a FreeToolsDock .json backup, or preview a sample register.

How to use Invoice register and sales ledger

  1. Choose your data source. Read documents saved in this browser automatically, click Load backup (.json) to inspect an archive file, or click Load example to preview 5 sample records.
  2. Filter the register. Narrow rows by From date, To date, Currency, Status, Document types, or a customer and reference search query.
  3. Review currency summaries. Check net, tax, reverse-charge VAT, CIS deductions, gross totals, and open balances separated by currency.
  4. Export your workbook. Click Export Excel (.xlsx) for a multi-sheet workbook or Export CSV for a flat register file.

Everything you type stays in this browser on your device. Nothing is uploaded, and your saved details are never sent anywhere.

Sales ledger columns, worksheet structure, and filtering

The register transforms locally saved invoices, credit notes, debit notes, receipts, and sales orders into an audit-ready sales daybook in your browser. Workbooks conform to the ECMA-376 Office Open XML Standard, producing three structured tabs: Register, Currency summary, and an optional Line items sheet.

If you have not created documents yet, click Load example to inspect 5 sample GBP and USD records, or create and save new customer invoices in your browser first. All filtering and workbook assembly run inside a Web Worker with 0 bytes uploaded.

Reading browser IndexedDB records or JSON backup files

On load, the island reads saved documents from browser IndexedDB automatically. To inspect an archive from another computer, click Load backup (.json) and choose a FreeToolsDock backup file up to 20 MB in size.

Loading a backup file previews its records strictly in memory without overwriting your active browser storage. Click Use browser storage whenever you want to return to your local device ledger. Each row is assigned an automatic status (Open, Overdue, Paid, Credit, or Debit) based on document kind, paid amount, and due date.

Filtering by date range, currency, status, and document type

Use From date, To date, Currency, Status, and Search customer, number or reference to isolate a quarterly VAT period or overdue accounts. Checkboxes under Document types let you include or exclude invoices, credit notes, debit notes, receipts, and sales orders.

Worksheet or format Primary purpose Key columns included
Register (.xlsx tab 1) Chronological sales daybook Date, type, number, customer, tax ID, currency, net, tax, reverse tax, gross, CIS, paid, balance, status
Currency summary (.xlsx tab 2) Per-currency reconciliation Currency, count, overdue count, overdue balance, net, tax, reverse tax, gross, CIS, paid, balance
Line items (.xlsx tab 3) Granular item audit Parent invoice number, date, description, quantity, unit price, tax code, line net, line tax
Flat register (.csv) Universal accounting import RFC 4180 quoted register rows with UTF-8 BOM and formula-injection protection

Why do credit notes, reverse-charge VAT, and CIS use separate columns?

Mixing customer refunds, reverse-charge supplies, and contractor tax withholdings into a single tax column distorts VAT return figures and breaks spreadsheet reconciliation. Isolating each adjustment type in its own signed column ensures every SUM formula ties directly to your VAT account and cash receipts.

Negative signing for credit notes and SUM formula accuracy

Under HMRC VAT Notice 700/21 Record Keeping, your sales daybook must link issued invoices and credit notes clearly to periodic VAT returns. This exporter writes credit note net, tax, and gross values as negative numbers so column totals reflect true net sales.

When you need to issue a formal adjustment before exporting your period ledger, generate a matching credit note PDF maker for customer refunds document so the negative entry appears automatically.

Isolating reverse-charge VAT and UK CIS deductions

Reverse-charge B2B transactions do not collect output VAT from the customer, so placing them in a dedicated reverseTax column prevents overstating tax owed to the tax authority. Similarly, UK Construction Industry Scheme (CIS) withholdings appear in cisDeduction rather than reducing gross invoice value. Keeping both columns distinct lets your bookkeeper reconcile VAT returns and subcontractor statements without manual spreadsheet edits.

Comparing multi-sheet Excel workbooks against RFC 4180 CSV

Choose Export Excel (.xlsx) when you want ready-to-review summary tabs and typed numeric cells, or choose Export CSV when importing flat transaction rows into external bookkeeping software. Both exports reflect your active date, status, and currency filters.

Separating multi-currency totals in the Currency summary tab

Adding GBP, EUR, and USD amounts into one grand total produces meaningless accounting numbers. The Currency summary tab groups rows by ISO currency code so each currency displays its own document count, overdue count, overdue balance, net sales, tax, and open balance.

Each currency section also preserves dedicated totals for reverse-charge VAT and CIS deductions, giving bookkeepers clean period figures without manual pivot tables.

UTF-8 BOM encoding and spreadsheet formula-injection safety

The CSV generator follows the IETF RFC 4180 CSV Specification with double-quoted text fields and CRLF line breaks, prefixed by a UTF-8 BOM for Excel compatibility. It also neutralizes leading =, +, -, and @ characters in text cells to block formula injection. If you need to reformat raw CSV tables later, convert raw tabular CSV exports into formatted spreadsheets locally.

Audit trails, local privacy, and tax compliance boundaries

Consistent sales registers substantiate gross receipts and tax deductions under rules such as the IRS Small Business Recordkeeping Guide. Because all parsing and XLSX generation run inside your browser tab, 0 bytes of confidential client revenue ever leave your device.

Archiving both your monthly .xlsx workbooks and underlying .json backups gives your bookkeeper a verifiable trail linking individual invoices, credit notes, and cash receipts across multi-year retention windows.

Tip: Uncheck Include a third worksheet with individual line items when sharing high-level revenue summaries with a bookkeeper, or leave it checked for year-end item-level audits.

For property-specific payment tracking, pair your general billing exports with the Rent ledger tool. This exporter is designed for informational and operational bookkeeping convenience rather than certified tax or accounting advice; confirm VAT, MTD, and statutory retention rules with a qualified accountant.

Questions

How are credit notes handled in the exported spreadsheet?

Credit note net, tax, and gross amounts are written as negative numbers in both the Register and Currency summary sheets. That way standard spreadsheet SUM formulas reconcile net sales and collected tax without manual sign adjustments.

Does the sales ledger mix multiple currencies into one total?

No. Every document row retains its own ISO currency code, and the Currency summary worksheet calculates separate subtotals for each currency so GBP, EUR, and USD balances are never added together.

Will opening a backup JSON file overwrite my current browser invoices?

No. Selecting Load backup (.json) parses and previews the backup file strictly in memory for filtering and export. Click Use browser storage at any time to switch back to your device's IndexedDB records.

How are reverse-charge VAT and UK CIS deductions displayed?

Reverse-charge VAT and UK Construction Industry Scheme (CIS) deductions are placed in dedicated columns rather than merged into standard collected tax. This separation keeps VAT return boxes and subcontractor deductions transparent.

What is included in the optional Line items worksheet?

When Include a third worksheet with individual line items is checked, the Excel export appends a Line items tab listing each document's SKU or description, quantity, unit price, tax rate, and line total alongside its parent invoice number.

How does the CSV export protect against spreadsheet formula injection?

Every text cell is sanitized so values starting with equals, plus, minus, or at signs are safely neutralized before quoting. The file also includes a UTF-8 BOM so Excel opens accented customer names and currency symbols cleanly.

Updated