Reviewing Accounts Balances and Details
This job aid contains instructions related to obtaining accounts' summary information in MYOB Acumatica.
Viewing Account Summary Information
- Open the Account Summary (GL401000) form.
- In the Company/Branch box, select the company or branch for which you want to view data.
- In the Ledger box, select the ledger for the accounts you want to view.
- In the Period box, select the period for which you want to display summaries.
- To inquire about the accounts of specific class, select an Account Class.
- In the Subaccount box, do one of the following:
- Specify a subaccount.
- Specify a mask to view a group of subaccounts. To define a mask, specify the values for only some of the segments. The system will select all the different subaccounts that have the specified segment values.
- Leave this box blank to view transactions on the account detailed by all relevant subaccounts.
- Select the Show Currency Details check box if you want to view currency details.
- In the table, view the summary balance for general ledger accounts and subaccounts that meet the selection criteria you have entered.
- If needed, view more information by doing any of the following:
- To view account details, select an account and click Account Details on the table toolbar.
- To view account balances by subaccount, select an account and click Account by Subaccount on the table toolbar.
- To view account information by financial period, select an account and click Account by Period on the table toolbar.
- To view account activity for the previous period, click Go to Previous Record on the form toolbar.
- To view account activity for the next period, click Go to the Next Record on the form toolbar.
Viewing Account Details
- Open the Account Details (GL404000) form.
- In the Company/Branch box, select the company or branch for which you want to view data.
- In the Ledger box, select the ledger in which you want to view account balances.
- In the From Period box in the Summary area, select the financial period that begins the date range of the batches you want to view.
- In the To Period box, select the financial period that ends the date range of the batches you want to view.
- In the Account box, select the account for which you want to view details.
- In the Subaccount box, do one of the following:
- Specify a subaccount.
- Specify a mask to view a group of subaccounts. To define a mask, specify the values for only some of the segments. The system will select all the different subaccounts that have the specified segment values.
- Leave this box blank to view transactions on the account detailed by all relevant subaccounts.
- Use the check boxes on the right side of the Summary area to adjust the information you want to view in the list:
- To view only daily total credits and total debits, select the Show Summary check box.
- To add the batches with a Released status, select the Include Unposted check box.
- To add the batches with the On Hold and Balanced status, select the Include Unreleased check box. This option becomes available only if you select the Include Unposted check box.
- To view currency details, select the Show Currency Details check box.
- In the list in the table, view the transactions that updated the account balance during the selected financial period.
Viewing Account Balances by Period
- Open the Account by Period (GL402000) form.
- In the Company/Branch box, select the company or branch for which you want to view data.
- In the Ledger box, select the ledger of the account you want to view.
- In the Financial Year box, select the financial year for which you want to view account details.
- In the Account box, select the account whose balances you want to view over the selected financial year.
- In the Subaccount box, do one of the following:
- Specify a subaccount.
- Specify a mask to view a group of subaccounts. To define a mask, specify the values for only some of the segments. The system will select all the different subaccounts that have the specified segment values.
- Leave this box blank to view transactions on the account detailed by all relevant subaccounts.
- Select the Show Currency Details check box to view currency details.
- In the table, view the account balances calculated for the financial periods of the selected financial year.
- If needed, view more information on the account as follows:
- On the form toolbar, click Account Details to view account details.
- On the form toolbar, click Account by Subaccount to view account balances by subaccount.
- On the form toolbar, click Go to Previous Record to view account balances in the previous year.
- On the form toolbar, click Go to Next Record to view the data for the next year.
Viewing Account Balances by Subaccount
- Open the Account by Subaccount (GL403000) form.
- In the Company/Branch box, select the company or branch for which you want to view data.
- In the Ledger box, select the ledger that contains the account you want to view.
- In the Period box, select the period for which you want to view account details.
- In the Account box, select the account whose balance you want to view for the selected financial period.
- In the Subaccount box, do one of the following:
- Specify a subaccount.
- Specify a mask to view a group of subaccounts. To define a mask, specify the values for only some of the segments. The system will select all the different subaccounts that have the specified segment values.
- Leave the box blank to view transactions on the account broken down by all relevant subaccounts.
- Select the Show Currency Details check box to view currency details.
- In the table, view the account balances for the selected subaccount or group of subaccounts.
- If needed, view more information as follows:
- On the form toolbar, click Go to Previous Record to view the account balances by subaccount in the previous period.
- On the form toolbar, click Go to Next Record to view the account balances by subaccount for the next period.
- On the form toolbar, click a subaccount and click Account Details to view the account details.
Using the Trial Balance Detailed Report
- Open the Trial Balance Detailed (GL632500) form.
- On the Report Parameters tab, in the Company/Branch box, select the company or branch for which you want to view data.
- In the Ledger box, select the actual ledger whose data you want to view.
- In the Financial Period box, select the financial period for which you want to view data.
- Select the Suppress Zero Balances check box if you want to exclude accounts with zero balances from the report.
- Click Run Report. Review the company trial balance information, which is grouped by the type of general ledger accounts and detailed to each subaccount.
Opening the Trial Balance Summary Report
- Open the Trial Balance Summary (GL632000) form.
- On the Report Parameters tab, in the Company/Branch box, select the company or branch for which you want to view data.
- In the Ledger box, select the actual ledger for which you want to view trial balance information.
- In the Financial Period box, select the financial period whose data you want to view.
- Select the Suppress Zero Balances check box if you want to exclude accounts with zero balances from the report.
- Click Run Report. Review the company trial balance information, which is grouped by general ledger account.
Printing transactions for a particular account
- Ensure that you connect the printer to your computer and prepare it for printing.
- Open the Transactions for Account (GL633500) report.
- On the Report Parameters tab, perform the following steps:
- Check the Ledger box, and change it, if needed.
- Check the From Period setting, and change it, if needed.
- Check the To Period setting, and change it, if needed.
- In the Account check box, select the account for which you want to view and print transactions.
- On the form toolbar, click Run Report. The system displays the generated report.
- On the report toolbar, click Print. The browser opens the Print dialog box with printing options.
Printing transactions for a particular period
- Ensure that you connect the printer to your computer and prepare it for printing.
- Open the Transactions for Period (GL633000) report.
- On the Report Parameters tab, perform the following steps:
- Check the Ledger box, and change it, if needed.
- Check the From Period setting, and change it, if needed.
- Check the To Period setting, and change it, if needed.
- On the form toolbar, click Run Report. The system displays the generated report.
- On the report toolbar, click Print. The browser opens the Print dialog box with printing options.