Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    Visual Basic




A Simple Payroll Accounting Program


hi,

i wanna try create a simple payroll accounting program. does anyone know exactly where can i get useful informations (tutorials) and if possible some codes? please direct me.

E.




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Accounting System (Payroll)
i need a code for payroll that browses for an excel file and prints the necessary fields in a report.. thanks

Accounting Leave In Payroll System
Hi,

I have taken up a project for a company using vb & access. This company has a typical method of accounting of leave which is as follows.
a)
The company has only 30 days previlage leave per year & no Casual or Sick leaves.

b) The Previlage leave is accrued after one year of completion of service.
c) The previlage leave thus accrued should be taken by the employee within the next one year. If the leave not taken within one year of the leave accrued the same is lapsed.

d) The company also allows the employee to take the leave in advance. ie before the leave is accrued he may be sanactioned a advance leave , preferably less than 30 days.

e) Example for the above is

Employee A joins the company on 1-9-96.
on 31-8-97 he completes one year & 30 days leave is accrued. Now A has to finish whatever leave is accrued within
31-8-98.



I am planning to use 2 access tables. One for the accrual of leave & other one for the transaction of leave.

Please help as to how to code the same in VB ASAP.

Thanking You in Anticipation of your prompt response.


Dennis.

Help With V.small + Simple Payroll Program Plz
Hi

I've been working on a very small little payroll program simply for use by inidividuals to keep track of their own hours worked and money earned. I've been doing this for a school (year 12) project and it's due date is coming up soon. I've spent a lot of time on the project trying to figure out how to add in an MDI form and flexgrids which is probably why I'm a little behind.

Though our teacher hasn't been of much help (as he doesn't know much VB), so the programming is very primitive to say the least - but that's all we've been taught

We've been told that the documentation is more important than whether the program runs or not. However, we've been told to do the documentation (such as user manuals etc) at a stage before we've even finished our programs.

So anyways, I was wondering if there was anyone so kind as to help me out with finishing the coding of my program so that I can concentrate on getting the documentation up to scratch? The remaining coding is just parts regarding saving and loading data and a few other bits which I'm stuck on. I just need it finished in the same primitive coding/form, so I'd say it would be like kindergarten work to most of you on these forums If you could help out it would be greatly appreciated.

I've attached the program below with a short readme so that you can understand what I was trying to do with certain parts etc.

Once again, thankyou so much in advance for anyone who can help me out, I've had many great experiences on these forums with such outstanding help it has been amazing.

cheers
nathan

Need Help With Payroll Program
Hey all,
I need some help with some code on how to code vba/excel so that it knows what week number it is based on the date entered and also to automatically plug in the next date 2 weeks later (bi weekly pay)

So after you type in the 'pay start date', the 'pay end date' will automatically be filled and the week number is displayed or stored somewhere for reference later.

Any help is appreciated.

Thanks !!

Time Calculation For Payroll Program
I have a problem and I am unsure where to start. I have a program that will allow workers to check out six times during the date. So by default it checks them in @ 8:00 AM. They then can check out at lets say 10:00 AM. Then the user checks out again @ 11:00 AM and then check back in @ 1:00 PM. How do I calculate the change in AM/PM. Any ideas to start?

Difference Between Web Payroll And Desktop Payroll.
    Hello friends !!


             Please let me know why should I go to make PAYROLL system in Web Application using .NET in place of Desktop Application in .NET.

            Waiting your reply!!

       Thanks in Advance!!!!!

Does Anyone Knows Visionpoint / SBT Accounting System Or Knows Any Other Accounting S
I have a project that converting Old Dos-based Accounting program written in Vision Point developement tool that is not supported anymore.
It's very large and also hard to convert since it has its own way that applys general purpose..
I found out it will be very hard to give whole functionality of the system using VB6 and Access DB.
Since I have to re-create whole Accounting system. It's too much.
So, I'm thinking if there is some tools that creating Account system like Vision Point that is based on Window system, it will be better to use the tool.
Does any one knows this kind of program or any experience with similar situation?
And what is best way to make direction? What should I do?

Any opinion will help.!!
Thank you.

