WHAT YOU GIVE TO THE WORLD LAST SECOND

WYGW Attendance & Payroll system - Suitable for any company

bandara.jmn@gmail.com (wygworld) — Fri, 8 Feb 2019 03:17:00 -0800

WYGW Attendance & Payroll system - Suitable for any company

This is an Attendance Management system that helps HRM to maintain Staff salaries overtimes and leaves. With this attendance management software, keeping tabs on all employees becomes easy.

This software comes with Unlimited employees, life time use (no license renewals), user friendly and unlimited users same time, database for any kind of company.

It is useful for Garment factories, Construction companies, Schools, shops, and Privet companies with staffs more than 50.

Run the payroll by selecting the pay period, Payroll additions and monthly deductions separately

.
The task of creating a payroll for an employee or a bunch of employees is a complicated task.
But with this payroll software, this task has been made much easier.
The software has the ability to calculate the payroll on monthly basis.

but it can get daily or weekly attendance details if you pay with daily or weekly.
You can also generate a pay slip at the end of the month, and the employees can look at their salary details by themselves.

Generate reports and the downloading option is available both in PDF and Excel formats.

This attendance and payroll management software is a great way to simplify the work at a company.
These are integral with a Human Resource Management Software and are easy to use and access.

Having this software to your HRMS can be really helpful for small, big or medium companies.

User logging and if password forget can create new.

Company and Employees details can easily be set up.

Daily attendance is very easy even without a fingerprint machine.

Attendance will update the Over time and staff leave same time.

Daily attendance will generate the Overtime and staff leaves.

Attendance edit facility available..

Data can import from fingerprint machine with Excel format.

WATCH HOW THIS SYSTEM SETUP

This software automatically keeps record on the leaves and the working days of the employees with attendance update.

Fill up the profile details of an employee that includes: Basic, Job, and Account Information.
overtime allow or not: percentage. Tax with providence fund or trust fund.

Fill up payroll details such as salary information, overtime, allowance, bonus and payroll history.

Staff loan details and outstanding

Web Site

Download the demo

Cheque printing without special software or Printer with MS Excel

bandara.jmn@gmail.com (wygworld) — Mon, 25 Jul 2016 19:05:00 -0700

Print your Business or personal bank Cheques

simply using MS Excel.

Cheque Printer new version available to download..

This is a simple workbook, which will be very useful for you if you write lot of cheques manually to your suppliers daily for your business. With this method you do not need a special printer or software only you need is a computer with MS Excel and a normal printer.

Yes, now you can use your normal printer and your laptop or desktop computer to print 100s of cheques in second.

First you have to enable macros to your MS excel.

I already crate a excel workbook using some macros and VB, you can download it free. and play....

These are the only steps you have to do to set your cheques printing.

1) save attached excel file in your favorites folder.
2) open office excel program and enable macros.

When you open the file , a yellow Message Bar appears in upper under menu bar like this.

A) Click Enable Content button.

Then file will open as a trusted document.If you not enable macros in your excel program file not work properly:

How to do it manually : Macro settings are located in the Trust Center.

1. Click the File tab.

2. Click Options.

3. Click Trust Center, and then click Trust Center Settings.

4. In the Trust Center, click Macro Settings.

5. Make the selections that you want.

6. Click OK.

3) now open the save excel file.

There are three work sheets in workbook .

First worksheet for your cheque detail. (chdetails) You can add 100 of checks detials for print
second cheque printer (cheqprint) You have to set it first time for your cheque paper size
Third sheet for customers/suppliers list. (payee list)

4) now scan an one of your check leaf from your check book and insert it to 2nd sheet to format the margins.

According to size of your bank check size ,

drag and drop the details to the correct place of check picture. These details linked with checks details sheet data. when you change the chcks details this data will change.

See the green color drop lines, it can move to any place to set your check leaf.

After you drag all cheque details to correct place. Remove check scan copy.

Now you can copy & paste first cheque margin to down for any nos of checks you wants.

Now enter your payee list and save. When you need to create checks just go to checks details sheet.

select the payee name form drop down list.
enter the amount
now cheques ready to print. any way first time just print a photo copy of black cheque and see whether all the margins and places are correct. if not drag till it ok,

Thanks
If this is useful for you please share to world...

New Link for download
Direct download with Google Drive

Billing Software with Ms Office 2016

bandara.jmn@gmail.com (wygworld) — Tue, 28 Jun 2016 09:11:00 -0700

