Columns for Tax Analysis Report

The following columns are available for this report.

Field	Description
Concatenated Address	This column displays the individual's street address, city, state, and ZIP code. The report shows this information in a single column.
Currency Code	This column displays the currency used for the account.
Description 2	This column displays the second line of the description for the transaction.
Expense Account	This column displays the general ledger account number associated with the net (tax basis) amount for an expense transaction.
Firm Country	This column displays the country from the firm's address.
Fiscal Period	This column displays the accounting period in which the transaction was posted.
Gross Amount	This column displays the employee's gross pay amount.
Invoice/Reference Number	This column displays the invoice number associated with the transaction. Because a retainage invoice has the same invoice number as the original invoice from which it was withheld, Vantagepoint displays Retainage Billing in the Description column to distinguish it from the original invoice.
Net Amount/Tax Basis	In the Inputs (Purchases) section of the report, this column displays the net amount for the transaction or tax code. In the Outputs (Sales) section of the report, it displays the tax basis for the transaction or tax code. The tax basis can be either the net amount for the transaction or tax code or, if a compound tax is involved, the net amount plus a tax amount that is subject to the tax. For invoices from which retainage is withheld, the tax basis includes the retainage if the Tax Method option is set to Tax when Withheld under Sections to Apply Retainage on the More Calculations tab of the Billing Terms form (Hubs > Projects > Billing Terms). The tax basis does not include retainage if the option is set to Tax when Invoiced. In that case, the tax on the retainage amount is billed on the retainage invoice when the retainage is due. If you use multiple currencies, the report can display net amounts, tax basis amounts, and tax amounts in any of the following types of currency: transaction currency, functional currency, or tax currency (if tax auditing is enabled for the company). You specify the type of currency that you want to use in Report in, on the General tab of the Tax Analysis Options dialog box.
Non-Recoverable Tax	If you include this column in the Tax Analysis report, this column displays the portion of the transaction's tax amount that is non-recoverable. If you use multiple currencies, the report can display net amounts, tax basis amounts, and tax amounts in any of the following types of currency: transaction currency, functional currency, or tax currency (if tax auditing is enabled for the company). You specify the type of currency in Report in on the General tab on the Tax Analysis Options dialog box. If a tax is a reverse charge tax (specified as such in the Non-Recoverable Tax section on the Options tab in Settings > Cash Management > Tax Codes), this column is blank.
Phase	This column displays the phase number associated with the transaction.
Post Seq	This column displays the posting sequence number for the transaction. Vantagepoint assigns the sequence numbers during the posting process. Vantagepoint assigns 1 to the first group of transactions posted during an accounting period, 2 to the second group, and so on. To see a numbered list of all of the postings for the current accounting period, select Transaction Center > Posting Review from the Navigation pane.
Project	This column displays the project number associated with the transaction. If a transaction is not related to a project, no project number displays. No project number displays for balance sheet account transactions, except for accounts receivable transactions.
Project Country	This column displays the country in which the project is located.
Recoverable Tax	If you include this column in the Tax Analysis report, this column displays the portion of the transaction's tax amount that is recoverable. If you use multiple currencies, the report can display net amounts, tax basis amounts, and tax amounts in any of the following types of currency: transaction currency, functional currency, or tax currency (if tax auditing is enabled for the company). You specify the type of currency in Report in on the General tab of the Options for Tax Analysis dialog box. If a tax is a reverse charge tax (specified as such in the Non-Recoverable Tax section on the Options tab in Settings > Cash Management > Tax Codes), this column is blank.
Reverse Charge Tax	If a tax is a reverse charge tax (specified as such in the Non-Recoverable Tax section on the Options tab in Settings > Cash Management > Tax Codes), this column displays the reverse charge tax amount. The European Union Value Added Tax system has reverse charge taxes. With a reverse charge tax, the buyer of a good or service is responsible for recording a VAT transaction.
Row Count	This column displays the total number of detail lines for each group, based on the sorting and grouping selections. If the report groups data at more than one level, this column displays row counts for all grouping levels.
Task	This column displays the task number associated with the transaction.
Tax Account	This column displays the posting account for the tax code, specified in Settings > Cash Management > Tax Codes.
Tax Amount	This column displays the amount of tax for the transaction. If you use multiple currencies, you have the option to have the report display net amounts, tax basis amounts, and tax amounts in any of the following types of currency: transaction currency, functional currency, or tax currency (if tax auditing is enabled for the company). You specify the type of currency you want to use in Report in on the General tab of the Tax Analysis Options dialog box. If a tax is a reverse charge tax (specified as such in the Non-Recoverable Tax section on the Options tab in Settings > Cash Management > Tax Codes), this column displays the reverse charge tax amount. A reverse charge tax amount shows in the Tax Amount field in both the Inputs and the Outputs sections.
Tax Code	This column displays the tax code for the transaction.
Tax Code Description	This column displays the tax code description.
Tax Code Rate	This column displays the tax rate.
Tax Payable	If you include this column in the Tax Analysis report, this column displays the payable portion of the input tax for the transaction. If you are using multiple currencies, you have the option to have the report display net amounts, tax basis amounts, and tax amounts in any of the following types of currency: transaction currency, functional currency, or tax currency (if tax auditing is enabled for the company). You specify the type of currency in Report in on the General tab. If a tax is a reverse charge tax (specified as such in the Non-Recoverable Tax section on the Options tab in Settings > Cash Management > Tax Codes), this column displays the reverse charge tax amount. A reverse charge tax amount shows in the Tax Payable in both the Inputs and the Outputs sections.
Tax Point Date	This column displays the transaction date.
Tax Registration Number	This column displays the tax registration number (ID) for the resource or employee who is associated with the transaction.
Tax Type (Inputs/Outputs)	This column indicates whether a tax is an input tax, output tax, or both.
Transaction Type	This column displays the two-letter abbreviation for the type of transaction (such as CD for cash disbursements, IN for invoices, AP for accounts payable vouchers, and EX for employee expense reports).
Vendor/Client/Employee	This column displays, either the vendor, client, or employee ID.
Vendor/Client/Employee Name	This column displays the vendor, client, or employee name for the transaction.