---
title: "General Ledger reports (PAS)"
slug: "general-ledger-reports-pas"
updated: 2026-07-07T19:14:09Z
published: 2026-07-07T19:14:09Z
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. |

![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).