IE-4: Open AP Import | NetSuite Implementation Guide

Interactive Example IE-4

AP Open Invoice Import Checklist

GAAP-compliant checklist for importing open vendor bills without re-recognizing expenses. Uses the clearing account methodology to prevent AP/Expense double-counting.

51 Checklist Items

6 Phases

3 GL Steps

The Problem: Expense Double-Count Trap

When migrating open vendor bills from a legacy system to NetSuite, the standard bill import creates full GL entries: Debit Expense/COGS, Credit AP. If you've already loaded your trial balance (which includes historical AP), you'll double-count both expenses AND liabilities.

🚨 Critical Issue

Without the clearing account method: A $100,000 AP balance becomes $200,000 after importing open bills, AND your expenses are overstated by $100,000. Your financial statements are materially misstated.

flowchart LR
    subgraph Legacy["Legacy System"]
        L1["Open Bills: $100K"]
    end

    subgraph Wrong["WRONG: Standard Import"]
        W1["Trial Balance<br/>AP: $100K"]
        W2["Import Bills<br/>DR Expense $100K<br/>CR AP $100K"]
        W3["Result:<br/>AP = $200K X<br/>Expense = $100K X"]
        W1 --> W2 --> W3
    end

    subgraph Right["RIGHT: Clearing Method"]
        R1["Trial Balance<br/>AP: $100K"]
        R2["Import Bills<br/>DR Clearing $100K<br/>CR AP $100K"]
        R3["Reverse<br/>DR AP $100K<br/>CR Clearing $100K"]
        R4["Result:<br/>AP = $100K OK<br/>Expense = $0 OK"]
        R1 --> R2 --> R3 --> R4
    end

    Legacy --> Wrong
    Legacy --> Right

    style W3 fill:#fee2e2,stroke:#ef4444
    style R4 fill:#d1fae5,stroke:#10b981

Solution

The Clearing Account Method

The clearing account methodology ensures that imported vendor bills only update the bill details (vendor, due date, line items) without impacting already-loaded GL balances. The AP balance stays correct, and no phantom expenses are created.

flowchart TB
    subgraph Step1["Step 1: Trial Balance Load"]
        TB1["Journal Entry"]
        TB2["DR Retained Earnings $100K"]
        TB3["CR Accounts Payable $100K"]
        TB1 --> TB2
        TB1 --> TB3
    end

    subgraph Step2["Step 2: Bill Import with Clearing"]
        BI1["Vendor Bill CSV"]
        BI2["DR AP Clearing Account $100K"]
        BI3["CR Accounts Payable $100K"]
        BI4["AP doubles temporarily"]
        BI1 --> BI2
        BI1 --> BI3
        BI2 --> BI4
        BI3 --> BI4
    end

    subgraph Step3["Step 3: Reversing Entry"]
        RE1["Journal Entry"]
        RE2["DR Accounts Payable $100K"]
        RE3["CR AP Clearing Account $100K"]
        RE4["AP correct, Clearing = $0"]
        RE1 --> RE2
        RE1 --> RE3
        RE2 --> RE4
        RE3 --> RE4
    end

    Step1 --> Step2 --> Step3

    style Step1 fill:#dbeafe,stroke:#3b82f6
    style Step2 fill:#fef3c7,stroke:#f59e0b
    style Step3 fill:#d1fae5,stroke:#10b981

GL Entry Flow

Step through each stage to see how the clearing account methodology works with real numbers.

1 Load Trial Balance

Load the opening AP balance from the legacy trial balance as of cutover date.

Journal Entry — Trial Balance Load

Account Debit Credit

3000 — Retained Earnings $100,000

2000 — Accounts Payable $100,000

Accounts Payable (2000)

$100,000 CR

Clearing Account (9998)

Expense Accounts

ℹ️ Note

The trial balance entry captures ALL legacy AP in a single journal entry. Individual vendor detail comes from the bill import in Step 2.

2 Import Vendor Bills with Clearing Account

Import open bills using the clearing account instead of expense accounts. This creates vendor-level detail without hitting P&L.

Vendor Bill Import (Clearing Account on Lines)

Account Debit Credit

9998 — AP Clearing Account $100,000

2000 — Accounts Payable $100,000

Accounts Payable (2000)

$200,000 CR (doubled!)

Clearing Account (9998)

$100,000 DR

Expense Accounts

⚠️ Temporary State

