TM 00561 AFC Comprehensive Guide To Reports And Data Files

TM_00561_AFC%20Comprehensive%20Guide%20to%20Reports%20and%20Data%20Files

User Manual:

Open the PDF directly: View PDF .
Page Count: 81

Download
Open PDF In Browser	View PDF

AvaTax for Communications
Comprehensive Guide to Reports and Data Files
Document: TM_00561_0015
Date:
11/21/2018

Avalara for Communications - Contact Information
Address Avalara, Inc.
512 South Mangum Street, Suite 100
Durham, North Carolina, 27701
Email CommunicationSupport@avalara.com
Help Center https://help.avalara.com/Avalara_for_Communications
Toll Free (877) 780-4848
Corporate Web Site http://communications.avalara.com/
Communications https://communications.avalara.net
Customer Portal

All trade names referenced herein are either trademarks or registered trademarks of their respective companies.
© Avalara, Inc. 2018. CONFIDENTIAL

Document Revision History
The Revision History log lists the date and description of the most recent revisions or versions of the
document.
Date

Version

Description

04/27/2016
06/16/2016

0001
0002

06/24/2016

0003

07/22/2016

0004

08/25/2016

0005

09/26/2016

0006

12/22/2016
02/24/2017

0007
0008

03/24/2017

0009

05/25/2017
06/27/2017

0010
0011

10/25/2017
12/21/2017

0012
0013

10/25/2018

0014

11/21/2018

0015

Initial version of document.
Updated description for Transaction/Service Report (TSR) to include note that
any excluded jurisdictions will appear as unknown or not be included in the
report.
Updated Sections 2.1.1 Transaction/Service Report, 2.1.2 No Tax Log Report,
2.2.1 Detail Log Report, 2.3.2 Tax Compliance Reports, 2.3.3 Non-Billable
Compliance Amounts, 2.3.4 Billable Non-Compliance Amounts with note that
SaaS Standard clients will receive a CSV version of reports in addition to the
existing version.
Added Section 2.1.7 Transaction Count Report, Appendix D – International
NPANXX IDs, Section 2.1.2 Audit Transaction/Service Report, and Section 2.1.5
Audit Reconciliation Report.
Miscellaneous updates in Sections 2.1.1, 2.1.2, 2.1.4 and 2.1.5 regarding
report availability by product. Also updated column header within the
International NPANXX IDs table in Section 8 – Appendix D.
Updated Section 2.2.1 Detail Log Report and Section 2.4.5 Customsort Utility
to reflect the addition of new columns for extended optional fields. Added
Senegal to the International NPANXX IDs table in Section 8, Appendix D. Also
added a new Section 2.2.2 for Bridge Conference Reports.
Included alternate spelling for the country ‘Colombia’ in Sections 5 and 8.
References to ‘reverse’ tax calculations in the AFC engine have been updated
and renamed to reflect the current naming convention which is ‘tax inclusive’
calculations. As a result, minor references in Section 2.14 Reconciliation
Report and Section 2.1.5 Audit Reconciliation have been updated.
Updated report extension in Section 2.2.1 Detail Log Report as well as sample
data in Section 2.1.3 No Tax Log Report.
Updated Appendix A – Supported Country Codes
Updated Section 2.2.1 Detail Log Report to include columns for bundled
transactions in the detail log report.
Updated Avalara contact information (address and support site).
Updated Appendix A – Supported Country Codes and Appendix D International
NPANXX IDs with 6 new countries.
Updated Appendix A – Supported Country Codes and Appendix A – Supported
Country Codes and Appendix D International NPANXX IDs with 4 new
countries. Deleted Brazil state codes.
Updated Appendix A – Supported Country Codes and Appendix D –
International NPANXX IDs with 2-byte ISO codes.

Table of Contents
Overview ...................................................................................................................... 1
Report Descriptions......................................................................................................... 3
AFC Engine Reports ................................................................................................................ 3
Transaction/Service Report ............................................................................................... 3
Audit Transaction/Service Report ...................................................................................... 5
No Tax Log Report............................................................................................................. 7
Reconciliation Report........................................................................................................ 9
Audit Reconciliation Report............................................................................................. 11
Eztax Log (logfilename.log).............................................................................................. 13
Transaction Count Report ............................................................................................... 14
Batch Processor & Stored Procedure Reports ....................................................................... 17
Detail Log Report ............................................................................................................ 17
Bridge Conferencing Report ............................................................................................ 21
Compliance Reports ............................................................................................................. 22
Customer Billable Amounts ............................................................................................. 22
Tax Compliance Amounts ................................................................................................ 24
Non-Billable Compliance Amounts .................................................................................. 25
Billable Non-Compliance Amounts .................................................................................. 26
Billable Amounts Combined with Non-Billable Amounts .................................................. 27
Custom and Sorting Reports ................................................................................................. 28
srtcomma20 Utility, (Outputfilename.ext) ....................................................................... 28
srtcomma20l Utility, (Outputfilename.ext) ...................................................................... 30
srtcomma20ld Utility, (Outputfilename.ext) .................................................................... 32
srtcommadetail Utility, (Outputfilename.ext) .................................................................. 35
customsort Utility, (Outputfilename.ext) ......................................................................... 37
STRG Utility, (Outputfilename.ext)................................................................................... 41
Ezlogns Utility, Comma delimited log.ext, ........................................................................ 42
Ezlogcust Utility, Comma delimited log.ext ...................................................................... 43
Ezlogcustios Utility, Comma delimited log.ext.................................................................. 45
Ezlogcustpts Utility, Comma delimited log.ext ................................................................. 47
Qui ck

Refer ence G ui de

t o I n f o r m a t i o n a l F i l e s |i
Copyright  2018 Avalara, Inc.

Ezlogcustptslnl Utility, Comma delimited log.ext.............................................................. 49
Srtcdf20 and srtcdf20p, Outputfile.ext,............................................................................ 51
Other Reports ...................................................................................................................... 53
Output_ASCIILOG.ext...................................................................................................... 53
File Descriptions ............................................................................................................ 55
Tax Type Files ....................................................................................................................... 55
tax_type.exp ................................................................................................................... 55
Zip Address to PCode Cross Reference Files .......................................................................... 57
all_adr.txt ....................................................................................................................... 57
Calculation Type Files ........................................................................................................... 59
calculationType.txt.......................................................................................................... 59
FIPS Code Cross Reference to PCode Files ............................................................................. 60
fipspcd.txt , pcdfips.txt.................................................................................................... 60
NPANXX Cross Reference to PCode Files ............................................................................... 61
npanxx7.txt..................................................................................................................... 61
Transaction/Service Pair List and Description Files ................................................................ 62
transerv.txt and transervdesc.txt , transervsau.txt and transervdescsau.txt...................... 62
Further information ....................................................................................................... 63
Appendix A – Supported Country Codes ............................................................................. 64
Appendix B – Supported States, Territories and Provinces ...................................................... 68
USA States and Territories .................................................................................................... 68
Canadian Provinces and Territories ....................................................................................... 69
Appendix C – AFC Sorting & Reporting Utilities..................................................................... 71
Appendix D – International NPANXX IDs ............................................................................. 73

Qui ck

Refer ence G ui de

t o I n f o r m a t i o n a l F i l e s | ii
Copyright  2018 Avalara, Inc.

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 Engine Reports
Transaction/Service Report
Audit Transaction/Service Report
No Tax Log Report
Reconciliation Report
Audit Reconciliation Report
EZtax Log
Transaction Count Report
Batch Processor & Stored Procedures
Detail Log Report
Bridge Conferencing Report
EZtax_20 Utility
Compliance Reports
Customer Billable Amounts
Tax Compliance Amounts
Non-Billable Compliance Amounts
Billable Non-Compliance Amounts
Billable Amounts Combined with Non-Billable
Amounts









AFC SaaS Standard

AFC SaaS Pro






























Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |1 of 75
Copyright  2018 Avalara, Inc.

Overview of Report Availability By Product
AFC License
Custom and Sorting Reports
Srtcomma20 Utility
Srtcomma20l Utility
Srtcomma20ld Utility
Srtcommadetail Utility
Customsort Utility
STRG Utility
Ezlogns Utility
Ezlogcust Utility
Ezlogcustios Utility
Ezlogcustpts Utility
Ezlogcustptslnl Utility
Srtcdf20, srtcdf20p
ASCIILOG Utility
Data Files
Tax_type.exp
All_adr.txt
Calculationtype.txt
Fipspcd.txt, pcdfips.txt
Npanxx7.txt
Transerv.txt, transervdesc.txt,
transerserdescsau.txt

AFC SaaS Standard






















Compre he nsi ve G uide

AFC SaaS Pro











to R epor ts








a n d D a t a F i l e s |2 of 75
Copyright  2018 Avalara, Inc.

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
File
Format
Sample
Data

.tsr
Comma Delimited
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
Column Name
Jurisdiction
BundlePackage
BundleId
TransactionType
ServiceType
Charge

Description
Area subject to its own distinct tax regulations.
Numeric for bundled package.
Identifier for the bundle package.
Transaction Type used in the input transaction or derived out of
the bundle if a bundle transaction was used.
Service Type used in the input transaction or derived out of the
bundle if a bundle transaction was used.
Amount charged.

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
Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |3 of 75
Copyright  2018 Avalara, Inc.

Transaction Service Report Format and Sample Data

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
AFC License
AFC SaaS Standard
AFC SaaS Pro

Generated by
Default?



Received by
Default?



Available Upon
Request?



Compre he nsi ve G uide

Location

Note

Logging Directory
Report zip file
Emailed in zip file if
requested.

Upon request, this report can be
produced and provided.

to R epor ts

a n d D a t a F i l e s |4 of 75
Copyright  2018 Avalara, Inc.

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
File
Format
Sample
Data

_audit.tsr.csv
Comma Delimited
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
Column Name
Jurisdiction
BundlePackage
BundleId
TransactionType
ServiceType
Charge
Start Date
End Date

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |5 of 75
Copyright  2018 Avalara, Inc.

Audit Transaction Service Report Format and Sample Data
Sample
TSR (Bundled version) – CSV Format
BundleP
kg

BundleId

USA

20000

20001

USA

20000

20001

USA

20000

20001

USA

20000

20002

USA

20000

20002

USA

20000

20002

USA

20000

20002

Jurisdiction

Trans

Svc

Charge

Start Date

End Date

07/12/16 17:31:43

