How to do -> Journal, Balance sheet and Profit and Loss Sheet?

[Dr. Praveen Bhatia]

I am following these steps using Proteus:

1. I have excel sheet with journal entries in it (basically, sales, expenses, salaries, taxes paid etc). I use Python csv reader to read it into a dictionary. How do I transfer this to Journal entries by Proteus? How do I then get the .odt Journal report?
2. I can create company, fiscal year from the proteus examples shown in the source code of Tryton. 
3. How do I generate Balance sheet? I also could not locate any example and/or .odt file to report Balance sheet in source code.
4. How do I generate Profit and Loss sheet?   I also could not locate any example and/or .odt file to report Balance sheet in source code

Please guide how to do the above. Looks basic, but I could not locate any examples to help me. If there is an example in the source code or otherwise that could guide me, it would be a great help

[Sergi Almacellas Abellana]

Hi,

El 03/10/16 a les 10:26, Dr. Praveen Bhatia ha escrit:

> I am following these steps using Proteus:
>

> 1. I have excel sheet with journal entries in it (basically, sales,

> expenses, salaries, taxes paid etc). I use Python csv reader to read
> it into a dictionary. How do I transfer this to Journal entries by
> Proteus?

You will have to create the valid moves (account.move model) for the
journal entry and also their move lines (account.move.line model).

How do I then get the .odt Journal report?

> 2. I can create company, fiscal year from the proteus examples shown in

> the source code of Tryton.

> 3. How do I generate Balance sheet? I also could not locate any example

> and/or .odt file to report Balance sheet in source code.

> 4. How do I generate Profit and Loss sheet? I also could not locate

> any example and/or .odt file to report Balance sheet in source code

You can find the reports in the Account -> Reporting menu.

Hope it helps.
--
Sergi Almacellas Abellana
www.koolpi.com
Twitter: @pokoli_srk

[Dr. Praveen Bhatia]

How do I then get the .odt Journal report?
>  2. I can create company, fiscal year from the proteus examples shown in
>     the source code of Tryton.
>  3. How do I generate Balance sheet? I also could not locate any example
>     and/or .odt file to report Balance sheet in source code.
>  4. How do I generate Profit and Loss sheet?   I also could not locate
>     any example and/or .odt file to report Balance sheet in source code

You can find the reports in the Account -> Reporting menu.

Hope it helps.
--

I don't seem to have Account menu but their is Financial menu. Are they both the same? 

In the Finance->Reporting menu I see :

General ledger (Has report button selectable : General ledger/Trial Balance)

Balance Sheet

Income Statement

Aged balance

journals Cash

journals Periods

Print General Journal

Only the General ledger menu has "get report" button selectable with two options General ledger/Trial Balance which open up in Libreoffice document. 

All the others dont have any report which can be seen in Libreoffice. How can I get these reports in .odt or Libreoffice? For example Balance Sheet, and Income statement, I can see the rows, but I can get .odt/libreoffice document out of it.

[Dr. Praveen Bhatia]

On Monday, October 3, 2016 at 7:50:24 PM UTC+9, Sergi Almacellas Abellana wrote:

Hi,

El 03/10/16 a les 10:26, Dr. Praveen Bhatia ha escrit:
> I am following these steps using Proteus:
>
>  1. I have excel sheet with journal entries in it (basically, sales,
>     expenses, salaries, taxes paid etc). I use Python csv reader to read
>     it into a dictionary. How do I transfer this to Journal entries by
>     Proteus?

You will have to create the valid moves (account.move model) for the
journal entry and also their move lines (account.move.line model).

 

I am a bit confused here. 

Every transaction needs two accounts. 

Excel sheet entries are essentially transactions. 

Where and how do I transfer these transcations? Is it class trytond.transaction.Transaction 

 

to which I transfer these data first? It seems to say something of database so I am further confused how this can store this transaction. 

Then for each Entry in transaction transfer them to each of the accounts? Is account.move used for that? 

[Nicolas Évrard]