AP is now doubled! This is expected and temporary. The clearing account holds the offset until we reverse it in Step 3. Never close a period in this state.

3 Reverse the Clearing Account

Post a reversing journal entry to eliminate the doubled AP and zero out the clearing account.

Journal Entry — Clearing Account Reversal

Account Debit Credit

2000 — Accounts Payable $100,000

9998 — AP Clearing Account $100,000

Accounts Payable (2000)

$100,000 CR

Clearing Account (9998)

Expense Accounts

💡 Migration Complete

Final Result: AP is correct at $100,000, clearing account is zero, and no phantom expenses were created. You have vendor-level detail for all open bills without impacting the P&L.

Sequence

Import Sequence

Follow this sequence to ensure data integrity. Vendor credits follow the same clearing account pattern but with reversed debits/credits.

flowchart TB
    A[Create AP Clearing Account] --> B[Load Trial Balance]
    B --> C[Create/Verify Vendors]
    C --> D[Import Vendor Bills]
    D --> E[Import Vendor Credits]
    E --> F[Validate AP Aging]
    F --> G{Totals Match?}
    G -->|Yes| H[Post Reversing Entry]
    G -->|No| I[Reconcile Differences]
    I --> F
    H --> J[Verify Clearing = $0]
    J --> K[Lock Migration Period]

    style A fill:#dbeafe,stroke:#3b82f6
    style H fill:#d1fae5,stroke:#10b981
    style I fill:#fee2e2,stroke:#ef4444
    style K fill:#d1fae5,stroke:#10b981

Phase 1

Pre-Migration Setup

Configure NetSuite with the necessary accounts, items, and settings before starting the import process.

Pre-Migration Setup (9 items)

Create AP Clearing Account — Create account 9998 (or similar) as type 'Other Current Liability' or 'Other Expense'. Name it 'AP Migration Clearing' or 'AP Suspense'. Path: Setup > Accounting > Chart of Accounts > New
Create Migration Service Item (Optional) — Create a non-inventory item 'Migration - AP' that defaults to the clearing account. Useful for item-based bill lines. Path: Lists > Accounting > Items > New
Import/Create All Vendors — All vendors referenced in open bills must exist before bill import. Capture external IDs for mapping. Path: Lists > Relationships > Vendors > Import
Map Vendor IDs (Legacy to NetSuite) — Create mapping table: Legacy Vendor ID to NetSuite Internal ID or External ID. Verify no duplicates.
Configure Vendor Bill Form — Ensure bill form allows external ID field, and that expense/item sublists are visible. Path: Customization > Forms > Transaction Forms
Verify Currency Setup (Multi-Currency) — If importing foreign currency bills, ensure currencies are enabled and exchange rates are loaded for transaction dates. Path: Lists > Accounting > Currencies
Set Up Subsidiary Mapping (OneWorld) — Map legacy company/entity codes to NetSuite subsidiary internal IDs.
Document Cutover Date — Establish and document the exact cutover date. All open bills as of this date will be migrated. Later bills entered directly in NetSuite.
Disable Automated Workflows (Temporarily) — Turn off any approval workflows or email alerts that might fire during bulk import. Path: Customization > Workflow > Workflows

Phase 2

Data Preparation

Extract, cleanse, and transform legacy AP data for NetSuite import format.

Data Preparation (9 items)

Extract Open Bills from Legacy System — Pull all unpaid vendor bills as of cutover date. Include partially paid bills with remaining balance only.
Extract Vendor Credits — Pull all unapplied vendor credits/debit memos. These need separate import with reversed GL logic.
Calculate Legacy AP Total — Sum all open bills minus credits. This MUST match your trial balance AP amount.
Reconcile to Trial Balance — Legacy AP Aging Total must equal Trial Balance AP. Investigate any differences before proceeding.
Map Required Fields — Map legacy fields to NetSuite: Vendor, Bill Date, Due Date, Bill Number, Amount, Currency, Terms, Subsidiary (if OneWorld).
Assign External IDs — Create unique external IDs for each bill (e.g., 'MIG-BILL-00001'). Essential for troubleshooting and potential re-import.
Format CSV per NetSuite Spec — Headers must match NetSuite field IDs exactly. Dates in MM/DD/YYYY format. Amounts without currency symbols.
Set Clearing Account on All Lines — Every expense line must reference the clearing account (9998), NOT the original expense/COGS account. This is the critical step.
Validate Data Quality — Check for: missing vendors, invalid dates, negative amounts, duplicate bill numbers, currency mismatches.

