With Wrapbook’s Production Accounting Suite (PAS), you can download payroll and accounting reports instantly.
Access accounting reports
From the left-side navigation, click the dropdown menu
Select the project that you want to access accounting reports for
In the left-side navigation, click Accounting to expand the menu
In the left-side navigation Accounting menu, click Accounting reports
Accounting reports options
There are three different types of accounting reports that you can generate for a project:
General ledger (GL) reports
Trial balance reports
Cost reports
Click on each of the tabs in the Account reports guide below to learn more.
Account reports guide
GL reports
You can use the General ledger report page to build, preview, and generate custom reports based on your project’s transactional data in Wrapbook.
Create a GL report
On the Accounting reports page, click the Create report button next to General ledger
On the General ledger report page, use the Quick filters and manual filters to build your report
Select the Report settings
Preview your report
Generate your report
GL quick filters
Instead of manually selecting the filters that you want to apply to the GL report, you can use the Quick filters section to pull and analyze your data using simple, conversational language.
Here’s how it works
On the General ledger report page in the Quick filters section, click the +
Under What kind of report do you need? type your request
Quick filter tips
The Quick filters section can process most natural language queries that are based on the following filters:
Tags
Location
Production/Episode
Account codes
Transaction numbers
Period/Effective date
Transaction type
Vendor information
The Quick filters feature works best when you’re specific about the information you're looking for. Be sure to include relevant dates, periods, or account codes in your query.
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
Alternatively, you can click on one of the Suggestions listed in the Quick filters section.
GL manual filters
If you don’t want to use the Quick filters, you can use the Apply filters section of the General ledger report page to manually select filters.
Click to see the full list of manual filters for GL reports
Filter | Description |
|---|---|
From period & To period | Define the period range |
Transaction type | Options: Accounts Payable (AP), Journal Entry (JE), Payroll (PR), Vendor Payment (VP), Open Purchase Order (Open PO) |
Transaction start date & Transaction end date | Select the timeframe for transactions |
From Transaction # & To transaction # | 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 | Options: Posted (default), Unposted, All statuses |
Cancelled | IOptions: nclude (default), Exclude, Only |
Posted start date & Posted end date | Select a range of transactions based on the date they were posted |
Vendor | Select the vendors that you want to see transactions for. If you don’t see a vendor in the list, you’ll need to go to the Vendors page and add them before you can select them as a filter. |
V1099 | Select the vendors with US tax form 1099s that you want to see transactions for |
From ACCT & To ACCT | Select the account numbers that you want to see transactions for |
Account type | Options: Asset, Liability, Expense, Income, and Equity |
LO | Select the work locations that you want to see transactions for. If you don’t see a location in the list, you’ll need to go to Project settings, Accounting section and add it to your project’s Tags. |
PRD | Select the production numbers that you want to see transactions for. If you don’t see a production number in the list, you’ll need to go to Project settings, Accounting section and add it to your project’s Tags. |
SET | Select the set numbers that you want to see transactions for. If you don’t see a set number in the list, you’ll need to go to Project settings, Accounting section and add it to your project’s Tags. |
FF1 | This is a free field that you can use to add a custom filter |
Asset | Choose if you want to see transactions for production assets |
Description contains | Select transactions that have specific words in their transaction descriptions |
Line amount minimum & Line amount maximum | Select a range of transactions based on their individual dollar amounts |
Include distribution changes | Click the checkbox to show distribution changes made, un-click the checkbox to hide them completely |
Include starting balance | Click the checkbox to show the starting balance for the period range selected, un-click the checkbox to hide it |
GL report settings
Before you generate a GL report, you’ll be required to enter the following information in the Report settings section:
Report title
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)
Preview your GL report
In the Report preview section of the General ledger report page, you can see how the report will appear 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.
Trial balance reports
You can use the Trial balance option to see a summary of balances on all accounts, grouped by Assets, Liabilities, and Expenses.
Create a trial balance report
On the Accounting reports page, click the Create report button next to Trial balance
On the Generate a trial balance report page, under Apply filters, select the data to include in your report
Select the Report settings
Preview your report
Generate your report
Trial balance report filters
On the Generate a trial balance report page you can use the following filters:
Period and date filters
Period ranges or individual periods
Transaction date
Posted date
Effective date
Tag filters
LO
PRD
SET
Free Fields (if using)
1099
Transaction Status
Trial balance report settings
Before you generate a trial balance report, you’ll be required to enter the following information in the Report settings section:
Report title
Report type (Detail or Summary)
Export format (PDF or CSV)
Page size (Letter, Legal, Ledger/RA3 or 2x Ledger/RA2)
You’ll also have the the options to:
Show $0 accounts
Summarize expenses (PDF only)
Preview your trial balance report
In the Report preview section of the Generate a trial balance report page, you can see how the report will appear based on the filters and settings you’ve applied.
Generate a trial balance report
On the Generate a trial balance 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.
Cost reports
You can use the Generate a cost report page to build, preview, and download reports for your committed and actual costs compared to your budget/estimated final costs (EFC) for the current period.
Create a cost report
On the Accounting reports page, click the Create report button next to Cost report
On the Generate a cost report page, under Apply filters, select the data to include in your report
Select the Report settings
Preview your report
Generate your report
Cost report filters
You can apply the following filters to the cost report:
Period range
Transaction date range
Posted date range
ACCT numbers
LO
PRD
SET
FF1
Cost report settings
Before you generate a cost report, you’ll be required to enter the following information in the Report settings section:
Report title
Report type (Detail or Summary)
Export format (PDF or CSV)
Page size (Letter, Legal, Ledger/RA3 or 2x Ledger/RA2)
You’ll also have the the options to:
Show $0 accounts
Show period variance
Edit the report columns
Click to edit the columns that you want to show in the report. The options are: Account, Description, Period actuals, Actuals to date, POs, Total to date, ETC, EFC, Budget, Approved overages, Total budget, Variance, Period variance
Preview your cost report
In the Report preview section of the Generate a cost report page, you can see how the report will appear based on the filters and settings you’ve applied.
Generate your cost report
On the Generate acost 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.