07/12/16 17:31:48

07/12/16 17:31:43

07/12/16 17:31:48

07/12/16 17:31:43

07/12/16 17:31:48

1.2

07/12/16 17:31:43

07/12/16 17:31:48

0.9

07/12/16 17:31:43

07/12/16 17:31:48

0.3

07/12/16 17:31:43

07/12/16 17:31:48

17.1

07/12/16 17:31:43

07/12/16 17:31:48

TSR (Non-Bundled version) – CSV Format
Jurisdiction

Trans

Svc

Charge

Start Date

End Date

USA

100

07/18/16 15:37:37

07/18/16 15:37:39

USA

100

07/18/16 15:37:37

07/18/16 15:37:39

100

07/18/16 15:37:37

07/18/16 15:37:39

100

07/18/16 15:37:37

07/18/16 15:37:39

100

07/18/16 15:39:19

07/18/16 15:39:20

USA

Availability of Reports
Audit Transaction Service Report Availability
Product
AFC License
AFC SaaS Standard

Generated by
Default?




Received by
Default?


Available Upon
Request?

Location

Note

Logging Directory
Report zip file

In addition to the existing report
provided in original format, this
audit version of the report is
produced and provided in CSV
format.



AFC SaaS Pro


Emailed in zip file if
requested.

Compre he nsi ve G uide

to R epor ts

The audit version of the report
name is XXXX_ audit.tsr.csv.
Upon request, this report can be
produced and provided in CSV
format.

a n d D a t a F i l e s |6 of 75
Copyright  2018 Avalara, Inc.

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
File Format
Sample Data

.ntl
Comma Delimited but fixed length
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
Column Name
Company ID
Customer
Number
Optional Alpha
1 field
TransactionType
ServiceType
PCode
Charges

Description
Input entered in the CompanyIdentifier field of the
TelecomTransaction or SalesUseTansaction.
Input entered in the CustomerNumber field of the
TelecomTransaction or SalesUseTansaction.
Input entered in the OptionalAlpha1 field of the
TelecomTransaction or SalesUseTansaction.
Note: Only displays in long format version.
Transaction Type used in the input transaction or derived out of
the bundle if a bundle transaction was used.
Service Type used in the input transaction or derived out of the
bundle if a bundle transaction was used.
PCode for taxing jurisdiction
Amount charged

Sample
Short Format Version identified company, customer number 4321, 000, 0000,
identified company, customer number 4321, 000, 0001,
identified company, customer number 4321, 000, 0002,

1249200,
1249200,
1249200,

Long Format Version identified company, customer number 4321, True, 000, 0000,
identified company, customer number 4321, True, 000, 0001,
identified company, customer number 4321, False, 000, 0002,

Compre he nsi ve G uide

53.27000
53.27000
53.27000

1249200,
1249200,
1249200,

53.27000
53.27000
53.27000

to R epor ts

a n d D a t a F i l e s |7 of 75
Copyright  2018 Avalara, Inc.

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
AFC License
AFC SaaS
Standard
AFC SaaS
Pro

Generated
by Default?

Received
by
Default?

Available Upon
Request?


Location

Note

Logging
Directory
Report zip file

Only generated by default if configuration
options are set properly by the user.
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.
Can set to generate by default if needed. Only
included if requested by customer.



Emailed in zip
file if
requested.

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |8 of 75
Copyright  2018 Avalara, Inc.

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
Reconciliation Report Format and Sample Data
Extension
File Format
Sample Data

.rtr
Comma Delimited
Column Headers
Jurisdiction, BundlePkg, BundleId, Trans, Svc, Charge, CalcCharge

Definitions for Reconciliation Report
Column Name
Jurisdiction
BundlePkg
BundleId
Trans
Svc
Charge
CalCharge

Description
Input entered in the CompanyIdentifier field of the
TelecomTransaction or SalesUseTansaction.
Numeric for bundled package.
Identifier for the bundle package.
Transaction Type used in the input transaction or derived out of
the bundle if a bundle transaction was used.
Service Type used in the input transaction or derived out of the
bundle if a bundle transaction was used.
Amount charged.
Calculated amount charged.

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

Sample

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |9 of 75
Copyright  2018 Avalara, Inc.

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?

AFC
License



AFC SaaS
Standard



AFC SaaS
Pro

Location

Note

Logging Directory

Only generated by default if
configuration options are set properly
by the user.
Can set to generate by default if
needed. Only included if requested by
customer.
Report is currently not available;
however, the data is accessible if
requested by the customer. It can be
implemented or created if needed.

Report zip file



Emailed in zip file if
requested.

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |10 of 75
Copyright  2018 Avalara, Inc.

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
File
Format
Sample
Data

_audit.rtr.csv
Comma Delimited
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
Column Name
Jurisdiction
BundlePkg
BundleId
Trans
Svc
Charge

CalCharge

Calculated amount charged.

Start Date

Timestamp (date and time) session was initiated.

End Date

Timestamp (date and time) session was terminated.

Sample
Reconciliation Report (Bundled version) – CSV Format
Jurisdiction

BundlePkg

BundleId

Trans

Svc

Charge

USA

20000

20001

USA

20000

20001

USA

20000

20001

USA

20000

20002

1.2

Compre he nsi ve G uide

CalcCharge

to R epor ts

Start Date
07/12/16
17:31:43
07/12/16
17:31:43
07/12/16
17:31:43
07/12/16
17:31:43

End Date
07/12/16
17:31:48
07/12/16
17:31:48
07/12/16
17:31:48
07/12/16
17:31:48

a n d D a t a F i l e s |11 of 75
Copyright  2018 Avalara, Inc.

Reconciliation Report (Non-Bundled version) – CSV Format
Jurisdiction

Trans

Svc

Charge

CalcCharge

Start Date

End Date

USA

-100

07/12/16 17:31:16

07/12/16 17:31:20

USA

07/12/16 17:31:16

07/12/16 17:31:20

USA

07/12/16 17:31:16

07/12/16 17:31:20

USA

07/12/16 17:31:16

07/12/16 17:31:20

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?

AFC
License

Location

Note

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.



AFC SaaS
Standard

Report zip file

In addition to the existing report
provided in original format, this audit
version of the report is produced and
provided in CSV format.



AFC SaaS
Pro



The audit version of the report name is
XXXX_ audit.rtr.csv.
Can set to generate by default if
needed. Only included if requested by
customer.

Emailed in zip file if
requested.

Compre he nsi ve G uide

to R epor ts

The audit version of the report name is
XXXX_ audit.rtr.csv.
Report is currently not available;
however, the data is accessible if
requested by the customer. It can be
implemented or created if needed.

a n d D a t a F i l e s |12 of 75
Copyright  2018 Avalara, Inc.

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
File Format

.log
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
AFC License
AFC SaaS
Standard
AFC SaaS Pro

Generated by
Default?

Received by
Default?

Available Upon
Request?


Location

Note

Logging Directory

This report is currently available.
This report is currently not available.
This report is currently not available.

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |13 of 75
Copyright  2018 Avalara, Inc.

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
File
Format
Sample
Data

.rpt
Comma Delimited
Detail Report Column Headers
Client, Platform, Module, Market, Trans, Svc, LicenseId, Authorized, Count, Start Date, End Date

Definitions for Detail Transaction Count Report
Column Name

Description

Client

Module

Blank by default. Will display licensed client when license
validation is active.
Blank by default. Will display licensed platform when license
validation is active.
Module Description for Transaction Count

Market

Market Id for Transaction Count

Platform

Trans
Svc
LicenseId
Authorized
Count
Start Date
End Date

Transaction Id for Transaction Count
Service Id for Transaction Count
0 by default. Will display license id when license validation is
active.
True by default. Will display false when license validation is
active and module is not licensed for client.
The number of transactions processed for Market/Trans/Svc.
Timestamp (date and time) session was initiated.
Timestamp (date and time) session was terminated.

Detail Report Sample
Client

Platform

Module

Market

Trans

Svc

LicenseId

Long
Distance

TRUE

07/05/2016
12:41:20

07/05/2016
12:41:31

Long
Distance

562

TRUE

07/05/2016
12:41:20

07/05/2016
12:41:31

Long
Distance

TRUE

07/05/2016
12:41:20

07/05/2016
12:41:31

Compre he nsi ve G uide

Authorized

Count

to R epor ts

Start Date

End Date

a n d D a t a F i l e s |14 of 75
Copyright  2018 Avalara, Inc.

Long
Distance

TRUE

07/05/2016
12:41:20

07/05/2016
12:41:31

Wireless

TRUE

07/05/2016
12:41:20

07/05/2016
12:41:31

Wireless

TRUE

07/05/2016
12:41:20

07/05/2016
12:41:31

Wireless

TRUE

07/05/2016
12:41:20

07/05/2016
12:41:31

Local

TRUE

07/05/2016
12:41:20

07/05/2016
12:41:31

Summary Report Column Headers
Client, Platform, Module, Market, LicenseId, Authorized, Count, Start Date, End Date

Definitions for Summary Transaction Count Report
Column Name
Client

Description

Module

Market

Market Id for Transaction Count

Platform

LicenseId
Authorized
Count
Start Date
End Date

0 by default. Will display license id when license validation is
active.
True by default. Will display false when license validation is
active and module is not licensed for client.
The number of transactions processed for Market/Trans/Svc.
Timestamp (date and time) session was initiated.
Timestamp (date and time) session was terminated.

Summary Report Sample
Client

Platform

Module

Market

LicenseId

Authorized

Long Distance

TRUE

Wireless

Local

Sales and Use

Start Date

End Date

07/05/2016 12:33:24

07/05/2016 12:33:35

TRUE

07/05/2016 12:33:24

07/05/2016 12:33:35

TRUE

07/05/2016 12:33:24

07/05/2016 12:33:35

TRUE

101

07/05/2016 12:33:24

07/05/2016 12:33:35

International

TRUE

325

07/05/2016 12:33:24

07/05/2016 12:33:35

Telecom Core

TRUE

136

07/05/2016 12:33:24

07/05/2016 12:33:35

VoIP

TRUE

07/05/2016 12:33:24

07/05/2016 12:33:35

Cable and Satellite

TRUE

07/05/2016 12:33:24

07/05/2016 12:33:35

Compre he nsi ve G uide

Count

to R epor ts

a n d D a t a F i l e s |15 of 75
Copyright  2018 Avalara, Inc.

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?

AFC License



Available Upon
Request?

