Synexus Sales Tax Export

Prev Next

The Synexus Sales Tax Export exports sales tax data from R365 into a .csv file, which can then be uploaded to Synexus for processing. 


Navigation

To navigate to the Synexus Sales Tax Export, first open the Reports page clicking 'My Reports' from under 'Reports' in the left navigation menu. 

Click the 'Financial' tab, then locate the Synexus Sales Tax Export.


Report Parameters

       
  1.        

    Filter By - A Listing of all Location categories

       
  2.    
  3.        

    Filter - A listing of all Locations associated with the selected Location category 

       
  4.    
  5.        

    Start Date - The beginning date for the report 

       
  6.    
  7.        

    End Date - The ending date for the report

       
  8.    
  9.        

    DSS Status - Whether to include information with DSS status of Approved, Unapproved, or both

       
  10.    
  11.        

    Invoice Status - Whether to include information with Invoice status of Approved, Unapproved or both

       
  12.    
  13.        

    Download - Click to download the Synexus Sales Tax information as a .csv file

       

Report Columns

       
  1.        

    Date - The day, month, and year associated of the data

       
  2.    
  3.        

    GrossSales - The Gross Sales dollar amount based on the DSS for this date

       
  4.    
  5.        

    TaxExemptSales - All Tax Exempt Sales or Sales in which the the Sales Category on the Sales Details has a category name like “Tax Exempt”

       
  6.    
  7.        

    TaxableSales - The dollar amount of Taxable Sales recorded this date

       
  8.    
  9.        

    ThirdPartySales - The dollar amount total of Third Party Sales. This column is made up of sales tied to a Sales Account Category of '3rd Party Delivery'

       
  10.    
  11.        

    SalesTaxCollected - The dollar amount total of Sales Tax collected on this date

       
  12.    
  13.        

    UseTax - All Use Tax details. This column will have information when the Invoice Detail is tied to a Vendor that has the 'Use Tax' checkbox checked

       
  14.    
  15.        

    LocationName - The Restaurant Location name

       
  16.    
  17.        

    LocationCity - The city of the Location

       
  18.    
  19.        

    LocationState - The state of the Location

       
  20.    
  21.        

    LocationZipCode - The Location's zip code