How to automate book keeping and bank transfer matching

How To
1

Hi all,

how can I automate book keeping and which tools would you use for the following process:

-There is one google drive folder per month where the latest bank statement will be downloaded (can be PDF or EXCEL)
-In the same folder there are x invoices
-Now i want to check for each line in the bank statement, is the invoice in the folder and if not, which ones are missing
-The missing ones are sent to someone who can then search it
-Every month, you only download the bank statement and then start over this process

Very excited for your ideas :slight_smile:

2

Hey there,

firstly I suggest choosing between PDF or EXCEL and sticking to one file type.

Then add an appscript that watches the folder for the master lets say PDF file to appear and calls a Make webhook when it does.

Then open the file with one of the PDF processing modules available to extract the data and search the folder for the rest of the files. Log the ones that don’t exist and send them for additional checking.