How to create a simple POS (point of sales) system for small shops groceries and service centers using MS Excel

POS SYSTEM MS EXCEL NEW VERSION AVAILABLE TO DOWNLOAD

With this method, you can manage the following facilities without special software or expensive equipment.

v Issue a sales bill using a bar code reader.

v Manage purchases

v Control inventory

v Day end and month end stock balance.

v Daily sales.

v Daily purchases.

You need little knowledge of excel macro to do this simply, otherwise, you can download

$6,000+ In 1 Week... Here's How To Get Started...

first, create excel workbook with 6 worksheets for the followings like this:

1. Bills

2. Pur

3. Purchase

4. Sales

5. Stock balance

6. Setup

Create a setup page with this headings and setup your stock items

Category : item category

Code : Create specific code for your each items. This must be unique ID no for each items and use this to create the barcodes. Exp:

According to this, take all the inventory items & create a code and update sheet with opening stock, pur.price and Seles price. You have to give the correct purchase price and sales prices because when you issue a bill, price will pick from this sheet. Opening balance will link with stock balance sheet.

You can download Bar code Generator or can do it Online.

Example for barcode I generate for sample file.

If you don’t have barcode printer just print to A4 Sheet and paste it to your Sales items.

Create Stock balance Sheet:

Create this sheet with below headings:

Copy this formula to each row and copy paste to down:

Code: =IF(setup!$B$3:$B$323<>"",setup!$B$3:$B$323,"")
Description: =IF(setup!$C$3:$C$323<>"",setup!$C$3:$C$323,"")
Opening Balance: =SUM(IF(B3=setup!$B$3:$B$1021,setup!$D$3:$D$1021))
Purchase: =SUM(IF(B3=purchase!$B$2:$B$2005,purchase!$D$2:$D$2005))
Sales: =SUM(IF(B3=sales!$H$2:$H$2551,sales!$J$2:$J$2551))
Stock: =+D3+E3-F3

Next Create a bill sheet:

Create sheet according to this format and give below formula to each row and create macro with below codes.
You can print bill with this sheet with using bar code reader or select the item code with drop down list

Line: =IF(C5="","",B4+1)
Code: Create a list box link with setup page item code and name. when you connect a bar code reader with bar code sticker details will auto pick.
Description: =I4
Qty : this column you have to enter manually according to customer purchase qty.
Price: =IF(E4="","",VLOOKUP(C4,al,5,0)*E4)

** macro for Save bill

Create a button called Save bill and copy this code: You can download this file form my file.

Sub Dayendsales()

' Dayendsales Macro

Sheets("Tsales").Select

Columns("G:G").Select

Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove

Range("E2:E255").Select

Selection.copy

Range("G2").Select

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

:=False, Transpose:=False

Sheets("sales").Select

Range("B3:D1572").Select

Application.CutCopyMode = False

Selection.ClearContents

Range("D3").Select

End Sub

Sub DayendPurchases()

' DayendPurchases Macro

Sheets("Tpurchase").Select

Columns("F:F").Select

Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove

Range("D2:D643").Select

Selection.copy

Range("F2").Select

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

:=False, Transpose:=False

Application.CutCopyMode = False

Sheets("purchase").Select

Range("C3:D625").Select

Selection.ClearContents

Range("E3").Select

End Sub

Sub SaveBill()

' SaveBill Macro

Application.Run "'shop sales control.xls'!copy"

Application.Run "'shop sales control.xls'!SaleReplace"

End Sub

Sub DayEnd()

' DayEnd Macro

End Sub

Next Create Pur sheet: according to this format.

Now create the Purchase and sales data save page with this format:

Sales data base

DOWNLOAD

After all the formula and code create you can run the system. When you save the bill, the details will save to sale database and it will update the inventory.

End of the month save the file as new name and delete old data of sale and purchase database worksheet. Before delete, copy the closing stock balances to setup page opening balances column.

Cheque Writer - NEW VERSION WITH MS ACCESS

bandara.jmn@gmail.com (wygworld) — Mon, 27 Jun 2016 04:34:00 -0700

Cheque Writer - NEW VERSION WITH MS ACCESS

Free Database

Simple no need special software if you have MS office.

Just drag and drop to the correct margin.

..

MORE DETAILS : HERE

Leave Schedules for Employers

bandara.jmn@gmail.com (wygworld) — Wed, 13 Jan 2016 01:42:00 -0800

Employee leave Schedule

