Trial Balance Report in TOPS [ONE]
The Trial Balance report shows the balances and transactions in the general ledger for a range of dates and/or accounts. If you choose to show detail, it displays all the transactional detail.
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 As of Date, Sort, Cost Center settings.
Options - Hides the editable report options.
Schedule - Email reports on a schedule, or as a one-time email.
Start Date - Beginning of the report date range.
End Date - End of the report date range.
Start Account Number - Starts of the range of GL accounts to be displayed.
End account number - Ends the range of GL accounts to be displayed.
Include Detail - Displays all transaction activity for each account.
Include Prior Year Balances - Enable this to see GL activity for a previous fiscal year.
Sort - Select an option to arrange the report by your preference
Cost Center - Filter by cost center
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)
If you made any changes, click to see the changes in the balance sheet on screen or before exporting.
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.