Does Anyone Knows Visionpoint / SBT Accounting System Or Knows Any Other Accounting System
I have a project that converting Old Dos-based Accounting program written in Vision Point developement tool that is not supported anymore.
It's very large and also hard to convert since it has its own way that applys general purpose..
I found out it will be very hard to give whole functionality of the system using VB6 and Access DB.
Since I have to re-create whole Accounting system. It's too much.
So, I'm thinking if there is some tools that creating Account system like Vision Point that is based on Window system, it will be better to use the tool.
Does any one knows this kind of program or any experience with similar situation?
And what is best way to make direction? What should I do?

Any opinion will help.!!
Thank you.

Payroll Help
Ive been given an assignment and on it, it says i should set up a database in my assignment, this should be linked to a payroll form so the user would enter their name, hours worked, par rate and a few other fields.
How do i do this i havnt got a clue?
ive looked through books and these havnt really helped or is there another way of doing this?

Payroll System
hey. well i m quite new for all this thing (VB programming). i m working on a payroll system project. & I m not progressing well. i draw DFD and ER diagrams. but i do not know how to really start, any sugestions will help; as am working on my first project.

Payroll Problem
I am trying to write an app that reads from a sequential text file and writes updated data to a results text file.
The data I want want the prog to read is like this:

101 "Fred" "Bloggs" 100 10 305 75 20
234 "Mary" "Malone" 80 8 244 60 16
319 "Thomas" " Black" 150 12 373.50 82.50 24

I am trying to output the results like this:

Employee number
First name
Last name
Earnings to date
Tax to date
National Insurance to date
Net pay

and the calculations to be made prior to outputting data are:

Gross pay:
40 hours at standard rate
Overtime at time and a half
Tax
25% of taxable pay
National Insurance
5% of gross pay




VB Code:
Option Explicit Private Sub cmdExit_Click()'Terminate Application    EndEnd Sub Private Function GrossPay(fHoursWorked, fHourlyRate) As Currency    GrossPay = fHoursWorked * fHourlyRate    fHoursWorked = 40    If fHoursWorked > 40 Then    fHourlyRate = fHourlyRate * 1.5    End IfEnd Function Private Function Tax(fPayForWeek, fTaxAllowance) As Currency    Tax = fPayForWeek / 100 * 75    fPayForWeek = GrossPayEnd Function Private Function NatIns(fPayForWeek) As Currency    NatIns = fPayForWeek / 100 * 95End Function Private Function NetPay(fPayForWeek, fTaxForWeek, fNatInsForWeek) As Currency    NetPay = fPayForWeek - Tax - NatIns    End Function Private Sub cmdWeeklyPayroll_Click()'Declare required storageDim EmployeeData As StringDim EmployPayroll As IntegerDim NetPay As CurrencyDim fPayForWeek As CurrencyDim NatIns As Currency  'read data from fileOpen "D:EmployeeData.txt" For Input As #1Open "D:EmployeePayroll.txt" For Output As #2 'While input contains dataDo While Not EOF(1) 'Get input dataInput #1, Employee_Number, First_Name, Last_NameWeekly_tax_allowance , Hourly_rate_of_pay, Earnings_to_dateTax_to_date , National_insurance_to_date 'Write data to new fileWrite #2, Employee_Number, First_Name, Last_NameWeekly_tax_allowance , Hourly_rate_of_pay, Earnings_to_dateTax_to_date , National_insurance_to_date, Net_payLoop 'Close open filesClose'Advise user prog completepicOutput.Print "Files 1 and 2 are closed"End Sub


I just cant seem to fathom how to do this, I know it will be pretty simple once I see it working, if someone could show me how.

Thanks
Anarchist

VB And Sage Payroll
Hi
How do I connect to Sage Payroll with VB?

Payroll Calculator
My payroll calculator gives the wrong answer and i am pretty sure my code is right. It is supposed to give time and a half for hours worked over 40 but gives the wrong answer, it does give the right answer for hours under 40 though, here is the code: What's wrong?

Dim inthours As Integer
Dim intrate As Integer
Dim intgross As Integer
inthours = txthours.Text
intrate = txtrate.Text
If inthours > 40 Then
intrate = intrate * 1.5
lblgross.Caption = inthours * intrate
ElseIf inthours <= 40 Then
intrate = intrate
lblgross.Caption = inthours * intrate
End If
End Sub

Help With Payroll Application.
Ive been working on the following payroll application for about 2 days now, and I cant seem to get it to work properly, It is supposed to add time and a half to for every hour hour worked over 40 hours, and it is supposed to take off 18 percent for taxes unless the employee is exempt.

I have the Overtime pay part working, but I don't know how to implement the tax part. Can anyone help me?

Here is the code:

Code:

Option Explicit
Private CurRate As Currency
Private DblHours As Double
Private CurWages As Currency
Private CurGrossWages As Currency
Private CurOverPay As Currency
Private CurTaxes As Currency


Private Sub CmdCalculate_Click()
CurRate = TxtRate.Text
DblHours = TxtHours.Text
CurWages = CurRate * DblHours
CurGrossWages = CurWages
CurOverPay = (DblHours - 40) * (TxtRate.Text * 1.5) + (40 * CurRate)


If OptNo.Value = True Then
Cur
End If


If TxtHours.Text > 40 Then
LblGrossAnswer.Caption = CurOverPay
Else
LblGrossAnswer.Caption = CurGrossWages
End If


End Sub

Private Sub CmdDone_Click()
End
End Sub

Payroll Prototype
Hi, all,

I try to serve a market niche by taking on non-core small/medium projects for small/medium organisations as all core systems have already flooded the market.

But at several meetings with prospective clients one issue keeps coming up - a need for custom payroll software.

I reckon the last time I tackled any payroll task was in 1989 during my basic programming class! It's all out of my head now, and even then it was a pretty basic school thing.

Is there anywhere I can get to look at what the best practice suggests for a modern heavy-duty payroll (or even better, HR) system?

Am not seeking code, just an overview, outline and basic design.

Any help willbe greatly appreciated.

Regards.

GoodGuy
Experience is a bad teacher for its exams precede its lessons.

MDI Or SDI: Which Is Better For A Payroll System?
gud evening VBCITY!

Im having a dillema on choosing which is better to implement for a development and design of a payroll system, is it through the use of MDI or SDI form?

if through the MDI form, i would like to know if there available controls for better navigation (e.g., like that of MS outlook bar or maybe the windows task pane) that I can use? If there are no available out there for free, can I know of a tutorial on how to create one.

Thanks and GOD BLESS!



---==+ Fear is what keeps us from doing things we know we can't... but we can. +==--- - zhylax

Making Payroll System In VB6
guys i need help...

i need to make a payroll system using vb6.. and i need some help with it..

i hope you guys could make a sample for me...

the system would also have a feature that the employees would be able to inquire about their salary...

i also need to use data base... but i dont know how

im expecting for a help from you guys... thank you so much..


i would gladly appreciate your help... god bless

Access Vba For Payroll Project
Please help. I have attached my code. When I reach the end of a recordset and am about to add a new reocrd. I get an exception error that boots me out of access all together.
please help. This project is laready past deadline and i have to finish it bfore the middle of March.
thanks.
Anne Johnson


'Final Paryoll Docuemtnation
'This is the labor file update subform that is giving me problems.
option Compare Database
option Explicit


'This is a test to see if i can calculate without causing an illegal page fault.

private Sub Elaptime_KeyPress(KeyAscii as Integer)
MsgBox ("Calculating Elaptime.")
me.Elaptime = me.Endtime - me.Begtime

End Sub

private Sub Form_AfterUpdate()
on error GoTo Form_AfterUpdate_Err
DoCmd.GoToRecord , "", acNewRec
Form_AfterUpdate_Exit:
Exit Sub
Form_AfterUpdate_Err:
MsgBox error$
resume Form_AfterUpdate_Exit
End Sub


private Sub Form_Open(Cancel as Integer)
on error GoTo Form_Open_Err
DoCmd.GoToRecord , "", acNewRec
Form_Open_Exit:
Exit Sub
Form_Open_Err:
MsgBox error$
resume Form_Open_Exit
End Sub

