Configuration of the General Ledger module in Acumatica ERP

This article consists in a series of steps required to set up the General Ledger and Cash Management module in Acumatica ERP – aka MYOB Advanced in Australia and New Zealand. This article is not intended to be the main documentation for setting up the system but rather a glimpse into the look and feel of the product and hopefully get people’s interest in the product and its features.

You will learn about the tasks pictured in green in the below image:

The first part of the series will cover the configuration of the initial settings of the system: the branch, the ledger, and the General Ledger module preferences.

Enable/Disable features

Acumatica ERP supports “Multi-Branch” accounting and this feature can be enabled using in the “Enable/Disable Features” Form as per the screen-shot below. This setting is not necessary in order to activate the first Branch of the Company.

CS100000; Configuration > Common Settings > Licensing

Create a Branch

The main settings that need to be considered when creating a branch are Branch ID and Name, the Base Currency, Description and Symbol, the Country and information about Weight and Volume which will be used throughout the system. Once the settings are saved, you can view them by accessing the Company screen as shown below.

Define a Ledger

Before defining the Chart of Accounts, you must define a Ledger and the Company added to it.

GL201500; Finance > General Ledger > > Configuration > Setup

Defining the Chart of Accounts – configure segmented key for the GL accounts

Before uploading the chart of accounts, its better to check and modify if needed the GL accounts settings – the lengths of the accounts

CS202000; Configuration > Common Settings > Segmented Keys

Upload the Chart of Accounts file using the Upload functionality provided on the screen

GL202500; Finance > General Ledger > Configuration >Manage

Configure the General Ledger module

On the GL Preferences form you must set up 2 liability GL accounts.

  • YTD Net Income Account (accumulates the net income from the beginning of each FY – you cannot post directly to this account). Once transactions are posted into the system this setting becomes read-only.

  • Retained Earnings Account (accumulates the net income or loss that is retained by the company).

GL102000; Finance > General Ledger > Configuration> Setup

Setting up the Financial Year

GL101000; Finance > General Ledger > Configuration > Setup

Create the first financial year in the system and generate periods. The setting “Belongs to next year” for New Zealand when the months of the financial year are staring 1 year before. (e.g. April 2017 is part of FY2018)

Activate Financial Periods

GL201000; Finance > General Ledger > Work Area > Manage

Select the “Active” check box in the screen below, so you’ll be able to post to these periods.

Once you have finished setting up the GL module, you can start creating General Ledger transactions.