QuickBooks Data Manipulation

By -
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

Post a Comment

Popular posts from this blog

Merchant Account Cancellation Fees

By -
It is a standard practice in the industry to charge an early termination fee. This is understandable - considerable time and effort goes into underwriting and boarding a new account, time is spent on customer service, etc. An early termination fee is a way for a merchant account provider to make sure they will recoup their initial investment into a new merchant account. These fees are usually range from $200 - $500 depending on the provider. However, some entities enact extremely unethical early termination fees. For example, some merchant account providers will charge a mutliple on the earnings from the largest volume month over the past 12 months. Some providers will go so far as charge a multiple on their profit + interchange + dues and assessments! Two examples that I have encountered: 1) Big Bank - I had a merchant processing with this bank. They wanted to cancel, and were prepared to pay what they thought was a $295 early termination fee. They receive a communication from the ban...
Read more

Flexible Pricing Controls

By -
At one time we were resellers of all the top gateways. Like our agents, we would cherry pick which gateway to use based on the needs of the merchant. That was until we built our own gateway from the ground up in an effort to eliminate a fragmented portfolio. Part of our inspiration for the rebuild was flexible pricing. We have all lost prospects to unavoidable fee structures. Most of the time there is nothing an agent can do about it. Or is there? With our gateway agents can do three things other gateways usually won't allow: Sell Below Buy Rate - Sell lower than your own costs or waive fees entirely. You have the power to create and market any pricing package you want. Feature by Feature Pricing - Virtually every feature can be sold with additional fees including Setup, Monthly, or Transaction basis. Charge by Basis Points - Charge merchants using basis points instead of a flat monthly or transaction fee. Flexible Pricing Controls
Read more