-
-
-
Give the report a name.
Set the Primary Sort field to Jurisdiction.
Press the expansion button (blue arrow) next to the Primary Sort field to open the DZ Report Section Options window.
Set the Section 2 field to None. NOTE: Leave the Section 1 field equal to Jurisdiction.
Press the OK button to save and close the DZ Report Section Options window.
On the DZ Report Options window select the checkbox for Print Column Headings.
Enter and insert a State Range of from CA to CA.
Enter and insert the appropriate date range for your return.
Press the Destination button to open the DZ Report Destination window.
Set the Save In field to an appropriate file path and name. IMPORTANT: The file name must contain a file type extension. We recommend using .csv for comma delimited files.
Set the File Format field to Comma - delimited.
Press the OK button to save and close the DZ Report Destination window.
-
Press the Save button to save the report for later use.
Close the DZ Report Options window.
Open the printed report using Excel or some other spreadsheet software.
Add a column for State Tax (= the Taxable column * current state tax rate (ie.06)).
Add a column for County Tax (= the Taxable column * current county tax rate (ie.0025)).
Add a column for Combined State and Local Tax (= the Taxable column * current combined rate (ie.01)).
Add a column for District Tax (= the Tax column - (State Tax column + County Tax column + Combined State and Local Tax column)).
Add a row at the bottom that contains the sum for each column.
The sum amounts at the bottom should provide the values needed on the first page of the return. The District Tax column should provide the values for filling out the district tax section of the return.