Project Description:
I am looking for a Google Workspace Automation Expert to streamline the credit card expense management for 2 companies (approx. 15 cards total). We currently use Google Forms for receipt uploads and manually reconcile them against bank statements. I need to automate the "busy work" and ensure no payment deadlines are missed.
Key Requirements:
Automated File Organization
Create/Optimize a Google Form for 15 cardholders across 2 domains.
Develop a Google Apps Script to automatically rename and move uploaded invoices from the Form into a structured Google Drive (organized by Company > Cardholder > Month).
PDF Password Automation:
Our Credit Card statements are password-protected. I need a solution to automatically decrypt these PDFs using a provided password lookup table so the accounts team can view them immediately.The decrypted statement to be renamed based on Credit card and month and be saved in designated folders on google drive
The Attachments in Google sheets should be renamed and uploaded in Google drive based on CC and Month
Reconciliation Dashboard (Google Sheets):
The data of the Credit card and that of google forms would be automatically matched by amount and date
and highlight missing details and email alerts to card holder , accounts
Option to re-run the matching should be available until NIL errors or mismatches are found
Deadline & Overdue Alerts:
Set up automated Email/ google task / Google calendar based on Statement generation Dates and Payment Due Dates.
Set up intermediary due date alerts for reconciliation and approval for release payment
Escalations: To seniors if a statement isn't reconciled 7 days before the due date.
Reminders to the finance team to pay based on due date along with the details of bank , account etc ( to be maintained in google sheets
Confirmation of payment from Finance to close the task
... Show more