private Sub Date_KeyPress(KeyAscii as Integer)
[Employee Labor Update]![date].OldValue
End Sub

'this is to see if anything has changed.


private Sub Form_Timer()
Dim fDirty as Boolean
fDirty = me.Dirty
With me!Elaptime
If Not (fDirty Eqv .Visible) then .Visible = fDirty
End With

End Sub

'private Sub Over20_Change()
'This is to see if the employee is working over 20

'MsgBox ("Here")

'DateAdd(1, 7, me.date) = me.TotalHours
''Dim weeklyhours as Integer

''weeklyhours = DSum("TotalHours", "Elaptime", me.Endtime - me.Begtime)
'If (me.Elaptime > 20) then
' DoCmd.Beep
' MsgBox ("This Employee is working Over 20.")
' me.Over20 = me.tbSumHours - 20
'End If
'End Sub

private Sub Over20_KeyPress(KeyAscii as Integer)
MsgBox ("Here")

DateAdd(1, 7, me.date) = me.Totalhours
''Dim weeklyhours as Integer

''weeklyhours = DSum("TotalHours", "Elaptime", me.Endtime - me.Begtime)
If (me.Elaptime > 20) then
DoCmd.Beep
MsgBox ("This Employee is working Over 20.")
me.Over20 = me.tbSumHours - 20
End If

End Sub

'private Sub Overtime_Change()
'This is a test to see if the employee has worked over 40 hours in a single week.

'MsgBox ("Here")
'If (me.Elaptime > 40) then
' DoCmd.Beep
' MsgBox ("This Employee has worked Overtime.")
' me.Overtime = me.tbSumHours - 40
'End If
'End Sub

private Sub Overtime_KeyPress(KeyAscii as Integer)
MsgBox ("Here")
If (me.Elaptime > 40) then
DoCmd.Beep
MsgBox ("This Employee has worked Overtime.")
me.Overtime = me.tbSumHours - 40
End If

End Sub

private Sub tbSumHours_KeyPress(KeyAscii as Integer)
MsgBox ("I'm Here.....")
Sum (me.Elaptime)

End Sub

private Sub TotalHours_AfterUpdate()
MsgBox ("TotalHours are being calculated.")
Sum (me.Elaptime)
End Sub

Need Sample Payroll Software
Looking for Payroll or Timesheet samples of source code in Visual Basic or Access.

Anybody Is Using Ceridian Insync Payroll System?
In my company, people are using Ceridian Insync payroll system to handle payroll stuff.

The system seems be developed by using Visual Basic.

My mission is to convert the employee's Time Attendance information to *.imp file so Insync application can import it directly rather than manually enter those data.

Anyone who is using the system can tell me what kind of format the *.imp file is using?

Help On Payperiod Setting For Payroll Project
I need a help on a code that will whenever an employee is added it will have the same paydate as the others.

Like I have 4 employees now and I add another employee I want that employee to have the same payperiod as the others.

Another thing is I have another form which sets/creates another payperiod – the beginning date, the ending date and the paydate. So that if I create another payperiod (without deleting the info from the old payperiod). So how do I again do
These;

1.    create another payperiod without deleting the old payperiod
2.    makes it work that when a new payperiod is set, all the employee listed on the old payperiod will now have the new payperiod.

Please help out. Any codes, tips, suggestions or links that you can give will be much appreciated. I really need help on this. Tnx so much.

Btw, I have 3 tables (ms access).

Employee
-empnum
-lastname
-firstname
-basicpay
-paydate

Payroll-empnum
-dnum
-ded1
-ded2
-grosspay
-totalded
-netpay
-begindate
-enddate
-paydate

Pay
-paynum
-begindate
-enddate
-paydate

Accounting VB Pkg
Would like to include in my order entry program an accounting package like Peachtree Complete or similar package or a VB accounting package. Can some one give me direction. Would like to have to operation act seamless with my vb program.??? Perhaps there are some good packages already available that can be easily used with VB. Any guidance helpful

Payroll Application Using Finger Reader Device
I need to develop an application. Worker will enter into the office and the will put their finger on a device durin entering and going out . JUST to find out the time they enter in and go out. With that I will calculate their wage.

