Restricted use of Control Accounts in MYOB Advanced

MYOB Advanced Tips and Tricks #7

Having reconciled and balanced accounts is vital to accurate financial reporting. Posting directly to the General Ledger Control Accounts can cause imbalances between sub-ledgers and their respective balance sheet accounts. Introduced in Release 2020.3, MYOB Advanced (powered by Acumatica) now provides the ability to restrict direct postings of transactions, such as journal entries, to control accounts.

Impacts of restricting control accounts

You can set restricted control accounts against the following sub-ledgers: Accounts Payable, Accounts Receivable, Fixed Assets, Inventory, Taxes (GST), Purchase Orders (Receipts), and Sales Orders (Shipments).

Establishing a control account has two impacts:

  1. Removes the opportunity for manual data entry directly into the account and reduces error rates.
  2. Prevents using the account as a default for fields related to sub-ledgers. For example, the Sales or Expense accounts are set in the Accounts Receivable or Accounts Payable master record.

Two new columns are added to the Chart of accounts Screen to display further and customise the account restrictions.

You can select the related sub-ledger Module alongside each General Ledger account, marking it as a control account. As per the example below, we have chosen the “AR” control to align with the Accounts Receivable General Ledger Account.

control accounts myob advanced 1

The “Allow Manual Entry” check box determines if users can post entries directly to this account. Clearing the box will prevent users from creating entries to this account. 

control accounts myob advanced 2

Checking this box will allow users to post transactions, although they will still receive a warning. We recommend that you uncheck this box after having made the necessary adjustments.

control accounts myob advanced 3

We recommended enabling the use of ledger control accounts to help prevent sub-ledger imbalances.

Are you interested in other ways to optimise MYOB Advanced?

Check out our handy MYOB Advanced Tips and Tricks blogs here:

  1. Generating On-Demand Statements in MYOB Advanced
  2. The New User Interface – MYOB Advanced
  3. Row-Level Security in MYOB Advanced
  4. Generic Inquiries in MYOB Advanced
  5. Fixed Assets in MYOB Advanced
  6. Business Events in MYOB Advanced
  7. Restricted use of Control Accounts in MYOB Advanced
  8. Corporate Cards in MYOB Advanced
  9. Matrix Items in MYOB Advanced
  10. Restricted Visibility of Customer and Supplier Records
  11. Important features of reporting dashboards
  12. The Global Search Function in MYOB Advanced
  13. Learn to Streamline your Intercompany Sales
  14. Simplify Your Cross-Company Sales
  15. Adding one-off public holidays to MYOB Advanced Payroll
  16. Deferral Schedules in MYOB Advanced
  17. Keyboard shortcuts to improve efficiency in MYOB Advanced

We hope these tips and tricks were helpful to you! If you have any questions about Control Accounts in MYOB Advanced, our friendly team is here to help. Call us on 1300 857 464 (AU) or 0800 436 774 (NZ), or send us an email.

Alternatively, for a comprehensive overview of all of our best MYOB Advanced ‘hacks’ in one place, you can download our PDF from the panel on the right – The Ultimate Compilations of Tips and Tricks!

Accolades
MYOB Diamond Partner
MYOB ANZ Partner of the Year 2023 Badge
MYOB Consultant of the Year 2023 Badge
Velixo Award 2024
Velixo Award 2023
Consultant of the Year Award
ES-HIGH-ACHIEVER-AWARDS-2021-EX-BUS-DEV-AUS
ES-PARTNER-AWARDS-2021-RGB-Exc-Bus-Dev-Exo-AU_reversed
PARTNER-AWARD-2020-EXBUS-EXO-AU
MYOB-WARD-EXCEL-BUS-DEV-EXO-2019-AU
Velixo Award 2019
AwardPartner2018-2x
Business awards logo
AwardPartner2016-2x
Excellence in Business Development 2015 AU
MYOB EXO Award 2015
AwardPartner2013-2x
AwardSolutions2012-2x
Telstra Awards 2012