DATA ENCODING

Sample Work # 1- AR Aging Monitoring and Excel template report

This is an Example template where I track accounts receivables, input payment details and generate AR aging report.

Sample Work # 2- Vansales Inventory Monitoring

This is where I encode the inventory loaded to a specific delivery van. It shows the  product description, code and amount per case. This will summarize the salesman's total loading, total sales and ending inventory which is weekly reconciled.

Sample Work #3 - System Payment

This is the computer system we used to generate all hanging or unpaid invoices of all the customers. This where I also post customer payments, as soon as payment posting is made, the specific invoice which is already paid will no  longer reflect when generating unpaid invoices.  

In this part of the portal, I can enroll different deductions to an invoice such as withholding  tax, other discounts and labor charges, so that it will automatically be deducted from the total invoice amount.

Sample Work# 4-  Making Pyroll

This is the file for payroll, it shows all the names of active employees. This is where I encode number of days worked of each employees, absences basic daily rate and compute total salary within a specific payroll period. 

the total pay of an employee is automatically linked to the payslip in the other sheet.

  LEAD GENERATOR