Friends, in this clip we will see how we can print the
reports that are generated.
I have opened case no. 2 in front of you.
The case no. 2 we did was provision for depreciation where
we did.
The same company is open, you can see, in the name of
provision for depreciation.
You open the same company in your teleprime once, provision
for depreciation value.
Okay, sir, we open it.
Now in this, the reports generated, how do we get their
printout?
They are going to learn, they are going to learn their
printout.
Okay, sir, we learn to printout.
Look, brother, for example, we have to printout the balance
sheet and profit and loss.
Learn any one, I will still teach you two, balance sheet
and P&L both.
If you learn any one, then you can printout any other
report.
You just have to learn them.
So I am pressing B for balance sheet once in front of you,
B for balance sheet.
And please detail it by pressing F1 with ALT and detail it.
Press F1 with ALT and detail it.
Do it detailed.
Okay, sir, we did it in detail.
Now what do you have to do?
Now you have to go to the top horizontal bar above my dear
friends.
Where it is written, company, data, exchange, go to,
import, export, email, print help.
All these things are written above the top horizontal bar.
From this, you have to go to the export button.
On the export button.
What is the word highlighted here?
E And there is an underline below E.
E word is highlighted.
And there is an underline below E.
What was the meaning of one underline in the beginning?
Remember.
10, 9, 8, 7, 6, 5, 4, 3, 2, 1.
E with ALT.
Yes, one underline means to press the key with ALT.
Below which one underline is visible.
So all the lovely children will press E with ALT.
As soon as you press E with ALT, many things have opened.
Let's read what things have opened.
Current, others, masters, transactions, configuration.
We have to go to the current.
Now we are learning to print.
We are not learning what is the use of all the commands in
this.
We are learning to print.
So we have to go to the current.
For current, you can see the highlighted word is R.
What is the highlighted word?
R So press R on the laptop.
R Press R on the laptop.
As soon as you press R on the laptop.
So you can see something like this will pop up.
Format of report detailed.
Show vertical.
Bank sheet no.
File format.
PDF.
Export to local drive.
Folder path etc.
File name balance sheet.
Now see friends, what is the thing to see here?
The thing to see here is that the PDF is written in front
of the file format.
But as soon as you press this button, R.
It is possible that the PDF is written in front of the file
format.
I am writing something like this.
Because I keep doing it in it.
That's why this PDF is already set here.
It may not be set here.
It may not be in 90% cases.
So there are two options in front of you for this.
Configure and send.
Send means it will be ready for its print.
But we do not have to get ready now.
Because we have to take it in our PDF format.
So we will press C for Configure.
The option of Configure is C.
Press C.
And friends.
This time press the downward arrow.
The four arrows in the laptop.
Press the downward arrow in them.
Do not come down by pressing enter here.
Come down by pressing downward.
And where do you reach?
Up to here.
Under export settings.
Reach the file format.
Reach the file format under export settings.
My dear friends.
Here you can see.
PDF is visible in my laptop.
I will press enter.
So many options will open.
If you were not getting PDF there.
XML was coming.
Something else was coming.
So press enter there once.
Press enter.
After pressing enter, you can see.
Friends.
ASCII comma delimited.
This file is useful to upload.
On some sites.
Like if we talk about ESIPF.
So when ESIPF is filled in the return.
So comma delimited.
The file that is generated by doing this.
It is uploaded there.
It has to be comma delimited.
This is for it.
You can also make JPEG image of it.
You can also take it in PDF.
You can also take a spreadsheet in Excel.
Which format you want to take.
I will show you in PDF.
Then I will show you in Excel.
Now select PDF.
All dear children here.
PDF.
Now, what will you need for JPEG image?
So take PDF.
After pressing enter.
And come to this screen.
With control.
Save the screen by pressing A.
Control plus A.
Save the screen.
Done.
Friends.
Now you have to press send.
And what is the left hand side of send?
E.
For elephant.
No.
He used to learn in childhood.
Now what is here?
E for send.
Sir, this is something different.
It is there.
What to do?
Press E.
And press Y after that.
Press E and press Y.
And you.
Loading.
And see.
PDF has been generated.
My God.
Sir.
Where was it generated?
It has been generated.
I will change the screen.
You will see it in the software.
Wait a minute.
I change the screen.
Look at this.
This came in the PDF.
Close it.
Balance sheet.
My God.
This is that balance sheet.
Yes.
This is that balance sheet.
Which is in printed out form.
You see and go.
On which he audits and signs.
Then click his photo.
It is uploaded on income tax.
Details.
Signature.
This is the balance sheet.
Look at your friends.
You used to make it by hand.
In the eleventh class.
In the twelfth class.
Enter here.
Make a balance sheet.
Take out its print.
Direct.
Just.
You can see this.
You can see the balance sheet.
Wow.
Yes.
This came in the PDF format.
Sir.
The diet print can also come out in the PDF.
If we want to do something about its change range.
Format in Excel.
Do it in Excel.
If you want to change the formatting.
So come on.
Let's come there.
Go back.
Stay here.
Let's do the PNL in Excel.
Press SK and come out and press P for PNL.
Man, we have nothing in PNL.
No fun.
Come back in the balance sheet.
All done.
Fine Sir.
What will we do now, friend?
This we will do in Excel.
Now do the same thing again.
We will do the same thing in Excel.
Do the same thing again.
Press E with ALT for export.
ALT plus E And press R for current.
R Press R
After that, C for configure.
And don't press ENTER.
Pressing downward arrow Go down to export settings file
format.
Go down to export settings file format.
Press ENTER here Select Excel Spreadsheet.
This time select Excel Spreadsheet.
And friends, it is very dangerous.
You can take this balance sheet by signing from here.
Now here is the option of digital signature.
But we will see later.
Now here is the option of digital signature.
So select Excel Spreadsheet here.
And save this box by CTRL A.
Yes sir, we have saved.
Now press E for send.
Now it is exporting to Excel.
It will take time to load.
Keep watching.
Let it load.
Excel file is open.
You have to change the software where you are recording.
You will have to change it. It will automatically open in
your laptop.
It has opened automatically in my laptop.
I have to change the screen to show you in my laptop.
Take this.
Take this, friends.
This has come in Excel.
Congratulations.
This has come in Excel.
Anyone can report like this.
Anyone can report like this, friends.
Any report.
Sir, do something else for us.
You come to teleprime.
Who is stopping you?
Press SK and come out.
Sir, we have to print out the print of machinery no.
2 account.
What will you do?
D for display, A for account books, L for ledger.
And machinery no.
2 account, open it.
Whatever report you want to print out, open it.
There was more data in 1. Let's open machinery 1 account.
Open machinery 1 account.
Press F2 with ALT.
Select the entire period in this.
1 January 23 to 31 December 24.
Select the entire period.
Now we have to print it out.
Press E with ALT.
R for correct.
C for configure.
Take PDF in file format.
Print comes out quickly from PDF.
You can also attach a digital signature here.
Press CTRL A.
E for send.
Press Y once.
E for send.
Press Y once.
E for send.
E for send. It's open. Here, I'll show you.
Here it is.
This is the PDF file.
What is all this PDF?
This is a game of left hand, left finger, left nail for
Tally.
This is nothing for Tally.
So he generates like this.
He says, just give the entry.
Everything will be ready.
Just give the entry.
Like catering at weddings.
Just give the order, give the money.
Everything will be done by himself.
Exactly like this.
Then 87 credit, 386 credit and 127 credit.
I bought it for 6 lakhs.
I sold the adoption in 386.
I bought it for 127. Everything is ready.
You can print out anyone.
You can do anything. Everything will be ready.
You can also take this in Excel.
Who said no?
Whatever you want to print, whatever you want to do.
Everything is your choice now.
I have told you how to do it.
You want to do Provision for Adoption Account 1.
Come here and do it.
DAL Provision for Adoption 1 Account
Alt F1
Alt F2 1 January 23 to December 24
Print it out.
Alt E, R for Current
C for Configure
PDF in PDF, Excel in Excel.
Whatever you want.
E for Send and that's it.
I refused to create a file.
There is some error in it.
I will take it in PDF.
If you get any error like this, he will not allow you to
convert.
Let me tell you one more way.
It is not happening.
There is some error right now.
Convert it to another file.
My dear friends, like they want to do in Excel, it is not
happening.
convert pdf to excel this method also works ok ok so
friends we will meet in next video till then thank you bye
bye take care