Downloading GL & TB from Workday Financial Management

Reports must be in the accounting packages' native format, properly structured, include all required fields, and be free of formatting errors that could cause upload issues.

Introduction

• This guide will help you download the General Ledger (GL) and Trial Balance (TB) reports from Workday Financial Management, ensuring the data meets Validis' upload requirements.
• Reports should be exported in (.CSV), (.XLSX), or (.XLS) file format.
• File size must not exceed 100 MB.
• Reports must already contain the required fields without manual manipulation.

How to Extract a General Ledger Report

Step 1: Locate the General Ledger Report

• Log in to your Workday Financial Management system.
• Navigate to the Reports section.
• Select General Ledger Detail Report

Step 2: Set Report Parameters

• Choose the specific company to upload to, if applicable.
• Set the date range to match your reporting period (e.g., monthly, quarterly, year-end).
• Select the accounting basis (accrual or cash), if required.

Step 3: Configure Columns

• Ensure the report includes the following fields:
  • Account Name
  • Account Code
  • Transaction Date
  • Transaction Number or Reference
  • Transaction Balance
  • Transaction Description (Optional but recommended)

Step 4: Generate and Export the Report

• Click the Export icon
• Check that all expected account balances are included.
• Export the report in (.CSV), (.XLSX), or (.XLS) file format.
• Save the report securely for upload to the Validis portal.

How to Extract a Trial Balance Report

Step 1: Locate the Reporting Section

• Log in to your Workday Financial Management system.
• Navigate to the Reports or Financial Reports section.
• Search for or select Trial Balance from the report list.

Step 2: Configure Report Parameters

• Select the relevant company or legal entity, if applicable.
• Set the date range to match your reporting period (e.g., monthly, quarterly, year-end).
• Choose the accounting basis (accrual or cash), if required.
• Ensure that zero balance accounts are included, if available.
• Verify the report contains these fields:
  • Account Name
  • Account Code
  • Account Balance

Step 3: Generate and Export the Report

• Click the Export icon
• Check that all expected account balances are included.
• Export the report in (.CSV), (.XLSX), or (.XLS) file format.
• Save the report securely for upload to the Validis portal.