Location

Note

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.
This report is currently not available.

AFC SaaS
Standard
AFC SaaS Pro

This report is currently not available.

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |16 of 75
Copyright  2018 Avalara, Inc.

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

File Format
Sample Data

Note: AFC SaaS Pro – {CompanyCode}_log{YYYYMMDD}.csv; AFC SaaS Standard – {InputFilename}_dtl.rpt
Comma Delimited but fixed length
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
Column Name

Description

Telecom TransactionID
AdjustmentMethod
BillToCountry
BillToState

Transaction ID used in the input transaction or derived out of the
bundle if a bundle transaction was used.
Adjustment setting.
Bill to country for taxing jurisdiction.
Bill to State for taxing jurisdiction.

BillToCounty

Bill to county for taxing jurisdiction.

BillToLocality

Bill to locality for taxing jurisdiction.

BillToZipcode

Bill to zip code for taxing jurisdiction.

BillToZipP4
BillToFipsCode

Bill to zip code plus 4 for taxing jurisdiction.
Bill to Fips code for taxing jurisdiction.

BillToNpaNxx

Bill to NpaNxx for taxing jurisdiction.

BillToPCode

Bill to PCode for taxing jurisdiction.

BusinessClass
Charge

Specification of business as CLEC or ILEC
Amount Charged

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |17 of 75
Copyright  2018 Avalara, Inc.

Detail Log Report Format and Sample Data
CompanyIdentifer
CountyExempt
CountyPCode
CustomerNumber
CustomerType
Date
Debit
DiscountType
ExemptionType
FacilitiesBased
ErrorMessage*
FederalExempt
FederalPCdoe
Franchise
Incorporated
InvoiceNumber
IsAdjustment*
Lifeline
TransactionLines
LocalExempt
LocalPCode
TransactionLocations
TransactionMinutes
Optional
Optional4
Optional5
Optiional6
Optional7
Optional8
Optional9
Optional10
OptionalAlpha1
OriginationCountry

Input entered in the CompanyIdentifier field of the
TelecomTransaction or SalesUseTansaction.
Input entered in the CountyExempt field of the
TelecomTransaction or SalesUseTansaction.
County PCode for taxing jurisdiction
Input entered in the CustomerNumber field of the
TelecomTransaction or SalesUseTansaction.
Input entered in the CustomerType field of the
TelecomTransaction or SalesUseTansaction.
Input entered in the Date field of the TelecomTransaction or
SalesUseTansaction.
Debit transaction.
Input entered in the DiscountType field of the
TelecomTransaction or SalesUseTansaction.
Input entered in the ExemptionType field of the
TelecomTransaction or SalesUseTansaction.
Input entered in the FacilitiesBased field of the
TelecomTransaction or SalesUseTansaction.
Error messages
Input entered in the FederalExempt field of the
TelecomTransaction or SalesUseTansaction.
Federal PCode for taxing jurisdiction
Input entered in the Franchise field of the TelecomTransaction or
SalesUseTansaction.
Input entered in the Incorporated field of the
TelecomTransaction or SalesUseTansaction.
Input entered in the InvoiceNumber field of the
TelecomTransaction or SalesUseTansaction.
Flag indicating whether bundle is an adjustment or tax
calculation
Identifier as a Lifeline participant.
Number of lines used for calculating the tax in per-line taxes.
Input entered in the LocalExempt field of the
TelecomTransaction or SalesUseTansaction.
Local PCode for taxing jurisdiction
Number of locations
Number of minutes used for calculating the tax in per-minute
taxes.
Input entered in the Optional field of the TelecomTransaction or
SalesUseTansaction.
Input entered in the Optional4 field of the TelecomTransaction or
SalesUseTansaction.
Input entered in the Optional5 field of the TelecomTransaction or
SalesUseTansaction.
Input entered in the Optional6 field of the TelecomTransaction or
SalesUseTansaction.
Input entered in the Optional7 field of the TelecomTransaction or
SalesUseTansaction.
Input entered in the Optional8 field of the TelecomTransaction or
SalesUseTansaction.
Input entered in the Optional9 field of the TelecomTransaction or
SalesUseTansaction.
Input entered in the Optional10 field of the TelecomTransaction
or SalesUseTansaction.
Input entered in the OptionalAlpha1 field of the
TelecomTransaction or SalesUseTansaction.
Originating country for taxing jurisdiction.

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |18 of 75
Copyright  2018 Avalara, Inc.

Detail Log Report Format and Sample Data
OriginationState
OriginationCounty
OriginalTransactionDate*
OriginationZipCode
OriginationZipP4

Originating state for taxing jurisdiction.
Originating county for taxing jurisdiction.
Input entered in the Date field of the TelecomTransaction or
SalesUseTansaction.
Originating zip code for taxing jurisdiction.
Originating zip code plus 4 for taxing jurisdiction.

OriginationFipsCode

Originating Fipscode for taxing jurisdiction.

OriginationNpaNxx

Originating NPaNxx for taxing jurisdiction.

OriginationPCode

Originating PCode for taxing jurisdiction.

ProcessingDate*
ProvinceState*
Regulated
Sale
ServiceClass
ServiceLevelNumber
ServiceType
StateExempt
StatePCode
TerminationCountry
TerminationState

Date bundle file processed
State or province abbreviation for taxing jurisdiction.
Input entered in the Regulated field of the TelecomTransaction
or SalesUseTansaction.
Sale amount
Specification of service class
Input entered in the ServiceLevelNumber field of the
TelecomTransaction or SalesUseTansaction.
Service Type used in the input transaction or derived out of the
bundle if a bundle transaction was used.
Input entered in the StateExempt field of the
TelecomTransaction or SalesUseTansaction.
State PCode for taxing jurisdiction.
Termination country for taxing jurisdiction.
Termination state for taxing jurisdiction.

TerminationCounty

Termination county for taxing jurisdiction.

TerminationLocality

Termination locality for taxing jurisdiction.

TerminationZipCode

Termination zip code for taxing jurisdiction.

TerminationZipP4
TerminatinonFipsCode

Termination zipc ode plus 4 for taxing jurisdiction.
Termination Fipscode for taxing jurisdiction.

TerminationNpaNxx

Termination NpaNxx for taxing jurisdiction.

TerminationPCode

Termination PCode for taxing jurisdiction.

TransactionType
BundlePackage*
BundleId*
TransactionCharge*
CountryISO
State

Transaction Type used in the input transaction or derived out of
the bundle if a bundle transaction was used.
Bundle Transaction Type Value
Bundle Service Type Value
Charge for Bundle
Three-character country code for taxing jurisdiction.
State abbreviation for taxing jurisdiction.

County

County name for taxing jurisdiction.

Locality

Locality name for taxing jurisdiction.

PCode
TaxTypeID
TaxType
TaxLevelID

PCode for taxing jurisdiction
Tax Type ID used in the input transaction or derived out of the
bundle if a bundle transaction was used.
Tax type identifier.
Tax Level ID used in the input transaction or derived out of the
bundle if a bundle transaction was used.

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |19 of 75
Copyright  2018 Avalara, Inc.

Detail Log Report Format and Sample Data
TaxLevel
Rate
CalculationType
TaxAmount
GrossSales
ExemptSaleAmount
Adjustments
NetSales
TaxDataLines
TaxDataLocations
TaxDataMinutes
Billable

Tax level identifier.
Rate for tax.
Calculation type for tax.
Tax amount.
Gross sale amount. This field is used for srtcomma20ld and
srtcommadetail reports.
Exempt sale amount from tax record.
Adjustment calculation
Net sale amount. This field is used for srtcomma20ld and
srtcommadetail reports.
Number of lines used for calculating the tax in per-line taxes.
Number of locations.
Number of minutes used for calculating the tax in per-minute
taxes.
Billable flag for tax.

Compliance

Compliance flag from tax record.

BridgeConf

Flag for transactional data related to bridge conferencing.

**OptionalField1
**OptionalField2
**OptionalField3
**OptionalField4
**OptionalField5
**OptionalField6

Additional Extended Optional fields in which column headers are
defined by the user upon creation of each one.

**OptionalField7
**OptionalField8
**OptionalField9
**OptionalField10
*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 contact communicationsupport@avalara.com for a sample Detail Log Report which includes columns for the
Extended Optional fields.

Sample
248184589

248184589

248184729

0
FALSE
FALSE
0
61
0.00331
TRUE
0
FALSE
FALSE
0
61
0.182
TRUE
0
FALSE
FALSE
0

2102300
0
0
USA
1
2102300
0
0
USA
1
2102300
0
0

1
0
0
839300

100
FALSE
0
FALSE

TSY_Test
FALSE
0
TRUE

0.331

100

1
0
0
839300

100
FALSE
0
FALSE

TSY_Test
FALSE
0
TRUE

FALSE
0
0
1
0
0

0
FALSE
0
0
169
100

1
2/24/2016 12:00
TRUE
0
FALSE
0
0
0
0
0
585
FALSE
0
2102300
FCC Regulatory Fee (Wireline)0
Federal
0
0
0
TRUE

0
FALSE
0
0
18
100

1
TRUE
0
0
0
585
FALSE
Fed Universal Service Fund
0
0

0
FALSE
0
0

TRUE
0
585

18.2

100

FALSE
0
0
1
0
0

1
0
0
839300

100
FALSE
0
FALSE

TSY_Test
FALSE
0
TRUE

FALSE
0
0
1

Compre he nsi ve G uide

to R epor ts

1
0
0
FALSE

2/24/2016 12:00
FALSE
0
0
0
0
2102300
0
Federal
0
TRUE
2/24/2016 12:00
FALSE
0
0
0
0
2102300

a n d D a t a F i l e s |20 of 75
Copyright  2018 Avalara, Inc.

Detail Log Report Format and Sample Data
248184729

248184736

61
0.00331
TRUE
0
FALSE
FALSE
0
61
0.182
TRUE
0
FALSE
FALSE
0
61
0.00331
TRUE
0
FALSE
FALSE
0
61
0.182
TRUE
0

USA
1
2102300
0
0
USA
1
2102300
0
0
USA
1
2102300
0
0
USA
1
100

0.331

100

1
0
0
839300

100
FALSE
0
FALSE

TSY_Test
FALSE
0
TRUE

18.2

100

1
0
0
839300

100
FALSE
0
FALSE

TSY_Test
FALSE
0
TRUE

0.331

100

1
0
0
839300

