Description
The GL Transaction Enquiry in Profitz provides a centralised view of all general ledger transactions posted across jobs, accounts, and operational codes. This tool is essential for finance teams, project managers, and auditors who need to trace financial activity, validate postings, and reconcile GL accounts with job-level detail.
Product Overview
Purpose and Benefits
GL Transaction Enquiry enables users to:
- View detailed GL postings across jobs, accounts, and divisions
- Filter transactions by period, batch, operation code, and asset references
- Investigate individual entries using drill-down links
- Support financial audits, reconciliations, and cost tracking
This enquiry is especially useful for tracing cost allocations, validating GL account usage, and reviewing operational coding across financial periods.
How to Access
Navigate to Enquiries › GL Transaction Listing
Header Details and Filtering Options
When you open the GL Transaction Listing screen, you’ll see a header section where you can define the scope of your enquiry. These filters allow you to pinpoint specific transactions based on financial, operational, and asset-related criteria.
| Filter | Description |
|---|---|
| Division | Select a division code (e.g., DEMO) to isolate transactions by business unit |
| Account | Filter by GL account code to view postings to specific ledger accounts |
| From/To Period | Define a financial period range to restrict results to a specific timeframe |
| Batch | Filter by batch number to locate grouped transactions |
| Fixed Asset Code | View transactions linked to specific assets for capital tracking |
Click Get Results to display the filtered transaction list.
Key Features
Transaction Overview
Each row in the enquiry displays key financial and operational details:
| Column | Description |
|---|---|
| Transaction ID | Unique identifier for the GL transaction |
| SJ Invoice ID / Id | Source journal or system reference |
| Job No / Job Name | Job associated with the transaction |
| Batch | Batch number used during posting |
| Operation Code / Description | Cost code and description used for allocation |
| Date / Period | Transaction date and financial period |
| Account Code / GL Account Code | GL account used for posting |
| Tran Type | Type of transaction (e.g., invoice, adjustment) |
| Name | Creditor, debtor, or internal reference |
| Qty / Amount | Quantity and financial value of the transaction |
| Retention | Retention amount if applicable |
| Transaction Ref1 / Ref4 | Custom references used during posting |
| GL Account Description | Name or label of the GL account used |
Interactive Drill-Down
Any blue hyperlink in the report is clickable. Clicking a value opens a detailed view of the transaction.
Example: Clicking a Transaction ID or Amount opens a breakdown of the posting, including job allocation and GL coding.
Best Practices
- Use From/To Period filters to isolate monthly or quarterly activity
- Use Batch filters to reconcile grouped postings or journal entries
- Drill into Amount or Operation Code to validate cost allocations
- Use GL Account Description to confirm correct account usage
Limitations
- Only posted transactions will appear in the enquiry
- Drill-down is only available for transactions with detailed allocation data
FAQ
Can I view job-related GL transactions in this enquiry? Yes. Each transaction includes job number and job name fields for cost tracking.
Why can’t I see any results? Ensure your filters (e.g., period, division, account) are correctly set and that transactions have been posted.
Can I export the results? Yes. Use the export options in the toolbar to download the enquiry data.
Related Articles
Comments
0 comments
Please sign in to leave a comment.