Trial Balance
After importing the template information you will see the Trial Balance screen and it's details which are described below.
If you would like assistance in importing the Trial Balance, you can access the following link:
- Trial Balance menu: Includes the different options that can be used in the Trial Balance.
- Search section: Allows filtering (account number, description, etc.) to search for specific accounts.
- Edit buttons: Allows you to edit accounts that have been added to the Trial Balance.
Trial Balance Menu
- Transfer to spreadsheet: Allows to transfer the Trial Balance information to the corresponding parts of the spreadsheet being worked on (Regular Corporation).
- Export: Allows to export the Trial Balance information from the program to an Excel sheet.
- Import: Sub menu for Import actions.
- Excel file (.xlsx) - Import the Trial balance from a Microsoft Excel sheet 2007 or higher version.
- Download Template - Generate an Excel file with the template to import the Trial Balance into the program.
- Options: Sub menu containing other actions.
Options
- Adjustments: Allows the user to add, edit and view Trial Balance settings.
- Distributions: Allows the user to add, edit and view distributions to the Trial Balance.
- Sub Groups: Allows the user to add, edit and view sub groups to the Trial Balance.
- Rollover: This option changes the amounts of the entire Trial Balance from the current year's Trial Balance to the previous year's Amount column.
- Clear Trial Balance: This option removes all information from the Trial Balance screen.
If you already transferred to the spreadsheet, this does not remove the information that was transferred.
Working with Adjustments
The adjustments can be worked under the Trial Balance option or on each line of the spreadsheet for which you are transferring.
Here are the steps to follow to work with the adjustments settings:
- Press the Options button.
- Choose the Settings option.
Press the Add Adjustment button to add one manually.
Working with Adjustments
The adjustments can be worked under the Trial Balance option or on each line of the spreadsheet for which you are transferring.
Here are the steps to follow to work with the adjustments settings:
- Press the Options button.
- Choose the Settings option.
Press the Add Adjustment button to add one manually.
Additionally, you can import the settings from an Excel spreadsheet using the Import option.
Once you have entered the Adjustments information, press Save Adjustments to continue to the next window. Remember that all Adjustments must have a $0 balance in order to be saved.
Note: The red button on the right side of the record is used to delete the adjustment. The empty line with the green indicator is for adding a new adjustment.
When you are finished working with the Adjustments, they will be displayed in the Trial Balance.
You can also edit the Adjustments directly on the line of the spreadsheet you want to change. The lines affected by the Trial Balance quantities will be closed and will have an adjustment symbol inside the quantity field.
Press this Add Adjustment symbol to edit it directly on the line following the steps above
Working with Distributions
Allocations allow you to transfer certain percentages of the amounts to different schedules as indicated.
To add, edit and remove allocations:
- Press the Options button on the Trial Balance screen.
- Select the Allocations option.
Press Add Allocation.
- To edit the allocation details, press the Open button.
- If you want to remove an allocation, press the trash button.
Note: Remember that the Allocation percentage balance must balance to 100%
Working with Sub Groups
Sub groups are used to further classify accounts. Note that the sub groups created and their titles are used in the detail sheets attached throughout the spreadsheet.
To add, edit, and remove sub groups:
- Press the Options button on the Trial Balance screen.
- Select the Sub Group Code option.
- In the list, enter a number for the sub group and a description.
- Press Save Sub Group Codes to save the changes.
You can import from an Excel sheet the Sub Group Codes to the Trial Balance, by pressing the Import button.