100
FALSE
0
FALSE

TSY_Test
FALSE
0
TRUE

0
0

169
100

FCC Regulatory Fee (Wireline)0
0
0
0

FALSE
0
0
1
0
0

0
FALSE
0
0
18
100

1
TRUE
0
0
0
585
FALSE
Fed Universal Service Fund
0
0

FALSE
0
0
1
0
0

0
FALSE
0
0
169
100

1
2/24/2016 12:00
TRUE
0
FALSE
0
0
0
0
0
585
FALSE
0
2102300
FCC Regulatory Fee (Wireline)0
Federal
0
0
0
TRUE

0
FALSE
0
0
18
100

1
TRUE
0
0
0
585
FALSE
Fed Universal Service Fund
0
0

TRUE

18.2

100

FALSE
0
0
1
0
0

TRUE

Federal
TRUE

2/24/2016 12:00
FALSE
0
0
0
0
2102300
0
Federal
0
TRUE

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?

AFC License
AFC SaaS
Standard

Location

Note

Working Directory
Report zip file

This report is currently not available.
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.
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.



AFC SaaS Pro

Emailed in zip file if
requested.


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.

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |21 of 75
Copyright  2018 Avalara, Inc.

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
File Format
Sample Data

.csf (customer sort format)
Fixed Position
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
Len

Positions

Description

Column Name

Type

Note

Customer
Number

A/N

1-20

Defines primary output key
passed from client input data

Tax type

A/N

21-26

Telecommunications tax type (see
Tax Types table for listing)
0 = Federal

Input entered in the
CustomerNumber field of
the TelecomTransaction or
SalesUseTansaction.
Tax type identifier.
Tax level identifier.

1 = State
Tax level

A/N

2 = County
3 = City
4 = Un-incorporated

Tax amount
sign

Tax amount

11.5

29-39

File record
length

Format "+" or "-"
Format "99999999999" zerofilled, 5 decimal places (no
decimal point)

Numeric
Tax amount.

Definitions for Data Specification for Output (.CSF) Files Sorted with SrtComma20.exe and
SrtComma20l.exe With –pcsf specified after input name
Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |22 of 75
Copyright  2018 Avalara, Inc.

Customer Billable Amounts Report Format and Sample Data
Len

Positions

Description

Column Name

Type

Note

Primary
output key

A/N

1-20

Defines primary output key
passed from client input data

A/N

21-26

Telecommunications tax type
(see Tax Types table for
listing)

Tax type identifier.

Tax type

0 = Federal

Tax level identifier.

1= State
Tax level

A/N

2 = County

3 = City
4 = Un-incorporated
Tax amount
sign

Tax amount

11.5

29-39

Format "99999999999" zerofilled, 5 decimal places (no
decimal point)

P Code

40-48

Permanent Code

File record
length

Format "+" or "-"

Numeric
Tax amount.

PCode for taxing
jurisdiction

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
AFC License

Generated
by Default?


Received
by Default?

Available Upon
Request?



AFC SaaS
Standard


Location

Note

Working
Directory

This report is generated by
default.

Report zip file

Clients configured for
compliance reporting
receive this report by
default. It is generated as
the batch of transactions
are processed.
This report is currently not
available; however, the
data is accessible if
requested by the
customer.



AFC SaaS Pro


Compre he nsi ve G uide

Emailed in zip
file if
requested.

to R epor ts

a n d D a t a F i l e s |23 of 75
Copyright  2018 Avalara, Inc.

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
File Format
Sample Data

.ssf
Comma Delimited
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
Column Name

Country
State

Description
Three-character country code for taxing
jurisdiction.
State abbreviation for taxing jurisdiction.

County

County name for taxing jurisdiction.

Locality

Locality name for taxing jurisdiction.

Tax Type

Tax type identifier.

Tax Level

Tax level identifier.

Tax Rate

Rate for tax.

Tax Amount
Gross Sale
Exempt
Adjustments
Taxable
Measure
Minutes

Tax amount.
Gross sale amount. This field is used for
srtcomma20ld and srtcommadetail reports.
Exempt sale amount from tax record.
Adjustment calculation.
Taxable measure used for calculating the tax.
Number of minutes used for calculating the tax
in per-minute taxes.

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

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |24 of 75
Copyright  2018 Avalara, Inc.

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?

AFC License
AFC SaaS
Standard


Location

Note

Working
Directory
Report zip file

This file is not generated when the [-cl]
command line option is used.
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.
Reports are generated by default going
forward with assumption of Date
Method 0. Reports are generated on a
monthly basis.



AFC SaaS Pro

Emailed in zip
file if requested.



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
File format

.nba
.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
AFC License

Generated by
Default?

Received by
Default?

Available Upon
Request?

Location

Note

Working
Directory

This file is not generated when the
[-cl] command line option is used.

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |25 of 75
Copyright  2018 Avalara, Inc.

Non Billable Amounts for Compliance Report Availability
AFC SaaS
Standard

Report zip
file




AFC SaaS Pro

Emailed in
zip file if
requested.



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.
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).

Report Format
Billed Non-Compliance Report Format and Sample Data
Extension
File Format

.nca
.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?

Location

Note

AFC License

Working
Directory

AFC SaaS
Standard

Report zip
file

This file is generated only if there
are transactions in the AFC log that
do not require compliance with a
jurisdiction.
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.



Received by
Default?

Available Upon
Request?



Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |26 of 75
Copyright  2018 Avalara, Inc.

Billed Non-Compliance Report Availability
AFC SaaS Pro

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
File Format

.scl
.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
AFC License

Generated
by Default?

Received
by Default?

Available Upon
Request?


AFC SaaS
Standard

Location

Note

Working
Directory
Report zip file

Clients may configure
this report if needed.
This report is currently
not available; however,
the data is accessible if
requested by the
customer.
Clients may request to
have this report
configured if needed.



AFC SaaS Pro


Compre he nsi ve G uide

Emailed in zip file
if requested.

to R epor ts

a n d D a t a F i l e s |27 of 75
Copyright  2018 Avalara, Inc.

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
File Format
Sample Data

.ssf, .csf
Comma Delimited
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

Column Name

Description

Country

Three-character country code for taxing
jurisdiction.

State

State abbreviation for taxing jurisdiction.

County

County name for taxing jurisdiction.

Locality

Locality name for taxing jurisdiction.

Tax Type

Tax type identifier.

Tax Level

Tax level identifier.

Tax Rate

Rate for tax.

Tax Amount

Tax amount.
Gross sale amount. This field is used for
srtcomma20ld and srtcommadetail reports.

Gross Sale

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |28 of 75
Copyright  2018 Avalara, Inc.

Srtcomma20 Utility Report Format and Sample Data
Exempt

Exempt sale amount from tax record.

Adjustments
Taxable
Measure

Adjustment calculation

Minutes

Taxable measure used for calculating the tax.
Number of minutes used for calculating the
tax in per-minute taxes.

Sample

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
AFC License

Generated by
Default?

Received by
Default?

Available Upon
Request?


AFC SaaS
Standard

Location

Note

Working
Directory
Report zip file

The referenced utility can be
used to generate this report.
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.
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.



AFC SaaS Pro

Emailed in zip
file if
requested.


Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |29 of 75
Copyright  2018 Avalara, Inc.

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
File Format
Sample Data

.ssf
Comma Delimited
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
Column Name

Description

Country

Three-character country code for taxing jurisdiction.

State

State abbreviation for taxing jurisdiction.

County

County name for taxing jurisdiction.

Locality

Locality name for taxing jurisdiction.

Tax Type

Tax type identifier.

Tax Level

Tax level identifier.

Tax Rate

Rate for tax.

Tax Amount
Gross Sale

Tax amount.
Gross sale amount. This field is used for srtcomma20ld and
srtcommadetail reports.

Exempt

Exempt sale amount from tax record.

Adjustments
Taxable
Measure

Adjustment calculation.

Minutes

Taxable measure used for calculating the tax.
Number of minutes used for calculating the tax in per-minute
taxes.

Lines

Number of lines used for calculating the tax in per-line taxes.

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

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |30 of 75
Copyright  2018 Avalara, Inc.

Srtcomma20l Utility Report Format and Sample Data

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

Column Name

Description

PCode
Tax type identifier.

Tax Type

Tax level identifier.

Tax Level
Tax Rate

Rate for tax.

Tax Amount

Tax amount.

Gross Sale

Gross sale amount. This field is used for
srtcomma20ld and srtcommadetail reports.

Exempt

Exempt sale amount from tax record.

Adjustments

Adjustment caluculation.

Taxable Measure

Taxable measure used for calculating the tax.
Number of minutes used for calculating the
tax in per-minute taxes.
Number of lines used for calculating the tax in
per-line taxes.

Minutes
Lines

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
AFC License

Generated by
Default?

Received by
Default?

Available Upon
Request?


AFC SaaS
Standard

Location

Note

Working
Directory
Report zip
file



Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |31 of 75
Copyright  2018 Avalara, Inc.

AFC SaaS Pro


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
File Format
Sample Data

.ssf,
Comma Delimited Fixed Length
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

Column Name

Description

Country

Three-character country code for taxing
jurisdiction.

State

State abbreviation for taxing jurisdiction.

County

County name for taxing jurisdiction.

Locality

Locality name for taxing jurisdiction.

Tax Type

Tax type identifier.

Tax Level

Adjustment Type

Tax level identifier.
Input entered in the AdjustmentType field
of the TelecomTransaction or
SalesUseTansaction.

Calculation Type

Calculation type for tax.

Tax Rate

Rate for tax.

Tax Amount

Tax amount.
Gross sale amount. This field is used for
srtcomma20ld and srtcommadetail
reports.

Gross Sale

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |32 of 75
Copyright  2018 Avalara, Inc.

Srtcomma20ld Utility Report Format and Sample Data
Exempt

Exempt sale amount from tax record.

Adjustments

Adjustment calculation
Taxable measure used for calculating the
tax.
Number of minutes used for calculating
the tax in per-minute taxes.

Taxable Measure
Minutes
Lines

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
Column Name

Description

PCode

PCode for taxing jurisdiction

Tax Type

Tax type identifier.

Tax Level
Discount Type
Calculation Type
Adjustment Type
Calc Type

Tax level identifier.
Input entered in the DiscountType field of the
TelecomTransaction or SalesUseTansaction.
Calculation type for tax.
Adjustment type for tax.
Calculation type for tax.

