Tres enables agencies to configure General Ledger Branches (GL Branches) to allocate Sales, Cost of Sales, and Expenses across multiple branches. This setup allows users to generate Income Statements for individual GL Branches or for customized groupings giving agencies the ability to group Branches differently for management and accounting purposes.
Skip to:
Setting Up General Ledger Branches
General Ledger Branches in Journal Entries
Running Income Statements by General Ledger Branch
Filtering Account History by Branch
Setting Up General Ledger Branches
To begin, an Admin or Manager with the appropriate General Ledger permissions must:
- Navigate to Settings > General Ledger Setup.
- Select General Ledger Branches.
- Click Add GL Branch and add details to create a new branch.
- Save.
Next the Admin or Manager links the General Ledger to a Management Branch. Go to Settings > Branches and use the drop down in the General Ledger Branch field to select the General Ledger branch that represents the Branch needed to breakdown the Income Statement as desired.
General Ledger Branches in Journal Entries
As Trips are Settled, all the Client and Supplier payments are completed, the automated Journal Entry will add the General Ledger Branch to Sales and Cost of Sales accounts based on the link from the Management Branch in the Trip.
Back Office users will need to add the General Ledger Branch to any manually entered Journal Entries or Journal entries associated with Other Payments. When adding a new Journal Entry row, the dropdown field will be enabled when the selected GL Account Category is Sales, Cost of Sales, or Expenses and will be disabled when the selected GL Account Category is Assets, Liabilities, or Capitals.
Best Practice: It is recommended that once General Ledger Branches have been turned on that all Journal Entry Rows that include a selected GL Account in Category of Sales, Cost of Sales, or Expenses include a General Ledger Branch. Doing so, allows the agency to run An income Statement for each branch and when added together they will total the same as running an Income Statement that includes all branches.
Running Income Statements by General Ledger Branch
Once at least one General Ledger Branch has been set up, Admins, Managers, and Back Office Users with the proper permission will see a GL Branch filter when running the the Income Statement Report under Reports > Tres Defined Reports > Income Statements.
The filter is a multi-select dropdown with all active GL Branches and an option for "Blank". Not checking any options in the filter will fetch results from all GL Branches. Checking the box for Blank will fetch results where the GL Branch field was not selected in the Journal Entry. When one or more General Ledger Branches are selected in the filter, the sum of the activity of the Journal Entries in the selected date range will show under each Income Statement account on the Income Statement.
Filter Behavior:
| Filter Selection | Result |
| No selection | Includes all GL Branches |
| "Blank" selected | Includes entries without a GL Branch assigned |
| One or more branches | Displays totals per Income Statement account for selected branches |
Filtering Account History by Branch
Running an Account History using the GL Branch filter allows you to see the details of an account on the Income Statement run by a single General Ledger Branch. The GL Branch Filter is only visible when there are one or more GL Branches set up.
Filter Behavior:
| Filter Selection | Result |
| No selection | Includes all GL Branches |
| "Blank" selected | Includes entries without a GL Branch assigned |
| A Branch selection | Includes entries with only selected branch in the GL Branch column |
Beginning balance is calculated based on the GL Branches selected in the filter along with the date range entered.