Hello friends, once again very warm welcomes to you all
Welcome to another beautiful lecture
and friends, all the practices we have done in previous
class
I believe you must have reviewed it and sat here
and today we will go to see with you
that the company in which we did all the work
profit and loss account, balance sheet
we made entries, TELI
poor TELI itself
made balance sheet, P&L, trial balance and gave us
so in that case
we have to export them in excel
so that we can adjust them from there
and can print it suitably according to us
or we have to export in pdf
because if we are working on income tax
or in case of audit
if we want to upload balance sheet in TELI
then it is uploaded in pdf format in income tax
so how we did TELI
those reports which TELI has made for us
whether it is trial balance, trading account, P&L account
or balance sheet or any other report
in excel or pdf
how we can convert them from TELI
we can export them
today's clip is going to teach us
so let's start
let's start
first of all, open the same company
ABC traders
yes sir, here it is
I have opened it
many times we close TELI and open
other company gets selected in bold
so I had another company open
so I pressed F3 with ALT
and selected this company ABC traders
because this has more work
this has balance sheet P&L
we don't have any other company
first of all, in B4 balance sheet
detail it by pressing F1 with ALT
and today we will see with you
how to export it
above, have you heard of top horizontal bar?
hmm
I am remembering sir
I am remembering
when you sent us the clip of screen specifications
so we saw
you told in it
that all these commands written above
y data
z exchange
goto g
o import
e export
m email
p print
f1 help
this bar is called top horizontal bar
you told us
I remembered
I said very good
now friends, here
in top horizontal bar
this option you can see
export
this is our work
and today we are going to learn a new command
like in export side
e is written
so if you press e
export will not work
under this
underline
it also has a meaning
it means
you have to press e with ALT button
in tele
anywhere
if you get single underline
on any command
so understand
you have to press ALT with it
so under e
underline means
you have to press ALT plus e
in many places
you can also see double underline
like here
in vertical button bar
see
basis of value
change view
exception report
save view
double underline
so if there is double underline
so you have to press CTRL with it
if there is single underline
so you have to press ALT
so for now
come to last page of your register
and write
where we were writing common commands
write there
number 1
single underline means
ALT
you have to press
number 2
double underline means
you have to press CTRL
with that particular command
ok sir
so now
with ALT
e
with ALT
e
options are open
which report you have to export
so we have
current report
balance sheet is opening
balance sheet
you have to export this
so for current
you have to press R
R is highlighted word
after this
friends
don't send it directly
first
C for configure
option is coming
press C for configure
and in this
come down from arrow
enter will not work
arrow
downward arrow
you have to come down
by pressing it
and in file format
by pressing enter
if it is excel
then excel
if you want to convert
in jpg
then jpg
and pdf
then pdf
if you want to export
in pdf
then pdf
whatever you can select
whatever you want
now friends
normally
it is selected on xml
may be
you are doing
so you are selected
on xml
I have done this
before
that's why
in my case
it was converted
in excel
but you
come here
and select on excel
press enter
and this screen
with CTRL
press A
and save
after that
for send
the command
press E
then your balance sheet
will be exported
in excel
without any delay
see
excel file
is opening
in front of you
now see
I have to change
the screen
and show you
how excel file
is opened
wait a bit
see
in this way
excel file
is opened
automatically
by pressing E
so you can see
your balance sheet
is exported
in excel
in this way
sir
we have
to export
any other report
in this way
or for example
export balance sheet
in pdf
and show
I said
take this
let's see
what's wrong
in seeing
this
it's not
costing money
it's not asking
money
see
convert a lot
see
what is
educational
mode
B for
balance sheet
ALT F1
press
E
with ALT
while pressing
ALT F1
press ENTER
and below
select pdf
then
press A
with CTRL
and for send
press E
so you would
find
that pdf
will be opened
let me show
how pdf
is opened
it will
pop up
automatically
on your
computer screen
it's on my
computer screen
but to show
I have to
change the screen
see
in this way
see
this is the
fun of
tele
so I am
taking tele
lightly
bro
tele is not
something light
tele is
so many
features
so don't
ask
sir
one more
P&L
and last
one last
you are
insisting
take this
one more
P&L
P for
P&L
ALT F1
press
press CTRL-A and press E to send
then your P&L will be open
it will come in Excel
if you want it in PDF, it will come in PDF
Sir, we want balance sheet P&L is fine but
export trial balance also
we want hard copy of trial balance
how can we take that in Excel?
for that you have to press ESC
D for display
after ESC, come here, outside
D for display
and T for trial balance
press
you want it in detail view
do detail view
press F1 with ALT
and here also
same thing
with ALT, E
R
C
drag down
file format select
then CTRL-A
CTRL-A and with E, send
means this is the way of any report
hold it right
this is the way to export any report in Excel, PDF, JPG
wherever you want to export the report, reach there
and start pressing these commands
ALT-E
R
CTRL-C
drag down
proper format select
CTRL-A
CTRL-A and E
means send
ok sir
ok sir, one more thing
it just came in my mind
which thing?
sir, suppose
we are doing a voucher entry
which one?
D for display
in D for day book
sir, pick this voucher entry
which has contra entry on top
9000
no, don't pick this
pick some sale entry
like this is sale entry of Rohan
here we sold goods to Rohan
wrist watch
3000
sir, we have to print out this
and give it to Rohan
he is asking for bill
and sir, if we print out this sheet from telly
and give it to Rohan
then this will work
our heading will come on top
party name, item, stock, amount, quantity, rate
everything is coming in this
sir, can we export this also?
in this way?
absolutely
you have put a very good idea
ALT-E
and see
R for current
press
C for configure
press
and below
see your file format
below
this is file format pdf
press A with CTRL
send with E
then you will get this also
in pdf format
this invoice
let me show you
what kind of invoice
has been popped up
with me
you can find out
see this
this kind of screen
see how good
your address has come
here
right
invoice number has come
date has come
party name has come
buyer name has come
quantity has come
rate, amount
everything has come
in this way
yes
in this way
we can get invoice printout
from tele
in this way
sir tele
is very useful
thing
absolutely
let's go back
to tele
prime
any report
you want to get
you can export it
in this way
you will start
writing notes
of this
quickly
please write
down the notes
how to export
tele reports
to excel
pdf
etc
put this heading
number 1 step
go to the report
whatever report
you want to print
go to that report
go to the report
number 2
press alt plus e
for export
press alt plus e
thereafter
what you have to do
press c for configure
no
press r
after that
yes
press r
after that
press c
export
press r
thereafter
c for configure
press c for configure
then
drag down
and select
the required format
drag down
and select
the required format
then press ctrl plus a
then press e
for send
press e
then your file will be exported in the desired format.
Okay Sir.
Okay Ji.