A Detailed Trial Balance Report displays detailed information about each of your accounts for a specified date range. The Detailed Trial Balance Report displays the same information as the Trial Balance Report, but includes beginning and ending balances for each account.
Generate a Detailed Trial Balance Report
- Navigate to Accounting.
- Click Financials on the navigation bar, and then click Detailed Trial Balance.
- Enter the date range for which you would like to run a report, and then click Refresh Report.
- A Date Filter Preset drop-down menu is also available for filtering the report.
- The following are available Date Filter Presets:
- Current Fiscal Year - Based on start month for the fiscal year.
- Current Month
- Last Month
- Current Quarter - The quarter you are currently in, not three months from the current date.
- Last Quarter - The previous quarter, not six months from the previous quarter.
-
Last Fiscal Year - Based on the start month for the fiscal year.
- The following are available Date Filter Presets:
- A Date Filter Preset drop-down menu is also available for filtering the report.
- Click the header of the column to sort the report.
- Click the linked values in the Credit and Debit columns to view the associated transactions.
- Click the linked values in the Credit and Debit columns to view the associated transactions.
Export the Report
There are three ways to export the Detailed Trial Balance Report.
Option 1
-
- Click Export to CSV to download a .csv file to your computer.
- Click Export to CSV to download a .csv file to your computer.
Option 2
-
-
- Click Copy to Clipboard, at the bottom of the page, to copy the report's contents to your clipboard and manually paste them into a spreadsheet.
- The copied data will need to be pasted into a spreadsheet as clicking this button will not automatically download a file to your computer.
- Totals will not automatically recalculate if you change the values within the pasted spreadsheet. Set up the formulas manually within the spreadsheet to automatically calculate the totals.
- The copied data will need to be pasted into a spreadsheet as clicking this button will not automatically download a file to your computer.
- Click Copy to Clipboard, at the bottom of the page, to copy the report's contents to your clipboard and manually paste them into a spreadsheet.
-
Option 3
-
-
- Click Print Report, at the bottom of the page, to print the report.
- Click Print Report, at the bottom of the page, to print the report.
-