Tax Rate

Rate for tax.

Tax Amount

Tax amount.

Gross Sale

Gross sale amount. This field is used for
srtcomma20ld and srtcommadetail reports.

Exempt

Exempt sale amount from tax record.

Adjustments

Adjustment calculation

Taxable Measure

Taxable measure used for calculating the tax.

Minutes
Lines

Number of minutes used for calculating the
tax in per-minute taxes.
Number of lines used for calculating the tax in
per-line taxes.

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

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |33 of 75
Copyright  2018 Avalara, Inc.

Srtcomma20ld Utility Report Format and Sample Data

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?

AFC License

Location

Note

Working Directory

The referenced utility can be used
to generate this report.

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.
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.


AFC SaaS Standard


AFC SaaS Pro

Emailed in zip file if
requested.


Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |34 of 75
Copyright  2018 Avalara, Inc.

srtcommadetail Utility, (Outputfilename.ext)
Description
Same as srtcomma20 but the .ssf file includes Tax Type and Tax Level descriptions.

Report Format and Sample Data
Srtcommadetail utility Report Format and Sample Data
Extension
File Format
Sample Data

.ssf
Comma Delimited
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
Column Name

Description

Country

Three-character country code for taxing
jurisdiction.

State

State abbreviation for taxing jurisdiction.

County

County name for taxing jurisdiction.

PCode

PCode for taxing jurisdiction

Locality

Locality name for taxing jurisdiction.

Tax Type
Tax Type
Description

Tax type identifier.

Tax Level
Tax Level
Description

Tax level identifier

Tax Rate

Rate for tax.

Tax Amount

Gross Sale

Tax amount.
Gross sale amount. This field is used for
srtcomma20ld and srtcommadetail
reports.

Exempt

Exempt sale amount from tax record.

Adjustments

Adjustment calculation
Taxable measure used for calculating the
tax.
Number of minutes used for calculating
the tax in per-minute taxes.

Taxable Measure
Minutes

Description for tax type.

Description for tax level identifier.

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |35 of 75
Copyright  2018 Avalara, Inc.

Srtcommadetail utility Report Format and Sample Data
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?

AFC License

AFC SaaS Standard

Location

Note

Working
Directory

The referenced utility can be used to
generate this report.

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.
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.



AFC SaaS Pro

Emailed in zip
file if requested.


Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |36 of 75
Copyright  2018 Avalara, Inc.

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
File
Format
Sample
Data

.csv, .xls
Comma Delimited
Definitions
Token

Description

OUTPUT_FILENAME_FORMAT

Format to be used for output / reports

BASE

The base format to be used.

OPTION

User supplied option.

ALGORITHM

Algorithm for calculating net taxable sale amount.

CALCULATED_VALUE_PRECISI
ON
DEFAULT_EXT

Precision to be used in reports for calculated floating point.

DATA_DIR

Directory specify where the EZtax data resides.

WORKING_DIR

Working directory for custom sort.

Precision to be used in reports for calculated floating point.

*OptionalField1
*OptionalField2
*OptionalField3
*OptionalField4
*OptionalField5
*OptionalField6

Additional Extended Optional fields in which column headers are
defined by the user upon creation of each one. Please note
these additional optional columns only apply to AFC SaaS Pro.

*OptionalField7
*OptionalField8
*OptionalField9
*OptionalField10
*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.

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |37 of 75
Copyright  2018 Avalara, Inc.

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
Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |38 of 75
Copyright  2018 Avalara, Inc.

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
Request
Type

Date

BillTo
BillTo
Country ISO State

BillTo
County

BillTo
Loc ality

BillTo
Transac tion Servic e Customer Invoic e
ZipCode Charge
Type
Type
Number Number

CalcTaxes 20160315 USA

Brevard

Cocoa Beach

32931

6 Customer 1

987654

CalcTaxes 20160315 USA

Brevard

Cocoa Beach

32931

50 Customer 1

123456

CalcTaxes 20160315 USA

San Francisco San Francisco

94102

6 Customer 2 4567890

CalcTaxes 20160315 USA

San Francisco San Francisco

94102

50 Customer 2 4567890

CalcTaxes 20160315 USA

New York

10001

6 Customer 3

1234

CalcTaxes 20160315 USA

New York

10001

36 Customer 3

5678

Sample Output 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

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |39 of 75
Copyright  2018 Avalara, Inc.

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?

AFC License

AFC SaaS Standard

Location

Note

Working
Directory

The referenced utility can be used to
generate this report.

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.
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.



AFC SaaS Pro

Emailed in zip file
if requested.


Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |40 of 75
Copyright  2018 Avalara, Inc.

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
STRG Utility Report Format and Sample Data
Extension
File Format
Sample
Data

.ssf
Comma Delimited
Column Headers
PCode, Tax Type, Tax Level, Tax Rate, Tax Amount Sign, Tax Amount, File Record Length

Definitions for STRG SSF File Format Key
Column Name

Description

Length

Positions

PCode

PCode for taxing jurisdiction

1-9

Tax Type

Tax type identifier.

10-15

Tax Level

Tax level identifier.

Tax Rate

Rate for tax.

17-24

11.5

26-36

Tax Amount Sign
Tax Amount
File Record Length

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?

AFC License

Location

Note

Working Directory

The referenced utility can
be used to generate this
report.



Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |41 of 75
Copyright  2018 Avalara, Inc.

STRG Utility Report Availability
Product

Generated
by Default?

Received
by Default?

Available Upon
Request?

Location

Note

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
Ezlog ns Utility Report Format and Sample Data
Extension
File Format
Sample
Data

.rpt
Comma Delimited
Column Headers
Country, State, County, Locality,, Tax Type, Tax Level, Tax Rate, Tax Amount, Gross Sale, Exempt, Adjustments, Taxable Measure, Minutes

Definitions for Ezlog ns
Column Name

County

Description
Three-character country code for
taxing jurisdiction.
State abbreviation for taxing
jurisdiction.
County name for taxing jurisdiction.

Locality

Locality name for taxing jurisdiction.

Country
State

Sample Data
USA
6

Tax Type

Tax type identifier.

Tax Level

Tax level identifier.

Tax Rate

Rate for tax.

Tax Amount

Tax amount.
Gross sale amount. This field is used
for srtcomma20ld and
srtcommadetail reports.

Gross Sale

o.030000
29881.866905
996062.252444

Exempt

Exempt sale amount from tax record.

Adjustments
Taxable
Measure

Adjustment calculation
Taxable measure used for calculating
the tax.

Minutes

Compre he nsi ve G uide

996062.252444
14859213

to R epor ts

a n d D a t a F i l e s |42 of 75
Copyright  2018 Avalara, Inc.

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.
EZlog ns Utility Report Availability
Product

Generated
by Default?

Received
by Default?

Available Upon
Request?

AFC License

Location

Note

Working Directory

The referenced utility can
be used to generate this
report.
This report is currently
not available.


AFC SaaS
Standard
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
File Format
Sample
Data

.rpt
Comma Delimited
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

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |43 of 75
Copyright  2018 Avalara, Inc.

Column Name
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

Description
Three-character country code for taxing jurisdiction.
State abbreviation for taxing jurisdiction.
County name for taxing jurisdiction.
Locality name for taxing jurisdiction.
Tax type identifier.
Tax level identifier.
Rate for tax.
Calculation type for tax.
Tax amount
Gross sale amount. This field is used for srtcomma20ld and
srtcommadetail reports.
Exempt sale amount from tax record.
Adjustment calculation
Taxable measure used for calculating the tax.
Number of lines used for calculating the tax in per-line taxes.
Number of locations
Number of minutes used for calculating the tax in per-minute taxes.
Input entered in the CustomerNumber field of the TelecomTransaction
or SalesUseTansaction.

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
AFC License

Generated
by Default?

Received
by Default?

Available Upon
Request?


Location

Note

Working
Directory

The referenced utility can be
used to generate this report.
This report is currently not
available.

AFC SaaS
Standard
AFC SaaS Pro

This report is currently not
available.

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |44 of 75
Copyright  2018 Avalara, Inc.

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
File Format
Sample
Data

.rpt
Comma Delimited
Column Headers
Invoice Numeber, 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
Column Name
Invoice Number
Optional
Service Level Number
Country

Decription
Input entered in the InvoiceNumber field of the
TelecomTransaction or SalesUseTansaction.
Input entered in the Optional field of the
TelecomTransaction or SalesUseTansaction.
Input entered in the ServiceLevelNumber field of
the TelecomTransaction or SalesUseTansaction.
Three-character country code for taxing
jurisdiction.

State

State abbreviation for taxing jurisdiction.

County

County name for taxing jurisdiction.

Locality

Locality name for taxing jurisdiction.

Tax Type

Tax type identifier.

Tax Level

Tax level identifier.

Tax Rate

Rate for tax.

Tax Amount

Tax amount

Gross Sale

Gross sale amount. This field is used for
srtcomma20ld and srtcommadetail reports.

Exempt

Exempt sale amount from tax record.

Adjustments

Numeric

Taxable Measure

Taxable measure used for calculating the tax.

Minutes
Customer Number

Number of lines used for calculating the tax in perline taxes.
Input entered in the CustomerNumber field of the
TelecomTransaction or SalesUseTansaction.

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.

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |45 of 75
Copyright  2018 Avalara, 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
AFC License

Generated
by Default?

Received
by Default?

Available Upon
Request?


Location

Note

Working
Directory

The referenced utility can be
used to generate this report.
This report is currently not
available.

AFC SaaS
Standard
AFC SaaS Pro

This report is currently not
available.

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |46 of 75
Copyright  2018 Avalara, Inc.

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
File Format
Sample
Data

.rpt
Comma Delimited
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
Column Name

Description

PCode

PCode for taxing jurisdiction

Optional
Service Level Number

Input entered in the Optional field of the TelecomTransaction or
SalesUseTansaction.
Input entered in the ServiceLevelNumber field of the
TelecomTransaction or SalesUseTansaction.

Country

Three-character country code for taxing jurisdiction.

State

State abbreviation for taxing jurisdiction.

County

County name for taxing jurisdiction.

Locality

Locality name for taxing jurisdiction.

Tax Type

Tax type identifier.

Tax Level

Tax level identifier.

Tax Rate

Rate for tax.

Tax Amount

Tax amount

Gross Sale

Gross sale amount. This field is used for srtcomma20ld and
srtcommadetail reports.

Exempt

