The Trial Balance section is designed to generate a trial balance report which can be filtered by the transaction display types. In addition, you can export journals tagged as 'Export Pending' from this area.
The following fields are required to generate the report:
|Display||This field will limit the transactions displayed.|
See * below for a list of all available display types.
|If checked, this will display a report showing the imported trial balance, total adjustments made in Reportance, and the final trial balance.|
|Account Type||Filters the displayed transactions based on where the account originated.||Two Options:|
Account - Includes all the transactions within all accounts including Reportance generated reporting accounts
Source Account - Only includes transactions from accounts imported into the system
|Start Date||Automatically populated as the start date of the dataset.||Required (inside date range of the dataset)|
|End Date||Automatically populated as the end date of the dataset.||Required (inside date range of the dataset)|
*All available Display types
|Trial Balance||Includes all transactions from all sources|
|Imported Balances||Only includes transactions and journals which were imported from the client file|
|Not Exporting||Only includes Reportance generated journals used for presentation purposes|
|Pending Export||Only includes Reportance generated journals which will be sent to the client file|
|Exported||Only includes Reportance generated journals which have been sent to the client file|
|Balancing||Only includes consolidated Reportance generated journals which have been sent to the client file|
Below is a sample of report settings. To generate the report click on the Run Report button.
Exporting journals tagged 'Pending Export'
To export a balancing journal, run a Trial Balance report with the Display set as 'Pending Export' and the Account Type set as 'Source Account'. After the report has been generated the Export as Balancing Journal button will be available.
- Change the transaction from 'Pending Export' to 'Exported'
- Create a balancing journal and post it to the system tagged as 'Balancing'
- Use the API connection to post the journal to the client's accounting system.
- Change transaction from "Pending Export" to "Exported"
- Create a balancing journal and post it to the system tagged as "Balancing"
Note: A user will manually need to enter these journals in to the client's accounting system.
Note: It is advisable to do a fresh import from the source system after the balancing journal has been processed because the 'tagged' journals will be excluded from the calculation of the trial balance in future reports to prevent any doubling up of information.
Warning: Depending on the setup of your client's accounting system, the exported journal may be sitting in their file as a 'draft journal' and, therefore, it will first need to be posted in the accounting system before it will be imported back into Reportance.
To search through the generated report start typing in the search field as demonstrated below. This is a live search field so pressing enter is not required.
For more information on Filtering and formatting generated reports see the knowledge article: Filtering and Formatting within Reportance.
To access the right-click menu, use your mouse to right-click anywhere on the generated report to bring up the following menu options: