Beginning in 2019, I began the process of automating admin and accounting functions which still continues on to this day.

To achieve this, I have had to learn various programming languages for the first time; Java, Python, Google & Batch Scripts and VBA to name a few and then try to write and experiment with my own code. Everytime when I go to write something to achieve a particular result, it’s lilke climbing a mental brick wall for me. It’s frustrating and difficult. It doesn’t come easy to me. Anything I have achieved along the way has been because of the amazing resources that are available for amatuers trying to learn code. When I get it right it’s an amazing feeling, a great sense of accomplishment.

That being said sometimes I get it wrong, sometimes mistakes are made. If you have received an unwanted email, then I sincerely apologise.

With thanks,

Mark Prosser.

0419 728 758

 

Business Functions Already Automated

  • Quarterly BAS Reporting
  • Purchase Orders
  • Job Numbers, folders and supporting documentation generation
  • All Sales Reporting Functions ( v2)
  • All Business Performance Functions
  • Supplier Reviews
  • Invoicing and Statement Generation
  • Payment Reminders
  • Business Projections for Costs and Cash on hand
  • Automated Machine Start up and Shutdown based on a Job Status
  • Automated Australia Post Tray ordering (v1)
  • Automated Australia Post pick ups (v1)
  • Database Processing and appending DPID (v1)

Future Business Functions to be Automated

  • Annual Tax Reporting
  • Refinement of Sales, Remind and Purchase Order reporting (v3)
  • Database Processing and appending DPID (v2)
  • Tray label generation from processed database and job particulars
  • Job Status reporting to a webpage for customers
  • Letter weight reporting to spreadsheet
  • Automated tray, small and large, reordering when stock is low (v2)
  • Automated Australia Post pick up based on Job Status (v2)