Exempt sale amount from tax record.

Adjustments

Adjustment calculation.

Taxable Measure

Taxable measure used for calculating the tax.

Minutes

Number of lines used for calculating the tax in per-line taxes.

Customer Number

Input entered in the CustomerNumber field of the
TelecomTransaction or SalesUseTansaction.

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.
Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |47 of 75
Copyright  2018 Avalara, Inc.

Availability of Report
This report is generated by the Ezlogcustpts Utility.
EZlogcustpts Utility Report Availability
Product
AFC License

Generated
by Default?

Received
by Default?

Available Upon
Request?


Location

Note

Working
Directory

The referenced utility can be
used to generate this report.
This report is currently not
available.

AFC SaaS
Standard
AFC SaaS Pro

This report is currently not
available.

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |48 of 75
Copyright  2018 Avalara, Inc.

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
File Format
Sample
Data

Definitions for Ezlogcustptslnl
Column Name

Description

PCode

PCode for taxing jurisdiction

Optional
Service Level Number

Input entered in the Optional field of the TelecomTransaction or
SalesUseTansaction.
Service ID used in the input transaction or derived out of the bundle
if a bundle transaction was used.

Country

Three-character country code for taxing jurisdiction.

State

State abbreviation for taxing jurisdiction.

County

County name for taxing jurisdiction.

Locality

Locality name for taxing jurisdiction.

Tax Type

Tax type identifier.

Tax Level

Tax level identifier.

Tax Rate

Rate for tax.

Tax Amount

Tax amount

Gross Sale

Gross sale amount. This field is used for srtcomma20ld and
srtcommadetail reports.

Exempt

Exempt sale amount from tax record.

Adjustments

Adjustment calculation

Taxable Measure

Taxable measure used for calculating the tax.

Minutes

Number of lines used for calculating the tax in per-line taxes.

Customer Number

Input entered in the CustomerNumber field of the
TelecomTransaction or SalesUseTansaction.

Lines

Number of lines used for calculating the tax in per-line taxes.

Location

Number of locations

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |49 of 75
Copyright  2018 Avalara, Inc.

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
AFC License

Generated
by Default?

Received
by Default?

Available Upon
Request?


Location

Note

Working
Directory

The referenced utility can be
used to generate this report.
This report is currently not
available.

AFC SaaS
Standard
AFC SaaS Pro

This report is currently not
available.

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |50 of 75
Copyright  2018 Avalara, Inc.

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
File Format
Sample
Data

.ssf, .csf
Fixed Length
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

Column Name

Description

Length

PCode

PCode for taxing jurisdiction.

1-9

Tax Type

Tax type identifier.

10-15

Tax Level

Tax level identifier.

Tax Rate

Rate for tax.

8.5

17-24

Tax Amount Sign

Numeric

Tax Amount

Tax amount

File Record Length

Column Name
Customer Number

Positions

11.5

26-36

Description
Input entered in the CustomerNumber
field of the TelecomTransaction or
SalesUseTansaction.

Length

Positions

1-9

21-26

Tax Type

Tax type identifier.

Tax Level

Tax level identifier.

Tax Amount Sign

Numeric

28-39

Tax Amount

40-69

File Record Length

39 or 89

Sample
0
1
2
3
1234567890123456….
-----------------------------------------------------------000000000000006000003000+00098418707
000000000000007000000580+00018387113
000000000000018000003180+00081599822
000000000000031000000039+00001000752

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |51 of 75
Copyright  2018 Avalara, Inc.

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
AFC License
AFC SaaS
Standard

Generated
by Default?

Received
by Default?

Available Upon
Request?



Location

Note

Working
Directory
Report zip file

The referenced utility can be
used to generate this report.
CDF users or clients may
request reports in this format.

AFC SaaS Pro

This report is currently not
available.

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |52 of 75
Copyright  2018 Avalara, Inc.

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
File Format
Sample
Data

.csv
Comma Delimited
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

Column Name

State

Description
Three-character country code for taxing
jurisdiction.
State abbreviation for taxing jurisdiction.

County

County name for taxing jurisdiction.

City

City name for taxing jurisdiction.

Tax Type

Tax type identifier.

Tax Level

Tax level identifier.

Tax Rate

Rate for tax.

Tax Amount
Charges

Tax amount
Amount charged.
Input entered in the ExemptionType field of
the TelecomTransaction or
SalesUseTansaction.
Adjustment calculation
Net sale amount. This field is used for
srtcomma20ld and srtcommadetail reports.
Number of minutes used for calculating the
tax in per-minute taxes.
Input entered in the InvoiceNumber field of
the TelecomTransaction or
SalesUseTansaction.
Input entered in the ServiceLevelNumber
field of the TelecomTransaction or
SalesUseTansaction.
Input entered in the Optional field of the
TelecomTransaction or SalesUseTansaction.
Number of lines used for calculating the tax
in per-line taxes.
Number of locations.
Calculation type for tax.

Country

Exemptions
Adjustments
Net Sales
Minutes
Invoice Number

Service Level Number
Optional
Lines
Locations
Calculation Type

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |53 of 75
Copyright  2018 Avalara, Inc.

Input entered in the CustomerNumber field
of the TelecomTransaction or
SalesUseTansaction.

Customer Number

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
AFC License

Generated
by Default?

Received
by Default?

Available Upon
Request?


AFC SaaS
Standard

Location

Note

Working
Directory
Report zip file

This report can be created by
using the ASCIILog utility.
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.
This report is currently not
available; however, the Detail
Log report is available to SaaS
Pro clients and is considered
equivalent in content.



Emailed

AFC SaaS Pro


Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |54 of 75
Copyright  2018 Avalara, Inc.

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.
Refer to Section 4.3.5 Tax Types in the AFC User Manual for more detailed information on tax types.

File Format and Sample
Tax_Type.exp File Format and Sample Data
File Name
File Format
Sample Data

tax_type.exp
tab delimited
Sample
Column Name
TAX_TYPE
Description
Reference

TAX_CAT_ID

Description
Numeric identifier for the tax
Description of the tax
Reference to the high level application of the tax.
Reference
DESCRIPTION
1

Telecom Tax

Sales and Use Tax

Both Telecom and Sales and Use Tax

Tax Category identifier
TAX_CAT_ID

DESCRIPTION
0

NO CATEGORY DESCRIPTION

SALES AND USE TAXES

BUSINESS TAXES

GROSS RECEIPTS TAXES

EXCISE TAXES

CONNECTIVITY CHARGES

REGULATORY CHARGES

E-911 CHARGES

Compre he nsi ve G uide

to R epor ts

a n d D a t a F i l e s |55 of 75
Copyright  2018 Avalara, Inc.

UTILITY USER TAXES

RIGHT OF WAY FEES

COMMUNICATIONS SERVICES TAX

CABLE REGULATORY FEES

RESERVED

VALUE ADDED TAXES

File Availability and Location
tax_type.exp File Availability and Location
Product
AFC License

Platform/Package
Unix

Location in Installation/Download Package
tax_type.exp is at root level in package
All other files are in the db subdirectory
All files are in the txt subdirectory
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).

Windows
AS/400

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

AFC SaaS
Pro

EZTaxWS_docs_v9_YYMM.zip
EZTaxWS_sau_docs_v9_YYMM.zip

All files are in the txt subdirectory
All files are in the txt subdirectory

Compre he nsi ve G uide

to R epor ts

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/Brazil) or 6 digit Canadian zip code range for
that City.

File Format and Sample
all_adr.txt File Format and Sample
File Name
File Format
Sample Data

all_adr.txt
Comma delimited
Sample

Column
PCode
Alternate

Country
State
County
City
Zip Begin
Zip End

Description
Numeric persisted code for tax jurisdiction
Flag indicating if the address is an alternate address
Alternate
DESCRIPTION
0

Primary Tax Jurisdiction

Alternate Tax Jurisdiction

Country ISO (3 bytes)
State Abbreviation (2 bytes)
County Name
City or Locality Name
Start of the zip code range
End of the zip code range

Compre he nsi ve G uide

to R epor ts

File Availability and Location
all_adr.txt File Availability and Location
Product
AFC License

Platform/Package
Unix
Windows
AS/400

Location in Installation/Download Package
all_adr.txt is in the db subdirectory
All files are in the txt subdirectory
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

AFC SaaS
Pro

EZTaxWS_docs_v9_YYMM.zip
EZTaxWS_sau_docs_v9_YYMM.zip

All files are in the txt subdirectory
All files are in the txt subdirectory

Compre he nsi ve G uide

to R epor ts

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
File Format
Sample
Data

CalculationType.txt
Comma delimited
Sample
DATA_TYPE_ID
DESCRIPTION

Numeric Value for Calculation Type
Please reference table provided below for Calculation Type descriptions.
Calculation Type
Rate
Fixed Amount
Per Minute
Per Access Line
Self-Taxing Rate (Cable)
Per Bracket
Fixed on Tier

Tax Applicability
Taxable Measure is multiplied by Rate
Fixed taxes represent a fixed tax that applies to the product being taxed.
Number of Minutes is multiplied by Rate
Number of Lines is multiplied by Rate
Taxable Measure is multiplied by Self-Taxing Rate
Number of Lines is multiplied by Rate based on tax bracket for line count
Sale Amount is multiplied by Rate based on tax tier for sale amount

File Availability and Location
calculationType.txt File Availability and Location
Product

Platform/Package

AFC License

Unix
Windows
AS/400

AFC SaaS
Standard

EZTaxWS_Std_docs_v9_1603.zip

AFC SaaS
Pro

EZTaxWS_docs_v9_YYMM.zip
EZTaxWS_sau_docs_v9_YYMM.zip

Location in Installation/Download Package
calculationType.txt is in the db subdirectory
All files are in the txt subdirectory
calculationType.txt is located in /eztax_db9. This is at the root
of the Integrated File System (IFS).
All files are in the txt subdirectory
All files are in the txt subdirectory

Compre he nsi ve G uide

to R epor ts

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
File Format
Sample Data

fipspcd.txt, pcdfips.txt
tab delimited with summary row at beginning of file
Sample
Column Name
Fips Code
PCode

Description
10 digit fips code
Numeric persisted code for tax jurisdiction

Column Name
PCode
Fips Code

Description
Numeric persisted code for tax jurisdiction
10 digit fips code

File Availability and Location
fipspcd.txt , pcdfips.txt File Availability and Location
Product

Platform/Package

AFC License

