DOSSIER DE REVISION 2017 5i5y1v

The Audit File is an ing audit tool developed under EXCEL,

Its main advantages:

• the assurance of a meticulous and professional presentation to be proposed to your external auditors (chartered ants, auditors, tax auditors, etc.)
• a significant time saving thanks to the functionalities and numerous automated modules included in this tool,
• a guarantee as to the automatic totalization of the cells and the integrated self-checks (detection of anomalies and deviations, analysis of variations, general concordances, etc.),
• the possibility of keeping the history of the revision of a balance sheet on a simple USB key and therefore the possibility of starting again from the analysis data of the N-1 exercise,
• an operational matrix to advance all the current work of the year (vat poly-activity flow/collection frameworks, preparatory statements for the declaration of VAT, advance payments of corporate income tax, payroll taxes, social declarations, control of social security contributions and annual frameworks, determination of taxable income, etc….as well as numerous worksheets for justification),

Main functions

• NEW: customised setting of vat rates linked to local taxation
• NEW: adaptation of the figures to the local currency (currency management)
• NEW: calculation and analysis of company ratios
• NEW: Undercapitalized links
• general agreement
• automated balance sheet / income statement / tax return assembly (simulation of DGI 2050 to 2059-C forms)
• automated assembly of financial analysis tables (CAF / BFR / FR / FR / Cash flow variation)
• comparison of N / N-1 balances
• tables of changes (shareholders’ equity / fixed assets / inventories /…) and variance control
• bank reconciliations
• calculation of the value-added cap and the CVAE
• calculation of interest on partners’ current s (determination of the non-deductible fraction)
• management of SICAVs, calculation of +/- capital gains realised according to the fifo method / management of unrealised capital gains and tax treatment
• monitoring tables (loans / leases / insurance / doubtful receivables…)
• automated calculation of prepaid expenses / analysis of external expenses
• automated vat framing (receipts / debits and mixed), controls of deductible / collected vat
• calculation of the solidarity social contribution
• determination of taxable income
• calculation of corporate income tax installments for year N and N+1 (provisional table)
• automated calculation of SST, excess depreciation amount
• staff summary tables (inputs / outputs…)
• monitoring of the workforce (determination of the annual average workforce according to the rule recommended by the URSSAF)
• summary of annual gross amounts
• summary of annual ceilings (calculation of salary bands)
• ing reconciliation / Dads / payroll book
• determination of the charging rate
• control of social security contributions / control of bases (management of staggered financial years)
• justification of third-party s
• calculation of the provision for paid leave
• NEW: calculation of the CICE tax credit
• NEW: Checking the calculation of the Fillon reduction calculation
• NEW: Calculation of the provision for retirement indemnity (IDR)
• calculation of the participation reserve
• calculation of TNS contributions (Artisans, Industrialists and Traders, Unregulated liberal professions) – including the subjection of dividends (SS 2013 Financing Act)
• automated centralisation of cycle conclusions / highlights / outstanding issues / entries in the annex
• etc….