Phase 3

Import Sequence

Execute the import in the correct sequence with proper GL treatment.

🚨 Critical Reminder

GL Impact for bill import MUST be:
Debit: Clearing Account (9998)
Credit: Accounts Payable (2000)

Never use actual expense accounts during migration import!

Import Sequence (9 items)

Verify Trial Balance is Loaded — Confirm AP trial balance journal entry is posted. Run Balance Sheet to verify AP matches legacy total.
Test Import (Small Batch) — Import 5-10 bills first. Verify GL impact shows Clearing/AP only. Check that no expense accounts are hit.
Verify Test Batch GL — Run Transaction Detail report filtered by clearing account. Confirm only migration bills appear.
Import Remaining Vendor Bills — Import full bill file. Use CSV Import with 'Add' mode. Path: Setup > Import/Export > Import CSV Records
Document Import Results — Record: Total bills imported, total amount, any errors. Save import log for audit trail.
Import Vendor Credits (if applicable) — Import vendor credits with clearing account. GL will be reversed: Debit AP, Credit Clearing.
Handle Prepaid Vendors/Deposits — Vendor prepayments cannot be imported via CSV. Must be entered manually or via SuiteScript. Document separately.
Verify Clearing Account Balance — Clearing account balance should equal total imported bills minus credits. This will be reversed in Phase 5.
Resolve Any Import Errors — Address failed rows: missing vendors, invalid currencies, field validation errors. Re-import corrected records.

Phase 4

Validation

Validate imported data before posting the reversing entry.

Validation (8 items)

Run AP Aging Report — Generate AP Aging Summary and Detail. Compare totals to legacy aging report. Path: Reports > Vendors/Payables > A/P Aging
Compare Bill Counts — Legacy open bill count vs NetSuite imported bill count. Should match exactly (excluding any intentionally excluded).
Verify AP Balance (Before Reversal) — AP should be DOUBLED at this point (Trial Balance + Imported Bills). This is expected and correct.
Verify Clearing Account Balance — Clearing account should equal imported bill total. This is the amount that will be reversed.
Spot Check Individual Bills — Select 10+ bills randomly. Verify: vendor, amount, date, due date, terms match legacy system.
Verify Vendor Balances — For top 10-20 vendors by balance, compare NetSuite vendor balance to legacy. Investigate any variances.
Check Expense Accounts — Run Trial Balance. Verify NO expense accounts have been hit by migration bills. All activity should be in clearing account only.
Document Validation Results — Create validation summary: totals match (Y/N), count match (Y/N), exceptions list, sign-off.

Phase 5

Clearing Account Reversal

Post the reversing entry to eliminate doubled AP and zero the clearing account.

flowchart LR
    A["Clearing Account<br/>$100,000 DR"] --> B["Journal Entry<br/>DR AP $100K<br/>CR Clearing $100K"]
    B --> C["Clearing Account<br/>$0"]
    B --> D["AP Balance<br/>Correct"]

    style A fill:#fef3c7,stroke:#f59e0b
    style C fill:#d1fae5,stroke:#10b981
    style D fill:#d1fae5,stroke:#10b981

Clearing Account Reversal (8 items)

Calculate Reversal Amount — Reversal amount = Clearing account balance. Must equal total bills imported minus credits.
Prepare Reversing Journal Entry — Debit: Accounts Payable (2000) / Credit: AP Clearing Account (9998). Memo: 'AP Migration Clearing Reversal'
Set Correct Posting Date — Use same date as trial balance load (cutover date). Ensures AP is correct as of go-live.
Get Approval for Reversal — Obtain sign-off from Controller/CFO before posting. This is a material entry.
Post Reversing Entry — Post the journal entry. Verify it saves without error. Path: Transactions > Financial > Make Journal Entries
Verify Clearing Account = $0 — Run Trial Balance or GL account detail. Clearing account must be zero. Any balance indicates an error.
Verify Final AP Balance — AP should now match original trial balance amount. Run Balance Sheet to confirm.
Verify No P&L Impact — Run Income Statement. Verify no expense activity from migration bills. P&L should be unaffected.

Phase 6

Cleanup & Controls

Finalize the migration, implement controls, and prepare audit documentation.

Cleanup & Controls (8 items)

