Previous  Next          Contents  Index  Navigation  Glossary  Library

US Sales Tax Report

Use this report to review your tax liability to the various tax authorities around the US. The US Sales Tax report includes all Invoices, Credit Memos, and Adjustments broken down by Ship To State, County, and City and lists taxable, exempt, and tax amounts. This report is used as the basis for the periodic Sales Tax Returns required by each state.

This report provides all of the transaction detail from your Receivables subledger to let you to reconcile these returns against your General Ledger balances. In addition, a summary is provided of the total amount exempt for each reason. The US Sales Tax report supports only accrual basis reporting and is only used for United States sales tax. See: US Sales Tax Reconciliation and Implementing US Sales Tax.

You submit this report from the Submit Requests window. See: Running Standard Reports and Listings.

Report Parameters

Transaction Date Range: Select and print sales tax information for the transaction date range you specify. This field is optional. If you specify a transaction date range but no GL date range, your report will not balance to the General Ledger if the transaction and GL dates for a transaction fall in different periods.

Note: For adjustment transactions, the transaction date refers to the transaction date of the invoice to which the adjustment applies.

GL Date Range: Select and print sales tax information for the GL date range you specify. The default is the first and last date of the prior accounting period. Use a GL date range to enable you to balance your US Sales Tax report against your General Ledger.

Warning: If you specify both a GL date range and a transaction date range, transactions with transaction and GL dates in different periods will not be printed in the report.

State Range: Select and print sales tax information for the State range you specify. The state information is generally derived from the ship-to-address of the transaction. If the ship-to-address is blank, Receivables derives the state information from the transaction's bill-to address.

Currency Range: Select and print sales tax information for the Currency range you specify.

Exemption Status: Enter an exemption status if you want the report to only list transactions which reference exemptions with that status. You can find all transactions using rejected exemptions by entering Rejected here.

Sales Tax Liability Account Range: This parameter only restricts Receivables Adjustment transactions. An Adjustment transaction is a Receivables feature that lets you increase or decrease the amount due of your invoice, debit memo, chargeback, deposit or guarantee. The report will exclude any Adjustment transactions posted to accounts outside the selected range. Invoice, Debit Memo and Credit Memo transactions that post to a general ledger account outside the selected account range are included in the report, but are tagged with an asterisk (*) in the footnote column. If no range is selected, all Adjustments will be displayed and no transactions will be tagged.

Detail Level: Select the level of detail to use for your report:

Order By: Select the option to use to sort your information. The report will first sort by tax authority and then by one of the following sort options that you select:

Posting Status: Select one of the following posting statuses to include on your report:

Show All Related Transactions: Enter Yes to view all invoices within the Transaction date range and all Adjusting Transactions (Credit Memos and Adjustments) that are related to that invoice. This parameter is only available when you provide a transaction date range.

See Also

Running Standard Reports and Listings

Receivables Standard Reports and Listings

Receivables Tax Reports


         Previous  Next          Contents  Index  Navigation  Glossary  Library