Freelancer: girofreelancer
Compartilhar:
Denunciar Inscrição

My second entry

In my second entry I send you two images of my previous work where you can see sample for payroll or Period end statements. I don't live in Australia, so I don't know the rules to generate payslips and calculate tax, but if you can send me what you currently are using (Excel spreadsheet, forms, formulas, etc., I can evaluate all your needs and estabilish the right price for you. Feel free to speak with me so we can find togheter the best solution for you.

Inscrição nº 5 do Concurso para                                                 Write some Software
Inscrição nº5

Painel de Comentários

  • girofreelancer
    girofreelancer
    • 8 anos atrás

    I'm working hard on the ATO documentation, because there are many details to consider. There are six scales for calculate the withholding amount for payments, not only the 2 reported on the Excel spreadsheet, and for each one I have to retrieve the parameters and prepare the formulas.
    In addition there are WFT, SOP, WLA, Tax offsets and Medicare Levy that are related to the data written by the Employee on its Tax File Number Declaration, Withholding Declaration and Medicare Levy Declaration.
    I'm preparing an interface to collect the basic data and prepare the formulas, you can see a screenshot on this link https://drive.google.com/file/d/0B1U9JVUTJQtyV0pBU1hOcGRGN28/view
    When I have completed this first step we can discuss more details.

    GiRo

    • 8 anos atrás
  • MissNeela
    Proprietário do Concurso
    • 8 anos atrás

    Thank you giro. Please see what you can do. I am going to be away tomorrow so I will email you on Sunday or Monday and we will discuss details further.

    • 8 anos atrás
  • girofreelancer
    girofreelancer
    • 8 anos atrás

    Thanks, for hire me for your contest.
    I have sent you my personal contact, because I think is more easy for us to exchange informations, have you seen it ?
    I have donwloaded other documentation, because I have to understand the formulas for Weekly Family Threshold (WFT) and Shading Out Point (SOP), they are needed to estimate the withholding amounts.
    There are also Medicare Levy and Tax Offsets to understand, so the job is hard but I will do all my best to create a good software for you.
    When I have finished this software I will come in Australia to open an accountant agency with you !
    Obviously I'm joking, because I love the work I do for so many years.
    Just another thing, as I have mentioned the offered price is small, so we have to agree the right price: the price of the contest cannot be changed (in future I suggest you to open a project instead of a contest), so we must find another way, but for now let me end the study of all documents.
    Thanks again

    • 8 anos atrás
  • girofreelancer
    girofreelancer
    • 8 anos atrás

    I will try to extract myself formulas from the document from ATO, if I have doubts I ask you.
    Freelancer's chat is not so good, if you like we can use our private email.
    This is mine: giro (point) freelancer (at) gmail (point) com
    I write it separately, because Freelancer dislikes that we speak in private, so you must reconstruct it. Thanks

    • 8 anos atrás
  • MissNeela
    Proprietário do Concurso
    • 8 anos atrás

    That would be great but unfortunately I don't know much about tax and formulas. If there is something you think I might be able to help with let me know and i will do my best. How can I send you messages through the freelancer chat service? It is hard to talk about it here as it does not send notifications

    • 8 anos atrás
  • girofreelancer
    girofreelancer
    • 8 anos atrás

    Very well.
    I have found on ATO (Australian Taxation Office) website this document https://www.ato.gov.au/Rates/Schedule-1---Statement-of-formulas-for-calculating-amounts-to-be-withheld/.
    I haven't problem with math, but knowledge and experience are needed for this type of application, so I need your help.
    Recently I have developed an application of bank risk management for a financial services agency: it has been a big experience, but only by combining our knowledge we were able to create a great application (see on my portfolio) that now is resold in all our country.
    I think we can do togheter the same thing.

    • 8 anos atrás
  • MissNeela
    Proprietário do Concurso
    • 8 anos atrás

    Ok I will try to find the actual formula.

    • 8 anos atrás
  • girofreelancer
    girofreelancer
    • 8 anos atrás

    I have seen your Excel spreadsheet, but to calculate tax there are 3282 hidden rows.
    On Tax-Free Threshold the taxation is 1 for a Weekly earnings of 357
    Without Tax-Free Threshold the taxation is 1 for a Weekly earnings of 3, 4, 5, 6, 7.
    Have you a real formula ?

    • 8 anos atrás
  • girofreelancer
    girofreelancer
    • 8 anos atrás

    Sure. The application that you are seeing in the images it works exactly on Google Drive for an American customer.

    • 8 anos atrás
  • MissNeela
    Proprietário do Concurso
    • 8 anos atrás

    Yeah I think I will save it on google drive or dropbox and hopefully that works.

    • 8 anos atrás
  • girofreelancer
    girofreelancer
    • 8 anos atrás

    I'm seeing your notes on my project plan: now I understand Super (in my country is a bit different).
    Basic pay is a fixed salary released to specific type of employees (for example trade representative).
    Cloud computing is a bit expensive (see this page https://azure.microsoft.com/en-us/pricing/calculator/ for details), so the use of cloud storage, in conjunction with green application, is better and it is free.
    If you put the green application on Google Drive or Microsoft One Drive you never lose your data.

    • 8 anos atrás
  • MissNeela
    Proprietário do Concurso
    • 8 anos atrás

    Please check link http://jmp.sh/b/oDvB3zlqE7DPztkF09b9

    • 8 anos atrás
  • MissNeela
    Proprietário do Concurso
    • 8 anos atrás

    Thanks for letting me know about the green software. I meant to ask you whether we can make it cloudbased just incase my computer breaks I wouldn't want to lose all data.

    • 8 anos atrás
  • girofreelancer
    girofreelancer
    • 8 anos atrás

    A desktop application is better for you, because with a web application:
    - you must register a domain name (www.yourname.com) and pay its annual fee;
    - you must buy a web space from any provider and pay its annual fee;
    - you must buy a database for you web space and pay its annual fee;
    - you must pay to create your web site, to host your web application;
    - you must periodically control the security of you web site, because your application store user data and you must protect their privacy;
    - last but not least if you lost internet connection you can't work at all.
    Small companies (as me and you) must consider pros and cons more accurately to not waste time and money.
    I look forward to hearing from you tonight.

    • 8 anos atrás
  • girofreelancer
    girofreelancer
    • 8 anos atrás

    Don't worry for the delay.
    Just another thing, my application will be configured as Green Software, therefore it not requires installation: you just have to copy the folder containing program's file and database to any PC and work.
    For example putting the folder on USB pen drive you can carry your application with you: connect the pen drive to every PC and work !
    If you like Google Drive or Microsoft One Drive, install them locally on your PC and move the application into its shared folder: now you can work from all other PC that can access to your shared folder, even without internet connection (when available data will be automatically synchronized).

    • 8 anos atrás
  • MissNeela
    Proprietário do Concurso
    • 8 anos atrás

    Hi, Sorry to get back so late. I have been away for a couple of days. I will have a look at the plan and let you know by tonight.

    • 8 anos atrás
  • girofreelancer
    girofreelancer
    • 8 anos atrás

    Have you seen my project plan ? If you need more informations feel free to contact me.

    • 8 anos atrás
  • girofreelancer
    girofreelancer
    • 8 anos atrás

    I have prepared a project plan for you, take a look and tell me what you think about.
    In TO DO section there are also some questions to answer.
    Don't worry for the price, we will find surely an agreement, but to find the right one it is important that I know all the work to do first.
    Some absurd rules of Freelancers do not allow to send a document to the contest holder (in projects it is allowed) so I put the project plan on my Google Drive: go to https://drive.google.com/folderview?id=0B1U9JVUTJQtyaVpQTXFVU3hwZTQ&usp=sharing to see it or download.
    I look forward to hearing back from you.
    Thanks

    • 8 anos atrás
  • MissNeela
    Proprietário do Concurso
    • 8 anos atrás

    If you could message me with a price range you are happy to work with It would be much appreciated. Thanks

    • 8 anos atrás
  • MissNeela
    Proprietário do Concurso
    • 8 anos atrás

    - Add, edit(include pay rate) and remove employee
    - Generate payslip
    - I need to be able to store old payslips and pull up when I select particular dates (eg. all payslips from June to August) this is especially important for yearly income and tax summary
    - Calculate super when selected particular dates (eg. all super earned from september to december)
    - Leave calculation based on hours worked (eg, for someone working 40 hours a week they have 4 weeks annual leave and 10 days personal leave)

    • 8 anos atrás
  • MissNeela
    Proprietário do Concurso
    • 8 anos atrás

    This does look great. I have an excel table I use to calculate tax which I can send you and also an example payslip. I'm really not looking for something too complicated. These are the options I need it to have:

    • 8 anos atrás

Mostrar mais comentários Processando...