13.4 Features and Enhancements
This topic includes details about the new features and enhancements in WorkBook Release 13.4.
CRM
CRM Billing Plan and Pipeline Details Tab Updated to Support Gross Revenue
Deltek Tacking Number: 1675725
- Gross Revenue - Hours
- Gross Revenue - Purchases
- Cost - Purchases
- Expected Gross Revenue
- Expencted Monthly Gross Revenue
For more information, see Pre-Conversion: Pipeline Details Tab Fields and Calculations.
- Pipeline column: When you convert a pipeline into a job, the pipeline figures at the point of conversion are displayed under this column.
Note: The values under this column become read-only after conversion.
- Price Quote column: After you have converted a pipeline into a job, the Pipeline Details tab pulls in the values from the Price Quotes on the job attached to the pipeline and displays the figures under this column. For more information, see Price Quote Column Fields and Calculations.
Having these figures conveniently displayed side by side can help you to easily compare projected and current revenue.
In addition, the Pipeline Billing Plan (
) calculates for the Gross Revenue instead of the Net Revenue, making it consistent with the billing plan in the Jobs module.Finance & Administration
Employee Department Recording on Cost Entries
Deltek Tracking Number: 1564501
Previously, WorkBook did not record the Employee Department ID that the employee resource was associated with at the time or a transaction being created (such as time, expense, mileage, and material cost associated with an employee). This created inconsistencies in data when an employee was moved from one department to another, and the latter department ID was incorrectly reported in some transactions and reports.
To address this issue, an EmpDepID column is added to tables supporting employee-related cost entries. When an employee-related entry is created, the Employee Department ID on the Employee is recorded and can be referenced later. This delivers consistency of data reporting, even if the employee is later moved from one department to another.
- Time Entry (TimeReg table)
- Personal expense entry (ExpenseEntry table)
- Mileage entry (JobMilage table)
- Material Entry (JobMatExp table)
- Financial posting (FinPosting table)
Integration with Pagero
Deltek Tacking Number: 1761063
- Send e-invoices to Pagero, which Pagero in turn sends to your intended recipient.
- Receive e-invoices from Pagero, which Pagero received from your behalf.
See the Deltek WorkBook Integration Guide for Pagero for more information on the Pagero integration, including prerequisites and initial setup.
Jobs
Reports – Report 386 (Client Job Cost Details) – New Option to Include or Exclude Inactive Employees
Deltek Tacking Number: 1564538
When running Report 386, you can use this new parameter to include or exclude the records of employees who left the company in the middle of a reporting period. You can generate Report 386 using the Reports icon from
.Report 581 - Job Reconciliation Report
Deltek Tacking Number: 154914
The Job Reconciliation report (Report 581) enables you to see an overview of the financial position of a job at a particular date. It draws information from across the Jobs module and gives you a single place to review the financial health of a job and identify any anomalies or issues that may need action. See Job Reconciliation Report (Report 581) for detailed information about this report.
In addition, System Variable 267 has been updated to include the Job Reconciliation report (Report 581). This setting affects the calculation of the % Margin for the Profitability and Completion and Job Estimate at Completion Forecast sections of the report.
My Settings
Redesign of My Settings/Whereabout Dialog Box
Deltek Tacking Number: 1765217
To continue with simple, impactful changes to the UI, the available options within the My Settings/Whereabout dialog box have been changed. Those options that were not required have been removed to provide a cleaner, fresher styling.
Updates include:- My Settings/Whereabout Dialog Box Changes - The dialog box that is displayed when you select My Settings on your avatar shortcut menu on the main toolbar has been redesigned to provide cleaner, fresher styling. In addition, the number of options that it provides has been reduced.
- Change Whereabout Pop-Up Redesign - When you access your avatar shortcut menu on the main toolbar and navigate to Change Whereabout, all existing active whereabout types and Reset Status options are displayed in a pop-up window. You can select your status from them when Company Variable 74 (Require Employees to Track Time Using Whereabout) is set to either 1 - Not Required or 3 - Required for Some Employees, and User Must Track Time is disabled. Status updates in both your user profile and the WorkBook footer are always in sync.
Resources
Resources - Resource Information Card - Ability to Add More Terms to Gender
Deltek Tacking Number: 1551938
You can now add custom gender terms, which you can then assign to individual users in WorkBook. You set this up in
You can also select gender terms from the Gender column in
In addition, the N/A option has been added as a third predefined option. Previously, only two predefined options - Female and Male - were available for selection. Note that you cannot delete the predefined options because they are hardcoded.
Scheduling
Ability to Assign Team to Sprint Added
Deltek Tacking Number: 1828222
You can now assign Scrum Teams to sprints. This change has been made to better support the Agile process by shifting accountability for a sprint from an individual resource to an entire Scrum Team. Previously, you could only assign individual employee resources (Scrum Responsible) to sprints.
- You now have access to/visibility into only those Scrum boards for which you are in a team that is responsible for the sprint, or for which you are a Scrum Responsible. This removes the inclusion of unneeded data.
- The Team Responsible field has been added to the Scrum Sprint View filter.
- The Team Responsible column has been added to the Scrum Sprints Setup page.
Ability to Rank Sprint Backlog Items in Scrum Board Added
Deltek Tacking Number: 1612431
For instructions, see Rank Sprint Items on the Scrum Board.
- The Effort and Backlog Priority fields have been added to the Task Card.
- The total effort for a selected sprint is now displayed on the tab toolbar.
- You can now filter tasks by sprint in .
All changes made to the prioritization of tasks are saved in the task log.
Absence Type Icons Update
Deltek Tacking Number: 1722179
Icons for absence types have been updated to the new 2D mono standard. This is in support of the ongoing effort to improve WorkBook's user interface through the standardization and rationalization of iconography.
Effort Added to Task and Sprint
Deltek Tacking Number: 1757432
- Scrum Sprint Overview tab
- tab
Public Hours Displayed on Scheduling Views
Deltek Tacking Number: 1812910
Scrum Board View Added to Tasks Module
Deltek Tacking Number: 1828389
The Scrum Board is now accessible via the Task Module.
Settings
Ability to Mark Departments as Inactive
Deltek Tacking Number: 1816400
- Job List Views
Jobs that are in Quotation, In Progress, On Hold, or Ready for Invoicing status are now displayed in parentheses and highlighted in red in the following views:
- Simplified View
- Job List
- Expenditure Overview Cost Prices
- Expenditure Overview Sales Prices
- Purchase Orders Overview
- Jobs List with Dimensions Settings
- Expenditure Overview Cost & Sale
- Project Retainer
- Costs
Inactive Departments are now displayed in parentheses in
. - Contacts
In
template, inactive Departments that are set and displayed as defaults on the field are highlighted in red and enclosed in parentheses. In addition, inactive Departments are not available for you to select in the drop-down list. - Grid Views
In Employee Settings, Employee Price Group, CRM Pipeline, Schedule Overview, and Weekly Schedule, for a selected employee record, if the Department to which that record belongs is inactive, the field background is highlighted in red, and the Department name is enclosed in parentheses when displayed.
- Resource Cards
In the Resource card and other places that display employee information, if the Department to which the resource belongs is inactive, the field background is highlighted in red, and the Department name is enclosed in parentheses.
Move an Employee to Another Company
Deltek Tacking Number: 1819876
In
, you can now select employees and move them to another Company. Only active Departments in the selected target Company are enabled for selection.System Administration
OAuth2 Updates
Deltek Tacking Number: 1828847, 1904577
WorkBook has updated its OAuth2 authentication protocol, including the following new features and enhancements.
- You can now configure system mail sending with OAuth 2.0 for Microsoft and Google services. The following are added in Release 13.4:
- Configuration options in
- Connect to OAuth 2.0 Server log-in button in
- Release 13.4 also implements OAuth 2.0 for further use of Google as follows:
- Added configuration options in
- Added Sign in with Google log-in option in
- Added Google OAuth 2.0 support for the following agents:
- Ticket Import Public Agent (OAuth 2.0) – Agent Type 180
- Mail Import Agent (OAuth 2.0 – Agent Type 178
- Mail Import Public Agent (OAuth 2.0) – Agent Type 176
- Mail Archive Agent (OAuth 2.0) – Agent Type 179
- Calendar Synchronization
- Calendar synchronization OAuth 2.0 settings are moved from System Variables 936, 937, 1182, and 1183 to . These System Variables are removed.
- The email account that you are signed in with is now displayed to you.
- The OAuth 2.0 login window now opens in a new browser tab.
:
- All changes to the grid can only be made via the New/Edit dialog, which you access from the toolbar.
- You cannot update Provider IDs or Client IDs for existing entries.
-
The Active column is replaced by the Scopes column, which displays all active features for which each setting is used.
:
See Deltek WorkBook Reconfiguring WorkBook to Use OAuth and Deltek WorkBook Configuring WorkBook to Use Google Workspace OAuth for updated instructions.
Time & Expense
API – Time Entry: Allow Filtering by Company
Deltek Tacking Number: 1561132
Some Time Entry API endpoints have been improved for performance and data quality.
Company Settings – New Company Variable to Require Confirmation when Submitting Time Entries
Deltek Tacking Number: 1937893
When you submit your own time entries for approval, you are now presented with a confirmation dialog box. Confirming the action is logged. Entries with blank hours are not valid and are not logged.
The confirmation dialog box does not affect automated submissions/approvals (such as agents) or submissions/approvals directly through the API.
To have WorkBook display the confirmation dialog box, you must first enable Company Variable 79 (Require Employees to Accept a Pop-Up Message When Approving Time). For instructions, see Enable Company Variable 79.
Translations
French Canadian Translation is Updated
Deltek Tacking Number: 2005407
Additional text that appears in WorkBook has been translated into French Canadian and imported into the translation layer.
User Interface
Icon Standardization
Deltek Tacking Number: 1765197
- CRM module: Icons have been updated to the new 2D mono standard.
- Dashboard module: Icons have been updated to the new 2D mono standard. Some icons that served redundant functions have been removed.
- Reloading/refreshing updated rows in grids: Icon has been updated to the new 2D mono standard.
- Inbox and Conversations header: Redundant icons have been removed and navigation controls have been rearranged.
- Arrow icons: Updated to ensure that they are consistent for the same functions across WorkBook.
- pages: Some icons have been repositioned, and some have been updated to the new 2D mono standard.
- Jobs module: Icons have been updated to the new 2D mono standard and some redundant icons have been removed.
- Time & Expense module: Icons have been updated to the new 2D mono standard and some redundant icons have been removed.
New Tree View Component
Deltek Tacking Number: 1825203
A new Tree View component provides a consistent user experience in WorkBook.
Rich Text Editor
Deltek Tacking Number: 1846881
WorkBook has upgraded its rich text editor to provide improved editing and a more consistent user experience across WorkBook.
- Add a new ticket quick (dialog box) –
- Briefings (tasks, jobs)
- Add a new task (dialog box)
- Add a new ticket (dialog box)
Scheduling – Timeline Calendar and Calendar User Interface
Deltek Tacking Number: 1545925
- In the toolbar of the Timeline Calendar, Calendar, and Personal Calendar, several buttons have been moved to the left, and two new buttons were added: Create New Task and Add an Existing Task.
- There is now a visual indicator to show which cell is selected.
- The styling of the grid header of the Timeline Calendar, Calendar, and Personal Calendar views has been improved.
- The styling of the Name and Day columns of the Timeline Calendar has been improved.
- The styling of the Timeline Calendar and Calendar booking cards has been improved.
-
View options have been added to the Calendar view to control what is displayed on the booking cards.
Reports
Job Reconciliation Report (Report 581)
Summary
This new report allows you to see an overview of the financial position of a selected job at a particular date. It draws information from across the Jobs module and gives you a single place to review the financial health of the job and identify any anomalies or issues that may need action. It does not support Download as XLSX Document (Row) Data, but it supports Download as XLSX Documents (Formatted) Data.
Location
Navigate to
to run this report. WorkBook uses the highlighted job in the Jobs List as the source of information for this report.Parameters
Parameter | Use |
---|---|
Report To Date | This is the date that indicates the To Date to be used to filter the transactions. This is the only required parameter. |
Report Layout and Calculations
This report calculates for the selected job's profitability by comparing the total value of its Price Quotes and Sales Invoices with the Sales and Cost values of applied entries and the actual revenue recognized based on WIP adjustments and values derived via posting configurations. It also compares the total value of its Price Quotes with its total forecast value based on both the actual values and the forecasted or scheduled values.
Section Heading | Section Descriptions |
---|---|
Job Overview for Job | This field indicates the job number of the selected job. |
Report To Date | This is the date that indicates the To Date to be used to filter the transactions. |
Summary | This section displays, in two columns, information sourced from the selected job. It includes the name of the information and the corresponding value of the data point. |
Column Heading | Column Descriptions |
---|---|
Client | This field indicates the client that the job belongs to. |
Project | This field indicates the project that the job is a part of. |
Job Type | This field displays the same job type that is indicated on the Job card. |
Job Team | This field displays the same job team that is indicated on the Job card. |
Department | This field displays the same Department that is indicated on the Job card. |
Company | This field indicates the Company and company initials that the job belongs to. |
Currency | This field indicates the currency used by the job. |
Report Currency | This field indicates the report currency used by the job. It is only visible if the report currency is different from the job currency. |
Job Name | This field displays the job's name as indicated on the Job card. |
Job Status | This field displays the job's status as indicated on the Job card. |
Start Date | This field displays the job's start date as indicated on the Job card. |
End Date | This field displays the job's end date as indicated on the Job card. |
Project Manager | This field displays the Project Manager that is indicated on the Job card. |
Account Manager | This field displays the Account Manager that is indicated on the Job card. |
Finance Manager | This field displays the Finance Manager that is indicated on the Job card. |
Section Heading | Section Descriptions |
---|---|
Profitability and Completion | This section displays the overview and comparison of the total value of the Price Quotes and Sales Invoices of the selected job and the Sales and Cost values of applied entries and the actual revenue recognized based on WIP adjustments and values derived via posting configurations. |
Column Heading | Column Descriptions |
---|---|
Estimated | The fields in this column get their data from the sum of all of the in-scope Price Quotes of the selected job. In-scope Price Quotes are Price Quotes that are under preparation, for approval, or approved. |
Estimated Revenue | This field displays the sum of the Total of each Price Quote that is under preparation, for approval, or approved. |
Estimated Purchase Cost | This field displays the sum of the Purchases of each Price Quote that is under preparation, for approval, or approved. |
Estimated Net Margin | Net Margin is the net of Revenue and Purchases. This field displays the sum of the Net Revenue or NR of each Price Quote that is under preparation, for approval, or approved. |
Estimated % Margin | Depending on the value set for System Variable 267, this field displays, as a percentage of up to two decimal places, the value of the Net Profit divided by either the Revenue or the Net Margin of all of the Price Quotes that are under preparation, for approval, or approved. |
Estimated Cost of Hours | This field displays the sum of the cost of any time hours applied to each Price Quote that is under preparation, for approval, or approved. |
Estimated Net Profit | Net Profit is the net of Net Revenue and any calculated cost of hours. This field displays the sum of the Net Profit of each Price Quote that is under preparation, for approval, or approved. |
Estimated Total Hours | This field displays the sum of the Hours of all Price Quotes that are under preparation, for approval, or approved. |
Actual | The fields in this column get their data from the value of WIP adjustments and revenue postings. This is based on your Posting Configuration setup and other actual postings to the selected job, including purchase invoices and expenses. All WIP adjustment transactions in any status are in scope. |
Actual Revenue | This field displays the sales value of the actual corresponding entries on the job. For example, if a time entry is posted to the job, the actual Revenue is the sales value of the posted time entry. |
Actual Purchase Cost | This field displays the cost value of the actual corresponding entries on the job. For example, if a purchase invoice or expense entry is posted to the job, the actual Purchase Cost is the cost value of that posted invoice or entry. |
Actual Net Margin | This field displays the total of the selected job's Revenue and all of its Purchase Costs. |
Actual % Margin | This field displays, as a percentage of up to two decimal places, the value of the Net Margin divided by the Revenue of the selected job. |
Actual Cost of Hours | This field displays the sum of the cost of any time entries on the job. |
Actual Net Profit | This field displays the total of the Net Margin and the cost of all the time entries logged on the selected job. |
Actual Total Hours | This field displays the total used hours based on the time entries logged on the selected job. |
Revenue Recognized | The fields in this column get their data from the value of WIP adjustments and the revenue recognized on the transactions posted on the selected job. Data is derived via posting configurations. For example, the time entry where the sales value of the time is recognized as revenue and is reflected on the WIP adjustment dialog box. Values are shown split as Revenue or Costs. |
Revenue Recognized Revenue | This field displays the actual Profit & Loss total on the WIP adjustments of the selected job. Note that Company Variable 75 should be set to 2. |
Revenue Recognized Purchase Cost | This field displays the total of all Purchase Costs on the WIP adjustments of the selected job. Note that Company Variable 75 should be set to 2. |
Revenue Recognized Net Margin | This field displays the total of the actual Profit & Loss and all the Purchase Costs on the WIP Adjustments of the selected job. |
Revenue Recognized % Margin | This field displays, as a percentage of up to two decimal places, the value of the Net Margin divided by the actual Profit & Loss total on the WIP Adjustments of the selected job. |
Variance | The fields in this column display the difference between either the Invoiced and Incurred or Actual and Recognized column and the Estimated Values column. |
Completion | The fields in this column display the percentage of the Invoiced or Actual column divided by the Estimate column. |
Invoiced | The fields in this column get their data from the value of the created Sales Invoices for the selected job. |
Section Heading | Section Descriptions |
---|---|
Job Estimate at Completion Forecast | This section displays a comparison of the total value of the Price Quotes and the total forecast value of the job based on both the actual values and the forecasted or scheduled values. |
Column Heading | Column Descriptions |
---|---|
Estimated Revenue | This field displays the sum of the Total of each Price Quote that is under preparation, for approval, or approved. |
Estimated Purchase Cost | This field displays the sum of the Purchases of each Price Quote that is under preparation, for approval, or approved. |
Estimated Net Margin | Net Margin is the net of Revenue and Purchases. This field displays the sum of the Net Revenue or NR of each Price Quote that is under preparation, for approval, or approved. |
Estimated % Margin | Depending on the value set on System Variable 267, this field displays, as a percentage of up to two decimal places, the value of the Net Profit divided by either the Revenue or the Net Margin of all of the Price Quotes that are under preparation, for approval, or approved. |
Estimated Hours and Internal Costs | This field displays the sum of the cost of any time hours applied to each Price Quote that is under preparation, for approval, or approved. |
Estimated Net Profit | Net Profit is the net of Net Revenue and any calculated cost of hours. This field displays the sum of the Net Profit of each Price Quote that is under preparation, for approval, or approved. |
Estimated Total Hours | This field displays the sum of the Hours of all Price Quotes that are under preparation, for approval, or approved. |
Actual Revenue | This field displays the sales value of entries posted against the selected job. It includes time entries, purchases, materials, expenses, and mileage. |
Actual Purchase Cost | This field displays the cost value of entries posted against the selected job. It includes time entries, purchases, materials, expenses, and mileage. |
Actual Net Margin | This field displays the total of the selected job's Revenue and all of its Purchase Costs. |
Actual % Margin | This field displays, as a percentage of up to two decimal places, the value of the Net Margin divided by the Revenue of the selected job. |
Actual Total Hours | This field displays the total used hours based on the time entries logged on the selected job. |
Scheduled | The fields in this column display the sales value and the cost value of the bookings made on the schedule. For example, the time entries logged on a specific schedule should be offset from the scheduled value. When an employee makes a time entry on the task that they are scheduled on, it should be for the day that they scheduled. |
Open Purchase Orders / Open POs | The fields in this column display the sales value and the cost value of the open balances of the Purchase Orders of the selected job. |
Expected | The fields in this column display the total of the preceding column for sales and costs. This provides a forecast value for each based on what has been processed on the selected job and what future items are still open. |
Variance | The fields in this column display the difference between the Estimated Value column and the Expected Value column. |
Section Heading | Section Descriptions |
---|---|
Detail by Activity | This section is split into hours and costs and displays the hours, sales, and costs of the selected job according to the relative activity that they are recorded on. It shows previously reported information with a deeper level of detail. |
Hours Detail by Activity | This sub-section displays the sales value of hours according to the activity that they are recorded on. The hours are derived via the activity used on the Price Quotes (estimated hours), the activity on the time entry (actual hours), or the schedule. The numeric value of the hours is also reported here from the same data sources) |
Costs Detail by Activity | This sub-section displays the cost value of purchase items according to the activity that they are recorded on. It has a deeper level of detail compared to the data reported on the previous sub-section and is derived from the purchases on Price Quotes, the cost on open Purchase Orders, and the cost value of purchase invoices posted to the selected job. |
Section Heading | Section Descriptions |
---|---|
Open Purchase Order Detail by Activity | This section displays details of open Purchase Orders, separating each value by activity. The details that are provided are related to the tracking of costs based on created Purchase Orders. The created Purchase Orders, which are linked to Price Quotes, should list the Price Quote number. Indicated supplier names are taken from the Purchase Order supplier, but broken down further by activity. |
Column Heading | Column Descriptions |
---|---|
Purchase Order / PO Number | This field displays the Purchase Order number. |
Price Quote / PQ Number | This field displays the Price Quote number, which is linked to the Purchase Order. |
Supplier | This field displays the supplier name, which is taken from the Purchase Order. |
Activity | This field displays the activity related to the Purchase Order. |
Inv No | This field displays the Invoice number, which is linked to the Purchase Order and the related activity. |
Order Value | This field displays the total value of the Purchase Order. |
Invoice Value | This field displays the value derived from a Creditor Invoice, which is linked to the Purchase Order and the related activity. |
Open Purchase Order / Open POs | This field displays the remaining value of the Purchase Order line, net of the Invoice value. |
% MU | This field displays the margin applied to the cost of the line referred to in the Open PO field, expressed as a percentage. |
Costs + MU | This field displays the sales value of the line referred to in the Open PO field, calculated by the cost multiplied by the margin. |
Section Heading | Section Descriptions |
---|---|
Purchase Invoice Detail Not Related to Purchase Orders by Activity | This section displays details of expenses or vouchers that are not linked to any Purchase Orders, separated by activity. |
Column Heading | Column Descriptions |
---|---|
Supplier | This field displays the supplier name of the non-PO expense or voucher. |
Activity | This field displays the activity related to the non-PO expense or voucher. |
Inv No | This field displays the Invoice number, which is linked to the non-PO expense or voucher. |
Invoice Value | This field displays the value derived from a Creditor Invoice, which is linked to the non-PO expense or voucher. |
% MU | This field displays the margin applied to the cost of the line referred to in the non-PO expense or voucher, expressed as a percentage. |
Costs + MU | This field displays the sales value of the line referred to in the Invoice Value field, calculated by the cost multiplied by the margin. |
Section Heading | Section Descriptions |
---|---|
Sales Invoicing | This section displays a comparison of the total value of Price Quotes and the total value of Sales Invoices, separated by activity. It provides a list of created Sales Invoices with a summary of the billings of the selected job, what has been paid or settled against the invoice, and the outstanding balance. This data supports the Invoiced field in the Profitability and Completion section of this report. |
Column Heading | Column Descriptions |
---|---|
Sales Invoice Summary and Detail |
The fields that display the invoiced amount without VAT or Tax are used to reconcile the Sales Invoice against the job data, specifically in the Profitability and Completion section. On the other hand, the fields that display the invoiced amount with VAT or Tax are used to reconcile against the Debtors module in Finance & Administration. This same information is also provided at the Activity level, where the total of invoices is listed by activity and compared to the estimated value as per the sum of Price Quotes. The information in this section must be expressed excluding VAT or Tax. |
Secondary Chart of Accounts Trial Balance Report (Report 585)
Summary
This report shows the list of all General Ledger accounts, both of account type Operating Balance Sheet, which are mapped to their corresponding Secondary Chart of Accounts account names and numbers. Note that if there are more than one Operating account or Balance Sheet account that is mapped to the same Secondary Chart of Account, the balances of all of the accounts are added and displayed as the balance for that Secondary Chart of Account. This report does not include the General Ledger account that is designated as the Net Profit P/L Account, as configured in Settings » Basic Finance Settings.
The Header and Sum From account types are omitted by default and are not included in Report 585. It does not have any line break functionality and is sorted based on the Secondary Chart of Accounts code or account number.
Location
Navigate to
to run this report.Parameters
Parameter | Use |
---|---|
As of Date | This is the date on which you run the report. This is the only required parameter. |
Only show accounts with a balance | Select this checkbox to omit accounts that do not have balances. This omits from the report any account where the balance of transactions in the period sums to 0 (zero). |
Hide Horizontal Lines between Accounts | Select this checkbox to remove horizontal lines between accounts in the report. |
Currency | This report always shows figures in the Company currency of the Company for which you run it. The Currency selector is therefore locked; you cannot change it. |
Calculations
This report displays the balances of accounts split into a debit and a credit column, based on the calculations described here. These balances are always positive, but they are designated as being debit or credit based on which column they appear in. The sum of the debit column should equal the sum of the credit column, unless a year-end closure procedure has not been completed in a prior financial year (see the following note).
- For Operating Accounts, the balance is calculated as the sum of all transactions in the period from and including the first day of the current financial year, to and including the date that is specified by the As of Date parameter.
- For Balance Sheet Accounts the balance is calculated as the sum of all transactions where the booking date is before or equal to the date that is specified by the As of Date parameter.
- The Balance Sheet Account that is designated as the Retained Earnings Account, as configured in , shows a balance net of any year-end postings that have occurred in the finance year.
- The Operating Account that is designated as the Net Profit P/L Account, as configured in , is omitted from this report.
If you run the report with an As of Date that is within a finance year where a final year-end closure has not been completed, the debit and credit columns will still balance.
However, if you run this report with an As of Date where a final year-end closure has not been completed in any preceding financial years, the debit and credit columns will not balance. To resolve this, you must perform the year-end closure for that prior finance year to ensure that all earnings in that financial year are transferred to retained earnings in the Balance Sheet. Running the Trial Balance subsequent to all final year-end closure procedures being completed for all preceding finance years results in debit and credit columns balancing.