The MYOB functions are found in the Extracts menu.

From here you can :

  • Run a Trial Balance for a period
  • Extract a General Ledger postings file for import into your accounting system
  • Import your General Ledger Accounts codes from your accounting system
  • Assigning (Mapping) your account codes to SmartCentral categories

Importing account codes and mapping is only required when the system is set up or if you change your account codes.

Trial Balance

Run a trial balance for a period by selecting the start and end date then clicking UPDATE.

The trial balance function sumarises all accouting information for the period and is very useful overview of your centre’s financial performance even if you are not exporting data to an accounting system.

Extract

You can extract data into an accouting file in one of three formats depending on your needs.

  1. Standard Format (Download) - this is the simplest format and groups all data of the same type by date across the whole organisation
  2. Service Format (Group by Service) - this splits transactions into separate entries for each service
  3. Parent Format (Group by Parent) - this puts each parent transaction onto a separate line and is the most verbose format

If your organisation operates a single service then format 1 and 2 will produce the same result.

Accounts

During setup you ‘train’ SmartCentral which MYOB account codes to use for each SmartCenrtal internal account.

To start this process you export the list of General Ledger (GL) account codes from your accounting system and import them into SmartCentral.

Export accounts.txt file 1

Export accounts.txt file 2

![If relevant: Remove {} from the accounts.txt file](/uploads/AccountsFile1.png “Remove {} line MYOB Accounts file”

Import the accounts.txt file

Mappings

Once the accounts.txt file has been imported, train SmartCentral which GL codes to use for parent payments , government payments, miscellaneous fees , bonds etc;

  • Service drop down box: select “All”, if all services will be mapped to the same MYOB accounts.
  • Service drop down box: select the relevant service, if each service is to be mapped to different MYOB accounts.
  • In the mapping screen, select the relevant account code from each drop down box

Map MYOB GL Codes

Note: If you are operating an organisation with multiple services you may set up separate mappings per service or use the same mapping for all services.

The default organisation mapping will be used until service mapping is added.

All GL accounts to be mapped must be in the one MYOB accounts.txt file

End of Period Processing (Export)

Now that SmartCentral is fully trained, just choose your date range (for end of period processing) and click Export. The file output is ready for immediate import into MYOB all correctly coded.

Importing into MYOB

Details on how to import the SmartCentral file into MYOB can be found here. You are importing General Ledger Entries.