The situation
A nine-person building company in Tamworth runs across multiple project codes, employs a mix of subbies and direct staff, and reports GST and PAYG quarterly. Every BAS period, the bookkeeper would open MYOB AccountRight, pull the relevant reports one by one, and paste the figures into a master Excel BAS workbook. The reconciliation had to be done by hand. Cross-checking the payroll classification rows against the GST summary alone took the better part of a day.
Across a full quarter, two working days disappeared into a process that was essentially data movement: pulling numbers out of one system and putting them into another in the right format. The actual review and lodgement, the part requiring professional judgement, was a fraction of that time.
The flow we built
On the first of each BAS month, Power Automate pulls the firm's GST and transaction data from MYOB AccountRight via the API and populates the Excel BAS workbook hosted on SharePoint. The workbook is pre-structured with the firm's chart of accounts and project codes, so the populated figures go directly into the right rows without any manual mapping.
Once the workbook is populated it is version-locked in SharePoint so no accidental edits can overwrite the data. On day 21 of the BAS month, the bookkeeper receives a Teams message with a direct link to the workbook and a reminder of the lodgement deadline. From there it is a straightforward review, not a data-gathering exercise.
The platforms
MYOB AccountRight provides the source data via its REST API. Power Automate handles the scheduled pull and the SharePoint interactions. Excel on SharePoint serves as the BAS workbook, with version history maintained automatically. Teams delivers the reminder. Running on a Bot Care Essential tier, the setup is monitored for API authentication issues that can arise after MYOB platform updates, which previously would have caused the pull to fail silently.
The results
Two days of quarterly admin dropped to approximately two hours. The bookkeeper now spends that time reviewing figures and making professional judgements rather than copying data between systems. The office manager described BAS week as something that used to disrupt the whole front office; it now fits comfortably into a Wednesday afternoon.
One additional outcome: during the first automated lodgement cycle, the workbook flagged a payroll classification difference between how two roles were coded in MYOB versus how they were treated for PAYG purposes. Correcting it before lodgement avoided a potential liability of around $2,100.
What this could look like for your construction business
If BAS preparation is still a manual exercise involving reports and spreadsheets, the prep time can typically be reduced by 80 to 90 percent. We build this kind of flow for MYOB AccountRight, Xero, and QuickBooks users across the construction, trades, and property sectors.