QuickBooks AR Aging Import

Upload QB AR Aging Report

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

Run BEFORE GL Detail. For each row, the tool creates a new debtortrans row with the OPEN balance, preserving the original QB invoice number as transno. GL Detail will skip these when it runs next. Customers without a match in debtorsmaster 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 *

Customer Name column *

Open Balance / Amount column *

Date column (optional)

Due Date column (optional)

P.O. column (optional)

AR Aging Import

Upload QB AR Aging Report

Map Columns

File preview (first 30 rows)

Review

Sample rows (first 30)