client exported their lengthy detailed QB accrual basis trial balance to Excel. Then their controller made a bunch of aje's to restate correctly to the cash basis.
I'm trying to suck the trial balance into TR's Workpapers CS but because QB imbedded the gl account numbers into the account name when it was exported, I don't have clean separate columns for the account number and one for the account title.
a single cell looks like this:
500-000 · DIRECT COSTS:590-000 · OTHER DIRECT COSTS:591-000 · ODC - Fringe Benefits:591-100 · ODC - Paid Time Off:591-101 · ODC - Vacation
I can parse the 500-000 into a separate column because of the dot separator, then the : separator and then parsing each section by section. Have to remember to insert lots of columns to the right so they don't get overriden.
Anyone know of an IIF file converter/tool?
Problem is those darn nested QB sub sub accounts.
(don't know macros or vb, but if that's what it will take I'll ask a buddy)