Trial Balance

Description 

The trial balance is an internal report ran at the end of an accounting period, listing the ending balance in each account. The report is primarily used to ensure that the total of all debits equals the total of all credits, which means that there are no unbalanced journal entries in the accounting system that would make it impossible to generate accurate financial statements. 

This report should always balance to zero.

This guide will explain how to view, print, and export a Trial Balance report. Also, this guide will show how to email the report on an automated schedule.

 

How to Generate/Export 

1. Click Reports and select Standard. Select your report 

2. Edit the Report Parameters as needed.

 

Start & End Date - Date range for the report. 

Sort - Select an option to arrange the report by your preference 

Start & End Account Number - Range of GL accounts to be displayed.

Cost Center - Filter by cost center. If a cost center is selected, the cost center name will appear on the header of the report.  

Include Detail - Displays all transaction activity for each account.

Include Prior Year Balances - Enable this to see GL activity for a previous fiscal year.

Consolidate Cost Centers- Consolidate cost centers rolls the amounts up to the account level.

3) Edit your Export Parameters

Export Orientation   Portrait/Landscape   

Export Font Size        Large/Small 

Show Run Date/Time   This feature is on by default. Disabling will remove the timestamp on the top right of the exported report 

Show account Number  This feature is on by default. Disabling will remove the account numbers, and only leaving the account name. 

Header Row Border  This feature is on by default. 

1st Column Border 

Banded Rows (Shading) 

Gridlines 

 

4. If you made any changes, click  to see the changes in the balance sheet on screen or before exporting.

5. Once you're finished, click 

This will download the exported report to your default download folder.

 

How to schedule Reports  

1. Click Schedule. This will display the scheduling options.

2. Schedule -Will let you email reports at a scheduled time, or as a one-time email. 

Frequency- How often you want the reports to automatically be sent. (Once, monthly, quarterly, etc.)

Permitted Days-pick which day you want the reports to run, if you don't want the report to run on a specific day, unselect those days.

Start Date- Select the day you want to start the scheduled reports

End Date- Select the date you want the scheduled reports to end. 

End Time- Select the time you want the reports to stop running. 

Recipient- Type in the email where you want the reports sent

3. Click Schedule at the bottom of the screen

 

You can go to Automation to see this scheduled job. 

 

 

Did you find this article helpful?

0 out of 0 found this helpful