Unix
Windows
AS/400

AFC SaaS
Standard

EZTaxWS_Std_docs_v9_1603.zip

AFC SaaS
Pro

EZTaxWS_docs_v9_YYMM.zip
EZTaxWS_sau_docs_v9_YYMM.zip

Location in Installation/Download Package
fipspcd.txt and pcdfips.txt are in the db subdirectory
All files are in the txt subdirectory
fipspcd.txt and pcdfips.txt are located in /eztax_db9. This is at
the root of the Integrated File System (IFS).
All files are in the txt subdirectory
All files are in the txt subdirectory

Compre he nsi ve G uide

to R epor ts

NPANXX Cross Reference to PCode Files

npanxx7.txt
Description
AFC provides support for using the 6 digit North America Numbering Plan Area – Local Exchange (NPANXX) code to define the taxing jurisdiction.
As a convenience, the NPA-NXX lookup and cross-reference table supports country codes for the NPANXX value. Refer to {Appendix A} for more information on country codes.

File Format and Sample
npanxx7.txt File Format and Sample
File Name
File Format
Sample Data

npanxx7.txt
comma delimited
Sample
Column Name
NPANXX

Description
6 digit NPA-NXX value
Also supports numeric country code (values 0 – 999)
Numeric persisted code for tax jurisdiction

PCode

File Availability and Location
npanxx7.txt File Availability and Location
Product
AFC License

Platform/Package
Unix

Location in Installation/Download Package
Npanxx7.txt is at root level in package
All other files are in the db subdirectory
All files are in the txt subdirectory
Npanxx7.txt is located in /eztax_db9. This is at the root of the
Integrated File System (IFS).

Windows
AS/400

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

AFC SaaS
Pro

EZTaxWS_docs_v9_YYMM.zip
EZTaxWS_sau_docs_v9_YYMM.zip

All files are in the txt subdirectory
All files are in the txt subdirectory

Compre he nsi ve G uide

to R epor ts

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.

File Format and Sample
transerv.txt and transervdesc.txt , transervsau.txt and transervdescsau.txt File Format and Sample
File Name
File Format
Sample Data

Telecom Filename: transerv.txt and transervdesc.txt
Sales and Use Filename: transervsau.txt and transervdescsau.txt
comma delimited – column size is fixed
Sample
Column Name
Alternate

Description
Indicates whether the t/s pair is an alternate name for an existing t/s pair
Alternate
DESCRIPTION
Blank
A

Market
Market Name
Trans Type
Trans Desc
Service Type
Service Desc
Long Description

Primary T/S Pair
Alternate T/S Pair

Numeric Market Id
Description of Market
Numeric Transaction Type
Description of Transaction Value
Numeric Service Type
Description of Service Value
Additional field provided in the transervdesc.txt and transervdescsau.txt – represents a description of
the application for the t/s pair.

File Availability and Location
transerv.txt and transervdesc.txt , transervsau.txt and transervdescsau.txt File Availability and Location
Product
AFC License

Platform/Package

Location in Installation/Download Package

Unix
transerv.txt, transervdesc.txt, transervsau.txt and
transervdescsau.txt are in the db subdirectory.

Windows
AS/400

All files are in the txt subdirectory
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).
Compre he nsi ve G uide

to R epor ts

transerv.txt and transervdesc.txt , transervsau.txt and transervdescsau.txt File Availability and Location
Product

Platform/Package

AFC SaaS
Standard

EZTaxWS_Std_docs_v9_1603.zip

AFC SaaS
Pro

EZTaxWS_docs_v9_YYMM.zip
EZTaxWS_sau_docs_v9_YYMM.zip

Location in Installation/Download Package
All files are in the txt subdirectory
All files are in the txt subdirectory

Further information
Please contact communicationsupport@avalara.com with any questions or if additional assistance is
needed in accessing information files.

Compre he nsi ve G uide

to R epor ts

Appendix A – Supported Country Codes
In tax calculation calls, Avalara recommends that you use the 3-byte ISO (International Organization for
Standardization) code for Country. The 3-byte ISO is required for exclusion lists.
Name
ANDORRA
ANTIGUA
ARGENTINA
AUSTRALIA
AUSTRIA
AZERBAIJAN
BAHAMAS
BAHRAIN
BARBADOS
BELGIUM
BELIZE
BERMUDA
BOLIVIA
BOSNIA AND HERZEGOVINA
BULGARIA
CAMBODIA
CANADA
CAYMAN ISLANDS
CHILE
CHINA
COLOMBIA
COSTA RICA
CROATIA
CURACAO
CYPRUS
CZECH REPUBLIC
DENMARK
DOMINICA
DOMINICAN REPUBLIC
ECUADOR
EGYPT
EL SALVADOR
ESTONIA
FIJI
FINLAND

3-Byte
ISO Code
AND
ATG
ARG
AUS
AUT
AZE
BHS
BHR
BRB
BEL
BLZ
BMU
BOL
BIH
BGR
KHM
CAN
CYM
CHL
CHN
COL
CRI
HRV
CUW
CYP
CZE
DNK
DMA
DOM
ECU
EGY
SLV
EST
FJI
FIN

2-Byte
ISO Code
AD
AG
AR
AU
AT
AZ
BS
BH
BB
BE
BZ
BM
BO
BA
BG
KH
CA
KY
CL
CN
CO
CR
HR
CW
CY
CZ
DK
DM
DO
EC
EG
SV
EE
FJ
FI

Compre he nsi ve G uide

PCode
5510000
5250000
4481300
4481400
4481500
4481600
5420000
5450000
4481700
4481800
5240000
5180000
4481900
5380000
4482000
4482100
4482200
5520000
5350000
5101400
5101500
5101600
5101700
5540000
5101800
5101900
5102000
5270000
5280000
5102100
5410000
5290000
5102200
5105400
5105500
to R epor ts

Name
FRANCE
GERMANY
GHANA
GREECE
GRENADA
GUATEMALA
GUYANA
HONDURAS
HUNGARY
ICELAND
INDIA
INDONESIA
IRELAND
ISRAEL
ITALY
JAMAICA
JAPAN
KENYA
KUWAIT
LATVIA
LEBANON
LITHUANIA
LUXEMBOURG
MALAYSIA
MAURITIUS
MEXICO
MOROCCO
NAMIBIA
NETHERLANDS
NEW ZEALAND
NICARAGUA
NIGERIA
NORWAY
OMAN
PANAMA
PAPUA NEW GUINEA
PARAGUAY
PERU
PHILIPPINES
POLAND

3-Byte
ISO Code
FRA
DEU
GHA
GRC
GRD
GTM
GUY
HND
HUN
ISL
IND
IDN
IRL
ISR
ITA
JAM
JPN
KEN
KWT
LVA
LBN
LTU
LUX
MYS
MUS
MEX
MAR
NAM
NLD
NZL
NIC
NGA
NOR
OMN
PAN
PNG
PRY
PER
PHL
POL

2-Byte
ISO Code
FR
DE
GH
GR
GD
GT
GY
HN
HU
IS
IN
ID
IE
IL
IT
JM
JP
KE
KW
LV
LB
LT
LU
MY
MU
MX
MA
NA
NL
NZ
NI
NG
NO
OM
PA
PG
PY
PE
PH
PL

Compre he nsi ve G uide

PCode
5105600
5105700
5105800
5127400
5300000
5310000
5320000
5108500
5108600
5138400
5148400
5108700
5108800
5370000
5108900
5330000
5109000
5109100
5460000
5109200
5390000
5109300
5109400
5210000
5113200
5113300
5113400
5113500
5113600
5113700
5340000
5158400
5114500
5470000
5115300
5115400
5530000
5115500
5360000
5115600
to R epor ts

Name
PORTUGAL
QATAR
REPUBLIC OF MALTA
REUNION ISLAND
ROMANIA
RUSSIA
SAUDI ARABIA
SERBIA
SINGAPORE
SLOVAK REPUBLIC
SLOVENIA
SOUTH AFRICA
SOUTH KOREA
SPAIN
ST KITTS AND NEVIS
ST VINCENT
SWEDEN
SWITZERLAND
TAIWAN
TANZANIA
THAILAND
TRINIDAD AND TOBAGO
TURKEY
UGANDA
UKRAINE
UNITED ARAB EMIRATES
UNITED KINGDOM
UNITED STATES OF AMERICA
UNSUPPORTED COUNTRY
URUGUAY
VENEZUELA
VIETNAM
ZAMBIA

3-Byte
ISO Code
PRT
QAT
MLT
REU
ROU
RUS
SAU
SRB
SGP
SVK
SVN
ZAF
KOR
ESP
KNA
VCT
SWE
CHE
TWN
TZA
THA
TTO
TUR
UGA
UKR
ARE
GBR
USA
UNS
URY
VEN
VNM
ZMB

2-Byte
ISO Code
PT
QA
MT
RE
RO
RU
SA
RS
SG
SK
SI
ZA
KR
ES
KN
VC
SE
CH
TW
TZ
TH
TT
TR
UG
UA
AE
GB
US
XX
UY
VE
VN
ZM

PCode
5115700
5480000
5200000
5220000
5123900
5124000
5490000
5400000
5124100
5178400
5124200
5124300
5168400
5124400
5230000
5260000
5124500
5124600
5124700
5124800
5124900
5125000
5125100
5125200
5125300
5500000
5125400
0
5190000
5125500
5127200
5127300
5105900

Below is the preferred Country and State abbreviation to be used for US Territories.
PCode
Name
5340001 AMERICAN SAMOA

Country and State Abbreviation
USA,AS

Compre he nsi ve G uide

to R epor ts

PCode
Name
5340002 FEDERATED STATES OF
MICRONESIA
5106100 GUAM
5340003 MARSHALL ISLANDS
5340004 NORTHERN MARIANA
ISLANDS
5340005 PALAU
5115900 PUERTO RICO
5340006 US VIRGIN ISLANDS

Country and State Abbreviation
USA,FM
USA,GU
USA,MH
USA,MP
USA,PW
USA,PR
USA,VI

Compre he nsi ve G uide

to R epor ts

Appendix B – Supported States, Territories and Provinces

USA States and Territories
ID Abbreviation

Name

Alabama

Alaska

Arizona

Arkansas

California

Colorado

Connecticut

Delaware

Washington, D.C.

Florida

Georgia

Hawaii

Idaho

Illinois

Indiana

Iowa

Kansas

Kentucky

