Skip to content

Recalculations and reconciliations in the audit

Updated:

Recalculating depreciation, loans and interest, receivables, payroll, revenue and VAT and the cash flow statement, with a threshold, explanations and a conclusion.

Open Depreciation recalculation in Fiatto
In this article

For an audit, review or compilation engagement, the audit workspace has screens under Engagement and file that recalculate an item or reconcile it with the client's books: Depreciation recalculation (/dashboard/controle/afschrijvingen), Loans and interest, Receivables, Payroll reconciliation, Revenue and VAT reconciliation and Cash flow statement. Only the engagement's accountants work here; the client sees a notice.

Steps

  1. On the screen, first record the threshold and click Save threshold. The suggestion is the engagement's clearly trivial threshold; a difference above the threshold needs an explanation.
  2. Depreciation recalculation recalculates per asset from the fixed asset register the depreciation for the year from cost, residual value, method and useful life, and sets it against the depreciation schedule and the posted part. Loans and interest does the same per loan, loan granted and deposit from the treasury register: interest on the outstanding balance per day, against the repayment schedule and the posted interest, with the movement of the principal and the short-term portion.
  3. Receivables shows per debtor the Ageing at the balance sheet date, what was received or written off afterwards, and a proposal for the Provision for doubtful debts next to the provision booked. You set the percentages per age band; a debtor with more than the threshold unreceived and more than 90 days overdue needs an assessment, optionally with a specific provision.
  4. Payroll reconciliation sets the payroll journal per month against the ledger and the payroll tax return; Revenue and VAT reconciliation sets revenue, VAT payable and input VAT per quarter against the VAT returns. If a return is not in Fiatto, you enter the declared amount yourself.
  5. Explain each difference above the threshold, or choose Ask the client a question or Record as a misstatement. Then write a conclusion and click Complete; with Reopen you can make changes again, and the conclusion then lapses.

Tips

  • The Cash flow statement builds the statement using the indirect method from the same trial balance as the financial statements, even if the financial statements model does not require one. The figures are kept when you complete it.
  • For an audit or review engagement, under Analytical procedures you set an expectation per item before looking at the balance. Fiatto sets it against the posted amount; at the end of the audit comes the Overall review.
  • Industry comparison sets the client's key figures against those of other clients of your firm in the same industry, only as quartiles and only from five clients: never names or figures of another client.
  • If the client is an owners' association, you record the cash committee's checks under Owners' association review next to the operating account and the reserve fund from the association's annual accounts.
  • An asset with an impairment or a loan with a variable rate gives an expected difference; the screen says so on the line.

See also: Figures and risk analyses, Sampling, balance confirmations and audit differences, Working papers per line item.

Was this article helpful?
View all articles in this topic

Find another answer

A task, feature or short question is enough.