Requirements:

  • Firm Computer
  • Access to W: drive


This process outlines the correct usage of the new Trial Balance Importer Tool. This is found in the S&H Network drive “W:” – see below for screenshot.

Instructions

  1. Drag the CaseWare “.FT” export file into the “In” folder. A script runs approximately every 5 minutes to convert these files into “.XLSX” files to import to GoTax. 
  2. Navigate to the “Out” folder and wait for the file to be processed. Upon processing, the file in the “In” folder will be deleted and the processed file will be in the “Out”.
  3. Move this file from the “Out” folder to a local folder. Use this file to import to the new GoTax locators.


Troubleshooting & Things to Remember 

  • If the Prior Year balances in the import all equal zero, the script will still run but will name the file “Client Code-PY-0”
  • In the case of the script failing, a “.TXT” file will be created in the “Failure” folder. Review these files and make corrections accordingly.
  • If unable to fix issues, take to GoTax champions first and they can direct questions to IT if necessary.
  • All files in each folder will be deleted after 24 hours to keep the drive cleaned up.
  • The current year Tax Export codes must be downloaded for this script to run properly. These can be found in the Company Portal.
  • Always briefly review the excel output file to make sure income matches up with expected values in the CaseWare FTB report.
  • Do not set CaseWare to directly export or GoTax directly import from these folders. Continue to use the same process and keep files locally in between steps. This script is exclusively meant to convert file type and format, not to be used as a location for other programs to interact with files.