Today we will give you very useful office work sheet for employee leave calculation.

This sheet already formatted and just enter the charactor related to leave.

Download and see how it easy to your office leave record..

Download

Highest Google Adsense Earners in the World 7

bandara.jmn@gmail.com (wygworld) — Fri, 1 Jan 2016 23:09:00 -0800

I want to tell you they all have some informational content published on World Wide Web. They all are earning from blog or websites by monetizing Google Adsense (one of the highest paying online network) or other advertising network. The listed sites are really inspiring for all of you, and more inspirational are the men behind these websites. We are presenting some of the huge websites that are making massive amount of money using Adesnse.

For a lot of people, blogging has become a primary source of revenue. If you are reading this, I bet you are one of the bloggers, willing to know about the highest Adsense earners. Making money has never been an easy job for them and never will be. They got succeeded in their job because of their hard work and clever mind.

1. Jack Herrick

URL: WikiHow
Earning: $2 million per month
Alexa Rank: 171
Daily Unique Visitors: 15 million
Daily Page Views: 40 million
Backlinks: 3.3 million
Registered In: 2004
About: Online how to guide web

Learn: How to Earn Money from Google Adsense

I think this will inspire you a bit. If you are also about to start a new website, make sure that you know how to make a great website with quality content and how to increase traffic. Who knows next time you may be on this list.

2. Pete Cashmore

URL: Mashable
Earning: $1.3 million per month
Alexa Rank: 738
Daily Unique Visitors: 4 million
Daily Page Views: 15 million
Backlinks: 12.5 million
Registered In: 2005
About: Technology, lifestyle, business and world

Read: 7 Creative Ideas that got People Rich in No Time.

3. Markus Frind

URL: POF
Earning: $1 million per month
Alexa Rank: 981
Daily Unique Visitors: 3 million
Daily Page Views: 20 million
Backlinks: 13 million
Registered In: 2000
About: Online dating around the world

4. Clark Benson

Website: Ranker
Earning: $600,000/ month
Alexa Rank: 1,464
Daily Unique Visitors: 4 million
Daily Page Views: 10 million
Backlinks: 266,000
Registered In: 2009
About: Opinion-based, crowdsourced rankings on just about everything.

5. Kevin Rose

URL: Digg
Earning: $150,000/month
Alexa Rank: 2,103
Daily Unique Visitors: 1 million
Daily Page Views: 2 million
Backlinks: 1.6 billion
Registered In: 2000
About: Sharing blogs and contents.

6. Michael Arrington

URL: Techcrunch
Earning: The website was sold to AOL in 2010 for $20 million
Alexa Rank: 784
Daily Unique Visitors: 5 million
Daily Page Views: 11 million
Backlinks: 8.7 million
Registered In: 2011
About: Technology news

7. Jamie Frater

Website: Listverse
Earning: $150,000/month
Alexa Rank: 6,669
Daily Unique Visitors: 450,000
Daily Page Views: 1 million
Backlinks: 105,000
Registered In: 2007
About: The top 10 list overing almost everything.

Invoice generate database Create from Excel

bandara.jmn@gmail.com (wygworld) — Mon, 6 Apr 2015 19:05:00 -0700

Create Invoice from using excel database simply .

When you issue a invoice to your customers, you will like to use easy simple format to create invoice and save the details & keep the records to your future view as a data base .

Here I create a easy simple Excel worksheets to do it,
Auto generate Invoice no.
Maintain Regular Customer List.
All invoice data will auto save in separate sheet.
Reload issued invoices and edit.

No need to install any programs. just do it with Excel.

You can download and see the sample file here. Invoice Control

invoice generate database Create form Excel

www.wygworld.com

POS SYSTEM FOR SHOPS, GROCERIES AND SERVICE CENTERS FROM EXCEL with using barcodes

bandara.jmn@gmail.com (wygworld) — Mon, 6 Apr 2015 19:03:00 -0700

How to create a simple POS (point of sales) system for small shops groceries and service centers using MS Excel

With this method you can manage following facilities without special software or expensive equipment.

v Issue a sales bill using bar code reader.

v Manage purchases

v Control inventory

v Day end and month end stock balance.

.....

First create excel workbook with 6 worksheets for followings like this:

1. Bills

2. Pur

3. Purchase

4. Sales

5. Stock balance

6. Setup

Create a setup page with this headings and setup your stock items

Category : item category

Code : Create specific code for your each items. This must be unique ID no for each items and use this to create the barcodes. Exp:

