Transcription of How to Generate a Year-To-Date Trial Balance File …
1 How to Generate a Year-To-Date Trial Balance File in microsoft dynamics GP All Trial Balance (TB) data must be submitted in Year-To-Date format (YTD). A YTD file contains the balances of each account from the beginning of the fiscal year through the last day of the period for which you will report data (as opposed to a period activity file which only shows the account balances for a given month or quarter). For instance, if your company has a December 31 year-end the first day of your fiscal year is January 1 and all YTD TB reports will contain data from that point. The steps for generating a YTD TB file in microsoft dynamics GP follow: Go to Report >> Financial >> trail Balance Select Default from 'Option' and click on 'Modify' Set reports filters Click on Destination Check on File and set export path In file format, select 'Tab-Delimited'/'Comma Delimited' Click here to watch a video demonstration.
