QuickBooks AP Aging Import

Upload QB AP Aging Report

Export a QB A/P Aging Detail report with columns: Type, Date, Num, Name, Open Balance.

Run BEFORE GL Detail. AP Aging is the sole source of supptrans rows in the migration — GL Detail does not create supptrans, only gltrans for the GL history. Each row becomes a new supptrans with the OPEN balance and the QB bill number preserved as transno. Suppliers without a match in suppliers are skipped.

Target Database

Map Columns

The tool couldn't auto-detect this aging report's layout. Pick which column is Type, Num, Name, and Open Balance (all required). Other columns are optional but recommended.

Header row: the row with your column titles (typically row 1).

Header row

Type column *

Num column *

Vendor Name column *

Open Balance / Amount column *

Date column (optional)

Due Date column (optional)

Bill # / Ref column (optional)

AP Aging Import

Upload QB AP Aging Report

Map Columns

File preview (first 30 rows)

Review

Sample rows (first 30)