Reference: Tax Reconciliation Reports

These composite reports enable you to reconcile tax details on taxable transactions to tax ledger accounts.

Tax ledger accounts are the ledger accounts that you configure for these account posting rules:

Transaction Tax

Transaction Tax on Payment

The reports are secured the Report Execution
domain in the Tenant Non-Configurable functional area. To view data in the reports, you also need access to the Reports: Transaction Tax
domain in these functional areas:

Common Financial Management

Customer Accounts

Tax Declaration to General Ledger Reconciliation

You can use this report after you create draft tax declarations to reconcile against each other:

The net activity of tax accounts based on tax details for selected tax declarations.

Tax ledger period activity for the selected tax authority.

Columns and Groupings	Considerations
Company Ledger Account	The report only includes ledger accounts that have reportable tax details. Example: For VAT-on-payment transactions, we record tax at the time of invoice and at the time of payment. Since VAT is reportable at the time of payment, the report excludes tax details recorded at the time of invoice.
Tax Declaration Totals	Enables you to review the sums of tax details for: All taxable transactions included in the selected tax declarations. Transactions that have an accounting date outside of the selected start and end dates. Transactions that have an accounting date within the selected start and end dates.
General Ledger Activity Totals	Enables you to review details and total amounts for journal lines with: Corresponding tax details for the selected tax authority. An accounting date within the selected start and end dates.
Transactions Suggested for Review	Enables you to drill down into tax reconciliation activities for taxable transactions: With an accounting or tax point date between the selected start and end dates. That aren't included in the selected tax declaration. When you use the accounting date as the tax declaration report date, you only need to review the Based on Accounting Date column. For any other tax declaration report date configuration, you only need to review the Based on Tax Point Date column. See Create Tax Declaration Components.

Tax Reconciliation Initial Balances

You can use this report to identify discrepancies between expected initial tax balances based on tax details and adjusted ledger activity before the start of the initial period for reconciliation.

Columns and Groupings	Considerations
Company Ledger Account Tax Rate	The report displays tax balances before the start of the initial period for reconciliation for each of the company's balance sheet tax ledger accounts, broken out by tax rate.
Tax Ledger Ending Balance Total Ledger Activities Without Tax Details Adjusted Tax Ledger Ending Balance	Enables you to review the actual ledger activity before the initial period for reconciliation. Workday calculates the adjusted tax ledger ending balances by deducting amounts for transactions booked to tax accounts that don't have tax details from tax ledger ending balances. Example: Payments booked to the ledger accounts with no tax details.
Tax Initial Balance	Enables you to: Review the totals of taxable transactions with tax details before the initial period for reconciliation. Drill down on initial balance tax activity.

Transaction Tax Reconciliation

You can use this report at period close to reconcile against each other:

Expected ending tax balances based on period beginning balances and tax details created during the selected period.

Adjusted tax ledger ending balances.

Columns and Groupings	Considerations
Company Ledger Account Tax Rate	The report displays tax balances for each of the company's balance sheet tax ledger accounts, broken out by tax rate.
Taxable Transactions Balance in Company Currency	Workday calculates the expected tax balances at the end of the period based on tax reconciliation activities for tax details that have an accounting date within the selected period.
Tax Ledger Balance in Company Currency	Workday calculates the adjusted tax ending balances by deducting amounts for transactions booked to tax accounts that don't have tax details from tax ledger ending balances. Example: Payments booked to the ledger accounts with no tax details.
Tax Activities with Journal Errors	This column enables you to identify taxable transactions where the corresponding journal has an error.
Future Period Tax Activities	This column enables you identify taxable transactions that have a transaction date during the selected period, but an accounting date outside of the period. Example: A supplier invoice with a transaction date in November and an accounting date in December.