Free Excel template · ASC 326-20 / AU-C 540

Audit Program: Bank Loans and Allowance for Credit Losses

The loan portfolio and the allowance for credit losses drive most of the audit risk at a bank. This program organizes the work into loan existence and accuracy, risk rating review, the allowance, nonaccrual and modifications, and deposits, interest and capital.

Standard
ASC 326-20 / AU-C 540
Format
Excel (.xlsx)
Cost
Free
Access
No sign-up

What it is

The loan portfolio and the allowance for credit losses drive most of the audit risk at a bank. This program organizes the work into loan existence and accuracy, risk rating review, the allowance, nonaccrual and modifications, and deposits, interest and capital.

It is a five-tab workbook: instructions, an overview with completion counts, a risk assessment, numbered procedures with sign-off columns, and a tie-out tab. General procedures that every audit needs are appended automatically.

When to use it

What’s inside

Standard cited

This template follows ASC 326-20 / AU-C 540. It is written in our own words, except for phrases the standard requires the document to contain, with [bracketed placeholders] for client details, amounts in USD and dates as MM/DD/YYYY. Check it against the current standard and your firm’s methodology before use. See AU-C 540 explained.

Download free Excel template (.xlsx)

Questions

Does the program set sample sizes?

No. It gives selection guidance and points to your firm’s sampling policy under AU-C 530. Set the size from tolerable misstatement, expected misstatement and assessed risk.

Which standard governs the allowance?

ASC 326-20 sets the current expected credit loss model. The audit side is AU-C 540 on estimates. Apply the versions in effect for the period.

Can I use it for a credit union?

The credit union program in this library fits the member-owned structure better, though many loan steps carry across.

Related templates

Last updated 11/05/2026. All free templates.