I have installed Tiny ERP 4.0.0-rc1 for a company which is already running and i am starting new financial year i have to enter all openings to the Tiny ERP please can help me how to enter all opening balances in . so that the chart of account of previous year reflect all debits and credits.

Hi George,
I installed just two days back only, when i am going thru the system, what i feel is, we can enter the opening balances thru journal code 'START' analytical journal.
Finalcial Management->Configuration->Jouranal->Analytic Journal Definition.

May be better option there... as I told you I stared examining it only two days ago.

regards,
Murali.

other idea: (4.1.1)
(if no analytic accounts are needed)

create a journal "Opening Balance" - same as "Bank Journal"
set both accounts to "opening account"

got to statements, select the "Opening Balance" journal and enter the balances of the accounts.

do not enter the any postings for the opening account - they will be generated automatically.

Attention: as it is a "Cash Journal"

* debit balances have to be entered as negative !! numbers. (cash out creates a debit posting on the other account)
* credit balances have to be entered as positive !! numbers.

click compute and confirm
that's it.

Fabien:?
If this is true
a) can this get into the demo data
b) shell I update the tutorial/documentation
c) can Tiny get statement view with debit/credit accounts (similar to "Real Entry"). This would be very useful for internal postings with no accounts are defined in the journal definition.

Problem: We are unable to transfer balances in the existing accounting software to Tiny Erp.

How do we input balances brought forward?

The date we started using Tiny Erp - 1/1/07

Example: Cash balance from 2006 = EUR 100

How do we declare that balance carry forward when we initialize tiny erp? We need the Cash Account Balance to start of with EUR 100.

An idea is to enter the (complete) balance with the closing date of the previous fiscal year.
The new fiscal year should start then with balances brought forward automatically.

sorry for being dumb but I'm no accountant and do not completely understand what you're saying ferdinand.

You propose to enter the complete balance. How can this be done? As I understand it, you close a period in the old system and get the balances for each account. You take this value and input it where in TinyERP?

Then you close the fiscal year in TinyERP. Closing asks you about a Journal, which one to take usually?

Then I have a look at the charts of accounts of the new fiscal year - all accounts are empty. Where can I find the opening balance?

I try to understand both the basic accountant issues and the way tiny is dealing with it. Can you please help me with some more explanations?

Thank you

knerz

well financial accounting in real life is a bit tricky

For setting up a balance and P&L statement a complete fiscal year is needed. For this reason we always switch to a new system or a new release when only ONE fiscal year is open.
It is much easier to handle migrations without having to respect balance deadlines.
Either enter the balance and & P&L statement or import all postings after closing a month of the "old" year.
Continue with accounting in the old year.
The new years opening balance should show the closing values of all accounts having "balance" as deferral method.

I didn't look deeply into Tiny if it handles this on a ongoing basis or if manual interaction is necessary.
AFAICS see "End of the year Treatments" - this creates the opening balance postings in "open journals" status draft.
didn't find where or how to change the status to done which is obviously necessary to view the postings in the chart of accounts.

ok. I made a sample purchase and sale and I paid the purchase. There are several entries about that in my general chart of accounts. These entries are all made in December 2007.

Now I adjust my system clock to January 2008. I close the period 'Dec 2007'. I create a new fiscal year 'FY2008'. I go to 'End of year treatment and click on 'Close a fiscal year'.
Fiscal Year to close: 'FY2007'
New fiscal Year: 'FY2008'
Create new entries: 'Yes' (don't know the meaning though)
Name of new entries: 'End of fiscal year entry' (default one)
New Entries Journal: 'FY2007' (newly created, type: 'Genereal', view: 'Journal view', Entry sequence: 'Voucher Entry sequence')
Check this box: 'Yes'

-> Close fiscal year

Now where do I find the 'new created' entries?

Any help/hint is very much appreciated. What are you guys doing at the end of the year if this is not working (or at least not understood)?

knerz

Did you check this ?

Checked it, the used Journal ('FY2007') is empty. I suppose these entries should appear in the period 'Jan 08', right?

A 'Financial Management' -> 'Entries' -> 'Search Entries' -> 'Entries' is showing only the above mentioned entries from Dec 2007, too.

any more help?

knerz

I just checked in v4.0.3. There the expected entries are created. In v4.2.0 it's not working. If you know better please tell me how to do it.

Bug tracke: http://tinyforge.org/tracker/index.php? ... 3&atid=129

knerz

This might be helpful:



from

http://tinyerp.org/wiki/index.php/TinyB ... Definition

I opened a feature request
http://tinyforge.org/tracker/?func=deta ... 3&atid=132

see also
http://tinyerp.org/forum/post16785.html#16785

It's about problems doing the closing fiscal year action with deferral method=balance with link to patch for v4.2.1

and the opening balance cookbook:
http://tinyerp.org/forum/post16794.html#16794