Anyone know how to import lockbox deposits?
# accountings
screnshaw
02/28/2022, 4:11 PMAnyone know how to import lockbox deposits?
r
RJMNS
02/28/2022, 5:51 PMYou're not talking the actual lockbox functionality within NetSuite, you're just saying you have money that came into your lockbox that you need to record in NetSuite?
If you have invoices for them to apply to, I'd do a CSV import of Customer Payments. If you don't have invoices and/or you're not doing application of the payments in NetSuite, you're just recording cash, I'd do them as JEs, noting the customer on the line.
s
screnshaw
02/28/2022, 7:19 PMI'm not sure. I just know that we have a bank that is sending us lockbox deposits so that we can reconcile in netsuite
k
Karina
02/28/2022, 7:31 PMdo you have bankfeeds set up?
s
screnshaw
02/28/2022, 7:33 PMWe do. No clue how to use it in terms of importing the lockbox deposits. Currently we have sftp to get the files (which is working)
k
Karina
02/28/2022, 7:37 PMwhat you are saying is that you want to match lump sum coming from the bank with specific NS transactions? not possible, not if the transactions are all different
Karina
02/28/2022, 7:37 PMi know there is a lockbox functionality but do not know what this is, it sounds like you may want to explore it as it should give you the breakdown of that lumpsum
k
KevinJ of Kansas
03/01/2022, 1:16 AMI dealt with a lockbox bank at a client - was a disaster - I want to say there was something new related to lockboxes that I meant to investigate but haven't had a chance to
KevinJ of Kansas
03/01/2022, 1:16 AMOh, that's right. Paystand does that.
KevinJ of Kansas
03/01/2022, 1:17 AMThe big fun part with lockboxes is when transactions don't come with remittance advice, or its unlegible, or the bank tellers screw something up - even getting a CSV file and turning it into an import is unreliable and you have to do a bunch to go with it
KevinJ of Kansas
03/01/2022, 1:18 AMThe paystand functionality around it was pretty neat from what I recall, but you're paying a premium for it - though I imagine the goal there is to reduce headcount, so that's one advantage to it
4 Views