QuickBooks Data Manipulation

It's, once again, been too long since I've blogged. I've been so busy, with all of the iPhone users downloading iTransaX - our recently released credit card app for iPhone.

One of my colleagues recently sent me an interesting article on the iPhone phenomenon. Of course, I wholeheartedly disagree with the article - I think the iPhone rocks! And not just because we have an iPhone application, with more to come, in the iTunes store!

Anyway, I'm not really hear to talk about iPhone today - I want to talk about QuickBooks. As more and more merchants begin using the NELiX TransaX QuickBooks Module (which, as you may know, allows users to process credit card, ACH/E-check/EFT, and Remote Deposit Capture (RDC)/check conversion transactions), we've been getting many very specific requests. For example:
  • "None of my customers have a "preferred payment method set. Is there anyway I can easily go through and set all of their payment methods without having to edit each individual customer in QuickBooks?"
  • "I use the NELiX TransaX Payment Gateway, and I have 1000 customers that I have to add to the Customer Vault. Is there anyway to process them all in a batch, instead of one at a time?"
  • "I have invoices that are generated from my website, and the payment is collected on the website. Is there anyway to get that invoice and payment data easily back into QuickBooks?"
  • "I need to auto create many invoices periodically, which have complex rules on the generation of those invoices. Is there anyway to automate this?"
Well, the answer was always "You'd have to have a programmer build a custom tool for you to accomplish that goal." Well, we've come up with a solution.

We have built a tool using Microsoft Access - the NELiX TransaX QuickBooks Data Management Utility. This is how it works:

- When run, the database will attach to the currently open QuickBooks company file on the current computer.
- Customers, Payment Methods, Items, etc, will be brought into the utility.
- Users can update customers, add new customers, or add new invoices.
- Customer Records are added and updated in QuickBooks, Invoices are created, and payment records created where applicable.
- NELiX TransaX Customer Vault entries created where applicable.
- Data can be imported in a preset format using an easy import tool.
- Alternatively, Access savvy users can import or link to any data source, import data, manipulate as desired, then write that data into the tables that feed into our updater.

This tool allows easily manipulation of customer data, and easy automation of invoice creation. And, best of all, it's free to any customer of NELiX TransaX!

More about the NELiX TransaX QuickBooks technology
More about the NELiX TransaX iPhone app - iTransaX

Comments

Popular posts from this blog

VB.NET WinForms and payment processing

VB6 / Visual Basic 6 - credit card and ACH procecessing