Hasaan Fazal
What is Expectation gap in auditing?
Auditing expectation gap or simply expectation gap is the term used to signify the difference in expectations of users of financial statements and auditor’s expectation concerning audited financial statements. Although its about expectations but still its scope and meanings have been defined in number of ways. Difference in expectation can arise on the performance i.e. […]
Custom Autofill series and Custom sorting with Custom lists in Excel
If you are already using some of Excel’s custom features then you probably are already in love with them. Few days back we discussed custom views option and how it can help us. Today we have another custom feature of Excel - Custom Lists. Custom lists helps us notably in two ways: by having our […]
What is meant by Carriage inwards and its accounting treatment?
Carriage inwards, transportation inwards, transport inwards, freight inwards or shipping cost are the cost borne by the buyer of the goods for moving the goods from supplier’s place to his own place (usually raw material store) or for receiving the goods at his place as such costs are to paid once delivered. It is often […]
Why auditor may be unable to obtain sufficient appropriate audit evidence?
Auditor is required to obtain sufficient appropriate audit evidence as it helps auditor reduce audit risk to appropriate level which leads to positive expression of auditor’s opinion in auditor’s report. Although auditor puts every effort in obtaining sufficient appropriate audit evidence, however, this is not always the case and under specific circumstances he may not […]
When Auditor expresses a Qualified opinion?
A qualified opinion is one of the three types of modified opinion that auditor expresses in circumstances where unmodified opinion is not appropriate in auditor’s judgment. Qualified opinion is also known as “except for” opinion. As the name suggests it is a conditional opinion on the financial statements being audited and implies that except for […]
Absolute or Static structured references in Excel table - How to
Just a quick note on how to do absolute referencing if you are using structured references in Excel tables. For the ones who are not familiar with structured references and tables, your tutorial is baking and you will surely be able to catch up afterward. Referencing - A quick review Those who know structured references […]
Understanding Custom Views in Excel
Excel is all about flexibility. With all the built in features there is just endless possibilities the way you can use this marvelous application software. But Excel extends the flexibility even further through custom features. And I recommend every Excel user to know all such features that come with word “Custom” because it put you […]
Calculate number of Work Days in Excel using formula
Few days back I scribbled about calculating days between two dates and there I discussed DAYS360 formula method and one other common sense method to find out the number of days between two dates. But what if we want to find out working days between two dates and not just any days i.e. excluding weekends […]
How to sort Rows horizontally left to right instead of Columns vertically top to bottom in Excel
Sorting is one of the many good things excel offers. And it does make our job a lot easier once the data is arranged in particular order. However there is one limitation to the usual use of sorting i.e. it sorts in vertical fashion that is columns are sorted top to bottom in the order […]
How to convert numbers into words in Excel - VERY QUICK TIP
I have been working on a small piece and I came across one requirement that in letters to customers in addition to amounts reported in numbers it must also include amounts receivable in words. Well I wasn’t paying attention to that part in the beginning. It don’t even cross my mind that there is no […]