Inactivate Clearing Account — Once verified at zero, mark clearing account inactive to prevent future use. Path: Lists > Accounting > Accounts > Edit
Inactivate Migration Item — If you created a migration service item, inactivate it to prevent accidental use.
Re-enable Workflows — Turn approval workflows and email alerts back on for normal operations.
Lock Migration Period — Lock the accounting period containing migration transactions to prevent changes. Path: Setup > Accounting > Manage Accounting Periods
Create Audit Documentation Package — Compile: source data extracts, mapping documents, import logs, validation reports, sign-offs, GL reconciliation.
Document Exception Handling — Record any bills that required manual adjustment, with reasons and approvals.
Train AP Team — Ensure AP team understands: how to identify migrated vs new bills, how to process payments against migrated bills.
Final Sign-Off — Obtain final sign-off from Controller/CFO confirming AP migration is complete and accurate.

Reference

Auditor Documentation Package

Prepare these documents for external audit review. Auditors will specifically look for evidence that the clearing account methodology was properly executed.

Document	Purpose	Key Content
Migration Methodology Memo	Explain approach to auditors	Clearing account rationale, 3-step process, GAAP compliance statement
Legacy AP Extract	Source data evidence	Complete open bill listing as of cutover, signed by legacy system owner
Trial Balance Reconciliation	Prove TB matches detail	Legacy TB AP = Sum of open bills, tie-out worksheet
Import Log	Evidence of systematic import	NetSuite CSV import results, success/error counts, timestamps
GL Account Analysis	Prove no P&L impact	Clearing account activity detail showing net zero, expense accounts untouched
Reversing Entry	Clearing account elimination	Journal entry detail with approvals, before/after TB comparison
Validation Report	Accuracy confirmation	Count match, total match, sample testing results, variance explanations
Management Sign-Off	Accountability	Signed attestation from Controller that migration is complete and accurate

Reference

Common Pitfalls

Pitfall	Severity	Solution
Forgetting clearing account on bill lines	Critical	Every expense line must use clearing account. Validate before import.
Skipping the reversal entry	Critical	AP will be doubled. Never close period without reversing.
Closing period with non-zero clearing	Critical	Clearing account must be zero before period close.
Wrong posting date on reversal	Warning	Use same date as trial balance to avoid interim misstates.
Missing vendor records	Warning	Import all vendors BEFORE bills. Check for external ID mismatches.
Importing prepayments via CSV	Warning	Vendor prepayments need manual entry or script. CSV doesn't support deposits.
Currency mismatch	Warning	Bill currency must match vendor currency. Load exchange rates for dates.
Not reconciling to trial balance	Warning	Legacy AP detail must equal TB. Investigate before importing.

Reference

Handling Vendor Credits

Vendor credits (debit memos) follow the same methodology but with reversed GL entries.

ℹ️ Vendor Credit GL Treatment

Standard vendor credit: DR AP / CR Expense
Migration vendor credit: DR AP / CR Clearing Account

The reversing entry will include credits (reduces the reversal amount).

Vendor Credit Import (Migration)

Account Debit Credit

2000 — Accounts Payable $5,000

9998 — AP Clearing Account $5,000

Reference

Sources & References

ℹ️ Methodology Attribution

The clearing account methodology for open AP migration is an industry best practice documented by multiple NetSuite implementation experts including Paul Giese (OptimalData Consulting) and standard ERP data migration frameworks.

Key Resources

OptimalData Consulting — Data migration methodology and best practices
Oracle NetSuite Help Center — CSV Import documentation, Vendor Bill fields
ASC 405 — Liabilities (GAAP guidance on liability recognition)
NetSuite SuiteAnswers — Article IDs: 10117 (Importing Vendor Bills), 42620 (Multi-Currency Imports)

AP Open Invoice Import Checklist

The Problem: Expense Double-Count Trap

The Clearing Account Method

GL Entry Flow

Import Sequence

Pre-Migration Setup

Pre-Migration Setup (9 items)

Data Preparation

Data Preparation (9 items)

Import Sequence

Import Sequence (9 items)

Validation

Validation (8 items)

Clearing Account Reversal

Clearing Account Reversal (8 items)

Cleanup & Controls

Cleanup & Controls (8 items)

Auditor Documentation Package

Common Pitfalls

Handling Vendor Credits

Sources & References

Key Resources

Related NCG Content