When to use this workbook

Use this loan payment split workbook to connect payment amount, principal component and interest component before the next review. Keep the three records distinct so a missing item is visible.

Reconcile one account or transaction stream at a time. Work from a closed statement period and compare the source records with the ledger before proposing a correction.

Review checkpoint: A balancing entry can conceal an unidentified transaction. Keep the unexplained item visible until its source and treatment are resolved.

Record checks for loan payment split

Records this workbook is designed to connect
RecordWhat to check
Payment amountIdentify the source and period behind the amount. Distinguish a quote or estimate from a posted transaction and flag any difference.
Principal componentIdentify the source and period behind the amount. Distinguish a quote or estimate from a posted transaction and flag any difference.
Interest componentUse a short factual description and a reference to the underlying record. Mark missing or conflicting evidence as unresolved instead of assuming an answer.

Your loan payment split working record

Enter short notes or document references. Use aliases instead of account numbers or personal identifiers. This worksheet exports the values you enter; it does not send them to AE or determine a filing position. Entries are not saved after you leave or reload.

Record 1
Download a blank CSV

Information readiness checklist

These checks track information readiness, not tax compliance or eligibility.

0 of 5 information checks marked.

Turn the record into a review handoff

For loan payment split, start the handoff with the connection between payment amount and principal component. Then identify what interest component still needs to establish. The exported sheet should make that relationship clear without replacing the original documents.

List the person collecting evidence separately from the professional deciding treatment. A blank field is a request for follow-up, not a zero, an approval or a concluded answer. Keep the supporting documents in your agreed secure record system; this public page accepts no document uploads.

Relevant source and further reading

IRS background for business bookkeeping. Use the applicable year’s guidance with your preparer; this organizational worksheet does not decide deduction amounts, election eligibility or statutory deadlines.

Prepared with AI assistance as an educational records tool. No professional review or client result is represented. Read AE’s AI disclosure and editorial policy.

Related workbooks

All business bookkeeping workbooks · Search the workbook library

Coordinate this work with AE Tax Advisors

If the records reveal an unresolved planning or implementation question, review AE’s relevant service scope and published fees. Bring the record summary and open questions to a discovery call.