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.