CAN YOU help me ?
What are devices and ways there?

PLEASE HELP.

Accounting Question
Hi!

I know that this is not probbably the right place to ask but still...
I made a test App for the convenient store (PointOfSale like App). It works just fine, but when I showed it to a potential customer, he asked me what is going on when a price for a single item is being changed in the middle of the month. This one has stumbed me (never thught of it!) since. I've been reading a book about accounting since then but it just doesn't make any sence to me. So my Q is:
What actions (And how) should I take in this case?
If the incomming price is shanged and there are still some items on stock left; If the commition percent is being rased;

Any ideas?

Please help!

Accounting Software
Is that any accounting software/ documentation that is free download from the web? I just want to know what module should i include?

Accounting Interface
any one have acounting interface or know a link from where I can get the idea of inter face ,Specially Vouchers.
Thanks in Advance

Accounting Software
hi to all
I am working on accounting software and keen about its back end if any one know any link or have accounting software in vb kindly help me.
thanks

Simply Accounting SDK & VB
Hi Everyone,

This is my first post and I'm taking an extremely huge shot in the dark here.

Has anyone ever worked with the Simply Accounting PRO SDK. It was written by ACCPAC International.

I you have worked with it before, i would appreciate it greatly if you could get in touch with me.

Thanks in advance...

-Pieter

Accounting Templates
We are a small MS systems house in North West England looking for a partner who will provide us with accounting software templates in VB/VBA source code format for MS SQL server which we can develop and resell on to our diverse user base. Must be multi company, multi currency, EU complant, and preferably have been audited/independently tested.

I was wondering if anyone had any reccomendations?

Appologies if this post is inappropriate.

Thanks

Brian Mahoney

Accounting Report! Help!
This is a question about selecting the right tool for the job.

we are developing an accounting system and we are now creating the reports.

right now we are looking at a very difficult report called the balance report (is that the name of the report in english???) anyway in that report every column is a different query to the database, so they tell me.

right now we are using impromptu, cause we think that the data report designer is not good enough...

right now we are facing problems, and im trying to look for an advise from somebody who dealed with this problem before.

is crystal a good choice???

has anyone created a report like that??? what did you use as reporting tool???

thanx

Accounting Functions
hi all - does VB include any accounting functions? Like
Net Present Value, et cetera? And if so, where can I go to
get a look at them?

Vb6 And Simply Accounting
Ok so my teacher has just given us an assignment to take data from a text file through vb6(or vb in MS Access) and export it to simply accounting. The user must be able to choose any text file containing data and any simply accounting file and we are to program it so that no errors pop up and that the code is ready for anything. One problem is this teacher has taught us little and we are left to come up with the answer to do all this by our own. Unfortunately I don’t know where to start. Can someone please help and just get me started? Much thanks for helping.

Help On Accounting Package
I would like to develop an accounting package with two modules general
ledger and receivables. Would anyone help with code or ideas or a site where
I may get code or any kind of help.

Thank you all

Accounting Database
I'm about to set up an accounting database. I need some help. I don't know where to store initial credit in each account. Do anyone have an example or URL's to send me where I can learn about it.

Thanks,

Ale

Simply Accounting
Does anyone here know how hard/easy it is to extract information from Simply Accounting? I need to be able to pull company information from a client's Simply Accounting package and haven't looked at it yet.


To err is human. To really foul things up requires a computer.

Accounting System
HI,
i want to build a accounting system whichis intgrated in others system like payroll,salspurchase.automatin in vouvhers trsaction, plz advise me wht ido and if any body have sample plz forward me. how should dbdesing and formas well
thx alot

Accounting Software
Hi gurus,

Where can I get some VB 6.0 source code to develop an Complete accounting package like Tally 6.3


With Regards,
Shiv Kumar G.M.

VB For Accounting/DB Apps
Is VB well suited for accounting applications and/or database applications?

or should you use some other software that will do the job better?

This is basically for a small firm, maybe 4-7 pc's and something like oracle would not be worth the expense.

Simply Accounting
Hi All,

Just wondering, Can I call Simply accouting application from visual basic. Also I want to
store the information in MSAcces.

If there is any solution please let me know.

