First Home Owners Grant Manager


Retail Bank (Mortgages)


For the government First Home Owners Grant (FHOG) scheme, this bank required a tool to manage home builder payments. The solution needed to provide:

  • fast & accurate data entry,
  • separation of duties; those who enter payments can’t authorise them.


Data is now a central database and while users interact with data via screens displayed by an Excel Add-In
Excel serves only as an interface (via screens) to the database and as a reporting medium.
Tasks such as entering claim details and authorising payment were segregated to minimize fraud.
Daily, Weekly & Monthly management reports were generated to monitor payments.


Excel, MS Access, VBA

* To respect client confidentiality, identifiers including client logos and names have been removed from all screenshots and descriptions. Displayed names and values are fictional.


Get this FREE Portfolio of VBA Projects

Get this beautiful portfolio of Excel VBA projects for ideas and inspiration.

Over 30 pages of smart solutions using Excel, Word, Outlook, MS Access and VBA.

Click the Download button to get instant access to this project summary as a PDF you can print or share.


Save time, money & stress

Get one-on-one access with an experienced Excel consultant who's ready to solve your business critical Excel, VBA, Formula or Macro problems.

Let me take care of everything for you and take advantage of 20+ years of Excel & VBA development experience.