Automated Spending System - Project Launcher

Industry: Travel

Project goal: To develop a system for planning payments from the company’s accounts

What was done:

Created a set of Google Sheets for planning, approval, preparation, and analysis of payments.
Implemented an automatic system for importing scheduled payments from other systems.
Developed a mechanism for payment approval, ensuring that payments cannot proceed without authorization.
Marked payments that are ready for execution.
Enabled grouping of payments so they can be paid together while keeping their individual details.
Set up logging of all actions to track responsible individuals.
Developed an automatic return of payment completion details to the original planning systems.

Achievements:

Improved the organization and planning of payments.
Allowed personalized actions with payments, clearly assigning responsibility.
Simplified the payment process by organizing payments and automatically pulling in the required details.
Ensured data integrity in both planning and execution phases of payments.
Made financial analysis easier with prepared reports.

Reports include: