WORK ORDER -Database & dashboard

Budget
Posted: 5 years ago
Opened
Description
Work Order Database and Dashboard

This desired program will be used in 2 offices that should end up with a connection to either Excel or an upload to a Quickbooks Desktop 2019 accounts payable file. An internet or Web connection will be necessary.

Part A
Automatically number each Work Order for later lookup and additional entries.
Import data from Quickbooks Desktop Pro 2019 or from a database file:
-Enter an Apartment Property Name – code is 3 digits -ie...OR1.

-Enter a Tenant address – ie...794033 (building 7940, apartment 33) Which then spells out the complete Mailing address. OR
- start typing tenant name with a fill-in list. I have 535 apartments in 6 properties. We are currently separating the 6 properties into individual sets of books.

Enter- 1 of 200 Task Codes for the service requested: ie.- BSL, which then spells out – "Bath Sink Leak" in another space

Provide an Additional Information area to assist the technician.

A General Ledger account number is associated with each Task Code- ie... Plumbing- 3565.
Note- there are about 12 possible General Ledger numbers used for the 200 Task Codes.

This Work Order print out is then given to our service technician who returns this page to the office after completion. ( not everyone has a smart phone)

Part B
The Work Order form has space for the employee to write his Name & Time to complete the Task..
(We do not inventory parts but want a Comment Space to write a note if something is needed or suggested.)

Part C
Our manager will enter the previously created Work Order Number from a Drop Down list(?) and enter:
-Employee initials which then pops up the Employee Name (or starts typing the Employee Name and the full name pops up).
-Each employees salary is hidden in the next cell.
-Time for Completion of the Task.
The next cell calculates the time in 15 minute increments.
The next cell calculates the time x salary to show the COST of the Task.

Part D
Daily Report- View &/or Print a list of 25 employees Daily hours worked. It does not need to be sorted out by property or GL category for this report.
(This allows us to see that all time is accounted for and not worry about it 1-2 weeks later)

Part E
In preparation of the 2 week payroll calculation:

Print a report of all employee hours worked including: regular time, over time, vacation time & sick leave. These 4 numbers per each employee are manually entered into the payroll system to calculate pay checks.

Print a report for each property (6) showing the combination of all employees costs for each General Ledger category. ( Several employees perform plumbing repairs or building cleaning etc. at 1-3 properties ) This list of costs per GL category per property should hopefully be posted back to QuickBooks Accounts Payable for a check to be written to the Management Company Payroll Account, and entered as an expense on the property’s books ( ie. Wages -plumbing or wages- cleaning). If not able to post using IIF , then print out the report for manual posting.

Summary-
Quickbooks exports current tenant names and addresses to Excel or other database.
Excel or database produces Work Orders for employees to service.
Excel or database produces employee information and General Ledger costs.
We use the information for Payroll computations.
Import expense information to each properties books for the financial statement and to reimburse the management company Payroll Account.

Can you make this happen?
Skills:
QuickBooks,Microsoft Excel
Category
Source: guru.com

Add a bid

days

Similar freelance jobs

safe 
...
7 months ago
safe$7
Hi Robert P. , I noticed your profile and would like to offer you my project. We can discuss any details over chat....
safe 
"Hello, I need to create a website based on a . psd design file. Please also specify the timeframe within which you can complete this. Technical requirements: Layout (not pixel-perfect, but close to it) Responsiveness (the website should properly adapt to different screen sizes and devices) Clean code......
safe 
Project Title: Delphi Code Feature Creation Using delphi: Check to see if this already exsits, if not: create a shedulled task to start my program on PC startup with highest permissions, with no password or prompt. program is called for example: C:\Program Files (x86)\Myfolder\myprogram. exe If it already......
safe 
I want to create a program for customers and sellers to be able to use, to create a template for there artwork and be able to size them to there specific needs. And be able to download them as pdf or png files. This program will benefit the clothing industry with the industry i am in....
safe 
Hi, I am not quite sure if what I am asking is possible but within my University degree there is a calculator program which only works on the HP Prime prime calculator, I own a Casio fx-CG50 AU. I was hoping to have this program converted into a format which is compatible with my Casio calculator, all......
1 year ago
safe 
I am looking for a skilled C++ developer to help with a real-time object detection system for my project....
1 year ago
safe 
Project Title: Correct Rcpp armadillo code Overview: I am seeking a skilled developer to fix a compilation error in my Rcpp armadillo code. The code is currently throwing a compilation error, and I need it to be resolved promptly. Requirements: - Proficient in Rcpp and armadillo library - Strong understanding......
1 year ago
safe 
Project Description: - I am looking for a freelancer who can combine all the columns of 2 rows with similar values in Telerik Reporting. - The combined data needs to be displayed in a table view. - Ideal skills and experience for this job include: - Proficiency in Telerik Reporting. - Strong understanding......
1 year ago
safe$250
Bonjour Dmytro M. , j'ai remarqué votre profil et je souhaite vous proposer mon projet. Nous pouvons discuter des détails via le chat....
safe 
Hello, I am looking to develop a unity soccer game with moves like score hero 1. Map with 1-3 stars achievments 2. engine to make the goals like i want 3. smooth game play 4. IAP , shop , buy lives 5. lives to play 6. finger smoothness touch 7. the level will be added automticlly to the map 8. rewind......
1 year ago
safe 
Project Title: Bootloader For Renesas RL78 mcu Description: I am looking for a skilled developer to create a bootloader for the Renesas RL78 mcu. The ideal candidate should have experience with Renesas RL78 mcu and be familiar with the development environment. bootloader code is ready need help for run......
safe 
I am using EMA´s (50/75/100/200),two Stoch (5/5/5 and 5/3/3), RDX Indicator and the Indicator "The Arty". For Short Positions the Prive has to be under the 200 EMA (the 100EMA under 200, 75 under 100, 50 under 75, NOT crossing) and for Long Positions over the 200 EMA ( 100 over 200, 75 over 100, 50 over......
1 year ago
safe 
My project involves using an Emotional Stroop Task to measure and assess attentional bias towards emotional stimuli. To do this, I will be using the Drift Diffusion Model which is an analytical model to study the human decision making process. My study will need to include 90 participants in order to......
safe 
I am looking for a WPF Developer for a long term project....
1 year ago
safe 
I'd like to extract tables from pdf invoices files. At this stage i really only want the products that are in the tables on the invoices. The only information i would like from the invoices is supplier date (received) location received. Within thetables i require stock code, product item, the unit measurement......
1 year ago
safe 
Im creating a config using 'openbullet 1. 4', everything added successfully, due i have 3 years of using openbullet, but this request i never faced it before!...
1 year ago
safe 
This position is responsible for verifying data quality reports and queries, correcting errors and also tracking them....
1 year ago
safe 
We are currently looking for developer to contact us on developing integration/plugin for below listed platform. Please drop me message on which plugin you're able to develop. Please send similar plugin portfolio of your previous work. The plugin need to ready for uploading to marketplace . ActiveCampaign.......
3 year ago
View all