Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Logs

D2C merge tax acctg logs

In addition to the Input, Journal, and Ledger tax accounting logs, 2 ONESOURCE Indirect Tax Determination Merge tax accounting logs are available.
  1. D2C Review
  2. D2C Unreported Tax logs.
These logs can be used as an aid in reviewing and reconciling balance data imported into Sales and Use Tax Compliance using the ONESOURCE Indirect Tax Determination extract file. As with the first 3 logs, these 2 logs provide extracted information to comma delimited .csv files.

Determination Merge review

The D2C Review tax accounting log displays the records imported using the ONESOURCE Indirect Tax Determination extract file aggregated by location and place code, showing the gross, exemption, and tax amounts for each tax authority associated with the place code.
There are 3 review columns for tax in the D2C Review tax accounting log; Input, Ledger, and Review. The Input tax column's the tax from the extract input file. The Ledger tax column reflects the tax in the ledger after compute to move the input taxes to the ledger. The Review tax column's simply a computation of taxable times the tax rate found in the system for the tax authority as a comparison to the Input and Ledger tax.
There are instances where Sales and Use Tax Compliance and Determination differ as to the taxing authority level a tax is carried. Within the D2C Review tax accounting log there's a column labeled
Special
. This column will be blank or display Multi Tax or Tax Only. Multi Tax will display in the Special column when Determination carries the city, county, and district tax for a place code aggregated to a single tax authority level (city or county tax authority) and Sales and Use Tax Compliance carries the tax at each of the tax authority levels associated with the place code.
For example:
Tax level
Tax authority
Gross
Exempt
Taxable
Rate
Ledger tax
Input tax
Review tax
Special
STATE
STATE A
1000
0
1000
0.065
65
65
65
N/A
COUNTY
COUNTY B
1000
0
1000
0.005
0
0
5
MultiTax
CITY
CITY C
1000
0
1000
0.005
12
12
5
N/A
DISTRICT
DISTRICT D
1000
0
1000
0.002
0
0
2
MultiTax
Tax Only
 will display in the
Special
 column when Determination carries a tax as multiple tax authorities and Sales and Use Tax Compliance carries it as a single tax authority. The D2C Review log will zero the basis amount for the extra tax authority as to not overstate the basis amount on the tax return.
Tax level
Tax authority
Gross
Exempt
Taxable
Rate
Ledger tax
Input tax
Review tax
Special
STATE
STATE A
1000
0
1000
0.050
50
50
50
N/A
COUNTY
COUNTY B
1000
0
1000
0.010
10
10
10
N/A
CITY
CITY C 1
1000
0
1000
0.010
5
5
10
N/A
CITY
CITY C 2
0
0
0
0.000
5
5
0
Tax Only
These fields are included in the D2C Review tax accounting log:
  • Entity
  • Region
  • Location
  • D2C Place Code
  • D2C Tax Type
  • Tax Type
  • Tax Level
  • Tax Authority
  • Gross
  • Exempt
  • Taxable
  • Rate
  • Ledger Tax
  • Input Tax
  • Review Tax
  • Special
  • Tax Name
  • D2C Tax Code Description
  • Tax Area County
  • Tax Area City
  • Tax Area Districts
  • D2C Tax Code
  • Place Determination
  • Input Source

D2C Unreported Tax

The D2C Unreported Tax tax accounting log displays records imported using the Determination extract file that Sales and Use Tax Compliance was unable to find a match for the Determination tax code. Therefore the tax for the tax authority won't be reflected in the ledger nor reported on a tax return. In most cases this will be a tax type not currently supported by Sales and Use Tax Compliance..
The following fields are included in the D2C Unreported Tax tax accounting log:
  • Entity
  • Region
  • Location
  • D2C Place Code
  • Tax Area County
  • Tax Area City
  • Tax Area Districts
  • D2C Tax Code Description
  • Tax Level
  • Tax Authority
  • Unreported Tax
  • D2C Tax Code
  • D2C Tax Type
  • Tax Type
  • Tax Area
  • Place Determination
  • Input Source

This article applies to:

  • Product: ONESOURCE Sales and Use Tax Compliance, ONESOURCE Indirect Tax