Comprehensive guide to AvaTax for Communications reports and data files
Overview
AvaTax for Communications (AFC) provides clients with numerous informational reports and files which contain mappings, cross-reference tables and data that can be helpful for building and maintaining an indirect tax-integrated billing system.
While the AFC engine is designed to generate some of these reports and files by default, there are many which are not automatically created; however, the data remains available and can be provided to clients if requested.
Please note that changes or settings in configuration options may impact the ability of AFC to generate reports automatically. In an effort to identify reports that are generated by default versus data that remains available to create reports by request of the client, the following terms are referenced throughout this document:
- Generated By Default: The AFC product routinely generates or creates the appropriate reports. The reports may or may not be provided to the client automatically.
- Received By Default: The AFC product routinely distributes or delivers the generated reports.
- Available Upon Request: No reports are routinely generated or distributed; however, the data to create such reports is available. A change in configuration options, settings or a formal request to Avalara can allow the report to be generated.
The table below provides a high-level overview of the various reports and files available by AFC product. Please reference Section 2 Report Descriptions or Section 3 File Descriptions to determine specific details such as, if data is generated by default, distributed by default or available upon request.
Overview of Report Availability By Product |
AFC License |
AFC SaaS Standard |
AFC SaaS Pro |
---|---|---|---|
AFC Engine Reports |
|||
Transaction/Service Report |
X |
X |
X |
Audit Transaction/Service Report |
X |
X |
X |
No Tax Log Report |
X |
X |
X |
Reconciliation Report |
X |
X |
X |
Audit Reconciliation Report |
X |
X |
|
EZtax Log |
X |
|
|
Transaction Count Report |
X |
|
|
Batch Processor & Stored Procedures |
|||
Detail Log Report |
|
X |
X |
Bridge Conferencing Report |
|
|
X |
EZtax_20 Utility |
X |
|
|
Compliance Reports |
|||
Customer Billable Amounts |
X |
X |
X |
Tax Compliance Amounts |
X |
X |
X |
Non-Billable Compliance Amounts |
X |
X |
X |
Billable Non-Compliance Amounts |
X |
X |
X |
Billable Amounts Combined with Non-Billable Amounts |
X |
X |
X |
Custom and Sorting Reports |
|||
Srtcomma20 Utility |
X |
X |
X |
Srtcomma20l Utility |
X |
X |
X |
Srtcomma20ld Utility |
X |
X |
X |
Srtcommadetail Utility |
X |
X |
X |
Customsort Utility |
X |
X |
X |
STRG Utility |
X |
X |
X |
Ezlogns Utility |
X |
|
|
Ezlogcust Utility |
X |
|
|
Ezlogcustios Utility |
X |
|
|
Ezlogcustpts Utility |
X |
|
|
Ezlogcustptslnl Utility |
X |
|
|
Srtcdf20, srtcdf20p |
X |
X |
|
ASCIILOG Utility |
X |
X |
|
Data Files |
|||
Tax_type.exp |
X |
X |
X |
All_adr.txt |
X |
X |
X |
Calculationtype.txt |
X |
X |
X |
Fipspcd.txt, pcdfips.txt |
X |
X |
X |
Npanxx7.txt |
X |
X |
X |
Transerv.txt, transervdesc.txt, transerserdescsau.txt |
X |
X |
X |
Report Descriptions
AFC Engine Reports
Transaction/Service Report
Description
By default, all clients receive the Transaction/Service Jurisdiction Report (TSR). This is the main revenue report and includes original revenue generated for jurisdictions. However, this report does not provide local level details for jurisdictions due to memory issues.
Note: Any excluded taxing jurisdictions will appear as unknown or not be included in the report.
Report Format and Sample Data
Transaction Service Report Format and Sample Data
Extension | .tsr | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Comma Delimited | |||||||||||||
Sample Data | Column Headers | |||||||||||||
TSR (Bundled version) – Original Format Jurisdiction, BundlePackage, BundleId, TransactionType, ServiceType, Charge TSR (Non-Bundled version) – Original Format Jurisdiction, TransactionType, ServiceType, Charge |
||||||||||||||
Definitions for Transaction Service Reports |
||||||||||||||
|
||||||||||||||
Sample | ||||||||||||||
TSR (Bundled version) USA, 20000, 20001, 5, 6, 300.000000 USA, 20000, 20001, 16, 6, 400.000000 USA, 20000, 20001, 19, 6, 300.000000 USA, 21000, 21001, 5, 6, 272.288730 USA, 21000, 21001, 16, 6, 363.051640
TSR (Non-Bundled version) USA, 5, 6, 1300.000000 USA, 16, 6, 2900.000000 USA, 19, 6, 1300.000000 CAN, 5, 6, 650.000000 CAN, 16, 6, 1450.000000 |
Availability of Reports
This report is generated by the AFC Engine. Please reference the table below for additional details regarding availability of reports by product.
Transaction Service Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
---|---|---|---|---|---|
AFC License |
X |
X |
|
Logging Directory |
|
AFC SaaS Standard |
X |
X |
|
Report zip file |
|
AFC SaaS Pro |
|
|
X |
Emailed in zip file if requested. |
Upon request, this report can be produced and provided. |
Audit Transaction/Service Report
Description
By default, all clients receive the Audit Transaction/Service Jurisdiction Report (TSR). This report is produced in addition to the original TSR. Similar to the original TSR, the report contains the main revenue report and includes original revenue generated for jurisdictions. However, this report does not provide local level details for jurisdictions due to memory issues. This audit version of the TSR is in CSV format and includes two additional columns, Start Date and End Date, which contain a timestamp for the report as well as headers for each of the columns of data.
Note: Any excluded taxing jurisdictions will appear as unknown or not be included in the report.
Report Format and Sample Data
This report is generated by the AFC Engine. Please reference the table below for additional details regarding availability of reports by product.
Audit Transaction Service Report Format and Sample Data
Extension | _audit.tsr.csv | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Comma Delimited | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sample Data | Column Headers | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TSR (Bundled version) – CSV Format Jurisdiction, BundlePackage, BundleId, TransactionType, ServiceType, Charge, Start Date, End Date
TSR (Non-Bundled version) – CSV Format Jurisdiction, TransactionType, ServiceType, Charge, Start Date, End Date |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Definitions for Audit Transaction Service Reports | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sample | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TSR (Bundled version) - CSV Format
TSR (Non-Bundled version) – CSV Format
|
Availability of Reports
Audit Transaction Service Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
---|---|---|---|---|---|
AFC License |
X |
X |
|
Logging Directory |
In addition to the existing report provided in original format, this audit version of the report is produced and provided in CSV format. The audit version of the report name is XXXX_ audit.tsr.csv. |
AFC SaaS Standard |
X |
X |
|
Report zip file |
|
AFC SaaS Pro |
|
|
X |
Emailed in zip file if requested. |
Upon request, this report can be produced and provided in CSV format. |
No Tax Log Report
Description
This report contains Transaction/Service data that was processed but did not generate any taxes.
Report Format and Sample Data
No Tax Log Report Format and Sample Data
Extension | .ntl | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Comma Delimited but fixed length | |||||||||||||||
Sample Data | Column Headers | |||||||||||||||
Short Format Version: If the log file is set to short (do not display OptionalAlpha1) - Company ID, Customer Number, Transaction Type, Service Type, P Code, Charges Long Format Version: If the log file is set to long (show OptionalAlpha1) - Company ID, Customer Number, Optional Alpha 1 Field, Transaction Type, Service Type, P Code, Charges |
||||||||||||||||
Definitions for No Tax Log Report | ||||||||||||||||
|
||||||||||||||||
Sample | ||||||||||||||||
Short Format Version - identified company, customer number 4321, 000, 0000, 1249200, 53.27000 identified company, customer number 4321, 000, 0001, 1249200, 53.27000 identified company, customer number 4321, 000, 0002, 1249200, 53.27000
Long Format Version - identified company, customer number 4321, True, 000, 0000, 1249200, 53.27000 identified company, customer number 4321, True, 000, 0001, 1249200, 53.27000 identified company, customer number 4321, False, 000, 0002, 1249200, 53.27000 |
Availability of Reports
This report is generated by the AFC Engine. Please reference the table below for additional details regarding availability of reports by product.
No Tax Log Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
---|---|---|---|---|---|
AFC License |
|
|
X |
Logging Directory |
Only generated by default if configuration options are set properly by the user. |
AFC SaaS Standard |
|
|
X |
Report zip file |
Can set to generate by default if needed. Only included if requested by customer. Also, in addition to the existing format, a CSV version of this report is available. |
AFC SaaS Pro |
|
|
X |
Emailed in zip file if requested. |
Can set to generate by default if needed. Only included if requested by customer. |
Reconciliation Report
Description
The Reconciliation Report contains the same columns as the TSR and an extra column for any tax inclusive charge calculations. This report is only produced upon the request of the client.
Report Format and Sample Data
Extension | .rtr | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Comma Delimted | |||||||||||||||
Sample Data | Column Headers | |||||||||||||||
Jurisdiction, BundlePkg, BundleId, Trans, Svc, Charge, CalcCharge |
||||||||||||||||
Definitions for Reconciliation Report | ||||||||||||||||
|
||||||||||||||||
Sample | ||||||||||||||||
USA, 0, 0, 10, 15, 300.000000, 300.000000 USA, 0, 0, 16, 37, 200.000000, 200.000000 CA, 0, 0, 10, 15, 300.000000, 300.000000 CA, 0, 0, 16, 37, 200.000000, 200.000000 USA, 0, 0, 10, 15, 300.000000, 300.000000 USA, 0, 0, 16, 37, 200.000000, 200.000000 CA, 0, 0, 10, 15, 300.000000, 300.000000 CA, 0, 0, 16, 37, 200.000000, 200.000000 USA, 0, 0, 10, 15, 300.000000, 300.000000 USA, 0, 0, 16, 37, 200.000000, 200.000000 |
Availability of Reports
This report is generated by the AFC Engine. Please reference the table below for additional details regarding availability of reports by product.
Reconciliation Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
AFC License |
|
|
X |
Logging Directory |
Only generated by default if configuration options are set properly by the user. |
AFC SaaS Standard |
|
|
X |
Report zip file |
Can set to generate by default if needed. Only included if requested by customer. |
AFC SaaS Pro |
|
|
X |
Emailed in zip file if requested. |
Report is currently not available; however, the data is accessible if requested by the customer. It can be implemented or created if needed. |
Audit Reconciliation Report
Description
The Audit Reconciliation Report contains the same columns as the Audit TSR and an extra column for any tax inclusive charge calculations. This audit version of the reconciliation report is in CSV format and includes two additional columns, Start Date and End Date, which contain a timestamp for the report as well as headers for each of the columns of data.
This report is only produced upon the request of the client.
Report Format and Sample Data
Audit Reconciliation Report Format and Sample Data
Extension | _audit.rtr.csv | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Comma Delimited | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sample Data | Column Headers | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Reconciliation Report (Bundled version) – CSV Format Jurisdiction, BundlePkg, BundleId, Trans, Svc, Charge, CalcCharge, Start Date, End Date
Reconciliation Report (Non-Bundled version) – CSV Format Jurisdiction, Trans, Svc, Charge, CalcCharge, Start Date, End Date |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Definitions for Audit Reconciliation Report | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sample | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Reconciliation Report (Bundled version) – CSV Format
Reconciliation Report (Non-Bundled version) – CSV Format
|
Availability of Reports
This report is generated by the AFC Engine. Please reference the table below for additional details regarding availability of reports by product.
Audit Reconciliation Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
---|---|---|---|---|---|
AFC License |
|
|
X |
Logging Directory |
Only generated by default if configuration options are set properly by the user. In addition to the existing report provided in original format, this audit version of the report is produced and provided in CSV format. The audit version of the report name is XXXX_ audit.rtr.csv. |
AFC SaaS Standard |
|
|
X |
Report zip file |
Can set to generate by default if needed. Only included if requested by customer. In addition to the existing report provided in original format, this audit version of the report is produced and provided in CSV format. The audit version of the report name is XXXX_ audit.rtr.csv. |
AFC SaaS Pro |
|
|
X |
Emailed in zip file if requested. |
Report is currently not available; however, the data is accessible if requested by the customer. It can be implemented or created if needed. |
Eztax Log (logfilename.log)
Description
This report is used by reporting utilities to produce customer billing and compliance reports.
Report Format
EZtax Log Report Format
Extension |
.log |
---|---|
File Format |
Binary |
Availability of Reports
This report is generated by the AFC Engine. Please reference the table below for additional details regarding availability of reports by product.
EZtax Log Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
---|---|---|---|---|---|
AFC License |
|
|
X |
Logging Directory |
This report is currently available. |
AFC SaaS Standard |
|
|
|
|
This report is currently not available. |
AFC SaaS Pro |
|
|
|
|
This report is currently not available. |
Transaction Count Report
Description
This report provides a breakdown of all transactions processed. Similar to the tsr report, it will append new entries to the end of the file, and is written out when the session is closed. By default this report is set to generate a detailed license report. Please refer to the AFC Transaction Count Report Summary document for additional details on this report.
Report Format
Transaction Count Report Format and Sample Data
Extension | .rpt | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Comma Delimited | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sample Data | Detail Report Column Headers | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Client, Platform, Module, Market, Trans, Svc, LicenseId, Authorized, Count, Start Date, End Date | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Definitions for Detail Transaction Count Report | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Detail Report Sample | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Summary Report Column Headers | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Client, Platform, Module, Market, LicenseId, Authorized, Count, Start Date, End Date | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Definitions for Summary Transaction Count Report | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Summary Report Sample | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Availability of Reports
This report is generated by the AFC Engine. Please reference the table below for additional details regarding availability of reports by product.
Transaction Count Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
---|---|---|---|---|---|
AFC License |
X |
X |
|
Working Directory |
The detailed report is generated by default. The file will be named the same as the log file with the extension license.rpt. If logging is disabled, the status file name will be used. If logging is disabled, the status file name will be used. The report will not be created and/or updated until the session is terminated. For example, if the log is EZTax.log, the report will be named EZTax.license.rpt and if the log is EZTax9.log then the report will be named EZTax9.license.rpt. |
AFC SaaS Standard |
|
|
|
|
This report is currently not available. |
AFC SaaS Pro |
|
|
|
|
This report is currently not available. |
Batch Processor & Stored Procedure Reports
Detail Log Report
Description
This report contains all the details of the Input file provided by the client combined with tax results. It is only available to SaaS Clients as it's not produced by AFC engine.
Note: Please be aware that one input transaction may result in one or more tax results or lines of data.
Report Format and Sample Data
Detail Log Report Format and Sample Data
Extension |
.csv or dtl.rpt Note: AFC SaaS Pro – {CompanyCode}_log{YYYYMMDD}.csv; AFC SaaS Standard – {InputFilename}_dtl.rpt |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Comma Delimited but fixed length | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sample Data | Column Headers | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TelecomTransactionID, AdjustmentMethod, BillToCountry, BillToState, BillToCounty, BillToLocality, BillToZipcode, BillToZipP4, BillToFipsCode, BillToNpaNxx, BillToPCode, BusinessClass, Charge, CompanyIdentifier CountyExempt, CountyPCode, CustomerNumber, CustomerType, Date, OriginalTransactionDate*,Debit, DiscountType, ExemptionType, FacilitiesBased, FederalExempt, FederalPCode, Franchise, Incorporated, InvoiceNumber, LifeLine, TransactionLines, LocalExempt, LocalPCode, TransactionLocations, TransactionMinutes, Optional, Optional4, Optional5, Optional6, Optional7, Optional8, Optional9, Optional10, OptionalAlpha1, OriginationCountry, OriginationState,OriginationCounty, OriginationLocality, OriginatinoZipCode, OriginationZipP4, OriginationFipsCode, OriginationPCode, Regulated, Sale, ServiceClass, ServiceLevelNumber, ServiceType, StateExempt, StatePCode, TerminationCountry, TerminationState, TerminationCounty, TerminationLocality, TerminationZipCode, TerminationZipP4, TerminationFipsCode, TerminationNpaNxx, TerminationPCode, TransactionType, BundlePackage*, BundleId*, TransactionCharge*, CountryISO, State, ProvinceState*, County, Locality, PCode, TaxTypeID,TaxType, TaxLevelID, TaxLevel, Rate, CalculationType, TaxAmount, GrossSales, ExemptSaleAmount, Adjustments, NetSales, TaxDataLines, TaxDataLocations, TaxDataMinutes, Billable, Compliance, BridgeConf, ProcessingDate*, IsAdjustment*, ErrorMessage*, OptionalField1, OptionalField2, OptionalField3, OptionalField4, OptionalField5, OptionalField6, OptionalField7, OptionalField8, OptionalField9, OptionalField10 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Definitions | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
*Note: BundlePackage, BundleId, TransactionCharge, ProcessingDate, IsAdjustment and ErrorMessage columns only apply to the detail log report for bundled transactions. **Note: For AFC SaaS Pro clients, the OptionalField column headers will remain until user overrides this default. Due to the level of complexity, please submit a support case for a sample Detail Log Report which includes columns for the Extended Optional fields. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sample | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Detail Log report sample data.rpt |
Availability of Reports
This report is generated by the batch processor and stored procedures. Please reference the table below for additional details regarding availability of reports by product.
Detail Log Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
---|---|---|---|---|---|
AFC License |
|
|
|
Working Directory |
This report is currently not available. |
AFC SaaS Standard |
|
|
X |
Report zip file |
Can set to generate by default if needed. Currently, it is included at the request of the customer. Only made available for clients using the new Extended format. In addition to the existing format, a CSV version of this report is available. |
AFC SaaS Pro |
|
|
X |
Emailed in zip file if requested. |
This report is not currently generated by default; however, it can be set to generate by default if needed. Currently, it is included at the request of the customer. |
Bridge Conferencing Report
The Bridge Conferencing feature is currently in development at this time. Please refrain from using this feature as well as the proposed solutions and APIs until further notice.
Compliance Reports
Customer Billable Amounts
Description
The Customer Billable Amounts reports is summarized, fixed position customer information report primarily used by clients for Billing purposes. Produced for clients configured for standard compliance reporting. Never requested by SaaS Pro Clients.
Report Format and Sample Data
Customer Billable Amounts Report Format and Sample Data
Extension | .csf (customer sort format) | |||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Fixed Postion | |||||||||||||||||||||||||||||||||||||||||||||||
Sample Data | Column Headers | |||||||||||||||||||||||||||||||||||||||||||||||
Data Specification for Output (.CSF) Files Customer Number, Tax Type, Tax Level, Tax Amount Sign, Tax Amount, File Record Length
Data Specification for Output (.CSF) Files Sorted with SrtComma20.exe and SrtComma20l.exe With –pcsf specified after input name Primary Output Key, Tax Type, Tax Level, Tax Amount Sign, Tax Amount, PCode, File Record Length |
||||||||||||||||||||||||||||||||||||||||||||||||
Definitions for Customer Billable Amounts Data Specification for Output (.CSF) Files | ||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||
Definitions for Data Specification for Output (.CSF) Files Sorted with SrtComma20.exe and SrtComma20l.exe With –pcsf specified after input name | ||||||||||||||||||||||||||||||||||||||||||||||||
|
Availability of Reports
This report is generated by srtcomma20l. Please reference the table below for additional details regarding availability of reports by product.
Customer Billable Amounts Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
---|---|---|---|---|---|
AFC License |
X |
X |
|
Working Directory |
This report is generated by default. |
AFC SaaS Standard |
X |
X |
|
Report zip file |
Clients configured for compliance reporting receive this report by default. It is generated as the batch of transactions are processed. |
AFC SaaS Pro |
|
|
X |
Emailed in zip file if requested. |
This report is currently not available; however, the data is accessible if requested by the customer. |
Tax Compliance Amounts
Description
This is the primary Compliance file and provides a summarized, standard billable tax report. Clients configured for compliance reporting receives it by default in comma delimited format. SaaS pro clients receives it monthly (Assumed Date method 0 unless specified).
Report Format and Sample Data
Tax Compliance Amounts Format and Sample Data
Extension | .ssf | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Comma Delimited | |||||||||||||||||||||||||||
Sample Data | Column Headers | |||||||||||||||||||||||||||
Country, State, Locality, Tax Type, Tax Level, Tax Rate, Tax Amount, Gross Sale, Exempt, Adjustments, Taxable Measure, Minutes | ||||||||||||||||||||||||||||
Definitions for Tax Compliance Amounts Comma Delimited SSF File Format |
||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
Sample | ||||||||||||||||||||||||||||
USA,,,, 6, 0, 0.030000, 29881.866905, 996062.252444, 0.000000, 0.000000, 996062.252444, 14859213.000000 USA,,,, 7, 0, 0.007600, 10116.132171, 1331070.000000, 0.000000, 0.000000, 1331070.000000, 20410578.000000 USA,,,, 18, 0, 0.031400, 11145.492379, 354952.000000, 0.000000, 0.000000, 354952.000000, 5446827.000000 USA, AL, , , 16, 1, 0.067000, 969.972210, 14477.196802, 0.000000, 0.000000, 14477.196802, 220238.671875 USA, AZ, , , 1, 1, 0.050000, 0.806080, 16.121600, 0.000000, 0.000000, 16.121600, 245.280014 USA, AZ, , , 10, 1, 0.012500, 9.068400, 725.472000, 0.000000, 0.000000, 725.472000, 11037.642578 USA, AZ, , , 12, 1, 0.011000, 7.980192, 725.472000, 0.000000, 0.000000, 725.472000, 11037.642578 USA, AZ, APACHE, , 1, 1, 0.050000, 0.806080, 16.121600, 0.000000, 0.000000, 16.121600, 245.280014 USA, AZ, APACHE, , 1, 2, 0.027000, 0.435283, 16.121600, 0.000000, 0.000000, 16.121600, 245.280014 USA, AZ, APACHE, SPRINGERVILLE, 1, 1, 0.050000, 0.705320, 14.106400, 0.000000, 0.000000, 14.106400, 214.620010 |
Availability of Reports
This report is generated by srtcomma20l. Please reference the table below for additional details regarding availability of reports by product.
Tax Compliance Amounts Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
---|---|---|---|---|---|
AFC License |
|
|
|
Working Directory |
This file is not generated when the [-cl] command line option is used. |
AFC SaaS Standard |
X |
X |
|
Report zip file |
Clients configured for compliance reporting receive this report by default. It is generated as the batch of transactions are processed. In addition to the existing format, a CSV version of this report is available. |
AFC SaaS Pro |
X |
|
|
Emailed in zip file if requested. |
Reports are generated by default going forward with assumption of Date Method 0. Reports are generated on a monthly basis. |
Non-Billable Compliance Amounts
Description
This summarized, comma delimited report is generated only for non-billable amounts.
Report Format
Non Billable Amounts for Compliance Report Format and Sample Data
Extension |
.nba |
---|---|
File format |
.ssf |
Availability of Reports
This report is generated by srtcomma20l. Please reference the table below for additional details regarding availability of reports by product.
Non Billable Amounts for Compliance Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
AFC License |
|
|
|
Working Directory |
This file is not generated when the [-cl] command line option is used. |
AFC SaaS Standard |
X |
X |
|
Report zip file |
Clients configured for compliance reporting receive this report by default. It is generated as the batch of transactions are processed. In addition to the existing format, a CSV version of this report is available. |
AFC SaaS Pro |
X |
|
|
Emailed in zip file if requested. |
Reports are generated by default going forward with assumption of Date Method 0. Reports are generated on a monthly basis. |
Billable Non-Compliance Amounts
Description
Summarized Comma delimited report generated only for non-compliance taxes (Transactions that do not require compliance within a jurisdiction).
Note: Non-compliance taxes aren't included in the .ssf Compliance file.
Report Format
Billed Non-Compliance Report Format and Sample Data
Extension |
.nca |
---|---|
File Format |
.ssf |
Availability of Reports
This report is generated by srtcomma20l. Please reference the table below for additional details regarding availability of reports by product.
Billed Non-Compliance Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
---|---|---|---|---|---|
AFC License |
|
|
|
Working Directory |
This file is generated only if there are transactions in the AFC log that do not require compliance with a jurisdiction. |
AFC SaaS Standard |
X |
X |
|
Report zip file |
Clients configured for compliance reporting receive this report by default. It is generated as the batch of transactions are processed. In addition to the existing format, a CSV version of this report is available. |
AFC SaaS Pro |
|
|
X |
Emailed in zip file if requested. |
This report is currently not available; however, the data is accessible if requested by the customer. |
Billable Amounts Combined with Non-Billable Amounts
Description
It contains aggregated compliance-related data from multiple files (SSF, NBA, NCA). Mainly used by our compliance department.
Report Format
Billable Amounts Combined with Non-Billable Amounts Report Format
Extension |
.scl |
---|---|
File Format |
.ssf |
Availability of Reports
This report is generated by the Combine SSF utility. Please reference the table below for additional details regarding availability of reports by product.
Billable Amounts Combined with Non-Billable Amounts Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
---|---|---|---|---|---|
AFC License |
|
|
X |
Working Directory |
Clients may configure this report if needed. |
AFC SaaS Standard |
|
|
X |
Report zip file |
This report is currently not available; however, the data is accessible if requested by the customer. |
AFC SaaS Pro |
|
|
X |
Emailed in zip file if requested. |
Clients may request to have this report configured if needed. |
Custom and Sorting Reports
The Custom Sort Utility is designed to allow clients to produce taxation reports which are sorted and summarized using client-specified fields and/or options. The utility is restricted to fields available in the AvaTax for Communications (AFC) transaction log, which can be affected by configuration settings in the EZtax.cfg.
This utility uses the AvaTax for Communications (AFC) API library.
srtcomma20 Utility, (Outputfilename.ext)
Description
Produces a comma-delimited file for compliance filing. User selects sort criteria and preferences.
Generates a outputfilename.ssf file for tax compliance filing. Sorted and condensed by PCode, Tax Type, Tax Level, Tax Rate.
Also generates outputfilename.csf file for customer billing.
Sorted and condensed by Customer Number, Tax Type, Tax Level, Tax Rate, Tax Amount.
Report Format and Sample Data
Srtcomma20 Utility Report Format and Sample Data
Extension | .ssf, .csf | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Comma Delimited | |||||||||||||||||||||||||||
Sample Data | Column Headers | |||||||||||||||||||||||||||
Country, State, Locality, Tax Type, Tax Level, Tax Rate, Tax Amount, Gross Sale, Exempt, Adjustments, Taxable Measure, Minutes | ||||||||||||||||||||||||||||
Definitions for srtcomma20 Comma Delimited SSF File Format | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
Sample | ||||||||||||||||||||||||||||
USA,,,, 6, 0, 0.030000, 29881.866905, 996062.252444, 0.000000, 0.000000, 996062.252444, 14859213.000000 USA,,,, 7, 0, 0.007600, 10116.132171, 1331070.000000, 0.000000, 0.000000, 1331070.000000, 20410578.000000 USA,,,, 18, 0, 0.031400, 11145.492379, 354952.000000, 0.000000, 0.000000, 354952.000000, 5446827.000000 USA, AL, , , 16, 1, 0.067000, 969.972210, 14477.196802, 0.000000, 0.000000, 14477.196802, 220238.671875 USA, AZ, , , 1, 1, 0.050000, 0.806080, 16.121600, 0.000000, 0.000000, 16.121600, 245.280014 USA, AZ, , , 10, 1, 0.012500, 9.068400, 725.472000, 0.000000, 0.000000, 725.472000, 11037.642578 USA, AZ, , , 12, 1, 0.011000, 7.980192, 725.472000, 0.000000, 0.000000, 725.472000, 11037.642578 USA, AZ, APACHE, , 1, 1, 0.050000, 0.806080, 16.121600, 0.000000, 0.000000, 16.121600, 245.280014 USA, AZ, APACHE, , 1, 2, 0.027000, 0.435283, 16.121600, 0.000000, 0.000000, 16.121600, 245.280014 USA, AZ, APACHE, SPRINGERVILLE, 1, 1, 0.050000, 0.705320, 14.106400, 0.000000, 0.000000, 14.106400, 214.620010 |
Availability of Reports
This report is generated by the srtcomma20 Utility. Please reference the table below for additional details regarding availability of reports by product.
Srtcomma20 Utility Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
---|---|---|---|---|---|
AFC License |
|
|
X |
Working Directory |
The referenced utility can be used to generate this report. |
AFC SaaS Standard |
|
|
X |
Report zip file |
Can request one extra report by using any of this utility/format. Report will be generated for every batch of transactions as requested. This report will be available soon for SaaS clients in specific base formats. |
AFC SaaS Pro |
|
|
X |
Emailed in zip file if requested. |
Can request one extra report with each API call by using any of this utility/format. The report will be generated monthly as requested. This report will be available soon for SaaS clients in specific base formats. |
srtcomma20l Utility, (Outputfilename.ext)
Description
Same as srtcomma20 but the .ssf file also contains the number of lines.
Report Format and Sample Data
Srtcomma20l Utility Report Format and Sample Data
Extension | .ssf | |||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Comma Delimited | |||||||||||||||||||||||||||||
Sample Data | Column Headers | |||||||||||||||||||||||||||||
Country, State, Locality, Tax Type, Tax Level, Tax Rate, Tax Amount, Gross Sale, Exempt, Adjustments, Taxable Measure, Minutes, Lines PCode, Tax Type, Tax Level, Tax Rate, Tax Amount, Gross Sale, Exempt, Adjustments, Taxable Measure, Minutes, Lines |
||||||||||||||||||||||||||||||
Definitions for srtcomma20l SSF File Format Key without -p option | ||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
Sample | ||||||||||||||||||||||||||||||
USA,,,, 6, 0, 0.030000, 29881.866905, 996062.252444, 0.000000, 0.000000, 996062.252444, 14859213.000000, 0 USA,,,, 7, 0, 0.007600, 10116.132171, 1331070.000000, 0.000000, 0.000000, 1331070.000000, 20410578.000000, 0 USA,,,, 18, 0, 0.031400, 11145.492379, 354952.000000, 0.000000, 0.000000, 354952.000000, 5446827.000000, 0 USA, AL, , , 16, 1, 0.067000, 969.972210, 14477.196802, 0.000000, 0.000000, 14477.196802, 220238.671875, 0 USA, AZ, , , 1, 1, 0.050000, 0.806080, 16.121600, 0.000000, 0.000000, 16.121600, 245.280014, 0 USA, AZ, , , 10, 1, 0.012500, 9.068400, 725.472000, 0.000000, 0.000000, 725.472000, 11037.642578, 0 USA, AZ, , , 12, 1, 0.011000, 7.980192, 725.472000, 0.000000, 0.000000, 725.472000, 11037.642578, 0 USA, AZ, APACHE, , 1, 1, 0.050000, 0.806080, 16.121600, 0.000000, 0.000000, 16.121600, 245.280014, 0 USA, AZ, APACHE, , 1, 2, 0.027000, 0.435283, 16.121600, 0.000000, 0.000000, 16.121600, 245.280014, 0 USA, AZ, APACHE, SPRINGERVILLE, 1, 1, 0.050000, 0.705320, 14.106400, 0.000000, 0.000000, 14.106400, 214.620010, 0 |
||||||||||||||||||||||||||||||
srtcomma20l SSF File Format Key with -p option | ||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
Sample | ||||||||||||||||||||||||||||||
0, 6, 0, 0.030000, 29881.866905, 996062.252444, 0.000000, 0.000000, 996062.252444, 14859213.000000, 0 0, 7, 0, 0.007600, 10116.132171, 1331070.000000, 0.000000, 0.000000, 1331070.000000, 20410578.000000, 0 0, 18, 0, 0.031400, 11145.492379, 354952.000000, 0.000000, 0.000000, 354952.000000, 5446827.000000, 0 100, 16, 1, 0.067000, 969.972210, 14477.196802, 0.000000, 0.000000, 14477.196802, 220238.671875, 0 125300, 1, 1, 0.050000, 0.806080, 16.121600, 0.000000, 0.000000, 16.121600, 245.280014, 0 125300, 10, 1, 0.012500, 9.068400, 725.472000, 0.000000, 0.000000, 725.472000, 11037.642578, 0 125300, 12, 1, 0.011000, 7.980192, 725.472000, 0.000000, 0.000000, 725.472000, 11037.642578, 0 125400, 1, 1, 0.050000, 0.806080, 16.121600, 0.000000, 0.000000, 16.121600, 245.280014, 0 125400, 1, 2, 0.027000, 0.435283, 16.121600, 0.000000, 0.000000, 16.121600, 245.280014, 0 125500, 1, 1, 0.050000, 0.705320, 14.106400, 0.000000, 0.000000, 14.106400, 214.620010, 0 |
Availability of Reports
This report is generated by the srtcomma20l Utility. Please reference the table below for additional details regarding availability of reports by product.
Srtcomma20l Utility Report Availability
Product | Generated by Default? | Received by Default? | Available Upon Request? | Location | Note |
---|---|---|---|---|---|
AFC License | X | Working Directory | The referenced utility can be used to generate this report. | ||
AFC SaaS Standard | X | Report zip file |
Can request one extra report by using any of this utility/format. Report will be generated for every batch of transactions as requested. This report will be available soon for SaaS clients in specific base formats. |
||
AFC SaaS Pro |
|
|
X |
Emailed in zip file if requested. |
Can request one extra report with each API call by using any of this utility/format. The report will be generated monthly as requested. This report will be available soon for SaaS clients in specific base formats. |
srtcomma20ld Utility, (Outputfilename.ext)
Description
Same as srtcomma20l but the .ssf file also contains Discount and Calculation Types.
Report Format and Sample Data
Srtcomma20ld Utility Report Format and Sample Data
Extension | .ssf | |||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Comma Delimited Fixed Length | |||||||||||||||||||||||||||||||||
Sample Data | Column Headers | |||||||||||||||||||||||||||||||||
Country, State, Locality, Tax Type, Tax Level, Adjustment Type, Calculation Type, Tax Rate, Tax Amount, Gross Sale, Exempt, Adjustments, Taxable Measure, Minutes, Lines PCode, Tax Type, Tax Level, Adjustment Type, Calculation Type, Tax Rate, Tax Amount, Gross Sale, Exempt, Adjustments, Taxable Measure, Minutes, Lines |
||||||||||||||||||||||||||||||||||
Definitions for srtcomma20ld SSF File Format without -p option | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||
Sample | ||||||||||||||||||||||||||||||||||
USA, , , , 18, 0, 0, 1, 0.091000, 470.360800, 5168.800000, 0.000000, 0.000000, 5168.800000, 0.0, 0 USA, , , , 55, 0, 0, 1, 0.033761, 132.343120, 3920.000000, 0.000000, 0.000000, 3920.000000, 3840.0, 0 USA, , , , 169, 0, 0, 1, 0.002430, 12.560184, 5168.800000, 0.000000, 0.000000, 5168.800000, 0.0, 0 USA, , , , 170, 0, 0, 2, 0.018333, 0.293328, 80.000000, 50.320000, 0.000000, 29.680000, 0.0, 0 USA, CA, , , 9, 1, 0, 1, 0.001100, 0.704000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 USA, CA, , , 10, 1, 0, 1, 0.007200, 4.823194, 669.888000, 0.000000, 0.000000, 669.888000, 0.0, 0 USA, CA, , , 19, 1, 0, 1, 0.024300, 15.552000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 USA, CA, , , 21, 1, 0, 1, 0.001600, 1.024000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 USA, CA, , , 22, 1, 0, 1, 0.015500, 9.920000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 USA, CA, , , 23, 1, 0, 1, 0.002700, 1.728000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 |
||||||||||||||||||||||||||||||||||
Definitions for srtcomma20ld SSF File Format Key with -p option | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||
Sample | ||||||||||||||||||||||||||||||||||
253500, 9, 1, 0, 1, 0.001100, 0.704000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 253500, 10, 1, 0, 1, 0.007200, 4.823194, 669.888000, 0.000000, 0.000000, 669.888000, 0.0, 0 253500, 19, 1, 0, 1, 0.024300, 15.552000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 253500, 21, 1, 0, 1, 0.001600, 1.024000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 253500, 22, 1, 0, 1, 0.015500, 9.920000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 253500, 23, 1, 0, 1, 0.002700, 1.728000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 253500, 44, 1, 0, 1, 0.007200, 3.817705, 530.236821, 0.000000, 0.000000, 530.236821, 480.0, 0 253500, 60, 1, 0, 1, 0.001500, 0.960000, 640.000000, 0.000000, 0.000000, 640.000000, 0.0, 0 253500, 232, 1, 0, 1, 0.002700, 1.367765, 506.579556, 0.000000, 0.000000, 506.579556, 480.0, 0 |
Availability of Reports
This report is generated by the srtcomma20ld Utility. Please reference the table below for additional details regarding availability of reports by product.
Srtcomma20ld Utility Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
AFC License |
|
|
X |
Working Directory |
The referenced utility can be used to generate this report. |
AFC SaaS Standard |
|
|
X |
Report zip file |
Can request one extra report by using any of this utility/format. Report will be generated for every batch of transactions as requested. This report will be available soon for SaaS clients in specific base formats. |
AFC SaaS Pro |
|
|
X |
Emailed in zip file if requested. |
Can request one extra report with each API call by using any of this utility/format. The report will be generated monthly as requested. This report will be available soon for SaaS clients in specific base formats. |
srtcommadetail Utility, (Outputfilename.ext)
Description
Same as srtcomma20 but the .ssf file includes Tax type and Tax Level descriptions.
Report Format and Sample Data
Extension | .ssf | |||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Comma Delimited | |||||||||||||||||||||||||||||||||
Sample Data | Column Headers | |||||||||||||||||||||||||||||||||
Country, State, Locality, PCode, Tax Type, Tax Type Description, Tax Level, Tax Level Description, Tax Rate, Tax Amount, Gross Sale, Exempt, Adjustments, Taxable Measure, Minutes | ||||||||||||||||||||||||||||||||||
Definitions for srtcommadetail SSF File Format Key | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||
Sample | ||||||||||||||||||||||||||||||||||
USA, , , , 0, 6, Federal Excise Tax, 0, Federal, 0.030000, 63.946941, 2131.564739, 0.000000, 0.000000, 2131.564739, 2376516.0 USA, CA, , , 253500, 9, P.U.C. Fee, 1, State, 0.001100, 0.072776, 66.159998, 0.000000, 0.000000, 66.159998, 155916.0 USA, CA, , , 253500, 10, E911 Tax, 1, State, 0.006500, 0.450252, 69.269518, 0.000000, 0.000000, 69.269518, 155916.0 USA, CA, , , 253500, 19, State High Cost Fund, 1, State, 0.024300, 1.607688, 66.159998, 0.000000, 0.000000, 66.159998, 155916.0 USA, CA, , , 253500, 21, CA Teleconnect Fund, 1, State, 0.001600, 0.105856, 66.159998, 0.000000, 0.000000, 66.159998, 155916.0 USA, CA, , , 253500, 60, CA High Cost Fund A, 1, State, 0.001500, 0.099240, 66.159998, 0.000000, 0.000000, 66.159998, 155916.0 USA, CO, , , 427200, 13, State Universal Service Fund, 1, State, 0.029000, 0.026172, 0.902500, 0.000000, 0.000000, 0.902500, 1920.0 USA, CO, DENVER, , 442100, 4, District Tax, 2, County, 0.001000, 0.000211, 0.210945, 0.000000, 0.000000, 0.210945, 246.0 |
Availability of Reports
This report is generated by the srtcommadetail Utility. Please reference the table below for additional details regarding availability of reports by product.
Srtcommadetail Utility Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
---|---|---|---|---|---|
AFC License |
|
|
X |
Working Directory |
The referenced utility can be used to generate this report. |
AFC SaaS Standard |
|
|
X |
Report zip file |
Can request one extra report by using any of this utility/format. Report will be generated for every batch of transactions as requested. This report will be available soon for SaaS clients in specific base formats. |
AFC SaaS Pro |
|
|
X |
Emailed in zip file if requested. |
Can request one extra report with each API call by using any of this utility/format. The report will be generated monthly as requested. This report will be available soon for SaaS clients in specific base formats. |
customsort Utility, (Outputfilename.ext)
Description
The customsort utility is designed to allow clients to produce taxation reports which are sorted and summarized using client-specified fields and/or options. In other words, it's a one-stop shop where clients can generate a specific report in available base format (utility) and can include sort on additional fields.
It works from data available in the log file, so it doesn't include original revenue and has no record of failed transactions.
Available base formats are as follows: SRTCOMMA20L, SRTCOMMA20L-P, SRTCOMMA20LD, EZLOGCUST, EZLOGCUSTPTS
Report Format and Sample
Customsort utility Report Format
Extension | .csv, .xls | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Comma Delimited | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sample Data | Definitions | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
*Note: AFC SaaS Pro clients will have to add the columns to the report and the new column header names will appear in the report after they have been renamed by the user. These additional optional columns are not available for AFC SaaS Standard or AFC On Prem clients. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Configuration File Sample - srtcomma20l | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
///////////////////////////////////////////////////////////////////////////////////// //// base_srtcomma20l.cfg //// OUTPUT_FILENAME_FORMAT: EZtax_{%y%m%d} BASE: srtcomma20l OPTION: NBA_FILE OPTION: NCA_FILE OPTION: NO_DELETE_LOG OPTION: NO_HEADER CALCULATED_VALUE_PRECISION: 6 DEFAULT_EXT: ssf DELIMITER: ',' DATA_DIR: C:\BillSoft\EZTax\Data WORKING_DIR: E:\Logs\customsort |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Configuration File Sample - srtcomma20l-p | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
///////////////////////////////////////////////////////////////////////////////////// //// base_srtcomma20l_p.cfg //// OUTPUT_FILENAME_FORMAT: EZtax_{%y%m%d} BASE: srtcomma20l-p OPTION: NBA_FILE OPTION: NCA_FILE OPTION: NO_DELETE_LOG OPTION: NO_HEADER CALCULATED_VALUE_PRECISION: 6 DEFAULT_EXT: ssf DELIMITER: ',' DATA_DIR: C:\BillSoft\EZTax\Data WORKING_DIR: E:\Logs\customsort |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Configuration File Sample - srtcomma20ld | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
///////////////////////////////////////////////////////////////////////////////////// OUTPUT_FILENAME_FORMAT: EZtax_{%y%m%d} BASE: srtcomma20ld OPTION: NBA_FILE OPTION: NCA_FILE OPTION: NO_DELETE_LOG OPTION: NO_HEADER CALCULATED_VALUE_PRECISION: 6 DEFAULT_EXT: ssf DELIMITER: ',' DATA_DIR: C:\BillSoft\EZTax\Data WORKING_DIR: E:\Logs\customsort |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Configuration File Sample - ezlogcust | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
///////////////////////////////////////////////////////////////////////////////////// OUTPUT_FILENAME_FORMAT: EZtax_{%y%m%d} BASE: ezlogcust OPTION: NBA_FILE OPTION: NCA_FILE OPTION: NO_DELETE_LOG OPTION: NO_HEADER CALCULATED_VALUE_PRECISION: 6 DEFAULT_EXT: rpt DELIMITER: ',' DATA_DIR: C:\BillSoft\EZTax\Data WORKING_DIR: E:\Logs\customsort |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Configuration File Sample - ezlogcustpts | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
///////////////////////////////////////////////////////////////////////////////////// OUTPUT_FILENAME_FORMAT: EZtax_{%y%m%d} BASE: ezlogcustpts OPTION: NBA_FILE OPTION: NCA_FILE OPTION: NO_DELETE_LOG OPTION: NO_HEADER CALCULATED_VALUE_PRECISION: 6 DEFAULT_EXT: rpt DELIMITER: ',' DATA_DIR: C:\BillSoft\EZTax\Data WORKING_DIR: E:\Logs\customsort |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Custom Sort (Full Example) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Configuration File Sample ///////////////////////////////////////////////////////////////////////////////////// //// ext_srtcomma20l.cfg //// OUTPUT_FILENAME_FORMAT: EZtax_{%y%m%d} BASE: srtcomma20l FIELD: P_CODE FIELD: CUST_NO FIELD: INV_NO OPTION: NBA_FILE OPTION: NCA_FILE OPTION: NO_DELETE_LOG OPTION: HEADER CALCULATED_VALUE_PRECISION: 6 DEFAULT_EXT: csv DELIMITER: ',' Sample Input File
Sample Out Files EZtax_160405.rpt Custom Sort Processing Metrics --------------------------------------------------------------------------- Start Time : Tue Apr 05 10:53:57 2016 End Time : Tue Apr 05 10:53:57 2016 Taxes Input Metrics --------------------------------------------------------------------------- Records: 22 File: C:\BILLSOFTONLINE\KML\KML\EZTax\EZTax.log Taxes Output Metrics --------------------------------------------------------------------------- Summarized Records : 19 File: EZtax_160405_ssf.csv Non-billable Records : 3 File: EZtax_160405_nba.csv Non-compliance Records : 0 File: EZtax_160405_nca.csv Total Summarized Records : 22 --------------------------------------------------------------------------- End of Report EZtax_160405_nca.csv
EZtax_160405_nba.csv
EZtax_160405_ssf.csv
|
Availability of Reports
This report is generated by the customsort Utility. Please reference the table below for additional details regarding availability of reports by product.
customsort Utility Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
---|---|---|---|---|---|
AFC License |
|
|
X |
Working Directory |
The referenced utility can be used to generate this report. |
AFC SaaS Standard |
|
|
X |
Report zip file |
Can request one extra report by using any of this utility/format. Report will be generated for every batch of transactions as requested. This report will be available soon for SaaS clients in specific base formats. |
AFC SaaS Pro |
|
|
X |
Emailed in zip file if requested. |
Can request one extra report with each API call by using any of this utility/format. The report will be generated monthly as requested. This report will be available soon for SaaS clients in specific base formats. |
STRG Utility, (Outputfilename.ext)
Description
Fixed Length outputfilename.ssf file for tax compliance filing. Sorted and condensed by PCode, Tax Type, Tax Level, Tax Rate
Report Format and Sample Data
Extension | .ssf | |||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Comma Delimited | |||||||||||||||||||||||||||||||
Sample Data | Column Headers | |||||||||||||||||||||||||||||||
PCode, Tax Type, Tax Level, Tax Rate, Tax Amount Sign, Tax Amount, File Record Length | ||||||||||||||||||||||||||||||||
Definitions for STRG SSF File Format Key | ||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
Sample | ||||||||||||||||||||||||||||||||
0 1 2 3 1.23457E+35 ------------------------------------------------------------ 000000000000006000003000+00098418707 000000000000007000000580+00018387113 000000000000018000003180+00081599822 000000000000031000000039+00001000752 |
Availability of Report
This report is generated by the STRG Utility. Please reference the table below for additional details regarding availability of reports by product.
STRG Utility Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
---|---|---|---|---|---|
AFC License |
|
|
X |
Working Directory |
The referenced utility can be used to generate this report. |
AFC SaaS Standard |
|
|
|
|
This report is currently not available. |
AFC SaaS Pro |
|
|
|
|
This report is currently not available. |
Ezlogns Utility, Comma delimited log.ext,
Description
Generates a comma-delimited file for customer billing. Sorting and reporting is done at the customer level. Sorted and condensed by Customer Number, PCode, Tax Type, Tax Level, Tax Rate, Calculation Type.
Report Format and Sample Data
Ezlogns Utility Report Format and Sample Data
Extension | .rpt | |||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Comma Delimited | |||||||||||||||||||||||||||||||||||||||||
Sample Data | Column Headers | |||||||||||||||||||||||||||||||||||||||||
Country, State, County, Locality,, Tax Type, Tax Level, Tax Rate, Tax Amount, Gross Sale, Exempt, Adjustments, Taxable Measure, Minutes | ||||||||||||||||||||||||||||||||||||||||||
Definitions for Ezlogns | ||||||||||||||||||||||||||||||||||||||||||
|
Availability of Report
This report is generated by the Ezlogns Utility. Please reference the table below for additional details regarding availability of reports by product.
EZlogns Utility Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
---|---|---|---|---|---|
AFC License |
|
|
X |
Working Directory |
The referenced utility can be used to generate this report. |
AFC SaaS Standard |
|
|
|
|
This report is currently not available. |
AFC SaaS Pro |
|
|
|
|
This report is currently not available. |
Ezlogcust Utility, Comma delimited log.ext
Description
Same as Ezlogns plus Lines, Locations and Customer number
Report Format and Sample Data
Ezlogcust Utility Report Format and Sample Data
Extension | .rpt | |||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Comma Delimited | |||||||||||||||||||||||||||||||||||
Sample Data | Column Headers | |||||||||||||||||||||||||||||||||||
Country, State, County, Locality, Tax Type, Tax Level, Tax Rate, Calculation Type, Tax Amount, Gross Sale, Exempt, Adjustments, Taxable Measure, Minutes, Lines, Locations, Customer Number | ||||||||||||||||||||||||||||||||||||
Definitions for Ezlogcust | ||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||
Sample | ||||||||||||||||||||||||||||||||||||
USA, , , , 6, 0, 0.030000, RATE, 0.892576, 29.752527, 0.000000, 0.000000, 29.752527, 0.000000, 1, 1, 2143278889 USA, TX, , , 9, 1, 0.001670, RATE, 0.049687, 29.752527, 0.000000, 0.000000, 29.752527, 0.000000, 1, 0, 2143278889 USA, TX, , , 13, 1, 0.036000, RATE, 1.035438, 28.762179, 0.000000, 0.000000, 28.762179, 0.000000, 1, 0, 2143278889 USA, TX, , , 26, 1, 0.012500, RATE, 0.367089, 29.367090, 0.000000, 0.000000, 29.367090, 0.000000, 1, 0, 2143278889 USA, TX, DALLAS, DALLAS, 1, 1, 0.062500, RATE, 1.863693, 29.819089, 0.000000, 0.000000, 29.819089, 0.000000, 1, 0, 2143278889 USA, TX, DALLAS, DALLAS, 1, 3, 0.010000, RATE, 0.298022, 29.802214, 0.000000, 0.000000, 29.802214, 0.000000, 1, 0, 2143278889 USA, TX, DALLAS, DALLAS, 4, 3, 0.010000, RATE, 0.283838, 28.383766, 0.000000, 0.000000, 28.383766, 0.000000, 0, 0, 2143278889 USA, TX, DALLAS, DALLAS, 10, 3, 0.620000, PER_LINE, 0.620000, 0.000000, 0.000000, 0.000000, 0.000000, 0.000000, 1, 0, 2143278889 USA, TX, DALLAS, DALLAS, 51, 3, 1.350000, PER_LINE, 1.350000, 0.000000, 0.000000, 0.000000, 0.000000, 0.000000, 1, 0, 2143278889 USA, , , , 6, 0, 0.030000, RATE, 0.210216, 7.007192, 0.000000, 0.000000, 7.007192, 5.100000, 0, 0, 2143278889B |
Availability of Report
This report is generated by the Ezlogcust Utility. Please reference the table below for additional details regarding availability of reports by product.
EZlogcust Utility Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
AFC License |
|
|
X |
Working Directory |
The referenced utility can be used to generate this report. |
AFC SaaS Standard |
|
|
|
|
This report is currently not available. |
AFC SaaS Pro |
|
|
|
|
This report is currently not available. |
Ezlogcustios Utility, Comma delimited log.ext
Description
Same as Ezlogcust plus includes Invoice Number, Optional, Service Level Number
Report Format and Sample Data
Ezlogcustios Utility Report Format and Sample Data
Extension | .rpt | |||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Comma Delimited | |||||||||||||||||||||||||||||||||||
Sample Data | Column Headers | |||||||||||||||||||||||||||||||||||
Invoice Number, Optional, Service Level Number, Country, State, County, Locality, Tax Type, Tax Level, Tax Rate, Tax Amount, Gross Sale, Exempt, Adjustments, Taxable Measure, Minutes, Customer Number | ||||||||||||||||||||||||||||||||||||
Definitions for Ezlogcustios | ||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||
Sample | ||||||||||||||||||||||||||||||||||||
6, 8, 7, USA, AL, AUTAUGA, AUTAUGAVILLE, 1, 1, 0.040000, RATE, 0.720000, 18.000000, 0.000000, 0.000000, 18.000000, 275.940002, 54, 18, BillSoft Inc. 6, 8, 7, USA, AL, AUTAUGA, JONES, 1, 2, 0.020000, RATE, 0.320000, 16.000000, 0.000000, 0.000000, 16.000000, 245.280014, 48, 16, BillSoft Inc. 6, 8, 7, USA, AL, AUTAUGA, PRATTVILLE, 1, 3, 0.025000, RATE, 0.050000, 2.000000, 0.000000, 0.000000, 2.000000, 30.660000, 6, 2, BillSoft Inc. 6, 8, 7, USA, AL, AUTAUGA, AUTAUGAVILLE, 1, 3, 0.030000, RATE, 0.060000, 2.000000, 0.000000, 0.000000, 2.000000, 30.660000, 6, 2, BillSoft Inc. 6, 8, 7, USA, , , , 6, 0, 0.030000, RATE, 14.312928, 477.097605, 0.000000, 0.000000, 477.097605, 5825.416504, 1140, 380, BillSoft Inc. 6, 8, 7, USA, AL, , , 8, 1, 0.060000, RATE, 2.200486, 36.674766, 0.000000, 0.000000, 36.674766, 551.879822, 108, 36, BillSoft Inc. 6, 8, 7, USA, AL, BALDWIN, , 10, 2, 0.690000, PER_LINE, 4.140000, 2.000000, 0.000000, 0.000000, 2.000000, 30.660000, 6, 2, BillSoft Inc. |
Availability of Report
This report is generated by the EZlogcustios Utility. Please reference the table below for additional details regarding availability of reports by product.
EZlogcustios Utility Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
---|---|---|---|---|---|
AFC License |
|
|
X |
Working Directory |
The referenced utility can be used to generate this report. |
AFC SaaS Standard |
|
|
|
|
This report is currently not available. |
AFC SaaS Pro |
|
|
|
|
This report is currently not available. |
Ezlogcustpts Utility, Comma delimited log.ext
Description
Same as Ezlogcust plus includes Pcode, Transaction type and Service Type
Report Format and Sample Data
EzlogcustptsUtility Report Format and Sample Data
Extension | .rpt | |||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Comma Delimited | |||||||||||||||||||||||||||||||||||
Sample Data | Column Headers | |||||||||||||||||||||||||||||||||||
PCode, Optional, Service Level Number, Country, State, County, Locality, Tax Type, Tax Level, Tax Rate, Tax Amount, Gross Sale, Exempt, Adjustments, Taxable Measure, Minutes, Customer Number | ||||||||||||||||||||||||||||||||||||
Definitions for EZlogcustpts | ||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||
Sample | ||||||||||||||||||||||||||||||||||||
0, 1, 1, USA,,,, 6, 0, 0.030000, 0.128824, 4.294140, 0.000000, 0.000000, 4.294140, 61.320000, BillSoft, Inc. 0, 1, 1, USA,,,, 18, 0, 0.072805, 0.291220, 4.000000, 0.000000, 0.000000, 4.000000, 61.320000, BillSoft, Inc. 0, 1, 1, USA,,,, 31, 0, 0.000730, 0.002920, 4.000000, 0.000000, 0.000000, 4.000000, 61.320000, BillSoft, Inc. 0, 1, 2, USA,,,, 6, 0, 0.030000, 0.128824, 4.294140, 0.000000, 0.000000, 4.294140, 61.320000, BillSoft, Inc. 0, 1, 2, USA,,,, 18, 0, 0.072805, 0.291220, 4.000000, 0.000000, 0.000000, 4.000000, 61.320000, BillSoft, Inc. 0, 1, 2, USA,,,, 31, 0, 0.000730, 0.002920, 4.000000, 0.000000, 0.000000, 4.000000, 61.320000, BillSoft, Inc. 0, 1, 3, USA,,,, 6, 0, 0.030000, 0.128824, 4.294140, 0.000000, 0.000000, 4.294140, 61.320000, BillSoft, Inc. 0, 1, 3, USA,,,, 18, 0, 0.072805, 0.291220, 4.000000, 0.000000, 0.000000, 4.000000, 61.320000, BillSoft, Inc. 0, 1, 3, USA,,,, 31, 0, 0.000730, 0.002920, 4.000000, 0.000000, 0.000000, 4.000000, 61.320000, BillSoft, Inc. 0, 1, 4, USA,,,, 18, 0, 0.072805, 0.291220, 4.000000, 0.000000, 0.000000, 4.000000, 61.320000, BillSoft, Inc. 0, 1, 4, USA,,,, 31, 0, 0.000730, 0.002920, 4.000000, 0.000000, 0.000000, 4.000000, 61.320000, BillSoft, Inc. 0, 2, 1, USA,,,, 6, 0, 0.030000, 0.120000, 4.000000, 0.000000, 0.000000, 4.000000, 61.320000, BillSoft, Inc. |
Availability of Report
This report is generated by the Ezlogcustpts Utility.
EZlogcustpts Utility Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
---|---|---|---|---|---|
AFC License |
|
|
X |
Working Directory |
The referenced utility can be used to generate this report. |
AFC SaaS Standard |
|
|
|
|
This report is currently not available. |
AFC SaaS Pro |
|
|
|
|
This report is currently not available. |
Ezlogcustptslnl Utility, Comma delimited log.ext
Description
Same as Ezlogcustpts plus the number of lines and locations are also included.
Report Format and Sample Data
Ezlogcustptslnl Utility Report Format and Sample Data
Extension | .rpt | |||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Comma Delimited | |||||||||||||||||||||||||||||||||||||||
Sample Data | Column Headers | |||||||||||||||||||||||||||||||||||||||
PCode, Optional, Service Level Number, Country, State, County, Locality, Tax Type, Tax Level, Tax Rate, Tax Amount, Gross Sale, Exempt, Adjustments, Taxable Measure, Minutes, Lines, Location | ||||||||||||||||||||||||||||||||||||||||
Definitions for Ezlogcustptslnl | ||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||
Sample | ||||||||||||||||||||||||||||||||||||||||
0, 0, 0, USA, , , , 6, 0, 0.030000, 2.462930, 82.097663, 0.000000, 0.000000, 82.097663, 0.000000, BillSoft, Inc. , 6, 2 0, 0, 0, USA, , , , 18, 0, 0.089000, 1.157000, 13.000000, 0.000000, 0.000000, 13.000000, 0.000000, BillSoft, Inc. , 0, 0 0, 0, 0, USA, , , , 31, 0, 0.000000, 0.000000, 13.000000, 13.000000, 0.000000, 0.000000, 0.000000, BillSoft, Inc. , 0, 0 1210800, 0, 0, USA, KS, , , 13, 1, 0.048700, 1.458565, 29.949999, 0.000000, 0.000000, 29.949999, 0.000000, BillSoft, Inc. , 0, 0 1284800, 0, 0, USA, KS, SALINE, , 10, 2, 0.750000, 2.250000, 0.000000, 0.000000, 0.000000, 0.000000, 0.000000, BillSoft, Inc. , 3, 0 1284900, 0, 0, USA, KS, SALINE, SALINA, 1, 1, 0.053000, 2.039814, 38.487064, 0.000000, 0.000000, 38.487064, 0.000000, BillSoft, Inc. , 0, 0 1284900, 0, 0, USA, KS, SALINE, SALINA, 1, 2, 0.010000, 0.384871, 38.487064, 0.000000, 0.000000, 38.487064, 0.000000, BillSoft, Inc. , 0, 0 1284900, 0, 0, USA, KS, SALINE, SALINA, 1, 3, 0.007500, 0.288653, 38.487064, 0.000000, 0.000000, 38.487064, 0.000000, BillSoft, Inc. , 0, 0 2502500, 0, 0, USA, NY, , , 5, 1, 0.025000, 0.925712, 37.028499, 0.000000, 0.000000, 37.028499, 0.000000, BillSoft, Inc. , 0, 0 2502500, 0, 0, USA, NY, , , 45, 1, 0.003750, 0.138857, 37.028499, 0.000000, 0.000000, 37.028499, 0.000000, BillSoft, Inc. , 0, 0 2604000, 0, 0, USA, NY, NEW YORK, , 10, 2, 1.000000, 3.000000, 0.000000, 0.000000, 0.000000, 0.000000, 0.000000, BillSoft, Inc. , 3, 0 |
Availability of Report
This report is generated by the Ezlogcustptslnl Utility. Please reference the table below for additional details regarding availability of reports by product.
EZlogcustptslnl Utility Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
---|---|---|---|---|---|
AFC License |
|
|
X |
Working Directory |
The referenced utility can be used to generate this report. |
AFC SaaS Standard |
|
|
|
|
This report is currently not available. |
AFC SaaS Pro |
|
|
|
|
This report is currently not available. |
Srtcdf20 and srtcdf20p, Outputfile.ext,
Description
Same as srtcomma20 but in CDF format.
Report Format and Sample Data
Srtcdf20 and srtcdf20p Utility Report Format and Sample Data
Extension | .ssf, .csf | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Fixed Length | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sample Data | Column Headers | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PCode, Tax Type, Tax Level, Tax Rate, Tax Amount Sign, Tax Amount, File Record Length Customer Number, TaxType, Tax Level, Tax Amount Sign, Tax Amount, File Record Length |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Definitions for Srtcdf20 and srtcdf20p | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sample | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0 1 2 3 1234567890123456…. ------------------------------------------------------------ 000000000000006000003000+00098418707 000000000000007000000580+00018387113 000000000000018000003180+00081599822 000000000000031000000039+00001000752 |
Availability of Report
This report is generated by the Srtcdf20 and srtcdf20p Utility. Please reference the table below for additional details regarding availability of reports by product.
Srtcdf20 and srtcdf20p Utility Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
---|---|---|---|---|---|
AFC License |
|
|
X |
Working Directory |
The referenced utility can be used to generate this report. |
AFC SaaS Standard |
|
|
X |
Report zip file |
CDF users or clients may request reports in this format. |
AFC SaaS Pro |
|
|
|
|
This report is currently not available. |
Other Reports
Output_ASCIILOG.ext
Description
This report deposits the contents of the logfilename.log to an ASCII version of the log file.
Report Format and Sample Data
ASCIILog Utility Report Format and Sample Data
Extension | .csv | |||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Comma Delimited | |||||||||||||||||||||||||||||||||||||||||
Sample Data | Column Headers | |||||||||||||||||||||||||||||||||||||||||
Country, State, County, City, Tax Type, Tax Level, Tax Rate, Tax Amount, Charges, Exemptions, Adjustments, Net Sales, Minutes, Invoice Number, Service Level Number, Optional, Lines, Locations, Calculation Type, Customer Number | ||||||||||||||||||||||||||||||||||||||||||
Definitions for ASCIILog | ||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||
Sample | ||||||||||||||||||||||||||||||||||||||||||
USA, PA, , , 9, 1, 0.002662, 0.851840, 320.000000, 0.000000, 0.000000, 320.000000, 0.000000, 0, 0, 0, 0, 0, RATE, 93368917:1608205 USA, PA, BERKS, KEMPTON, 14, 1, 0.050000, 46.583018, 931.660350, 0.000000, 0.000000, 931.660350, 240.000000, 0, 0, 0, 0, 0, RATE, 93368917:1608206 USA, CA, , , 10, 1, 0.007200, 4.317632, 599.671134, 0.000000, 0.000000, 599.671134, 240.000000, 0, 0, 0, 0, 0, RATE, 93368917:1608204 USA, PA, BERKS, KEMPTON, 1, 1, 0.060000, 55.899620, 931.660350, 0.000000, 0.000000, 931.660350, 240.000000, 0, 0, 0, 0, 0, RATE, 93368917:1608206 |
Availability of Reports
This report is generated by the ASCIILog Utility. Please reference the table below for additional details regarding availability of reports by product.
ASCIILog Utility Report Availability
Product |
Generated by Default? |
Received by Default? |
Available Upon Request? |
Location |
Note |
---|---|---|---|---|---|
AFC License |
|
|
X |
Working Directory |
This report can be created by using the ASCIILog utility. |
AFC SaaS Standard |
|
|
X |
Report zip file |
This report is not currently generated by default; however, it can be set to generate by default if needed. Currently, it is included at the request of the customer. Please note this report is not recommended for larger clients. |
AFC SaaS Pro |
|
|
X |
Emailed |
This report is currently not available; however, the Detail Log report is available to SaaS Pro clients and is considered equivalent in content. |
File Descriptions
Tax Type Files
tax_type.exp
Description
Tax types are used by AFC to identify the specific tax to which the tax liability applies. With the large number of taxes that exist in the telecommunications world, having the tax identified along with the description, category, and reference helps both in billing / customer service and in compliance filing.
The numeric tax type value is also used for specified exemptions and in Rate and Logic overrides. The tax category is used for grouping taxes and for category based exemptions.
See AFC Tax Types for more detailed information on tax types.
File Format and Sample
Tax_Type.exp File Format and Sample Data
File Name | tax_type.exp | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | tab delimited | |||||||||||||||||
Sample Data | Sample | |||||||||||||||||
|
File Availability and Location
tax_type.exp File Availability and Location
Product |
Platform/Package |
Location in Installation/Download Package |
---|---|---|
AFC License |
Unix |
tax_type.exp is at root level in package All other files are in the db subdirectory |
Windows |
All files are in the txt subdirectory |
|
AS/400 |
tax_type.exp is at root level in package All other files are located in /eztax_db9. This is at the root of the Integrated File System (IFS). It is copied to the EZTAX_DB9 installation library. all_adr.txt - ALL_ADR The name on the left is the text file name. The name on the right is the physical file name. |
|
AFC SaaS Standard |
EZTaxWS_Std_docs_v9_1603.zip |
All files are in the txt subdirectory |
AFC SaaS Pro |
EZTaxWS_docs_v9_YYMM.zip EZTaxWS_sau_docs_v9_YYMM.zip |
All files are in the txt subdirectory |
Zip Address to PCode Cross Reference Files
all_adr.txt
Description
The address to PCode cross-reference file has all jurisdictions recognized by AFC listed along with the corresponding PCode.
The Zip Begin and Zip End has different meaning depending on the jurisdiction level.
- Country Level: Zip Begin/End represent the ID for the country. Refer to Appendix A for more information on country codes.
- State/Province Level: Zip Begin/End represent the ID for the state/province.
- County Level: Zip Begin/End represent the ID for the county.
- City Level: Zip Begin/End represent the 5 digit (USA) or 6 digit Canadian zip code range for that City.
File Format and Sample
all_adr.txt File Format and Sample
File Name | add_adr.txt | |||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Comma delimited | |||||||||||||||||||||||
Sample Data | Sample | |||||||||||||||||||||||
|
File Availability and Location
all_adr.txt File Availability and Location
Product |
Platform/Package |
Location in Installation/Download Package |
---|---|---|
AFC License |
Unix |
all_adr.txt is in the db subdirectory |
Windows |
All files are in the txt subdirectory |
|
AS/400 |
all_adr.txt is located in /eztax_db9. This is at the root of the Integrated File System (IFS). It is copied to the EZTAX_DB9 installation library as: all_adr.txt - ALL_ADR The name on the left is the text file name. The name on the right is the physical file name. |
|
AFC SaaS Standard |
EZTaxWS_Std_docs_v9_1603.zip |
All files are in the txt subdirectory |
AFC SaaS Pro |
EZTaxWS_docs_v9_YYMM.zip EZTaxWS_sau_docs_v9_YYMM.zip |
All files are in the txt subdirectory |
Calculation Type Files
calculationType.txt
Description
For the Telecommunication tax calculations, there are different rules on not only what is taxed but also how it is taxed. This table provides descriptions for all calculation types.
For additional details, please reference the table below.
File Format and Sample
calculationType.txt File Format and Sample
File Name | CalculationType.txt | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | Comma delimited | |||||||||||||||||||
Sample Data | Sample | |||||||||||||||||||
|
File Availability and Location
calculationType.txt File Availability and Location
Product |
Platform/Package |
Location in Installation/Download Package |
---|---|---|
AFC License |
Unix |
calculationType.txt is in the db subdirectory |
Windows |
All files are in the txt subdirectory |
|
AS/400 |
calculationType.txt is located in /eztax_db9. This is at the root of the Integrated File System (IFS). |
|
AFC SaaS Standard |
EZTaxWS_Std_docs_v9_1603.zip |
All files are in the txt subdirectory |
AFC SaaS Pro |
EZTaxWS_docs_v9_YYMM.zip EZTaxWS_sau_docs_v9_YYMM.zip |
All files are in the txt subdirectory |
FIPS Code Cross Reference to PCode Files
fipspcd.txt , pcdfips.txt
Description
AFC provides support for using a 10 digit Federal Information Processing Standards (FIPS) code to define the taxing jurisdiction.
The fipspcd.txt file provides a cross reference for the PCode associated with a given FIPS code. There will never be a single FIPS code cross referenced to more than one PCode.
The pcdfips.txt provides a cross reference for the FIPSs code(s) associated with a given PCode. There may be multiple FIPs codes that are associated with a single PCode.
File Format and Sample
fipspcd.txt , pcdfips.txt File Format and Sample Data
File Name | fipspcd.txt, pcdfips.txt | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | tab delimited with summary row at beginning of file | |||||||||||
Sample Data | Sample | |||||||||||
|
File Availability and Location
fipspcd.txt , pcdfips.txt File Availability and Location
Product |
Platform/Package |
Location in Installation/Download Package |
---|---|---|
AFC License |
Unix |
fipspcd.txt and pcdfips.txt are in the db subdirectory |
Windows |
All files are in the txt subdirectory |
|
AS/400 |
fipspcd.txt and pcdfips.txt are located in /eztax_db9. This is at the root of the Integrated File System (IFS). |
|
AFC SaaS Standard |
EZTaxWS_Std_docs_v9_1603.zip |
All files are in the txt subdirectory |
AFC SaaS Pro |
EZTaxWS_docs_v9_YYMM.zip EZTaxWS_sau_docs_v9_YYMM.zip |
All files are in the txt subdirectory |
NPANXX Cross Reference to PCode Files
npanxx7.txt
Description
AFC provides support for using the 6 digit North America Numbering Plan Area – Local Exchange (NPA- NXX) code to define the taxing jurisdiction.
As a convenience, the NPA-NXX lookup and cross-reference table supports country codes for the NPA- NXX value. Refer to Appendix A for more information on country codes.
File Format and Sample
npanxx7.txt File Format and Sample
File Name | npanxx7.txt | |||||
---|---|---|---|---|---|---|
File Format | comma delimited | |||||
Sample Data | Sample | |||||
|
File Availability and Location
npanxx7.txt File Availability and Location
Product |
Platform/Package |
Location in Installation/Download Package |
---|---|---|
AFC License |
Unix |
Npanxx7.txt is at root level in package All other files are in the db subdirectory |
Windows |
All files are in the txt subdirectory |
|
AS/400 |
Npanxx7.txt is located in /eztax_db9. This is at the root of the Integrated File System (IFS). It is copied to the EZTAX_DB9 installation library as: npanxx7.txt - NPANXX7 The name on the left is the text file name. The name on the right is the physical file name. |
|
AFC SaaS Standard |
EZTaxWS_Std_docs_v9_1603.zip |
All files are in the txt subdirectory |
AFC SaaS Pro |
EZTaxWS_docs_v9_YYMM.zip EZTaxWS_sau_docs_v9_YYMM.zip |
All files are in the txt subdirectory |
Transaction/Service Pair List and Description Files
transerv.txt and transervdesc.txt, transervsau.txt and transervdescsau.txt
Description
AFC maps product to transaction type/service type pairs. The transaction type is a high level grouping such as VoIP or Cellular. The service type is a more granular breakdown such as Access Charge. These files provide the t/s pair information for reference and importation into the billing or invoice application.
Note: Transerv.txt and transservdesc.txt do not contain the additional Sales and Use Transaction/Service Pairs available in Telecom for AFC SaaS Pro REST v2 and AFC SaaS Standard. A list of Additional Sales and Use Transaction/Service Pairs can be found in section Telecom and SAU in TM_00115_AFC Transaction and Service Types.
File Format and Sample
transerv.txt and transervdesc.txt , transervsau.txt and transervdescsau.txt File Format and Sample
File Name |
Telecom Filename: transerv.txt and transervdesc.txt Sales and Use Filename: transervsau.txt and transervdescsau.txt |
|||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
File Format | comma delimited - column size is fixed | |||||||||||||||||||||||
Sample Data | Sample | |||||||||||||||||||||||
|
File Availability and Location
transerv.txt and transervdesc.txt , transervsau.txt and transervdescsau.txt File Availability and Location
Product |
Platform/Package |
Location in Installation/Download Package |
---|---|---|
AFC License |
Unix |
transerv.txt, transervdesc.txt, transervsau.txt and transervdescsau.txt are in the db subdirectory. |
Windows |
All files are in the txt subdirectory |
|
AS/400 |
transerv.txt, transervdesc.txt, transervsau.txt and transervdescsau.txt are located in /eztax_db9. This is at the root of the Integrated File System (IFS). |
|
AFC SaaS Standard |
EZTaxWS_Std_docs_v9_1603.zip |
All files are in the txt subdirectory |
AFC SaaS Pro |
EZTaxWS_docs_v9_YYMM.zip EZTaxWS_sau_docs_v9_YYMM.zip |
All files are in the txt subdirectory |
Further information
Please submit a support case with any questions or if additional assistance is needed in accessing information files.
Availability of reporting in sandbox environments
The same reports are available in the sandbox environment, but the reporting data is not guaranteed to be up-to-date.
Appendix A – Supported Regions
Please refer to the following guide for the full list of ISO codes for supported countries, states, provinces, and territories:
Appendix B – AFC Sorting & Reporting Utilities
The format of compliance files may be that of any of the available AvaTax for Communications (AFC) sorting and reporting utilities listed in the table below.
Method |
Description |
Example |
---|---|---|
Date Method 0 |
This method gathers all transactions that were sent to our server during the previous month by looking at start time field for each transaction and generate the compliance files from that data on the first of every month or requested date. AFC uses date method 0 to generate compliance reports, unless specified by client. |
|
Date Method 1 |
This method processes data based on invoice date. We gather all transactions that have an invoice date of the previous month and generate the compliance files from that data on the first day of every month. |
|
Date Method 2 |
This method processes data based on an optional10 field. The client will fill in the optional10 field with the year and month (YYYYMM format) that they want the transaction to show up in their compliance files. When AFC runs the compliance reports, it only includes transactions from the previous month, based upon optional10 field. |
|