> ## Documentation Index > Fetch the complete documentation index at: https://docs.layerfi.com/llms.txt > Use this file to discover all available pages before exploring further. # Export balance sheet as CSV > Exports a balance sheet report as a CSV file. Returns a pre-signed URL for downloading the generated CSV file. ## OpenAPI ````yaml get /v1/businesses/{businessId}/reports/balance-sheet/exports/csv openapi: 3.0.1 info: title: API version: latest servers: [] security: - BearerAuth: [] tags: [] externalDocs: url: / paths: /v1/businesses/{businessId}/reports/balance-sheet/exports/csv: get: tags: [] summary: Export balance sheet as CSV description: >- Exports a balance sheet report as a CSV file. Returns a pre-signed URL for downloading the generated CSV file. operationId: business.reports.balance-sheet.exports.csv.get parameters: - name: businessId in: path description: The UUID of the business to export the balance sheet for. required: true schema: type: string - name: Content-Type in: header description: Content-Type must be set to application/json. schema: type: string - name: effective_date in: query description: Effective date for the balance sheet (ISO 8601 format). required: true schema: type: string format: date-time - name: money_format in: query description: Format for monetary values in the export. schema: type: string enum: - DOLLAR_STRING - CENTS_INTEGER - name: reporting_basis in: query description: Accounting basis for the report. schema: type: string enum: - ACCRUAL - CASH - name: tag_filter in: query description: Filter results by tags. schema: type: string responses: '200': description: Pre-signed URL for downloading the CSV export. headers: {} content: application/json: schema: type: object properties: data: $ref: '#/components/schemas/S3PresignedUrl' required: - data '400': description: Balance sheet not yet reconciled for the requested date. content: application/json: schema: $ref: '#/components/schemas/ApiError' '404': description: >- Business id is not found. This indicates the business id is invalid or the business has been archived. content: application/json: schema: $ref: '#/components/schemas/ApiError' deprecated: false components: schemas: S3PresignedUrl: type: object properties: type: type: string description: Resource type. Value will be 'S3_Presigned_Url'. example: S3_Presigned_Url presignedUrl: type: string description: Pre-signed URL to download a document. example: > https://example-bucket.s3.amazonaws.com/example-object?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=FAKEAWSACCESSKEY%2F20240710%2Fus-west-1%2Fs3%2Faws4_request&X-Amz-Date=20240710T000000Z&X-Amz-Expires=3600&X-Amz-SignedHeaders=host&X-Amz-Signature=FAKESIGNATURE1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef fileType: type: string description: The file type of the document. example: csv fileName: type: string description: The name of the file. example: receipt.pdf createdAt: type: string format: date-time description: When the document or generated file was created. documentId: type: string format: uuid nullable: true description: >- The ID of the stored document. Present when this URL is for a stored business document; omitted for generated downloads such as report CSV/XLSX exports. document_type: $ref: '#/components/schemas/DocumentType' description: >- The type of the stored document. Included on fetch document and on nested `presigned_url` objects from list documents. Omitted for generated report CSV/XLSX downloads. nullable: true required: - presignedUrl - fileType - fileName - createdAt description: A pre-signed URL to download a document or generated file. ApiError: type: object description: An error object returned in API error responses. properties: type: $ref: '#/components/schemas/ApiErrorType' description: >- A fixed category for the error, helpful for categorizing and processing errors. description: type: string description: A human-readable error description. error_enum: $ref: '#/components/schemas/ApiEnumErrorType' description: >- A stable, machine-readable identifier for programmatically handling specific error conditions. Only present for 4xx client errors—not included for 5xx server errors. Use this instead of parsing the description field, as enum values remain stable across API versions. nullable: true meta: type: object description: Optional additional information about the error. nullable: true required: - type - description DocumentType: type: string enum: - RECEIPT - UNSTRUCTURED_BOOKKEEPING_CONTEXT - OTHER description: >- The type of document. RECEIPT is for receipts and invoices. UNSTRUCTURED_BOOKKEEPING_CONTEXT is for general bookkeeping context documents. OTHER is for any other document type. example: RECEIPT ApiErrorType: type: string enum: - ResourceArchived - AuthFailure - Plaid - Stripe - InvalidState - ResourceNotFound - InvalidParameters - JsonSerialization - Unknown - BadRequest - PaginationCursor - Conflict - LedgerOperationFailed example: InvalidParameters ApiEnumErrorType: type: string description: >- Stable enum values for programmatic error handling. Only present in 4xx error responses. enum: - AccessCodeInvalid - BalanceSheetDoesNotBalance - BalanceSheetMissingAccount - BankStatementParserError - BillStateError - BulkCategorizeFailure - BulkMatchFailure - BusinessTaskAlreadyCompleted - BusinessTaskDeleted - CalendlyOAuthError - CallBookingError - CantUpdateTransactionInCustomerPayout - CantUpdateTransactionInVendorPayout - CheckPayrollConfigNotFound - CheckPayrollServiceNotFound - ClerkUserAlreadyExists - ConflictingQueryParams - CustomAccountAlreadyExists - CustomTransactionCsvParsingError - CustomTransactionUploadFailure - CustomerPayoutInputFormatError - DoesNotMatchExistingEntity - EmptyBatchRequest - ExpenseParserError - ExternalAccountBalanceReconciliationError - ExternalIdConflict - InvalidCategory - InvalidEffectiveDate - InvalidLedgerOperation - InvalidMonthlyAverageRange - InvalidMultiPartRequest - InvalidPaginationCursor - InvalidPayload - InvoiceDeleted - InvoiceNotFound - InvoiceReferenceMismatch - InvoiceStateError - ManualRateLimit - MultipleTagKeyFiltersUnsupported - NoCognitoUserFound - NoOpeningBalanceFound - NotYetReconciled - OnePasswordApiError - OnePasswordItemNotFound - OnePasswordVaultNotFound - OpenAICategorizationError - PaymentLinkInvalid - PayrollStateError - PeriodIsClosed - PeriodNotClosed - PhoneNumberAlreadyRegistered - PlaidApiError - PlaidConnectionBroken - PlaidCreateLinkTokenError - PlaidCredentialsNotConfigured - PlaidExchangePublicTokenError - PlaidGetInstitutionByIdError - PlaidGetItemError - PlaidInvalidEnvironment - PlaidItemAlreadyExists - PlaidItemNotFound - PlaidProcessorApiError - PlaidUnlinkItemError - QueryParamFormat - QueryParamMissing - QuickbooksBrokenConnection - QuickbooksConnectionAlreadyExists - QuickbooksConnectionAlreadySyncing - QuickbooksConnectionMissing - QuickbooksConnectionNotActivated - QuickbooksInvalidRequest - QuickbooksInvalidState - QuickbooksNoMatchingAccount - QuickbooksNonPostingAccountType - QuickbooksNotConfigured - QuickbooksOAuthCallbackInvalid - QuickbooksOAuthError - QuickbooksTokenExpired - ResourceArchived - ScheduleCNotConfigured - SmsNotEnabled - SpecifiedBadRequest - SpecifiedIdNotFound - SplitTransactionError - StepEvaluationBadRequest - StripeConnectAccountIdNotFound - StripeCredentialsNotConfigured - StripeGetBalanceForConnectAccountFailure - StripeRedirectOrRefreshUrlNotConfigured - TagFilterNotFound - UnexpectedQueryParam - UnitAccountsInUse - WrongAnswerType example: InvalidPayload securitySchemes: BearerAuth: type: http scheme: bearer bearerFormat: JWT ````