Create an accounting table for the service station in Google Sheets
100 USD There is a SERVICE STATION.
1) It is necessary to set up warehouse accounting. Incoming goods and outgoing goods.
When new goods arrive, I want to scan them using applications like Scan to Sheets. Scan the barcode of the product, and it will automatically be added to the warehouse balance. I also scan when goods leave the warehouse.
2) Repair work is being carried out. After the repair work, an invoice is issued. I want to be able to select which repair works were done in the table, pulling them from a separate sheet (price list), and also have the ability to include goods from the warehouse that were used.
3) A separate sheet where we would enter client data. And it should also have a user-friendly interface, especially if the client has visited before.
4) Later, create a button that will automatically generate an invoice in a PDF file from Excel. (Create a separate template in Google Docs and link it with Google Sheets).
I will attach an example of the table I tried to make; perhaps the technical task is not very clear, but it was written after a lot of wasted time trying to do it myself).
Applications 2
-
4 days134 USD
272 4 days134 USD
Good afternoon!
I can set up a convenient accounting system for your service station in Google Sheets with automation of all processes:
inventory management with incoming and outgoing goods through barcode scanning (integration with Scan to Sheets app);
generation of invoices with selection of services from the price list and automatic retrieval of used goods from inventory;
a separate client database with quick search and history of inquiries;
… a button for automatic PDF invoice generation based on a Google Docs template directly from the spreadsheet.
I have extensive experience in automating and integrating Google Sheets for business tasks. I implement everything quickly and clearly, and I will help with instructions. Ready to discuss details and start working!
-
1 day100 USD
157 1 day100 USD
Good day, I am already developing a similar system for relatives in the store, so I can fulfill your order within a few hours and add that the PDF with the repair report will be sent to the client's email along with the completed work, materials, and the total cost (receipt). This will be a bonus for choosing me for cooperation.
-
1 day134 USD
4464 102 0 1 day134 USD
Good afternoon. I will be happy to help. I will do everything quickly and efficiently!
-
30 days601 USD
3638 7 0 30 days601 USD
Good afternoon! I am ready to create a custom CRM system for you. This will give you much more stability, functionality, and convenience. The check, of course, will be different, but that is the appropriate level. There will be users with different roles, you can create accounts for clients, keep track of cars and their history, send mailings and notifications to clients, and much more
-
5 days111 USD
1539 35 3 5 days111 USD
Good afternoon. There is a ready-made reworked BAS Accounting for Service Stations. It has been in use for 5 years. You can install it and start working. You need to decide whether to install it locally on a computer or on a server. I will send the invoice. The system already has a service agreement with the client and a printed act of completed work, including spare parts and standard hours. I can provide a demonstration.
Current freelance projects in the category Enterprise Resource Planning (ERP)
AI advertising automation - FACEBOOK ADS
150 USD
Hello everyone! We are looking for specialists who have effectively automated the management / launch and analytics of Facebook advertising through AI Claude / GPT / GEMINI. We need to quickly set up automation / launch / exports / analytics. Please share your… AI & Machine Learning, Enterprise Resource Planning (ERP) ∙ 9 hours 49 minutes back ∙ 13 proposals |
WABA setup with integration into SendPulse
Previously, the WhatsApp business account was connected through a Polish FOP, and the system was functioning correctly. Currently, the Polish FOP is unavailable, so reconnection and setup of WABA through a Ukrainian FOP is required. The current account is deactivated, and… Enterprise Resource Planning (ERP), Client Management & CRM ∙ 1 day 17 hours back ∙ 8 proposals |
Integration of 1C with KeyCRM and automation of NovaPay registersIt is necessary to implement a comprehensive solution for automating data exchange between the KeyCRM system and the 1C:Accounting program for Ukraine (version 1.2.6.5). 1. Automatic loading of orders from KeyCRM (API) The trigger for loading: The processing must connect to the… Enterprise Resource Planning (ERP) ∙ 2 days 2 hours back ∙ 14 proposals |
Implement the processing of mass billing distribution to clients in messengers (Viber and Telegram) BASTechnical task In the CONTRACT, on the subscription tab (this is a revised tab through an extension), add a phone number that will need to be filled in the future for sending invoices to the client: Implement the ability to send invoices to clients in bulk, generated for a… Enterprise Resource Planning (ERP) ∙ 3 days 19 hours back ∙ 11 proposals |
Processing Bank client for PrivatBank and Baf Small BusinessGood afternoon Need processing of the Bank client for PrivatBank and Baf Small Business, import the file export xlxs into the Small Business configuration Enterprise Resource Planning (ERP) ∙ 5 days 21 hours back ∙ 11 proposals |
Odessa