Invoices and accounting with model-driven Power Apps

I got to build this really awesome model-driven Power App for one my clients who is a Director of a micro enterprise (aka very small company) - she has been absolutely great to work with in every way, knows what she wants, needs it greatly and has had previous great experiences with Dynamics 365 and Power Apps. I really enjoy building apps which fill a genuine need, especially when no code was required in the making of this beauty!

Disclaimer: I am definitely not trying to rebuild Dynamics Finance/Operations, nor do I want to be responsible for building Project Service Automation version 99. However, when you are the Director, Shareholder, Accountant, HR and the only employee of a company Dynamics 365 would be overkill and rather pricey!

Ps. in case you hadn’t clocked yet - that really awesome Customer/Director/Shareholder/Accountant/HR/Employee is me!

‘Micro Enterprise Financials’ - what does it do?

Record Work Items

Easily manage what Services are available using reference data rather than hard coded option sets for flexibility without configuration which automatically populates the Service Rate. Track when work was done, for which customer, how long it took plus any Additional Details to record specific tasks or activities. The Total is automatically calculated using a real time workflow.

Full video can be found here

Full video can be found here

Generate Invoices

Automatically produce professional and detailed invoices in a variety of templates using word templates. Automatically create a unique and customised Invoice ID using the autonumber column type. Set invoice periods using flexible reference data. Allocate work items to specific invoices, calculate the invoice Net Total using Power Automate and Total including tax (at any rate) with calculated fields. Flexibility to business needs is crucial - Export as PDF pending!

Full video can be found here

Full video can be found here

Track Payments

Update Invoice Status along the invoice process from Draft to Paid in full. Cascade the Status down to each individual work items using a Power Automate cloud flow in the background for clean, seamless auditing.

Full video can be found here

Full video can be found here

Capture Expenses

Record and categorise Expenses details. Link Billable expenses to the relevant Invoice and Customer. Upload images of receipts for your paper free records.

Full video can be found here

Full video can be found here

Produce financial reports

As a registered company I need to be able to produce the below as a minimum:

  • Quarterly goods and services tax activity statements

  • End of year reporting

  • Expense reporting

I will be honest - I haven’t built any of this yet but I’m pretty confident I will be able to produce all the financial reports and statement I need with simple views and excel templates. To ensure I remain a compliant, organised Micro Enterprise, with a happy accountant!

What’s next?

Managing invoices is nothing new, this is app is far from ‘bleeding edge’ but for me it’s life changing. Thats what matters the most with any system or technology - the impact. Its an ‘ABC’ (Anything But Code) success story with huge potential for growth. Plus hopefully making my accounting tortures a little more bearable!

LOGOCustomised.png
Previous
Previous

Beyond Security Roles with ‘Designer Feature Protection’

Next
Next

Marketing beyond Segments and Mailing Lists