Pennylane

Interact with Pennylane accounting API

Actions105

Bank Account Actions
- Create
- Get
- List
- List Establishments
Billing Subscription Actions
- Create
- Get
- List Invoice Line Sections
- List Invoice Lines
- Update
Category Actions
- Create
- Get
- List
- Update
Category Group Actions
- Get
- List
Commercial Document Actions
- List
- List Appendices
- List Invoice Line Sections
- List Invoice Lines
- Upload Appendix
Customer Actions
- Create Company
- Create Individual
- Get
- Get Company
- Get Individual
- List
Customer Invoice Actions
- Create
- Create From Quote
- Delete
- Finalize
- Get
- List
- List Appendices
- List Categories
- List Invoice Line Sections
- List Invoice Lines
- List Matched Transactions
- List Payments
- Mark As Paid
- Match Transaction
- Send By Email
- Update
- Update Categories
- Update Imported
- Upload Appendix
Export Actions
- Create Analytical GL
- Get Analytical GL
- Create FEC
- Get FEC
File Attachment Actions
- Upload
GoCardless Mandate Actions
- Associate To Customer
- Cancel
- Get
- List
- Send Email Request
Journal Actions
- Create
- Get
- List
Ledger Entry Actions
- Create
- Update
Ledger Entry Line Actions
- Get
- Get Changes
- Letter
- List By Entry
- List Categories
- List Lettered Lines
- Unletter
Product Actions
- Get
- Get Changes
- List
- Update
Purchase Request Actions
- Get
- Import
- List
Quote Actions
- Create
- List
- List Invoice Line Sections
- List Invoice Lines
- Update
- Update Status
SEPA Mandate Actions
- Create
- Delete
- Get
- List
- Update
Supplier Actions
- Get
- Get Changes
- Update
Supplier Invoice Actions
- Get
- Import
- List
- List Matched Transactions
- List Payments
- Match Transaction
- Unmatch Transaction
- Update
- Update Payment Status
Transaction Actions
- Create
- Get
- Get Changes
- List
- List Categories
- List Matched Invoices
- Update
User Actions
- Get Me

Export → Create Analytical GL

AI-generated

Summary

Create an analytical general ledger export for a specified date range from Pennylane's accounting API.

Inputs

Start Date (required) — The start date for the export in date-time format.
End Date (required) — The end date for the export in date-time format.
Additional Fields — Optional parameters including a comma-separated list of journal IDs to include and the export format (CSV or Excel).
Request Options — Advanced settings such as batching (throttling requests), SSL certificate validation bypass, proxy configuration, and request timeout in milliseconds.

Output shape

a single analytical general ledger export file in the specified format (CSV or Excel).

The export corresponds to the specified date range and optional filters. Pagination or batching may be governed by request options but the output is typically one export file per execution.

Examples

Example 1: Export analytical GL for Q1 2024 in CSV format including specific journals.

Start Date set to 2024-01-01, End Date set to 2024-03-31, Additional Fields with Journal IDs '123,456' and Format 'csv'.

PennylaneInstall