One of my clients would like to import Historical Trial Balance transactions into NetSuite via CSV. They want the Accounts Receivable balance in the HTB to be segregated by customer, similar to how they currently track revenue by client in Great Plains.
However, they do not create invoices. Instead, they receive a monthly revenue output file from their custodian, use a converter tool, and import the transactions into NetSuite as Journal Entries.
Given this setup, I have a couple of questions:
- What would be the recommended approach for importing HTB AR balances by customer while maintaining customer-level visibility in NetSuite?
- Since the AR balances are being imported through Journal Entries rather than invoices, these balances may continue to appear on the AR Aging report without a mechanism to clear them. What would be the recommended approach to prevent or resolve the sustained balances in AR Aging?
- Are there any best practices or alternative methods for migrating historical customer-level AR balances into NetSuite when invoices are not available?
Any guidance or recommendations would be appreciated.