balance sheet format in excel

News

Invitation to contribute question bank for Information system audit


Announcement Invitation for contributions to Question Bank in respect of Information System Audit Assessment Test ISA AT New Syllabus Information Systems Audit is a post qualification course meant for the members of the Institute Members who are registered for the course are required to appear and p

ICSI achieves landmark of 50000 CS members


ICSI achieves landmark in its Pursuit of Professional Excellence reaches 50 000th CS Membership Mark Shri Arun Jaitley Honble Union Minister for Finance and Corporate Affairs awarding CS Membership certificate to the 50000th CS Member CS Ashutosh Shukla in the presence of CS Dr Shyam Agrawal Preside

CBDT signs 10 more Advance Pricing Agreements


Central Board of Direct Taxes CBDT signs ten 10 more Advance Pricing Agreements APAs pertaining to various sectors of the economy like Telecom Pharmaceutical Banking Finance Steel Retail and Information Technology etc With this the total number of APAs entered into by the CBDT reaches 140 The Centra

SPMCIL contributed to the world's biggest exercise of demonetisation


Honble Union Minister of Finance Sh Arun Jaitley gives away awards for excellence at the 11th Foundation Day celebrations of Security Printing and Minting Corporation of India Ltd SPMCIL SPMCIL contributed to the worlds biggest exercise of demonetisation SPMCIL is among the few government companies

Fee for delayed filing of income tax return


In view of the non intrusive information driven approach for improving tax compliance and effective utilization of information in tax administration it is important that the returns are filed within the due dates specified in section 139 1 Further the reduced time limits proposed for making of asses

More News



Experts Opinions

Accounting of cash credits in balance sheet?


An assessee availed a CC Limit of 15 lacs against mortgage of property Balance on 31st March in CC Account shows 13 5 lacs How much to show under Liability 1 5 lacs CC utilised to be shown under Liab Under which head Current Liability or Long Term Loans Does CC limit of 13 5 lacs UNUTILISED needs to

Excel formula - prepaid


can any one suggest me a formula to calculate the month on month prepaid amount to be charged off I already have the formula in start date of the expense date of booking of the bill is in same month Say for ex Rs 1 20 000 spend for 1 Apr 16 to 31 Mar 17 Means Rs 10 000 to be charged off every month

Tratement of mutual fund in individual balance sheet


DEAR SIR I HAVE INVESTMENT IN MUTUAL FUND 85000 RS MONTHLY FOR FINANCIAL YEAR 2015 16 SO I AM ASKING THIS INVESTMENT VALUE TREATEMENT IN MY BALANCE SHEET AT WHICH VALUE

Balance Sheet


When prepare Balance Sheet P L of small trader retailer businessman who s turnover below 20lakh which ratio should maintain or logic applied

Format letter for early cit(a) hearing


Can anyone send me format letter for early hearing to CIT A at avv1874 yahoo com

Discussion

Accounting of cash credit in balance sheet?

An assessee availed a CC Limit of 15 lacs against mortgage of property Balance on 31st March in CC Account shows 13 5 lacs How much to show under Liability 1 5 lacs CC utilised to be shown under Liab Under which head Current Liability or Long Term Loans Does CC limit of 13 5 lacs UNUTILISEDneeds to

Death of partner and admission of new partner. deed format

Can anyone provide me deed format for death of one of the partner and firm wants to admit a new partner on the day of death Its urgent

Authorization letter format

Hi Can someone share with me a sample authorization letter to a Chartered accountant to appear before IT Officer

Bank account out of balance treatment

Hi All Could anyone help me please to know the treatment for the out of balance in the bank account at the end of the year

How to write reply to it department calling of information u/s 133(6) of income tax act, 1961

My client was a retired pensioner and he had been filing his income tax returns for the last 8 years But he fails to file IT return for the AY 2013 14 because he was hospitalized at that time of filing the returns While computing his tax liability it is found that some tax liability also below 10 00

More Messages






File Download


More Files

Articles

Learn how to compare two columns in Excel


Like a two dimensional database Excel is capable of storing many different types of data from small business contacts to personal income tax records In both of these examples accuracy is essential to make sure you have the information you need when you need it In any data entry situation people ofte


Adding suffix in cells in MS Excel


Suppose you have a weight record of children and it looks like below You want to change the column as the After section You can add another column and write Kg and then concatenate these fields But again the same problem will be there and you not be able to calculate So how will you format cells in


Trick to add digits in a cell in Excel


Now I will tell you how to add prefix 00 for a check number For example you have the data like below before Now the point is how you will format cells in excel so that total digit should look like six digit code It is possible to add zeroes manually But the zeroes will go away until and unless you c


Tricks to Format cells in Excel: Currency Format (Prefix)


I have a large record set of the amount I want toadd prefix i e Rs in my records so that I can apply sum average min max function I can easily do it by typing it manually but then I will not be able to apply any function If I enter any amount in this column I will need to add Rs prefix manually If y


Guidance and Information about how to fill exam form for CA- IPC / Final


ATTENTION CA Aspirants 1 Detailed instructions on filling up the exam forms online are enclosed Candidates are advised to read understand and follow the instructions carefully while filling up the form 2 Filling up valid E mail address Mobile Number and Personal Identification Number PIN at the resp


More Articles


Updated on : 3/24/2017 11:34:12 AM


CCI online Coaching


KPMG


MilesEducation



CCI Jobs

× Online Coaching My Enrolled Courses
Articles Forum News Experts Exams Share Files Income Tax Accounts Career Corporate Law Service Tax Video Judgements Rewards Top Members Events Albums Find Friends Featured Feed Scorecard Bookmarks Mock Test Poll Notification Knowledge Finder Coaching Institutes Trainee Corner Jobs
close x
Download GST App    |    x