Does anyone have experience doing an AP Aging clea...
# accountingd
Danny Tang
09/30/2020, 8:08 PMDoes anyone have experience doing an AP Aging clean up post implementation? Our implementation team imported the bills and bill payments into NetSuite as Journals but didn't apply them against each other. After manually applying as many bill payments as we could, we have a handful of bills that we can not find the payment for. Does anyone have any suggestions on how to clean this up?
Danny Tang
09/30/2020, 8:09 PMNetSuite support suggested that we open a new AP account and transfer the correct AP balance to the new account and have our controller write off the remaining/legacy AP balance. Has anyone done this before?
l
Luis
09/30/2020, 9:26 PMAre the reminding vendor bills checked against the AP balance as of Go Live date? Cause maybe some of them are really unpaid
k
KevinJ of Kansas
10/01/2020, 1:50 PMI've done a ton of AP reconciliation - generally they fall into a few categories:
1) your AP balance doesn't tie to your AP detail
1a) Payments/Credits not entered properly.
1b) Someone edited the damn vendor bill after the fact
1c) wrong total field mapped in the import.
2) someone has a JE to AP without a name on it post go live for some reason.
3) double entry of transactions
KevinJ of Kansas
10/01/2020, 1:50 PMThose are the places I'd start.
KevinJ of Kansas
10/01/2020, 1:51 PM4) some one posted to the wrong period.
5) there are period/date mismatches on vendor bills - in order to get a valid comparison set your report by period setting to "always" and then run your financials versus your open AP aging.
d
Danny Tang
10/01/2020, 9:15 PMLooks like its #2 on your list, the implementation team who migrated our legacy data didn't put any vendors in any of the vendor bill/bill payment JE's which is why we are having trouble applying them against each other
Danny Tang
10/01/2020, 9:27 PMso the problem we ran into is we can't apply two lines against each other unless they have a vendor record, and since these are all legacy data, those periods are locked so we can't add a vendor
Danny Tang
10/01/2020, 9:27 PMany suggestions?
k
KevinJ of Kansas
10/01/2020, 9:30 PMDoes the total for "no Vendor" come to zero?
d
Danny Tang
10/01/2020, 9:32 PMNo, I wish...
k
KevinJ of Kansas
10/01/2020, 9:32 PMThen the more likely thing is that your AP detail loaded at go live didn't match your GL history import
KevinJ of Kansas
10/01/2020, 9:33 PMHow long have you been live?
d
Danny Tang
10/01/2020, 9:35 PM3+ years
k
KevinJ of Kansas
10/01/2020, 9:35 PMoh geeze.
🤦♂️ 1
KevinJ of Kansas
10/01/2020, 9:36 PMDo you have any accounts that are set up as AP accounts, that shouldn't really be AP accounts?
KevinJ of Kansas
10/01/2020, 9:36 PM(i.e. accrual AP accounts or something)
d
Danny Tang
10/01/2020, 9:38 PMi just checked, the AP accruals are setup as Other Current Liability and we only have 2 AP accounts, one AP and one AP Adjustments
k
KevinJ of Kansas
10/01/2020, 9:38 PMMan, you're hitting the area where I'd want 20 hours to look at it and figure it out. 3 years after the fact? That's not easy clean up to make.
d
Danny Tang
10/01/2020, 9:39 PMhaha yeah we've made some clean up attempts already
2 Views