Hi, I am currently working with a customer on an intermediate solution. We are using Microsoft Excel and VBA to create a Quickbooks posting machine. The spreadsheet includes a form with buttons to initiate loading of Paypal or Authorize.net transaction files (currently, paypal is in excel format while Authorize.net is in QB iif format). We have also established three reference sheets that are used to translate the transactions to post correctly in Quickbooks. Currently, as the transactions are loaded into the spreadsheet they are split up into three category sheets. On the form there is a button for posting the categories one at a time. The best part is that this programming talks directly to Quickbooks from the spreadsheet. When you click the button to begin posting you can go to quickbooks and watch the bank balance change as transactions are posted.
... View more