Louisiana

Maine

Maryland

Massachusetts

Michigan

Minnesota

Mississippi

Missouri

Montana

Nebraska

Nevada

New Hampshire

New Jersey

New Mexico

New York

North Carolina

North Dakota

Compre he nsi ve G uide

to R epor ts

ID Abbreviation

Name

Ohio

Oklahoma

Oregon

Pennsylvania

Rhode Island

South Carolina

South Dakota

Tennessee

Texas

Utah

Vermont

Virginia

Washington

West Virginia

Wisconsin

Wyoming

Guam

Puerto Rico

American Samoa

Fed St of Micronesia

Marshall Islands

Northern Mariana Islands

Palau

US Virgin Islands

Canadian Provinces and Territories
Id

Abbv.

Name

Alberta

British Columbia

Manitoba

New Brunswick

NL or NF

Newfoundland

Northwest Territories

Nova Scotia

Ontario

Prince Edward Island

QC or PQ

Quebec

Saskatchewan
Compre he nsi ve G uide

to R epor ts

Abbv.

Name

Yukon Territory

Nunavut

Compre he nsi ve G uide

to R epor ts

Appendix C – 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
Date Method 0

Date Method 1

Description
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.
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.

Example
•

Reporting Scenario 1: Throughout the month
of January 2013, you submit several
transactions to the web service for taxation
at the time each sale occurs. The system will
generate the January 2013 compliance
reports on February 1st, 2013 for all the
transactions received in January, irrespective
of invoice date.
•
Reporting Scenario 2: Throughout the
month of January 2013, you submit
several transactions to the web service
for taxation with an invoice date of
January 2013. On February 1st, 2013,
the system will gather all transactions
with an invoice date of January 1st
through January 31st 2013 and
generate the compliance data.
•

Compre he nsi ve G uide

Reporting Scenario 3: You send a
transaction with an invoice date of
January 15th past February 1st when
AFC runs your compliance reports, this
transaction will never show up on any
report. You will need to submit a
request to our network services to
rerun your data for January in order to
capture January data sent past
February. Additional charges apply to
rerun, or provide subsequent
compliance reports for the month.
Alternatively, you may request your
compliance reports to be generated on
a specific day of the month in order to
give you enough time to complete
processing tax calculations for your
billing cycle. Please contact
communicationsupport@avalara.com in
order to set up these preferences.

to R epor ts

Method
Date Method 2

Description
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.

Compre he nsi ve G uide

Example
•

Reporting Scenario 4: Throughout the month
of January 2013, you submit several
transactions to the web service for taxation
at the time each sale occurs. Each
transaction must include the value 201301 in
the Optional10 field. The system will
generate the January 2013 compliance
reports on February 1st, 2013 and include
the taxes for all transactions with a 201301
value in the Optional10 field. It is important
to note that if you send transactions with
201301 in the optional10 field, after the
compliance report is run on February 1, they
will be provided in any compliance reports. In
this case, you should record the transaction
as 201302 or a future period for them to be
reported upon.

•

Reporting Scenario 5: On February 1st 2013,
you process a batch for all January 2013
transactions. Each transaction must have a
201301 value in the Optional10 field. You
should request your reports to be generated
on the 2nd day of the month beforehand.
The system will generate your January 2013
compliance reports on the 2nd day of the
month and include the taxes for all
transactions with a 201301 value in the
Optional10 field.

•

Reporting Scenario 6: On February 15th, you
process an adjustment for a transaction that
took place on January 15th 2013. The Date
field of the transaction must have the date of
the original transaction (January 15th) in
order to get the appropriate tax adjustments
back, but the Optional10 field of the
transaction must have a value of 201302
since the adjustment was handled during
February. The tax adjustment will be
included in your February 2013 compliance
reports.

to R epor ts

Appendix D – International NPANXX IDs
In tax calculation calls, Avalara recommends that you use the 3-byte ISO (International Organization for
Standardization) code for Country. The 3-byte ISO is required for exclusion lists.
NPANXX
Country ID

Country Name

3-Byte
ISO Code

2-Byte
ISO Code

Country
Code

PCode

ARGENTINA

ARG

4481300

AUSTRALIA

AUS

4481400

AUSTRIA

AUT

4481500

AZERBAIJAN

AZE

994

4481600

BARBADOS

BRB

809

4481700

BELGIUM

BEL

321

4481800

BOLIVIA

BOL

591

4481900

BULGARIA

BGR

359

4482000

CAMBODIA

KHM

855

4482100

CHINA

CHN

5101400

COLOMBIA

COL

5101500

COSTA RICA

CRI

506

5101600

CROATIA

HRV

385

5101700

CYPRUS

CYP

357

5101800

CZECH REPUBLIC

CZE

5101900

DENMARK

DNK

5102000

ECUADOR

ECU

592

5102100

ESTONIA

EST

372

5102200

FIJI

FJI

679

5105400

FINLAND

FIN

358

5105500

FRANCE

FRA

331

5105600

GERMANY

DEU

5105700

GHANA

GHA

233

5105800

ZAMBIA

ZMB

260

5105900

HONDURAS

HND

504

5108500

HUNGARY

HUN

5108600

INDONESIA

IDN

5108700

IRELAND

IRL

353

5108800

ITALY

ITA

5108900

JAPAN

JPN

5109000

KENYA

KEN

254

5109100

LATVIA

LVA

371

5109200

LITHUANIA

LTU

370

5109300

LUXEMBOURG

LUX

352

5109400

MAURITIUS

MUS

230

5113200

Compre he nsi ve G uide

to R epor ts

NPANXX
Country ID

Country Name

3-Byte
ISO Code

2-Byte
ISO Code

Country
Code

PCode

MEXICO

MEX

5113300

MOROCCO

MAR

212

5113400

NAMIBIA

NAM

264

5113500

NETHERLANDS

NLD

5113600

NEW ZEALAND

NZL

5113700

NORWAY

NOR

5114500

PANAMA

PAN

507

5115300

PAPUA NEW GUINEA

PNG

675

5115400

PERU

PER

5115500

POLAND

POL

5115600

PORTUGAL

PRT

351

5115700

ROMANIA

ROU

5123900

RUSSIA

RUS

5124000

SINGAPORE

SGP

5124100

SLOVENIA

SVN

386

5124200

SOUTH AFRICA

ZAF

5124300

SPAIN

ESP

349

5124400

SWEDEN

SWE

5124500

SWITZERLAND

CHE

5124600

TAIWAN

TWN

886

5124700

TANZANIA

TZA

255

5124800

THAILAND

THA

5124900

TURKEY

TUR

5125100

UGANDA

UGA

256

5125200

UKRAINE

UKR

380

5125300

UNITED KINGDOM

GBR

5125400

URUGUAY

URY

598

5125500

VENEZUELA

VEN

5127200

VIETNAM

VNM

5127300

GREECE

GRC

5127400

ICELAND

ISL

352

5138400

INDIA

IND

356

5148400

NIGERIA

NGA

566

5158400

SOUTH KOREA

KOR

410

5168400

SLOVAK REPUBLIC

SVK

703

5178400

UNSUPPORTED COUNTRY

UNS

5190000

REPUBLIC OF MALTA

MLT

356

5200000

MALAYSIA

MYS

5210000

REUNION ISLAND

REU

690

5220000

ST KITTS AND NEVIS

KNA

659

5230000

Compre he nsi ve G uide

to R epor ts

NPANXX
Country ID

Country Name

3-Byte
ISO Code

2-Byte
ISO Code

Country
Code

PCode

ANTIGUA

ATG

268

5250000

BELIZE

BLZ

501

5240000

DOMINICA

DMA

809

5270000

DOMINICAN REPUBLIC

DOM

809

5280000

EL SALVADOR

SLV

503

5290000

GRENADA

GRD

809

5300000

GUATEMALA

GTM

502

5310000

GUYANA

GUY

592

5320000

JAMAICA

JAM

809

5330000

NICARAGUA

NIC

505

5340000

ST VINCENT

VCT

809

5260000

CHILE

CHL

5350000

PHILIPPINES

PHL

5360000

100

ISRAEL

ISR

972

5370000

101

BOSNIA AND HERZEGOVINA

BIH

387

5380000

102

LEBANON

LBN

961

5390000

103

SERBIA

SRB

381

5400000

104

EGYPT

EGY

5410000

105

BAHAMAS

BHS

124

5420000

106

BRAZIL

BRA

5430000

107

SENEGAL

SEN

686

5440000

108

BAHRAIN

BHR

973

5450000

109

KUWAIT

KWT

965

5460000

110

OMAN

OMN

968

5470000

111

QATAR

QAT

974

5480000

112

SAUDI ARABIA

966

5490000

113

UNITED ARAB EMIRATES

ARE

971

5550000

114
115
116
117

ANDORRA
CAYMAN ISLANDS
PARAGUAY
CURACAO

AND
CYM
PRY
CUW

376
345
595
599

5510000
5520000
5530000
5540000

Compre he nsi ve G uide

KY
PY
CW

to R epor ts

Source Exif Data:

File Type                       : PDF
File Type Extension             : pdf
MIME Type                       : application/pdf
PDF Version                     : 1.6
Linearized                      : No
Author                          : Alicia Combs
Company                         : Avalara, Inc.
Create Date                     : 2018:11:21 10:41:28-05:00
Modify Date                     : 2018:11:21 10:45:55-05:00
Source Modified                 : D:20181121153645
Language                        : EN-US
Tagged PDF                      : Yes
XMP Toolkit                     : Adobe XMP Core 5.6-c015 91.163280, 2018/06/22-11:31:03
Metadata Date                   : 2018:11:21 10:45:55-05:00
Creator Tool                    : Acrobat PDFMaker 19 for Word
Document ID                     : uuid:874fa8db-a55d-4481-93e9-0e564bf0e427
Instance ID                     : uuid:d23c5c7a-fd32-4bbc-a6a4-43fe1e0991a3
Subject                         : 14
Format                          : application/pdf
Title                           : 
Creator                         : Alicia Combs
Producer                        : Adobe PDF Library 19.8.103
Page Layout                     : OneColumn
Page Count                      : 81

EXIF Metadata provided by EXIF.tools

TM 00561 AFC Comprehensive Guide To Reports And Data Files

TM_00561_AFC%20Comprehensive%20Guide%20to%20Reports%20and%20Data%20Files

Navigation menu

Versions of this User Manual:

Views

Navigation