I need a webpage/cms built to calculate GST & tax Quarterly via csv uploads

  • Status Closed
  • Budget $30 - $250 USD
  • Total Bids 8

Project Description

Ok i need a program that will help me keep track of my tax, income, gst and generate reports

The system must allow me to import a csv file, then code each transaction row into categories.

This will allow me to tell how much i spent at the end of the year of different expenses, how much i paid in wages, how much i made in contract income etc.

I will download the csv file from my bank, then i need to be able to upload it to the webpage/program and give each row a reference code eg: 1001 (Wages)

I need a module in the cms to add different codes "Chart of Accounts", each code will also have variables as seen below


1) Tax Free Expense = EXPENSE WITH NO GST

2) Taxable Expense = EXPENSE WITH GST ($amount divide 11) eg: -$110 / $11 = $10 GST

3) Taxable Sales = CREDIT INCLUDES 10% GST

4) Tax Free Sales = CREDIT with NO GST

Each month i need to be able to calculate the total: SALES, TOTAL GST PAYABLE

The page should have shortcuts to click on the code box and select a code for the transaction.

I have attached a screen shot of the program i currently use so you can see the rows columns, 1 row per transaction.

If i select a code for a transaction that is (2) TAXABLE EXPENSE then the GST amount will show in the "GST Amount" Column (always 10% of the total so you will need to divide the total transaction amount by 11 )

So step 1 will be to create the CMS, then create an area where i can add a reference code. The reference code will be by: Name; Code #; GST: Y/N; Expense; Sales

The end report will allow me to calculate transaction for a period eg: 01/10/2012 - 31/12/2012

The results will show a list of my codes with their 'Number' & 'Name' and the 'total' of the transactions i listed under that codem, Then show the next code and so on and so on. What we end up with is a balance sheet/Quarterly figures that show how much we made in SALES, how much we spent in EXPENSES. & how much GST we collected in out sales, & how much we paid in GST on out Expenses

You must write TAXMAN in you bid or it will be ignored. It would be advantagous if you have knowledge in Australian Taxation and BAS / GST

The CMS must be user friendly. I will provide a copy of the code #'s and their variables/category to the successful bidder

Get free quotes for a project like this
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online