Create Bar code:

You can download Bar code Generator or can do it Online.

Example for barcode I generate for sample file.

If you don’t have barcode printer just print to A4 Sheet and paste it to your Sales items.

Create Stock balance Sheet:

Create this sheet with below headings:

Copy this formula to each row and copy paste to down:

Code: =IF(setup!$B$3:$B$323<>"",setup!$B$3:$B$323,"")
Description: =IF(setup!$C$3:$C$323<>"",setup!$C$3:$C$323,"")
Opening Balance: =SUM(IF(B3=setup!$B$3:$B$1021,setup!$D$3:$D$1021))
Purchase: =SUM(IF(B3=purchase!$B$2:$B$2005,purchase!$D$2:$D$2005))
Sales: =SUM(IF(B3=sales!$H$2:$H$2551,sales!$J$2:$J$2551))
Stock: =+D3+E3-F3

Next Create a bill sheet:

Line: =IF(C5="","",B4+1)
Code: Create a list box link with setup page item code and name. when you connect a bar code reader with bar code sticker details will auto pick.
Description: =I4
Qty : this column you have to enter manually according to customer purchase qty.
Price: =IF(E4="","",VLOOKUP(C4,al,5,0)*E4)

** macro for Save bill

Create a button called Save bill and copy this code: You can download this file form my file.

Sub Dayendsales()

' Dayendsales Macro

Sheets("Tsales").Select

Columns("G:G").Select

Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove

Range("E2:E255").Select

Selection.copy

Range("G2").Select

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

:=False, Transpose:=False

Sheets("sales").Select

Range("B3:D1572").Select

Application.CutCopyMode = False

Selection.ClearContents

Range("D3").Select

End Sub

Sub DayendPurchases()

' DayendPurchases Macro

Sheets("Tpurchase").Select

Columns("F:F").Select

Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove

Range("D2:D643").Select

Selection.copy

Range("F2").Select

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

:=False, Transpose:=False

Application.CutCopyMode = False

Sheets("purchase").Select

Range("C3:D625").Select

Selection.ClearContents

Range("E3").Select

End Sub

Sub SaveBill()

' SaveBill Macro

Application.Run "'shop sales control.xls'!copy"

Application.Run "'shop sales control.xls'!SaleReplace"

End Sub

Sub DayEnd()

' DayEnd Macro

End Sub

Next Create Pur sheet: according to this format.

Now create the Purchase and sales data save page with this format:

Sales data base

Macro code you can copy form my file.

After all the formula and code create you can run the system. When you save the bill, the details will save to sale database and it will update the inventory.

End of the month save the file as new name and delete old data of sale and purchase database worksheet. Before delete, copy the closing stock balances to setup page opening balances column.

watch this video to how system work:

Earn extra money with recycle newspaper

bandara.jmn@gmail.com (wygworld) — Fri, 2 Jan 2015 22:42:00 -0800

Now I'm going to give World how to earn extra money with newspaper.

You can earn extra money with old newspaper and magazine, making some useful items instead of Plastic.

Recycle papers like newspapers can use to make Baskets, bags and flower vase and many more items which you need to your daily use.

You can make environmental friendly items using recycle newspapers instead of plastics.

These days I'm trying to make below items using paper tubes and i found it is very interesting hobby and anybody can do it.

* Try Amazon Mom for Free *
*

How to do it:

First cut the newspaper to 4” inch wide and roll it as follows.

Color the roll tubes as your desire. You can use water colors fabric paints or lacquer for coloring.

Items I made using this method:

Flower vase:

Bags:

Design a form filling database using Microsoft access

bandara.jmn@gmail.com (wygworld) — Wed, 4 Jun 2014 07:53:00 -0700

We all need to fill a form in our day to day work, but it is little bit difficult to fill a form everyday if you are doing a business, or provide a service. If you need to fill a form with same format like bank slips, invoices, TT or PO it is very easy to create a database using MS office.

Now I will give you the step by step instructions to create a form filling database to fill a bank Telegraph transfer (TT). For this job I used HSBC TT form. This is common form given HSBC in Asian countries.

First take a scan copy of your form and identify how many field you have to fill in the form. In this form there are 21 fields to fill.

2Open the MS access program and create a database given a name.

Now create a database main table called “TT” as below.

We can give a ref No to identify our TT form. Create other all fields according to manual form.

In this form beneficiary name is common and we can create a separate database for beneficiaries. Once we create a name we not need to type again and again, because we can select it form the database. So create a table call “bank” for Beneficiary name.

