Hi All, how is Credit Card reconciliation work in Netsuite? Looks like I can’t directly upload the credit card statement to Netsuite as it’s required to enter NS Customer Id, etc. I’m interested to learn from others on how we can reconcile Credit Card transaction in NS. Thanks.

Hey Ron, I specialize in this. Hard to explain in this format and can’t do with all vendors but in essence you can find out what data your processor send along with transaction and when they fund can they give you back that unique data set you reconcile to so you can either drop right into NetSuite or simply look at the file and mark all as bad if they are on the file. It’s a daily raw data file. What is current process and what data point are you reconciling to? You don’t want to use statement - you need the raw data file.

Hey Murray, I’m also interested in learning more about your expertise in this area. Currently, we use AMEX, and our accounting team dumps out the transactions into Excel file, and then manually tags department/classes/vendors etc. Then they import it in as JE. I’m hoping to figure out how we can leverage the NetSuite functionality where some this information gets pre-populated. Are there paid import and reconciliation tools available?