Free Excel template · ASC 740

Income Tax Payable and Prepaid Rollforward (Excel)

The balance sheet carries current income taxes as a payable or a prepaid by jurisdiction. A rollforward shows how each balance moved: the provision, true-ups, payments, extension payments and refunds.

Standard
ASC 740
Format
Excel (.xlsx)
Cost
Free
Access
No sign-up

What it is

The balance sheet carries current income taxes as a payable or a prepaid by jurisdiction. A rollforward shows how each balance moved: the provision, true-ups, payments, extension payments and refunds.

The workbook has 15 jurisdiction rows with beginning balance (payable positive, prepaid negative), current provision, true-up, estimated and extension payments, refunds, ending balance, the general ledger balance and the difference. It ties provision and true-up to current tax expense in the provision and shows each balance as payable or prepaid.

When to use it

What’s inside

Standard cited

This template follows ASC 740. 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.

Download free Excel template (.xlsx)

Questions

How are prepaids shown?

As negative balances. Presentation shows each row as payable or prepaid.

Does it include deferred taxes?

No. See the deferred tax rollforward in this library.

Where do interest and penalties go?

In a separate row if you record them in a separate account.

Related templates

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