Run Accounting Schedule Reconciliation and Open RO Audit — Free

Audit Scope and Reconciliation Setup

Audit period and close date documented critical (required)

Record the month-end period, close date, and reconciliation cutoff used for the audit.

Factory receivable schedule obtained for the current period critical (required)

Verify the current factory receivable aging or detail schedule is available for review.

Yes No N/A

Warranty receivable schedule obtained for the current period critical (required)

Verify the current warranty receivable aging or detail schedule is available for review.

Yes No N/A

Open RO schedule obtained for the current period critical (required)

Verify the current open repair order schedule is available for review.

Yes No N/A

General ledger balances captured for all reconciled accounts critical (required)

Confirm the general ledger balances for factory receivable, warranty receivable, and related clearing accounts were captured.

Yes No N/A

Factory Receivable Reconciliation

Factory receivable schedule agrees to general ledger within tolerance critical (required)

Enter the variance between the factory receivable schedule and the general ledger.

Aged factory receivable items over 60 days reviewed critical (required)

Confirm all factory receivable items older than 60 days were reviewed for collectability and support.

Yes No N/A

Unresolved factory receivable variances documented critical (required)

Verify any unresolved differences are documented with root cause, owner, and expected resolution date.

Yes No N/A

Factory receivable support files complete

Confirm invoices, claim backups, approvals, or other support are attached for sampled or disputed items.

Yes No N/A

Stale factory receivable balances identified for write-off or adjustment critical (required)

Determine whether stale balances were identified and routed for write-off, adjustment, or escalation per policy.

Yes No N/A

Warranty Receivable Reconciliation

Warranty receivable schedule agrees to general ledger within tolerance critical (required)

Enter the variance between the warranty receivable schedule and the general ledger.

Warranty claims aging reviewed for items over 90 days critical (required)

Confirm warranty claims older than 90 days were reviewed for status, denial risk, and collection follow-up.

Yes No N/A

Denied or short-paid warranty claims identified and tracked

Verify denied or short-paid claims are separately tracked with disposition and next action.

Yes No N/A

Warranty receivable support and approvals complete

Confirm claim forms, manufacturer correspondence, and approval evidence are retained for reviewed items.

Yes No N/A

Stale warranty receivable balances escalated critical (required)

Confirm stale warranty balances were escalated for adjustment, dispute resolution, or write-off consideration.

Yes No N/A

Open RO Aging and Clearing Review

Open RO schedule ties to service system and general ledger critical (required)

Confirm the open RO schedule agrees to the service system and related accounting balances.

Yes No N/A

Open RO items over 30 days reviewed for stale status critical (required)

Verify all open ROs older than 30 days were reviewed for completion, parts delays, or billing issues.

Yes No N/A

ROs with no activity or no customer authorization identified critical (required)

Confirm ROs lacking activity, authorization, or support were identified and escalated.

Yes No N/A

Clearing entries prepared for eligible open RO balances

Verify eligible open RO balances were prepared for clearing, reclassification, or closure.

Yes No N/A

Unusual or long-outstanding RO balances explained

Confirm any unusual or long-outstanding balances have a documented explanation and owner.

Yes No N/A

Controls, Exceptions, and Follow-Up

Exceptions summarized with root cause and owner critical (required)

Summarize all reconciliation exceptions, root causes, and responsible owners.

Corrective action due dates assigned critical (required)

Enter the target completion date for each corrective action or follow-up item.

Note (optional)

Management review completed for unresolved items critical (required)

Confirm unresolved variances and stale balances were reviewed by management.

Yes No N/A

Recurring control deficiency identified

Indicate whether the same issue has recurred from prior periods and requires a control improvement.

Yes No N/A

Inspector signature critical (required)

Inspector attestation that the monthly reconciliation review was completed.

Get your results

Enter your email — we'll send you a PDF of your filled-out template, plus the occasional MangoScoop newsletter (templates, workflow tips, product updates). Unsubscribe anytime — link is in every email.

Email (required)

Your name (optional)

Run: Accounting Schedule Reconciliation and Open RO Audit

Audit Scope and Reconciliation Setup

Factory Receivable Reconciliation

Warranty Receivable Reconciliation

Open RO Aging and Clearing Review

Controls, Exceptions, and Follow-Up

Get your results