Overview
A trial balance report in Wrapbook shows all accounts and their current balances, ensuring debits equal credits.
The trial balance report can be used by production accountants to:
Verify accounting accuracy
Prepare for financial statements
Provide a quick overview of account balances
The trial balance report in Wrapbook can be exported in the following formats:
PDF
XLSX (Excel)
CSV (raw data export)
How to create a trial balance report
In order to create a trial balance report, Wrapbook’s Production Accounting Suite must be enabled.
Once PAS is enabled, you can begin creating your report by going to Accounting reports dashboard:
In the left-side navigation, click the dropdown menu
In the dropdown menu, select the name of the project that you want to create a Trial balance report 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 Trial balance
Select the project, expand the ACCOUNTING menu, click Account reports, and then click the Create report button next to Trial balance
Screenshot of the Generate a trial balance report page
Trial balance report filters
On the Generate a trial balance report page you can click on any of the following filters to customize your report:
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
Screenshot of the filters available on the Generate a trial balance report page
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)
Always show cents
Enable Thousands separator
Edit report columns
You can click the Edit report columns button to enable editing of the following:
Account
Description
Bal forward
Curr period
Ending bal
Screenshot of trail balance Report settings
In the Edit report columns, popup you can click the checkboxes next to the column types to update
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.
Use the Report preview to see an overview of the data that will be in your report, then click the Generate report button