Create a database form for TT.

This is the data entry form for main table TT.

6). Create database form for beneficiary details.

7). Now you can create a quarry to find a TT you entered.

8). Create a report and insert the scan copy of TT form.

you can link the scan copy of TT form and set the details you need to fill.

9) Now select the main table and link the each field to scan copy and save.

Now you are ready to print the TT form. First enter all the beneficiaries name and after that start to fill the form. When you enter the form give the ref number continuously as 1,2,3,4 act.

10). you can create database main window as below. Then it will easy to select each option easily.

After you create the database, open and click Fill TT , enter your ref no / bank/amount and city of bank , just select the beneficiary name , then address and details will auto link and print the form with laser printer.

you can download my sample file here

if you need to create a like this database i can do it with few dollars.

How to make incense sticks

bandara.jmn@gmail.com (wygworld) — Mon, 30 Sep 2013 04:45:00 -0700

You may like to know how to make incense sticks manually by hand roll.

This article i wrote to inscrutable and now think to post my blog.

Incense sticks are used by many communities in the world daily for performing worships and for special occasion.

In Asian countries use incense sticks in daily for their pujja ceremonies. So it has good demand for this business. This Industry has long history and it can be set-up with less investment.

You require only low technology for manufacturing. Basically sticks are rolled by hands. If you can invest much money you can buy machines also. There are many different types of incense sticks used for different purposes or on different festive days.

you also can make incense sticks by hand roll using following method.

step 1:

You'll Need following things to made sticks

Bamboo sticks - There are two difference sizes 7" and 10"

Wood glue - In Sri Lanka and India used wood power call "patta" , "bummi powder" or

1.Jigat power.

2.Charcoal powder - burning wood powder

Unburned Wood powder -sawdusts

Sandalwood powder

Paint

Perfumes - fragrance oils

Most used fragrance oils are (Perfumes)

Patchouli

Sandalwood

Jasmine

Rose

Mogra

step 2:

Supplying of raw materials

Supplying of raw materials also good small business you can start in small investment. The new generation always tries to earn money online without doing anything, but

my suggestion is you have to do work to earn money yourself.

So in this industry have many opportunities to earn extra money IÃ¢â?¬â?¢ll tell steps by steps how to do its.

First you need bamboo sticks to make incense sticks.

A . How to make bamboo sticks.

You need following materials to make bamboo sticks

Bamboo tree

Hand saw

Large knife

Small knife and blades

step 3: Bamboo nodes

1. Bamboo trees can find out in any countries. First you have to cross cut bamboo to 10" or 7" inchers size leaving out nodes as follows,

step 4:

split to slats

2. Using a knife the pieces are split in to slats & silver .

step 5:

Now you put sticks to sun-dried and ready to make incense sticks.

you can do this Bamboo sticks supply also as a small business.

B. Charcoal powder - burned wood powder

This is very easy make. you can collect burned wood and grind its. Coconut cell powder or bamboo burned powder are very good to use as charcoal power for sticks.

step 7: hand rall

Now you need little experience to roll sticks to bamboo sticks.

first mixed the above materials to following ratio.

Wood glue( Jigat power)+ Charcoal powder + sawdust + Sandalwood powder = 1:2:.1: .5

mixed this all together and used water to prepare glue.

how to Handrall -

Site

Songs Lyrics Database

bandara.jmn@gmail.com (wygworld) — Sun, 29 Sep 2013 00:43:00 -0700

Songs Lyrics Database
Created by me for you.
Add new Songs Lyrics Video Audios link and keep save and keep your computer.

download Zip file and save in your favorite folder. open data base and enjoy.

Songs Lyrics Database

Now, ev'ry one needs somebody.
And you know, ev'rybody needs someone.
Well, and a-yes it's true!
Ev'rybody needs a special kind of love,
And you're the only one I'm thinkin' of.
You mean the world to me.
You are my only!

Convert a numeric value into English words

bandara.jmn@gmail.com (wygworld) — Thu, 26 Sep 2013 00:16:00 -0700

Convert a numeric value into English words using this
excel worksheet.

Now you can convert numeric value to word using this excel work sheet.

Download

if you want to convert to other currency please let me know.

Calculate your personalty number with your name

bandara.jmn@gmail.com (wygworld) — Sun, 22 Sep 2013 06:01:00 -0700

Calculate your personalty number with your name.

download excel file.