• Registered: 06/03/2008
  • Posts: 2

Topic: import opening balance from external source

hello,

currently i'm importing all data from my ancient C based system to front accounting
i have no problem saving all GL transactions
i do however face some problem when importing opening balance
i'm curious, how and where does front accounting store opening balance
is it as a gl transaction dated the first day of every fiscal years in 0_gl_trans table?

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,106

Re: import opening balance from external source

Hello,

No it is not. The transactions are stored just as it is. If you which to see an opening balance of an account, you just make an accumulate of transactions up to a certain date.
So if you are importing OB from an external system, you would do that in a date 1 prior to the fiscal year you are starting. F.i. you start the fiscal year of 01.01.2008. You make the initial balance with a balanced journal entry from 12.31.2007.
We do not have any special tables for periods or year balances. This way you are free to select your own periods by selecting your period in balance sheets and income sheets.

/Joe