Click here to Skip to main content
Click here to Skip to main content

Mobile Payroll

, 16 Aug 2013
Rate this:
Please Sign up or sign in to vote.
Mexican payroll explained to American, Canadian and other foreign companies that have interests in Mexico

Please note

This article is an entry in our AppInnovation Contest. Articles in this sub-section are not required to be full articles so care should be taken when voting.

Introduction

This article describes Windows 8 application entry in Intel® App Innovation Contest 2013.

Contest Data

  • Target Platform: Windows 8 (for contest purposes), Android, iOS, BlackBerry 10 (for a wider audience), as well as Windows 7 for audiences already established with this platform.
  • Category: Finance

Overview of the Application

The idea is to create a software that executes the complete payroll process dealing with Mexican labor laws. This app would be useful for American, Canadian and other foreign companies that have services offshored their interests in Mexican soil. By providing the whole context of the process, they can better manage the money they spend in these interests, as well as save money and have information in their hands when it comes to know how their budget is for payroll being handled there.

Intended Audience

The proposed financial application is intended primarily for use by companies conducting operations in Mexico. It could also be used by private accounting firms/CPA, research institutions or Mexican governmental agencies. Planned features matrix and most-common use cases can be found in the following tables:

Features Matrix

Edition

Features

Note

Single

Mexican employees can access their detailed information and the legal base for it from their desktop computers, as well as online (it may be through the web, tablet or via smartphone).

Free

Enterprise

Will have integration of data generated from this solution to the existing financial management applications of the companies and include forecasting and budget allocation for lines of business related to payroll. Information will be produced by the system handling all payroll operations.

Commercial

Potential Users

User

Edition

Usage

Employee

Single

Limited to employees of the companies who use the app, so they can learn how their payroll is calculated.

CPA, CFO, CEO

Enterprise

CPA/Accounting firms, Payroll outsourcing firms located in Mexico or conducting operations there.

Research And Education

Enterprise

Research and practical learning of the Mexican business payroll and tax system related to it.

Gov

Enterprise

Mexican governmental agencies involved in tax and labor issues.

Application Development Approach

  • From technical perspective, development approach follows the principles of separation of concerns and as many applicable design patterns as possible, including following the Microsoft standards and best practices regarding the development with the use of these technologies.

  • All front-end will be created via HTML5/CSS3/JavaScript; data content to be stored in reference (read-only) and User databases operated through corresponding data-access libraries included in .NET; the algorithmic part will be implemented as managed code compiled into .NET assembly (C# language).

  • The proposed application will use hardware features of Tablet PC (multi-touch screen, digitizer pen support, multimedia features) and UI capability of Windows 8 platform.

  • From PM perspective, this is a development project from scratch following several years of research and documentation of requirements for such solution.

Coding Languages and Frameworks: .NET, C#, HTML5, CSS3, JavaScript, SQL CE

The application's managed code base will be developed using C# language and .NET framework/HTML5/CSS3/JavaScript. SQL/T-SQL will be used for Database operations on Microsoft SQL Server Compact edition (SQL CE). Some default operations will be handled with data stored in XML files.

Application Layers

Business Intelligence Layer

Proprietary payroll, social security and tax calculation engines are being developed under C#. For online purposes, there will be a set of services implemented using WCF (SOA standard) in order to create and publish an API for interested parties.

Data Layer

Data Layer comprises the User, Operations and Reference databases.

Tax Calendar, Glossary and Calculation Module for Labor Purposes

Tax Calendar is included as default to proposed application, providing valuable reference and calculation information to business owners regarding their tax obligations and timing according to Mexican Law.

Using the Code

NOTE: This section will be continuously updated as project progressing.

Points of Interest

  • More than being interesting for software developers, the information contained in this article would be more suited for CPAs, CEOs, CFOs, HR Execs and people who handle Payroll and related operations in Mexico.

  • Opacity will be eliminated for all parties involved in the "need to know" part of the process, which will be more streamlined and will have direct impact and benefits in all parties involved in this delicate enterprise process.

History

  • 08/12/2013 - First version of the article is published
  • 08/16/2013 – More detailed high level additions regarding the project have been included
  • 08/16/2013 - Modified format in order to better view articles as full HTML

About the Author

Julio Plascencia has 12 years of experience od application development (mainly in the financial field) in Mexico and more recently, USA. Having recently provided services to financial institutions like Ally Financial, a very large financial corporation located in the USA East Coast and Mexican Outsourcing payroll service provider Payroll Tech. Julio is new to CodeProject, which he thinks is a driving and dynamic digital society for software developers. Beyond his professional duties, he plays guitar (mainly hard rock and metal music) and is devoted to his family, composed of his wife and his baby son.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

wizardXXI
Chief Technology Officer
United States United States
No Biography provided
Follow on   Twitter   Google+

Comments and Discussions

 
AdminThanks for entering the Intel AIC 2013! PinstaffKevin Priddle16-Aug-13 8:09 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web01 | 2.8.140826.1 | Last Updated 17 Aug 2013
Article Copyright 2013 by wizardXXI
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid