Interview query CA urgent
This query is : Resolved
01 July 2023
The person asked me how you prepare the balance sheet in excel. I replied i export the trial then schedules are linked with trial and Balance sheet and P/L items are linked with schedule. Then he said suppose there are various changes in trial then you again put all the fig in trial i said yes he said that it is a very lengthy process..
Don't you know any formula that if any fig is changed then automatically balance sheet is changed ? there are 5000 line items in your trial then how would you manage...
Please guide
Don't you know any formula that if any fig is changed then automatically balance sheet is changed ? there are 5000 line items in your trial then how would you manage...
Please guide
01 July 2023
you should use sum if formula for this
03 July 2023
sumif formula to change the fig in trial?
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Is Aadhar PAN linking required for opening bank account?
- CPC Processing IT Return for AY 2023-24 without recognizing the Taxation Option under New Regime
- Where to show the RCM on Rent paid to unregistered landlord
- RCM - commercial rent paid to URP under GST
- SEC 54 OF IT ACT
- Form 26QB for TDS on property
- GST Annual Returns filing due date
- Gst Sales of FY 2023-24
- Payable outstanding for years disallowance
- Legal heir raised refund , but refund issued to the closed account of deceased.
- Need help with business structure for setting up a new business
- TDS applicability on Service through ECO
- Issue of gst e invoice
- Interchangeable words in accounts
- Adjusted profit/Loss in the case of LLP and Pvt. Ltd.company
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
- Query for dubts
- Regarding Resignation by Auditor from Pvt. Ltd.
Trending Online Classes
-
Excel Mastery Program
CA Rishabh Pugalia
CAclubindia
