• Registered: 03/29/2017
  • Posts: 2

Topic: import trial balance

respected sir,
i am new in this area. i wants to transfer from my previous software to FA.
but i have some trouble. i wants to know how to import my previous TRIAL BALANCE to (all accounts balance) to FA. with csv file?
thanks a lot

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: import trial balance

If there are only a few entries, manually enter a JV on the last day of the previous fiscal period and open the new fiscal and close the old one.

Otherwise, make one entry in a JV on the last day of the of the previous fiscal period and compare the before and after backups for what has changed and prepare a set of SQL statements for all the others in a spreadsheet and execute them in your MySQL client.

apmuthu's Website

  • Registered: 03/29/2017
  • Posts: 2

Re: import trial balance

Thanks sir, i try to solve my problem as per your instructions. lot of thanks.