Breadcrumbs

Setting up budgets in an Accounts ledger to be reported on in Reporter

This support note applies to:

  • AE Reporter (AU)

Article ID: 30364

In MYOB Accountants Enterprise Reporter (AE Reporter) data entered in Accounts for the year and year to date for any ledger year in Accounts will be picked up in AE Reporter.

AE Reporter will only pick up a budget figure for the budget year to date or budget period for the current ledger year in Accounts.

AE Reporter will not pick up any data entered directly into Comparatives apart from budget year to date or budget period for the current ledger year in Accounts.

To create a budget figure for the current ledger year in Accounts you will need to create a new Comparative ID through Enter > Comparatives using the correct naming format, then change this to be type B or M via Ledger > Comparatives.

For Reporter to pick up the budget year to date figure for the current ledger year in Accounts where you have a periodic ledger, you will need to set the ledger year selection to be on the final period. For Reporter to pick up the budget period figure from the current ledger year in Accounts where you have a periodic ledger you will need to set the ledger year selection to be on the relevant period.

To create a budget figure for the current ledger year in Accounts

  1. From within the Accounts ledger go to the menu option Enter then select Comparatives. The Comparative Entry screen appears.

  2. Enter the new COMPARATIVE ID using the correct naming format then enter an account for CODE and a DEBIT or CREDIT amount. On this screen you can press [Tab] or [Shift+Tab] to move between the fields.

  3. Press [F4] to save and close the Comparative Entry screen. The remaining accounts and corresponding amounts can be entered later.

    Format

    Example

    Budget Year to Date

    YYYY

    Budget year to date 2010 will have the comparative ID 2010.

    Budget Period

    YYYY-Mnn

    (where YYYY is the year, -M is keyed in and nn is the period number)

    Budget period for a quarterly ledger for the 2010 ledger year for the third period will have the comparative ID 2010-M03.

  4. An entry is added to for the new comparative ID.

  5. Go to the menu option Ledger then select Comparatives…. The Comparative Maintenance screen appears.

  6. In the Select Comparative field enter the COMPARATIVE ID created in step 2 then press Enter. You are now prompted to enter one of A- Amend, D- Delete or Enter new name.

  7. At the A- Amend, D- Delete or Enter new name prompt enter A then press Enter. For the COMPARATIVE ID created in step 2 the prompt Type <YYYY> appears.

  8. Enter B or M depending on whether the comparative is for budget year to date or budget period then press Enter. For budget year to date enter B and for budget period enter M. The message Comparative YYYY updated or Comparative YYYY-Mnn updated appears.

  9. Press [F4] to save and close the Comparative Maintenance screen. You are returned to the Accounts ledger screen.

  10. Enter the remaining accounts and corresponding amounts by going to the menu option Enter then select Comparatives. The Comparative Entry screen appears.

  11. Enter the COMPARATIVE ID created in step 2 and enter an account for CODE and a DEBIT or CREDIT amount. On this screen you can press [Tab] or [Shift+Tab] to move between the fields.

  12. Press Enter to allow another account to be added.

  13. Pressing [F4] to save and close the Comparative Entry screen. The remaining accounts and corresponding amounts are added to the COMPARATIVE ID created in step 2.

What Column Definition to select in Reporter to pick up the Accounts budget data

To pick up the budget data entered in Accounts, select the correct Column Definition and Ledger Year in Reporter.

Reporter will only pick up the budget year to date or budget period for the current ledger year in Accounts.

Accounts

Reporter

Comparative ID

Type

Column Definition

Ledger Year

YYYY

B

YtdBud

Final period in current Accounts ledger year only

YYYY-Mnn

N

PtdBud

Relevant period for the current Accounts ledger year only