Ananthan

Human Resource PayRoll System Using Crystal Report
Hi,
   i am new to VB application.i need to develop HR PayRoll system using VB 6.i am sending attachment of the front end Form design for the payroll system which is required for our HR.i am using Ms Access back end.i need to generate pay slip(for a particular employee) to be reported in crystal report format where we can take the print of the pay slip.please can anyone help in this regard.I would be very greatful if one can help me in this.

Thanks and regards
Babu


 

Human Resource PayRoll System Using Crystal Report
Hi,
   i am new to VB application.i need to develop HR PayRoll system using VB 6.i am sending attachment of the front end Form design for the payroll system which is required for our HR.i am using Ms Access back end.i need to generate pay slip(for a particular employee) to be reported in crystal report format where we can take the print of the pay slip.please can anyone help in this regard.I would be very greatful if one can help me in this.

Thanks and regards
Babu

 

Storing Accounting Year
Dear Friends,

I want to store the accounting year as 2002-03 format in a field called "year" with the data type as text. But I will be using the DTPicker to get the year & add + 1. But when I do this I get the format as 2002-2003 . I want it to b e 2002-03 only

PLs help,

Thanks.
Dennis.

Call Accounting System?
is it possible to trace calls in analogue phone?? i already made a software Call Accounting System... but it could be used only AVAYA ip phone... coz AVAYA ip phone has a server where all calls registered after the calls made... or store it to .txt file... is it possible to trace calls from other phones??? what are the components/hardwares needed???

by d way using VB app... tnx n advance if you would...

Great Plains Accounting
Has anyone done any applications that connect to Great Plains? Where can I get info on doing this? I have gone to the Microsoft web site, but can't find anything. I know QuickBooks offers a free .dll that will connect to its db, just wondering if GP does the same thing.

Accounting Package Needed
Our company has written, in SQL server, an application to run our business. We have been using Quickbooks for accounting and are doing double entries. We wish a program to work with what we have done and have looked at Great Plains and ACCPAC. But both of these are more complete packages; what we want is just the accounting backend so that we don't have to write all of that programming. We want all of our business processes in our front end, which we can customize at will. Is there a product available?

MYOB Premier Accounting
Hi Guys

Does anyone know if you can run Insert SQL statements against MYOB through the ODBC Direct driver to insert data into it.  I am planning on writing a front end to suit my user’s needs but I am just doing some preliminary testing in Access (I have linked the tables through ODBC), when I run an insert SQL Statement I get the error:

ODBC – Call failed
[ATI][OpenRDA ODBC]dam_verify_query_sup(#0)

I get the same error when I try to insert data manually through the table View.  I would usually assume that it cant connect to the data source, but select statements work fine (and the table view opened fine).

If this driver does not support insert statements does anyone know of a driver that does?  Or a way to insert data from outside MYOB?

Thanks Si


Help In Designing Financial Accounting Software
hi i need some information on how to go about making a business Financial Accounting System... should I use vb 6 nad SQL Server 2000 ?

Web Interface To VB&Access POS-Accounting Application
Hi,
I have developed an application for Point of sale and accounting using VB & MS-Access. I want to add the web interface to this application so that a person sitting in other branch offices should be able to work on the same centrally located database of point of sale and accounting.
I need help to find out which will be the best secure, fastes and stable plateform. Please give a guide line on where to start from.
Thanks

Need Guidelines For Online Accounting Package.
Dear Friends,
I got offer to develop on-line inventory (with accounts) package. v have to maintain the entaire database. v'll prove user id and pwd to our customers. I have good knowledge on ASP,JAVA Script and little exp. using XML.
v r planning to use SQL Server/Oracle as database.
* shall i use activex controls to posting vouchers, purchase orders and generating invoice.
* is there any way to generate accounting reports on-line. is this good to use ASP.
* is it must to use security layers.
* is there free hosting for testing our package.
if anybody villing to guide us to develop this package can also mail me at telugu_sri@yahoo.com.

waiting your favourable reply asap

Sudha




Edited by - nsrao on 6/14/2003 2:08:06 AM

Copyright © 2005-08 www.BigResource.com, All rights reserved