Tracking & Invoicing Solution

Job ID: 34888375

Budget: $1,500 – $3,000 SGD

The tracking and invoicing solution will help us to digitize a big part of our book keeping and reduce human resource needed for regular track record maintenance, it will help us streamline our workflow and automate the book keeping process as a whole, standardizing all info and centrally storing them on a single collective database.

It will allow our customers to fill up a digital form instead of a physical copy by scanning a QR code, reducing queue time and hassle for the client and simplifying the data collection process, and the collected data can then be store digitally in a database, for fast and simple retrieval of records if needed. The maintenance of the database will also be simplified.

The solution will also allow us to tag the customer with our newly generated invoice for that particular transaction, allowing us to not going go completely paperless but also eliminate situations where our customer misplace the receipt and could not claim the payout when at the office.

Front-end Module
Our Front-end module will be a web form that allows customers to register and login to their account by scanning a QR code from our counter, they will be required to fill in key details such as ID number and contact details to complete their registration. Once done they will be able to start transactions. The staff at the recycling point will request for the transaction ID and key in details such as material type and weight before proceeding.

Once processed the transaction status will be updated and customer will be able to proceed to office to claim their payment using the transaction page as proof.

Back-end Module
Our back-end module comprises of a general database for our client info, their transaction history and the invoice involved. Before a transaction occur, our customer will need to scan a QR code to register or login to their account to start a transaction.

Then, we will open a new transaction for them under their account to keep track of their past and ongoing transactions. The status of their transaction will also be updated here showing, no active transaction, transaction in progress and transaction completed. Showing the previous id if there are no active transaction and showing the current id if there is an ongoing transaction.

The supervisor will be able to add and modify material pricing here, and staff will only need to input the weight of materials and the amount of payout for the transaction will be calculated automatically. The supervisor can view, modify and delete user account, staff accounts and transactions directly, in cases where there are errors in the record.

Receipt Module
Our receipt module will take info from our back-end module once a staff verifies a customer’s account info and starts a transaction. Key info such as customer’s info, material type, material weight, pricing calculations and other additional info will be recorded by the recycling point staff. The info will be stored and kept in the database as a receipt for the transaction.

Our office staff then only need to liaise the receipt number with the customers and the amount payable will be prompted, as the calculations will be done on the back-end reducing the time needing for the calculation.
Related categories: PHP MySQL Laravel React.js QR Code Making