* Dr. Praveen Bhatia [2016-10-03 14:22 +0200]:

>
>
>On Monday, October 3, 2016 at 7:50:24 PM UTC+9, Sergi Almacellas Abellana
>wrote:
>>
>> Hi,
>>
>> El 03/10/16 a les 10:26, Dr. Praveen Bhatia ha escrit:
>> > I am following these steps using Proteus:
>> >
>> > 1. I have excel sheet with journal entries in it (basically, sales,
>> > expenses, salaries, taxes paid etc). I use Python csv reader to read
>> > it into a dictionary. How do I transfer this to Journal entries by
>> > Proteus?
>>
>> You will have to create the valid moves (account.move model) for the
>> journal entry and also their move lines (account.move.line model).
>>
>>
>>
>
>I am a bit confused here.
>Every transaction needs two accounts.
>Excel sheet entries are essentially transactions.

>Where and how do I transfer these transcations? Is it *class *
>trytond.transaction.Transaction

In fact this class is the one handling the database level
transactions. It's a low-level concept not at all the (financial)
transactions you're talking about.

>Then for each Entry in transaction transfer them to each of the accounts?
>Is account.move used for that?

Yes you should go to "Financial > Entries > Account Moves" and enter
your accounting movements there.

On the technical side, the form you will see by activating this menu
item is related to the account.move and account.move.line models of
Tryton … That's the name of the models you will have to use in
proteus.

--
Nicolas Évrard - B2CK SPRL
E-mail/Jabber: nicolas...@b2ck.com
Tel: +32 472 54 46 59
Website: http://www.b2ck.com/

[Sergi Almacellas Abellana]

El 03/10/16 a les 14:01, Dr. Praveen Bhatia ha escrit:

> All the others dont have any report which can be seen in Libreoffice.
> How can I get these reports in .odt or Libreoffice? For example Balance
> Sheet, and Income statement, I can see the rows, but I can get
> .odt/libreoffice document out of it.

You can export them with the export option of the tryton client to a csv
file, which can be opened with Libreoffice calc.

[Dr. Praveen Bhatia]

> How can I get these reports in .odt or Libreoffice? For example Balance
> Sheet, and Income statement, I can see the rows, but I can get
> .odt/libreoffice document out of it.
You can export them with the export option of the tryton client to a csv
file, which can be opened with Libreoffice calc.

Thank you. I could make decent progress. I have reached till here:

1. All the excel data of financial transactions are now moved into Journals and Accounts as expense/revenue etc
2. Created fiscal years 2008,2009,...... 2017 with each fiscal year having 12 monthly periods
3. All the transactions are moved with the move.period set to the corresponding fiscalyear->period (based on year and month of transaction)
4.  I need General Ledger reports/Balance Sheet/Income Statements of each fiscal year separately. ie. for 2008, separate from 2009 etc. ...... down to 2016 and 2017 separate
   
5. In the Financial ->Reporting-> Balance Sheet or Income Statement I only get to see 2016 Fiscal year and find no way to see another year or choose fiscal years. I am also not clear if what I am seeing is only the 2016 fiscal year or is it showing for the all the years combined and will not allow separation

Can you please guide me how to achieve separate fiscal year reports? Am I doing something wrong in entering data or in checking the Reporting menu's fiscal years?

 

[Sergi Almacellas Abellana]

El 05/10/16 a les 03:24, Dr. Praveen Bhatia ha escrit:
> 5. In the Financial ->Reporting-> Balance Sheet or Income Statement I

> only get to see 2016 Fiscal year and find no way to see another year
> or choose fiscal years. I am also not clear if what I am seeing is
> only the 2016 fiscal year or is it showing for the all the years
> combined and will not allow separation
>
> Can you please guide me how to achieve separate fiscal year reports? Am
> I doing something wrong in entering data or in checking the Reporting
> menu's fiscal years?
>

For the income statement:

By default the data for the current fiscalyear is shown, but you can
modify the context screen (which is shown above of the filter widget) in
order to show other fiscalyears. You should enter the fiscalyear you
want to see there and use the refresh button to refresh the data.

