One of the key factors while providing accounting as a service is automation. CBP needed a way to get bills and receivables from CBP customers to CBP service providers. Vertizone was happy to help in design and implement an Email consolidation solution.
Solution & ImplementationWhen we ask customers to consider accounting service, we cannot ask them to purchase additional equipment/hardware/software. We should be providing service on they already have. When we carefully looked at what the customer already has, We found out they either had a desktop, broadband and scanner or they had a fax machine. So we gave the customers an email or a fax number where they can send their bills and receivables. Email & fax service and the server on which our software solution would run was provided by the hosting company servicing CBP. Input to the solution would be an email with bills and receivables attached to the email. These attachments could be editable documents such as word and excel or image formats such as tiff, pdf and png files. Emails we received from customers had to be stored in a DB for two reasons. (a) Future reference and (b) Further processing. Technically, it had to run on a windows platform and should use an open source DB such as MySQL or Postgre SQL. With some of our experience, thorough search and R&D, technical requirements and cost constraints, we short listed Email2DB software in the center of the solution. During our R&D we found out that it does most of the things that we wanted. Using this software, we would have access to email subject, message body, attachments, email date and time. We had to convert all of these into one image format so that we could combine all of them into one file. Through search, R&D and cost constraints, we narrowed down to PNFCC a tool that converts almost all formats to tiff format. We decided on tiff for two reasons. Its an image format and no tampering can be done. This format takes the least amount of harddisk space among all the image formats. It is a standard format and the tools needed to open tiff files comes with standard windows OS.
ConclusionCBP can now approach a customer and confidently give them an email address to try out their service before they sign up. Also, CBP can now focus on their marketing activity and not worry about technical capability. |