If anyone uses SVB, I wrote a python script to aut...
# accounting
j
If anyone uses SVB, I wrote a python script to automate an integration between SVB and Netsuite if anyone would like to check it out and give it a try. I'd be happy to share it. I tried to comment and make in all caps what needs to be changed. Its a bit sloppy but it works for me. It pulls in QFX and CSV date from SVB given a certain date, formats the CSV so its in good form and uploads it, then uploads the qfx data to netsuite so the JE's will be ready to match transactions. We use it for regularly occuring transactions (Sweep/payroll) but can be customized. Additionally we made it so anything with the external ID "SVB" in netsuite bypasses the JE approval process so the low risk regular JEs dont need to be approved (Essentially just transfers we dont run through approval)