Bachelor Tech
  • Home
  • Tutorials
  • Portfolio
  • About Jan
  • Contact Jan

Part 1 – What do we want to do + Required technology (bank feed)

by Jan Bachelor April 16, 2022

Last Updated on April 16, 2022 by Jan Bachelor

Do you have a small to medium sized business with some employees having company credit cards? Is it a nightmare for your Finance team to retrieve receipts for expenses, allocated them to projects and get them approved, yet you do not want to pay for high budget solutions like Concur or Oracle NetSuite? Then follow this tutorial – all you need is a little server (VM) with WordPress, a few affordable licenses, and a cheap (< $30 monthly) Integromat subscription!

In this tutorial:

The approach – How will we get there?

  • Get your bank to push a .CSV file as a daily feed of expenses for all credit cards for your company. In this tutorial, we will assume that the feed will be available via FTPS (other options such as email attachments with a specific subject are also possible).
  • Decide what data you want from this feed and for your accounting – e.g. charge date, charge amount, transaction description, etc.
  • Design a parent and child form in Gravity that we will feed the data into. For example, will each cost need to be allocated to a company subsidiary (branch) and/or project and/or expense type?
  • Consider a workflow once the data comes into the form – manager approval, finance review step, etc. Can you get your HR team to compile and keep up to date a spreadsheet with the employees and their managers?

Technology that will be required:

  • A WordPress site with Gravity Forms, Gravity Flow, Outgoing and Incoming webhook add-ons
  • Gravity API to be enabled on your WordPress site.
  • Integromat (Make.com) subscription – free one will do for starters
  • Google Spreadsheet (for storing direct manager details – this could be hard-coded in Gravity if preferred).
Part 2 - Design the child form for expenses (Gravity Forms)
Back to: Concur Alternative: Import Employees’ Credit Card Expenses to WordPress via an automated bank feed – Gravity Form/Flow & Make.com (Integromat)

1 comment

Martin July 3, 2022 - 1:15 pm

This tutorial deserves more credit, I’ve not seen such a detailed write-up on how to turn a WP site into a fully fledged automated expense bank feed where employees have to provide justification for every expense – pretty good, keep it up!

Reply

Leave a Comment Cancel Reply

Save my name, email, and website in this browser for the next time I comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

0 comment 0 FacebookWhatsappEmail

Concur Alternative: Import Employees’ Credit Card Expenses to WordPress via an automated bank feed – Gravity Form/Flow & Make.com (Integromat)

  • Next
Collapse
Expand
  • Part 1 - What do we want to do + Required technology (bank feed)
  • Part 2 - Design the child form for expenses (Gravity Forms)
  • Part 3 - Design the parent form for individual expenses (Gravity Forms)
  • Part 4a - Integromat Workflow - Fetch data from FTPS and filter it out
  • Part 4b - Integromat Workflow - Submit the parent gravity form from Integromat
  • Part 4c - Integromat Workflow - Create child forms in Gravity from Integromat

Search for articles

Other Tips

  • How to mount an NFS share (such as from FreeNAS) from an Android box
  • How to download a Windows 10 ISO on a Windows device – easy work-around

Other Tutorials

  • Build Your Own Router - Proxmox, OPNSense, OpenVPN server and a VPN client all in one!
    12 Steps
  • Dynamically Populate Gravity Forms from Google Sheets (GSheets APIv4)
    6 Steps

Recent Comments

  • Jan Bachelor on Use Integromat to get computer IDs from user email in JamF ProHi Robert, the static groups were created in the p…
  • Robert Petitto on Use Integromat to get computer IDs from user email in JamF ProCan you share how you'd use Make (integromat) to a…
  • Martin on Part 1 – What do we want to do + Required technology (bank feed)This tutorial deserves more credit, I've not seen…
  • Jan Bachelor on WAN / LAN Set Up (Before OPNSense Installation)Hi Ed, I have not tested it with PCI passthrough y…
  • Ed on OPNSense VM Set UpIn step 4 firewall you turned off firewall, should…

Tags

chrome iso windows

Categories

  • Android
  • FreeNAS
  • Linux
  • Windows

Recent Posts

  • How to mount an NFS share (such as from FreeNAS) from an Android box

  • How to download a Windows 10 ISO on a Windows device – easy work-around

Facebook Twitter Instagram Pinterest Linkedin Youtube

@2019 - All Right Reserved. Designed and Developed by PenciDesign

Bachelor Tech
  • Home
  • Tutorials
  • Portfolio
  • About Jan
  • Contact Jan