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
- Showing Gift from relative in ITR for this year
- ITR selection for salaries and capital gain less than L
- Share accounting-->fifo - capital gain - period as per fifo?
- Soyabean hsn code and gst rate
- Treatment of Pension ?annuity returns on PMVY
- ITR filing- non tax audit cases- Asstt.Year 2026-2027
- Salary and pension received from Asian Development Bank
- Free lancer income
- Regarding IMS Mandatory from 1st July 2026
- What is provisional receipt number for generation of form 16A
- Capital Gain on EUITY Shares
- Gst invoice numbering and delivery challan numbering
- Standard Deduction claim for EPFO Pension and ICICI Prudential Life Annuity
- Small dealers gst returns filing
- Sales amount in Gstr1
- CG after sale of flat
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