On the balance sheet, you should modify the date in order to see the
information for previous fiscal years.

Hope it helps.

[Cédric Krier]

On 2016-10-04 18:24, Dr. Praveen Bhatia wrote:
> 5. In the Financial ->Reporting-> Balance Sheet or Income Statement I

> only get to see 2016 Fiscal year and find no way to see another year or
> choose fiscal years. I am also not clear if what I am seeing is only the
> 2016 fiscal year or is it showing for the all the years combined and will
> not allow separation
>
> Can you please guide me how to achieve separate fiscal year reports? Am I
> doing something wrong in entering data or in checking the Reporting menu's
> fiscal years?

Balance sheet is date based and it always sums all previous fiscal year.
So if you want to have them separately, you have to close each fiscal
year by balancing the account non-deferral.

The Income Statement is based on the fiscal year and it is set on the
top of the tab.

--
Cédric Krier - B2CK SPRL
Email/Jabber: cedric...@b2ck.com

[Dr. Praveen Bhatia]

>
> Can you please guide me how to achieve separate fiscal year reports? Am I
> doing something wrong in entering data or in checking the Reporting menu's
> fiscal years?

Balance sheet is date based and it always sums all previous fiscal year.
So if you want to have them separately, you have to close each fiscal
year by balancing the account non-deferral.

The Income Statement is based on the fiscal year and it is set on the
top of the tab.

--
Cédric Krier - B2CK SPRL
Email/Jabber: cedric...@b2ck.com
Tel: +32 472 54 46 59
Website: http://www.b2ck.com/

I see. Thanks! Understood now. 

[Dr. Praveen Bhatia]

For the income statement:

By default the data for the current fiscalyear is shown, but you can
modify the context screen (which is shown above of the filter widget) in
order to show other fiscalyears. You should enter the fiscalyear you
want to see there and use the refresh button to refresh the data.

On the balance sheet, you should modify the date in order to see the
information for previous fiscal years.

Hope it helps.

--
Sergi Almacellas Abellana

Thanks Got it!

Is there a proteus way of doing it? I mean by proteus output a csv file for the different fiscal years -> saved on the computer.  

[Sergi Almacellas Abellana]

El 05/10/16 a les 10:52, Dr. Praveen Bhatia ha escrit:

> Is there a proteus way of doing it? I mean by proteus output a csv file
> for the different fiscal years -> saved on the computer.

As usual, you can use the export functionality of the client to save the
csv file on your computer.

If you want to do it via proteus, you should set the correct context
when browsing the model records and use the python csv functionality to
save them into csv files.

[Dr. Praveen Bhatia]

Balance sheet is date based and it always sums all previous fiscal year.
So if you want to have them separately, you have to close each fiscal
year by balancing the account non-deferral.

The Income Statement is based on the fiscal year and it is set on the
top of the tab.

--
Cédric Krier - B2CK SPRL

 Is this the correct way to close a fiscal year in proteus?

fiscalyear.state = 'close'

or will this spoil something ? And something needs to be executed before that?

 

[Cédric Krier]

On 2016-10-05 02:31, Dr. Praveen Bhatia wrote:
> > Balance sheet is date based and it always sums all previous fiscal year.
> > So if you want to have them separately, you have to close each fiscal
> > year by balancing the account non-deferral.
> >
> > The Income Statement is based on the fiscal year and it is set on the
> > top of the tab.
> >

> > Is this the correct way to close a fiscal year in proteus?
> fiscalyear.state = 'close'
> or will this spoil something ? And something needs to be executed before
> that?

You can not write the state on fiscal year like that. There are
procedure. You should first use the *client* before automate action
using proteus. There is a wizard for closing but before that you have to
balance the non-deferral accounts (and probably some tax revenue
allocation etc.)

By the way, proteus does not enforce good usage for example readonly
field are not enforced.

--
Cédric Krier - B2CK SPRL