--- title: "General Ledger reports (PAS)" slug: "general-ledger-reports-pas" tags: ["ai gl", "plain language", "AI report", "ai customize"] updated: 2026-08-20T22:10:41Z published: 2026-08-20T22:10:41Z canonical: "help.wrapbook.com/general-ledger-reports-pas" --- > ## Documentation Index > Fetch the complete documentation index at: https://help.wrapbook.com/llms.txt > Use this file to discover all available pages before exploring further. # General Ledger reports (PAS) ## Overview A General Ledger (GL) report in Wrapbook is a comprehensive record of all financial transactions in the accounting system. It allows production accountants to: - View all posted transactional debit and credit activity for every account - Research and audit specific transaction data across different dimensions like accounts, periods, and tags - Generate customized reports with filters for various data points The GL report can be exported in multiple formats: - PDF (sorted and subtotaled by account code) - XLSX (includes formulas and subtotals) - CSV (raw data export) ## How to create a GL report In order to create a GL report, Wrapbook’s [Production Accounting Suite](/v1/docs/about-production-accounting) must be enabled. Once PAS is enabled, you can begin creating your report by going to the *Generate a general ledger report* page: 1. In the left-side navigation, click the dropdown menu 2. In the dropdown menu, select the name of the project that you want to access the GL for 3. In the left-side navigation, expand the ***ACCOUNTING*** menu, and click **Accounting reports** 4. On the *Accounting reports* dashboard, click the **Create report** button next to *General ledger* ![Form to generate a general ledger report with various filter options and settings.](https://cdn.us.document360.io/67f3ef76-1568-46b4-8047-4792fc3a99ce/Images/Documentation/Untitled - 2026-04-20T120629.967.png) *Example of the Generate a general ledger report page* ### What do you want to see in this report? On the *Generate a general ledger report* page, under *What do you want to see in this report?*, you can use simple conversational language to describe what data you want to include in the report. **Here’s how it works** - Under *What do you want to see in this report?* type a description of the data you want to show in the report **Here’s some examples of requests you can make:** - *Show me all transactions for vendor Home Depot* - *Display all qualified expenses in Louisiana* - *What transactions occurred in the previous period?* - *Show me all post-production costs* ![Interface for generating a general ledger report with filter options for transactions.](https://cdn.us.document360.io/67f3ef76-1568-46b4-8047-4792fc3a99ce/Images/Documentation/Untitled - 2026-03-30T142507.029.png) *Type a description of the information that you want to see in the report* ### GL report manual filters You can also use the *Apply filters* section of the *General ledger report* page to manually select filters. ****Click the arrow to see the complete list of filters**** | **Filter** | **Description** | | --- | --- | | **Eff date** | Filter transactions based on the effective date (start and end date range). | | **Type** | Filter by transaction type: Accounts Payable (AP), Distribution Change (DC), Journal Entry (JE), Payroll (PR), Vendor Payment (VP), Open Purchase Order (Open PO), Petty Cash (PC), and PCard (PX). | | **Transaction start date / Transaction end date** | Select the date range of transactions to display | | **From trx / To trx** | Select a range of transactions based on their reference number. | | **From PO# / To PO#** | Select a range of purchase orders based on their reference number. | | **Transaction status** | Filter by Posted (default), Unposted, or All statuses. | | **Cancelled** | Choose whether to Include (default), Exclude, or show Only cancelled transactions. | | **Posted start date / Posted end date** | Filter transactions based on when they were posted to the General Ledger. | | **Vendor** | Select specific vendors to include in the report. Vendors must be added on the *Vendors* page before they appear as options. | | **V1099** | Select vendors with US tax form 1099 status. | | **Account type** | Filter by account classification: Asset, Liability, Expense, Income, or Equity. | | **1099** | Select transactions that have been assigned a US tax form 1099 tax code. | | **Asset** | Choose whether to show transactions related to production assets. | | **Line description** | Filter transactions by a specific line description — only transactions with a matching line description will be included. | | **Line amount minimum / Line amount maximum** | Filter transactions based on their individual dollar amounts. | | **Include starting/ending balances** | Check to display the starting and ending balances for the selected period range. | | **Paid AP invoices** | Filter to show *Accounts Payable* invoices that have been paid. | | **From pmt / To pmt** | Filter transactions by paid AP invoices payment number range — enter a starting and ending payment number to narrow results to a specific set of payments. | | **Payment start date / Payment end date** | Filter paid AP transactions to a specific date range based on when the payment was made. | | **Ref** | Filter transactions by reference number — enter a reference to find transactions associated with a specific payment or record. | | **From account / To account** | Filter transactions by a chart of accounts range — select a starting and ending account to include only transactions that fall within those accounts. | | **Specific accounts** | Select individual account codes instead of a numeric range. | | **LO** | Filter by work location tag. | | **PRD** | Filter by production or episode tag. | | **SET** | Filter by set tag. | | **FF1** | Select from your customized Free Fields | | **Bank** | Filter transactions associated with a specific bank account. | ### Effective-date reporting for Purchase Orders Use the **Eff date** filter when you need the General Ledger report to reflect transactions and Purchase Order information as of a particular date. For PO-related reconciliation, select the effective-date range that matches the point in time you are investigating. When PO history is available for a project and a PO has changed over time, the PO information in the report reflects the historical state applicable to the selected effective date. This allows you to review PO data as it existed at that point in time instead of seeing only the PO's current state. PO history is available for projects with the **Purchase order history available** setting enabled. For effective dates before **July 24, 2026**, the report shows the PO status as open or closed based on the status on **July 23, 2026**. **Editorial note:** Keep the existing descriptions of transaction date and posted date. Add one sentence explaining that effective date answers a different question: it identifies when the transaction or PO state is effective, while posted date identifies when the transaction was posted to the ledger. ![Form fields for transaction details including dates, types, and vendor information.](https://cdn.us.document360.io/67f3ef76-1568-46b4-8047-4792fc3a99ce/Images/Documentation/Untitled - 2026-04-20T121001.104.png) *Screenshot of the manual filters available on the Generate a general ledger report page* ### GL report settings Before you generate a GL report, you’ll be required to enter the following information in the *Report settings* section: - *Report name* - *Report type (Detail or Summary)* - *Group by (Account code, Account type, Transaction vendor, Line vendor, Transaction type, Transaction #, Ref # Tag (LO), Tag (PRD), Tag (SET), Tag (FF1), Ungrouped)* - *Export format (PDF or CSV)* - *Page size (Letter, Legal, Ledger/RA3 or 2x Ledger/RA2)* #### Show Thousands separator - If you want to display a thousands separator on your GL report, click to enable this option #### Customize Under *Report columns*, you can click the **Customize** button to the following columns: - *Curr* - *LO* - *PRD* - *Account* - *Account description* - *SET* - *FF1* - *TRX* - *TRX date* - *Type* - *Eff date* - *Period* - *Vendor* - *Line description* - *Ref* - *Post date* - *Pmt date* - *Pmt* - *PO* - *1099* - *V1099* - *Asset* - *Amount* After clicking *Customize*, use the customize *Report Columns* popup to: - **Select or remove columns** — check or uncheck the boxes next to each column name - **Rename a column** — click an existing column name and type a new one - **Reorder columns** — hover over the four-dot icon to the left of a column name, then drag it to a new position ![Settings for generating a General Ledger report in PDF format with customization options.](https://cdn.us.document360.io/67f3ef76-1568-46b4-8047-4792fc3a99ce/Images/Documentation/Untitled - 2026-04-09T124445.499.png) *Screenshot of GL settings options. Click the* ***Customize*** *button to choose which columns to include in the report, update column names, and change the column order.* ![Report columns for accounting including account details and transaction information.](https://cdn.us.document360.io/67f3ef76-1568-46b4-8047-4792fc3a99ce/Images/Documentation/Screenshot 2026-04-09 at 12.43.48 PM 1.png) *Check the columns you want to include, click a column name to rename it, and use the four-dot handle to drag it into a new position* ### Preview your GL report In the *Report preview*, you can see the types of data that will appear in the report based on the filters and settings you’ve applied. ### Generate your GL report - On the *General ledger report* page, click the **Generate report** button - After you click the button, your report will begin automatically downloading to your computer. You’ll receive an email once it’s ready. ![Preview of a general ledger report generation with various filter options displayed.](https://cdn.us.document360.io/67f3ef76-1568-46b4-8047-4792fc3a99ce/Images/Documentation/Untitled - 2026-04-20T122716.242.png) *Example of a GL Report preview. Click the* ***Generate report*** *button to begin your download.* ![General ledger report detailing transactions for Airbnb and other vendors with amounts.](https://cdn.us.document360.io/67f3ef76-1568-46b4-8047-4792fc3a99ce/Images/Documentation/Untitled (65).png) *Example of a GL report generated in Wrapbook* ## Create a GL report template Report templates allow you to save your preferred settings for your GL reports. Instead of adjusting settings every time you generate a report, you can create and save templates for quick access to your preferred views. ### Create a template 1. Go to the [Generate a general ledger report page](/v1/docs/general-ledger-reports-pas#how-to-create-a-gl-report) 2. In the *Apply filters* section, add the [filters](https://help.wrapbook.com/docs/general-ledger-reports-pas#gl-report-quick-filters) that you want to use for your report template. Use the *Report preview* to see an overview of what will be included in the report. 3. Once you are satisfied with the way the report is configured, click the **Create template** button 4. In the *Create template* popup, enter a template *Name.* You can click the checkbox to *Set as default* (optional) 5. Click the ***Save*** *button* 6. The template that you’ve just created will now appear as an option in the *Custom template* dropdown menu when you return to the *Generate report* page. If you set the template to be the default, it will automatically be selected in the dropdown menu. ![Interface for generating a general ledger report with various filter options displayed.](https://cdn.us.document360.io/67f3ef76-1568-46b4-8047-4792fc3a99ce/Images/Documentation/Untitled - 2026-04-20T122832.957.png) Click to apply filters, then click the **Create template** button ![Interface for creating a new template with fields for name and default settings.](https://cdn.us.document360.io/67f3ef76-1568-46b4-8047-4792fc3a99ce/Images/Documentation/New template popup.png) *Enter a Name, click to Set as default for this report (optional), and then click the* ***Save*** *button* ![Confirmation message indicating the template has been successfully saved for future use.](https://cdn.us.document360.io/67f3ef76-1568-46b4-8047-4792fc3a99ce/Images/Documentation/Template saved alert.png) *A notification will appear confirming that your template has been saved* ### Set as default, rename, duplicate, or delete an existing template Once a template has been created, you can set it as the default, update its name, duplicate it, or delete it using the following steps: 1. Go to the [Generate a general ledger report page](/v1/docs/general-ledger-reports-pas#how-to-create-a-gl-report) 2. On the *Generate a general ledger report* page, under *Templates*, click the dropdown menu to select the template that you want to update 3. Click the gear icon, and then select an option: *Set as default, Rename, Duplicate,* or *Delete* ![Vendor payments template with date fields and options for managing filters and settings.](https://cdn.us.document360.io/67f3ef76-1568-46b4-8047-4792fc3a99ce/Images/Documentation/Untitled - 2026-04-20T123257.464.png) *Select the template, click the gear icon, and then make your selection* ### Updating a template - If you make changes to a template, a *Save changes* button will appear next to the template’s name - To preserve the changes be sure to click the **Save changes** button before running a report or leaving the page ![Dropdown menu showing template options with a highlighted 'Save changes' button.](https://cdn.us.document360.io/67f3ef76-1568-46b4-8047-4792fc3a99ce/Images/Documentation/Save template changes.png) *Click the* ***Save changes*** *button to update the template* Original and detailed book of record for all accounting transactions arranged by departmental account codes that occurs throughout the lifetime of a production. (General Ledger) Original and detailed book of record for all accounting transactions arranged by departmental account codes that occurs throughout the lifetime of a production. Accounting entry on the left side of a ledger. A debit entry increases an asset account and decreases a liability account. Accounting entry on the right side of a ledger. A credit entry increases a liability account and decreases an asset account. Professional review of the ledger and transactions of a project to ensure compliance with laws & procedures. May be conducted by Federal or State agencies, labor union representatives, Studio or Financier representatives, or to review compliance with tax incentive guidelines. (Purchase Order) A financial document committing the production to expenditure. An IRS form by which specific income (such as non-employee compensation, royalties, etc.) is reported to the federal government. Equivalent to a W-2 for independent contractors where remuneration is not being paid by the employer. Items that have been purchased or made that have value (typically $200+); these items are tagged by the Production Accountant to be sold (or given away) at the end of the production period, typically at 50% of original purchase price. Often, assets are stored for continuity purposes in anticipation of re-shoots, additional episodic series use, etc. (Accounts Payable) Cash disbursements through the payment of vendor invoices and other payables Places or properties used on a project (as opposed to a stage or backlot). If using the inside of the structure, this is called an Interior (Int). If filming outside, this is called Exterior (Ext). When an error is identified in an account (as in trial balance shows a balance other than zero), the ledger must be reconciled to find and correct the error. Also used in bank reconciliation where the balance shown on the bank statement is reconciled to the balance shown on the project's general ledger.