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

Closed

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

VARIABLES: (note GST = GOOD & SERVICES TAX)

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

Skills: HTML5, MYOB, MySQL, PHP, Tax

See more: php code to create report, need a help to write a will, I need a program, how we can write a report, how to write good reports, how to create webpage, how to create free php, how to create a webpage, how should i write my it report, how i should write report, how can i write report, how can i write a report, how can i write a, how can i create a webpage, free services contract, csv codes, create webpage for free, contract bank, calculate and write, a contract for services, what is an accounts payable, bank codes, i need friendly write up, create a webpage, uploads

Project ID: #4254244

7 freelancers are bidding on average $126 for this job

dzmitrij

Hello, Can make this work. Regards. Dima

$80 USD in 2 days
(63 Reviews)
5.5
bistanil98

Can we discuss this in detail before start this project,for more detail please check in PM.

$220 USD in 10 days
(9 Reviews)
4.8
sourov06

***TAXMAN***I am the expert here to help you with your project.Please check my PM.

$60 USD in 2 days
(10 Reviews)
4.5
realimaginations

Ready to work. check pmb for previous works.

$75 USD in 2 days
(5 Reviews)
3.0
thilina1990

(TAXMAN) Hello sir, I very responsibly and carefully selected your job for bidding.I read all the details supplied.I understood you need to build a applications to easily manage your accounts.I can do it for you.I More

$50 USD in 15 days
(3 Reviews)
2.4
tourala

Hi! I've read your project description, and I have the required skills on HTML5, MYOB, MySQL, PHP, Tax to complete the tasks of project. If you have anything to ask you can please. I have expertise to meet your proje More

$90 USD in 4 days
(2 Reviews)
2.1
mayankjwr

Hi, We have expert developers and designers team, ready to start work for you, kindly check your PMB. Konnect software

$230 USD in 15 days
(1 Review)
1.8
teksam

I'm ready to start.

$170 USD in 5 days
(0 Reviews)
0.0