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 must be enabled.
Once PAS is enabled, you can begin creating your report by going to the Generate a general ledger report page:
In the left-side navigation, click the dropdown menu
In the dropdown menu, select the name of the project that you want to access the GL for
In the left-side navigation, expand the ACCOUNTING menu, and click Accounting reports
On the Accounting reports dashboard, click the Create report button next to General ledger
Select the project, click Accounting reports, and then click the Create report button next to General ledger
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
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
1099
Select transactions that have been assigned a US tax form 1099 tax code.
Account
Select the line numbers for the accounts to be displayed
Account type
Filter by account classification: Asset, Liability, Expense, Income, or Equity.
Asset
Choose whether to show transactions related to production assets.
Bank
Filter transactions associated with a specific bank account.
Cancelled
Choose whether to Include (default), Exclude, or show Only cancelled transactions.
Effective date
Filter transactions based on the transaction date (start and end date range).
FF1
Select from your customized Free Fields
Include distribution changes
Check to display distribution changes made to transactions. Uncheck to hide them.
Include starting/ending balances
Check to display the starting and ending balances for the selected period range.
Line amount
Filter transactions based on their individual dollar amounts.
LO
Filter by work location tag.
Paid AP invoices
Filter to show Accounts Payable invoices that have been paid.
Payment Number
Filter by specific vendor payment reference numbers.
PO#
Select a range of purchase orders based on their reference number.
Posted date
Filter transactions based on when they were posted to the General Ledger.
PRD
Filter by production or episode tag.
SET
Filter by set tag.
Specific accounts
Select individual account codes instead of a numeric range.
Transaction #
Select a range of transactions based on their reference number.
Transaction date
Select the date range of transactions to display
Transaction status
Filter by Posted (default), Unposted, or All statuses.
Transaction type
Filter by transaction category: Accounts Payable (AP), Journal Entry (JE), Payroll (PR), Vendor Payment (VP), Open Purchase Order (Open PO), Petty Cash (PC), and PCard (PX).
V1099
Select vendors with US tax form 1099 status.
Vendor
Select specific vendors to include in the report. Vendors must be added on the Vendors page before they appear as options.
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
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.
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.
Example of a GL Report preview. Click the Generate report button to begin your download.
.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
Go to the Generate a general ledger report page
In the Apply filters section, add the 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.
Once you are satisfied with the way the report is configured, click the Create template button
In the Create template popup, enter a template Name. You can click the checkbox to Set as default (optional)
Click the Save button
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.
Click to apply filters, then click the Create template button
Enter a Name, click to Set as default for this report (optional), and then click the Save button
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:
Go to the Generate a general ledger report page
On the Generate a general ledger report page, under Templates, click the dropdown menu to select the template that you want to update
Click the gear icon, and then select an option: Set as default, Rename, Duplicate, or Delete
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
Click the Save changes button to update the template