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
- DELIVERY GOLD & SILVER AND OTHER ETF TRADING PROFIT AS BUSINESS INCOME
- GSTR-1A How to update Invoice
- Excess salary payment.
- 3cd- cash system of accounting is allowed?
- Provision for loans that are under Revenue Recovery
- APPLICABILITYOF GST ON STUDENT HOSTEL FEES
- Form 121-contradictory opinions
- Current Account Opening for Sole Proprietorship with Udyam Certificate - Zero Turnover
- Stamp Paper for partnership firm change new income tax 2025
- TDS on Purchase of Immovable Property by NRI from NRI
- Cash gift by grand mother to her grand daughter
- Tax amount diff in Gstr1 and 3B in tax compare reports
- Tds on GST in connection with sale to public company
- Restoration of certificate of practice
- Regarding change in correspondence address in SSP portal
- No Compliences after incorporation
- USEFUL LIFE OF USED/SECOND HAND COMMERCIAL VEHICLES
- Claiming TDS deducted by builder on Hardship compensation and Corpus
- Address Change to another state of a Registered Trust with 12AB approval
- Updated return in budget 2026
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
