> ## Documentation Index > Fetch the complete documentation index at: https://docs.lastaccountingcompany.com/llms.txt > Use this file to discover all available pages before exploring further. # Get the transactions window > One keyset-paged window over the full transaction row universe: bank rows, ledger-only entries (sales summaries, imported history, manual entries), and payslip rows. needs_receipt means an OPEN customer ask (missing, requested, or inadequate) — evidence already in hand and under review does not count. Status, date range, open-periods scope, and the dimension filter all run in the database; the first (un-cursored) page carries whole-history totals and, under status=needs_receipt, the this-week/older buckets. ## OpenAPI ````yaml /openapi.yaml get /lens/transactions openapi: 3.1.0 info: title: LAC Customer API version: '2026-07-15' description: > Last Accounting Company (LAC) is an AI-native accounting firm for Finnish SMBs: continuous reconciliation, daily close, real-time dashboards, and full Vero reporting. This API is the same surface the LAC customer portal UI uses. It gives you programmatic access to your books (read-only general-ledger views), financial statements, documents, invoicing, payroll, source-system connections, and the message channel to Björn, the accounting agent. ## Authentication Every request carries `Authorization: Bearer `. Two token kinds are accepted: - **Portal API key** (`lac_sk_...`) — minted in portal Settings → API access. Keys have a scope of `read` or `write`. Read-scoped keys are refused on all mutating methods (POST/PATCH/DELETE). Write-scoped keys act as the `operator` role: they can never use payroll endpoints (reads included), change company settings, grant access, approve or return an invoice, or manage API keys. Payroll and company settings require an interactive admin or existing broad approver. Invoice decisions require the matching invoice review permission. Write-scoped keys can prepare draft partner seller profiles. An interactive company admin must review the evidence and activate a profile or change an active profile. - **Firebase ID token** — the interactive session token used by the portal UI itself. API keys are pinned to a single company, so the `customer_id` parameter (query string on GETs, body field on writes) can always be omitted when authenticating with an API key. Interactive tokens with access to multiple companies use `customer_id` to select one. ## Conventions - All field names are `snake_case` on the wire. - Monetary amounts are **integer cents** (fields suffixed `_cents`). - Rates and percentages are **basis points** (fields suffixed `_basis_points`; 10000 = 100%, e.g. Finnish standard VAT 25.5% = 2550). - Quantities on invoice lines are decimal strings (e.g. `"1"`, `"2.5"`). - Dates are `YYYY-MM-DD`; periods are `YYYY-MM`; ranges accept `YYYY-MM`, `YYYY-Qn`, `YYYY`, `all`, `this_month`, or `last_6_months`. ## Limits - Document uploads: at most 20 files and 25 MB per request. - Sheet pagination: `limit` is capped at 200 rows per page (0 = unpaginated). ## Errors Errors return a JSON envelope `{"error": "...", "detail": "..."}` with a conventional HTTP status code (401 missing/invalid token, 403 insufficient scope or role, 404 not found, 422 validation failure). More at [docs.lastaccountingcompany.com](https://docs.lastaccountingcompany.com). contact: name: Last Accounting Company url: https://docs.lastaccountingcompany.com servers: - url: https://api.app.lastaccountingcompany.com/portal description: Production (note the /portal base path). security: - apiKey: [] tags: - name: Company description: Company profile, identity, overview, and agent status. - name: Onboarding description: Saved customer onboarding facts, source inventory, and opening statements. - name: Books description: >- Read-only windows into the canonical general ledger: the spreadsheet-style Books/VAT sheet, financial statements, and analytics. There is no cell-edit or batch-edit API — the books are maintained by LAC. The one write here is a row declaration: your answer about a row (no receipt exists, private, a split, or a different booking), recorded as evidence for Björn. - name: Dimensions description: >- Project, cost-centre, department, and customer-defined reporting lenses over posted general-ledger lines. Provider catalogs are read-only; local axes and values are available for bank/file-only books. - name: Documents description: Receipt/invoice/contract uploads and per-file ingest metadata. - name: Messages description: The chat channel to Björn, the accounting agent. - name: Work log description: >- Append-only work-hours log (date, minutes, note). Hours are records for invoicing and payroll evidence; they do not post to the books. Kilometres are not logged here — vehicle travel is submitted as an expense claim in the portal, where statutory reimbursement rates apply. - name: Filings description: Filing authorization, review requests, and produced output packages. - name: Invoicing description: >- Sales invoicing — drafts, partner seller profiles, e-invoice sending, PDF finalizing, credit notes, reminders, recurring templates, and the invoice-customer register. LAC sends buyer invoices on the e-invoice network only. A partner-profile invoice also sends its legal seller a bookkeeping PDF copy. - name: Payroll description: >- Payroll workspace — employees, tax cards, employer settings, draft runs, and payslips. Every payroll operation (reads included) requires an interactive admin or existing broad-approver session and is NOT available to API keys. - name: Payments description: >- Contextual review and named-human release for source-bound purchase, payroll, and reimbursement payments. There is no manual payment composer and no bank file: a batch that cannot be delivered directly to the bank fails closed rather than becoming the customer's manual task. - name: Connections description: >- Source-system connections (bank, settlement providers, commerce, accounting systems, inbox/Gmail, Google Sheets) and service-connection requests/confirmations. PayPal consent can start through this API and returns a URL that a company admin must open. Other browser-interactive consent flows remain portal-only. - name: Imports description: Historical import runs (e.g. migrated books) and their artifacts. - name: API keys description: >- Manage portal API keys. These endpoints require an interactive admin session (Firebase token) and are NOT available to API-key bearers, which receive 403. - name: Lens description: >- Typed, display-ready read models over the books: the transactions window (full row universe, three-state status, keyset pagination), the per-row booking view, data coverage, and the connections catalog. - name: Accounting description: >- The accountant's read models: general ledger, journal entries, context cards, the filings strip with previews, and the SQL explorer. Every endpoint here requires LAC staff access or the company admin role; other bearers receive 403. paths: /lens/transactions: get: tags: - Lens summary: Get the transactions window description: >- One keyset-paged window over the full transaction row universe: bank rows, ledger-only entries (sales summaries, imported history, manual entries), and payslip rows. needs_receipt means an OPEN customer ask (missing, requested, or inadequate) — evidence already in hand and under review does not count. Status, date range, open-periods scope, and the dimension filter all run in the database; the first (un-cursored) page carries whole-history totals and, under status=needs_receipt, the this-week/older buckets. operationId: getLensTransactions parameters: - name: customer_id in: query schema: type: string - name: limit in: query schema: type: integer maximum: 500 - name: cursor in: query schema: type: string description: Opaque keyset cursor from window.next_cursor. - name: status in: query schema: type: string enum: - done - needs_receipt - under_review - name: from in: query schema: type: string format: date - name: to in: query schema: type: string format: date - name: scope in: query schema: type: string enum: - open_periods - name: dimension_axis_id in: query schema: type: string - name: dimension_value_id in: query schema: type: string responses: '200': description: Rows plus window metadata. content: application/json: schema: type: object properties: customer_id: type: string as_of: type: string format: date-time rows: type: array items: type: object properties: row_id: type: string kind: type: string enum: - bank - entry - payslip booking_date: type: string format: date amount_cents: type: integer currency: type: string counterparty_name: type: string description: type: string status: type: string enum: - done - needs_receipt - under_review receipt_flagged_at: type: string format: date-time source: type: object properties: name: type: string brand_key: type: string live: type: boolean journal_entry_id: type: string evidence_count: type: integer resource_ref: type: object description: >- Exact canonical identity; omitted only for a derived payslip row. required: - uri - revision properties: uri: type: string format: uri revision: type: string window: type: object properties: limit: type: integer cursor: type: string next_cursor: type: string total: type: integer needs_receipt: type: object properties: this_week: type: integer older: type: integer excluded_closed_or_historical: type: integer '401': $ref: '#/components/responses/Unauthorized' '403': $ref: '#/components/responses/Forbidden' components: responses: Unauthorized: description: Missing or invalid bearer token. content: application/json: schema: $ref: '#/components/schemas/Error' Forbidden: description: >- Insufficient scope or role — e.g. a read-scoped key on a mutating method, or an API key on an interactive-session-only endpoint. content: application/json: schema: $ref: '#/components/schemas/Error' schemas: Error: type: object description: Standard error envelope. properties: error: type: string description: Machine-readable error message. detail: type: string description: Human-readable detail. securitySchemes: apiKey: type: http scheme: bearer bearerFormat: lac_sk_... description: >- Portal API key minted in portal Settings → API access. Scope `read` or `write`; pinned to one company. Send as `Authorization: Bearer lac_sk_...`. ````