Once you’ve successfully connected your system to CereTax, transactions you’ve processed from your system can be located under Transactions > Sales. The transactions screen can be further customized to add or remove columns of data by right-clicking any where on the header row, then selecting Column. The available data columns can then be selected or de-selected for your needs. Along the bottom of the screen are additional navigation items, including Refresh and Filter.
Every transaction processed through CereTax is assigned a unique KSUID. The value in the KSUID field is automatically generated by CereTax and cannot be customized. If the System Trace Audit Number was not provided from your system, the value will be the same as the KSUID field.
Transactions that are processed numerous times will result in multiple transactions with the same Invoice Number and can be differentiated by the unique KSUID. There could also be multiple transactions in different statuses. (Please see section Transaction Statuses below for more information.) The value in the Status column should be used to determine the status of the transaction.
Searching for Transactions
To quickly search for a specific transaction, the filter function on the header row or filter icon at the bottom of the screen can be used to search for or refine the data you want to view:
Right-click anywhere on the header row and select Filter, or select the Filter icon from the bottom of your screen
Select Add Filter
Report Field – Select the search criteria
Condition – Available values depend on what is selected in the Report Field
Value – Dependent on previously selected values
If required, additional filter parameters can be added to further refine your search by selecting Add Filter again
Select Confirm to save changes
In these examples:
This filter will return Invoice Number INV-004
This filter will return any invoice(s) with Customer Account “Hello”
This filter will return transactions from September 2024 where the calculated invoice total was greater than or equal to $100
Transaction Navigation and Troubleshooting
Once the transaction(s) you would like to view has been found, the lines of the transaction can be viewed by clicking on the arrow on the right-hand side of the transaction row. The line header row can also be customized by right-clicking on the line header row and selecting columns. CereTax recommends including columns Transaction Charges Calc Base and Transaction Charges Tax as Shipping values can be found in these columns.
Using the arrow on each line, additional details can be viewed by clicking on each icon along the left-hand side of the screen. For troubleshooting purposes, we recommend reviewing these details if you are not receiving the expected tax amounts.
Tax
Provides detailed information on tax calculation including jurisdictions and rates applied
Rules
Lists the rules that applied to that line
If a rule was created but does not appear on this list as expected, check that your Rule Type was set up correctly, the Rule Level may need to be changed
If the rule appears on the list but did not return the desired tax amount, check that your rule’s criteria and actions are set up correctly, or “Sync Rules” again if rules were not already synced after initial set up
Global Sales Internal Field and TaxOnTaxMax are default internal values
Situs
List the address(es) used for calculation
Attributes
List the attributes that were included for calculation
Refer to the Integrations page for guidance specific to your integration
If guidance for your integration is not available, or additional attributes need to be set up for your custom API connection, please contact support@ceretax.com for next steps
Exemptions
Provides jurisdiction and tax type exempted for exemptions applied
Exemptions can be sent from your system or managed in CereTax
If exemptions are being managed in CereTax, the Rules icon will show any exemption rules that were applied
The lines can be minimized by clicking on the arrow(s) again. To clear your filtered results or to conduct another search, right-click anywhere on the header row and select Filter or select the Filter icon from the bottom of your screen to change your values or delete the filter rows using the trash can icon.
Transaction Statuses
The transaction statuses you see within CereTax are typically initiated from your system. Status changes made in CereTax will not affect or update the transaction in your system. For best practices, we recommend processing changes or updates in your system; this will allow CereTax to be automatically updated with the appropriate transaction information and status.
Transactions can be in one of the following statuses:
Once a transaction has been created in CereTax, it can either be in an Active or Quote status, depending on your integration or how your API connection is customized
Quote
Quote transactions are for the purpose of estimating tax only
These transactions are temporary, the status cannot be updated or changed
Once the Quote is finalized in your system, a new transaction is created in CereTax with a Posted status
Transactions processed with the Tax Calculator will be appear in this status
Active
The details of the transaction have not been finalized
Once details are finalized, the status is automatically updated to Posted
Posted
Details of the transaction has been finalized
Suspended
The transaction in your system was either voided, cancelled, or deleted
Pending
The transaction contained one or more line-item issues that must be resolved before the transaction can be re-processed
If the transaction was created from your system, refer to the CereTax logs for additional information
If the transaction was manually imported into CereTax, refer to the system generated error file under Transactions > Import Transactions
Once the errors are resolved and re-processed, a new transaction will be created
Pending status transactions are not temporary and will remain in your CereTax account
Transaction statuses can be updated by checking the box on the left-hand side of the row. A menu will appear with an option to “Update Status” or “Reverse.” The actions not allowed for the transaction, depending on its status, will be greyed out.
