PayrollReviewDetail
Produces detailed payroll review reports, showing how QuickBooks calculates taxes on paychecks and year-to-date transactions.
Columns
| Name | Type | References | Description |
| Label | String | A label representing a specific category or grouping within the Payroll Review Detail report. | |
| Date | Date | The date of the payroll transaction, providing a chronological reference for the data. | |
| Entered_Last_Modified | String | The date and time when the payroll transaction was entered or last modified. | |
| Tax_Table_Version | String | The version of the tax table used to calculate payroll taxes for the transaction. | |
| Income_Subject_To_Tax | Double | The portion of income that is subject to taxation for the specified payroll transaction. | |
| Wage_Base | Double | The base wage amount used as the basis for calculating payroll taxes. | |
| Payroll_Tax_Rate | Double | The rate at which payroll taxes are applied to the wage base. | |
| User_Edit_ | String | Indicates if the transaction was manually edited by a user, providing traceability for adjustments. | |
| Amount | Double | The monetary amount associated with the payroll transaction, such as deductions or earnings. | |
| Calculated_Amount | Double | The system-calculated amount for the payroll transaction based on tax rates, wage base, or other criteria. | |
| Amount_Difference | Double | The difference between the user-entered amount and the calculated amount, highlighting discrepancies. | |
| RowType | String | Specifies the type of data in the row, such as Text, Data, Subtotal, or Total. |
Pseudo-Columns
Pseudo Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| ReportPeriod | String | The report's date range in the format fromdate:todate, where either value may be omitted for an open-ended range (for example, 2024-12-25:). Supported date format: yyyy-MM-dd. The allowed values are ALL, TODAY, THISWEEK, THISWEEKTODATE, THISMONTH, THISMONTHTODATE, THISQUARTER, THISQUARTERTODATE, THISYEAR, THISYEARTODATE, YESTERDAY, LASTWEEK, LASTWEEKTODATE, LASTMONTH, LASTMONTHTODATE, LASTQUARTER, LASTQUARTERTODATE, LASTYEAR, LASTYEARTODATE, NEXTWEEK, NEXTFOURWEEKS, NEXTMONTH, NEXTQUARTER, NEXTYEAR. | |
| AccountType | String | Specifies the type of accounts to include in the report. The allowed values are NONE, ACCOUNTSRECEIVABLE, ACCOUNTS PAYABLE, BANK, INCOME, EXPENSE, and others. | |
| AccountList | String | A comma-separated list of account names or IDs to include in the report. Specify AccountListType for additional filtering. | |
| AccountListType | String | Defines the format for querying account lists. The allowed values are LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN. | |
| EntityType | String | The type of entities to include in the report. The allowed values are NONE, CUSTOMER, EMPLOYEE, VENDOR, OTHERNAME. | |
| EntityList | String | A comma-separated list of entity names or IDs to include in the report. Specify EntityListType for additional filtering. | |
| EntityListType | String | Defines the format for querying entity lists. The allowed values are LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN. | |
| ItemType | String | The type of items to include in the report. The allowed values are NONE, INVENTORY, SERVICE, DISCOUNT, SALES, FIXEDASSET, and others. | |
| ItemList | String | A comma-separated list of item names or IDs to include in the report. Specify ItemListType for additional filtering. | |
| ItemListType | String | Defines the format for querying item lists. The allowed values are LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN. | |
| ClassList | String | A comma-separated list of class names or IDs to include in the report. Specify ClassListType for additional filtering. | |
| ClassListType | String | Defines the format for querying class lists. The allowed values are LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN. | |
| TransactionTypes | String | A comma-separated list of transaction types to include in the report. Supported values include ALL, INVOICE, SALESRECEIPT, BILL, PAYCHECK, and others. | |
| ModifiedDateRange | String | Filters transactions based on modification date within the format fromdate:todate. The allowed values are ALL, TODAY, THISWEEK, THISWEEKTODATE, THISMONTH, THISMONTHTODATE, THISQUARTER, THISQUARTERTODATE, THISYEAR, THISYEARTODATE, YESTERDAY, LASTWEEK, LASTWEEKTODATE, LASTMONTH, LASTMONTHTODATE, LASTQUARTER, LASTQUARTERTODATE, LASTYEAR, LASTYEARTODATE, NEXTWEEK, NEXTFOURWEEKS, NEXTMONTH, NEXTQUARTER, NEXTYEAR. | |
| DetailLevel | String | Determines the level of detail included in the report. The allowed values are ALL, ALLEXCEPTSUMMARY, SUMMARYONLY. | |
| PostingStatus | String | Specifies whether to include posting or non-posting transactions, or both. The allowed values are POSTING, NONPOSTING, EITHER. | |
| ReportAsOf | String | Specifies the date for generating open balance information in the report. The allowed values are REPORTENDDATE, TODAY. | |
| SummarizeColumnsBy | String | Controls how columns are labeled and data is calculated in the report. The allowed values are NONE, ACCOUNT, CUSTOMER, PAYEE, ITEMTYPE, and others. | |
| IncludeColumns | String | A comma-separated list of columns to include in the report. Examples: ACCOUNT, AMOUNT, DATE, MEMO, TAXTABLEVERSION. | |
| IncludeAccounts | String | Specifies whether to include all accounts or only those currently in use. The allowed values are ALL, INUSE. | |
| SummarizeRowsBy | String | Controls how rows are organized and labeled in the report. The allowed values are NONE, ACCOUNT, CLASS, CUSTOMER, PAYEE, ITEMTYPE. |