> For the complete documentation index, see [llms.txt](https://docs.quanti.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.quanti.io/connectors/sales-analytics-connectors/pennylane.md). # Pennylane Prebuilt reports and definition *** ## Prerequisites Before connecting Pennylane to QUANTI, ensure you have: * **Pennylane Account**: An active Pennylane account with appropriate access level * **API Access**: Administrator or Accountant role to generate API credentials * **Active Company**: At least one company configured in your Pennylane account * **Financial Data**: Existing invoices, transactions, or accounting data to synchronize *** ## Setup Instructions {% stepper %} {% step %} **Generate API Token** * Log in to your Pennylane account * Navigate to **Settings** > **Connectivity** > **data sharing** * Click on **Generate new API token** * Copy the generated token immediately (it will only be shown once) * Store it securely {% endstep %} {% step %} **Connect to QUANTI** * In QUANTI, click on **Connect to Pennylane** * Paste your API token in the authentication field * Click **Validate** to verify the connection * Select the company you want to synchronize data from * Click **Next** {% endstep %} {% step %} **Connector Information** * **Connector Name**: Define a unique name for your connector * **Dataset ID**: Specify the BigQuery dataset ID where tables will be created * The dataset will be created automatically if it doesn't exist * Click **Next** {% endstep %} {% step %} **Select Prebuilt reports** * Review the available Prebuilt reports (see section below for details) * All tables are selected by default - you can deselect tables you don't need * Recommended: Keep all tables enabled for complete financial data tracking * Click **Next** {% endstep %} {% step %} **Finish setup** * Define a sync period and a lookback window - Click save * For the first sync, you have the following options: * Activate auto-sync for recurring syncs based on your sync settings by clicking the switch button * Launch a historical data recovery by choosing your desired dates in the historical data tab * Launch a manual sync immediately by clicking the Sync now button * Wait for the sync to complete. Then navigate to your data warehouse to verify that tables are populated * Check the connector dashboard for sync status and any potential errors {% endstep %} {% endstepper %} *** ## Prebuilt reports * **analytical\_ledger**: All accounting entries with analytical tags at the most granular level. Includes company information, dates, labels, debit/credit amounts, account details, journal codes, document references, invoice links, third party information, analytical tags, and synchronization timestamps. * **bank\_accounts**: Bank accounts linked to Pennylane. Contains account details including establishment information, connection type, associated accounting plan items, currency, synchronization status, balance, and timestamps. * **bank\_transactions**: Bank transactions with execution dates and payment status. Includes transaction details, company and third party information, amounts in EUR and original currency, source, duplicate detection flags, SFTP/EBICS file information, and status indicators. * **general\_ledger**: All journal entries at the most granular level for comprehensive accounting records. Contains company information, dates, labels, debit/credit amounts, account details, journal codes, document and invoice references, third party information, and creation metadata. * **companies**: Legal entities with registration details and platform configuration. Includes company name, trade name, registration numbers, VAT details, address information, SaaS plan, accounting settings (cash-based, VAT frequency), fiscal information, activity codes, legal form, and timestamps. * **company\_users**: Users associated with companies. Contains user identification (email, first name, last name), company association, role, last activity date, accounting firm information, invitation timestamps, and synchronization data. * **customer\_invoices**: Invoices issued to customers. Includes creation and issue dates, payment deadline, company and customer information, amounts (including and excluding taxes), currency, invoice number, source, payment status, outstanding balance, and timestamps. * **customers**: Client data with identification and location. Contains customer name, company association, VAT rate, accounting plan items, address details, registration numbers, VAT numbers, activity codes, legal information, and synchronization timestamps. * **fiscal\_years**: Fiscal year periods. Includes company information, fiscal year dates (start and end), descriptor, closure timestamp, and synchronization data. * **supplier\_invoices**: Supplier invoices received through various channels. Contains creation and issue dates, payment deadline, company and supplier information, amounts (including and excluding taxes), currency, invoice number, source, payment status, and timestamps. * **suppliers**: Vendor legal entities. Includes supplier name, company association, VAT rate, accounting plan items, address details, registration numbers, VAT numbers, activity codes, legal information, and synchronization timestamps. * **tax\_declarations**: Tax declarations submitted to tax authorities. Contains company information, declaration type and form, declaration period dates, status indicators (declaration and payment validation), payment amount, rejection reasons if applicable, and timestamps. *** Prebuilt reports and definition *** ## Notes * **Data Refresh**: Pennylane data can be synchronized multiple times per day depending on your subscription plan * **Historical Data**: Full historical data is available with no API limitations on date ranges * **Real-time Sync**: For critical financial operations, use manual sync to get the most up-to-date data * **Currency**: All amounts are stored in the company's default currency as configured in Pennylane * **VAT Rates**: VAT rates are stored as decimal values (e.g., 0.20 for 20%) * **Invoice Status**: Invoice statuses include: draft, pending, paid, partially\_paid, late, cancelled * **Payment Terms**: Payment terms are stored in days (e.g., 30 for "30 days net") * **API Rate Limits**: Pennylane enforces rate limits on API requests. QUANTI automatically manages these limits to ensure reliable data extraction * **Accounting Standards**: Data follows French accounting standards (Plan Comptable Général) *** ## Troubleshooting
Connection Issues * Verify that your API token is valid and hasn't expired * Ensure your Pennylane account has Administrator or Accountant permissions * Check that API access is enabled in your Pennylane subscription plan * Verify that the selected company is active in Pennylane
Missing Data * Draft invoices may not be synchronized by default * Archived transactions or documents may be excluded * Check date filters in your sync configuration * Some data may require specific Pennylane modules to be activated
Data Discrepancies * Ensure all invoices are validated/finalized in Pennylane before sync * Check that journal entries are posted (not in draft status) * Verify that the sync period covers the expected date range * Compare amounts in the base currency if multi-currency is enabled
Need Help? Contact QUANTI support at or consult our comprehensive documentation at [https://docs.quanti.io](https://docs.quanti.io/)
--- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.quanti.io/connectors/sales-analytics-connectors/pennylane.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.