Excel PivotTables: Review Expenses without Double-Counting
A practical guide to excel pivottables, with a worked example, evidence checklist, common mistakes and steps to prepare a defensible working.
By Team assureOfficeArticles & practical guides
Practical Indian tax, financial reporting, labour, state law and business compliance guides for CAs, accountants and businesses.
Articles & practical guides
361 articlesExcel SUMIFS: Build a Month-Wise Expense Review
A practical guide to excel sumifs, with a worked example, evidence checklist, common mistakes and steps to prepare a defensible working.
By Team assureOfficeExcel XLOOKUP: Match Ledger Codes and Report Exceptions
A practical guide to excel xlookup, with a worked example, evidence checklist, common mistakes and steps to prepare a defensible working.
By Team assureOfficeTally Cost Centres: Prepare a Segment Reporting Working
A practical guide to tally cost centres, with a worked example, evidence checklist, common mistakes and steps to prepare a defensible working.
By Team assureOfficeTally Edit Log: Review Changes around the Closing Date
A practical guide to tally edit log, with a worked example, evidence checklist, common mistakes and steps to prepare a defensible working.
By Team assureOfficeFinancials Builder Review: Assign Tasks and Track Sign-Offs
A practical guide to financials builder review workflow, with a worked example, evidence checklist, common mistakes and steps to prepare a defensible working.
By Team assureOffice
Country-by-Country Reporting: Reconcile Entities and Data Sources
A practical guide to country-by-country reporting, with a worked example, evidence checklist, common mistakes and steps to prepare a defensible working.
By Team assureOfficeTransfer Pricing Notice: Prepare the Submission Evidence Index
A practical guide to transfer pricing notice, with a worked example, evidence checklist, common mistakes and steps to prepare a defensible working.
By Team assureOfficeTP Documentation: Build a Functions, Assets and Risks Interview
A practical guide to tp documentation, with a worked example, evidence checklist, common mistakes and steps to prepare a defensible working.
By Team assureOfficeTP Royalties: Reconcile the Agreement, Sales Base and Payment
A practical guide to tp royalties, with a worked example, evidence checklist, common mistakes and steps to prepare a defensible working.
By Team assureOfficeTP Corporate Guarantees: Prepare the Terms and Evidence File
A practical guide to tp corporate guarantees, with a worked example, evidence checklist, common mistakes and steps to prepare a defensible working.
By Team assureOfficeTransfer Pricing Working-Capital Adjustments: Assemble the Inputs
A practical guide to transfer pricing working-capital adjustments, with a worked example, evidence checklist, common mistakes and steps to prepare a defensible working.
By Team assureOffice